Skip to content

Portfolio · case studies

Real projects. Real results.

11 years solving expensive problems for businesses that can't afford downtime. From enterprise POS systems handling thousands of daily transactions to automated business processes that eliminate manual work — here's how complex problems get solved with clean, maintainable code.

Selected work

Case studies that solve expensive problems

Industries: Major F&B and retail brands · Airport duty-free operations · Loyalty programs managing millions of points · Pet service businesses. Scale: Production systems handling high transaction volumes, multi-country deployments and compliance-critical environments.

Cloud Cost Google Cloud Bill Cut by a Third, Without Downtime Google CloudCloud RunCloud SQLCost Optimisation An investment research platform's cloud bill rose every month under its previous developer's setup. Checked every cost against the account's own billing data, right-sized servers, moved the API to Cloud Run and cleared out waste, catching a deploy limit weeks from being hit along the way. Cloud bill down 33% in one month, with no downtime. Read the case study → Performance High-Volume Performance Crisis Resolution .NET FrameworkSQL ServerPerformance OptimizationProduction Crisis An automated point-expiry system ran flawlessly for years — until a new customer's extremely high transaction volumes exposed critical bottlenecks and put production at risk. Analyzed query and data-access patterns under pressure, applied targeted optimizations without disrupting the live automation, and ran a custom off-hours program to clear accumulated data. Crisis resolved within half a day with zero business disruption. Read the case study → Web & Automation Pet Grooming Booking & Automation System .NETWeb APISQL ServerEmail Automation Transformed a backend-only legacy booking system into a full customer-facing platform: intelligent booking automation (groomer availability, pet-size rules, seniority-based scheduling), automated driver scheduling with area-code restrictions, package subscriptions with automatic point awards, and API-triggered confirmation, reminder and low-point emails. What once needed constant manual coordination now runs autonomously. Read the case study → POS & Desktop Payment Terminal Integration Middleware .NETMiddleware ArchitectureHardware IntegrationLogging & Diagnostics Multiple credit-card terminals were integrated directly inside the POS code — jumbled into a single file that made debugging a nightmare and every new terminal riskier. Extracted the terminal logic into a dedicated middleware program with a clean base framework, so developers implement only terminal-specific commands without touching connection logic, backed by extensive diagnostic logging. New integrations now take a fraction of the original time. Read the case study → POS & Performance Offline POS Sync Optimization & Staging DB Innovation .NETMulti-threadingEntity FrameworkAzure Blob Storage Offline POS sync was painfully slow — tables downloaded one-by-one, testing polluted production with fake data, and image downloads crawled through a web-service middleman. Introduced a staging local database by dynamically cloning tables through the existing EF middleware, added multi-threading for parallel downloads, and pointed image downloads directly at blob storage. Sync time is now set by the single largest table instead of cumulative sequential processing. Read the case study → POS & Desktop Retail POS Module Refactoring & Architecture Overhaul .NETMVVM PatternArchitecture RefactoringCode Quality Leadership A legacy retail POS had UI and business logic tightly coupled with no structured pattern in the sales module — monolithic code where every new feature risked breaking existing functionality. Introduced a properly structured MVVM pattern where none existed; once established, subsequent modules followed with clean separation of concerns and were continuously optimized. The MVVM-based modules proved easy to maintain and issue-free. Read the case study → Internal Tools Developer Productivity Framework Enhancements .NETFramework DesignCode GenerationDeveloper Experience To add a report (before)
4+ files
After (+1–2 lines)
1 file
Development workflows killed productivity: adding a report meant editing 4+ files, system settings were jumbled into one error-prone file, and enum-string pairs were maintained by hand with high risk of sequence mismatches. Restructured printing to one main file plus a line or two elsewhere, split settings into module-specific files with a framework that auto-generates UI from data models, and refactored fragile positional enum dependencies into structured code. Read the case study →
POS & Compliance Airport Retail POS Compliance & Major Enhancement .NET FrameworkSQL ServerPOS SystemsCompliance & Reporting Airport duty-free operations faced strict regulatory requirements the system couldn't meet — no flight tracking, tariff-code restrictions, passport-based purchase limits, or proper audit trails. Built a flight-info tracking module, a tariff-code system with configurable purchase limits by passport type, stock-overview reports for audit documentation, and a mandatory double-verification reconciliation workflow. Now highly reliable in a compliance-critical environment, passing audits and preventing violations automatically. Read the case study →

Capabilities

Technical expertise

Automation & Integration

  • Automated business process workflows
  • Batch processing & scheduled jobs
  • Email notification automation
  • Third-party system integration
  • Payment terminal integration
  • API development & integration

Database & Performance

  • Database design & schema modeling
  • SQL Server optimization expert
  • Query performance tuning
  • Index strategy & implementation
  • Complex query rewriting
  • Database troubleshooting
  • Large-scale data processing
  • Design for reporting & analytics

Backend Development

  • .NET Framework / .NET Core
  • C# application development
  • Web API design & implementation
  • Windows Services
  • Middleware architecture
  • POS system development

Architecture & Refactoring

  • Legacy system modernization
  • Code refactoring & restructuring
  • Separation of concerns
  • System architecture design
  • Performance bottleneck identification
  • Technical debt reduction

Have a Legacy System Issue or Manual Workflow Problem?

Whether you need to fix critical bugs, automate time-consuming processes, optimize performance, or rescue a failing system — expertise like this can transform your operations.