ASHWANI KUMAR

Senior Business Analyst

Carrier Airconditioning & Refrigeration Limited•  July 2023 - July 2024

Developed Power BI dashboard for Blocking Process to provide insights on pre blocking of Cu & Al volume vs demand as per changing pricing trends of metals resulting in usage of 150+ users. Developed Pricing Dashboard using IHS Markit website as source of data input to Power BI connected via API to provide insights on latest pricing trends of metals, plastics and packaging etc. resulting in subscription cost reduction of ~ 125 users. Developed Supply Chain Dashboard by coordinating with Global stakeholders, Digital team, Data Hub and Data Engineering team to design Snowflake database. Gathered KPIs and calculative logics and building the same in Power BI for all CXO’s/ CFO’s, used for monthly operations review.

Business Analyst

Ecom Express Limited•  January 2023 - June 2023

Identified fraud/poor performance sellers by designing and implementing Seller Scorecard and conceptualizing performance matrices across all product categories. Developed complex SQL queries to extract historical data from large databases and utilized Python (Pandas / Numpy) for data analytics. Developed a user-friendly Power BI Dashboard to present complex data and provide holistic view of data and trends for stakeholders. Streamlined the reconciliation claim handling process by automating tedious manual tasks, increasing productivity and efficiency.

Program Manager

Ecom Express Limited•  December 2021 - December 2022

Utilized data analysis skills to deep dive into the onboarding app journey for delivery partners, identifying areas where users were experiencing delays, and implementing changes to streamline the process, resulting in reduced onboarding time by ~7 minutes from ~22 minutes. Designed and implemented performance matrices for delivery partners, leveraging expertise in data analysis and collaborating with stakeholders to ensure alignment with business goals. Developed comprehensive Power BI dashboard to track and analyze performance metrics, enabling the identification of underperforming regions, states, and cities, resulting in increase in Business share from 40% to 72%. Conducted cost simulations to optimize budget expenses for incentive schemes during peak season by utilizing historical data to predict expected expenses.

After Sales Manager

Bajaj Auto Limited•  July 2019 - November 2021

Improved customer experience by identifying bottleneck operations and reducing service time at workstations, resulting in an NPS score > 95%. Conducted a thorough analysis of past spare parts consumption data to pinpoint slow-moving products, leading to decreased blocked funds. Streamlined manpower allocation process to deliver vehicles in promised timelines and meet customer expectations, leading the increase in service volume by 20%.