Hello I'm

Pratish Nagvekar

- Data analyst

About Me

I am a bachelor in Mechanical engineering with working experience of two years in industrial companies like Colgate and Finolex. Previously I worked as production team leader where I practiced process improvement methods like Root cause analysis, Kaizen, 5s, OPL etc. This is where I was introduced to concepts of data collection and analysis.

I found working with data and obtaining insights from the analysis interesting and inspiring and hence I decided to get into the field of data analytics.

I have recently completed Google Data Analytics Course, Google Finance Data Analyst Professional Certification, SQL - MySQL for Data Analytics and Business Intelligence Certification and Microsoft Power BI Desktop for Business Intelligence Certification. I'm looking for work specifically into Bussiness intelligence, Financial services related fields where I believe has my highest interests.

Projects

These are some of the work I have done related to Data analytics demostrating skills like ETL process, data cleaning, data management, presentations, visualization, dashboards using tools like MySQL, Power BI, R Programming, Excel, Google sheets, Tableau etc

Optimizing Last-Mile Delivery Planning for Cost Reduction

Optimized the operational cost of delivering packages to remote areas in the country up to 30.14% by making sure baseline process is being followed, identifying clusters, branches and partners with excessive overpayments, and reducing baseline cost further by implementing insights from analysis using MySQL and Power BI 

• Data Transformation, Exploratory data analysis using SQL

• Interactive Dashboard Reports for CEO, finance team and Management

• Data Storytelling using Power BI

Atliq Mart Supply Chain Project

Atliq Mart company lost key customers due to drop in Product delivery service levels. Developed a dashboard to analyze performance of major Logistics KPI's.

Objective: 1. Create a Dashboard to demonstrate analytics across all major logistics KPI’s

2. Find out which are top customers and which customers suffered the most

3. Find out how bad is the service level

Bike sharing capstone

In 2016, Cyclistic launched a successful bike-share offering. Since then, the program has grown to a fleet of 5,824 bicycles that are geotracked and locked into a network of 692 stations across Chicago. Lily Moreno is the director of marketing. Annual members are much more profitable than casual riders and Moreno believes that maximizing the number of annual members will be key to future growth of the company

Bellabeat FitBit Fitness Capstone project

Bellabeat, a high-tech company that manufactures health-focused smart products. Collecting data on activity, sleep, stress, and reproductive health has allowed Bellabeat to empower women with knowledge about their own health and habits.

Interested to work with me?

Drop a message to [email protected]