Purnima Sharma

Experience

• 

  GMAC Mortgage

  Feb 2005 - Jan 2007

  Reporting Analyst

  Maintained full responsibility of creating and managing BO universes that decreased the reporting time by 50% within multiple departments. In addition to designing and maintaining universes, I automated several reports using macros and programming skills, which resulted in reducing the time required for report generation by 75%. Previously a tedious function of report processing and generation was streamlined and was more accurate and efficient. Responsible for the data management and reporting for GM Direct Lending Finance and Strategic Planning Provided data processing and analytical support for financial administrationDesigned and maintained financial, commission, and incentive databases Show less

• 

  Holman

  Apr 2007 - Jun 2022

  Developer III

  • Interact with people at all levels (including C-levels), gather requirements, translate their business needs into technical requirements, and architect solutions that align with the organizational goals.• Build ETL Pipelines in Data Factory, implement complex business rules and code for transformations.• Create data models in SAP Business Objects universes for enterprise-wide reporting and data analytics • Optimize slow running SQL queries, review code, and make recommendations • Create machine learning models using Azure ML and Databricks to uncover trends and patterns within data, summarize findings, and effectively communicate technical concepts to non-technical stakeholders• Developed an end-to-end backend tool to automate the creation of ROI reports for the Finance department, significantly reducing report generation time from 3-4 days to instantaneous. This automation enabled senior management to instantly view the ROI of every client, leading to the renegotiation of several low revenue-generating contracts and improving the bottom line.• Established an infrastructure for the development of multiple scorecards, empowering call center managers to perform analytics, monitor performance, manage calls, and consistently track key performance metrics. As a result, the Call Management System (CMS) managers reported a year-to-date (YTD) 6% decrease in critical CMS statistics. Show less

• 

  Sogeti (Capgemini) - Client: Johnson & Johnson

  Sept 2022 - Mar 2023

  Senior Manager

  • Played a key role in the data migration project for the consumer division of J&J to Kenvue• Identified and fixed different components of failing pipelines, missing tables, data discrepancies.• Handled data transformation involving varied data sources and file formats (JSON, CSV, parquets etc.) • Proactively identified and rectified various issues within data pipelines, including failing pipelines, missing tables, and data discrepancies• Handled varied data sources and file formats such as JSON, CSV, and parquet, and delta• Spearheaded optimization efforts for long-running queries, resulting in significant reductions in processing time and resource utilization, thereby improving overall system performance and efficiency.• Optimized pipelines by changing sequential to parallel data loads Show less

• 

  Sogeti (Capgemini) - Client: Federal Home Loan Bank (FHLB)

  Apr 2023 - Mar 2024

  Senior Manager

  • Acted as the Technical Lead for a comprehensive data modernization project, overseeing the entire lifecycle from data ingestion to complex transformations, reporting, data visualizations, and automation.• Received commendation from the Director (client) for delivering an end-to-end solution that revolutionized their data processes. Paraphrased comments include: "Previously inaccessible reports and functionalities are now readily available on a daily basis, enabling timely and profitable adjustments. Importantly, the enriched analytics were achieved without burdening the business with additional manual efforts."• Managed and led a multidisciplinary team to successfully implement the data modernization project, ensuring alignment with client requirements and project objectives. Show less

• 

  Sogeti (Capgemini) - Client: 84.51 (Kroger)

  Apr 2024 - now

  Senior Manager

  • Spearhead seamless data migration initiatives from on-premise infrastructure to Azure cloud platform, ensuring minimal disruption and optimal performance.• Lead the implementation of Unity Catalog, employing medallion architecture and Delta Live Tables to enhance data accessibility, integrity, and real-time analytics capabilities.• Develop and model curated datasets tailored for diverse stakeholders, including data scientists, data, reporting, and business analysts, facilitating efficient and insightful data-driven decision-making processes. Show less