SUMMARY

• Over 10 years of IT experience in diversified fields like Data Warehousing and Mainframe application development, out of which 7 years of experience in various Data warehousing applications.
• Extensively worked with large EDW systems in all functional areas including Insurance, Banking Financial, Healthcare, Telecommunications and Retail.
• Design and develop Extraction, Transformation and Loading ETL processes using Informatica to streamline and automate the collection of data from source systems, as well as the production and distribution of ad-hoc reports.
• Experience in Data Warehousing, Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact tables, Dimension tables.
• Experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Experience in creating Test Readiness Review TRR , Requirement Traceability Matrix RTM documents.
• Extensively worked on Informatica Designer components Source Analyzer, Warehouse designer, Transformation Developer, Mapplet, Mapping Designers and Workflow Manager Tools.
• Well versed in developing and testing complex mappings, using transformations like Filter, Router, Expression, Aggregator, Connected and Unconnected Lookup, Source Qualifier, Update strategy, Sequence Generator, Normalizer, Rank, Joiner and more
• Extensively used SQL Override function in Source Qualifier Transformation.
• Handling various loads like Daily Loads, Weekly Loads, Monthly Loads and Quarterly Loads using Incremental Loading Technique.
• Hands on experience in writing UNIX scripts for various purposes including FTP, Creating Parameter Files, file manipulation keyword search, PMCMD scripts for triggering Informatica workflows.
• Experience using Oracle, SQL Server, DB2 databases for data warehouse, data mart.
• Knowledge on Teradata databases, SFDC model.
• Experience in understanding the Business requirements and translating them into detailed design along with Technical specifications.
• Hands on experience in all aspects of Software Development Life Cycle SDLC .
• Extensively worked on applications using TSO/ISPF, COBOL, JCL, VSAM, DB2, SQL and CICS.
• Excellent Communication interpersonal skills.
• Strong analytical skills, able to work independently and manage/lead Informatica ETL Teams.

CONFIDENTAIL

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

CONFIDENTAIL

Sr. Informatica Developer/Support

In an effort to reduce deposits held by a TPA to fund loss payments imprest funds and improve the reconciliation procedures on ace billed CONFIDENTAIL business, a process to fund such accounts on a daily cleared basis via Zero Based Accounts ZBA needs to be instituted. Reimbursements will be based upon cleared checks versus issued, with ACE Treasury remitting funds based on summary data from the CONFIDENTAIL. Changes will be required in various processes currently associated with TPA business, i.e., CS Stars, CDW, Files for SBS. A repository will be developed and become the reconciliation tool for detail of treasury remittance and TPA issued check information.

Responsibilities:

• Gathered Business requirements from concerned users and analyzed the Functional Requirement Documents FRD and drafted the Technical Specifications based on the Informatica ETL standards and also conducted Impact and feasibility analysis.
• Used Informatica Power Center for extraction, transformation and loading ETL of data in the data warehouse.
• Created various Informatica jobs using transformations such as Source Qualifier, Normalizer, Union, Expression, Filter, Connected Lookup, Unconnected Lookup, Update Strategy, Sorter, Aggregator, Router, and Sequence Generator etc.
• Used Informatica Debugger for debugging mappings.
• Well versed in loading the Data into different targets from source systems like Flat files, Oracle, DB2 and loaded into Oracle and Flat files.
• Designed Reusable Transformations using the Transformation Developer created Mapping Parameters and Variables.
• Extracting data from set of flat files through Direct or Indirect file methods.
• Created various Informatica tasks such as Sessions, Email, Decision, Control, Command, Timer, Assignment, Event Wait and Event Raise.
• Developed Error Logging and Error Handling methodologies.
• Implemented Global Parameter file to centralized all the parameters and variables for the Database connections, file paths etc.
• Tuned Informatica mappings for better performance using various strategies based upon the analysis done.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Created UNIX Shell scripts to create wrapper scripts to run the workflows and ftp the target files to Mainframes server.
• Installed Informatica PowerCenter 9.1 and configured in Development, QA and Production.
• Created deployment groups for deploying the mapping from one environment to another.
• Responsible for Release migration in between different environments.
• Provided 24/7 On-Call support to resolve the Informatica related issues on Production system and used to support ETL Applications.

Environment: Informatica PowerCenter 9.x/8.x, Oracle 10x, IBM DB2, UNIX Shell Scripting, CA-7 Scheduling tool, Windows XP, SQL Server.

CONFIDENTAIL

Sr. Informatica Developer/Support

CONFIDENTAIL will collect detailed credit risk information as part of its efforts to comply with Basel II rules among other initiatives and store it in the PeopleSoft Enterprise Performance Management Data Warehouse EPM or Data Warehouse . The Credit Risk Data Warehouse CRDW will be the repository for the data used by BNY for its current credit risk and economic capital reporting conducted within the Portfolio Management Division PMD , and to provide data for Basel II credit and equity risk capital calculations. The CRDW processes daily credit risk information from 40 disparate source systems across BNYM using over 500 jobs running on a 20 hour window on a daily basis.

Responsibilities:

• Responsible for end to end Informatica ETL Process Design.
• Extensively used ETL Informatica for the extraction, Transformation and Load of source data which was from Oracle, DB2 and Flat Files.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing.
• Performed data validation testing writing SQL queries.
• Extensively worked with Performance Tuning at the mapping level and session level.
• Responsible for Requirement Gathering Analysis and End user Meetings to obtain the valid mappings in informatica.
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications.
• For Business meeting, conversion of business rules into technical specifications.
• Responsible for mentoring Developers and Code Review of Informatica Mappings developed by other developers.
• Worked on Informatica Power Center Tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL Override.
• Extensively used various Informatica active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation.
• Extensively used LTRIM, RTRIM, ISNULL, ISDATE, TO DATE functions in Expression Transformation for data cleansing in the staging area.
• Responsible for best practices like Informatica naming conventions, Performance Tuning and Error Handling.
• Developed Reusable Transformations and Reusable Mapplets.
• Solid experience in debugging and trouble shooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV Environment.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Create schedule the Job using IBM Tivoli OPC Job Scheduler.
• Provided 24/7 On-Call support to resolve the Informatica related issues on Production system and used to support ETL Applications.

Environment: Informatica Power Center 8.x/7.x Repository Manager, Designer, Workflow Manager , Oracle 9x, SQL Server, OPC, ESP Scheduler.

CONFIDENTAIL

Informatica Developer

The objective of this project is for the consolidation of the HNCA Medi-Cal data into one integrated system. Medi-Cal will load claims data to Operational Data Warehouse ODW to provide daily, weekly updates of all relevant data from the Medi-Cal and surround systems. As an ETL Informatica Developer, was responsible for designing the mappings, sessions and workflows. The main objective of the project was to build an enterprise Medical Claims data mart.

Responsibilities:

• Worked with the Technical/Business analysts for requirements gathering, Business needs analysis, testing and project coordination.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier Transformation and Update Strategy Transformation.
• Worked extensively with various passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator Transformation and Lookup Transformation.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data loads.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Responsible for performance tuning at the Mapping level, Session level, Source level and the Target level.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Worked with re-usable objects like Re-Usable transformations and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation.
• Used Filter transformation at the early stages of the mapping for the performance tuning of the mapping.
• Extensively used SQL Override, Sorter and Filter functions in Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Used Update strategy transformation using functions like DD INSERT, DD UPDATE, DD DELETE, and DD REJECT to insert, update, delete and reject items based on the requirement.

• Responsible for migrating the workflows from development to production environment.
• Handled Unit testing for the mappings.

Environment: Informatica Power Center 7.x/6.x Repository Manager, Designer, Workflow Manager, Workflow Monitor , SQL Server 2000, Shell Scripting, UNIX, Windows XP, Autosys

CONFIDENTAIL

Informatica Developer

This is basically a Data warehousing Project. CONFIDENTAIL is a front end billing application that projects summary, usage data of each subscribers belonging to corporate accounts. This project involves in developing data layer for front-end application. Several Notifications were generated to send status of the cycle to maintenance teams.

Responsibilities:

• Developed new mappings based on the business requirement document using Informatica Designer.
• Attended weekly Data Warehouse Team meetings on a periodic basis to update weekly status on pending enhancements.
• Directly responsible for the Extraction, Transformation and Loading of data from Source tables and files to Data Warehouse.
• Used different Data Warehouse techniques like Star-Schema, Snowflake Schema.
• Used different transformations like Joiner transformation, Update Strategy, Lookup transformation, Rank transformations, Expressions, Aggregator, and Sequence Generator.
• Extensively worked on performance tuning at the mapping level and session level in Informatica.
• Worked on Informatica PowerCenter Client tools like Designer, Workflow Manager, and Workflow Monitor.
• Worked with the Scheduling team for scheduling the Informatica Workflows.
• Worked with the Business Intelligence team for report generation.
• Environment: Informatica Power Center 7.x/6.x Repository Manager, Designer, Workflow Manager , Oracle, SQL Server, UNIX.

CONFIDENTAIL

Informatica Developer

The FDR Maintenance and Enhancement project falls under Application Value Management AVM category. Major and minor changes in one of FDR sub systems Client Specific were undertaken by client specific team during the duration of this project .The Client specific team worked on Standard Requests based on client's requirements. The team interacted with clients of FDR and worked on their requirements. This project is to support FDR in maintaining the existing third party credit card processing application - FDFIS. This includes new requirement from the client's side. The project involves working with the FDR clients in creating Functional Specifications and designing the product to suit emerging market trends. FDR wants to maintain the existing financial application to meet its client specific requirements. FDR wants to perform development, maintenance and migration activities to the existing FDFIS application.

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica ETL mappings to load data into various target tables and defining ETL standards.
• Loaded data from various sources like DB2, SQL Server, Flat files into Oracle data warehouse.
• Created Reusable Transformations, mapplets, Shortcuts for Sources and Targets to use across various Mappings.
• Created shell scripts using Informatica PMCMD command and scheduled using UNIX utility Maestro.
• Configured the sessions using workflow manager to have multiple partitions on Source data to improve the performance.
• Created and tested the data accuracy by creating complex Oracle SQL's using analytical functions.
• Implemented screen door processing for validating and cleansing Flat file sources.
• Preparing and using test data/cases to verify accuracy and completeness of Informatica ETL process.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV Environment.

Environment: Informatica Power Center 7.x/6.x Repository Manager, Designer, Workflow Manager, Workflow Monitor , Oracle, UNIX, Windows XP.

CONFIDENTAIL

Software Developer

CONFIDENTAIL is a specialty retailer in the apparel business sector spread all over America. It operates stores selling casual apparel for women, men and children in the form of six retail brands. Head quartered in Ohio, the division has opened 3800 stores and expanded throughout the United States. The MADS legacy system has supported the LTD business for decades making it the world's most admired company. However, the growing business trend demands a complete re-engineering and enhancement of the existing system. I have handled certain changes in processes with respect to the client-customer rapport needs involving the LPC, LGC, and LSC gift certificates. This transition in the MADS is vital in the client's modus operandi of a new system.

Responsibilities:

• Involved in Analysis, creating Low Level Design and High Level Design Documents.
• Analyzing the Cobol Programs and coding the COBOL programs as per requirements.
• Prepare High level Estimate and details project plan.
• Prepare Unit test cases and Unit plan for Testing.
• Implemented all the components into production and given support.
• Standards followed as per the client's documentation.

Environment: COBOL, DB2, JCL, VSAM, Endevor, File-Aid

CONFIDENTAIL

Software Developer

CONFIDENTAIL is a leading direct merchant of traditionally styled, casual clothing for men, women and children, as well as soft luggage and products for the home. They operate 20 outlet stores in the US and UK. The company's products are offered through regular mailings of its primary and specialty catalogs and via the Internet. The expanding needs of the client were met by a highly reliable e-shopping system that was subject to certain changes effected by growing business operations. I carried out a few additions and fixed some defects in the Shopping Cart Billing System.

Responsibilities:

• Involved in Analysis, creating Low Level Design and High Level Design Documents.
• Analyzing the Cobol Programs and coding the COBOL programs as per requirements.
• Prepare High level Estimate and details project plan.
• Prepare Unit test cases and Unit plan for Testing.
• Implemented all the components into production and given support.
• Standards followed as per the client's documentation.

Environment: COBOL, DB2, JCL, VSAM, Endevor, File-Aid