Mar 2024 – Dec 2024 · 9 mos

• Created a database from scratch, establishing a structured framework to centralize data and enable seamless visualizations for Tableau and Power BI.
• Developed ETL processes to extract data from multiple sources, transform it for consistency, and load it into the database. This ensured seamless integration of data for revenue, inventory, and client behavior dashboards, supporting efficient analysis.
• Presented detailed reports and PowerPoint presentations to stakeholders and senior management, showcasing actual revenue vs. projected and collected figures. These insights supported strategic decision-making and ensured alignment with business objectives.
• Led and mentored a team, providing guidance, support, and professional development opportunities to foster skill growth and enhance team performance.
• Designed and delivered clear, compelling, and user-friendly visualizations, dashboards, and reports to communicate actionable insights to stakeholders, ensuring alignment with business objectives.
• Skilled in leveraging tools such as Microsoft Excel, MySQL, Python, and Tableau to extract, clean, and visualize data effectively, enabling data-driven decision-making.

Jun 2023 – Mar 2024 · 9 mos · Gurugram, Haryana, India · On-site

• Successfully created and maintained multi-client dashboards tailored for vehicle tracking and utilization, providing real-time insights into fleet performance and vehicle usage patterns.
• Designed negative wallet reports for both active and churned riders, enabling operations teams to identify trends and optimize collection strategies.
• Demonstrated expertise in creating customized reports and dashboards for high-profile clients, including Amazon, Porter, and Bluedart, driving actionable insights and operational efficiency.
• Conducted fortnightly reconciliations with finance teams, showcasing strong stakeholder management by ensuring accurate and timely payments through data analysis, issue resolution, and effective communication.
• Developed comprehensive vehicle utilization reports using Tableau, leveraging advanced data visualization and analytics capabilities.
• Proficient in using tools like Microsoft Excel, SQL, and Tableau to extract, clean, and visualize data, delivering impactful insights for business decision-making.

Jul 2021 – Jun 2023 · 1 yr 11 mos · New Delhi, india

• Designed a Comprehensive Dashboard Ecosystem:
• Established a network of interconnected dashboards tailored for various departments and business functions, delivering actionable insights to drive decision-making.
• Sales Dashboard: Provided visibility into sales performance metrics, including revenue, units sold, and sales trends over time.
• Inventory Dashboard: Enabled effective inventory management by tracking inventory levels, turnover rates, and stock availability.
• Sell-Through Dashboard: Analyzed product performance to identify top-performing items and areas for improvement.
• TAT (Turnaround Time) Report: Monitored process efficiency with detailed tracking of turnaround times for services or operations.
• Customer Data Analysis and Segmentation:
• Leveraged Python and RFM (Recency, Frequency, Monetary) modeling techniques to analyze customer data, segmenting loyal customers based on purchasing behavior. Insights were used to enhance marketing strategies and improve customer retention.
• Advanced Data Visualization and Analysis:
• Developed a comprehensive sales dashboard, geographical dashboard, and performed data mining using Tableau to visualize sales performance, geographical trends, and uncover hidden patterns in the data.
• Created insightful reports that supported data-driven strategies for sales, inventory, and customer behavior.
• Implemented ETL Processes:
• Designed and executed ETL workflows to extract data from multiple sources, transform it for consistency, and load it into databases. This enabled seamless integration of data for dashboards focused on sales, inventory, and customer behavior.

Jul 2020 – Jul 2021 · 1 yr · Delhi, India

• Developed Tableau dashboards leveraging data from SAP SD and MM modules, providing stakeholders with real-time visibility into key performance indicators (KPIs) and business metrics. Enhanced reporting accuracy and speed by managing data extraction and transformation processes. Reports were Back-order reports, Inventory report's.
• Created a New Product Development and Aging Report, delivering critical insights directly to the CEO, supporting data-driven decision-making.
• Analyzed real-time sales and forecast data to generate a three-month trend analysis, comparing current year metrics with the previous year’s data to identify performance patterns.
• Streamlined reporting processes by automating SAP data extraction using Python scripts. Scheduled reports to run in the background, ensuring timely delivery of accurate data while significantly improving operational efficiency.

Sep 2019 – Jul 2020 · 10 mos

• Developed Multiple Dashboards to track Supply chain KPIs & Metrics.
• Developed Dashboards on Returns order, Order Cycle Journey, Packaging Inventory System, AOV Dashboard, Delivery services matrix Dashboard etc.
• Data Wrangling, Structuring & EDA of Data through Python.
• Design and implemented AOV Analysis, for our daily orders which helps in recognizing the buying behavior of the customers and helps us in executing discount codes.
• Taking the database reporting needs and modify them through Python that will extract data and compile it into meaningful reports.
• Created Data Visualization through Mat plot & Seaborn Python Libraries

May 2018 – Aug 2019 · 1 yr 3 mos

• Conducting Weekly 5’s Audits, Process Audits, Unaccounted Stock Audit’s, Billed Item Audit, Location Sanity Audit, Cold Supply Chain Audit and Layout Facility Audits.
• Random Quality Check and Assurance of Fruits, Vegetables and Staples based on receiving guidelines Parameter’s.
• Process Audit conducted to Examine the Fulfilment centre is Following the Protocol/Benchmarks for Process of Quality Assurance and Quality Control.
• Trained Each Employee’s for CAPA (Corrective Action & Preventive Action) for better closure for Non-Compliance’s and removal of gaps.
• Lean, 5s, CAPA & Kaizen, Set of Quality tools are adhered and controlled at Fulfilment Centre for better Lean Practices.
• Conducting Root Cause Analysis for Customer Complaints in terms of Item Missing Products/Wrong item Delivered/Expired Products/QNG (quality not good) products.
• Conducting Cold Supply Chain audit to ensure the Cold SKU’s are sent with proper usage of gel packs and the proper designated Crates.
• Compiling All reports and ensuring those reports reach on timely basis to top level Management .
• Conducting Weekly, Minutes of Meeting with the Zonal and Fulfilment centre Manager’s to for the closure of gaps found during the Weekly Audits.
• Achievements:
• Designed the Aisle Checklist for better Control for Stock Keeping w.r.t removal of Dust/cleanliness/fallen Stocks/Near Expiry checking/damaged Stock’s/Air Packaging control in defined Products.

Mar 2017 – Jan 2018 · 10 mos · New Delhi, India

• Working in & handling Warehouse of FMCG Client, Nestle.
• Managing Day to Day Activities of Warehousing, i.e. Receiving, Storing, dispatch along with Quality Assurance.
• Planned and Execute Inventory Stock on daily cycle count basis & full WH inventory.
• Managed, Supervised & staff shifts, according to the need and increase in productivity.
• To maintain Reports i.e. TAT, inbound/outbound, Vehicle temperature Reports, Reefer vehicle Delivery tracker.
• Achievements:
• Managed and Reduction in labor by Implementing Dock leveler.
• Done HO-TO of Nestle-DC-Delhi, location to other Hassangarh location, within 7 days, warehouse operational on the eight day at (Nestle DC Hassangarh).
• Improved productivity by purchasing new storage racks and equipment.
• Coached and improved the team of supervisors to oversee daily and weekly operations, coaching them on planning, hygiene maintenance, Quality and individual performances.

Dec 2016 – Dec 2016 · 0 mo

Jun 2016 – Jul 2016 · 1 mo