Data Analyst Machine Learning

Kunal Ghogare

Long Beach, CA +1-747-***-**** *************.*********@*******.*****.*** LinkedIn Github EDUCATION

California State University, Long Beach Master of Science in Information Systems Expected - May 2025 Courses: Business data analysis, Machine Learning for Business Analytics, Artificial Intelligence GPA: 4.0/4.0 Pune University, India Bachelor of Engineering in Information Technology Aug 2017 - May 2021 PROFESSIONAL EXPERIENCE

Simplify Healthcare Ltd Associate Data Engineer Dec 2021 – Apr 2023

● Configured SQL Server for multi-tenancy and metadata management, increasing response speed by 10% and decreasing storage costs by 30%, equating to a $3,000 monthly savings.

● Collaborated with cross-functional teams and Developed the Quick Edit feature, utilizing predictive analytics and data modeling to streamline product edits, cutting time by 25 to 8 minutes.

● Automated 80% of data migration tasks using SQL Service Integration Services (SSIS), eliminating manual efforts and streamlining transfers across multiple databases.

● Developed an ETL Data Integration Pipeline integrating JSON data tables containing over 380M+ rows.

● Refined SQL stored procedures, triggers & REST APIs for automated data quality checks in data models, resulting in a 50% improvement in data accuracy and maintaining referential integrity of health insurance plans. The Mahua Store Data Analyst Intern Jun 2021 – Nov 2021

● Created data-driven strategies to optimize user flows, resulting in 40% reduction in cost per lead from $8 to $4.08.

● Employed Power BI to create real-time dashboards, communicating and highlighting seasonal trends and sales patterns of customer engagement that informed marketing strategies and drove 6% revenue increase ($9,000).

● Executed market research, analyzed click stream data, and identified 13 KPIs by data cleaning and wrangling data using Python and Pivot Tables which enabled optimizing resource allocation & cost savings of 30%. National Education Foundation Data Analyst Intern Mar 2019 – Jan 2020

● Led end-to-end technical management and created user stories for projects of national events K2S and Enduro3, enhancing logistics and performance metrics by 25% through data analytics and A/B testing.

● Cleaned and sorted participant datasets, identifying 30+ Key Performance Indicators using Python.

● Applied statistics and utilized R and Tableau to derive actionable insights, steering data-driven decisions for continuous event enhancements, achieving a notable 66.7% growth in event engagement. SKILLS

Programming Skills: Python, SQL, R, JavaScript, NumPy, Pandas, Matplotlib, OpenCV, Seaborn, SciPy, HTML, CSS, XML. Databases: Microsoft SQL Server, PostgreSQL, Oracle DB, MySQL, MongoDB, Snowflake. Cloud Services: GCP, Azure, AWS, Google Cloud Storage, RDS. BI Tools: PowerBI, Tableau, MS Excel, Google Data Studio, Oracle BI, SQL Server Management Studio, SSIS, Visual Studio, Agile, Postman, MS Office suite, Alteryx, IBM-SPSS, Jira. PROJECTS

Academic Performance Predictions Business Intelligence, Statistics, R Aug 2023 - Dec 2023

● Leveraged Predictive Analytics: Crafted Multivariate Regression Model with Python (SciPy), and SPSS achieving 0.991 R- Square on student dataset for Academic Performance Insights.

● Conducted statistical validation (ANOVA, hypothesis testing, p-value analysis), and used Exploratory data analysis (EDA) techniques for pattern recognition and pinpointing study hours and prior scores as pivotal. Candidates’ Attention Analysis Machine learning, Python, OpenCV Apr 2021 - May 2021

● Designed attention analysis software with head pose estimation, using OpenCV for facial landmark detection.

● Implemented machine learning enhancements, achieving 69% accuracy in student engagement analysis.

● Architectured a Flask-based backend API for efficient head pose data management, enabling easy integration with data pipelines and analytics tools enhancing insight generation. Food Safety Data Engineering Data Visualization, Alteryx, ETL Jan 2021 - Apr 2021

● Employed Alteryx for precise data profiling and Talend for seamless integration, ensuring efficient data loading into SQL Server to create a data warehouse, achieving a 60% reduction in data processing time.

● Designed a dimensional model comprising 6 dimensions and 2 facts, tailored to meet business requirements.

● Utilized communication skills to design tailored interactive dashboards using Power BI, enabling stakeholders to visualize and analyze over 1,000 data points. This facilitated rapid, informed decision-making in food safety.

Contact this candidate