VARSHA MANDSAURWALE

• Investigated all revenue streams to identify gaps and maximise recovery potential.
• Designed and delivered end-to-end Power BI dashboards to quantify, prevent and monitor revenue leakage.
• Developed automated reporting solutions using Power BI, SQL and DAX to track KPIs and highlight risk areas.
• Collaborated with Product Owners, Compliance teams and IS teams to resolve systemic issues impacting revenue collection.
• Implemented fraud detection controls for refunds, credits and discounts.
• Supported audits across Salesforce, SAP ISU, SAP CRM and NEP (Ensek).

Achievements:

• Reduced revenue leakage by 60% and financial risk through analytics-driven controls and automated Power BI monitoring.
• Delivered accurate datasets and dashboards used for business-critical decisions and regulatory compliance.
• Improved operational efficiency through Power Query automation and governance enhancements.

Power BI Development & Analytics Delivery

• Designed interactive Power BI dashboards for fraud analytics, revenue assurance, consent management, PSR governance and operational KPIs.

• Built advanced DAX calculations for trend analysis, anomaly detection and risk scoring.

• Developed robust data models using Power Query, combining data from Salesforce, SAP ISU, SAP CRM and NEP (Ensek).

• Automated manual Excel-based reports into Power BI, enabling scheduled refresh and reducing manual intervention.

• Created drill-through pages, bookmarks and dynamic visuals for leadership insights.

• Implemented role-level security (RLS) and workspace governance in Power BI Service.

Fraud Detection and Risk Analytics

• Designed and implemented data validation rules for refunds, miscellaneous credits, and employee discounts, reducing fraudulent transactions.

• Built automated checks for bank accounts, emails and telephone numbers to improve data quality and prevent fraud.

• Developed fraud identification dashboards to monitor suspect brokers and employee-related anomalies.

Regulatory Compliance and Consent Management

• Analysed and streamlined consent data for half-hourly reads and settlement processes ensuring compliance with industry regulations.

• Created reporting mechanisms to track consent status across multiple systems for audit readiness.

Priority Services Register (PSR) Data Governance

• Conducted data cleansing and standardisation of PSR categories, improving accuracy and consistency across platforms.

• Automated daily PSR data transmission to industry systems using Power BI-powered quality checks.

• Enhanced customer vulnerability handling through data-driven improvements in careline and engineer visit processes.

Data Auditing and System Reconciliation

• Led audits across Salesforce, Ensek, SAP CRM, and SAP ISU, identifying and resolving discrepancies in medical and service needs data.

• Eliminated duplicate and invalid PSR records, improving data integrity and reliability.

• Developed reconciliation reports addressing mismatches between SAP ISU and NEP, ensuring accurate service and medical needs mapping.

• Corrected systemic data issues including missing start dates, future dates, and incorrect age periods, strengthening governance.

• Led offshore AMS operations ensuring all deliverables met quality and timelines.
• Prepared analysis, design documents, and estimations for system components.
• Developed and debugged .NET applications including user controls and backend logic.
• Designed and optimised SQL queries, stored procedures, views, triggers.
• Delivered 50+ reports using SQL, SSRS, and SSIS.
• Handled incident management through ServiceNow and JIRA.
• Supported Agile delivery, requirement gathering, and sprint planning.
• Facilitated PMR, WSR, audit calls and acted as Timesheet SPOC.
• Participated in recruitment drives and project hiring activities.
• Project: Honeywell — Offshore AMS Lead
• Project: Siemens (UNIFY)
• Gathered requirements and prepared functional and technical specifications.
• Developed web-based solutions using ColdFusion, ASP.NET, Classic ASP.
• Provided L2/L3 production support and resolved application issues.
• Managed change requests, enhancements, and documentation.
• Coordinated with customers to address technical issues and document defects.
• Project: Nissan Motor Co. Ltd.
• Designed GUI-based test behaviours for multiple ECUs.
• Executed manual and functional testing across vehicle systems.
• Created and analysed test cases and conducted acceptance testing.
• Validated ECU behaviour using CONSULT III Plus tool.
• Actively involved in daily stand-up meetings contributing significantly towards agile methodology.