📊 Portfolio Projects
COVID Impact on Lost Workdays & Wages
Business Question: How did COVID-19 impact lost workdays and wages across U.S. states?
Tools Used: Excel (PivotTables, Charts), Public Health Data
Insights: Identified the top 20 states with the highest economic impact. Used data storytelling to highlight trends by region and policy approach.
View DetailsState Performance Dashboard
Business Question: How do state-level metrics trend over time, and what insights can we gain from pivoted monthly data?
Tools Used: Excel, PivotTables
Insights: Created interactive dashboards showing changes by month. Useful for performance comparisons and trend analysis.
View DetailsCustomer Churn Prediction (Telco)
Business Question: Which customer behaviors predict churn, and how can we reduce it?
Tools Used: Excel, CSV Data Cleaning, Exploratory Analysis
Insights: Cleaned and analyzed telco data to find top churn indicators. Flagged areas for improved customer retention strategy.
View DetailsHousing Affordability Trends in New Mexico
Business Question: Are New Mexico’s housing prices rising faster than wages over time?
Tools Used: Excel, Data Wrangling, Visualization
Insights: Revealed increasing gaps in affordability by comparing historical housing and income data by county.
View DetailsEmployee Turnover Survey Analysis (MBA)
Business Question: Why are employees leaving and what actions can we take to improve retention?
Tools Used: Excel, Survey Data, PivotTables
Insights: Translated employee sentiment into action plans by analyzing trends across departments and tenure bands.
View DetailsChange Management Communication Plan (MBA)
Business Question: How can leadership communicate change effectively during uncertainty?
Tools Used: Organizational Change Models, Stakeholder Analysis
Insights: Developed a structured communication plan to navigate business transformation using Kotter’s change framework.
View DetailsVA Non-Profit Contract Strategy (MBA)
Business Question: How can a small nonprofit improve success with VA government contracts?
Tools Used: SWOT Analysis, SAM.gov Research, Proposal Planning
Insights: Built a roadmap for compliance, vendor setup, and capability improvement for federal contract readiness.
View DetailsPharmaceutical Merger – Communication Strategy (MBA)
Business Question: How can two merging pharma companies align messaging for employees and stakeholders?
Tools Used: Internal Communication Strategy, Executive Briefing
Insights: Created a leadership-aligned communication strategy to navigate culture shifts and uncertainty during the merger.
View DetailsNote: Some analyses are based on MBA coursework.
