Power BI
Chetan Patnaik
Data Analyst
Melbourne,VIC
Summary
Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Power BI, SQL, and Excel, ensuring robust data solutions and strategic recommendations.
Overview
2
2
Certificates
4
4
Languages
5
5
years of professional experience
2
2
years of post-secondary education
Work History
Data Analyst
XL Express
Melbourne, VIC
06.2024 - Current
- Design and implementing scalable data analytics solutions, managing approximately 15, 000 daily consignments across all states.
- Utilized data visualization techniques to present complex data in a comprehensible way, increasing overall team understanding and efficiency
- Developing comprehensive Power BI dashboards providing visibility into sales performance, forecasts, and key metrics.
- Spearheaded process automation initiatives using Excel Macros and VBA, reducing manual data entry by 70% and improving operational efficiency in tracking and reporting.
- Designed and implemented customized dashboards in ZOHO CRM, providing real-time visibility into supply chain KPIs and operational metrics across multiple distribution centers.
- Developed comprehensive cost modeling frameworks for client onboarding, resulting in 25% more accurate pricing strategies for logistics operations and improved profit margins.
- Creating monthly DIFOT reports for high-value customers, delivering actionable insights for business improvement.
- Conduct predictive modeling and statistical analysis, resulting in 20% increase in revenue generation opportunities.
Business Intelligence Analyst
Authentic Life Care
Melbourne, VIC
03.2024 - 06.2024
- Gathering data from various sources, including participant feedback, service delivery reports, and financial records, to identify trends and insights.
- Creating reports and dashboards to present data in a clear and actionable format for management, stakeholders, and service providers.
- Tracking key performance indicators (KPIs) and metrics to measure the success of programs and initiatives, ensuring they meet the needs of participants.
- Providing data-driven recommendations to improve service delivery, increase efficiency, and enhance participant outcomes.
- Working closely with different departments, including service coordinators, planners, and support staff, to understand their data needs and ensure BI solutions meet their requirements.
- Ensuring data accuracy and compliance with NDIS regulations and standards, and contributing to internal quality assurance processes.
- Communicating complex data insights in a simple and understandable way to stakeholders, including participants, their families, and service providers.
Operations Coordinator
Coles Online
Melbourne, VIC
05.2023 - 10.2023
- Managed data analysis for 10, 000-13, 000 weekly deliveries across all states.
- Implemented tracking systems and analytics solutions, reducing delivery discrepancies by 25%.
- Optimized delivery routes through data-driven decision making, achieving 15% reduction in transportation costs.
- Created and maintained detailed SOPs for data analysis and reporting procedures, ensuring consistency in logistics performance measurement across the organization.
- Developed reporting systems for real-time visibility and performance monitoring.
- Enhanced company's decision-making process through efficient transaction monitoring and detailed data analysis.
- Received accolades for exemplary performance in managing delivery operations & providing top-tier customer support.
Data Analyst
Amazon
HYD
09.2019 - 01.2022
- Created interactive dashboards using Amazon AWS, Quick Sight and Tableau for operational insights.
- Led data analytics initiatives for a 5-member team, implementing automated reporting systems that reduced report generation time by 40% while maintaining 100% accuracy in delivery schedules and performance metrics.
- Automated data collection and analysis processes using Excel Macros and VBA, saving 20 hours weekly in manual reporting tasks
- Performed statistical analyses including regression, forecasting, and hypothesis testing, to derive insights from data.
- Developing and validating predictive models, applying best practices in analytics to improve business processes and outcomes.
- Established and monitored KPIs through data-driven approaches.
- Extract, transform, and clean data to ensure accuracy, reliability for analysis and reporting.
Education
Master of Science in Business Analytics - Business Analytics
Kaplan Business School
Melbourne 03.2022 - 03.2024
Skills
Microsoft Azure Services
undefinedCertification
Microsoft Certified: Azure Data Fundamentals
References
Available on request
Timeline
Data Analyst
XL Express
06.2024 - Current
Business Intelligence Analyst
Authentic Life Care
03.2024 - 06.2024
Microsoft Certified: Azure Data Fundamentals
01-2024
Microsoft Certified: Power BI Data Analyst Associate
01-2024
Operations Coordinator
Coles Online
05.2023 - 10.2023
Master of Science in Business Analytics - Business Analytics
Kaplan Business School
03.2022 - 03.2024
Data Analyst
Amazon
09.2019 - 01.2022
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Affiliations
- Australian Computer Society
- Melbourne AI Enthusiasts
- Kaplan Business School Alumni
Work Preference
Work Type
Full TimeContract WorkWork Location
On-SiteRemoteHybridImportant To Me
Career advancementWork-life balanceQuote
I Don't Stop When I'm Tired, I Stop When I'm Done.
David Goggins
Software
Tableau
SQL
Adv Excel
Gen AI
Languages
Telugu
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Interests
Hiking
Photography
Reading Books
Accomplishments
- Data analytics professional skilled in Microsoft Azure and business intelligence.
- Currently a Data Analyst at XL Express, managing 10,000 daily consignments, develops Power BI dashboards, and automates processes using Excel Macros, reducing manual data entry by 70%.
- I've previously served as Operations Coordinator at Coles Online, optimizing delivery routes and reducing discrepancies by 25%.
- My experience at Amazon Logistics included leading a team to implement automated reporting systems, cutting report generation time by 40%.
- I hold a Master’s in Business Analytics and relevant Microsoft certifications.
Similar Profiles
Nathaniel NewnhamNathaniel Newnham
Depot Manager at xl expressDepot Manager at xl express
Drazen HanzekDrazen Hanzek
Returns Officer at XL ExpressReturns Officer at XL Express
Balvinder DhaliwalBalvinder Dhaliwal
Truck Driver at XL ExpressTruck Driver at XL Express