JOAO HAFLIGER

Govern data and IT operations across multiple international locations, defining engineering standards adopted by 3+ development teams. Optimised Oracle Exadata query and pipeline performance and designed ETL/data-quality frameworks supporting real-time analytics and regulatory reporting.

Led and mentored an 18-person development team building data infrastructure and BI solutions for a Tier-1 investment bank. Improved ETL workflow reliability and throughput by standardising pipelines and introducing code reviews and automated testing to reduce production incidents.

Engineered real-time upstream/downstream data communication flows for financial client order processing using IBM Message Queues. Improved scalability and throughput by refactoring client report pipelines and delivered secure file transformation and transfer tools to reduce manual reconciliation effort.

Architected and delivered a full data migration and synchronisation solution from a legacy IBM mainframe to IBM DB2 with zero data loss. Built secure, encrypted data transfer pipelines and high-volume consolidation pipelines for credit and debit card transactions across multiple banking partners.

Designed and delivered an enterprise-wide BI platform across multiple hospitals and clinics on Oracle Exalytics and Exadata. Developed inventory ETL pipelines for real-time supply chain analytics and tuned SQL in the data warehouse to reduce query execution times and improve dashboard responsiveness.

Built an internal budget and financial-management application integrated with the national accounting system, supporting regional outposts up to Central Command. Implemented bottom-up data consolidation workflows to enable organisation-wide financial planning and resource allocation reporting.

BSc in Theoretical Physics from the University of Lisbon, with rigorous training in mathematical modelling, statistical analysis, and quantitative reasoning for analytical and modelling work.