Highlights:

Skills:SQL, Python, PowerBI, Tableau, SAS, Data Analysis, Exploratory Data Analysis

Senior Consultant 11/2021 - 03/2024
Ernst & Young LLP., Bengaluru, Karnataka India
Industry: Information Technology
Conducted quality control reviews of remediation strategies and, developed risk indicators using SQL
- Conducted data analytics quality control (DAQC) reviews of customer remediation strategies across different lines of businesses - Analyzed population data & code and created reproducible test cases for data validation using SAS SQL - Ensured data, code and remediation amount aligned with business requirements and compliant with client’s policies & standards - Utilized JIRA to track and manage non-compliance of code/data, ensuring timely resolution and seamless communication between quality control (QC) and development teams - Created comprehensive Excel-based documentation, facilitating collaboration with multiple stakeholders during the QC process - As a team lead, managed and mentored seven members ensuring on-time delivery of reviews, streamlining communication, and onboarding new members. Also, conducted thorough screening of candidates while hiring consultants for the team - Developed, tested and migrated anti-money laundering (AML) risk indicators in compliance with India Data Localization laws using SQL - Worked with multiple stakeholders to test said risk indicators used for money laundering detection and conducted their post-implementation verification - Automated Python code for a monthly report based on cross-border wire transactions - Achievement - Kudos Award - For managing the team, assisting the client in creating a roadmap for new candidate onboarding, and training a group of 100 new joiners--
Trainee Decision Scientist 06/2018 - 11/2021
Mu Sigma Inc., Bengaluru, Karnataka India
Industry: Data Analytics
Identified customers at-risk of churning using Python, SQL and PowerBI. Also, managed live optimization dashboards for batch manufacturing, forecasted demand and optimized transport network using Apache Hive, R & Python.
- Identified customers at a high risk of churning out by using Survival Modelling (using Ranger package) on Python - Used Survival Modelling to calculate expected churn amount and key variables affecting churn - Gathered requirements and designed PowerBI reports using Power Query and DAX measures - Increased Churn dashboard adoption across the sales team by 35% by identifying gaps and making enhancements based on user feedback - Quantified dollar value saved by developing the value-tracking methodology - Used SQL for ETL, creating datasets for churn analysis and integrating new data to the model - Contributed to company wide knowledge repository by documenting process flows, creating entity relationship diagrams, creating use case decks and reproducible code - Optimized transport distribution network and reduced transport costs for the company by $305K+ - Proposed optimized transport model and estimated overall reduction in transport cost to be ~16% - Created ARIMA models to forecast ‘average weight per truck load’ and ‘average distance traveled per truck load’ for different manufacturing sites for resource planning team - Maintained and ensured 100% uptime on real-time QlikView dashboards influencing and optimizing manufacturing processes based on LIMS data - Ensured backend data hosted on HDFS meets data quality standards by active monitoring. Provided application support to investigate data issues, created reports and regularly updated stakeholders through weekly business reviews - Achievement - Impact Award - Showed great ownership, resourcefulness, and accountability for her work in running the account. Being a young resource, she took great decisions independently and created credibility for Mu Sigma - Achievement - Spot Award - For taking up the mantle of leading the churn project and unwavering commitment in delivering value to the customer--

Kalinga Institute of Industrial Technology 05/2014 - 04/2018
Bhubaneswar, Odisha, India
Degree: Bachelor's Degree
Major:Information Technology
A four-year Bachelor of Technology course in Information Technology. Graduated with an 8.32 CGPA.

Apoorva Sharma Resume