Hafiz Muhammad Umar Farooq Email and Phone Number

• Leading and supervising a team of 8 engineers to ensure seamless project execution and timely delivery of high-quality solutions.• Designing and developing ETL Processes based on business rules using Informatica Power Center.• Developing complex Informatica mappings using expressions, aggregators, filters, lookup, and stored procedures to ensure movement of the data between various applications.• Responsible for efficiently managing four Teradata systems, ensuring seamless data distribution, and maintaining optimal system availability to meet diverse business user requirements.• Task delegation to the team for ETL scripts, model implementation and its deployment after successful testing; and leading overall technical effort for ETL development using SLJM and PowerCenter Informatica.• Formulate techniques for quality data collection to ensure adequacy, accuracy, and legitimacy of data.• Providing technical support to BI team to understand source system and semantic layer and assisting them with reports and data extraction when needed.• Collaborate with stakeholders, Sales, Marketing, Finance, Ubank and technology teams to define project scopes, objectives, and deliverables, ensuring alignment with organizational strategies.• Develop detailed project plans, including timelines, milestones, and resource allocation, while closely monitoring progress and addressing potential roadblocks.• Implement agile methodologies to enhance team productivity, facilitate effective communication, and adapt to changing project requirements.• Conduct regular performance evaluations for team members, providing constructive feedback and identifying opportunities for skill development.• Troubleshooting operational issues, escalating, and resolving business partner issues in a timely manner with strong collaboration for business priorities. • Plan initiatives for migrating data repositories from existing data warehouse to Big Data platform.

EDW Modernization Vodafone Qatar (ETL Developer)• Requirement gathering from business users• Performing data profiling and data modeling• Develop ETL process by using DataStage mappings, PL/SQL packages and procedures as per model• Data integration activities for existing Data-warehouse• Strategize history loading of 3-year data and data management without impacting existing live batch• Creating sequences and performing data loading for Technical and Business UAT• Deploying ETL jobs in production environment

Data Engineer (JAZZ-Pakistan)• Lead team for ETL migration from Teradata to DB2 using Informatica and IBM DataStage.• Leading AMS and performing complete maintenance and administration of all Jazz Teradata Systems including Test, Dev, and Production environment• Performing complete PowerCenter Informatica and IBM DataStage Administration• Linux/Unix system administration and script aiding in automation of data management, • Lead team for DB2 Warehouse Migration for Wave0 Project (Teradata to DB2)• Performing functional, business and performance UAT of Jazz DWH ETL after migration to DB2• Leading BAU Operations for DB2 and training new resources• Managing workloads on 44 node Cloudera (HDP 2.6) and recommend optimizations.• Implementing TASM new rules as per client requirement

• Responsible and performing DWH system operations and support for operational effectiveness.• Preparation, Scheduling and Monitoring of Data Warehouse ETL and ensuring daily and timely availability of data with 95% SLA.• Providing L1/L2 support to all DWH Users.• Performing Teradata DB Administration on production system.• Performing and managing DataStage Administration and operations.• Linux/Unix system administration and script aiding in automation of data management, transformation, and loading.• Identifying data sources and solve data quality issues to ensure data consistency and integrity in timely manner.• Planning and Implementation of Teradata Active Service Management (TASM) as per business requirements.• Identification and automation of statistics in Teradata.• Ensure maintenance of DWH space management on ETL and Teradata servers.• Responsible for accurate deployment of new sources/ CRs as per business requirements• Applying compression techniques (MVC & BLC) to gain space in TD DB.• Backup and restoration management of Teradata DB using TD DSA.

My Responsibilities includes:• Performing Teradata DB Administration on production and appliance systems.• Performing Informatica PowerCenter (9.6.1) Administration, and Development.• Planning, Implementing and Tweaking of Teradata Active Service Management (TASM) as per business requirements.• Linux/Unix system administration.• Identification and implementation of automated statistics in Teradata viewpoint portlet.• Data management and synchronizing on all three Teradata DB systems.• Coordinating with all vendors for excellent and smooth DWH operations.• Ensuring correct and updated statistics for all production databases.• Ensure maintenance of DWH space management on ETL and Teradata DB servers.• Synchronization and data retentions of Teradata systems according to department SLA’s.• Ensuring availability of DWH infrastructure and related services on 24/7 basis.• Backup recovery of ETL and Teradata system in case of any data lost/disaster.• Training other team members on developing and improving standardized data management operations.• Dimensional data analysis, forecasting and planning.Major Engagements:• Complete re-designing and successful implementation of TASM according to business requirements on 6650 and 2750.• Terdata new server 2750 structural design for databases and business users and migration of data from EDW nodes. • Column level and block level compression on 2580 nodes, MVC on 6650 nodes.• Teradata software upgrade 12.0 to 14.0 on 6650 and 2580 Nodes.• Teradata software upgrade 14.0 to 14.10 on 6650 and 2580 Nodes.• Teradata software upgrade 14.10 to 15.0 on 6650 and 2750 Nodes.• Upgrade of tape library to new solution i.e. Spectra T120 and configuration of backup on new tape library.• Implementation of different sources in DWH

• Performing Teradata DB Administration on production and appliance systems.• Performing and managing Informatica PowerCenter (9.6.1) Administration, and Development.• Linux/Unix system administration and script aiding in automation of data management, transformation, and loading.• Identifying data sources and solve data quality issues to ensure data consistency and integrity in timely manner.• Planning and Implementation of Teradata Active Service Management (TASM) as per business requirements.• Identification and automation of statistics in Teradata.• Ensure maintenance of DWH space management on ETL and Teradata servers.• Responsible for accurate deployment of new sources/ CRs as per business re• Backup and restoration management of Teradata DB (via NETVAULT application) along with media management.• Identifying areas for improvement in the reporting platform and plan for optimization, expansion and bringing operational efficiency.

• Responsible and performing DWH system operations and support for operational effectiveness.• Preparation, Scheduling and Monitoring of Data Warehouse ETL and ensuring daily and timely availability of data with 95% SLA.• Monitoring performance and managing parameters to provide fast query responses to 'front end' users.• Identifying data sources and solve data quality issues to ensure data consistency and integrity in timely manner.• Implementation of Teradata Active Service Management (TASM) as per business requirements.• Responsible for accurate deployment of new sources/ CRs as per business re• Ensuring availability of DWH infrastructure and related services on 24/7 basis.• Backup and recovery of ETL and Teradata system (via NETVAULT) along with media management.• Providing Level-1 support to all DWH users.• Identifying areas for improvement in the reporting platform and plan for optimization, expansion and upgrade operations.• Working collaboratively with other team members on developing and improving standardized data management operations and improving data quality control methods

• Responsible for accurate DWH system operations and support for operation effectiveness.• Preparation, Scheduling and Monitoring of Data Warehouse ETL and ensuring daily and timely availability of data with 95% SLA.• Identifying data sources and solve data quality issues to ensure data consistency and integrity in timely manner.• Ensuring 99 % Accuracy of data (Quality data) DWH by developing, executing and improving daily reconciliation mechanisms.• Ensuring availability of DWH infrastructure and related services on 24/7 basis.• Backup and recovery of ETL and Teradata system (via NETVAULT) along with media management.• Dimensional data analysis, forecasting and planning.• Data loading into Teradata using Systematic Load Job Management (SLJM) and Informatica systems.• Providing Level-1 support to all DWH users.

Work as Engineering Internee and learned basic telecom architecture and network troubleshooting.