Ishan Bhatnagar

Work History

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.

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.

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.

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.