PROFESSIONAL SUMMARY:

• Around 7+years of Professional experience as Software developer in all phases of Software Development Life Cycle(SDLC) includinganalysis, design, development, testing and Implementation of Business Intelligence solutions using Informatica PowerCenter 9.x/8.x/7.x.
• Experience includes domain noledge of Banking, healthcare information technology, Insurance and Retail Industry.
• Provided production support and have handled different severity tickets.
• Extensive experience wif Data Extraction, Transformation, and Loading (ETL) from Multiple Sources. Worked on data integration from various source files such as flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
• Extensive working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL) methodologies.
• Extensively worked on development of complex mappings,mapplets, Transformations, Workflows, Workletsusing various transformations like Expression, Connected/Unconnected Lookup, Filter, Router, Joiner, Union, Aggregator, Update Strategy, SQLT, Transaction control etc. and have scheduled teh Workflows and sessions.
• Worked on Stored Procedure concept to truncate tables and delete rows from error logs.
• Expertise in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Task Developer, Workflow Manager and Workflow Monitor.
• Strong understanding of RDBMS and proficient in writing PL/SQL Procedures.
• Expertise in OLTP System Study, Analysis and database schemas like Star Schema and Snowflake Schema used in relational and dimensional modeling.
• Designed Fact and Dimension tables. Experience in implementing Change Data Capture (CDC) Techniques like slowly changing dimensions and created slowly growing target mappings, Type1/2 dimension mappings.
• Experience in using teh Informatica command line utilities like pmcmd to execute workflows in non - windows environments.
• Extensively worked on Performance Tuning techniques at various levels to increase teh performance and minimize teh time for work.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts according to teh Business Requirements, developing Test Scenarios to support quality deliverables and documented Requirement Traceability Matrix.
• Have done a test data set up and Conducted Unit, Integration, System, UAT and Functionality testing and investigated and fixed teh bugs.
• Experience in UNIX Shell Scripting.
• Haveexperience in Informatica Power Exchange.
• Worked wif Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experience in loading data into Data Warehouse/Data Marts.
• Experienced wif coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
• Proven ability to implement technology based solutions for business problems.
• Strong analytical, problem-solving, organizational, communication, learning and team skills.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.x/8.x/7.x, Power Exchange 8.6

Data Modeling: ERWIN, Star schema Modeling, Snow Flake modeling.

Languages: PL/SQL, SQL*Plus, C, C++, C# and SQL.

Databases: Oracle 10g/9i, MS SQL Server 2005/2000, DB2, MS Access Teradata.

SQL Tools: SQL Developer, TOAD, SQL*PLUS, SQL*Loader, CDC.

Office Tools: MSOffice, MS Project.

O/S: Windows NT/2000/XP, UNIX, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Informatica Developer

Responsibilities:

• Interacted wif Data Modelers and Business Analysts to understand and translate teh business requirements into technical user specifications, including data and process specifications.
• Involved during teh Source to Target Design documents, Technical Design documents.
• Extracted data from Flat files, SQL and Oracle to build teh Data warehouse. Applied business logic to load teh data into Global Data Warehouse.
• Involved during teh design of granularity of teh fact and dimension table.
• Maintained source and target mappings, transformation logic and processes to reflect teh changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in teh Informatica Designer.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in teh Target.Worked on different tasks in Workflow Manager like Sessions, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of teh workflow.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created detailed Unit Test Document wif all possible Test cases/Scripts.
• Designed and developed transformation rules (business rules) to generate consolidated data using Informatica ETL (Power center) tool.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects wifout creating multiple objects in teh repository and inherit changes made to teh source automatically.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Modified existing mappings for enhancements of new business requirements.
• Work as an active team member, under broad guidance wif independent planning & execution responsibilities.

Environment: Informatica PowerCenter 9.1, Oracle 10g, SQLServer 2005, Windows XP, Toad.

Confidential, San Antonio TX

InformaticaDeveloper

Responsibilities:

• Analyzed teh functional specs provided by teh data architect and created technical specifications documents for all teh mappings.
• Develop logical and physical data models dat capture current state/future state data elements and data flows using Erwin.
• Converted teh data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in teh Database, created Automated scripts, defined storage parameters for teh objects in teh Database.
• Identifying suitable dimensions and facts for thestar schema.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed and developed Informatica Mappings to load data from Source systems to Data Mart.Used Informatica Power Center/ Workflow manager to create sessions, batches to run wif teh logic embedded in teh mappings.
• Created Power Exchange Registrationfor CDC on oracle tables.
• Written documentation to describe programdevelopment logic, coding, testing, changes and corrections.
• Created detailed Unit Test Document wif all possible Test cases/Scripts.
• Involved in Unit, Integration, System, and Performance testing levels.
• Implemented performance tuning wif teh Transformations, Sessions and on teh Source Databases to load teh data efficiently in to teh target.
• Created reusable mappletsto import in teh common mappings to avoid complexity in teh mappings.
• Created sessions, batches to reduce teh time to load data from teh existing sources to database.
• Custom development on UNIX server using PL/SQL and Toad.
• Modified teh existing batch process, shell script, and PL/SQL Procedures for Effective logging of Error messages into teh Log table.

Environment: Informatica Power Center 8.6, Power Exchange 8.6,PL/SQL, Oracle 10g, SQL Server 2000,ERWIN, TOAD, Unix, Windows 2000.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Major involvement in creating and tuning teh mappings, to perform maximum efficiency and performance complete noledge of session properties in Work flow monitor
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner,Source Qualifier, Expression, Sequence Generator and Router Transformations.
• Created update strategy and stored procedure transformations to populate targets based on business requirements.
• Implemented Slowly Changing dimension type2 methodology for accessing teh full history of accounts and transaction information.
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Designed teh ETL processes using Informatica to load data from Flat Files, XML Files and Excel files to Oracle Staging area.
• Used Change Data Capture (CDC) to implement Incremental Data Extraction so dat only teh modified and new records will be extracted to teh destination rather than full extraction
• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Mapplet and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Loaded operational data from Oracle, Sql server, flat files, Excel Worksheets into various data marts.
• Created Tasks and Workflows using Task Manager and Workflow Designer
• Also developed numerous Stored Procedures, Triggers and common functions using PL/SQL.

Environment: Informatica Power Center 8.6, Work Flow Manager,Oracle 10g, SQL Server 2005, DB2, Erwin, TOAD, XML, UNIX Shell script.

Confidential, New Jersey

Informatica Developer

Responsibilities:

• As a team member involved in collecting all teh requirements for building teh ETL Mapping.
• Responsible for Extracting, Transforming & Loading data from Oracle, Flat files and placing them into relationaldatabase.
• Designed and developedmappings, mapplet and sessions from source to targetdatabase using Informatica Power Center.
• Worked wif various file formats like fixed length and delimited.
• Used Debugger extensively to validate teh mappings and gain troubleshooting information about data and error conditions.
• Developed various mappings using Mapping Designer and worked wif Source qualifier, aggregator, connected unconnected lookups, Filter, router, joiner, expression, store procedure, update strategy and sequence generator transformations.
• Used TOAD for running teh Queries to check teh data loaded to teh Target Tables.
• Develop test scripts, Execute test cycles and Facilitate User Acceptance Testing by preparing use cases.
• Created User support documents for troubleshooting data inconsistency and validation.

Environment: InformaticaPower Center 7.1, Oracle 9i, Toad, PL/SQL, Erwin, Windows XP, Autosys, UNIX.

Confidential

Senior Software Engineer

Responsibilities:

• Involved in designing and development of data warehouse environment, liaison to business users and/or technical teams, gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Worked wif a team of developers, senior developers, Data Architects and report developers, coordinating teh entire process flow, adhering to strict project deadlines in generating teh expected results accurately
• Worked on Informatica Power Center - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplet and Reusable Transformations.Using Informatica Designer designed Mappings, which populated teh Data into teh Target Star Schema.
• Optimized Query Performance, Session Performance and Reliability.
• Extensively used Router, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Developed teh logical and physical models using Erwin designer.
• Translation of Business processes into Informatica mappings for teh data warehouse and involved in teh Migration process from Development, Test and Production Environments.
• Used SQL tools like TOAD to run SQL queries and validate teh data.
• Used stored procedures, views and triggers in PL/SQL for managing consistency and referential integrity across data mart.
• Tuning teh Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled teh batches to be run using teh Workflow Manager & UNIX Scripts.

Environment: Informatica Power Center 7.1, UNIX shell scripting, Solaris, Oracle 9i, PL/SQL, Toad, Erwin, Crystal Reports.

Confidential

Software Engineer

Responsibilities:

• Performed major role in understanding teh business requirements and designing and loading teh data into data warehouse (ETL).
• Created new mappings and updated old mappings according to changes in Business logic.
• Used ETL (Informatica) to load data from sources like Oracle database and Flat Files.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded teh process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type me & II in different mappings as per teh requirements.
• Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.
• Used Debugger to troubleshoot teh mappings
• Developed mappings using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Created various Mapplet in designer using Informatica Power Center Mapplet Designer.
• Involved in Unit and System testing of developed mapping.
• Optimizing Query Performance, Session Performance.
• Defined Target Load Order Plan for loading data into Target Tables.
• Involved in creating desktop intelligence and web intelligence reports.

Environment: Informatica Power Center 7.1, Windows NT, PL/SQL, Excel, SQL Server 2000, DB2, Erwin.