Hafiz Mannan

•The Knowledge Academy UK: 6+ Consultants (USA)/ 90+ (UK) [OAS 5.9], 12+ (UK) [OEMM], 8 (UK/NZ) [ODI-12C] •World Bank: Numerous consultant teams (10+) [Data Warehouse & BI; ODI/OBIEE-12C, Oracle DB Admin-19c, Oracle RAC, Performance & Tuning •Director General Immigration & Passport HQ: 16+ [Oracle 12c Admin, Data Guard, RAC, Performance & Tuning, Utilities, DWH & BI Fundamentals, ODI, Analytics Server, DB Security Essentials, Oracle DB Admin-12c] •Ericsson Pakistan: 6[Oracle DB & Advanced Administration]

•Migrated on-premises database systems to AWS cloud for in EU and USA leading a team of how many? •Completed schema conversion, evaluated processes and tools, and executed processes for bulk migration and data change capture, ensuring zero down time •Designed target database architecture including infrastructure, instance and core database layers •Migrated 15+TB production databases from IBM DB2 to AWS Aurora PostgreSQL and 24x7 operational production databases from Oracle to AWS RDS PostgreSQL

•Managed executive/stakeholder relationship and expectations, and delivered within specifications and deadlines •Ensured data governance, leveraging a range of data processes and tools as per need •Oversaw the data pipeline and end-to-end lineage including collection, quality, placement, aggregation, and analysis of large quantities of data •Led data science projects including statistical analysis, predictive modelling, churning, and fraud detection initiatives •Headed company-wide dashboard development

•Designed, integrated, configured, upgraded, maintained, administered and optimised performance of databases on PostgreSQL, MySQL, Oracle and SQL Server •Configured PostgreSQL for DR site and migrated DB to cloud •Log analysis and performance review, and analyzed production database error logs and metrics for major performance bottlenecks, suggesting and supporting implementation of tuning steps •Tuned PostgreSQL performance, SQL Tuning, index maintenance, and PostgreSQL architecture and auto-vacuum

•Plan, design and manage high availability database architectures for different data/DWH/database-oriented solution; based on Oracle Technologies •Data Lake & life cycle management, including Operational Sources, Data Transfer, ETL/ELT •End to End ETL design, implement and management using ODI (Designer, Topology, Operator, source/target mapping) and Informatic (Defining source/targets, Transformation rules, mappings, workflow monitoring) •Backup & recovery including disaster recovery sites

• Planning, Designing and implementation of different databases’ systems; including Database Disaster recovery setups • Backup Optimization of existing database systems; ensuring no data loss and minimum downtime • Manage end to end database services (Oracle, SQL Server, mysql) running under development, testing and Production Status • Database migration/integration for different services/sections/projects; Implement database security and auditing

•Installation, configuration, patching of Oracle server software and related products (Oracle 11g Database, R12 Apps. OBIEE, ODI, Oracle Web Logic Application Server, RAC and Data Guard environments) • Oracle System monitoring; perform database/application/Web logic performance tuning, Design, implementation and maintenance of Security • Plan, establish backup and recovery policy as per company's requirement; Design and implement high availability architecture (Data Guard & Real Application Cluster)

• Planning, designing, Development, implementing & maintaining high availability database architectures for Data Warehouse and Transactional Systems • Provide leadership to a cross-functional team of 50+ members in delivering high-end technology solutions • Monitor and operations management of complex Database & Applications and systems based on Oracle technologies • Manage disaster recovery/ changes in compliance to standard ITIL standards

- Project integration & operations management of Telecom Fraud Management System - Project integration & operations management of Telecom Revenue Assurance System - System integration & performance optimization (Ericsson charging system - Voucher Server) - Oracle 10g,11g Database implementation & management of sized upto 300 & 900 Terabytes with daily data processing of 7 Billion Records

• Lead IT project teams (system/ network administrators, programmers, hardware technicians) – Acting Head of IT • Ensured smooth functioning of Oracle RDBMS and software applications being used for Finance, HR, Procurement and shares administration • Defined IT policies; evaluated, prepared & implemented annual budget for IT projects worth PKR 3 Million • Business process re-engineering, migration & return on investment for implementation of ERP • Prepared IT disaster recovery plans & documentation