Business Analysis II, Data Science - Snapdeal Pvt. Ltd
(2015-03)
Managing projects related to supply chain optimization and data sciences initiatives.
- Identify areas of the supply chain that can benefit from process automation and optimization through data science.
- Handling Reverse Process (creating SOP's, Process and dashboard) and maintaining department analytical tools, processes and databases
- Transformed project data requirements into project data models and analyzed historical data and market trends to improve accuracy in forecasting
- Participated in requirements meeting and data mapping session to understand business needs. Developed tables, views and materialized views using SQL
- Managed customer experience analytics by tracking CSAT, AHT, NPS trends, customer feedback themes, and key customer journey touchpoints—including cancellations, returns, and delivery issues—to identify improvement opportunities and enhance customer satisfaction.
- Strong understanding of end-to-end supply chain operations (Order → Manifest → Ship → Deliver → Return).
- Expertise in monitoring key SCM KPIs such as RTO%, PDD breach, OFD performance and courier SLA compliance.
- Skilled in courier performance tracking, allocation analysis, and exception management.
- Strong analytical capability using SQL, Vertica, Databricks, Excel, and Power BI for SCM reporting.
- Ability to automate dashboards, daily reports, and alerts for faster decision-making.
- Skilled in identifying root causes of customer dissatisfaction and driving corrective actions.
- Ability to analyse support tickets, seller issues, and operational dependencies affecting experience.
- Collaboration with multiple teams (Product, Ops, SCM, Seller Team) to resolve customer-impacting issues.
- Cross-functional coordination to improve both operational efficiency and customer satisfaction.
- Proven ability to automate processes and reduce manual effort through reporting solutions.
- Automated supply chain and logistics reports, including RTO Trends, OFD Performance, Shipment Lag Reports, Courier Allocation Metrics, Delivery Breach Analysis, and a real-time Live Cancellation Dashboard with Manifest% and shipped% calculations using Databricks and SQL, reducing manual effort by 90%, improving reporting accuracy, and enhancing operational visibility.
- Developed automated workflows and alerts to monitor delivery attempt trends (D1–D7), 3-day delivery attempt success, RTO spikes, shipment delays, courier underperformance, PDD breaches, and courier-wise delivery issues, enabling proactive issue resolution and faster operational decision-making.
- Enabled operations teams to identify spikes instantly and take proactive actions.
- Integrated courier-wise metrics (SHP→OFD→DEL→RTO) into BI dashboards.
- Helped leadership make data-driven allocation decisions.
Team Leader - Evolve Brands Pvt. Ltd.
(2003-07 - 2015-02)
Led reporting and analytics for major clients, including Seagate (India & SAARC), Symantec, Hunter Douglas, Lenovo, Vision Express, Schneider, and HT, by developing automated dashboards, trend analyses, performance summaries, and weekly/monthly business reviews to support strategic decision-making.
- Managed end-to-end reporting across Daily, Weekly, Monthly, Quarterly, Half-Yearly, and Yearly cadences, ensuring accurate data consolidation, analysis, and timely delivery of reports, presentations, and insights to internal stakeholders and external clients.
- Automated reports using SQL and Excel, significantly reducing report turnaround time while improving reporting accuracy, operational efficiency, and performance tracking.
- Analyzed engagement metrics and campaign performance across campaign, keyword, ad group, device, placement, geographic, and search query levels by combining data analysis with client feedback to optimize campaign performance and achieve client objectives.
- Fulfilled client and operational reporting requirements by analyzing data trends, identifying business risks, highlighting performance gaps, and providing actionable insights to support informed decision-making.
Senior MIS Database - Solution Integrated Marketing Services Pvt. Ltd. (Solution Digitas)
(2003-05 - 2003-06)
Worked on HP and Microsoft projects, managing end-to-end data analysis activities including data extraction, validation, cleaning, and preparing actionable insights for project stakeholders.
- Collaborated with internal teams to ensure the delivery of accurate reports, performance dashboards, and business metrics to support decision-making.
- Executed all types of data cleaning tasks in Excel such as data formatting, error correction, deduplication, text-to-columns, VLOOKUP-based validation, and dataset restructuring. Developed feedback-based analytical reports by identifying trends, segmenting responses, and transforming raw data into actionable insights.
- Analyzed sales and survey databases to identify performance trends, customer insights, and business opportunities. Prepared detailed reports and dashboards to support decision-making for internal teams and clients.
Associate Database - Direct way Data Services Pvt. Ltd
(2003-02 - 2003-05)
- Handled data maintenance in FoxPro, MS-Access and Excel, including database updates, restructuring tables, applying validation rules, and performing periodic audits to ensure accuracy. Improved data reliability for reporting, analysis, and decision-making processes.
- Prepared detailed feedback analysis by reviewing customer responses, identifying key patterns, and summarizing insights to support business decision-making.
- Generated MIS reports and provided regular updates to clients, ensuring accuracy, completeness, and timely delivery of all required information.
