data analytics

GAURAV PATIDAR

Indore, India

+1-203-***-**** **********@*****.*** https://www.linkedin.com/in/gauravp019 Impact-focused Data Engineer with a track record of designing and optimizing data pipelines, ETL workflows, and data models to power business insights. Proficient in SQL, Python, Power BI, and cloud platforms with hands-on experience in large-scale data extraction, transformation, and visualization. Skilled in supply chain analytics and data science techniques, including predictive modeling and time series forecasting.

EDUCATION

University of New Haven, West Haven, CT May 2025

Master of Science in Business Analytics GPA: 3.9/4.0 Shri Vaishnav Vidyapeeth Vishwavidyalaya, India June 2021 Bachelor of Technology in Computer Science

WORK EXPERIENCE

Parenteral Drugs (INDIA) Limited August 2021 – July 2023 Supply Chain Analyst Procurement analyst India

• Optimized production schedules using SAP and ERP, boosting on-time order fulfillment by 15%.

• Reduced supply chain disruptions by 20% through accurate inventory analysis and material requirement planning (MRP).

• Automated supply chain reporting with SQL and Power BI, reducing manual data entry by 25% and improving report accuracy.

• Developed KPI models to track performance metrics, accelerating data-driven decision-making by 10%. Softrefine Technology March 2021 – August 2021

Front-end Developer India

• Developed and optimized API integrations for data retrieval, improving data access speed by 20%.

• Enhanced web application performance by reducing load time by 15% through modular front-end design.

• Engineered data workflows with backend teams, boosting processing speed by 20%. Technosoft Informatics July 2019 – September 2019

Web designer (Intern) India

• Designed and developed both static and dynamic web pages, increasing user engagement.

• Managed project timelines and coordinated team efforts to ensure timely delivery.

• Incorporated feedback from senior developers to refine project outcomes. SKILLS & PROJECTS

Skills:

Data Analysis & Engineering: SQL, Python (Pandas, NumPy), Data Cleaning, Data Transformation, ETL Basics Visualization & BI: Power BI, Tableau, Excel (Pivot Tables, VLOOKUP), Dashboard Development Programming: Python, R (Basic)

Databases & Tools: SQL Server, Git, Excel

Data Science: Forecasting, Time Series Analysis, Basic Machine Learning Cloud (Basic Exposure): Azure, Google Cloud Platform Project & Workflow: Agile, Process Automation

Soft Skills: Communication, Team Collaboration, Problem Solving Projects:

Fleetcor Project: Data Engineering & Revenue Growth

• Developed ETL pipelines using SQL Server and SSIS to process billions of rows, enhancing data retrieval efficiency.

• Built customer segmentation models with SQL and Power BI, increasing cross-selling effectiveness by 15%.

• Conducted impact analysis using logistic regression and ARIMA forecasting in R, improving retention by 10%. Port Authority: Integrated Forecasting & Traffic Analysis

• Processed 150+ datasets to build a predictive model for transit demand, improving scheduling accuracy by 12%.

• Implemented ETL workflows with SQL and Power BI, reducing data processing time by 25%.

• Forecasted 3,913 bus departures for 02/26/2024 and 125,022 passenger departures for 06/23/2025.

Contact this candidate