SUMMARY

• More than 8+ years of strong experience in System Analysis, Design and Development, Testing, Business Intelligence and Business Analysis in the fields of databases, data warehouse and client server technologies using ETL (Extraction, Transformation, and Loading) utilizing Informatica 8.x/7.x/6.x (Power Mart and Power Center8.1)
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading(ETL).
• Data Processing Experience in Designing and implementing Data Mart applications,mainly transformation Process using ETL tool Informatica Power Center.
• Broad experience in analysis, design, development and maintenance of Oracle9i,10g database objects, SQL, Relational database.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Extensive experience in PL/SQL programming including effective use of Oracle packages, stored procedures, cursors, database triggers and tools like SQL*Plus,PL/SQL Developer and TOAD.
• Worked with various clients in the Banking, Telecommunications and Sales.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Practical knowledge of Data warehouse concepts and principles (Kimball/Inman) - StarSchema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Strong experience in activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Informatica Administration experience including grid management, creation and upgradation of repository contents, creation of folders and users and their permissions
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Demonstrative experience in designing and developing sessions, transformations, workflows and mappings using Informatica PowerCente
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Created Reports using Crystal Reports & Business Objects.
• Experienced in Black Box, and White Box Testing of Database and Web applications
• Experienced doing traceability matrixes, test reports, test scripting, automation.
• Experienced in running SQL queries using Toad, SQL Navigator and SQL Server.
• Expertise in ETL process using Informatica (Power Mart / Power Center)
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.
• Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server
• Created Reports using Crystal Reports & Business Objects.
• Experienced in Black Box, and White Box Testing of Database and Web applications
• Working knowledge of Test Director/Quality Center, WinRunner/QTP
• Experienced doing traceability matrixes, test reports, test scripting, automation.
• Experienced in running SQL queries using Toad, SQL Navigator and SQL Server

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows XP,NT/95/2000, Sun Solaris 2.6/2.7, Linux 6.X/7.X/8.X

LANGUAGES KNOWN: C, C++ PL/SQL 8.x/2.x, SQL*Plus, SAS

RDBMS: Oracle 7.X/8.X/9.X/10g, Teradata,MS SQL Server 6.5/7.0/2000, MS Access 7.0/’97/2000, SQL Server 11.x/12.0

SCRIPTING LANGUAGES: VB Script, Java Script

TECHNOLOGIES: Active X, OLEDB, and ODBC

WEB SERVERS: Java WebServer2.0, Netscape Enterprise Server, Web Logic 6.0.

DATAMODELLING TOOLS: Erwin 3.5.1/4.x, Designer 2000, Ralph-Kimball methodology, Bill-Inman, Starschema,snow flake schema, Extended starschema, Physical and logical modeling

DATAWAREHOUSING: Informatica PowerCenter / Powermart 8.1/7.1/6.1/5.1 ETL, Ab Initio, (GDE 1.15, Co>Op 2.14), Data Mining, DataMart, SQL*Loader, TOAD 7.5.2,DataFlux.

BI Tools: Business Objects XIR3, Cognos 8.0 Series

ETL Tools: Informatica8.6.1/8.1.1/7.1.2/6.2/6.1 (Powermart/Powercenter) 6.x, Informatica PowerExchange7.x/8.x, Informatica Power Connect

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. ETL/Informatica Consultant

Responsibilities:

• Understanding existing system and acquiring business requirements
• Involved in the design meeting session of the data model and creating rules formigration with end users.
• Designing of High Level and Low Level Documents
• Designing of mapping documents and ETL Design Documents
• Import data from various sources like flat files, SQL database server and loadinginto Oracle Database without Duplicates.
• Prepared PL/SQL programs to validate the data
• Developing well tuned Mappings usingInformatica Designer Tool.
• Developing of Session Tasks and Workflows
• Made performance improvements to the database by building Partitioned tablesIndex Organized Tables and Bitmap Indexes.
• Prepared test plans and tested all ETL processes.
• Documented the Jobs, source to target mappings for each column and businessrequirement behind the logic of the Job.
• Preparation of User Manuals
• Release sheet preparation and Migration to production.
• Delivering the project Objects in timely manner.

Environment:Informatica Power Center 7.1.1, Windows 2000, Oracle 9i, UNIX Sun Solaris 8 Servers,Congnos Report Studio.

Confidential, NY

Sr. ETL Developer

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of FRD documents to the development teams.
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Modified the logical and physical data models that capture new requirements to reflect the data model using Erwin.
• Implemented HIPPA standards as part of Informatica B2B Data transformation studio 8.6
• Configured the B2B Data Transformation studio 8.6 (Integration hubs) for enabling the data transformation between users and the Informatica power center.
• Configured the HTTP server authentication type in the Integration service for enabling the B2B Data Transformation (B2BDT).
• Involved in designing the process flow for extracting the data across various source systems.
• Extracted source data using power exchange from legacy systems.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user.
• Designed and developed various complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Coded BTEQ scripts to load data from Teradata staging to Enterprise Data warehouse.
• Created Teradata External Loader connections such as MLoad, Upsert, MLoad, Update, and Fast Load in the Informatica Workflow Manager while loading data into the target tables in Teradata Database.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Designed and developed UNIX shell scripts as part of the pre-session and post-session commands to automate the process of loading, pulling, renaming and pushing data from and to different servers.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Used PL/SQL procedures and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.
• Responsible for writing unit test cases and performing the unit testing for data validity based on business rules.
• Member of On call team for providing support for daily and weekly batch loads.
• Prepared run book for the daily batch loads giving the job dependencies and how to restart a job when it fails for ease of handling job failures during loads and socialized the same with other teams.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Involved in various meetings, seminars, presentations and group discussions.

Environment: Informatica Power Center 8.1/8.6, B2B Data Transformation Studio 8.6, Unix, DB2 Power exchange 8.1, Erwin, TOAD, PL/SQL, Flat files, Oracle 11i/10g, SQL Server.

Confidential, Danbury, CT

Sr. ETL Developer/Tester

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Warehouse Designer, Mapping Designer and Workflow Manager.
• Extracted data from DB2 and oracle based Market soft sources and transformed those and loaded in to SQL Server targets.
• Involved in creating delta mappings and loading various dimensions as required to load the fact including the time dimension..
• Implemented Type I and Type II slowly changing dimensions.
• Designed and developed Informatica 7.x ETL mappings/mapplets/workflows to load migrated data and execute converted transformation processes from legacy system and application/system databases to the new BO Universe based reporting Datamart and Enterprise Data Warehouse.
• Loaded fact tables by the dimension ids and qualified interactions and successful lead counts.
• Debugged the mappings extensively hard coding the test data ids to test the logics going by instance by instance.
• Expertise in writing Test Strategy, Test Scenario, Test Plan, Test Cases, Bug Reports and Developing Test Scripts. Attend small card review and give project overview.
• Experience in analysis, Programming and testing.
• Request Test Data for Testing Environments.
• Support developer during testing phase.
• Participated and reported status in all test related project team meetings.
• Documented the automation strategy and the test plan.
• Performed integration of automation scripts with the Test Management Repository, Test Director.

Environment: Informatica Power Center 7.2/6.0, SQL Server 2005, Oracle9i, TOAD, UNIX Shell script.

Confidential, Allentown, PA

ETL Designer/Developer

Responsibilities:

• Interacted with the end users in finalizing the requirements and assisted in preparing the Functional Requirements Documents.
• Responsible for the Dimensional Data Modeling and populating the Business rules into the repository for metadata management.
• Developed Jobs using Power Center 7.1.4 to Extract and load relational data into Oracle9i, DB2, and SQL Server 2000 Databases.
• Implementation of Surrogate key by using Key Management functionality for newly inserted rows in Data Warehouse.
• Defined reference lookups and aggregations, external procedures and update transformations according to the business rules.
• Designed and developed mapping using various transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations. Star Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts.
• Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Performed data manipulation using Basic function and Informatica Transforms
• Designed complex job control processes to manage a large job network.
• Wrote PL/SQL stored procedures using Toad.
• Developed several Test Plans, Unix Scripts for Unit/Team Testing.
• Handling On-Call support calls from the data center and identifying the issue and performing root- cause analysis and providing them with the solution.
• Implementing performance-tuning techniques along various stages of the ETL process.
• Designed complex job control processes to manage a large job network.
• Used AutoSys for Job scheduling.

Environment: Power Center 7.1.4, SQL Server 2000, DB2 7.0/8.0, Oracle 9i,Flat files, Autosys, Toad 8.0, Shell scripts, Windows NT 4.0/2000, HP-UX 11.0,Unix.

Confidential

ETL Developer

Responsibilities:

• Analyzed the systems, architecture, met with end users and business units in order to define the requirements.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 6.x.
• Extensively used Informatica tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer.
• Implemented various Informatica transformations like Expression, filter, Aggregator, Router, Ranker, update strategy, joiner, Lookup, Sequence generator, stored procedure and Source Qualifier. To load the data from Staging area to DW.
• Developed data Mappings between source systems and warehouse components using Mapping Designer.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data target database.
• Involved in the Performance Tuning.
• Tuned ETL procedures and STAR schemas to optimize load and query Performance.
• Created and ran sessions and workflows using Workflow Manager.
• Monitored the sessions and workflows using Workflow Monitor.
• Trouble shooting of connectivity problems. Looked up and read session, event and error logs for troubleshooting.

Environment: Informatica Power Center 6.x, SQL Server 2000, UNIX Shell Scripts, TOAD, Windows NT.

Confidential, TX

Informatica Developer/Support

Responsibilities:

• Worked on ETL Mapping design using Informatica.
• The data is transformed, validated, and loaded into the Data-warehouse using Power Center.
• Used heterogeneous data sources, like flat files and Oracle.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Worked on connected as well as unconnected Lookup transformation to look up values in a table.
• Used Parameter files for multiple DB connections to the sources.
• Creating reusable transformations and mappings using Informatica.
• Checked and tuned the performance of Informatica Mappings.
• Worked on unit test conditions and unit test documentation for all the informatica mappings.
• Worked with flat file sources and relational sources

Environment: Power Center 6.2, Oracle 9i, Windows NT, SQL Server 2000, UNIX, TOAD.