Data State University

********@*******.*** ANKUSH RASTOGI **** Lincoln Swing

515-***-**** https://www.linkedin.com/in/ankushrastogi Ames, IA 50014 PROFESSIONAL SUMMARY

EDUCATION

Iowa State University, Master of Science, Management Information Systems,(STEM Major), GPA: 3.7 (Expected) Dec 2017 Jaypee University of Engineering and Technology, Bachelor’s, Mechanical Engineering 2008 - 2012 TECHNICAL SKILLS

Machine Learning Algorithm: LDA, Regression (Linear, Multiple, Logistic), KNN Descriptive Statistics: ANOVA, hypothesis testing, Predictive modeling Predictive Analytics/Data Mining Tools: Weka, R, MS-Excel Programing Languages: SQL, CSS3, HTML, C#, JavaScript Databases: MS SQL Server, Oracle, MySQL, MS-Access Tools: Visual Studio, SSMS, SSIS, JIRA, Visio, Tableau INTERNSHIP EXPERIENCE

Analytics/SQL Programmer Intern, GuideOne Insurance, Iowa May 2017 - Aug 2017

• Designed master data for predictive analytics using SQL Server and SSIS and optimized SQL scripts

• Created SSIS Packages to extract data from excel files, OLE DB Sources, MS Access files using Lookup, Derived Columns, Condition Split, Execute SQL Task, & Data Flow Task to generate data for the predictive data modeling

• Collaborated with the predictive analytics team to help with data planning and management. PROFESSIONAL EXPERIENCE

Research Assistant and Teaching Assistant, Iowa State University, Iowa Jan 2017 - Present

• Analyzed students’ data to investigate organizational climate for STEM underrepresented students

• Designed robust data model and automated data load process as per the principle investigator’s requirements

• Collaborated with nine universities to provide workflow insights to National Science Foundation (NSF)

• Teaching lab sections to computer science students to build advanced skill-set in MS Excel and MS Access Data Analyst/ Senior Systems Engineer, Infosys Limited, India Jun 2013 - Jul 2016

• Analyzed data using R and developed reports using Tableau improving project profitability by 10 %

• Performed market analysis to effectively achieve given objectives and presented the report to the marketing and product team; helped in increasing the product usage by 5% in various geographies

• Generated reports using MS Excel; created pivot tables and charts for inventory decision making

• Coordinated with 5 team members to perform software development life cycle process

• Implemented data models, composed complex stored procedures, and User Defined Functions

• Developed web pages and performed data scraping independently using HTML 5.0, JavaScript, style sheet, .NET

• Received “Star Performer Award” for consistent performance over the course of 2 years ACADEMIC PROJECTS

Big Data Analytics Nov 2016

• Analyzed data in R, Excel, Watson Analytics, and Tableau to recommend future bike station to increase profit by 13%

• Developed Multiple Linear Regression models to identify profitable locations Analysis of Lending Club Data Mar 2017

• Conducted an exploratory data analysis for lending club loan data with 2 Million records and 150 dimensions

• Developed logistic regression model for understanding credit worth factors using Microsoft R, Tableau Iowa County Data Analysis Sep 2017

• Examined Iowa State’s county data by exploratory data analysis and created Pearson correlation matrix to find the correlation of Actual per capita Medicare cost with respect to 240 predictors

• Performed regression analysis using R to establish eight significant predictors that highly impacted the actual per capita cost and visualized using Tableau to provide relevant business insight

• 3+ Years’ Experience • Database Management • Data Analysis • Data Visualization

• Leadership Skills • Team Player • Predictive Modeling • Development

Contact this candidate