Dhruv Patel Email & Phone Number

•Utilized Snowflake and orchestrated Airflow to automate ETL processes extracting 1M+ records (CRM and website analytics), achieving a 40% reduction in processing time and enabling real-time data analysis for marketing teams.•Increased student content consumption by 15% through personalized recommendations based on learning style (KNN model).•Leveraged A/B testing to optimize website call-to-actions (CTAs) for course enrollment, resulting in a 10% increase in student registrations and a projected 8% increase in annual program revenue.•Designed 10+ dynamic Tableau dashboards and KPI scorecards for presenting insights to the non-technical stakeholders to discontinue a few of their unprofitable campaigns, reducing the company’s expenditure by 20%.

• Utilized RFM Analysis to segment users with high feature engagement but low conversion, informing a freemium tier with targeted messaging that increased engagement by 12% and conversion by 5%.• Migrated 200 GB of historical sales data to Amazon Redshift using PySpark for parallel processing and AWS S3 for efficient staging, reducing migration time by 40%.• Optimized query performance by writing efficient SQL queries for complex datasets stored in Google BigQuery, achieving a 25% reduction in query execution time, enabling faster data retrieval and analysis.• Built XGBoost churn model to predict subscription cancellations, enabling proactive interventions (special offers, loyalty programs) that reduced churn by 10% and saved $500K/year.• Created an automated Tableau report to monitor product performance, offering actionable insights to prioritize marketing efforts on five specific products facing diminishing sales.

• Utilized pandas and NumPy for data manipulation and analysis, and SQL for efficient joins and querying of 500K+ sales records. • Performed EDA and feature engineering in Python to enhance statistical model development, improving performance and flexibility. • Implemented demand forecasting models (ARIMA, SARIMA) resulting in 70% improved data forecast accuracy, optimizing inventory levels, and reducing stock-outs by 20%. • Created Tableau dashboards with database Connection, presenting demand insights, resulting in $75K in cost savings for the company.

Master'S Degree, Data Analytics Engineering, 3.7

Relevant Coursework: Foundations of Data Analytics, Data Management for Analytics, Machine Learning in Engineering, Computation.

Bachelor Of Engineering - Be, Information Technology, 8.22

Relevant Courses: Python Programming, R, Advanced Database Management Technology, Data warehouse and Business Intelligence, Data Mining.

Diploma, Computer Science

Relevant Coursework: Programming in C, C++, SQL, Databases, Data Architecture, Data Structures, Web development, Computer Graphics