Ishan Bhatnagar
Senior Data Analyst
Harris Park
Summary
Experienced Senior Data Analyst proficient in advanced statistical tools and data visualization techniques. Uncover valuable business insights. Collaborate with cross-functional teams to deliver actionable results. Seamlessly adapt to evolving project requirements. Recognized for reliability, critical thinking, and transforming complex datasets into strategic recommendations.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
4
4
Certifications
2
2
Languages
Work History
Senior Data Analyst
Yusen Logistics
04.2024 - Current
- Designed and developed data pipelines to acquire, clean and process data.
- Created data models to support decision-making processes.
- Identified patterns and trends in large data sets and provided actionable insights.
- Created dashboards to monitor and track key performance indicators.
- Optimized supply chain operations through detailed data analysis, contributing to noticeable improvements in cost-efficiency.
- Conducted in-depth market analysis to identify opportunities for growth, contributing to marked increase in revenue.
- Developed and implemented advanced predictive models that forecasted trends, enabling strategic decision-making.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
Data Analyst
Yusen Logistics Australia
04.2021 - 03.2024
- Produced monthly reports using advanced Excel spreadsheet functions and PowerBI.
- Used statistical methods to analyze data and generate useful business reports.
- Utilized data visualization tools to effectively communicate business insights.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Deployed predictive analytics models to forecast future trends.
Data Analyst
Invigor Group Limited
08.2020 - 02.2021
- Performed detailed time series analysis on publicly available pricing and promotion data to understand industry trends, seasonality, individual retailer strategies and the impact of COVID-19 in Australia.
- Developed a volume forecasting model based on liquor Point of Sale (PoS) data, promotional calendars and competitor prices to accurately forecast sales volumes on-promotion products in Australia.
IT Analyst
HCL Technologies Ltd.
09.2016 - 02.2019
- Designed and implemented networks in collaboration with project engineers.
- Collaborated with IT team members to design and implement efficient network infrastructure.
- Communicated with vendors to resolve network outages and periods of reduced performance.
- Developed thorough documentation of network systems, aiding in future maintenance efforts.
- Analyzed data traces using protocol analyzers to identify anomalies and find solutions.
- Mitigated risk by analyzing complex computer systems to assess vulnerabilities.
Education
Master of Data Science -
02.2019 - 12.2020
Bachelor of Computer Science - undefined
07.2011 - 07.2015
Skills
Python & R programming
Business intelligence
Microsoft Power BI & Tableau
Advanced Excel
ETL processes
Advanced analytics
Data warehousing
Machine learning
Certification
Microsoft Certified Data Analyst
Timeline
Senior Data Analyst - Yusen Logistics
04.2024 - Current
Data Analyst - Yusen Logistics Australia
04.2021 - 03.2024
Data Analyst - Invigor Group Limited
08.2020 - 02.2021
Macquarie University - Master of Data Science,
02.2019 - 12.2020
IT Analyst - HCL Technologies Ltd.
09.2016 - 02.2019
VIT University - Bachelor of Computer Science,
07.2011 - 07.2015