Sign in

Data Analyst

Arlington, TX
January 10, 2020

Contact this candidate


Suyog Ghungrad +1-312-***-**** Arlington, TX


University of Illinois At Chicago, Chicago, USA Aug 2017 - May 2019

Master of Science in Industrial Engineering (GPA: 4.0/4.0)

National Institute of Technology, Surat, India July 2013 - May 2017

Bachelor of Science in Mechanical Engineering (GPA: 3.4/4.0)


Software Tools: Minitab, MS Excel, Python Jupyter, Teamcenter, Salesforce, MS SQL, SIMIO, Tableau

Language: Python, SQL, R

Excel: Pivot Tables, V-lookup, Macros, Data analysis (regression, ANOVA), Solver

Python: Numpy, Pandas, Scikit-learn, Matplotlib, Seaborn, Keras, SciPy, Networkx, Object-Oriented Programming

Relevant Courses: Operations Research Supply Chain Mgmt. Operations Mgmt. Stochastic Processes Data Science

Additional Certifications: Machine Learning (Coursera), Certified Six Sigma Green Belt (CSSGB)


Data Analyst -World Bicycle Relief, Chicago, IL. Nov 2019 – Dec 2019

oIndependently cleaning, migrating and updating database within salesforce for non-profits.

oValidated the accuracy of the data in the salesforce.

oCreated ad-hoc reports for marketing teams.

Graduate Research Assistant – University of Illinois At Chicago July 2019 – Present

oApplication of a travelling salesman model to a laundry collection problem (UIC): Optimized the route followed or path covered by employee in equipment room at UIC flames athletic center by 28% using Tabu search method.

oCreated presentations, demonstrations, and homework for lab sessions for ‘Plant Layout’ class on SIMIO software.

oTutoring a sales manager professional for Supply Chain Management online certification.

oParticipating in Simio December 2019 Student Competition on “Regional Airport Passenger Experience Improvement”.

Industrial Engineering Intern - Federal Mogul Corporation, Skokie, IL. Feb 2019 – May 2019

oIdentified potential buy-to-make savings of around $1 million as first year savings by data mining and analyzing data obtained from multiple source (Oracle, access, excel, file maker) using Excel (advanced functions).

oActively collaborated with value stream managers, process and product engineers, purchasing and marketing managers and product analyst for B2M and B2B projects by weekly meetings and kept track of projects through FileMaker Pro.

oIndependently identified potential savings of $300,000 as first year savings for supply chain department.

oPerformed ad-hoc reporting, verified and updated database for on-going projects in FileMaker Pro.

Graduate Teaching Assistant - University of Illinois At Chicago Aug 2018 – Dec 2018

oReported to Director of Graduate Studies as teaching assistant for the seminar course (ME/IE 595) in the mechanical and industrial engineering department.

oGenerated reports on student’s surveys about the guest speaker using Python and Excel.

oDeveloped and presented reports with simple visualization for comparison of working hour trends over time in Excel.


1.Minimizing churn rate through analysis of financial habits: data-preprocessed by one-hot encoding, feature scaling and balancing, feature selection, k-fold cross validation and model building (Logistics Regression) in Python.

2.Factors affecting Operating Cost in Supply Chain in Root beer game: Performed full factorial experiment to screen initial factors that affect operating cost and analyzed the effect across supply chain (Bullwhip Effect). Predicted operating cost with 92.52% based on linear regression model that used lead time and position of echelon as factors in Minitab.

3.University Health Services: Walk-In Clinic Case Study: Created process flow diagrams for calculating process flow time and waiting times for patients of UHS at Harvard for pre-triage & triage system.

4.Designed Optimization Algorithm: Created a model for simulated annealing (SA) in jupyter notebook with object-oriented programming to find the minimum value of objective function which had 10 million total combinations in the total enumerations.

5.Forecasting and Procurement at Le Club Francais du Vin: Forecasted demand for next year for different types of wine using different qualitative methods like moving average and A/F ratio.

6.Vehicle Service project: Using SSIS uploaded more than 1 million rows in SQL with cleaning, filtering and quality assurance checks.


oAwarded a full fees waiver for outstanding academic performance at the University of Illinois at Chicago for the year 2018.

Contact this candidate