Prateek Verma
New Delhi
Summary
Energetically drove data-driven decisions at M/S Subhash Garg and Sons Pvt. Ltd., mastering tools like MS Excel, SQL, and Power BI to enhance reporting efficiency and accuracy. Excelled in transforming complex datasets into actionable insights, bolstering project outcomes by leveraging advanced analytics skills and effective communication.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Management Analyst
M/S Subhash Garg and Sons Pvt. Ltd.
New Delhi
03.2022 - 08.2024
- Company Overview: Firm dealing in railway maintenance projects, material supply, and infrastructure projects.
- Documented processes for collecting, manipulating, validating, analyzing, and reporting data.
- Generated automated reports using software such as Microsoft Access or Excel.
- Created spreadsheets using MS Excel to track orders and inventory levels.
- Compiled data from various sources into reports using MS Excel spreadsheets.
- Generated ad hoc reports using MS Excel as requested by end users.
- Maintained a thorough understanding of relevant software applications including MS Excel, Access, SQL Server Reporting Services, Tableau, Power BI.
- Prepared reports for upper management using MS Excel, Powerpoint and Access.
Data Analytics Bootcamp
Trainity
New Delhi
03.2023 - 08.2023
- Developed and maintained data pipelines for ingesting, transforming, and loading large datasets into various analytics platforms.
- Performed exploratory data analysis to understand trends in customer behavior.
- Implemented methods such as linear regression and decision trees to predict customer lifetime value.
- Skilled in utilizing complex Excel features for improved data presentation.
- Created DataFrames and conducted insightful statistical analyses.
Education
Bachelor of Technology - BTech - Civil Engineering
National Institute of Technology
Kurukshetra, Haryana07.2021
Senior Secondary - Non-Medical
Gita Niketan Awasiya Vidyalaya
Kurukshetra, Haryana03.2017
Skills
- MS-Excel
- SQL
- HTML5
- Python
- Pandas
- NumPy
- Matplotlib
- Statistics
- RDBMS
- Power BI
- Tableau
- Server
- Data Insights Visualization
- PostgreSQL
- Pivot Table
- Communication Skills
Certification
Virtual Internship Certificate, TRAINITY
Projects
Netflix Data Analysis, 07/2023 - 07/2023, Worked on various visualizations like Text table, Bar Chart, Line Chart, Pie Chart. Doing due diligence and KYC for the clients as part of business expansion processes. Producing accurate and updated reports under tight deadlines without much supervision. Meeting project target workload within set time limits. Employed Microsoft Excel features like V-Lookup, H-Lookup, Index Match, Pivot Tables to organize data, generate analytical reports, and create dashboards. Accomplished various project-tasks and delivered them before deadlines to promote teamwork & dedication. Learnt Advanced Excel functions and tools to skill-up dashboard formation and make it look more eye-catching and expressive. Python Programming and libraries for data analysis, cleaning, making DataFrame, insightful statistical measures and data visualization for better understanding of the KPIs in data. Bank Loan Case Study, Data Collected, processed and analyzed using Pandas Library. Used Pandas in-built methods to derive useful insights and key data values. Statistical outcomes were inquired and reported using functions and queries. Imported libraries and visualized the data using Matplotlib and Seaborn libraries. British Airways Reviews, Interactive Tableau Dashboard to represent reviews of the facilities and services by the British airways, from various kinds of travelers all around the world. The dashboard includes geographical as well as different types of charts as filters to select as metric, can be filtered for a specific time making it fully functional. Data collection and cleaning to make it apt for analysis, and progressing to EDA over the whole dataset. The data was prepared in a way to showcase how many people will default based on various variables. Incurred Advanced Excel functions and utilized Pivot Table for conducting univariate, bivariate analysis and segmented univariate, bivariate analysis. Outliers were marked and taken care of in EDA.
Languages
- English, Native or Bilingual Proficiency
- Hindi, Full Professional Proficiency
Timeline
Data Analytics Bootcamp
Trainity
03.2023 - 08.2023
Data Management Analyst
M/S Subhash Garg and Sons Pvt. Ltd.
03.2022 - 08.2024
Virtual Internship Certificate, TRAINITY
Bachelor of Technology - BTech - Civil Engineering
National Institute of Technology
Senior Secondary - Non-Medical
Gita Niketan Awasiya Vidyalaya
Similar Profiles
Dhruv ChopraDhruv Chopra
Associate Director at Garg Data Information Pvt. Ltd. (BirchStreet Systems)Associate Director at Garg Data Information Pvt. Ltd. (BirchStreet Systems)
ADARSH GADARSH G
Diesel Mechanic at TVS MOBILITY PVT LTD, T V SUNDRAM AND SONS PVT LTDDiesel Mechanic at TVS MOBILITY PVT LTD, T V SUNDRAM AND SONS PVT LTD
Diptiman DasDiptiman Das
Senior Executive - Training & Placement at Netaji Subhash Engineering College (A Unit of Techno India Group)Senior Executive - Training & Placement at Netaji Subhash Engineering College (A Unit of Techno India Group)