Hafiz Mannan

Berufserfahrung von Hafiz Mannan

• Bis heute 1 Jahr und 7 Monate, seit Nov. 2022

  Senior Consultant - Oracle (DB, Migration, Data Warehouse, BI & Analytics)

  HPE

• Bis heute 6 Jahre und 10 Monate, seit Aug. 2017

  Technical Consultant (DB, BI & DWH) & Corporate trainer

  3As Technologies

  •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]

• 1 Jahr und 2 Monate, Nov. 2022 - Dez. 2023

  PRINCIPAL CONSULTANT - AWS PROFESSIONAL SERVICES

  7NSoft Systems (Pvt) Ltd USA

  •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

• 10 Monate, Feb. 2022 - Nov. 2022

  Head of Data

  The Entertainer (FLZ LLC) Dubai

  •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

• 10 Monate, Apr. 2021 - Jan. 2022

  Senior Database Architect

  Northbay Solutions

  •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

• 3 Jahre und 1 Monat, Sep. 2017 - Sep. 2020

  Sr. Consultant Databases

  Interactive Group

  •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

• 1 Jahr, Sep. 2016 - Aug. 2017

  Technical Consultant – Contractor

  Ministry of Interior, Doha - Qatar

  • 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

• 4 Monate, März 2016 - Juni 2016

  Technical Consultant - Oracle Services (Core, ERP R12, OBIEE)

  ICM Software House

  •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)

• 2 Jahre und 2 Monate, Feb. 2014 - März 2016

  Manager Databases, SAN and Systems

  Interactive Group

  • 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

• 5 Jahre und 8 Monate, Sep. 2007 - Apr. 2013

  Senior Consultant – Oracle DBA

  Ericsson Nigeria Ltd.

  - 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

• 3 Jahre, Okt. 2004 - Sep. 2007

  Systems Analyst (DBA)

  FFBL

  • 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

• 2 Jahre und 8 Monate, März 2002 - Okt. 2004

  Deputy Director Technical, DBA

  NADRA