Cloud Data Migration — Oracle to PostgreSQL + AWS
SQL · PostgreSQL · Oracle · AWS S3 / DynamoDB · GitHub Copilot
- Architected end-to-end ingestion and notification pipelines migrating Customer and Account domains from legacy Oracle to PostgreSQL + AWS, enabling decommission of legacy infra across 2+ business domains.
- Built source-to-target reconciliation frameworks validating record counts and field-level accuracy — minimal critical data discrepancies at go-live.
- Used GitHub Copilot daily for code review, test generation, and query optimisation, improving iteration speed and review efficiency.
Enterprise Data Governance
Power BI · Excel
- Drafted enterprise data standards covering definitions, ownership, quality thresholds, and lineage — aligned to regulatory and audit requirements.
- Ran a structured data criticality assessment scoring datasets by regulatory exposure and business impact, informing the client's investment roadmap.
- Built Power BI dashboards tracking data quality KPIs and governance adoption for real-time leadership visibility.
ESG Data Integration — Enablon Platform
SQL · .NET · ETL
- Designed integration workflows feeding sustainability data into Enablon, aligning source outputs to its data model across multiple entities.
- Wrote advanced SQL for extraction, cleansing, and loading with business-rule translation and quality checks at each stage.
- Contributed to .NET integration-layer development, building and testing data connectors between source systems and the ESG platform.
AI-Powered Analytics PoC — Natural Language Data Modelling
Snowflake · Oracle · LLM integration
- Contributed to a PoC extracting data from Snowflake and Oracle sources and generating data models and business glossaries via natural language prompting.