Resume

Sign in

Data Analyst

Location:
Edison, New Jersey, United States
Posted:
February 02, 2019

Contact this candidate

Resume:

SUDEEP KAPADNIS

857-***-**** e-mail: ac8djp@r.postjobfree.com LinkedIn : https://www.linkedin.com/in/sudeep-kapadnis

SUMMARY

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.

SKILLS

MS Excel – LOOKUP, Pivot Tables, Dashboard SQL R

Google Data Studio Tableau

IISE Six Sigma Green Belt Certificate (CSSGB) LEAD360 Graduate Leadership Certificate

WORK EXPERIENCE

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.

EDUCATION

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.



Contact this candidate