Sign in

Data Analyst

Tempe, Arizona, United States
February 02, 2018

Contact this candidate

Nilesh Chekkala

**** * ********** **. *** 1013H Tempe AZ 85281. 480-***-****. WORK EXPERIENCE

Arizona State University, Arizona October 2016-Present Data Acquisition and Analyst

Acquired data from the vendor websites and performed analysis to generate insights on the justification of annual budget.

Extracted the regression patterns of E-books and journals usage data for fiscal year 2016-17 to help forecast decisions on increasing/decreasing usage limit of 40 vendors.

Carried out data manipulation, data cleaning, dealt with missing records, purged and consolidated data for analysis and selected the appropriate visualization techniques; developing reports and communicating insights. Meghna Enterprises, Mumbai May 2016 -July 2016

Operations Analyst Intern

Reduced inventory levels by 15% by analyzing data from vendors about customer preference and market demand.

Coordinated product shipments to achieve cost reduction and enable a high customer service level. Setco Automotive Ltd., Gujarat January 2016 - April 2016 Graduate Intern

Performed ‘Time and Motion Analysis’ on the 380 Assembly line confirming potential for 22% production rate increase.

Implemented inventory control and process improvement activities linked with Line balancing. NIK Interiors, Mumbai July 2014 - September 2015


Developed solutions for optimal lot sizes for construction materials to obtain demand quantities which reduced the storage cost by 16% overcoming the inflated costs for procurement and setup.

Analyzed data using VLOOKUP and pivot tables to forecast project cost with categorization of expenditure, project completion date and a Gantt chart defining real time scheduling and future actions.

Initiated a culture of introducing the clients with visually impactful dashboard with Excel with flexibility for dynamic change of plans. This lead to 20% rise in new project offers for the year 2015. EDUCATION

Master’s in industrial engineering (Specialization: Industrial Statistics)

Arizona State University, USA Anticipated May 2018 Bachelor of Science in Mechanical Engineering

University of Mumbai, India June 2015


Design and Analysis of Engineering Experiment November 2017-December 2017

Designed experiment to assess the clarity of the photographic images using One Quarter Factorial Design (Resolution IV).

Concluded and defended the resulting significant factors, model adequacy checks and the residual analysis using R. Data Mining and Classifier Selection August 2017-September 2017

Investigated training dataset to extract patterns using SVM, ANN and Clusters with minimum balanced error rate(BER).

Developed a model with a test data accuracy of 93% with BER of 9% for each of 3 classes of the response variable. Statistical Modeling and Regression Analysis February 2017-April 2017

Performed Logistic regression analysis using R to explain the relationship between variables under considerations.

Obtained Adjusted Rଶ value of 91.2% and the significant factors to take care of energy efficiency in future. Phoenix (Arizona) Airport Relational Database Management System formation Systems Engineering)January 2017-March 2017

Generated a database management system in VBA integrated MySQL using ODBC 5.3 ANSI Driver and created a server.

Designed and Populated specific tables, databases for collection, tracking and reporting of data. Design and Optimization of a Board-game Manufacturing Plant November 2016-January 2017

Computed and Analyzed manufacturing costs, holding costs, optimization of the bottle-neck operations, concerned logistics involved and making decisions of whether to outsource an item of the game set. These results nursed to optimize the sole objective of minimizing the cost of producing a single gaming-unit and a lean manufacturing and assembly line.

Recuperated the production flow to slash the overall cost of production unit by 27% Facility Layout Planning of a company in Las Vegas (Applied Deterministic Operations Research) October 2017-November 2017

Fetched data by generating an API of google maps for shortest distance between 2 zip codes in VBA Excel.

Built mathematical models in AMPL, solve for MIPs using CPLEX and built efficient model based on heuristics. The results unfolded the appropriate facility locations and minimized the objective function to a global minimum. CERTIFICATIONS AND SKILLS

Data Visualization and Communication with Tableau

Excel to MySQL: Analytics Techniques for Business Specialization (Managing Big Data with MySQL)

Programming Languages: JAVA, R (ggplot2, caret, dplyr), Python (Numpy, Pandas, Mathplotlib, Scikit-learn), XML

Software Tools: Microsoft Excel (3 years), MySQL, Teradata SQL, Tableau (1 year), Weka, Minitab, AMPL, SolidWorks

Contact this candidate