Profile
Data analyst with 5 years turning operational and product data into decisions, mainly in SQL, Python and Power BI. Works close to the teams that use the numbers: retention reporting, funnel analysis and data quality checks that stop bad figures reaching a dashboard.
Experience
- •Own weekly commercial reporting for six store regions, replacing a manual Excel pack with a Power BI model refreshed from the warehouse.
- •Cut the time to produce that pack from about 9 hours a week to under 1 by moving the joins and aggregations into scheduled SQL views.
- •Built a basket-level analysis in Python that showed which promotions were driving repeat visits rather than one-off traffic, which changed how the next quarter's offers were picked.
- •Added row-count and null-rate checks to the nightly load, so a broken feed is flagged before the dashboards open instead of after someone reports a wrong number.
- •Wrote the SQL behind the claims operations dashboard used daily by roughly 40 people across three teams.
- •Analysed the claims funnel and identified two handoff stages that accounted for most of the delay, which fed the process review that followed.
- •Documented the definitions behind each reported metric so that the same figure stopped being calculated two different ways.
- •Produced monthly delivery performance reports in Excel and rebuilt the largest one with formulas and pivot tables instead of manual copy-paste.
Education
Skills
Languages