Prateek Kumar Agarwal

Experience

• 

  Uttarakhand transport corporation

  Jul 2015 - Jul 2015

  Summer Trainee

  During this intership learned about auto parts, assembly of engine, gear box , clutch plate etc

• 

  Ashok Leyland

  Jul 2016 - Jul 2016

  Summer Internship

  To make SOP of main operation on cylinder head line

• 

  Action TESA

  Aug 2017 - Mar 2019

  Mis executive and Analyst

  Documentation - Daily production report , OEE reports , Deviationreports , Gap analysisAnalyze employee productivity, performance and task completionto meet quality standards.

• 

  Avadh Rail Infra Ltd

  Mar 2019 - Mar 2021

  Preparing MIS reports (monthly ,weekly & daily) , OEE reports .All these report are created using ms Excel and present with help of graph and charts to creat a better understanding.working with software such as SAP by design to extract data for analysis

  • Senior Reporting Analyst

    Aug 2019 - Mar 2021

  • Reporting Analyst

    Mar 2019 - Aug 2019
• 

  Merino Industries Limited

  Apr 2021 - Feb 2023

  Assistant Manager - MIS

  - Data analysis to generate MIS reports with dashboard for each performance indicators/departments- Presentation of insights through PPT- Data collection and cleaning to understand data to generate meaningful insights and reports - Coordination with department for timely closure of gap found.- Scheduling meetings with department and record minutes of meeting.- Support and create documentation as per process requirements or gap found.

• 

  KultureHire

  Sept 2022 - Feb 2023

  Business Analyst

  Collected raw data for YouTube and did operation of data cleaning and data manipulation to get the data which can be used for data analysisGenerate insight based on data to address the business statement.created dashborad in excel to show insight and provide solution for the business problem

• 

  Trainity

  Dec 2022 - May 2023

  Data Analyst
• 

  Zypp Electric

  Feb 2023 - Oct 2024

  ➤Introduced BigQuery to the team and implemented data automation to streamline client dataprocessing, minimizing manual interaction and enabling rapid response. ➤Utilized Google Sheets to streamline data operations and achieve standardization throughautomation.➤Introduced Tableau Cloud and created user-friendly, multi-layered dashboards that deliver impactfulinsights. ➤Proactively monitored data integrity and collaborated with clients to address data-related issues, ensuring seamless data continuity. Show less

  • Senior Data Analyst

    Nov 2023 - Oct 2024

  • Data Analyst

    Feb 2023 - Nov 2023
• 

  American Express Global Business Travel

  Nov 2024 - now

  Consulting Analyst