INFORMATICA DEVELOPER

ABDUL HAMEED acv5tw@r.postjobfree.com

Phone: 773-***-****

PROFESSIONAL SUMMARY:

Over all 10 yrs of IT experience which includes 8 years of strong data warehousing, ETL and OLAP experience using Informatica Power mart and Power Center 8.6/ 8.1/ 7x/ 6.2/6.1/ 5.1,(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), Business Objects, Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008/2005/2000/7.0/6.5, MS Access 2007/2005.

Experience in all aspects of the System Development Life Cycle.

Designed and developed complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Worked with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor tools.

Extensive UNIX Shell Scripting knowledge.

Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.

Experience in Performance Tuning of ETL to get quicker execution time.

Working Experience in E-R modeling-FACT & Dimensions tables, Physical & logical data modeling.

Involved in Extraction Transformation and Loading (ETL) Process in various projects using Informatica Power Center.

Worked Extensively with Slowly Changing Dimensions Type1, Type2 and Type3.

Knowledge of ETL command line utilities to execute workflows in Unix environment.

Experience in Capturing Incremental data (CDC) from source systems.

Strong technical skills with Unix/Linux systems.

Worked on error handling and problem solving in Informatica.

Experienced in integration and transforming of various data sources from Databases like Oracle, DB2, SQL Server and formats like flat-files, COBOL files, XML, etc.

Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.

Expertise in developing SQL,PL/SQL codes through various Procedures/Functions, Packages, Cursors and Triggers to implement the business logics of database.

Sound knowledge of views, Synonyms, Indexes, Partitioned Tables, Joins and Sub-Queries.

Experienced in data modeling and data normalization.

Strong understanding of OLAP/OLTP and relational database design Concepts.

Experience in Repository Configuration and processing tasks using Workflow Manager & Workflow Monitor to move data from multiple sources into targets.

Experience with managing ODBC connections.

Excellent communication skills and ability to learn new things and be highly motivated.

Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.

Ability to work under stringent deadlines with team as well as independently.

EDUCATION: Master of Business Administration (Concordia University Wisconsin)

TECHNICAL SKILLS:

DWH Tools

Informatica Power Center 9.1/8.6/ 8.1/ 7x

Business Objects 5.1/5.0,Netezza, TOAD, MS Access

EIM

Informatica Data Quality 9.x/Informatica Data Explorer, Informatica MDM 9.x

BI Reporting Tools

Cognos Analysis, Query Studio (Workspace Advanced)

Languages

Visual Basic, Clear Basic, ASP, PL/SQL, T-SQL.

Data Modeling Tools

Erwin, ER Studio

Databases tools

Oracle 11g/10g/9i/8i, MS SQL Server 2012/ 2008/ 2005/2000, SQL*Loader,Quest TOAD, UDB DB2 8.0, Sybase.

Environment

Windows Server 2012/2008/2003, Windows 7 & XP/2000, UNIX,LINUX

CRM Tools

Clarify 8.0/7.0

Scheduling tools

Informatica Scheduler, DAC, Autosys, Tidal Scheduler 2.5/5.3,Crontab, Control-M

PROFESSIONAL EXPERIENCE:

Client : State Farm Bloomington, IL.

Duration : OCT 2015 – July 2016

Role : Sr Informatica Developer

Environment: Informatica Power Center 9.6.0, IBM-AIX, DB2, Sybase, UnixShellScripting, Red hat Linux, HP Service Manager, ODS, WinSQL, Subversion, UC4.

Description:

State Farm is an American group of insurance and financial services companies in the United States. Its an industry leader known for financial strength and top-notch customer service. The group's main business is State Farm Mutual Automobile Insurance Company, a mutual insurance firm that also owns the other State Farm companies. It insure more cars and homes than any other insurer in the U.S. A mutual company focused on its policyholders, State Farm is currently ranked number 41 on the Fortune 500 list of largest companies. The project is to extract data from the ECS data warehouse and transforms as per the business requirements and by performing validations. Then data is loaded into intermediate stage and is finally loaded into new FDW data warehouse.

Responsibilities:

Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).

Worked on the build phase for the new data center migration of TAC project.

Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.

Lead the onsite and offshore team.

Modified existing mappings to accommodate new business requirements due to single instance impact at the source.

Worked on Data Conversion and Data Analysis.

Troubleshooting the issues in Informatica.

Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.

Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.

Improve availability and timeliness of test environments.

Performed ETL configuration and troubleshooting.

Worked with Sybase SQL statements for storing, retrieving, and manipulating data in a relational database.

Strong Knowledge of Oracle EBS/ERP

Worked with Security Analyst to upload the Unix script into Dynamic Password Lookup tool to securely access the application credentials.

Used ODS for integrating disparate data from multiple sources for business operations, analysis and reporting.

Created mappings to migrate data from Flat files, Sybase to data warehouse.

Strong technical skills with Unix/Linux systems.

Used DB2 Load utility to load the data from FDW table into the file.

Managed ETL Domain/Repository/Integrations services and workflows (Stop/Start) whenever the database servers are bounced.

Worked with ODS can for data scrubbing, resolve for redundancy and checked for compliance with the business rules.

Worked with DBA to create the derived tables required for ETL development.

Used UNIX Shell Scripting on Linux platforms to automate the loading process and to generate restart tokens for cold starting the workflows.

Created Sessions and Workflows to carry out the ETL process, configured sessions and connection parameters.

Extensively used unix commands to check the processes, view logs and troubleshoot the issues.

Used unix scripts to load the initial/incremental SQL into the file and then load into FDW table.

Worked closely with Unix SAs for troubleshooting OS related issues with applications and servers maintenance activities.

Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.

Used UC4 tool for automating and scheduling the ETL workflows.

Worked with different teams to trouble shoot the workflows/UC4 jobs failures due to db and network issues.

Developed Unit test cases and Unit test plans to check data is correctly loading.

Client : JPMorgan Chase & Co, Dallas, TX.

Duration : NOV 2011-SEP 2015

Role : Sr Informatica Developer

Environment: Informatica Power Center 9.1.0, Oracle 11g,SQL, PL/SQL, IBM-AIX, Sybase, UnixShellScripting, Red hat Linux, PVCS, TOAD,SQL Developer, Business Objects, UC4,Autosys, Erwin.

Involved in implementing change management process while fixing the existing code to enhance the code or bug fixing.

Coordinated with the DBA Teams, Source systems and offshore for different data loads (System test Load, Integration System Test Load, UAT Load and Pre production deployment load) and identified the bugs, new requirement changes and Data Quality Issue.

Prepared Technical Specification documents (TSD) for Mappings.

Troubleshooting the issues in Informatica.

Worked with Sybase SQL statements for storing, retrieving, and manipulating data in a relational database.

Good understanding of relational database management systems like Oracle,PLSQL,and SQL and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.

Created and Configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.

Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.

Designed and developed Mappings and mapplets with various transformations such as Connected and Unconnected Lookup, XML Source Qualifier, Filter, Joiner, Router, Stored Procedure, Sorter, Expression, Aggregator.

Developed the code for data extraction, data processing and data warehousing.

Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.

Planned and executed deployments across all environments.

Developed Slowly Changing Dimension Mappings for Type 1,Type 2 and Type 3 .

Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.

Performed ETL configuration and troubleshooting.

Loaded operational data from Oracle, Sql server, flat files, Excel sheets into various data marts.

Redesigned some of the existing mappings in the system to meet new functionality.

Used Debugger to fix the defects/ errors and data issues.

Reviewed ETL code for standards adherence before the migration and tuned mappings and workflows for better performance.

Migrated the repository objects (workflows) between the folders of different repositories.

Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision task.

Used UNIX Shell Scripting to automate the loading process and to generate restart tokens for cold starting the workflows.

Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.

Fine-tuned large/complex queries to improve batch load performances.

Move components across various environments like test, UAT, and production environment.

Prepared Test preparation and execution plans for different entities and executed the testing with team and Involved in Integration testing.

Client : Express Scripts, St. Louis, MO.

Duration : September 2010 to Oct 2011

Role : Sr.Informatica Developer.

Environment: Informatica Power Center 8.6.1,9.1,Power mart, Oracle 11g,SQL, PL/SQL, IBM-AIX, UnixShellScripting, MS SQL Server 2008, TOAD,SQL Developer, Business Objects, Autosys, Erwin.

Description:

Express Scripts is the nation's leading provider of prescription drugs safer and more affordable for tens of millions of consumers through thousands of employers, government, union and health plans. The project is in redesigning the existing data warehouse which involves extraction of data from the IMS data warehouse and transforms it by performing validations. Then data is loaded into intermediate stage and is finally loaded into new FMC data warehouse.

Responsibilities:

Involved in gathering business user requirements, understanding the business model (E-R Diagrams) and database tables.

Developed Technical design documents (TDD) from user requirements and functional requirements documents (FRD).

Design, implement and documenting ETL processes data warehousing practices and standards.

Extensively used Informatica Power center 9.1, Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.

Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.

Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.

Designed ETL strategy to load data from source systems such as UDB DB2,Oracle, XML, Flat Files to Target Data Base.

Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.

Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.

Altered mappings to accommodate new business requirements due to single instance impact at the source.

Created FTP connections to read data from the flat files from different server.

Worked with SQL statements for storing, retrieving, and manipulating data in a relational database.

Created partitions on the sources to improve the performance.

Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.

Used SCD Type 1, Type 2 and Type 3 mappings to update slowly Changing Dimension Tables.

Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.

Developed reusable transformations and mapplets, which were used in other operations.

Used SQL developer and TOAD to run SQL queries and validate the data in warehouse and data mart.

Worked with Variables and Parameters in the mappings to pass the values between sessions.

Used Debugger to test the mappings and fixed the bugs.

Migrated mappings to various environments like development, testing and production etc.

Scheduled sessions and work flows using Autosys and Informatica Scheduler.

Worked with the DBAs for the performance and database tuning.

Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.

Created workflows using Session, Command, and Email tasks.

Developed Unit test cases and Unit test plans to check data is correctly loading.

Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.

Used UNIX Shell Scripting to automate the loading process.

Provided reliable, timely support of integration, performance and user acceptance testing processes.

Client : VMWare, Palo Alto, CA.

Duration : July 2009 to August 2010

Role : Sr.Informatica Developer.

Environment: Informatica Power Center 8.6.1, Oracle 11g,SQL, PL/SQL, IBM-AIX,MS SQL Server 2008, UnixShellScripting, TOAD, Business Objects, Autosys, Erwin, MS Access.

Description:

VMware is the global leader in virtualization and cloud infrastructure delivers customer-proven solutions that accelerate IT by reducing complexity and enabling more flexible, agile service delivery. The project is in redesigning the data warehouse which involves extraction of data from the EBS data warehouse and transforms it by performing validations and applying business rules. Then data is loaded into intermediate stage and is finally loaded into new EMS data warehouse.

Responsibilities:

Involved in the full life cycle development of the project including: design, development, and testing.

Involved in gathering business user requirements, understanding the business model (E-R Diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.

Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule it.

Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations etc.

Used Surrogate keys in the Data Ware house tables to manage the Slowly Changing Dimensions (SCD) properly and easily.

Extracted data from multiple sources such as DB2, Oracle, XML, Cobol, Flat Files & MS Access and loaded the transformed data into targets in Oracle, Flat Files.

Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic.

Extensively used the features of Informatica Version 8.6 including Designer, Workflow manager and Workflow monitor.

Experience in dimensional modeling (star schemas, snowflake schemas /ROLAP, OLAP, MOLAP) .

Worked with SQL Server SQL statements for storing, retrieving, and manipulating data in a relational database.

Involved in Data migration, extraction, Data cleansing and Data Staging of operational sources using ETL processes.

Created partitions on the sources to improve the performance.

Extensively used Change Data Capture (CDC) approach efficiently to capture only the changed data.

Used stored procedures for truncating the tables and deleting the rows from error logs.

Created Sessions and Workflows to carryout the ETL process, configured sessions and connection parameters.

Worked with the scheduling tool UC4 to schedule the workflow jobs.

Developed reusable transformations and mapplets, which were used in other operations.

Worked with Variables and Parameters in the mappings to pass the values between sessions.

Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points and monitoring the debug monitor.

Worked on software engineering/SDLC tools, particularly Microsoft Team Foundation Server (TFS), to document and track work items from initial request through production deployment.

Conducted Informatica performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.

Used UNIX Korn Shell Scripting to automate the loading process.

Developed Unit test cases and Unit test plans to check data is correctly loading.

Client : WellPoint, Indianapolis, IN.

Duration : May 2008 to June 2009.

Role : Sr. Informatica Developer

Environment :Informatica Power Center 8.1.1, Oracle 10g,SQL,PL/SQL,UDB DB2, ODI,Toad, Mercury Test Director8.0,HP-UNIX, Citrix.

Description:

WellPoint is the nation's leading health benefits company serving the needs of more than 33 million medical members nationwide. It provides coverage for the medical care through WellPoint's affiliated health plans to their medical members. Wellpoint offer a broad range of medical and specialty products.

Responsibilities:

Worked on Informatica – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.

Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.

Responsible for managing scope, planning, tracking, change control, aspects of the Informatica Objects.

Used the Power Center 8.1.1, Designer’s debugger to test and fix bugs in the mappings.

Generated Reusable Transformations, Mapplets and used them extensively in many mappings.

Worked with Variables and Parameters in the mappings to pass the values between sessions.

Created and Monitored Sessions using Informatica Power Center Server to load data in to the Target Database.

Involved in Informatica GRID configuration & Data Modeling (ERD process).

Implemented the enhanced ETL mapping to Staging Database and from Staging to Data warehouse star schema.

Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.

Extensively used ETL to load data from flat files to Oracle and flat files.

Worked on converting PL/SQL loads to Informatica loads.

Responsible to tune ETL procedures, processes, and STAR schemas to optimize load and query performance.

Conducted performance tuning on sessions by optimizing block size, data cache size, sequence buffer length and commit interval.

Mercury Test Director is used for assigning and tracking the Change Requests (CR’s) and Test Problem reports (TPR’s).

Client : Ameriquest Mtg, Orange, CA.

Duration : May 2007 – April 2008

Role : Informatica Consultant

Environment: Informatica PowerCenter 7.1.1, Oracle 9i, SQL, PL/SQL, Business Objects, Suse Linux, Rational Rose, Clear Case, PVCS.

Description:

Ameriquest is a leading mortgage company. Several of the applications use Informatica for their reporting and data mart needs. All these teams use a centralized production environment. Involved in Design, Development and Implementation of Enterprise Data Warehouse and extensively worked with distributed databases to extract data into staging area.

Responsibilities:

Participated in build of the Data Warehouse which includes the Design of Data mart using Star Schema.

Integrated various sources in to the Staging area in Data warehouse for Integrating and Cleansing data.

Involved in Analysis/Design/Development and Implementation and successfully completed all the work involved in converting the company’s Operational data Store from SQL to Oracle database and deployed the systems in Production, with full Production Support.

Interacted with business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.

Extensively used Change Data Capture (CDC) approach efficiently to capture only the changes.

Responsible for creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts and created new jobs and their dependencies in Production

Involved in Control-M Implementation, Extensively used the scheduling tool Control M to schedule jobs and their dependencies in production.

Completely involved and alert in Easily Solved variety of issues during Production Support, ensuring smooth completion of data loading process.

Worked with DBA to fine tune complex SQL’s, do regular Run-Stats on the tables, drop and re-create indexes to decrease run times of various Informatica mappings which process large volume of data.

Extensively worked in planning the Metadata strategy and responsible for maintaining of the Metadata in the Enterprise Data Warehouse (EDW).

Involved in working with the Data Modeler in Data Modeling.

Client : Dean Health System, Madison, WI

Duration : March 2006 to April 2007.

Role : Informatica Consultant

Environment: Informatica PowerCenter 6.2, Business Objects 5.1, Oracle 9i, SQL,PL/SQL, UDB DB2 8.1, Toad, HP-UNIX, Citrix, eRequester and Rational Portfolio Manager (RPM).

Description :

Dean Health System is multi-specialty integrated healthcare delivery system based in Madison, Wisconsin, which provides Medical and Health services, Health Insurance, Ancillary health services and Clinical Research through a network of Dean-owned clinics throughout southern Wisconsin.

Responsibilities:

Worked on Informatica – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet designer and Transformations.

Worked on Informatica developments and enhancements by creating new mappings and making changes to the existing mappings as per the business requirements.

Worked on converting PL/SQL loads to Informatica loads.

Involved in development of various data migrations projects using Informatica like Siebel sales release (extracted and transformed data as per business rules from third party system ‘CALLBACK’ and loaded into Siebel tables), MDR database lease (extracted and transformed data as per business rules from third party leased flat files and loaded into Oracle tables to be used by Business Objects for reports).

Developed email routines to indicate failure or successful completion of workflows.

Involved in Migration of project from Development to Production environment.

Used Repository Manager to create folders, which is used to organize and store all Metadata.

Created mappings to migrate data from Flat files, DB2, Sybase, Oracle, and MS Access to data warehouse.

Implemented Joiner, Expression, Aggregator, Sorter, Rank, Lookup, Update Strategy, Filter, stored procedures, Normalizer Transformation and Router Transformations.

Worked on building Universes and universe modification using Business Objects on Oracle as database.

Resolved loops by creating aliases and contexts.

Created Measure Objects, Conditions and Functions as per the User requirements.

Developed Business Objects reports.

Involved in preparation of design documents, technical documents and Unit test documents.

Involved in Application migration phases (Application Specific Migration Phase, Guided and Assisted perform phase and parallel perform phase).

During Migration prepared various documents like Application specification Plan document, Application information document, Application support control plan and parallel perform completion report document.

Provided estimates and schedule inputs for service request (both Project service requests and Blanket service requests).

Responsible for creating all service requests in eRequester application which is used to track build activities and the effort estimates.

Responsible in creating all the tasks created in eRequester application back in Rational Portfolio Manager (RPM) application which is used for tracking effort tracking, resources allocation and as document repository.

Assign tasks against Service Requests/Problem Tickets/User Queries to the team members.

Establish the cause of problem and try to resolve at Onsite.

Be the primary contact for customer/end-user queries.

Support release/rollout activities in acceptance and production environments.

Participate in review of requirements and high-level design with client.

Review and Monitor progress.

Ensure compliance with Software Development Life Cycle (SDLC).

Client : ProQuest Information & Learning, Ann Arbor, MI.

Duration : September 2005 – February 2006

Role : Informatica Consultant.

Environment : Informatica Power Center 6.1, Business Objects 5.0, Oracle 9i,10g, MS SQL Server 2000,Red hat Linux, Erwin, UNIX Shell Scripting.

Description:

ProQuest Information and Learning is a global leader in collecting, organizing and publishing value-added information to researchers, faculty, and students in libraries, government, universities, and schools in over 160 countries. ProQuest has signed an outsourcing agreement with IBM Global Services (IBM) for Application Development / Maintenance (AD/M) services.

Responsibilities:

Business Analysis and Requirements Gathering.

Involved in logical and physical data modeling.

Analysis and Design of ETL processes.

Extensively used Business Objects for BI reports.

Created and managed Universes.

Extraction, Transformation and Loading of the data Using Informatica Power Center’s Designer and Server Manager.

Worked on Informatica tools –Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.

Involved in the development of Informatica mappings and also tuned them for better performance.

Different sessions were run in the Server Manager and the log was studied to modify the mappings to obtain correct result from the transformation.

Used ETL to load data from source to Oracle database.

Worked on Data Conversion and Data Analysis. Stored data in the Data Warehouse about Claims, Customers, and Accounts.

Contact this candidate