Experience
Mohitkumar Dhiman
3000 Greenridge Dr, Apt 2106, Houston, TX - 77057
860-816-6743
mohitkumar.dhiman@uconn.edu
https://www.linkedin.com/in/mohitkumardhiman https://github.com/Mohitkumar2020
Summary: Analytical problem-solver, data-driven decision-maker, and an effective communicator having 3+ years of work experience in Data Analytics and Business Intelligence. Proficient in Python, R, SQL, Tableau, Business Analysis, and Modeling Techniques.
EDUCATION
University of Connecticut School of Business, Hartford, CT, USA GPA: 3.8/4.0
Master of Science in Business Analytics and Project Management May 2020
Coursework: Statistics with R, Data Science using Python, SQL, Big Data with Hadoop, Financial Analytics, Business Process Modeling
Nirma University Institute of Technology, Gujarat, India GPA: 7.7/10.0 Bachelor of Technology in Instrumentation and Control Engineering May 2016
TECHNICAL SKILLS
Programming Languages: Python (Pandas, NumPy, Matplotlib, Seaborn, Keras, Scikit-Learn), SQL, R, SAS, C++, Pig, Spark, Hive
Tools: Tableau, Advanced Excel (VLOOKUP, Pivot Table, Power Pivot, VBA), Power BI, Google Analytics, MS Visio, MS Project, MS Office Tools, SSIS, SSRS, SSAS, Jupyter Notebook, SAS JMP, SAS Enterprise Miner
Databases: Oracle 11g, Microsoft SQL Server, Teradata, MySQL, Hadoop, Snowflakes, Amazon Redshift, AWS S3
Statistical Analysis: Clustering, Linear and Logistic Regression, Decision Trees, Random Forest, Neural Networks, GBM, SVM, Principal Component Analysis, Time-series forecasting, ARIMA, A/B testing, Chi-Squared test, Hypothesis Testing, Text Analysis, Optimizations (Linear and Non-linear), Market Basket Analysis, Web Analytics, Segmentation, Customer Analytics, Financial Forecasting
Project Management: Scoping, Client Relationship, Risk & Cost Management, Change Request, Agile – Scrum, JIRA
EXPERIENCE
Connecticut Computer Services Inc. – Data Analyst, Rocky Hill, CT, USA Jun 2019 – Aug 2019
• Analyzed the behavior of fitness club members including financial activities, demographics, check-in counts, membership types using SQL Server; built productive-level attrition model to predict the active-member duration using Python improving the overall efficiency of monthly attrition report by 30%
• Used Market Mix Modeling techniques, analyzed the effectiveness of ad spend in marketing channels to acquire new members
• Used Power BI to generate reports and analyze member behavior and financial trends
Capital Community College – Marketing Analyst, Hartford, CT, USA Feb 2019 – May 2019
• Applied Machine Learning models using student data to predict and improve student retention and provided recommendations to improve retention from 47% to 55%
• Built ETL data pipelines using SQL to extract data from multiple sources and integrating and loading them into the data warehouse
• Used Google Analytics and A/B testing to increase viewership of the college website and the application process completion by 20%
Tata Consultancy Services – Data Analyst, Pune, India Jun 2016 - May 2018
• Developed an Excel-based VBA tool to automate daily status reports reducing the report generation time by 75%
• Created data models and analyzed big data to build a dynamic reporting tool which can be modified easily as per the user’s requirement using Microsoft Business Intelligence tool: Power Pivot and VLOOKUP
• Worked in collaboration with the product owner on an agile team in establishing User Requirement Documents, Functional Specification Documents and in creating user-stories; worked closely with development teams to ensure accurate implementation
LEADERSHIP AND ACHIEVEMENTS
• Vice President, Education | UCONN School of Business Toastmasters
• Certifications: Data Visualization and Communication with Tableau, Managing Big Data with MySQL, Python for Data Science and ML Bootcamp, L