Priya Shah
Data Analyst | SQL, Python and Power BI | Retail and Operations Analytics
Summary
Data Analyst with 3 years in grocery retail and social housing. Writes SQL against large sales and operations datasets, automates reporting in Python and builds Power BI dashboards that managers actually open. Good at turning a loose question from a stakeholder into a clear answer with the caveats stated.
Experience
Greenleaf Grocers
- Built the weekly store performance dashboard in Power BI, used by 60 store and area managers across 48 stores.
- Automated 5 manual Excel reports with Python and SQL, saving the commercial team about 12 hours a week.
- Analysed 2 years of till data to show waste on fresh bakery ran 30% higher in smaller stores; a revised ordering rule cut it by £140k a year.
- Answer 15 to 20 ad hoc data requests a month from buying, finance and operations.
Thameside Housing Association
- Cleaned and matched records for 9,000 homes across 3 legacy systems ahead of a housing management system migration.
- Built a repairs dashboard that showed 22% of jobs were missing their 28-day target; the figure fell to 11% within 6 months.
- Produced monthly KPI packs for the board and the regulator.
Skills
- SQL (SQL Server, BigQuery)
- Python (pandas)
- Power BI and DAX
- Excel (Power Query, pivot tables)
- Data Cleaning
- Data Visualisation
- KPI Reporting
- Stakeholder Communication
- A/B Test Analysis
- Git
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Education
BSc (Hons) Mathematics, Queen Mary University of London, 2023