DeafProgrammer

Database Design & Development Projects

This page highlights significant database projects, including relational system design, data centralisation, and data warehousing work developed to support reliable business operations and decision-making.

Private Database Development Projects

Developing relational databases for private and personal projects, with a focus on structured data models, transactional reliability, and long-term maintainability across business-oriented systems.

  • Designing relational database structures to support ASP.NET front-end systems and practical reporting requirements.
  • Applying primary key and foreign key relationships, business rules, and structured querying to support predictable behaviour over time.
  • Technologies: SQL Server, SSMS, T-SQL

Horse Racing Database Project

Developing and refining a structured SQL Server database for a long-term private horse racing project, focused on storing race data, supporting analytical queries, and identifying performance patterns through relational design and reporting logic.

  • Designed relational structures to support race history, form analysis, and reporting requirements.
  • Uses stored procedures and structured T-SQL queries to support data analysis and ongoing refinement.
  • Maintained as a private database project as part of a long-term personal system.
  • Technologies: SQL Server, SSMS, T-SQL

Client Brokerage Management System (CBMS)

Contributed to the design and implementation of the Client Brokerage Management System by helping centralise 13 regional Microsoft Access databases into a structured SQL Server relational backend, improving consistency, transactional processing, and long-term usability across a state government environment.

  • Helped build the foundation of the SQL Server database and the Microsoft Access front-end application, deployed in a centralised environment for multi-user access.
  • Designed and programmed constraints, triggers, stored procedures, and user-defined functions to support data integrity and business rules.
  • Developed audit mechanisms and user-friendly audit queries to improve traceability and support operational review.
  • Worked on data export and migration processes from multiple regional Microsoft Access databases into centralised SQL Server relational tables using DTS, VBA, and T-SQL.
  • Supported testing, debugging, validation, and production implementation in a user-focused environment.
  • Technologies: SQL Server, SSMS, T-SQL, DTS, SMO, Microsoft Access, Visual Basic

Financial Data Mart (FDM)

Contributed to a whole-of-portfolio corporate data warehouse and business intelligence solution, supporting analytical reporting and decision-making through structured data warehouse design, ETL development, and dimensional modelling.

  • Worked across the business intelligence lifecycle, including data quality analysis, data profiling, data warehouse design, and reporting-layer support.
  • Developed ETL processes and transformation logic using T-SQL, DTS, PL/SQL, and Informatica.
  • Used data modelling and dimensional modelling techniques to support reporting structures and end-user information needs.
  • Designed schema and integrity constraints that supported quality assurance and data scrubbing processes where source system gaps existed.
  • Assisted with the ongoing construction and refinement of reporting layers as business needs changed over time.
  • Technologies: SQL Server, T-SQL, DTS, Oracle, PL/SQL, Informatica, Sybase PowerDesigner, Business Objects