Amrita Sharma Email & Phone Number

Worldwide, Oo

Worldwide, Oo

• Analyzed unstructured click stream data and performed funnel analytics, deep mining through 500B records, >100GB of raw data, that enabled business team to get a data instrumentation work funded• Utilized diverse technologies including PySpark, Splunk, Tableau and SQL for analytics and defined data specifications for large aggregate datasets• Managed complete data lifecycle from business requirement gathering to data collection and final dashboard creation that enabled trend analysis of more than 1B transactions per week, >85% of all transactions, and provided end-to-end holistic analysis of customer's journey on the platform• Led scoping work to define goals for data product and defined 30+ key metrics for analysis• Redefined data validation process and set a new standard by bringing down the gap from >50% to less than 1-2% across two data systems. Mentored three team members and built data validation capability in team

Worldwide, Oo

Retail Associate Forecasting: Worked as the data scientist on the team to evaluate the current state retail headcount forecasting model and developed a new model for a leading telecom client• Validated short-term improvement opportunities in the current state model• Recommended short, medium, and long-term initiatives to improve workforce forecasting• Developed predictive model to perform labor forecasting based on customer demand and external factors along with the store specific internal factorsHarmonize and Visualize Design and Implementation Project:• Collaborated with clients and internal project team (including offshore team) to provide high-quality and timely deliverables • Analyzed 2000 plus requirements across four different Supply Chain functions for a leading computer manufacturer and created Business Information Models and Logical Data Models• Conducted multiple requirement gathering workshops and training sessions for the business stakeholdersStrategic Sourcing project for a leading mining company :• Collected, Managed and Analyzed data from multiple sources and different formats for supplier spend. Consulted with the client managers to identify the spend categories, performed data cleansing and developed the Spend Cube in Tableau.

Pittsburgh, Pa, Us

Cleveland , Ohio, Us

I worked as a Pricing and Portfolio Analytics intern at KeyBank where I worked on three different projects in the areas of Business Analytics and Machine Learning. I developed very good understanding of KeyBank's Payments processes especially on the Merchants and Deposits side. Project 1- Customer Churn prediction-I developed machine learning models which predicted customer attrition by analysing 140 Million plus customer transaction records and customer demographic informationProject 2 - Merchants Portfolio Analytics -Built data model on top of data coming from diverse data sources.Created tableau dashboards and performed customer portfolio analyticsRecommended most profitable and least profitable customer segments and industries

Rueil Malmaison, Paris, Fr

Client: Schneider Electric Manufacturing PlantsRoles and Responsibilities:- Performed implementation & integration of OTM(Oracle Transportation Management) with ERPs.- Interacted with plant users for requirement gathering, analyzing, validating and documenting- Travelled to China Distribution Centre(DC) to implement OTM for manufacturing plants and DCsProject 2:- Developed the Business Continuity Plan(BCP) for SE IPO(Information Process Organization) divisionProject 3:- Designed the pricing mechanism to evaluate the 3rd party vendors for redeveloping legacy applications.Tools/Technologies Used:- Oracle Transportation Management (OTM), - PL/SQL, - BI Publisher, - SQL developer,- MS ExcelAchievements:- Received appreciation from senior management for implementing OTM Project for Schneider Electric DCs- Received client appreciation for providing valuable feedbacks and training to the OTM users

Rueil Malmaison, Paris, Fr

Project Worked upon :SAP ECC upgrade - Analytical study of new business functionality in SAP ECC 6.0 Enhancement Package 6.Roles and Responsibilities:- Performed feasibility analysis of new business functionalities in SAP ECC Enhancement Package 6.- Proposed roadmap for upgrading Materials Management and Financial Accounting modules of SAP.- Performed Cost -Benefit Analysis of new business functionalitiesAchievements:- Shortlisted among the top 10 entries for E4 Intercollegiate summer trainee award contest.- Project selected in top 5 projects in Avartan(an inter college summer internship competition).

Bangalore, Karnataka, In

Clients: Aetna (Health Insurance Client)Roles and Responsibilities:- Designed and developed custom business processes in Oracle Apps ERP based on client’s requirements.- Handled project through entire Development Cycle from Design to Development to Testing of the Aetna.- Integrated Financial Services (Oracle Financials module).- Spearheaded the Defect Prevention Team and did Root Cause Analysis to ensure Quality Compliance.- Mentored a team of 5 colleagues and conducted continuous competency development trainings for them.- Performed Project scheduling and resource allocation work in the team.- Interacted with the client for requirement gathering, analyzing, validating and documenting.Tools/Technologies Used:- Oracle Application Framework (OAF), - PL/SQL, - Reports6i, - BI Publisher, - PL/SQL developer,- Oracle Apps ERP 11i, R12Achievements:- Awarded the STAR performer Award for exceptional performance during the R12 upgrade project.- Awarded the STAR trainer award twice for training the batches of new joiners.- Secured the 5/5 CGPA during the Education And Research Training in Infosys.- Received the best Appraisal Rating for demonstrating outstanding commitment to the project.- Appreciated by my onsite coordinator and senior manager for my excellent work in the project.

Masters, Business Intelligence And Data Analytics

Master Of Business Administration (M.B.A.), Logistics, Materials, And Supply Chain Management And It

Bachelor’S Degree, Computer Science

High School, Science