Custom Desktop Application for Data Processing Automation

I developed a custom desktop application for Gcwensa (Pty) Ltd, designed specifically for their internal data engineering team to automate complex and repetitive data processing tasks. The goal was to improve operational efficiency and eliminate manual effort in handling large data workflows.

The application features three primary functions:

SQLite to MSSQL Conversion – The tool allows engineers to convert legacy or acquired SQLite databases into MSSQL format, enabling better compatibility with internal systems and improved data visualization.

Apache Data Retrieval & Processing – Through API integration, the application downloads raw Apache data files directly from remote server providers, then parses and imports them into MSSQL for structured storage and reporting.

Automated Excel Reporting – The app reads from the MSSQL database and generates detailed Excel reports based on analytical rules. These reports are formatted for clarity and exported for upper management review.

The entire solution was developed using WPF for a user-friendly desktop interface, and built with scalability in mind for future data processing enhancements.

Language & Frameworks: C#, WPF, XAML Database: SQLite, MSSQL Integrations: APIs for Apache data retrieval Functionality: Data conversion, reporting automation, Excel export