Business Analyst | Revfin Services Private Limited | Delhi
Apr 2024 – Sep 2024

• Developed a Power BI dashboard to monitor 36,000 IoT devices in electric vehicles, detecting and resolving tampering in 1,600 devices, and improving recovery of 832 repossessed vehicles, boosting revenue and decision-making.
• Leveraged SQL to process over 700 million rows for geospatial analysis and enhanced performance monitoring, improving asset recovery by 20%.
• Visualized daily metrics for 36,000 e-rickshaws, identifying battery degradation patterns, optimizing battery replacements, and enhancing maintenance schedules.
• Streamlined investor data using SQL, reducing file size by 95% and cutting refresh times from 3 hours to 10 minutes with automated Excel pivot table updates.
• Automated dealer performance reporting, improving efficiency by 40% and enhancing dealer performance tracking by 15% through Power BI.

ELDP | Xylem Water Solutions | Bangalore & Remote(N. Carolina, USA)

Jul 2021 – Mar 2024
                 

Roles: Product Management & Marketing Analyst

• Designed and developed a Sales Opportunity Dashboard in Power BI, driving a 15% increase in lead identification for sales teams across multiple regions.

• Conducted extensive competitor pricing analysis using advanced Excel, optimizing product pricing and improving market competitiveness.

• Created a Distributor Identification Dashboard, streamlining the distributor network and improving sales coverage by 10%..                                                      

• Performed market research for period 2012-2022, analyzed national gas leakage datasets, and utilized Python (pandas) and Excel (slicer, XLOOKUP) for large dataset analysis, resulting in a strategic Gas Pressure Profile dashboard with conditional formatting for efficient leak identification.

• Performed SaaS customer base analysis, resulting in strategic pricing and offering changes that led to a 12% increase in recurring revenue.

• Implemented real-time dashboards in the Utility Data Lake, enhancing data accuracy and improving Sensus customer satisfaction by 20%.                                               

• Optimized the design of a High-Efficiency DC-DC Flyback Converter using Excel (Solver, Aggregate functions), improving energy efficiency by 10%.