Prateek Kumar Agarwal

Prateek Kumar Agarwal

Summer Trainee

Followers of Prateek Kumar Agarwal2000 followers
location of Prateek Kumar AgarwalGurugram, Haryana, India

Connect with Prateek Kumar Agarwal to Send Message

Connect

Connect with Prateek Kumar Agarwal to Send Message

Connect
  • Timeline

  • About me

    | Senior Data Analyst | | Skilled in Data Analytics & Visualization | | Life long Learner | | Passionate About Mentoring & Career Development |

  • Education

    • Graphic Era Hill University

      2013 - 2017
      Bachelor’s Degree Mechanical Engineering 1st division with honour's

      Activities and Societies: society of automobile engg. ( SAE India )

  • 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
  • Licenses & Certifications

    • Atlassian Jira and Agile and Scrum Fundamentals for Beginners

      Skillshare
      Aug 2024
      View certificate certificate
    • Data Analytic basic for everyone

      IBM
      Jan 2022
    • Introduction to NLP and LLMs

      LinkedIn
      May 2025
    • Analyzing Data with excel

      IBM
      Jan 2022
    • Python basics for data science

      IBM
      Jan 2022
    • Tableau Certification

      Simplilearn
      Dec 2022
      View certificate certificate
    • Business Analyst Certification

      Relevel by Unacademy
  • Honors & Awards

    • Awarded to Prateek Kumar Agarwal
      HackerRank SQL Gold Badge 5 Star Hackerrank Jan 2023 Solved question from easy to medium level using different sql function like - CTE , Subquery , nested Subquery , Aggregate function , windows function , Joins etc.Learned new concept along they way and help to make query more effective.
  • Volunteer Experience

    • Volunteer

      Issued by Udyansh - उद्यांश on Sept 2018
      Udyansh - उद्यांशAssociated with Prateek Kumar Agarwal