SUMMARY

• Over 10+ years of IT experience in all phases of software development life cycle, with forte at successful project implementations - analyzing systems, understanding & defining requirements, development, technical designs & reviews and project planning.
• Extensively strong work experience with large scale Data Warehouse implementations using Informatica 9.x/8.x/7.x PowerCenter, Oracle, DB2 and SQL Server on UNIX and Windows platforms.
• Proficient knowledge and hands-on experience in building Data Warehouses, Data Marts, Data Integration and ETL processes.
• Extensive experience in Extraction, Transformation and Loading (ETL) data from various data sources into Data Warehouse and Data Marts using Informatica PowerCenter tools (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Expertise in implementing complex business rules by creating robust Mappings, Mapplets, Sessions, Worklets and Workflows using Informatica PowerCenter.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, Flat Files and XML files into Data Warehouse and also experienced in Data Cleansing and Data Analysis.
• Experience in Dimensional Data Modeling, Slowly Changing Dimensions Type I, II & III, ODS, Star/Snowflake Schema, Fact & Dimension tables, OLTP & OLAP Systems.
• Extensively strong work experience on SQL and PL/SQL. Proficiency in developing SQL with various relational databases like Oracle, SQL Server & DB2.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Triggers, Views and Indexes in distributed environment.
• Excellent expertise with different types of data load strategies and scenarios like Historical Dimensions, Surrogate keys, Summary facts, Incremental Logic etc.
• Experience in performance tuning of Informatica mappings and sessions to improve performance of the large volume projects.
• Proficient knowledge and hands-on experience as a Designer & Developer in HP Exstream Dialogue Designer, CSF (Document automation tools) and Mainframe technology.
• Experience in preparing documentation such as High level design, System requirement document and Technical Specification document etc.
• Expert in business process engineering and SDLC, AGILE methodology including analysis, design, development, testing and implementation of software applications.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Business experience with Asset Management, Investments, Portfolio Management, Risk, Insurance & Banking Systems.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.
• Experience in using IBM Clear Quest to track defects and document test cases.
• Experience in project management, estimations, and resource management activities.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.

TECHNICAL SKILLS

Operating System: Windows 2000/2003/2007 , Windows - NT, Redhat Linux

Languages: SQL, PL/SQL, UNIX Shell Script, Cobol, JCL

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x

Documentation Tools: HP Exstream Dialogue Designer, LIVE Editor, CSF

RDBMS: Oracle 11g/10g/9i, IBM DB2, SQL Server 2008/2005

Test Mgmt Tool: HP Quality Center 10.0

Database Tool: TOAD, SQL Plus

Other Tools: WinSCP, FTP, Clear Case, Clear Quest, TortoiseSVN, Putty

Scheduling Tool: Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential, New York City

Sr.ETL/Informatica Developer

Responsibilities:

• Coordinate with Business Users to understand business needs and implement the same into a functional Data Warehouse Design.
• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files into staging area and populated onto Data warehouse.
• Maintain User Maintained tables for processing User adjustments (Cash flows and market values) for both pre and post allocations.
• As a developer Designed, Developed and tested the Informatica Mappings which are designed as per best practices for the development team to make the development phase more efficient and also serves as a medium to introduce the development standards that developer need to follow.
• Used Informatica designer to create mappings using transformations like Lookup, Router, Filter, Sequence Generator, Joiner, Aggregator, Source Qualifier, Expression, Update Strategy, Stored Procedure and Union transformations to transform the data as per business logic.
• Created Mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, worklet, Assignment, Link Task Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used SCD Type 1 and Type 2 mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Used partitioning in Informatica to improve performance.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Used Session parameters, Mapping variable/parameters and created Parameter files for flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Created Document Test Plans, Test Procedures, Expected Results, Assumptions and Validations.
• Prepared document to move the mappings from development to testing and then to production repositories.
• Handling Adhoc issues, requests for data and implementing quick fix changes.

Environment: Informatica PowerCenter, SQL, PL/SQL, Oracle 11g, Linux 2.6.32, HP Quality Center, ControlM, WinSCP, Toad, Putty, Clear Quest, TortoiseSVN.

Confidential, New York City

Sr.ETL/Informatica Developer

Responsibilities:

• Function as a co-ordinator and working with Business team & offshore team.
• Analyzing the source systems, data nature & business rules.
• Review functional and technical design documents.
• Co-ordinate with different infrastructure teams - Data Center, Windows Administration, Web Application Support and Database/Informatica Admins for implementations.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• As developer Designed, Developed and tested the Informatica Mappings which are designed as per best practices for the development team to make the development phase more efficient and also serves as a medium to introduce the development standards that developer need to follow.
• Used Informatica designer to create mappings using transformations like lookup, router, filter, sequence generator, joiner, aggregator, source qualifier and expression transformations to transform the data as per business logic.
• Designed and Created complex Informatica mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Used SCD Type 1 and Type 2 mappings to update slowly Changing Dimension Tables.
• Develop and maintain database objects using PL/SQL - Control Structures, Composite data types, Explicit Cursors, Exceptions, Procedures, Functions, Packages and etc.
• Extensively Involved with System Testing and User Testing.
• Used Session parameters, Mapping variable/parameters and created Parameter files for flexible runs of workflows based on changing variable values.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Created Document Test Plans, Test Procedures, Expected Results, Assumptions and Validations.
• Prepared document to move the mappings from development to testing and then to production repositories.
• Proactively took responsibilities for internal organizational processes like Quality Management & Employee Performance management.

Environment: Informatica PowerCenter, SQL, PL/SQL, Oracle 11g, Linux 2.6.32, HP Quality Center, ControlM, WinSCP, Toad, Putty, Clear Quest, TortoiseSVN.

Confidential

Sr.ETL/Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Developed data conversion/quality/cleansing rules and executed data cleansing activities for the unstructured flat file data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Experience in integration of heterogeneous data sources like Oracle and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, Joiner and Rank transformations.
• Implemented complex business rules in Informatica Power Center by creating re-usable transformations and robust Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed Unit Testing and fixed the errors to meet the requirements.
• Copied/Exported/Imported the mappings/sessions/worklets/workflows from development to Test Repository and promoted to Production.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Created Document Test Plans, Test Procedures, Expected Results, Assumptions and Validations.
• Prepared document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter, SQL, PL/SQL, Oracle 11g, Linux 2.6.32, HP Quality Center, ControlM, WinSCP, Toad, Putty, Clear Quest, TortoiseSVN.

Confidential

Sr.ETL/Informatica Developer

Responsibilities:

• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional data from heterogeneous sources.
• Worked on loading of data from several flat files to relational tables.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Created Document Test Plans, Test Procedures, Expected Results, Assumptions and Validations.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Handling Adhoc issues, requests for data and implementing quick fix changes.

Environment: Informatica PowerCenter, SQL, PL/SQL, Oracle, Linux 2.6.32, HP Quality Center, ControlM, WinSCP, Toad, Putty, Clear Quest, TortoiseSVN.

Confidential

ETL/Informatica Developer

Responsibilities:

• Analyzed the requirements and framed the business logic for the ETL process.
• Extracted data from Oracle as one of the source databases.
• Involved in the ETL design and its documentation.
• Followed Star Schema to design dimension and fact tables.
• Experienced in handling slowly changing dimensions.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Developed reusable Mapplets and Transformations.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Design, develop and Informatica mappings and workflows, Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Scheduled the tasks using scheduler.
• Created high level design documents, technical specifications, coding, unit testing and resolved the defects using Quality Center.
• Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.

Environment: Informatica PowerCenter, PL/SQL, Oracle, Linux, ControlM, WinSCP, FTP, Clear Quest, TortoiseSVN.

Confidential

ETL/Informatica Developer

Responsibilities:

• Analyzed the existing system and the relationships between the fact tables and the dimension tables.
• Created database tables based on the source system analysis with proper columns and proper relationships between the tables to get max possible performance.
• As developer Designed, Developed and tested the Informatica Mappings which are designed as per best practices for the development team to make the development phase more efficient and also serves as a medium to introduce the development standards that developer need to follow.
• Prepared job chains for running the loads by maintaining the proper dependency between the jobs.
• Designed and prepared all ETL specifications based on the requirements.
• Used Informatica designer to create mappings using transformations like lookup, router, filter, sequence generator, joiner, aggregator, source qualifier, expression transformations to transform the data as per business logic.
• Addressed all the issues which users were facing.
• Incorporated all the data models in Model mart in order to maintain the versions of data models.
• Responsible for entire delivery of the project with quality and correct data.
• Used to maintain the versions of documents.
• Suggested solution approaches to implement the requirements.

Environment: Informatica PowerCenter, PL/SQL, Oracle, VB Scripting, DB2, Linux, Clear Case, Clear Quest, ControlM.

Confidential

Developer

Responsibilities:

• Analyzed & discussed the business requirements with the onsite business analyst’s team.
• Created low level Design Document (Technical Doc) based on the functional requirements.
• Take the production output of CSF templates replicate the objects & conditions in HPD.
• Did the estimation for the project and later for Change Request(s).
• Create the Variables, Map the Data, and Write the rules and functions as per CSF report.
• Developed sections, procedures and tables.
• Created NOP and E-Validation for the applications.
• Writing test plans and test scripts.
• Did the Coding in Dialogue Design Manager and Dialogue Designer.
• Reviewing the design of team members.
• Generate AFP & PDF outputs for all possible test cases & verify using CSF production output report.
• Performing unit, integration and SoapUI testing.
• Provided daily status updates of the Project development to the onsite team daily through mails and teleconference.

Environment: HP Exstream Dialogue Designer, Mainframe, JCL, CSF, DB2, Clear Quest, FTP, Putty, Win SCP, TortoiseSVN, SoapUI, Linux.

Confidential

Developer

Responsibilities:

• Analyzed and discussed the business requirements with the AGS team in Paris.
• Coding in Dialogue Design Manager and Dialogue Designer.
• Developed sections, paragraphs and tables.
• Reviewing the design of team members.
• Performing unit and integration testing.
• Created NOP and E-Validation for the applications.
• Provided daily status updates of the Project development to the onsite team daily through mails and teleconference.

Environment: HP Exstream Dialogue Designer, Clear Quest, FTP, Putty, Win SCP, Clear Case, SoapUI, Linux.

Confidential

Developer

Responsibilities:

• Analyzed and discussed the business requirements with the AXAGS team in Paris.
• Requirement analysis and review.
• Writing test plans and test scripts.
• Done the coding in CSF tool.
• Run and compile the CSF reports using JCL jobs and producing the outputs.
• Reviewing the design of team members.
• Created NOP for the applications.
• Performing unit and integration testing.
• Provided daily status updates of the Project development to the onsite team daily through mails and teleconference.

Environment: CSF, Mainframe, JCL, Clear Quest, FTP, Putty, DB2, Win SCP, Clear Case, Linux.