Oracle ODI & Data Warehouse Technical Consultant

SYED ZOHAIB AHMAD

Lahore, Pakistan

Mobile: +92-325*******

Email: *************@*****.***

LinkedIn: https://www.linkedin.com/in/zohaibahmadpublic/ PROFESSIONAL SUMMARY

Senior Data Engineer and Business Intelligence Consultant with 10+ years of experience delivering end-to-end ETL, Data Warehousing, Data Modeling, and BI solutions within banking and financial services environments. Strong expertise in Power BI, OBIEE, Azure Data Factory, Oracle Data Integrator (ODI 11g/12c), Informatica PowerCenter, Pentaho, and advanced SQL performance tuning. Hands-on experience across Oracle 19c, Azure SQL Database, PostgreSQL, AWS RDS, and Hadoop platforms. CORE SKILLS

• ETL Development & Data Integration

• AWS ETL Pipeline

• Oracle Data Integrator (ODI 11g/12c)

• OIC

• Informatica PowerCenter

• Pentaho ETL

• Data Warehousing Architecture

• Dimensional Data Modeling (Star & Snowflake Schema)

• Change Data Capture (CDC)

• Power BI, OBIEE, OAS Development

• SQL & PL/SQL Development

• Database Administrator

• Oracle 19c Performance Tuning

• Azure SQL Database, PostgreSQL, AWS RDS, MS SQL Server, Vertica

• Hadoop Ecosystem

PROFESSIONAL EXPERIENCE

Senior Technical Consultant – Digital Next Generation (Aug 2025 – Dec 2025)

• Designed and implemented OFSA / Oracle FCCM ETL pipelines including PFT and FTP modules.

• Developed end-to-end ETL workflows using ODI 12c and Oracle Database 19c.

• Engineered data ingestion from Temenos T24, databases, and flat files.

• Built automated daily load plans with exception handling and logging.

• Optimized SQL queries and improved ETL performance. Advisory Software Engineer – Kavtech Solutions (Mar 2023 – Jul 2025)

• Designed enterprise ETL pipelines using Informatica PowerCenter.

• Built near real-time AWS ETL pipelines for high-volume datasets.

• Maintained and optimized Pentaho ETL solutions.

• Managed PostgreSQL, AWS RDS, and Oracle 19c environments.

• Developed Tableau dashboards and analytics reports. Senior Technical Consultant – Principal Search Consulting (Oct 2021 – Feb 2023)

• Developed ODI 12c ETL pipelines for OFSAA module.

• Implemented Change Data Capture (CDC) for incremental loads.

• Optimized SQL queries and built automated ETL workflows.

• Worked with Azure SQL Database, Oracle 19c,SQL Server, Power BI, and Tableau. Senior BI Consultant – AF Ferguson & Co (Feb 2016 – Aug 2021)

• Led Power BI reporting implementation for Allied Bank Limited.

• Delivered OBIA 12c implementation including ODI 12c ETL and Data Modeling.

• Installation Oracle 19c database, Database cloning, backup

• Designed Star & Snowflake dimensional models.

• Developed OBIEE RPD repositories and dashboards.

• Implemented data-level and user-level security.

Software Developer – RYK Sugar Mills Limited (Sep 2014 – Jan 2016)

• Developed ASP.NET web applications.

• Managed MySQL database operations.

EDUCATION

• Master of Computer Science – University of Lahore

• Bachelor of Commerce – Central College (Affiliate of Punjab University) CERTIFICATIONS

• Qlik Sense Training – PwC

• Oracle Cloud Application Training – PwC

• Oracle 12c Cloud & Form Builder Training – PwC

• Windows App Development – Microsoft Innovation Centre

Contact this candidate