Prateek Agrawal Email & Phone Number

Hyderabad Area, India

 E2E implementation of Dashboard to monitor Drug Quality and compliance related actions (Deviation/Complaint/CAPAs) for Global TechOps Teams. Developed macro-economic model to calculate environmental impact in terms of carbon emission and water consumption from direct and indirect supply chain. Developed and designed survey on Health, Safety and Environment for key suppliers and organized workshop on achieving sustainability goals. Creating process for optimizing procurement of Spare Parts showcasing saving potential of $6M per annum. Streamlined process for demand consolidation from 26 Sites.  Developed FAQ Chat Bot for information related with Malaria. Gold Award in Novartis for enhancing the process of assigning Material Group to indirect materials. Gold Award in Novartis for providing an inter-plant marketplace for procurement teams to access the live availability of materials. Applause Award in Novartis for streamlining the Demand Submission data flow from site planners to ERP. Applause Award in Novartis for designing new process to capture changes in Master Data for audit purpose.

Bengaluru Area, India

 Requirements gathering, scoping and UAT for reporting needs of Customer Service Representatives. Developed Tableau Dashboard for analyzing Forecast Accuracy and Demand Development of customers at material level. Designed process to minimize duplicate Purchase Order creation. Present Shipment Performance Indicators to customers. Leading MIS team for automation of SAP ERP reports using SAP BO and SSIS. Sentiment Analysis for customer feedback from Surveys. Integrated it with LinkedIn Comments.

Bangalore

 Creation of Sales and Marketing Dashboards at Product level for Exxon Mobil. Provided a visual guide for business to check completion of data loads before broadcasting reports.

Bengaluru Area, India

 SAP BW Implementation of Employee Administration, Organizational Management, Payroll Calculation and Time Management components of HR Module for Comcast Corporation Developed HR Management Dashboards on Tableau and linked then with SAP reports for drill down. Gathering requirements analyze the gaps and provide effort estimation for all report requirements.

Midnight Anna Delivery has the objective of delivering light munchies and beverages to customers post the Cinderella style deadline of 11 PM in Bangalore.

Post Graduation Diploma In Data Analytics, 3.6/4

Activities and Societies: • Developed solution for online transportation network company to provide analytical solutions to overcome.

Bachelor Of Engineering (Be), Telecommunication Engineering

Activities and Societies: • Volunteered for SHIKSHA, a program to teach slum children. • Volunteered for SEQUITAR, the science society.

Pcm

Activities and Societies: Chess Club