Prateek Gupta

• Determined customer needs, automated reports for executive level dashboards using ETL & developed performance metrics/ KPI’s • Deep dived, created embedded queries to blend various data sources & provided business intelligence solutions to complex problems • Created dynamic dashboards in Google Data Studio for end to end customers, tracked KPI’s & implemented ways for process improvement • Created ad-hoc reports. Improved the performance of data by enhanced SQL queries & data manipulation resulting in 67% process improvement

• Developed advance SQL queries to extract, transform raw data. Performed ETL operations to create dashboards & visualizations in Google Data Studio • Gathered, analyzed data, interpret patterns to improve company’s statistical forecast processes for staffing demands & marketing analysis • Created high business impact analytical models to drive business journey needs resulting in 21 % more efficiency & low error rate

• Established, monitored & developed process improvement plans, dashboards for quality KPI’s and serve as focal point in organization • Analyzed, conducted predictive analytics & cross validated models on customer returns for quality & interpret them using Python • Created data visualizations & exploratory analysis to analyze & track performance KPI’s • Determined potential problems of models, provided solutions & validated effectiveness of model with 89% accuracy

Materials and Manufacturing Processes Aid the professor in educating the course. Preparing projects and leading the students. Giving attention to details and building good working relationships Tutor and mentor students. Prepare presentations, lead discussion sessions and resolve issues Prepare and grade quizzes for student assessments whilst providing feedback on their assignment and coursework.

• Partnered with customers & leadership for requirements gathering, prioritized, analyzed data needs while building relationships & dynamic reports • Developed flow diagrams, models using regression, decision trees & data mining techniques to find pattern in products • Assisted cross functional teams in resolving database issues, ad-hoc analysis & prepared data using SQL & provided business intelligence • Forecasted sales to reduce wastes resulting in 16% cost benefits in business processes & drive continuous improvement

College President of Non Government Organistion like SPIC MACAY and BEING EARTHBORN. Cricket team Captain. Awarded with Man of the Match in State Cricket Tournament Final.