Data Analyst Focused on Risk, Systems & Decision Intelligence Across Healthcare, Finance & Energy
Welcome to my data analytics portfolio.
This repository showcases end-to-end analytics projects focused on measuring risk, improving performance, and strengthening decision-making across healthcare systems, financial portfolios, and energy markets.
Each project demonstrates:
- Clear business context
- Structured analytical methodology
- Executive-ready dashboards/outputs
- Actionable insights
Domain: Healthcare / NHS Operations
Tools: Power BI, Power Query, DAX, Data Modeling
📌 Analyses 9,216 emergency room visits over 19 months to identify wait-time bottlenecks, peak demand periods, and patient flow challenges.
Key Focus Areas
- Patient wait-time performance
- Peak day & hour demand analysis
- Admission vs discharge patterns
- Department referral insights
Domain: Finance / Banking / Credit Risk
Tools: Advanced Excel, Pivot Tables, Financial KPIs
📌 Evaluates loan portfolio health by separating good vs bad loans, tracking repayments, and identifying credit risk exposure.
Key Focus Areas
- Loan quality classification
- Repayment vs funded amount tracking
- Month-on-month performance trends
- Borrower and geographic risk segmentation
Domain: Energy Economics / Commodity Risk / Time-Series Analysis Tools: Python, pandas, numpy, matplotlib
📌 Quantifies nearly four decades of Brent crude oil price volatility to examine structural regime shifts, crisis-driven shocks, and market risk dynamics.
Key Focus Areas
- Log return transformation & volatility estimation
- Annualised risk measurement (~40% volatility)
- Crisis-period shock identification
- Volatility clustering & regime analysis
- Risk modelling implications for energy markets
- Data cleaning & transformation
- KPI development & business metrics
- Time-series & trend analysis
- Dashboard storytelling for executives
- Healthcare & financial domain analysis
If you’d like to discuss these projects or explore collaboration opportunities:
- LinkedIn: https://www.linkedin.com/in/brightsarfo
- Email: [email protected]
- Portfolio Website: www.brightsarfo.carrd.co