Analyst Intern Marketing

Ridham Mahajan

469-***-**** *****************@*****.*** https://www.linkedin.com/in/ridham-mahajan/ Dallas, TX KEY SKILLS

• Tableau Desktop • Power BI • Python •SQL • Advanced MS Excel • Alteryx • Business Intelligence • Regression

• Clustering •Machine Learning • Natural Language Processing • ETL • Pivot Tables • Adobe Analytics • Google Analytics BUSINESS EXPERIENCE

Data & Analyst Intern June 2022-Present

CDK Global

• Configured and deployed Tableau-based dashboards to drive digital transformation, Identified key performance indicators for director-level stakeholders, and improved data accessibility by 6%

• Streamlined data pipelines by creating optimized datasets using Alteryx, leading to a 5.54% decrease in errors and improving reporting capabilities by 3.6%

• Facilitated agile requirement definition & refinement sessions with 10+ data analysts & data engineers to translate client requests into story points, resulting in successful JIRA-based iteration delivery within deadlines Marketing Analyst Intern January 2022 - June 2022

Department of Electrical & Computer Engineering, University of Texas-Dallas

• Used SQL to extract and transform data from multiple databases, analyzing over 1.2M rows of data to surface key trends & insights resulting in a 36% increase in social media presence

• Crafted profiling reports using Neural Networks techniques, allowing the marketing team to quantify strategic initiatives for up to 2K student segments

Technical Manager December 2017 - July 2021

Institute of Banking Training, Amritsar, India

• Performed data integration from multiple sources with SSIS to construct reports and measure performance metrics and trends in sales, achieving savings of 10-20% per inventory purchase

• Assessed the lifecycle of competitor companies to generate business insights using Power BI in social media marketing controls which enhanced user reach by 45.75%

• Coordinated 5+ cross-functional collaboration efforts involving data science, development, and visualization teams to optimize existing ETL process for higher efficiency, achieving a 10% cost savings & improving cycle time by 25% PROJECTS

Minority and Women Retailer (MDWR) Dashboard July 2022 – January 2022

• Developed logical and physical data models, including snowflake schema and highly normalized data models resulting in an 8.15% increase in data accuracy and a 10% improvement in data accessibility for stakeholders.

• Produced effective data visualization summarized from 4 sources, resulting in saving 3K man-hours annually

• Created different Action filters, Parameters, and calculated fields in an interactive dashboard to visualize over 6TB of data, leading to a 6.15% enhancement in query speed Healthcare Predictive Analysis November 2022

• Trained 11 machine learning models including Linear Regression, K-Nearest Neighbors, Decision Tree, Random Forest, Gradient Boosting, XGBoost, and CatBoost regressors to predict the length of a patient's stay in the hospital.

• Evaluated the performance of each model using R^2 score, achieving the highest score of 0.97167 with XGBoost and the lowest score of 0.30192 with LightGBM.

EDUCATION

Master of Science, Business Analytics University of Texas at Dallas, Richardson May 2023 Bachelor in Computer Application Guru Nanak Dev University, Amritsar, India May 2016 HIGHLIGHTS

Certification: Alteryx Designer Core, Google Analytics Individual Qualification, Google Data Analytics Languages: Python (Pandas, NumPy, Matplotlib, Seaborn, Scikit-learn, SpaCy), R, SAS Statistical Analysis: ANOVA, Hypothesis testing, Decision tree, Time series forecasting, Predictive Analysis, Classification Others: Microsoft Office (MS Word, Outlook, PowerPoint) business intelligence

Contact this candidate