SUMMARY

• Experience as a Software Engineer / Informatica Developer for over nine years in developing large - scale Data Warehouse and Client/Server Applications, including Data Profiling, Data Migration, Data Modeling, Business Process, Design and Development, Integration and Testing, Database Programming, SDLC, Project Management and Production Support.
• Experience in Health, Financial, and Insurance domains.
• Experience in complete Software development life cycle (SDLC) with a strong background in Design/Modeling, database development and implementation of various business intelligence and data warehouse / datamarts projects that cover gathering Business Requirements, Development, Implementations and Documentation.
• Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 9.x/8.x/7.x/6.x/5.x Suite.
• Implemented Informatica Naming standards and Best Practices for the full life cycle of data warehouse projects, right from design to development through go-live and support
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer, Workflow Manager and Monitor.
• Sound knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inman) - Star, Snowflake schema, SCD, Surrogate keys, and Normalization/De normalization
• Data modeling experience in designing and implementing Data Mart and Data Warehouse applications using Erwin.
• Experience in integration of various data sources like Oracle, DB2, COBOL copybooks, SQL Server, Flat Files, Excel, and XML files
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Experience in using Business Objects to create reports
• Extensively used various Performance Tuning techniques to improve the performance for data loads
• Experience interacting with Business users and Architecting high level requirements, high level design and detailed level design documents.
• Strong Quality Assurance and debugging skills in ETL Process
• Solid understanding of OLAP concepts and challenges with large sets of data
• Proficient in Toad, SQL navigator, and UNIX Shell Scripting

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Data Quality (IDQ) 9.x, Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x, (Source AnalyzerWarehouse Designer, Transformation Developer, Mapplet DesignerMapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Power Exchange 8.0, RepositoryMetadata, Data Mart, OWB 11gR2, OLAP, OLTP.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flack, Fact, Dimensions), EntitiesAttributes, Cardinality, ER DiagramsDatabases Oracle 11i/10g/9i/8i/7.3, MS SQL Server 7.0/2000/2005/2008 TERADATA, DB2, OLTP

Programming: SQL, T-SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, C, Java, HTML, Perl, PHP

Tools: TOAD, Business ObjectsSQL Developer, Excel, Word, AutosysControl-M, MS ACCESS

Reporting Tools: Oracle Business Intelligence, Cognos, Business Objects.

Environment: UNIX, Windows XP/Vista, Linux.

PROFESSIONAL EXPERIENCE

Confidential, AZ

Sr ETL Developer

Responsibilities:

• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center 9.1.
• Involved in massive data cleansing prior to data staging
• Experience with high volume datasets from various sources like Text Files, and Relational Tables and xml targets.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Implemented Type1 and Type2 methodologies loading, to keep historical data in data warehouse.
• Implemented incremental logic to load the data.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Designed and Developed the Crystal Reports using the Views and Stored Procedures.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.

Environment: Informatica power center 9.1/9.6, SQL Server 2008, DB2, Unix, PL/SQL, Windows 7, Business Objects, SQL Developer 2005

Confidential, Portland, ME

Sr ETL/ Informatica Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Used IDQ to perform data profiling and create mappings.
• Involved in migration of the mapps from IDQ to power center
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager
• Implemented SCD1, SCD2 type maps to capture new changes and to maintain the historic data
• Worked on extract and load type of mappings
• Worked on SQL, Oracle, DB2, Teradata databases
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions
• Involved in creating stored procedures and using them in informatica
• Developed Unix shell scripts to schedule informatica sessions
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Used Debugger to troubleshoot the mappings.
• Created Web Intelligence Ad-hoc and canned reports
• Created alerts, filters and inserted Breaks in designing reports.
• Responsible for migration of the work from dev environment to testing environment
• Responsible for solving the testing issues
• Created documents that have the detail explanation of the mappings, test cases and the expected results and the actual results

Environment: Informatica power center 9.1, Informatica Data Quality, SQL Server 2008, DB2, UNIX, PL/SQL, Windows 7,Business Objects, Oracle 11i, SQL Developer 2005

Confidential, Schenectady, NY

ETL Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Followed the old ETL tool Sagent and developed technical design documents and used them to develop mappings in Informatica.
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Created new mappings and enhancements to the old mappings according to changes or additions to the Business logic.
• Worked on PROVIDER, CLAIMS, MEMBER, EDI, EITTR, WEBPROVIDERS subject areas
• Developed complex mappings using different transformations like source qualifier, connected look up, unconnected look up, expression, aggregator, joiner, filter, normalize, sequence generator and router transformations.
• Worked on several extracts and loads type of mappings.
• Worked on XML Source Files.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Developed Re-Usable Transformations and Mapplets.
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Developed SCD 1 and SCD 2 to capture new changes while maintaining the historic information.
• Reduced the amount of data moving through flows to have a tremendous impact on the mappings performance.
• Designed Work Flows that uses multiple sessions and command line objects ( which are used to run the unix scripts)
• Worked on SQL server, Oracle, Sybase data bases.
• Used Unix scripts for scheduling and executing informatica work flows
• Responsible for solving testing issues
• Worked extensively on Unit Testing and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.
• Prepared detail documentation for the developed code for QA to be used as guide for future migration work.

Environment: Informatica 9.1/8.6.3, SQL Server 2008/2005, Oracle 11i, PL/SQL, UNIX, VIRTUAL WINDOWS XP, WINDOWS 7, IBM Lotus, SQL Developer 2005, SUN SOLARIS

Confidential, Albany, NY

ETL/Informatica Developer

Responsibilities:

• Collected requirements from Business Users, analyzed and prepared the technical specifications
• Used ETL tools Informatica 8.6.3/9.1 to extract data from source systems, cleanse Transform, and Load data into databases.
• Developed mappings using Power Center -Designer for data transformation as per the technical requirements
• Designed mappings for different subject area CLAIMS, DENIED CLAIMS, PROCEUDRE, PROVIDER, REFERENCE, MEMBER,WMS
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement.
• Implemented slowly changing dimension (SCD) for accessing the full history of Customer and transactions of customer. Implement Type I, II, and III changes in slowly changing dimension tables.
• Worked extensively with Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Created mapping using TERADATA, COBOL, DB2 sources
• Used Reusable Transformations and Reusable Mapplets for different validations
• Built PLSQL procedures, functions as a part of custom transformations
• Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.
• Setting up batches and sessions to schedule the loads at required frequency using Power Center server manager
• Involved in Version control of the jobs to keep track of the changes in the Development Environment.
• Designed views and materialized views to create accumulated data based on the detail facts the data
• Extensively worked on UNIT TESTING and created different unit test case documents for different subject areas.
• Designed work flows, that are used to run a set of maps together one after the other, the results such as the execution time, start time, end time and status are stored in a run time repository which can be accessed by other users
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager.
• Used debugger to test the mapping and fixed the bugs
• Developed UNIX shell scripts to schedule the jobs for running
• Tuned and optimized mappings to reduce ETL run times thereby ensuring the mappings ran within the designated load window.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Co-ordinate with QA and BI reporting teams for any data related issues.

Environment: Informatica 9.1/8.6.3, SQL Server 2008/2005, Oracle 11i, OBIEE, PL/SQL, TERADATA, UNIX, VIRTUAL WINDOWS XP, WINDOWS 7, SQL Developer 2005,SUN SOLARIS

Confidential, Wall-Street, NY

ETL/ Informatica Developer

Responsibilities:

• Worked closely with Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin 4.5 to design the business process, dimensions and measured facts.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica powercenter 8.6.1.
• Migrating from informatica 8.1.1 mappings into informatica 8.6.1 which consists of grid technology
• Understanding the domain and nodes as well as by using the informatica integration service to run the workflows in 8.6.1.
• Involved in massive data cleansing prior to data staging.
• Created mapping using XML, COBOL sources.
• Worked on power exchange to access the data from different sources and to avoid manual coding
• Innovative design for Change data capture of Suppliers and millions of Account every business day
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and xml targets.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Implemented Type1 and Type2 methodologies in ODS tables loading, to keep historical data in data warehouse.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Tuning the complex mappings based on source target and mapping, session level.
• Involved in performance and tuning the ETL processes.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Developed UNIX Shell Scripts for scheduling the sessions in Informatica.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate the data in warehouse.

Environment: Informatica Power Center 8.6.1/8.1.1 , OBIEE 10.1.3.4, Oracle11i, Informatica Power Connect / Power Exchange, MS Access, TOAD, XML,PL/SQL, SQL server 2008, Windows, UNIX

Confidential, Omaha, NE

ETL/Informatica Developer

Responsibilities:

• Developed several Informatica load maps using PowerCenter/PowerMart for extraction, loading and transformation (ETL) of data into Oracle database.
• Developed several Informatica error maps to perform Error handling by capturing errors and error messages and inserting them into the Error tables.
• Used Star schema and Snowflake schema in relational, dimensional and multidimensional modeling
• Extracted data from flat files and oracle database, applied business logic using several transformations and loaded them in the central oracle database.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batches/Worklets and Workflows.
• Used informaticato load into Teradata Database
• Created parameter files for load start time, load end time and status code.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Used debugger to test the data flow and fix the bugs before running the sessions
• Tuned the mappings at session level by setting the buffer size, cache size, increasing commit intervals etc.
• Used TOAD to import data from different schemas and to export the query results into XLS sheets, text files and several other formats.
• Created complex mappings in using Aggregate, Expression, Router, Sequence Generator, Update Strategy, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed UNIX scripts to automate load process and email the status to specific distribution lists.
• Used SSIS to automate the SQL server databses
• Migrated the sessions, workflows into production.
• Generated reports based on user requirements.

Environment: Informatica 7.1.3, Oracle 10.2, MS SQL Server 2005, PL/SQL, TOAD, DB2, Microsoft Excel, OBIEE, Windows NT, Rational Rose.

Confidential

ETL/Informatica Developer

Responsibilities:

• Extensively involved to implement customer data mart and also data ware house.
• Analyzed the source data coming from Oracle, SQL server, and flat files.
• Extracted data from different source systems like Oracle, SQL server, flat file.
• Worked with Star Schema and Snow flake schema for the data warehouse.
• Extensively used Informatica Power center for extracting, transforming and loading into different databases.
• Designed, developed and tested the different Mappings according to Requirements.
• Analyzed the load dependencies and scheduled the workflows accordingly to avoid the loading conflict issues.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts as part of the ETL process for scheduling.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Created database objects like Tables, Indexes
• Performed unit testing, knowledge transfer and mentored other team members.

Environment: Informatica PowerCenter 5.1.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL* Loader, UNIX Shell Script.