Case Studies
Selected technical work and measurable outcomes. Client and employer names are intentionally omitted.
Database consolidation
Migrated data from separate databases into a consolidated SQL Server database, including cleansing, backfill and view optimisation.
14,000+ account migration
Built SQL-based billing and reporting tools supporting the migration of more than 14,000 customer accounts, with a focus on accuracy and reduced manual processing.
70% less manual QA
Developed a PowerShell-based SSRS bulk testing tool that reduced manual QA workload by 70%.
33% reporting reduction
Refactored and standardised legacy SQL and stored procedures, reducing the number of SSRS reports by 33% and improving maintainability.
40% faster billing reports
Optimised SQL queries and indexing to improve billing report generation time by 40%.
Power BI operational analytics
Built Power BI datasets and interactive dashboards from Azure SQL, using DAX for storage-volume trends and Top-10 operational analytics.
CRM & invoice processing
Developed a lightweight CRM solution that imported customer information and PDF invoice data for administrative and debt-recovery workflows.
Database release automation
Built a Visual Studio-based schema release solution to standardise database version control across development, test and production.
Secure hosted application
Deployed a secure streaming web application and administered hosted SQL Server environments for remote access, migration and analysis activities.
68,000 customer SoLR transfer
Project-managed a regulated Supplier of Last Resort transfer involving approximately 68,000 customer accounts, covering final billing, customer data, reporting and operational processes. Final bills were issued within five weeks and credit-balance refunds within eight weeks.
Bill Finder application
Developed a bespoke Windows application giving authorised third parties read and print access to customer bills and account history for customer service and debt collection. The project profile recorded 80% of customer queries being finalised at first contact.
Need similar technical delivery?
We can discuss the requirement without publishing sensitive project or client information.