Machine Learning, Power Bi, Python, R, Tableau

Mehul Gupta

312-***-**** ***********@*****.*** www.linkedin.com/in/mehul-gu-pta/ github.com/mgupta97 KNOWLEDGE BASE

Business Tools: SAP, Excel, Jira, Salesforce

Project Management Methodologies: Agile, Problem Solving, Risk Analysis, Project Documentation Data Visualization: MS Excel Pivot, Tableau, Power BI Technical Skills: ML, Python, SQL, R, Amazon Work Space (Sagemaker), PySpark, TensorFlow Libraries: Pandas, NumPy, Sci-Kit Learn, ggplot2, Matplotlib, Seaborn, Dash, Plotly EDUCATION

University of Illinois at Chicago Chicago, IL, US

Master of Science in Business Analytics (3.56/4) August 2021 – May 2023 Vellore Institute of Technology Vellore, Tamil Nadu, India Bachelor of Technology in Computer Science and Engineering (3.38/4) July 2015 – April 2019 EXPERIENCE

Sales Analyst May 2024 – Present

Crush It Enterprise Chicago, IL

• Developed predictive models to analyze sales performance, increasing revenue efficiency by 7%.

• Conducted Exploratory Data Analysis (EDA) on customer behavior to optimize pricing and marketing strategies.

• Utilized Python (pandas, NumPy) for data engineering (ETL), feature engineering, and forecasting.

• Created Tableau dashboards for real-time revenue analysis, driving a 6% increase in market share.

• Collaborated with pricing teams to automate sales forecasts and customer segmentation models. Research Assistant Aug. 2023 – May 2024

Department of Pharmacology, UIC Chicago, IL

• Applied statistical modeling (Python, R) to analyze complex biomedical datasets, improving efficiency by 15%.

• Conducted multivariate analysis and machine learning techniques to detect patterns in sequencing data.

• Developed ggplot2 visualizations for data-driven decision-making and academic publications. Data Analyst Aug. 2019 – May 2021

Roxy Delhi, India

• Built SQL pipelines to process and analyze large datasets, improving data reporting speed by 20%.

• Performed predictive analytics to optimize pricing and revenue management strategies.

• Designed Power BI dashboards for actionable business insights, improving decision-making efficiency.

• Conducted demand forecasting and customer segmentation, increasing profitability by 10%.

• Utilized Agile methodology to demonstrate expertise in industry analysis, ensuring timely delivery of business strategy, leading to a 10% increase in stakeholder satisfaction. PROJECTS

NBA Team Performance Analyzer Python, Dash, NBA API November 2024 – December 2024

• Built a Dash-powered dashboard to analyze and forecast NBA team performance (2000-2024).

• Conducting EDA, time series forecasting, and statistical modeling to predict future team rankings.

• Leveraging NBA API, Python (scikit-learn, pandas), and ML techniques for performance optimization. MBTI Personality Prediction Model Machine Learning, SVM, XGBoost, NLP Jan 2022 – April 2022

• Developed a machine learning model with 76.9% accuracy to classify personality types. [XGBoost, SVM]

• Engineered features using CountVectorizer, LabelEncoder, and NLP techniques for dataset optimization. SKILLS

Business Experience: Market Research, Business Knowledge Customer Experience/Soft skills: Interpersonal and Communication, Collaboration, data-driven, Data storytelling Data Science: Data Engineering (ETL), Data Pipelines, Data Validation, Data Quality, Statistics Machine Learning & Modeling: Predictive Modeling, Feature Engineering, Operations Research, A/B Testing, Regression, Natural Language Processing (NLP)

Contact this candidate