Irfan

Professional Experience

#Client: AT&T Inc.

Project Name: Sunrise Center’s

Project Description: AT&T it is the world's largest telecommunications company, the largest provider of mobile telephone services, and the largest provider of fixed telephone services in the U.S.it is also the parent company of mass media conglomerate Media. The Sunrise platform is the single place for the Retail Sales Organization to view and analyze all information needed to understand and improve performance of the Sales organization for all products Wired and Wireless. Including Sales Whiteboard and Key Performance Indicators, Customer Satisfaction, Inventory, and include Staffing, Scheduling, Training, Commissions, and Security. The goal is to be able to recreate a virtual store for any given point in time.

Environment: Informtica 10.1, Teradata 16.1

              Role: ETL Developer

Responsibilities:

•         Understanding the specification and analyzed data according to client requirement. Extensively worked in data Extraction, Transformation and loading from source to target system using BTEQ, FastLoad, and MultiLoad.

•         Developed modules to extract process & transfer the customer data using Teradata utilities.

•         Parsed high-level design spec to simple ETL coding and mapping standards.

•         Developed BTEQ scripts to load data from Teradata Staging area to Teradata data mart.

•         Designed the complete workflow for all the extracts mappings to serve the business requirements with dependency hierarchy.

•         Used ERWIN for metadata and table associations and essential data stage.

•         Tested the functionality of the systems in the development phase and designed the test plans for the data warehouse projects.

#Client: Telia Company

Project Name: BITS-AD (RxDoD)

Project Description: Telia Company AB is a Swedish dominant telephone company and mobile network operator present in Sweden, Finland, Norway, Denmark and Baltic States. Telia provide such as Tier-1 network provider, mobile network operator, internet service provider, fixed–line communication, IT hosting.Telia is Europe 5th largest telecom operator. Business purpose to create data warehouse is Legacy system to be replaced by BI-TS. Legacy Systems are having information like Customers, Subscriptions, network and revenue etc. in different file format.

Environment: Informtica 10.1, Teradata 15.1

              Role:ETL Developer

Responsibilities:

•         I am working with onsite offshore model, so we use to get the task from my onsite team.

•         Responsible for Extracting, Transforming and Loading data from files and relational database and processing it into Data warehouse.

•         Worked extensively on different types of transformations like Expression, Aggregator, Lookup, Sequence Generator and Joiner.

•         Creating / Building and Scheduling workflow and Sessions using the Workflow manager.

•         Worked on Teradata SQL Assistant querying the source/target tables.

•         Updated numerous Bteq/Sql scripts, making appropriate DDL changes and completed unit and system test.

•         Created scripts using FastLoad, Multi-Load to load data into the Teradata data warehouse

•         Involved in reviewing the Mappings.

•         Unit testing of ETL’s for the functionality and performance aspects.

•         Daily Communication regarding the status of the work to Onsite coordinator.