Engineering
Selected Engineering Work
Case studies from previous professional roles and independently developed applications.
Case studies
Previous professional experience
When SQL Returns the Wrong Answer
Investigating incorrect operational figures across dependent SQL views, business rules and historical data.
- SQL Server
- SQL
- Relational databases
Calculation path. Relational records pass through dependent views and calculations to produce a report value. - Source records
- Dependent views
- Report value
Previous professional experience
Keeping Data Consistent Across Applications
Examining how records, calculated values and identifiers move between interconnected business applications.
- PHP
- SQL
- REST APIs
Integration path. Several operational records pass through transformation and mapping to one destination product. - Source records
- Transform & map
- Destination product
Independent application
AI Suggestions Without Automatic Database Changes
A CRM in which AI-generated proposals are validated and reviewed before approved database operations are executed.
- Next.js
- TypeScript
- PostgreSQL
Approval path. A generated proposal passes through validation and user approval before a database write. - AI proposal
- Validation
- User approval
- Database write
Private application · Overview only
Learning & Education Platform
An independently developed full-stack educational application with authenticated workflows, study planning, assessment tracking, relational data and explainable rule-based recommendations.
- Next.js
- TypeScript
- PostgreSQL
- Drizzle ORM
- Authentication
- Server-side validation