SUMMARY

• SDLC: 9+ years of IT experience in Data Analysis, Design, coding and testing of Data Warehousing implementations across Retail, Financial, Pharmaceutical, Health care and Insurance Industries.
• Informatica: 5 years of Data Warehousing experience using Informatica Power Center 9.1.0/8.6.1/8.1.1/8.0/7.1.3/7.1.2/7.1.1/6.2/5.1.1 , Power Mart 6.1/5.1.1/5. x/4.7, Warehouse Designer, ETL, Data mart Siebel 7.0/2000/5.5 , Siebel Warehouse 6.3, Siebel EIM, OLAP, OLTP, Autosys, Control M, Sybase. Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files (fixed width, delimited), XML, RDBMS tables, legacy system files.
• Data Analysis: 4 years of strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Methodologies: Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW and Metadata repository.
• Databases: 5 years of experience using Oracle 11g/10g/9i/8i, DB 2 8.0/7.0/6.0 , MS SQL Server 2005/2000/7.0 , Teradata V2R6/V2R5, Sybase 12.x/11.x, SAP R/3,MS Access 7.0/2000, PL/SQL, SQL*Plus, SQL*Loader and SQL Developer.
• Experienced with coordinating cross-functional teams.
• Excellent analytical, problem solving, and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1.0/8.6.1/8.1.1/8.0/7.1.3/7.1.2/7.1.1/6.2/5.1.1 , Power Mart 6.2/5x/4.7, Informatica Power Analyzer, Informatica Power Connect, Informatica Power Plug, Informatica Designer, Workflow Manager, Workflow Monitor, ETL, ETI, Data mart, OLAP, OLTP, Mapplet, Transformations, Control M, SQL*Plus, SQL*Loader.

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.1/4.0/3.5.2

Databases: Oracle 10g/9i/8i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005, Teradata V2R6/V2R5, SAP R/3, Sybase 12.x/11.x, MS Access.

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Synopsis, Java, J2EE, HTML, DHTML, C, C++, Unix Shell Scripting, Kernel Programming, PERL scripting

Environment: Sun Solaris, HP-UX, IBM AIX, MS DOS, Novell NetWare, Win NT, Red Hat Linux.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr ETL Informatica Developer

Responsibilities:

• Worked on ETL Design& functional specifications and converted them into technical specifications.
• Extensively used ETL and Informatica to load data from Oracle, Excel spreadsheet, flat files, XML and Mainframe/COBOL to the target Teradata database.
• Experience in Informatica providing Data warehouse solutions using PowerCenter and data modeling with ERWIN tool.
• Responsible for Power Center and Power Exchange installations, configuring Power Center domain, nodes and integration services.
• Designed ETL Process Design Documents.
• Designed Source to Target Mapping specification Documents.
• Extensively involved in Data Extraction from Mainframe source (VSAM), Oracle using Power Exchange when there was change in the source data sets.
• Created repository services and repository contents. Restored the repository contents from the backups using Admin console.
• Extensive experience working with repository manager. Was responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders etc.
• Used SQL overrides in source qualifiers with appropriate schema names for extracting only the required rows for optimal performance. Implemented complex expressions in expression transformations. Tested the queries thoroughly for integrity and identifying data errors.
• Extensively worked on Informatica power center tools - Designer, Workflow Manager, Workflow Monitor & Repository Manager.
• Extensively wor ked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Created reusable transformations and mapplets by using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively
• Extensively worked on the performance tuning of the Mappings as well as the tuning of the sessions.
• Developed a script which automated the loading process to the Oracle database
• Developed various mappings, Reusable transformations and validated the ETL logic coded into mappings.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Lead the Performance Tuning of Informatica Mappings, Sessions and workflow.Developed unit test cases and did unit testing for all the developed mappings.
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.
• Provided production support by monitoring the processes running daily.

Environment: Informatica Power Center 9.1/9.6.1, Oracle 10g/11g,PL/SQL Erwin 5.1, Business Objects xi, TOAD 9.6.1, Autosys, UNIX version 5.1, Windows XP Professional/2002, UNIX, Windows XP/2000.

Confidential

ETL - Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used Informatica Power Center 8.1.1 to extract data from various sources and load in to staging database.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Used Power Exchange interface to get the data from mainframe files.
• Performed source data analysis .Primary data sources were from Oracle & SQL server 2005.
• Involved in using Erwin for physical and logical data modeling.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 8.1.1
• Created Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Implemented Slowly Changing Dimension methodology for accessing the full history.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Migrated repository objects, services and scripts from development environment to production environment. Exte nsive experience in troubleshooting and solving migration issues and production issues.
• Involved in Unit testing and documentation.

Environment: Informatica 8.6.1, Oracle 10g, PL/SQL, TOAD 8.6.1, Flat File,Sybase, SQL Server 2005,Business Objects, Windows NT, UNIX Shell Scripting.

Confidential, Texas

ETL - Informatica Developer

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling. Backup & recovery.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Worked in Development, Testing, Pre-production and Production Servers.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer.
• Created complex reusable transformations and mapplets using Lookup, Aggregator, Normalizer, Update strategy, Expression, Joiner, Rank, Router, Filter, and Sequence Generator etc. in the Transformation Developer, and Mapplet Designer, respectively.
• Created reusable Sessions and Commands in the Workflow Manager.
• Created and implemented variables and parameters in the Mapping Designer.
• Created reusable Worklets in Worklet Designer and set up Workflows in the Workflow
• Used unconnected lookup for populating date-time entered field in the target tables.
• Developed mapplets, mappings and configured sessions.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and WorkFlow Manager.
• Worked closely with reporting team and generated reports using Business Objects 6.2.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality asurance testing.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, Web Services,XML,Java, Windows NT, UNIX Shell Scripting.

Confidential, California

Data warehouse Developer (ETL / Informatica)

Responsibilities:

• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Implementing Extraction process of flat files into target database
• Migrated Mappings from Development to Testing and Testing to Production.
• Used Parameter Files for multiple DB connections for the sources and defining variable values.
• Developing the documentation and plan for transformation and loading the Warehouse.
• Analyzing the data from various sources for data quality issues.
• Participated in all facets of the software development cycle including providing input on requirement specifications, high level design documents, and user’s guides.
• Worked with Web services.
• Writing Oracle Stored Procedures, SQL scripts and calling at pre and post session.
• Created Concurrent Tasks in the workflows using workflow manager monitor jobs in Workflow Monitor.
• Designing mapping templates to specify high level approach.
• Involved in Unit testing and documentation.

Environment: Informatica 8.1.1, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, Web Services, PVCS, Windows NT, UNIX Shell Scripting.

Confidential

ETL - Informatica Developer

Responsibilities:

• Engaged with Call Center, Customer & Marketing data mart with different types of active and passive transformation.
• Identified and created different source definitions to extract data from input sourcesand load into relational tables using Informatica Power Center.
• Extensively used ETL to load data from Oracle, flat files to Oracle.
• Develop Mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, Sequence Generator, Joiner, Aggregator transformations and expression.
• Implement Source and Target definitions in Informatica Designer.
• End-to-end ETL development of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informatica Mappings for data loads
• Extensively used ETL and I Informatica to load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle 9i database. implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & mapplet Designer and transformation Designer. Development of Informatica mappings and also in tuning of mappings for better performance.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Created and run workflows and Worklets using Workflow Manager to load the data into the Target Database.

Environment: Informatica 7.1/6.2,, OLAP, Teradata V2R5, Oracle 9i, MS SQL Server 7.0/2000, Sybase, Flat files, PL/SQL,SQL, SQL*Loader, Erwin 3.5, Windows 2000, HP-UX, UNIX Shell Scripting.

Confidential

Data warehouse Developer (ETL / Informatica)

Responsibilities:

• Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
• Extensively used ETL to load data from Oracle, flat files to Oracle.
• Extensively used aggregator, expression, lookup, and update strategy, transformation
• Understanding the ETL Specification Documents for Mappings requirements.
• Extract Data from multiple sources like Flat files, Oracle into staging database.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designdevelop and Mapplets to load data from external flat files and RDBMS.
• Created Mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Joiner, Union, Sequence Generator, and Update Strategy.
• All errors encountered were documented using an Issue Log. Interacted with team members to resolve the errors encountered.
• Performed Unit tests on all the Mappings developed and documented the test cases and test results.

Environment: Informatica 6.2, Oracle 8i, PL/SQL, Toad 9.4, ERWIN, Web Services, PVCS, Wndows NT, UNIX Shell Scripting