YASIR HAFEEZ

Email: adxowg@r.postjobfree.com; Contact No.: +001 312-***-****

Data Warehouse & BI Professional

Summary:

Accomplished professional with 16 years of versatile experience in Data Warehousing, Data Modeling, ETL Design & Architecture and ETL Development. Experienced in planning and managing resources to successfully complete projects, while working in multi-cultural team environment and on-shore/off-shore working model. Efficient Team Leader & Player, combining communication, interpersonal & problem-solving skills with analytical, decision making and leadership capabilities to enhance organizational objectives.

Core Competencies:

Data Warehouse Design and Architecture

Data Modelling

Requirement Analysis

Data Profiling

Information Sourcing and Scoping

ETL Development

Performance Optimization

Preparation of detailed technical documents

Good domain knowledge in Telcom industry

Cross Functional Team Coordination

Professional Experience

Etihad Etisalat Mobily, Riyadh

Big Data and Automation Principal, Aug 2017 till Present

Job Role:

Understanding and analyzing Business User’s reporting requirements.

Defining the scope of the project based on gathered requirements and source data analysis.

Designing the model to store the data required to support the reporting requirements.

Defining business rules and mapping the source data elements onto the defined model.

Knowledge transfer to the ETL and Semantic Layer Development teams.

Managing team of multiple data modelers by assigning them work based on priority of end user requirements and reviewing their work to ensure quality of work.

Designing and developing the Presentation/Semantic Layer data marts.

Accomplishments:

Recipient of Employee of the Quarter Award for Q1 2019.

National Bank Of Abu Dhabi, Abu Dhabi

Senior Technical Analyst, Aug 2016 till Jul 2017

Job Role:

End to end support of the data warehouse operations in production environment.

Identify new reporting requirements in the bank which can be supported through the EDW.

Modeling, mapping and developing the ETL for integration of new data into the EDW.

NCR, Dubai

Professional Services Consultant, Dec 2014 till Jul 2016

Job Role:

Worked in the capacity of ETL Lead

Design and development of ETL architecture and framework.

Planning and management of ETL tasks and resources.

Quality control of ETL development.

Customer interaction for requirement gathering and review feedback.

Projects:

Ooredoo Oman, Apr 2015 – Jul 2016

Location: Muscat, Oman

Description: Worked as an ETL specialist to migrate the ETL code from Teradata utilities to Informatica. Also helped assist in identifying areas of improvement in the currently implemented ETL design and optimizing the ETL batch window. Troubleshoot and fix issues identified in the ETL implementation as reported by the business users.

Emirates Airline, Dec 2014 – Dec 2015

Location: Dubai, UAE

Description: Emirates Airline is a world’s leading Airline. The Emirates CBI data warehouse is a Teradata Industry “Travel and Hospitality LDM” implementation. The project is implemented on Teradata 15 database. Informatica PowerCenter 9.5.1 is used as the ETL tool. I worked on this project in the capacity of ETL lead. I managed a team of 15 ETL developers working on an on-shore/off-shore model. My responsibilities included understanding customer expectations and designing the ETL architecture in light of that, planning the ETL tasks, managing ETL resources (which were scattered mainly in 3 different locations i.e. Dubai, Cyprus and Pakistan), keeping an eye on the quality of the solution being delivered, meeting the timelines and getting customer feedback.

TERADATA GLOBAL CONSULTING CENTRE, Islamabad, Pakistan

Professional Services Consultant, Jun 2007 till Dec 2014

Job Role:

Involved in collation/ analysis of requirements and sourcing of information to define goal & scope of project

Translate business needs into technical requirements through Data Modeling and Data Mapping

Develop ETL Design & Architecture to define roadmap for ETL development

Focus on development & testing of ETL, loading of data and operationalizing Jobs based on defined frequency

Conduct knowledge transfer sessions for customer team members with regards to day-to-day operations

Ensure compliance to project delivery schedules and other SLA parameters

Focus on maximizing customer satisfaction through prompt resolution of issues and qualitative service delivery

Coordinate with various support teams in implementation of various process improvement initiatives

Projects:

Eircom, May 2013 – Dec 2014

Location: Islamabad, Pakistan (Off-Shore)

Description: Eircom is a telecommunications service provider in Ireland. My role on the project involved translation of logical data mappings into physical data mappings and validation of already developed physical data mappings. I was also involved in the project as a senior Informatica ETL developer and a coordinator between the on-site and off-site team.

Lloyds Banking Group, Jan 2014 - Mar 2014

Location: Bristol, UK

Description: Lloyds is the largest retail and commercial bank in the UK. I worked as an on-site semantic layer developer for Lloyds. I worked on the planning branch project, the purpose of which was to identify the correct planning branch for each retail customer based on the customer’s ATM and retail transactions.

PTCL, Nov 2013 – Dec 2013

Location: Islamabad, Pakistan

Description: PTCL is the largest landline telecom services provider in Pakistan. I had the experience of working as an ETL developer for PTCL earlier in 2007 as well. PTCL decided to upgrade their ETL infrastructure in 2013 and move the development from script-based utilities to Informatica PowerCenter 9. I worked as an ETL architect to design the Informatica ETL architecture. As part of the exercise, I setup the Informatica repository and Integration services, created users, user groups, roles etc. and defined the access rights, established the naming conventions and development standards and developed template ETL jobs that worked as guidelines for the ETL developers.

Telenor Pakistan, Mar 2013 – Oct 2013

Location: Islamabad, Pakistan

Description: Telenor Pakistan is the second largest telecommunication service provider in Pakistan and one of the key Clients for Teradata Pakistan. The data warehouse program at Telenor is 6 -7 years old which comprises of a Teradata CLDM implementation using Teradata as the RDBMS. They launched a Financial Intelligence project in Mar 2013 with the aim to integrate the financial Oracle ERP data into the already existing data warehouse

Involved in information sourcing, gap analysis, data profiling, ETL Design & Development, Data loading and migration into Production Environment and handing over operations to the Managed Services team.

Turk Telecom, May 2012 – Feb 2013

Location: Istanbul, Turkey

Description: Turk Telecom is the largest land line telecommunication services provider in Turkey. Turk Telecom Data Warehouse project is a Teradata CLDM 13 implementation using Teradata RDBMS and Informatica PowerCenter 9

Functioned as ETL lead, Data Mapper & Source system Analyst for Turk Telecom Data Warehouse Project. Lead a team of 5 ETL developers. Responsible for the ETL Design, development and loading of data into the Integrated Data Warehouse.

Ericsson Data Warehouse, Feb 2012– Mar 2012

Location: Stockholm, Sweden

Description: Ericsson is a leading provider of Telecommunication Networks worldwide. The Ericsson MSDP Data Warehouse project involved supporting Ericsson's managed services business.

Functioned as data mapper involved in understanding source & target logical data models, data profiling, developing a source matrix document to serve as a guide for the ETL developers.

Axfood Data Warehouse Project, Sep 2011– Oct 2011

Location: Islamabad, Pakistan (Off-Shore)

Description: Axfood is a retail chain in Sweden. The Axfood Data Warehouse is an implementation of Teradata’s industry Retail Logical Data Model with Teradata RDBMS and Informatica PowerCenter.

Worked as ETL consultant involved in development of ETL jobs, designing of ETL job scheduling and defining load strategy for the loading of data into the Data Warehouse

Nokia Data Warehouse Project, 2008 – 2011

Location: Helsinki, Finland (On-Shore) and Islamabad, Pakistan (Off-Shore)

Description: Nokia is a world leading cellular phone manufacturer. The Nokia Data Warehouse (NDW) Program is an implementation of Teradata’s industry Manufacturing Logical Data Model with Teradata RDBMS and Informatica PowerCenter.

Onshore/offshore ETL Lead Developer involved in ETL development using Informatica Power Center 8.6.1. Worked on various projects in the NDW program such as Sales Planning Simulation (SPS), Electronic Claim Handling, MAPS, Transportation Management System, Sales Organization and Factory Repair. Also had the chance to work for Managed Services handling the day-to-day operations of the Data Warehouse.

PTCL Data Warehouse (Pakistan), 2007 – 2008

Location: Islamabad, Pakistan

Description: PTCL is the largest land line Telecommunication Service Provider in Pakistan. The PTCL Data Warehouse is an implementation of Teradata CLDM. Teradata RDBMS is used as the data store whereas Teradata tools & utilities are used for ETL development.

Involved in development of ETL & job scheduling scripts, data loading, data testing and data reconciliation using Teradata tools/ utilities like Fastload, Bteq, Fastexport and Multiload

Accomplishments:

Recipient of Teradata GCC Employee of the Quarter (Q2, 2010)

Academics

MS Computer Science, National University of Computer and Emerging Sciences, Islamabad, 2007

Bachelor’s in Computer Science (Hons.), Government College University, Lahore, 2005

Certifications and Trainings

Teradata Master Certified V2R5

Informatica PowerCenter 8 Certified Developer

One-week Advance Informatica training conducted by Informatica

One week SAS Data Integrator training conducted by SAS Dubai

4-day UNIX shell scripting training at NUST.

1-week Abinitio training conducted by Abinitio

3-day Presentation Skills training conducted by CMD (Centre for Management Development)

2 days training on “Interest Based Negotiations” conducted by Teradata

Conducted 1-week fast track Teradata Factory training for Mobilink Pakistan Data Warehouse team

Conducted 2-week Teradata Factory training for Teradata GCC Lahore new hires in Lahore, Pakistan

Basic in-house IBM DataStage training in GCC Teradata

Teradata Factory Course by Teradata

Data warehouse Implementation Workshop by Teradata

3-day Qlik Sense training conducted by Qlik Dubai

Technical Skills

Advanced Skills

Teradata

Teradata tools & Utilities (Fastload, Multiload, FastExport, Bteq, TPT)

SQL

Informatica PowerCenter

Unix Shell scripting

Basic Knowledge

Oracle

IBM DataStage

SAS Data Integrator

C++

Microstrategy

Date of Birth: 13th March 1984; Languages Known: English and Urdu

Contact this candidate