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.