Private Database Development Projects

Developing relational databases for personal and private projects, with a focus on efficient data management across transactional systems and decision support environments.

• Designing a relational database to support an ASP.NET front-end system, with an emphasis on scalability and efficient querying.
• Technologies: SQL Server, SSMS, T-SQL

Client Brokerage Management System Database

Consolidated multiple Microsoft Access databases into a centralised SQL Server backend for the Client Brokerage Management System (CBMS), improving data consistency, transactional processing, and support for decision-making across a state government department.

• Designed and implemented a robust OLTP relational database in SQL Server to centralise data from multiple Microsoft Access databases, ensuring consistency and reliability.
• Migrated data from Microsoft Access databases to a SQL Server relational database using SMO, Visual Basic for Applications (VBA), and T-SQL scripts.
• Implemented a secure architecture integrating Microsoft SQL and Windows Security with Active Directory membership.
• Technologies: SQL Server, SSMS, T-SQL, DTS, SMO, Microsoft Access, Visual Basic.