PROFESSIONAL SUMMARY:

• Over 12 years of working experience in Data warehouse, data marts and ETL development, maintenance, testing, business requirements analysis, administration and documentation. Good experience in data ware house development in areas of health care, financial industry and Telecommunication.
• Experience in Informatica 9.6/9.1/8.6/7.1/6.2 client tools - Designer, Repository Manager and Workflow Manager. Developed more than 200 mappings so far.
• Extensive experience working with large scale OLAP & OLTP applications
• Worked with the clients, users, business analysts and technical staff to design, develop and enhance Data Warehouse models, Business Intelligence solutions, scripts, Procedures and Metadata for relational databases.
• Experience in various stages of System Development Life Cycle (SDLC) and its approaches like Waterfall, Agile Model.
• Expertise in using various Active/Passive transformations like Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy, Sequence Generator, Source Qualifier and Stored Procedure transformations etc.
• Extensive experience with Oracle/DB2/SQL Server SQL queries, PL/SQL procedures, functions, triggers and Packages etc.
• Expertise in implementing complex business rules by creating re-usable transformations and Mappings/Mapplets.
• Expertise in Unit Testing and Integration Testing Of the Application.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• Experience in integration of various data sources like Oracle, Flat Files, Excel, VSAM Files, Access, DB2 and XML files.
• Strong experience with Star and Snowflake schema, dimensional data modeling, fact and dimensional tables & slowly changing dimensions.
• Involved in Requirement Gathering, Analysis and Implementation by considering various business requirements/issues such as technical, security and performance.
• Expertise in Folder/Mapping/Session/Workflow migrations and Repository administration.
• Expertise in writing various Korn/Perl Scripts for ETL process in UNIX.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.1/8.1/7.1/6.2, Power Mart 6.2/5.1.1/5.0 (Source Analyzer, Data Warehouse Designer, Repository Manager, Workflow monitor, Mapping Designer, Mapplet, Transformation Developer),Power Connect 7.x, OLAP, OLTP, SQL*Plus, SQL*Loader, IBM Websphere DataStage 8.1 (Parallel&Server)

Databases: Oracle 10g/9i/8.x/7.x, SQL Server 7.0,DB2, MS Access, Informix and Teradata V2R6

Reporting Tools: Cognos 8.5/8.4, Crystal Reports, Developer 2000 (Forms 4.5, Reports 2.5)

Process Models: Waterfall, Agile.

Data Modeling: Star-Schema Modeling, Snowflakes Modeling, FACT and dimension Tables, Erwin

Query Tools: Toad, SQL Navigator, SQL Assistant, Bentic

Languages: SQL, PL/SQL, XML, C, C++, Java.

Scripting languages: Unix-Shell Scripting, Perl, java Script, and VB Script

Operating Systems: Unix, SOLARIS, Windows XP/NT/2000/98/95

Networks: Windows NT, Windows 2000,Novell Netware

Internet Tools: HTML, DHTML, CSS, XML, ODBC

Packages: MS Office (MS Access, MS Excel, MS Visio, MS PowerPoint, MS Word)

GUI: Developer 2000, Visual Basic 4.5/5.0

Bug Tracking Tools: Bugzilla, Clear Quest .

Version Control Systems: VSS, CVS, Clear Case.

Application Servers: Web Logic 7.0/8.1, Web Sphere 5.1

Other: AutoSys, Control-M SAP B/W R3, LDAP, Opcon Scheduler, ATS

PROFESSIONAL EXPERIENCE:

Confidential, Woodlawn, MD

Informatica ETL Consultant / Informatica Production Support consultant

• Confidential 's legacy is a partnership that began when the North American Public Sector business of CSC and SRA International merged to become a leading provider of next-generation IT solutions and professional services with over 50 years of combined legacy experience supporting U.S. government agencies and programs.
• Working as a senior ETL developer which involves creating Informatica ETLs using Informatica Power Center client tools
• Working on PECOS (Provider) and CME (BENE) projects to load vendor data into the staging and data mart areas.
• Responsible for creating the business requirement documents, high level & low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Responsible for interacting with and business analysts, business users, SMEs & technical architects whenever there is a need for the redesign of the existing ETLs and process improvements
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development, and Scrum.
• Responsible for review the code developed by other developers.
• Developed SQL overrides in source qualifiers and lookup transformations according to business requirements
• Involved in Performance tuning at various levels including Target, Source, Mapping, Session level.
• Involved in creation and running sessions, Workflows using Workflow Manager to load data into the Data Warehouse.
• Involved in developing and documenting data mappings, Transformations and Informatica Sessions.
• Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.
• Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs.
• Implemented the application to move the obsolete Informatica objects from main folders to obsolete folder using the UNIX shell scripts
• Identified issues existed in Informatica mappings and worked on implementing the required changes in them.

Environment: Informatica Power Center 9.6, Oracle 11g/10g, IBM DB2, AIX UNIX 5.3, OS/400, JIRA,ALM, Teradata SQL Assistant,DB2/400, Teradata SQL Assistant, Oracle SQL Developer, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe and SVN Version Control 1.6.

Confidential, Baltimore MD

Informatica ETL Consultant / Informatica Production Support consultant

• Worked as a senior ETL developer which involves creating Informatica ETLs using Informatica Power Center client tools
• Responsible for creating the business requirement documents, high level & low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Responsible for interacting with and business analysts, business users, SMEs & technical architects whenever there is a need for the redesign of the existing ETLs and process improvements
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development, and Scrum.
• Responsible for review the code developed by other developers.
• Developed SQL overrides in source qualifiers and lookup transformations according to business requirements
• Involved in Performance tuning at various levels including Target, Source, Mapping, Session level.
• Involved in creation and running sessions, Workflows using Workflow Manager to load data into the Enterprise Data Warehouse (EDW)
• Involved in developing and documenting data mappings, Transformations and Informatica Sessions.
• Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.
• Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs.
• Implemented the application to move the obsolete Informatica objects from main folders to obsolete folder using the UNIX shell scripts
• Identified issues existed in Informatica mappings and worked on implementing the required changes in them.

Environment: Informatica Power Center 9.6/9.5, Oracle 11g/10g, IBM DB2, AIX UNIX 5.3, OS/400, DB2/400, Windows XP, Quest TOAD 9.0, Oracle SQL Developer, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe and SVN Version Control 1.6.

Confidential, Buffalo NY

Informatica ETL Consultant / Informatica Production Support consultant

• Worked as a senior ETL developer which involves creating Informatica ETLs using Informatica PowerCenter client tools
• Responsible for creating the business requirement documents, high level & low level design documents, creating ETL specifications, test cases documents for all the new mappings developed for production applications in compliance with SDLC processes
• Worked as on call person for Informatica and Kalido DIW production issues on rotation basis
• Participated in designing and development of software using agile development practices.
• Responsible for fixing around 1500 production related issues which includes very complex data issues
• Worked as the primary person from AMS team related to transition of the new EDW implemented using Kalido DIW and MDM to AMS team
• Responsible for interacting with and business analysts, business users, SMEs & technical architects whenever there is a need for the redesign of the existing ETLs and process improvements
• Responsible for mentoring the new resources brought into the team
• Responsible for review the code developed by other developers.
• Developed SQL overrides in source qualifiers and lookup transformations according to business requirements
• Implemented the application to move the obsolete Informatica objects from main folders to obsolete folder using the UNIX shell scripts
• Implemented 50 new Informatica mappings as a part of automation of the existing monthly manual and new processes
• Identified issues existed in Informatica mappings and worked on implementing the required changes in them
• Worked closely with Cognos reporting team whenever there is an issue with data feeds to build Cognos cubes and reports.

Environment: Informatica PowerCenter 9.1/8.6, Oracle 11g/10g, IBM DB2, AIX UNIX 5.3, OS/400, DB2/400, Windows XP, Quest TOAD 9.0, Oracle SQL Developer, Visio 2003, Microsoft Project 2003, Microsoft Visual SourceSafe and SVN Version Control 1.6 and Cognos 8.0, Rational Clear Quest 7.0

Confidential, Camp Hill, PA

Informatica ETL Consultant

• Based on the functional requirements created technical design specification documents for ETL Process.
• Responsible in building maps by uses various transformations like Source Qualifier, Expression, Aggregator, Rank, Joiner, Lookup, Update Strategy, Stored procedure Transformations based on the requirement from the end users.
• Participated in designing and development of software using agile development practices and scrum meetings.
• Used Error handling strategy for trapping errors by using the error function in the mapping level and sending errors to an error table.
• Responsible for creating, handling and taking care of Parameter File Modifications in new releases and enhancement.
• Created Mapplets and reusable Transformations using Mapplet Designer, Transformation Developer for the Standardization of data as per the business requirements.
• Wrote the PL/SQL procedures for data fixes.
• Involved in Performance tuning at various levels including Target, Source, Mapping, Session level.
• Involved in creation and running sessions, Workflows using Workflow Manager to load data into the Enterprise Data Warehouse( EDW)
• Involved in developing and documenting data mappings, Transformations and Informatica Sessions.
• Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.
• Involved in the error checking and testing of ETL Procedures using Informatica Session log and workflow logs.
• Responsible for creation of reports and logs for the various jobs across the batch.
• Used UNIX, Shell scripting to create scripts, monitor the target data files, log files.
• Responsible for scheduling the workflows and monitoring them as per the requirement.
• Responsible for code migration from DEV - SAT - TFP - PRD environments using information repository manager.
• Responsible for extracting data from heterogeneous sources like Flat Files, COBOL, oracle, db2 and loading the same into Oracle and Teradata.
• Developed Unix Shell scripts for data extraction and file transfers and also used PMCMD command to start the workflows.
• Extensively used TOAD to test, debug SQL and PL/SQL Scripts, packages, procedures, triggers, and functions
• Involved in creating the test cases and test plans for user acceptance testing and system testing based on functional Specifications.

Environment: Informatica Power Center 8.1/7.1.3,Oracle10g/9i,Unix, Mainframes, COBOL, Bentic, Toad, VSS, Teradata, DB2, SQL Server, Opcon Scheduler, XML Spy, Edit plus, PL/SQL, SQL, Shell Scripts.

Confidential, Iowa

Data Warehouse Consultant/ETL Developer

• Responsible in building maps by uses various transformations like Normalizer, Source Qualifier, Expression, Aggregator, Rank, Joiner, Lookup, Update Strategy, Stored procedure Transformations based on the requirement from the end users.
• Created Mapplets and reusable Transformations using Mapplet Designer, Transformation Developer for the Standardization of data as per the business requirements.
• Wrote the PL/SQL procedures for data extraction, transformation and loading
• Involved in fine-tuning SQL overrides for performance Enhancements.
• Involved in creation and running sessions, Workflows using Workflow Manager to load data into the Enterprise Data Warehouse (EDW)
• Involved in developing and documenting data mappings, Transformations and Informatica Sessions.
• Responsible for developing the mappings and workflows for claims and billing department for their day to day report activities.
• Responsible for developing mappings that evaluate claims to ensure the applicants qualified for re-insurance benefits.
• Responsible for developing mappings that confirms to business rules for claims to confirm coverage and to determine liability, compensability and to damages.
• Responsible for developing mappings and workflows to Evaluate claims for potential fraud and makes referrals to the Special Investigations Unit as appropriate by generating emails to authorized personal.
• Involved in building Oracle views and stored procedures using Toad.
• Responsible for developing mappings to determine the business rule that determines if claims would qualify for the reinsurance coverage and its terms.
• Involved in monitoring the sessions, workflows and worklets using Workflow Monitor to ensure the data is properly loaded into the Enterprise Data Warehouse.
• Used UNIX, Shell scripting to create scripts in loading data from flat files to target files, monitor the target data files, log files.
• Involved in manual testing, functional testing and Integration testing.
• Responsible documenting the bugs during testing and reporting the same to leads and co-workers/peers.
• Responsible for performing root cause analysis and reporting.
• Knowledge with Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.

Environment: Informatica Power Center 7.1.3, IBM Websphere DataStage 8.1 (Parallel&Server), Business objects 5.1, Oracle 8i, SQL Server, DB2, Erwin 4.0, UNIX Shell Scripts, PL/SQL, SQL, and WinNT4.0/2000.