RAJDEEP GUPTA

Tempe, AZ ***** 480-***-**** https://www.linkedin.com/in/rajdeep-gupta-1b4622b4 aczgp3@r.postjobfree.com

Skills: -Regression analysis -Data mining -Database Management -Design of Experiments -Enterprise Modelling

-Data visualization -Data modelling -Six Sigma methodology -Data Warehouse -Advance quality control

Software & Tools: MySQL, Weka, TABLEAU, R, SAP, XML, Python, MYSQL, AMPL, VISUAL BASIC, MS Office (Word, Excel, PowerPoint, Access), JMP, Solid works, Auto-CAD, Pro-E, JAVA

EDUCATION

Arizona State University Uttar Pradesh Technical University (UPTU) Master of Science, Industrial Engineering Bachelor of Technology, Mechanical Engineering

August’15 - May’17 August’10 - May’14

WORK EXPERIENCE

Supply chain Analyst (SG Enterprises) July’14 -July’15

Performed market analysis to efficiently achieve objectives an increasing the sales by 30%.

Used Microsoft excel to create pivot table, MACROS, VLOOKUP for data extraction from large dataset.

Analyzed more than 1000 contacts in spreadsheet and successfully drawing conclusion about supplier data.

Extensively used SQL Server for data extraction and Tableau for data analysis, visualization and reporting.

Forecasted sales to optimize inventory space utilization.

Data analyst Intern (Indian army workshop) June’13-August’13

Worked in a team to complete project ‘Processing and testing of Tank T-72’ and presented report.

Performed data queries using SQL and prepared reports on daily, weekly and monthly basis.

Managed database of more than 1000 vendors and produced monthly reports.

Data analyst Intern (Swadesh Engineering Industries) June’12- August’12

Created dashboard in excel and Tableau for data reporting. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful information.

ACADEMIC PROJECTS

Amazon employee access challenge (TOOLS USED- R, Excel)

Took a test data from UCI machine learning website.

Analyzed the data set, developed models to find the pattern in data using data mining techniques in R.

Predicted resource access using various supervise learning techniques such as decision trees, KNN, SVM.

Compared each technique based on accuracy and performance to get best model.

Classification problem for high dimensional dataset (TOOLS USED- WEKA)

Analyzed the given test data set to build final model using Random forest classifier.

Built a classification model for a 2-class data-set with 61 attributes using WEKA.

Calculated prediction with 86% of accuracy.

Design and analysis of bike rider’s comfortability (TOOLS USED- JMP, Minitab)

Collected data based on guidelines and principle of DOE for assessing comfortability of rider.

Identified the optimal levels of Significant Factors utilizing ANOVA, hypothesis testing and blocking.

Developed parameters and increase in satisfaction level by 30% using JMP and Minitab

Developed a decision support system for ASU (TOOLS USED- Visual Basic, Microsoft Access, My SQL)

Developed an ER model and relational model for database.

Designed and developed the database using SQL and MS-Access.

Formulated a Windows and Web-based user interface for the same using queries from MySQL and Visual Studio.

Development of model to enhance customer service in ASU (TOOLS USED: MySQL, Excel)

Analyzed data given by the department and developed Entity relationship model of the system.

Did root cause analysis of the system and found solution for it by generating “TO- BE model’.

Reduced the enquiry time by 37% and improved quality of customer service by 31%.

Manufacturing System analysis (Tools used- Excel)

Implemented the concepts of 'Group technology' and 'Flexible manufacturing system' to redesign the

existing manufacturing systems.

Applied the concepts of JIT, MRP, queueing analysis, Facility layout to reduce the cost of manufacturing.

Contact this candidate