Welcome to my Portfolio! Hi, I’m Annie. I like puzzles, both in data and in real life, from making dashboards to crafting tiny DIY bracelets. I’m drawn to business analysis in insurance because there’s something exciting about turning uncertainty into insight.
Actuarial Science & Business Analytics
4.0 / 4.0
DePauw Vietnamese Student Association, Gamma Iota Sigma (Delta Gamma Chapter), DePauw Actuarial Science Oragnization
• Analyzed 150+ employee feedback entries using Python (pandas, NLTK) and cluster analysis to uncover attrition risks and segment staff into 5+ cohorts.
• Delivered workforce insights via strategy decks and Excel visuals, reducing analysis time by 30% and enabling targeted retention strategies.
• Analyzed 500+ survey responses to identify high-engagement segments and presented insights to leadership.
• Used Python and Tableau to uncover trends from 1,000+ data points, suggesting actions to boost retention by 30%.
• Analyzed financial data from 4 institutions using SQL and Excel, improving assessment accuracy by 25%.
• Built Tableau dashboards and automated reports from 5,000+ data points to highlight 10% YoY growth insights.
A SQL & Power BI analysis of Netflix content, highlighting genre and rating patterns across countries.
A SQL & Tableau analysis of global COVID-19 trends in cases, deaths, and vaccinations by region.
A Python & Tableau study of NYC Airbnb data, exploring pricing, room types, and neighborhood demand.
A Python & Power BI analysis of claims data to detect risk patterns and support better segmentation.
An Excel-based analysis and dashboard of ER metrics to improve service speed, resource planning, and patient outcomes.
An Excel-based Marine Liability pricing model and dashboard using rating, inflation adjustments, and loss loadings for competitive, sustainable premiums.
Tools: SQL, Power BI
Data: 8,800+ Netflix content records
Netflix faces challenges in managing global content diversity and audience preferences. This project explores trends in content type, ratings, genres, and country distribution to guide strategic decisions.
Actionable insights were delivered for content strategy, moderation, and audience targeting. The project showcases structured SQL querying and compelling Power BI storytelling.
Tools: SQL, Tableau
Data: COVID-19 cases, deaths, and vaccinations (Our World in Data)
This project explores global COVID-19 trends by analyzing infection rates, death tolls, and vaccination rollouts. It provides public health insights to support policy decisions and identify high-risk regions.
This project helped identify vaccination gaps, high-risk countries, and key pandemic trends. It demonstrates SQL-based data transformation and Tableau visualization skills for public health strategy.
Tools: Python, Tableau
Data: 48,000+ Airbnb listings across NYC boroughs
This project analyzes pricing, room types, and neighborhood availability in NYC Airbnb listings to guide smarter listing and booking strategies.
This project highlights actionable insights for both hosts and guests by showcasing data-driven patterns in price, availability, and neighborhood trends. Python and Tableau were used for transformation, analysis, and storytelling.
Tools: Python, Power BI
Data: 10,000+ insurance policyholder records
This project analyzes claim severity, customer segmentation, and risk indicators to improve pricing strategies and fraud detection in insurance portfolios.
Actionable insights were derived to enhance underwriting, pricing, and customer risk profiling. A Random Forest model supported early fraud detection, and Power BI visuals communicated findings to business stakeholders.
Tools: Excel (Power Query, DAX, PivotTables, Visualisations)
Data: 6000+ synthetic ER patient visit records
This project analyzed emergency room performance to reduce wait times, optimize resource allocation, and improve patient care by analyzing referral trends, admission status, and demographic patterns.
This Excel-native dashboard empowered hospital teams to monitor real-time performance, identify bottlenecks, and adjust staffing plans. By leveraging Power Query and DAX, the tool enabled efficient, low-code healthcare analytics with dynamic filtering and clear KPIs.
Tools: Excel (Formulas, PivotTables, Visualisations)
Data: 100 historical Marine Liability insurance claims (2018–2023)
This project analyzed Marine Liability insurance claims to develop accurate, competitive premiums by assessing claim frequency, severity, and risk distribution, incorporating inflation adjustments and large loss loadings for long-term pricing stability.
This Excel-native dashboard enabled underwriters and actuaries to monitor claim patterns, assess risk drivers, and refine pricing strategies. Using formulas, PivotTables, and charts, it delivered efficient, low-code insurance analytics with dynamic filtering and clear KPIs.
