<aside>
I build database systems that businesses can trust; organized, secure, and built to scale. From designing a schema from scratch, securing sensitive data with role-based access control, or transforming messy datasets into clean, reliable pipelines, I make sure the data side of your business works the way it should.
</aside>
My work includes Database Design & Architecture, Data Modeling & Normalization (1NF–3NF), SQL Development, Query Optimization, Backup & Recovery, Disaster Recovery Planning, ETL & Data Transformation, and Data Quality & Integrity across platforms including Microsoft SQL Server, PostgreSQL, and Azure SQL Database
Administered a 13-table relational database (Northwind) spanning sales, inventory, logistics, and HR domains. Implemented role-based access control (RBAC) with differentiated privilege levels across admin, manager, staff, and read-only roles; configured staff permissions to allow INSERT and UPDATE on orders while explicitly restricting DELETE operations to protect data integrity; and enforced controlled salary update access to sensitive employee records
Redesigned a flat 41-record movie dataset into a fully normalized 3NF relational schema, decomposing a single denormalized table into 6 entities; Movies, Directors, Producers, Stars, Genres, and a linking junction table. Eliminating redundancy and enforcing referential integrity through foreign key constraints; wrote multi-table JOIN queries to extract analytical insights including top-rated films by genre, director filmography breakdowns, and producer output comparisons
Analyzed 145K+ Transport for London accident records using Python (pandas, NumPy, scikit-learn) to build K-Means clustering and Decision Tree models (86.5% accuracy) that identified high-risk hotspots and severity patterns, delivering data-driven safety recommendations projected to reduce accidents by 10-15% in targeted zones
Got a project that needs solid data infrastructure? Whether you’re starting from scratch or cleaning up an existing system, I’d love to hear about it. Reach out via Email or connect on LinkedIn.