Data State University

Piyush Gupta

****, ********** *****, ***** *****, CA-95050 206-***-**** ******.*****@*******.*** www.linkedin.com/in/piyushgupta Core Competencies

Certifications: SAS Statistical Business Analyst Certification, Google Analytics Certification, Customer Analytics(Wharton School) Data Mining & Visualization Tools: SAS 9.4, SAS EG, SAS EM, IBM SPSS Modeler, Tableau, R (Matplotlib, ggplot) Programming Languages for Analytics: SAS, R, Python (Numpy, Scipy, Pandas), SQL, SQL for SAS Databases: SQL Server Management Studio, Visual Studio Statistical & Machine Learning Techniques: ANOVA, Regression, Decision Tree, Neural Network, PCA, Segmentation, Clustering Education

Master of Science in Management Information System (Data Science & Analytics) Dec 2016 Spears School of Business, Oklahoma State University, USA GPA 3.38 Courses: Data Mining, Database Marketing, Business Intelligence, Statistics, R & Python Programming, Database Management System Bachelor of Engineering in Electronics and Communication May 2014 Rajiv Gandhi Technical University, India GPA 3.70

Work Experience

Data Analyst (Quantitative Intern) May - Aug 2016

Oklahoma State University Foundation, Oklahoma City, OK

• Used my innate curiosity to ask the right business questions on the huge Stock Market and Donor Databases, to find viable solutions and optimize the Investment Decision Making for the Organization using Statistical & Predictive modeling techniques

Manipulation and Preparation of large datasets using SAS codes and checked the integrity of the data

• Performed Data Wrangling on the Donor Data, to assist the Marketing Team in creating effective Marketing Campaigns

Reduced the potential risks for the foundation by performing Predictive Modeling using Statistical techniques such as Decision Tree, Linear and Logistic Regression on the stock market to understand the impact of various stock market metrics

Identification of the potential donors and tracked the donor behavior from the Donor Database using Segmentation techniques

• Transformed the complex statistical findings and insights into understandable managerial reports

• Visualized the trends in the donor data through charts, bar graphs and effective Tableau dashboards Junior Data Analyst July 2014 - May 2015

Abhyudaya Multimedia, Indore, India

Performed Descriptive Analytics of the client’s data and presented in the form of Tableau visualizations

Collaboratively performed special projects and ensure the successful delivery to the clients within tough deadlines

Communicate with the clients to gather the analytics requirements and ensure the successful delivery of the projects Paper Publication

Analysis of the Domestic Flight Delays in the USA, SAS® Users Conference at San Antonio Sep - Nov 2016

Performed extensive research to understand the combination of significant weather factors that cause delays

Merged the 3.2 million rows for the open flight delays data and the weather data using SAS Enterprise Guide and Miner

Analyzed the factors responsible for the delayed flights for the five busiest airports and carriers using machine learning techniques

Please read the paper at http://www.scsug.org/wp-content/uploads/2016/11/An-Analysis-of-Domestic-Flight-Delays-using-SAS.pdf Analytics Projects

Prediction of the Stock Market Returns and Potential Donors, OSU Foundation May - July 2016

Presented optimal investments solutions for the donor money by developing a predictive model using the historical returns data

Leverage Data mining to predict the stock market returns and the significance of market metrics on one to five yearly returns Analysis of the Credit Worthiness of the new Loan Applicants using R, Oklahoma State University Aug - Dec 2016

Leveraged R Programming on the 5 years of Lending Club Loan Open Data to explore the primary reasons for the loan charge off

Build two Predictive Analytics models using Logistic Regression & Decision tree technique to predict the potential loan defaulters

Achieved a high predictive power using Stepwise Linear Regression to predict the Interest Rate for the loan applicants Volunteer Experience

Data Analyst, Center for Health Systems Innovation Sep 2016

Analysis of the Cerner Health Facts datasets to find the impact of Cancer and Heart disease on the Health Insurance claims using R

Contact this candidate