Jay Rakeshbhai Patel
669-***-**** *********@*****.*** LinkedIn GitHub Website Fremont, California EDUCATION
Master of Science – Data Science 3.6 GPA August 2022 - May 2024 University of the Pacific, CA, USA
Master of Science – Mathematics 3.4 GPA October 2020 - June 2022 Gujarat University, Ahmedabad, India
Bachelor of Science – Mathematics 3.5 GPA July 2017 - August 2020 Gujarat University, Ahmedabad, India
EXPERIENCE
Data Scientist (Internship) January 2024 – May 2024 San Joaquin Council of Governments Stockton, USA
• Analyzed Vanpool data using Python, SQL, and data mining techniques, identifying a 20% usage increase. Led the San Joaquin County initiative, achieving a 15% rise in regional participation through machine learning and Tableau.
• Identified 25 markets using location-based data mining, pinpointing top vanpool zip codes with Tableau and Shiny.
• Developed an ARIMA model saving 1.2M miles annually, highlighting vanpool savings and $500K revenue analysis.
• Proposed integrating zero-emission vans to cut emissions by 30% using state-space models, enhancing sustainability. Data Analyst (Internship) June 2021 - June 2022
Leafenix Solution Ahmedabad, India
• Transformed one million sales records with Pandas, increasing efficiency by 45% and enabling 30% faster decisions.
• Simplified complex information with impactful pie charts, boosting comprehension by 20% through visual clarity.
• Trimmed costs by $100,000, raised satisfaction by 10%, and enhanced efficiency with data-driven insights.
• Revamped Tableau projects to assess customer data effectively, driving a 20% boost in customer retention rates. PERSONAL PROJECTS
Leveraging AWS for YouTube Data Analytics and Reporting (Data Engineering, AWS)
• Optimized project execution by managing and analyzing YouTube video data with 99% accuracy and achieving a 30% improvement in processing speed, utilizing AWS S3 for storage and AWS Lambda for enhanced efficiency.
• Implemented AWS Glue to automate ETL processes and deployed Amazon Redshift for real-time analytics, resulting in a 40% reduction in data processing time and a 50% increase in query performance efficiency.
• Slashed costs by 50% and boosted data volume by 300% through AWS cost optimization and scalability strategies.
• Created an intuitive data dashboard using Amazon QuickSight, enhancing decision-making effectiveness by 25%. LINEAR REGRESSION ON BOSTON HOUSING (Machine learning, Python, Alteryx)
• Engineered machine learning models, including Random Forest, to forecast Boston housing price fluctuations; improved market accuracy by 20% and guided strategic investments, yielding 12% revenue growth.
• Processed and analyzed a dataset of 500+ records, improving MAE by 15% through linear regression analysis.
• Refined data analysis techniques using regression models to pinpoint adjusted R-squared values of 0.485 and 0.536, significantly improving predictive accuracy and informing strategic decision-making in sales forecasting. Optimizing Retail Strategies with In-Depth Consumer Behavior Analysis (R, SAS, Excel, Power BI)
• Performed statistical analysis using R and SAS, uncovering key drivers that boosted marketing effectiveness by 20%.
• Leveraged state-space models with R stats library to analyze sales trends, optimizing pricing and driving sales by 10%.
• Crafted detailed Excel and Power BI visualizations, elevating promotional ROI by 15% through refined strategies. SKILLS
• Programming & Visualization: Python, SQL, R, HTML, CSS, XML, Tableau, Power BI, Alteryx, MS Excel, MS PowerPoint
• Database Management & Tools: Oracle SQL, MySQL, PostgreSQL, MongoDB, MS Access, Azure Studio, Google Cloud, Dash, Database Design, EAD, ETL, Data Warehousing, Feature Engineering, Hadoop, Spark, AWS, Git, Linux, Unix
• Machine Learning & Data Science: Regression, Classification, Clustering, Boosting, CNN, RNN, LSTM, MLP, Neural Networks, NumPy, Pandas, Matplotlib, Scikit-Learn, SciPy, Keras, TensorFlow, OpenCV, Ploty, Shiny, MASS
• Soft Skills: Leadership, Communication, Management, Teamwork CERTIFICATION
• Data Analytics – Google Data Analytics
• AWS Academy Graduate - AWS Academy Cloud Foundations