Python, machine Learning, SQL, MS Excel, Tableau

Mayank Thapliyal

469-***-****; *********@********.***

www.linkedin.com/in/MayankThapliyal24

https://github.com/mayank2404

EDUCATION

The University of Texas at Dallas May 2021

M.S., Business Analytics (Data Science Track) GPA – 3.6 Scholarship – Dean’s Excellence Scholarship

Graphic Era University, Dehradun, India August 2014 B.Tech, Electrical and Electronics Engineering

TECHNICAL SKILLS

Languages & Libraries: Python, C#, SQL, R, Unix shell scripting, SAS Base, Pandas, Tensor Flow, Matplotlib, NumPy, Scikit-learn Databases & Services: MS SQL Server, MySQL, Amazon Web Services, MongoDB Data Analytics: Statistical Analysis, Hypothesis testing, Data Mining, Predictive Modelling, Time Series, Regression, SVM, Decision Trees, Random Forest, KNN Classifiers, Ensemble Models, Deep Learning Tools: Tableau, Jupyter Notebook, MySQL Workbench, JIRA, Visual Studio, SharePoint, MS Office, R studio, Git BUSINESS EXPERIENCE

Cognizant Technology Solutions, Bengaluru, India April 2015 – September 2018 Programmer Analyst

Domain: Legal Research & Human Resources

• Created and maintained metrics dashboards to monitor incoming tickets & ‘service-level agreement’ breach by application maintenance team, resulting in cut down of breach occurrences by 40 %

• Manipulated, cleaned and transformed customer datasets in 100 Gigabytes range from multiple RDBMS data sources, analyzed them to generate analytical insights using SQL and Pandas, which aided client in taking critical business decisions

• Diagnosed and repaired major bugs in critical HR applications using finely tuned SQL queries to improve existing Stored Procedures which reduced technical incident count by 20 %

• Designed SQL macros to streamline repetitive data processing operations, resulting in increased efficiency by 15 %

• Mentored a group of seven trainee employees, trained them in Tableau, SQL & Scrum methodology Programmer Analyst Trainee

• Designed important features for client’s web application, resolved performance-based issues significantly

• Refactored critical web application modules and documented the process, which improved code readability by 22 % ACADEMIC PROJECT

Airbnb price & Local income prediction, UT Dallas February 2020 – March 2020

• Implemented machine learning regression models on Airbnb dataset to predict price & classification models on Local dataset to predict income category, efficiently used Gridsearch and Cross-validation for hyperparameter tuning & generalization

• Obtained nearly perfect model for classification problem with Decision Tree model obtaining accuracy of 84%, and received bonus marks for on point and creative visualization US Wildfire Database, UT Dallas March 2020 – June 2019

• Created database model in 3rd normal form for US wildfire data including 1.88M geo-referenced wildfire records representing a total of 140 million acres burned during the 24-year period

• Queried and managed tables using tuned SQL queries, functions and joins for data extraction and analysis COMPETITIONS, LEADERSHIP & ORGANIZATIONS

NGO ‘Karma Yogpeeth’ – Web designer October 2018 – March 2019 Outreach, Cognizant – Event coordinator August 2017 – June 2018

Contact this candidate