Oct 2023 - Feb 2024

Product Data Analyst Co-Op at NSK

• Enhanced operational efficiency by 30% through optimizing multiple Power BI dashboards with KPI data sourced from Salesforce, Hubspot, and Google Analytics. • Conducted data cleaning and formatting of over 100,000 products using Excel, improving overall data accuracy by over 25% and helping consolidate information across various departments. • Developed a Python-based Machine Learning model achieving over 97% accuracy in predicting product families, helping to correctly classify products with missing or incorrect data. • Utilized advanced SQL queries to optimize product data retrieval and enhance data accuracy, contributing to streamlined business processes.

Jul 2024 - Nov 2024

Healthcare Benefits Data Analyst at Prime Therapeutics

• Utilized Excel Macros to automate data processing tasks, improving overall healthcare plan data efficiency and accuracy. • Communicated with stakeholders to gather requirements, clarify information, and address inquiries related to benefit coding and claims processing. • Integrated and reconciled large datasets from various sources using IBM DB2 to input new healthcare benefit plan designs.

Dec 2024 - Present

Business Systems & Data Analyst II

• Led the transition of the MSE team’s reporting process from Excel to Tableau, improving data visualization and stakeholder reporting efficiency. • Developed Python scripts to clean and prepare large datasets from thousands of survey respondents for seamless Tableau integration. • Automated weekly and monthly reports using Excel Macros, PivotTables, and Power Query, delivering actionable insights on key survey metrics across multiple platforms. • Utilized SQL to extract and analyze demographic and survey response data for over 85,000 employees from S3, enabling advanced segmentation and heatmap visualizations. • Spearheaded the migration of Customer Commitment survey data from Prism to Jira, consolidating reporting sources into a unified system of record for improved data accuracy