RAJATH SIMHA RAVISHANKAR

+1-469-***-**** adbbso@r.postjobfree.com https://www.linkedin.com/in/rajath-simha-54b96b78 SUMMARY

4+ years’ experience in Analytics, Data Science and Business Intelligence in multiple domains. Leveraged advanced analytics and dashboarding to present key insights and compelling stories to help make informed business decisions. EDUCATION

Master of Science, Business Analytics– The University of Texas at Dallas Aug 2016 - Jun 2018 Coursework: Statistics, Machine Learning, Big Data Analytics, Business Analytics with R & SAS. GPA: 3.54 Bachelor of Technology - Visvesvaraya Technological University (VTU) Aug 2009 – May 2013 PROFESSIONAL EXPERIENCE

Ford Motor Company, Michigan, USA Jul 2018- Present Senior Data Analyst

• Implemented and Automated ETL workflows to land, Stitch & Transform data into Hadoop Data lake for analytical purposes and work as a Data Steward using Alteryx, Python & Sql

• Constructed an XGBoost model to predict the cost of variable marketing & validate the same using appropriate visualizations for various cars achieving 87% accuracy.

• Profiled, Analyzed and Resolved Data quality using advanced querying and analytical tools like Python and Alteryx.

• Working on Master Data Management system as a part of SAP implementation for Global Data Insights & Analytics.

• Worked on building a time series forecasting ARIMA model in Python to predict losses incurred by Peoplesoft.

• Built Data warehouse by creating normalized data models in Qlikview to reduce the time for reporting.

• Identifying kpi’s using Tableau and Power-Bi and presenting the insights as a part of vehicle safety analytics. Southwest Airlines, Dallas, USA Sep 2017- Dec 2017 Data Analyst Intern

• Developed a predictive maintenance simulation model on R for flight sensors to reduce aircraft downtime by 13%

• Automated, aggregated and reported DMI data of Boeing 737- 800 on Alteryx and Tableau reducing the load time by 40%

• Identified cross-functional gaps by performing sentiment analysis on twitter data using Text analysis(NLP) in Python Nationstar Mortgage, Dallas, USA May 2017- Aug 2017 Data Engineer Intern

• Designed and implemented a statistical model in R from scratch to increase the claim paid amount by 30%

• Delivered an end to end project including data transformation and dynamic reporting in Power-BI creating DAX functions

• Re-engineered the lone state transition model from SAS to R to run it on Azure to decrease the run time by 60% Expicient Software Pvt Ltd, Bangalore, INDIA Jul 2013 – Jul 2016 Senior Consultant

• Implemented Order Management systems including Data Modelling, Analysis and Reporting for retail modules

• Developed SQL scripts to create and populate tables in data warehouse for daily reporting purpose.

• Created cross functional supply chain visualizations to present the insights to clients using Tableau.

• Assisted in building a classification model to predict the sourcing & scheduling rules using IBM Sterling. ACADEMIC PROJECTS

Business Analytics with SAS, UT Dallas

• Built a model to improve the customer retention by focusing on churn rate of telecom customers using SAS E-miner. Business Data Warehousing, UT Dallas

• Designed an application in Qlikview and SAP Hana including Data Modelling, Data Warehousing using the semantic layer. Data Visualization, PepsiCo

• Provided logistic solutions to Pepsico.com by reducing the distance by generating suitable dashboards in Tableau Machine Learning, UT Dallas

Implemented an ensemble model to reduce the misclassification error by 4% on the online news popularity dataset TECHNICAL SKILLS:

Certifications: Tableau 10, Python, Machine Learning, R Programming, Programming in SAS Base from Udemy. Analysis Tools: SAS Enterprise Miner, Base SAS, Alteryx, Python Languages: R, SAS, Python (Numpy, Pandas, Scipy, Matplotlib, scikit, PySpark, nltk). Big data: Hadoop/HDFS, MapReduce, Sqoop, Hive, Spark, Kafka. Statistics: Hypothesis testing, Time Series Analysis, Regression analysis, ANOVA, t-Test. Machine Learning: Random Forest, Bagging, Boosting, KMeans & Hierarchical clustering Databases: MS SQL Server, Oracle, My SQL, Teradata, Basics of No Sql(Mongo DB) Business Intelligence: Tableau, Power BI, Qlikview, Informatica.

Contact this candidate