MOHIT JAIN

ac3783@r.postjobfree.com; +1-469-***-****

https://www.linkedin.com/in/mohitjain1219

EDUCATION

The University of Texas at Dallas May 2018

M.S., Information Technology and Management GPA 3.90 Jaypee Institute of Information Technology, India June 2013 B. Tech, Electronics and Communication Engineering GPA 8.1 TECHNICAL SKILLS & TOOLS

Programming: SQL, SAS, R, SAP ABAP, JavaScript, VBA, Powershell Software: SAP, ERP, SharePoint, Salesforce, CA ERWin, BMC Remedyforce Analysis Tools: Tableau, QlikView, Power BI, SAS EM, SSAS, SAP Business Objects, MS Power Query, MS Excel, D3.js Databases: MS SQL, MS Access, HANA Database

BUSINESS EXPERIENCE

The University of Texas at Dallas, Dallas, USA

Graduate Teaching Assistant August 2017 - December 2017

• Mentor 100+ students on individual and small group basis to reinforce learning concepts involving QlikView development and SAP HANA modeling

• Developed, administered and corrected assignments in a timely manner to assist professor Vizient Inc., Irving, USA

Business Intelligence and Operations Intern June 2017 - August 2017

• Created complex SQL scripts for analysis and extraction of quarterly business intelligence report for business members

• Performed cleaning and blending of data coming from multiple sources, to create compelling dashboards and reports in Tableau which helped in making data-driven business decisions

• Automated various tasks in Exchange by developing powershell scripts resulting in streamlined business process

• Decreased incident raise rate by 20% by providing effective user education to business counterparts in a 3-month period Accenture, Pune, India

Software Engineering Analyst August 2013 - July 2016

• Analyzed and performed proof of concept for designs involving technical feasibility test and mock developments

• Trained 15 new employee in CRM processes, technically guided and resolved their queries

• Conducted brown-bag sessions on technical and business master data creation which significantly reduced inter team dependencies

• Generated custom reports summarizing sales data for review by executives and clients using MS SQL, SSAS and Excel

• Reduced manual work by 50% by creating an Excel VBA program to automatically assign work on a daily basis PROJECTS

Data Analytics for Expedia (using R and SAS) August 2017 - December 2017

• Designed a predictive model to predict whether a customer is going to make a booking through Expedia or not

• Optimized the data by sampling unbalanced data, removing outliers, handling skewness and correlation among variables

• Implemented classifiers like SVM, Naïve Bayes and K-means clustering for classifying potential customers

• Utilized model enhancement techniques like bagging, boosting and ensemble for increasing model accuracy Predicting Online News sharing (using SAS EM, R and Power BI) January 2017 - May 2017

• Analyzed data and performed data cleaning, data exploration and data imputation activities to bring the dataset to a consistent stage

• Built data models using Regression, Clustering, Decision Trees, and Random Forest techniques to determine major contributing factors for online news sharing

• Predicted the number of times an article will be shared on social media by narrowing down top 10 attributes (among 61) based on significance level

Airline Database Management (using SQL Server and CA ERWin) August 2016 - December 2016

• Designed ER model in ERWin to accommodate business requirements for an Aviation company

• Implemented functionalities like reservation and cancellation for customers by creating SQL Server database

• Developed Stored Procedures, CTE and views for determining total cost of the ticket and duration of flight Twitter Sentiment Analysis (using SAP HANA and Tableau) August 2016 - December 2016

• Performed sentiment analysis of twitter data on the new iPad pro and surface pro 4 using Twitter API and SAP HANA database by creating analytic views and custom dictionaries

• Visualization of the acquired data was done by designing dashboards and reports in Tableau ORGANIZATIONS

Bulletin Officer at SAP Users Group, UT Dallas August 2016 - Present

Contact this candidate