Business Analyst at Genpact (2022-06 – 2026-06)
Architected a data platform focused on optimizing retailer operations, fleet management, and workforce performance across multiple regional hubs. Integrated multi-source infrastructure to deliver real-time KPI visibility, eliminate deep data discrepancies, and remove manual reporting overhead. Client: Circana. Technologies: MS Power BI, Advanced Excel (Cleansing, Normalization, Restructuring), Excel VBA, Unify, PowerPoint, SQL Server, SharePoint.
- Evaluated technical feasibility for incoming operations automation requests, translating complex business problems into stable technical solutions.
- Engineered, tested, and deployed an enterprise portfolio of 100+ custom Excel VBA macros, successfully eliminating repetitive operational tasks.
- Optimized and refactored legacy VBA codebase to drastically minimize script processing errors and accelerate execution speed.
- Developed and launched 15 dynamic, interactive dashboards using Power BI Desktop to supply operations teams with actionable business insights.
- Constructed robust data models in Power Query by connecting, cleaning, and transforming disparate data from SQL databases, SharePoint, and cloud folders.
- Maintained cloud and desktop Power BI assets, configuring data gateways and scheduled refreshes to guarantee reliable, daily report delivery.
Senior Software Engineer at Covalense Technology (2019-07 – 2022-06)
Built an enterprise Business Performance Analytics platform enabling standardized global reporting and consolidated KPI monitoring across cross-functional global business units. Client: Unilever. Technologies: MS Power BI, Excel VBA, Advanced Excel (Data Transformation, Macro Automation).
- Evaluated massive data volumes from disparate operational sources to develop high-utility summary reports for top management and executive stakeholders.
- Engineered automated VBA macro routines to replace repetitive manual administration tasks for team leads, boosting operational velocity.
- Provided end-to-end production support for existing VBA applications, successfully modifying functionalities based on shifting user requirements.
- Designed and structured comprehensive MIS, Quality, and operational reports using Advanced Excel to fulfill core management information needs.
- Programmed specialized macros for financial reconciliation, auditing data accuracy, and executing live customer order updates.
- Converted legacy, resource-heavy Excel formulas (including VLOOKUP and HLOOKUP) into high-performance VBA code to increase workbook stability.
Senior Process Analyst at BROADRIDGE Financial Solutions (2017-05 – 2019-02)
Technologies: Excel VBA, Advanced Excel (Data Transformation, Macro Automation), SQL Server, PDF/PPT Automation. Clients: Barclays, Bloomberg, Credit Suisse, State Street, E*Trade, and 10+ US Banks.
- Generated and distributed accurate executive-level management reports (PDF, PPT, and Excel Dashboards) under strict financial market deadlines.
- Authored comprehensive MIS documentation to establish smooth daily operations, standardized workflows, and quick system maintenance.
- Analyzed reporting frameworks and provided targeted recommendations to improve overall reporting efficiency, formatting, and metric consistency.
- Developed sophisticated Excel applications utilizing the Excel Object Model, class modules, program modules, sheet events, and combo boxes to move data dynamically based on complex selection criteria.
- Partnered with the finance department to automate manual accounting pipelines, converting multi-tier formulas (VLOOKUP, HLOOKUP, Index) into automated scripts.
- Designed relational database tables, optimized stored procedures, built data-input interfaces, and provided administrative support using SQL Server.
Senior Process Analyst at Hinduja Global Solution Pvt Ltd (2013-04 – 2017-01)
Served within the core Quality Analyst team providing automated reporting solutions to drastically reduce manual workloads, optimize transaction processing times, and preserve absolute data accuracy. Client: Humana. Technologies: Advanced Excel, Excel VBA, PowerPoint, CASH Platform.
- Prepared daily, weekly, monthly, and quarterly MIS analyses while systematically maintaining process-wise pipelines.
- Processed over 150 custom data and analytical reports monthly to fulfill customer and internal stakeholder business requests.
- Engineered standardized, automated Excel reporting templates that significantly minimized daily manual processing times.
- Translated complex statistical reports into professional graphical presentations using PowerPoint for senior leadership reviews.
- Identified structural workflow bottlenecks and collaborated with finance team members to consolidate reporting and issue unified financial statements.
- Programmed data verification macros to automatically reconcile data and audit customer order files for error-free processing.
