Resume

Sign in

ETL Informatica Developer

Location:
Phoenix, Arizona, United States
Posted:
October 07, 2016

Contact this candidate

Abuhuraira

Experience Summary

Mr. Abuhuraira has nearly 7 years of experience in IT industry. He has been exposed to Informatica, Oracle, Netezza and UNIX shell scripting. He has involved as ETL Lead Developer in various phases of Data warehouse projects like Requirement Gathering, Designing, Development, Analysis and Post implementation support.

Strong IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Data Warehouse and Data Mart systems in the Life science, Telecom and Insurance industries.

Involved in Development and design of ETL (Extract, Transform and Loading data) methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center (9.x/8.x)

Extensively Worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer.

Strong experience on Workflow Manager Tools–Task Developer, Workflow & Worklet Designer.

Extensively worked on Informatica Advance Techniques - Dynamic Caching, Pushdown Optimization, Parallel Threading to increase Performance throughput.

Having good exposure in root cause analysis for complex logics by using SQL query.

Involved in complete Software Delivery Life Cycle (SDLC) in large data warehouse environment.

Experience in identify, research and resolve ETL production root cause issues. Experience in maintenance, enhancements, performance tuning of ETL code.

Education and Certifications

Title of the Degree with Branch Bachelor of Engineering (Manufacturing)

College/University College of Engineering Guindy Campus, Anna University

Year of Passing 2008

Technical Skills

Operating System Windows 98/XP/2000/Vista/7/ 8/10, UNIX

Technology Datawarehousing

Programming Languages C, HTML, UNIX Shell Scripting

Databases Oracle 9i, 10g, 11g, Netezza 4.6.5, Teradata

Tools Informatica Power Center 8.6.0, 9.0.1, 9.6.1

Other Utilities WinSCP, Putty, Oracle SQL Developer, TOAD

Certifications

No

Name of Institution

Diploma or Certificate

Year of Completion

1

Informatica

S - Power Center 8 Mapping Design

2011

2

Informatica

U - Power Center 8 Advanced Mapping Design

2011

3

Informatica

R - Power Center 8 Architecture and Administration

2011

4

CSC

.NET developer

2008

Project #1

Title PAS Conversion DW

Client American Automobile Association (AAA)

Operating System Windows 7 & UNIX

Tools / DB / Script Informatica, Oracle & UNIX Shell Scripting

Team Size 18

Role ETL Lead developer

Period Nov 2015 – Till Date

Location Phoenix, AZ, USA

Client Description

As North America’s largest motoring and leisure travel organization, AAA provides more than 52 million members with travel, insurance, financial and automotive-related services which is formally known as CSAA Insurance Group. It is one of the top 20 personal lines property and casualty insurance groups in the United States recently celebrating 100th anniversary in 2014. It offers automobile, homeowners and other personal lines of insurance to AAA members through partnerships with AAA clubs in 23 states and the District of Columbia. With an A+ rating by A.M. Best, the insurance industry's most respected ratings agency, the company wrote $3 billion in premiums in 2014. In the past 10 years, it has grown from a regional insurance provider in three states to a coast-to-coast organization serving nearly 17 million AAA members. Headquartered in Walnut Creek, CA, it has more than 3,600 employees located primarily in Arizona, California, Colorado, Nevada, New Jersey, and Oklahoma.

Project Description

Policy Administration System(PAS) Conversion project is developed for AAA IE is an Insurance Service provider who is the leading agency writer of Automobile Insurance in America. The PAS program aims to improve policy administration business processes and time to market through implementation of a new policy administration system that is reliable, flexible, and supports product innovation. The objective for the Auto Insurance Business Requirements for all AAA NCNU products and states is to develop business requirements for the initial release of the PAS to be used as input into detailed design and development. Our goal is to convert all the existing legacy system policies into PAS environment (Exigen) as an XML feed.

Role and Responsibilities

Mr.Abuhuraira is being a part of team providing Technical and Functional Support during design and built phase using Oracle and Informatica as technical platform. Mr.Abuhuraira as ETL lead developer is responsible to

User Requirement gathering and converting the same into Functional and Technical Specifications.

Actively involved with BSAs and SMEs and Analyst to resolve the ambiguities in the requirements and participate in gathering of business requirements and carry out a suitable data Model for DataMart.

Follow good security coding practices to ensure the application is free from most common coding vulnerabilities. Provided architectural design for Informatica.

Involved in System analysis, Estimations and design enhancements.

Participated in High Level design discussion and worked throughout the design cycle.

Lead offshore development team of 4 members and interaction with client on daily basis.

Develop the XML generation using Informatica and able to interpret the XSD definition and modify the XSD in order to work in Informatica.

Able to understand and generate the XSD definition.

Participate in code reviews.

Identifying performance bottlenecks and fine-tuning ETL mappings and workflows for performance. Created scripts for automating dropping-recreation of warehouse table indexes for bulk loads.

Participate in transitions of the application or technical architecture components to the testers. Provide a fix for any defects and performance issues discovered in testing.

Project #2

Title GRID DB Data Quality Audit

Client AT &T

Operating System Windows 7

Tools / DB / Script Informatica, Oracle & UNIX Shell Scripting

Team Size 52

Role ETL Lead developer

Period Mar 2015 – Oct 2015

Location Chicago, US

Client Description

AT&T Inc. is an American multinational telecommunications corporation headquartered in Whitacre Tower, downtown Dallas, Texas. AT&T is the largest provider both of mobile telephony and of fixed telephony in the United States, and also provides broadband subscription television services. AT&T is the third-largest company in Texas (the largest non-oil company, behind only ExxonMobil and ConocoPhillips, and also the largest Dallas Company). As of April 2012, AT&T is the 17th largest company in the world by market value, and the 13th largest non-oil company. As of 2012, it is also the 20th largest mobile telecom operator in the world, with over 106 million mobile customers. AT&T is one of the top 10 Fortune 500 Company and one of the largest cable operator in United States. AT&T provides advanced video, high-speed Internet, and telephone services to approximately 80 million residential and business customers and provides the world’s largest long-distance and Wireless network in North America.

Project Description

GRID DB Data Quality Audit is a project handled by the Enterprise Analytics Practice of Cognizant. The team specializes in framing the analytical reports to the higher level leadership audiences of AT&T. The existing system consists of 60+ BO based reports which leverage data from All Data layer applications.

The primary focus is on developing these BO reports to show the discrepancy across Data layer application in order to overcome the pain areas listed below. The existing data layer gets impacted due to several project engagement taken place which resulting in showing the inconsistencies in the data across data center. It leads to show improper data in key areas like Customer Billing, Credit, Installment, device, product and revenue information etc. Our primary focus is to create a framework across these data layer application and report the discrepancies.

Role and Responsibilities

Mr.Abuhuraira was being a part of team providing Technical and Functional Support during design and built phase using Netezza / Oracle and Informatica as technical platform. Mr.Abuhuraira as ETL lead developer was responsible to

Perform the detailed design of application and technical architecture components.

Presented all of the Informatica tools to the Client, its usage, advantages and disadvantages for them to make up their mind to proceed with specific tools of Informatica.

Actively involved with BSAs and SMEs and Analyst to resolve the ambiguities in the requirements and participate in gathering of business requirements and carry out a suitable data Model for DataMart.

Work with the business architect and other planners to assess current capabilities and identify high-level business requirements.

Confirm the design with the stakeholders to ensure that the design satisfies the requirements. Work with other developers, designers, and architects to make sure that the configuration and Custom components meet application requirements and performance goals.

Follow good security coding practices to ensure the application is free from most common coding vulnerabilities. Provided architectural design for Informatica.

Documented ETL requirements and translate the Business logic into ETL language.

Participate in code reviews.

Project #3

Title AZ AD Symphony DM – ANTP.

Client AstraZeneca

Operating System Windows Vista

Tools Informatica, Oracle & Netezza

Team Size 65

Role DI Lead developer

Period Jan 2013 – Feb 2015

Location Chennai, India

Client Description

AstraZeneca is one of the world’s leading ethical pharmaceutical companies which provides innovative, effective medicines designed to fight disease in important areas of medical need: cancer, cardiovascular, central nervous system, gastrointestinal, infection, pain control and respiratory. AstraZeneca is active in over 100 countries with growing presence in important emerging markets; corporate office in London UK; major R&D sites in Sweden, the UK and the US. AstraZeneca employs around 12,000 people at 16 research and development centers in 8 countries. AstraZeneca has a broad product portfolio including many world leaders and a range of high potential medicines designed to meet the needs of patients and the healthcare professionals who treat them.

Project Description

The Cornerstone Reporting & Analytics environment is the current reporting system developed to support Headquarters Commercial Analytics and the Field Sales Reporting Tool in AstraZeneca. The Cornerstone reporting environment utilizes Microstrategy Business Intelligence Tool as the platform for delivering the needed data. The current reporting solution leverages Netezza and Informatica as the technical platform. AstraZeneca is in the process of developing a new and enhanced information platform that will provide information in a more robust, flexible and efficient way. This new platform will ultimately replace the existing Cornerstone and Touchstone Reports systems and provide analytical capabilities across the commercial functions (Ex: sales, marketing and managed markets).

This effort is aligned to the Symphony Information Delivery Program. The scope of this project includes the definition of the key indicators and business rules required to measure performance across the commercial organization. The scope also includes a recommendation for the structured organization and design of a fast, flexible, intuitive data model to support effective business decision making and insight generation.

Role and Responsibilities

Mr.Abuhuraira was being a part of team providing Technical and Functional Support during design phase and built data marts using Netezza and Informatica as technical platform. Mr.Abuhuraira as DI lead developer was responsible to

Created Integration Requirements and Design Specification Document.

Provided architectural design for Informatica.

Defined and designed flow and standards for Informatica.

Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that enhance business decision-making.

Documented ETL requirements translation of Business logic into ETL language.

Lead the offshore team of ETL Developers for Customer Master Module and providing them with in depth understanding of the Architecture, ETL system design and requirements.

Involved in designing the Data warehouse based on the requirement document using Informatica Power Center 9.0.1.

Extensively worked with flat files and excel sheet data sources. Wrote batch scripts to automate flat file transportation local to Informatica server.

Utilized worklets to trigger job execution based on flat file availability for file sourced mappings. Scheduling and automating jobs to be run in a batch process.

Used Deployment group migration.

Trouble shooting and resolving issues in workflow objects.

Project #4

Title AZ AD CAN EDW MDM Integration.

Client AstraZeneca

Operating System Windows Vista

Tools Informatica, Oracle, UNIX

Team Size 14

Role ETL Architect / Senior DI developer

Period May 2012 – Dec 2012

Location Chennai, India & Mississauga, Canada

Client Description

AstraZeneca is one of the world’s leading ethical pharmaceutical companies which provides innovative, effective medicines designed to fight disease in important areas of medical need: cancer, cardiovascular, central nervous system, gastrointestinal, infection, pain control and respiratory. AstraZeneca is active in over 100 countries with growing presence in important emerging markets; corporate office in London UK; major R&D sites in Sweden, the UK and the US. AstraZeneca employs around 12,000 people at 16 research and development centers in 8 countries. AstraZeneca has a broad product portfolio including many world leaders and a range of high potential medicines designed to meet the needs of patients and the healthcare professionals who treat them.

Project Description

AstraZeneca Canada EDW MDM remediation project is to design a new architecture from MDM source system instead of CAT, PeopleSoft as well as all other dimensional source systems. Previously all dimensional information’s will be provided by separate Vendors like IMS, SAP, Visage, Etc. Since each vendor maintained their own standards, it’s difficult to compare sales against a single product throughout

all vendor data. So, Business wants to maintain all Dimensional data in one single vendor which has all source values linked in it.

Role and Responsibilities

Mr.Abuhuraira had been part of team providing Technical and Functional Support to design and built architecture to adopt the data from MDM source system. Mr.Abuhuraira as ETL architect was responsible for Extracting, Transforming and Loading all existed source systems dimensional data in EDW application while adopting the new MDM source system. Mr.Abuhuraira was taking care of any clarification required from client or customer to solve any issues during design and development phase of the project. Mr.Abuhuraira had coordinated in both onsite and offshore to drive this project. Mr.Abuhuraira was engage all technical discussion and shared the ideas to frame the logic based on business needs. Mr.Abuhuraira as DI lead developer was responsible to

Gathered requirements from users and document the sessions during the inception/Analysis phase of the project.

Followed best practices of the waterfall model / spiral model of SDLC practices.

Actively involved with BSAs and SMEs and Analyst to resolve the ambiguities in the requirements and participate in gathering of business requirements and carry out a suitable data Model for DataMart.

Analysed the requirement and provide the inputs to Offshore Team.

Created plan for ETL teams development and QA activities.

Involved in preparing technical design/specifications for data Extraction, Transformation and Loading.

Lead the team and provided all technical feed to the team to develop the complex logic and resolve the issues.

Have very good understanding of Informatica 9 version including new features.

Used Normalizer transformation to normalize and de-normalize the data.

Developed various complex mappings with parameter files, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Designer.

Studied the current OLTP system to understand the existing data structures.

Used Deployment group migration.

Trouble shooting and resolving issues workflow objects.

Workflow errors that require service request to Informatica for problem resolution.

Project #5

Title AZ Momentum – Canada – EDW Sup.

Client AstraZeneca

Operating System Windows Vista

Tools Informatica, Oracle, UNIX

Team Size 11

Role Senior ETL developer

Period Jan 2010 – Apr 2012

Location Chennai, India

Client Description

AstraZeneca is one of the world’s leading ethical pharmaceutical companies which provides innovative, effective medicines designed to fight disease in important areas of medical need: cancer, cardiovascular, central nervous system, gastrointestinal, infection, pain control and respiratory. AstraZeneca is active in over 100 countries with growing presence in important emerging markets; corporate office in London UK; major R&D sites in Sweden, the UK and the US. AstraZeneca employs around 12,000 people at 16 research and development centers in 8 countries. AstraZeneca has a broad product portfolio including many world leaders and a range of high potential medicines designed to meet the needs of patients and the healthcare professionals who treat them.

Project Description

This project ensures that various processes essential for ensuring continuous business are managed, executed and monitored. In the event of failure, this team will respond with agreed service levels to ensure that the problem is resolved to the satisfaction of the end user. AstraZeneca Canada Enterprise Data Warehouse is a Sales and marketing application. The input feed for this application is obtained from sources like IMS, Brogan, Visage, NATP, Proscape & AZ internal data. Reports are developed on top of the data warehouse that gives the commercial teams and all key stakeholders single version of truth.

Role and Responsibilities

Mr.Abuhuraira had been part of team providing Operational Support to multiple applications.

Abuhuraira as Senior ETL developer will be responsible for Extraction Transform and Loading all source systems data into EDW application for reporting. Mr.Abuhuraira was taking care of any clarification required from client or customer to solve any production issues and he had to provide the clarifications requested by the client or customer. Along with these he was responsible for

Using Workflow manager and monitor for Workflow, sessions and database connection management and workflow monitoring.

Informatica environment administration. Creating users and groups, configuring profiles and privileges. Configured folders and folder security. Configured shared folders for re-usable objects.

Fixing invalid Mappings, modifying and testing coded procedures and functions, Unit and Integration Testing of Informatica sessions, batches and target Data. Created PL/SQL packages for iterative costing calculations

Developed Mappings for loading data from Multiple Sources into Oracle tables.

Perform daily operations of the EDW and related systems, user admin, interface processing and release management, disaster recovery.

Automating all the loads with the scheduling tool AutoSys

Provide Production incident and Production monitoring services

Resolving production incidents in the ETL as per the agreed SLA.



Contact this candidate