SUMMARY:

• Having around 6 years of IT experience Design, Development, Implementation and Maintenance of Data warehouse applications as Lead Developer.
• Experience in designing, development and support of data warehouse applications using Informatica Power Center 8.x/ 7.x/9.0
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, DB2 UDB, Excel, Oracle, MS SQL Server and Teradata.
• Worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience on Workflow Manager Tools Task Developer, Worklet & Workflow Designer.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling and Slowly Changing Dimensions.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schemas.
• Involved in all aspects of ETL- requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, designing various mappings, developing mappings, unit testing, integration testing, regression testing and UAT in development.
• Experience in Scheduling the Scripts using Autosys Scheduler.
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality.
• Exceptional problem solving and decision making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.

SKILLS:

Informatica Powercenter 8.6/9.0

Data Modeling:

Star Schema Modeling, Snow Flake Modeling, ER Modeling

Databases:

Oracle 11g/10g/9i, MS SQL Server 2005/2000, DB2, MS Access

Languages:

SQL, PL/SQL, Basics in J2EE, HTML,

Tools:

SQL* Loader, Microsoft VSS

Scheduling:

Informatica Scheduler

Operating Systems:

Windows7/ NT/2000/2003/XP,

EXPERIENCE:
Jun ’11 Till date Informatica Developer, Confidential, Baltimore, MD
Legg Mason is a diversified group ofglobal asset management firms ("affiliates") who are recognized for their proven investment expertise and long-term performance. The principal investment affiliates of Legg Mason are among the industry leaders in their respective areas of specialization, with unique investment approaches that have been developed over decades. Legg Mason affiliates operate with investment autonomy, with each affiliate pursuing its own unique investment philosophy and process and maintaining its own investment culture, in order to create sustainable value for its clients.

• Involved in customizing data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed complex Mappings using Informatica PowerCenter Designer.
• Designed reusable transformations and mapplets.
• Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and others.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance.
• Imported external data (flat files) into Oracle tables using SQL*Loader.
• Implemented changes in slowly changing dimension tables.
• Created and ran workflows using Workflow Manager to load the data into the Target Database.
• Optimized/Tuned mappings for better performance and efficiency.
• Developed mapping parameters and variables to support SQL override.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Queried target database using Teradata BTEQ to validate the data in the Data Warehouse.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Tested the data and data integrity among sources and targets using Unit Testing.
• Actively participated in Supply Chain Management.
• Associated with Production support team in various performances related issues.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module.
• Created number of standard reports and queries based on the existing classes/objects.

Environment: Windows XP, Oracle, MS SQL Server, Informatica (Power Center 8.x/9.0 with team based development).
Jan ’10 - May’11 Informatica Developer, Confidential, Florence, SC
Automatic Data Processing, Inc. (NASDAQ: ADP), with nearly $9 billion in revenues and about 550,000 clients, is one of the world\'s largest providers of business outsourcing solutions. Leveraging over 60 years of experience, ADP offers a wide range of HR, payroll, tax and benefits administration solutions from a single source. ADP\'s easy-to-use solutions for employers provide superior value to companies of all types and sizes.

• Understanding the business requirements by partnering with business and application developers to create conceptual, logical and physical data models.
• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, and Rank, Router etc. to extract the data from multiple source systems like Oracle, SQL Server and .csv files.
• Creation of Reusable transformations, Mapplets to reduce the development time and complexity of mappings and better maintenance.
• Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs.
• Developed Complex mappings by extensively using Informatica Transformations.
• Creating/Building and Running Sessions/workflows and worklets using the Workflow Manager/ Workflow Monitor.
• Worked on performance tuning by creating indexing, hints, used explain plans and analyzing the database.
• Worked for a combination of Relational and dimensional data modeling.
• Worked with offshore team by helping them to understand the requirements and co-ordinate with them to meet the deadlines.
• Environment: Informatica Power Center 8.x, Oracle, SQL Server, DB2

Oct’08 Dec’09 Informatica Developer, Confidential,Phoenix AZ
American Express provides innovative payment, travel and expense management solutions for individuals and businesses of all sizes. Most of all, we help our customers realize their dreams and aspirations through industry-leading benefits, access to unique experiences, business-building insights, and global customer care. We enable our customers to do more and achieve more.

• Responsible for Requirement Gathering Analysis and End user Meetings.
• Responsible for Business Requirement Documents BRD’s and converting Functional Requirements into technical specifications.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Involved in POC of Informatica Metadata Manager and prepared a handy document for the ETL team.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, Teradata, MS Access, and Flat Files.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Look up, Update Strategy, Sequence Generator, Rank and Aggregator.
• Extensively used LTRIM, RTRIM, ISNULL, ISDATE, TO_DATE functions in Expression Transformation for data cleansing in the staging area.
• Extensively worked with Substr, Instr, Decode functions in the Expression Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Solid Expertise in using both Connected and Un connected Lookup transformations.
• Extensively worked with various lookup caches like Static, Dynamic, and Persistent Cache.
• Developed Re usable Transformations, and Re Usable Mapplets.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter File.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Extensively worked with joiner functions like normal, full outer, master outer and detail outer in the joiner transformation.
• Used Update Strategy DD_INSERT, DD_DELETE, DD_UPDATE, AND DD_REJECT to insert, delete, update and reject the items based on the requirement.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
• Innovative design for Change Data Capture of huge amounts of Customers and Customer Accounts every business day.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Environment: Windows 2000, Oracle 9i, SQL Plus, PL/SQL IBM AIX 5.2, Informatica 8.6
Jul ‘07 Sep ’08 ETL Developer, Confidential, Charlotte NC

Time Warner Cable, Inc. is the second-largest cable operator in the U.S. and an industry leader in developing and launching innovative video, data and voice services. The enterprise data warehouse helped resolve performance issues and be able to continuously learn and retain knowledge of new services and products being offered by the company. The TWC data warehouse was built on Oracle database. The sources of this were SQL Server, Oracle, XML and Flat Files. The sources were loaded into Oracle DW using Informatica.

• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and
• Transformations developer.
• Involved in designing the procedures for getting the data from various systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Responsible for studying the existing data warehouse which is in PL/SQL and also working on PL/SQL packages, stored procedures, triggers and functions.
• Used Extraction Transformation and Loading to transfer the data to the target Database.
• Used various transformations like Aggregator, Expression, Lookup, Rank, Update Strategy, Stored procedure and Sequence Generator.
• Worked with Heterogeneous targets in Power Center 8.x/ 7.x/9.0.
• Worked with different types of partition techniques like key range, pass through, Round Robin and Hash partitioning.
• Knowledge of slowly changing dimension tables and fact tables.
• Involved in Performance tuning for better performance.
• Responsible for Creating workflows and worklets. Created Session, Event, Command and Control Decision and Email tasks in Workflow Manager.
• Wrote the shell scripts to process the PL/SQL procedures and wrote the PL/SQL program units for data extracting, transforming and loading.

Environment: Informatica (Power Center 8.x/ 7.x, Oracle 9i, SQL, PL/SQL, UNIX, Windows XP
Oct 06 - Jun 07 ETL Developer, Confidential, Ann Arbor MI

Pfizer is one of the largest health care service oriented company in the world. It offers a full range of health care products. The main objective of the project was to implant a sales data mart for the health care products. Informatica Power Center 7.0 was used as ETL tool to extract data from source system to target systems. The source systems were Oracle, Flat Files, SQL Server and the target was Oracle and Flat Files.

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD\'s and converting Functional Requirements into Technical Specifications.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Experience working with Oracle warehouse builder for extracting data from heterogeneous data sources.
• Developed Re usable Transformations, and Re-Usable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Used Update Strategy DD_INSERT, DD_DELETE, DD_UPDATE, AND DD_REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Environment: Informatica Power Center 7.1.4(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 10g, SQL Server, Sybase, DB2,Access, Flat Files, Business Objects, Reflection, Windows XP, Informatica Scheduler
EDUCATION: Bachelor of Applied Science, Computer Information Systems,Confidentail University, Grand Rapids, MI