857-***-**** e-mail: email@example.com LinkedIn : https://www.linkedin.com/in/sudeep-kapadnis
Certified Six Sigma professional with knowledge of Supply Chain Engineering Management, Data Analysis and Reporting focused on solving complex business problems using data-supported results.
MS Excel – LOOKUP, Pivot Tables, Dashboard SQL R
Google Data Studio Tableau
IISE Six Sigma Green Belt Certificate (CSSGB) LEAD360 Graduate Leadership Certificate
Data Analyst – Indigo Agriculture, Boston, MA August 2018 – current
Facilitated accurate payments to Indigo Agronomists by designing Google Data Studio dashboards that indicate live update of amount and category of data input by them.
Generated Live Dashboards to indicate crop harvest progress by region to indicate visually the number of harvested, non-harvested and failed crop acres in categorical manner.
Reconciled data from multiple sources such as Google sheets, SharePoint and Salesforce using R and MS Excel.
Maintained data consistency in Google sheets which were the live data management platform.
Presented findings on limitations of Google Data Studio and supplemented the need for another Visualization tool.
Master of Science in Engineering Management (GPA 3.5/4) September 2016 - May 2018
Northeastern University Boston, MA
Sourcing and Procurement Supply Chain Engineering Database Management and Design
Probability and Statistics Operations Research Collection Storing and Retrieval of Data
Economic Decision Making Engineering Project Management Fundamentals of Business Analysis
Bachelor of Engineering in Mechanical Engineering July 2011 - June 2015
University of Pune MH, India
GRADUATE PROJECTS and CERTIFICATE
Design of a database for a health insurance company November 2017
Modeled the database with Toad data modeler 6.1 to include insurance claim pathway from subscriber to insurance
company via healthcare provider to be triggered in case of occurrence of medical event.
Created database with MS SQL Server and tested the database’s functionality with sample data.
Salary prediction using regression model November 2017
Imported dataset with employees and their salaries and stored it in a database using R.
Retrieved data applying SQL queries on stored dataset and generated simple linear regression model to predict salary against number of years of experience.
Displayed prediction results for each continent separately using ggplot2.
Analysis of correlation between film ratings and ratio of gross income to budget August 2017
Web-scraped data using R Studio and also mastered ParseHub and import.io web-scrape tools.
Generated histograms and scatter plots for visualization of frequency distributions of films success over ratings.
Conducted Pearson’s correlation test on film ratings and income to budget ratio, and found it insignificant (< 0.1).
Economic Worth comparison of three equal investment businesses with MS Excel April 2017
Estimated net worth of each proposal in terms of Net Present Values, Payback Period, and Rate of Return.
Saved close to $1.86M and $4.39M in cost over other models by selecting the most economically viable business after conducting Regression analysis, Risk analysis and Analytic Hierarchy Process on after-tax cash flows.
Presented results for 3 business models with MS PowerPoint and Excel dashboard
Certificate for Commendable Supply Chain Management March 2018
Secured 5th rank among 18 teams at 2nd intercollegiate competition conducted by the Institute for Supply Management.