Aniket Wagh

Strategic Data Ownership: Managed end-to-end analytics lifecycle from data extraction to ETL and dashboarding. Product Strategy & Impact: Developed Power BI dashboards integrating Google Analytics & social data, reducing manual reporting by 30% and improving transaction completion by 20%. Independent Leadership: Acted as sole analytical POC for multiple clients, delivering insights that shaped their business strategies.

KPI Optimization: Created and automated dashboards, improving reporting efficiency by 30%. Workflow Automation: Automated SQL workflows, saving 25+ hours/month in repetitive tasks. Insights to Action: Identified video-led creatives improved conversions by 30%, prompting a strategic campaign shift.

A/B Testing & Experimentation: Designed and executed large-scale experiments (Enhanced HUD, ETA Range, Assignment Delay HUD comms, Pre-assignment comms). Optimized Track Screen interactions, reducing Swiggy-driven cancellations by 41 seconds, enhancing overall customer experience. Business Impact: Showed Delfee Refund increased cancellations by 0.01% overall, recommending against rollout and saving ₹0.23 CPO in Bangalore. This directly led to new experiments like Pre-assignment Comms. Strategy & Framework change: Partnered with PMs to design next-gen service recovery metrics, creating a future-ready framework for measuring cancellations and refunds, strengthening Swiggy’s ability to scale recovery initiatives. Analytics Efficiency & Scalability: Automated metric onboarding into the XP dashboard, eliminating the need for new dashboards/experiments and reducing analysis duration by approximately 50%, allowing the team to focus on higher-impact strategic tasks. Strategy & Framework change: Acted as the go-to analyst for Track Screen analytics, collaborating across Product, Engineering, QA, and XP Council, influencing PRDs and GTM strategy with data-driven thresholds

Deployed by Inteliment End-to-End Data Infrastructure: Designed scalable ETL pipelines to integrate disbursement, repayment, and interest data into enterprise systems. Financial Analytics: Produced accurate loan & repayment reporting, strengthening compliance and enabling faster credit decisions. Independent Ownership: Delivered analytics solutions across collection, cleaning, transformation, and reporting independently. Mentorship: Delivered SQL and statistical training to over 5 new analysts.

➢ Experienced with the 4-tier architecture of application i.e. Extraction, Transformation, Data Model and Presentation Layer ➢ Extensive knowledge with Dimensional and Fact modeling like star schema and snowflake schema. ➢ Developed and maintained ETL workflows and mappings ➢ Developing optimized packages, event handlers and error handling using SSIS using Visual Studio ➢ Created complex T-SQL Stored Procedures, Views, User Defined Functions, Triggers, Cursors and Joins for ETL on SQL Server using SSMS ➢ Developed compelling and interactive analysis reports and dashboards for Finmart, Sales analysis, HR analysis and Product analysis using advanced DAX in Power BI