Apr 2020 – Aug 2022 · 2 yrs 4 mos · Gurgaon, Haryana

• I was hired to lead complex project management and data analytics initiatives at KPMG. My efforts enabled significant cost optimization, operational excellence, and innovative business solutions.
• Key Achievements:
• ● Transforming Operations: Led the charge in optimizing costs and streamlining processes, leveraging data-driven insights to drive business excellence.
• ● Unleashing Team Potential: Fostered collaborative environments, leading cross-functional teams to deliver high-impact projects and achieve remarkable efficiency gains.
• ● Future-Proofing the Workplace: Conceptualized and implemented innovative solutions, such as hoteling tools, to enhance employee experience and maximize resource utilization.
• ● Data-Driven Decision Making: Developed scalable analytics solutions, empowering business leaders with actionable insights to inform strategic decisions.
• ● Global Strategic Impact: Served as a trusted advisor to KPMG partner firms, driving strategic initiatives and cultivating a culture of innovation and excellence.

Apr 2016 – Mar 2020 · 3 yrs 11 mos · Gurgaon

• I was hired to lead transformation analytics at McKinsey. My efforts enabled sustainable business outcomes, new revenue streams, and improved client working capital.
• Key Achievements:
• ● Accelerating Transformation: Led analytics efforts for McKinsey's transformation programs, unlocking sustainable business outcomes through data-driven solutions.
• ● Empowering Regional Growth: Spearheaded APAC region expansion, scaling solutions from 6 to 39 clients and cultivating high-performing teams.
• ● Innovative Problem-Solving: Developed bespoke analytics solutions using cutting-edge tools, driving client insights and informed decision-making.
• ● Cloud-Based Innovation: Conceptualized and deployed Velox, a cloud-based working capital optimization model, generating new revenue streams.
• ● Client Impact: Improved working capital baseline for clients by 8-12%, demonstrating tangible business value through analytics expertise.
• ➤ Specialties: Data Science, Business Intelligence, Analytics Strategy, Digital Transformation, Leadership, Team Management, Data Governance, Advanced Analytics, Agile Methodology, Data Visualization (Power BI, Tableau), Python, Data Modeling, Business Process Improvement, Operational Excellence, Strategic Planning, Change Management, Stakeholder Management, Cloud Computing, Data Quality, Business Analysis.

Jul 2014 – Mar 2016 · 1 yr 8 mos

• Involved in data interpretation, manipulation, cleansing & processing Excel & VBA, SQL (query and ETL). Building knowledge of a client’s business strategy (product offerings, target market segments, positioning/value proposition, etc.) and market forces (suppliers, customers, competitors, regulatory environment etc. Developed requirement gathering template to help streamline the process. TAT and SLA agreement, budget and stakeholder management. Deadlines and Quality of deliverables. Data transformation and crunching for different solution and custom reports. Create ad-hoc automated custom reports as per the client requirement by using Excel, VBA, Access & SQL.
• Re-engineered the report generation for one of the reporting team which resulted into a saving of 8 FTE efforts for the whole year worth 150 k USD (52 weeks * 7hrs a day * 8 FTE * 50$ per hour).
• Created tools for doing the 8-points quality check for excel based reports (usable across teams) and a configurable excel tool to generate ppt out of excel.
• Streamlined the process for prognosis report generation and roll out Market Prognosis team and reduced the collation and publishing time from 10 FTE 15 days to 1 FTE 2 days (received operational excellence award for this).

Jul 2013 – Jun 2014 · 11 mos

Apr 2011 – Jul 2013 · 2 yrs 3 mos · Gurgaon

• Validate the usable data from various data sources and make the data talk using the Access, VBA, SQL and Excel as per the requirements/technical fitment for the client(s). Involved in creation and maintenance of various self-data extraction tools and reports in MS Access and MS Excel using VBA. Involved in the SaaS Solution development life cycle for three online tools and acted as a bridge between development team and business leaders.

Nov 2009 – Apr 2011 · 1 yr 5 mos

• Handling and governing the in-house projects which includes costing, benefit realization, time estimations, business owner, project updates. Generation of scorecards and high-level packs for the Top Management. Work on raw data to filter out and validate the usable data using Access, VBA, SQL and Excel. Involved in UAT of incident ticket generation system which helped in stabilizing the ticketing process and created a smooth experience for our clients.
• Apart from day to day reporting, I have also lead couple of major projects, i.e. “Book to Bill” & “Order to Shipment Synchronization”. Both the projects have helped colt to enhance their work

Nov 2008 – Nov 2009 · 1 yr

• Work on raw data received from various clients to filter out and validate the usable data using the Access, VBA, SQL and Excel per the requirements provided by the clients. Creation and maintenance of various self-data extraction and reporting tool in MS Access and MS Excel using VBA. Conversion and implementation of extracted and collected data for various tools and analysis.