OBJECTIVE

• Aiming to be associated with a progressive organization that gives me the scope and apply my knowledge and skills to involve as a part of team that dynamically works towards the growth of organization.

SUMMARY

• 10 years of experience inData Warehousingand a wide range of progressive experience in Development and implementation of the business technology solutions.
• A judicious professional with rich experience in Informatica Power Center 9, 8.6, 8.1 and 7.1, IDQ, Cognos 10.1, Oracle 10g, SQL Server 2005 and Unix.
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, design documentation, approach architecture, strategy documents, system implementation, maintenance and acceptance testing.
• Successfully worked for the projects like Data Marts which involves creation of dimensions, facts for advanced analytics and MIS reporting purposes and Data Migration for loading data from legacy system to new core system basing on design document.
• Good Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Good knowledge of Data Profiling guidelines and best practices using IDQ.
• Complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL and Real - Time consideration.
• A skilled problem solver and an efficient team lead with excellent communication, analytical, business and interpersonal skills with ability to set effective priorities to achieve immediate and long-term goals and to meet operational deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica 9x, 8x, 7x

Reporting: Cognos 10x

Databases: MSSQL Server 2005, Oracle 8i/9i/10g, Sybase, DB2

Languages: C, C++

Operating Systems: Windows 95/98/XP/NT, UNIX (Solaris, Linux)

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior Informatica Developer

Responsibilities:

• Analyzed the business and wrote Design Document.
• Implemented and followed a Scrum Agile development methodology within the cross functional team and acted as a liaison between the business user group and the technical team.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Facilitated Application Development sessions to identify business rules and requirements, and documented them in a format that can be reviewed and understood by both business people and technical people.
• Performed data analysis for the existing data warehouse and changed the internal schema for performance.
• Wrote technical papers, gathered technical requirements, and compiled them to help the design system.
• Developed Mappings by extensively using most of the Transformations such as the Source Qualifier, Expression, Aggregator, Joiner, Filter, Router, Sequence Generator, Look up, SQL and Update Strategy Transformation.
• Developed business rules using IDQ for cleansing/validating/standardization of data.
• Defined System Trust and Validation rules for the base object columns.
• Extensively used SQL for accessing and manipulating database systems
• Was jointly responsible for monitoring the progress of the development and QA team
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs
• Performed Acceptance Testing (UAT), unit testing and documenting
• Maintained a close and strong working relationship with teammates and management staff to achieve expected results for the project team.

Confidential, Moline, IL

Senior Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems like Flat files, Teradata and Oracle.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Created solution specs and ETL approach document, which are the base of this project.
• Developed Mappings, Mapplets and Transformations using Informatica Designer.
• Developed Mappings by extensively using most of the Transformations such as the Source Qualifier, Expression, Aggregator, Joiner, Filter, Router, Sequence Generator, Look up, SQL and Update Strategy Transformation.
• Developed Tasks in Task Developer and Schedule the Sessions in Workflow Manager as per the Business requirement.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance
• Performed unit testing and involved in fixing the bugs.

Confidential

Senior Developer

Responsibilities:

• Interaction with business users in discussing the approach and doing gap analysis for the varying functionality.
• Analyzed the functional specs provided by the client and created technical specs documents for all the mappings.
• Data Quality Analysis to determine cleansing requirements.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Used Framework Manager to build model, packaged and published package to the cognos Server.
• Developed Standard Reports, List Reports, Cross-tab Reports, Repeater forms, Drill through Reports and Master Detail Reports using Report Studio.
• All phases of testing is completed for this Project like Unit testing, QA testing, Regression testing and UAT.
• Used windows Scripting and Scheduled pmcmd to interact with Informatica Server from command mode.
• Used Scheduling tool Zena and arranged jobs in parallel run to complete the sheet on time.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Confidential

Senior Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems like Flat files, Teradata and Oracle.
• Created solution specs and ETL approach document, which are the base of this project.
• Developing Mappings, Mapplets and Transformations using Informatica Designer.
• Developing Mappings by extensively using most of the Transformations such as the Source Qualifier, Expression, Aggregator, Joiner, Filter, Router, Sequence Generator, Look up, SQL and Update Strategy Transformation.
• Developing Tasks in Task Developer and Schedule the Sessions in Workflow Manager as per the Business requirement.
• Worked with different Informatica tuning issues and fine-tuned the transformations to make them more efficient in terms of performance
• Performed unit testing and involved in fixing the bugs.

Confidential

Developer

Responsibilities:

• Prepared the data migration strategy document from the legacy system to the new core system and obtained user acceptance on the same.
• Extensive interaction with business users in discussing the migration approach for each and every module (incl. assets and liabilities) and doing gap analysis for the varying functionality in different systems.
• Handled 3 junior developers doing the base mapping for Finacle Core and Finacle CRM.
• Created recon data marts for end to end financial reconciliation while migrating from legacy to the new system.
• Created application specific upload formats (flat files) for migrating various products and data into the new core.
• Created solution specs and ETL approach document, which are the base of this project.
• Created data mapping, data discovery and business requirements documents for the entire migration of the project.
• Data discovery and analysis while reconciling the data from various banking, treasury and ERP systems like Equation, EXIMBILLS, Oracle Financials, Oracle CRM etc.
• Using Informatica 8.1 to Extract, Transform and Load data from Multiple Sources like Flat files, Oracle 9i, Sql Server 2005.
• Developing Mappings, Mapplets and Transformations using Informatica Designer.
• Developing Mappings by extensively using most of the Transformations such as the Source Qualifier, Expression, Aggregator, Joiner, Filter, Router, Sequence Generator, look up, Rank and Update Strategy Transformation.
• Developing Tasks in Task Developer and Schedule the Sessions in Workflow Manager as per the Business requirement.
• Involved in Creating the UAT Scripts/reports for Data Migration, Reconciliation and Transformations of Informatica.

Confidential

Responsibilities:

• Handled mapping of various attributes (dimensions and facts) in the model from various source systems.
• User interactions in discussing the mapping approaches and to arrive at the transformations required in the ware house.
• Supported key business areas like Finance, Business performance, CRM, operations etc to derive their MIS from the logical views built in the ware house.
• Prepared the documentation on the model and the specifications for all attributes captured in the ware house.
• Supported business enabled testing (UAT) and reconciliation of data in the ware house against the data in the source systems.
• Executed the transformations and loading of historical data into the warehouse for the last one year.
• Developed mappings by extensively using Informatica Transformations like Lookup, Filter, Expression, Aggregator, Joiner and Stored procedures etc.
• Created mapping Technical documents, testing documents and Unit Test cases to ensure successful execution of data loading processes.
• Used slowly changing dimension concept to load data.
• Creating Workflows and Sessions for the respective Mappings.

Confidential

Responsibilities:

• Involved in collecting Functional requirement from Business User.
• Identified attributes (Dimensions & Facts) in the Data Mart and Designed the Star Schema.
• Developed Mappings and tuned them for better performance.
• Handled the Loading part of the Data Mart from various Sources Systems like Flat files, Oracle and SQL Server 2000.
• Used Mapping Designer and Mapplets to generate different Mappings with different transformations like Source qualifier, Aggregator, Lookups, Update Strategy, Joiner, Expression, Filter, Router, Sorter and Sequence Generator.
• Creating Dimensional and Fact tables.
• Tested the Mart for its Data Accuracy and credibility.
• Supported the UAT Environment for the Data Mart.