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 CSAT, AHT, NPS and customer experience analytics
- The NPS report played a major role in improving customer experience (CX), logistics, product quality, and overall business decisions at Snapdeal
- 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
- Ability to identify bottlenecks processes and drive operational improvements
- 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
- Deep understanding of customer journey touchpoints (NPS, Cancellations, Returns, Delivery Issues)
- Skilled in identifying root causes of customer dissatisfaction and driving corrective actions
- Ability to analyse support tickets, seller issues, and operational dependencies affecting experience
- Experience in tracking NPS trends, feedback themes, and improvement opportunities
- Collaboration with multiple teams (Product, Ops, SCM, Seller Team) to resolve customer-impacting issues
- End-to-end visibility over order lifecycle from customer order to delivery/return
- Cross-functional coordination to improve both operational efficiency and customer satisfaction
- Proven ability to automate processes and reduce manual effort through reporting solutions
- Automated reports such as RTO Trends, OFD Performance, Shipment Lag Reports, Courier Allocation Metrics and Delivery Breach Analysis using Databricks + SQL
- Eliminated manual report creation, reducing effort by 90% and Improved visibility and reduced manual errors using highlight advanced SQL skills (including PARTITION BY, WINDOW functions, GROUPING, CTEs, etc.) as part of your work at Snapdeal
- Automated real-time Live Cancellation Report with Manifest% and shipped% calculations
- Enabled operations teams to identify spikes instantly and take proactive actions
- Built automated workflows to calculate delivery attempt trends (D1–D7), 3-day attempt salience, and courier-wise delivery issues
- Integrated courier-wise metrics (SHP→OFD→DEL→RTO) into BI dashboards
- Helped leadership make data-driven allocation decisions
- Created automated alerts for spikes in RTO%, delays, courier underperformance, and PDD breaches
Team Leader - Evolve Brands Pvt. Ltd.
(2003-07 - 2015-02)
Led comprehensive reporting and analytics for major clients such as Seagate (India & SAARC), Symantec, Hunter Douglas, Lenovo, Vision Express, Schneider, and HT by creating automated dashboards, trend analyses, performance summaries, and weekly/monthly business reviews to support strategic decision-making.
- Prepared and distributed comprehensive reports, presentations, and supporting materials, ensuring accuracy, clarity, and timely delivery to internal stakeholders and leadership teams
- Automated reports using SQL and Excel to reduce turnaround
- Supported operations through deep performance tracking
- Managed comprehensive reporting across all cadences (Daily/Weekly/Monthly/Quarterly/Half-Yearly/Yearly) for multiple projects, ensuring accurate data consolidation, analysis, and communication to internal leadership and external clients
- Report on different types of engagement metrics and analyze performance across many sites. Combine data analysis and client feedback to configure, operate, and optimize complex campaigns to meet client
- Giving types of analysis - campaign, keyword & Ad group level, device, placement level, geographical analysis, Search query level analysis etc
- Full fill the client and operation's reports requirements, Analyse the data trend, highlight point which are harmful for business
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
