YASIR HAFEEZ

Mobily is the second largest telecommunications service provide in Saudi Arabia and is part of the Etisalat group which is a multinational telecommunications service provider operating in 16 different countries

Job Role

• Understanding and analyzing Business User’s reporting requirements
• Defining scope of project based on gathered requirements and source data analysis
• Designing model to store data required to support reporting requirements
• Defining business rules and mapping source data elements onto defined model
• Designing and developing Presentation/Semantic Layer data marts
• Knowledge transfer to ETL and Semantic Layer Development teams
• Managing team of multiple CLDM modelers by assigning them work based on priority of end user requirements and reviewing their work to ensure quality of work

National Bank Of Abu Dhabi was a bank operating in the United Arab Emirates until it merged with the First Gulf Bank in, to form First Abu Dhabi Bank. NBAD was the largest lender bank in the Emirate of Abu Dhabi and in the United Arab Emirates

Job Role

• End to end support of data warehouse operations in production environment.
• Identify new reporting requirements in bank which can be supported through EDW.
• Data Modeling, mapping and developing ETL for integration of new data into EDW.
• Worked on following tools and technologies: Teradata, Oracle, SAS Data Integrator.

NCR is the world’s enterprise technology leader for restaurants, retailers, and banks

Headquartered in midtown Atlanta, NCR has over 35,000 employees and does business in 141 countries

Job Role

• Worked in 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, April 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 is an enterprise software company that develops and sells database analytics software. It was established in 1978 and has been a world leader in the field of Data Warehousing since then

Job Role

• Involved in collection and 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 operationalized 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 landline 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, 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, 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, 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, 2007 – 2008

Location: Islamabad, Pakistan

Description: PTCL is the largest landline 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.