SUMMARY

• Seven plus(7+) years of Total IT Experience in the Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of software systems in various verticals such as Financial, Health Care, Telecommunication industries.
• Six years of strong Data Warehousing experience using Informatica Power Center 9.x/8.x
• Extensive domain knowledge in Banking, Insurance, Payroll and Financial domains
• Good understanding of life cycle Implementation for data warehouse.
• Proficiency in gathering business requirements, establishing functional specifications and translating them to design specifications
• Experience in Databases such as Oracle and SQL Server.
• Experienced in working with various Power center/ Power Mart components like Informatica server and client tools e.g., Designer, Repository Manager, Workflow Manager and Workflow Monitor
• Experience in implementing incremental loads and Change Data capture (CDC).
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings and Workflows in all versions of Informatica
• Strong Data Warehousing experience using ETL scripts and Informatica Power Center (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Data mart, OLAP, ROLAP, MOLAP, OLTP, Star Schema, Snowflake Schema.
• Worked on all the transformations like Connected and Unconnected - Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter
• Experienced in Data Cleansing as per the business requirements using ETL tools and PL/SQL and preparing the cleansed data for loading into data warehouse
• Excellent understanding of Client/Server architecture makes a valuable asses to any project, with excellent logical, analytical, communication and organizational skills.
• Excellent team player and can work on both development and maintenance phases of the project.
• Highly skilled in providing instantaneous and workable solutions to business requirements
• Good organizational and interpersonal skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter9.x/8.x(Repository Manager, Repository Server Administration Console, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer) Data Mart, OLAP, and OLTP.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Normalization, Denormalization and MS Visio

Databases: Oracle 11g,10g, MS SQL Server 2008, MS Access,Teradata

Programming: SQL, PL/SQL, C, SQL*Loader, Unix, HTML

Other Tools: SQL Developer, SQL*Plus, TOAD, Excel, Word

Operating Systems: Windows (XP, NT/ 95/98/2000/2003 ),UNIX

Reporting Tools: Hyperion, SQR,Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, PORTLAND, ME

ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules & made recommendations for innovative IT solution.
• Worked with the various enterprise groups to document user requirements, translate requirements in to system solutions and produce development, testing and implementation plan and schedule.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, FilterAggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator
• Developed, documented and executed unit test plans for the components.
• Set some understanding according to the business approach and making development while confirming with BA s, if any BR (Business Rule) being used was not effective. In a way, that using the experience and business understanding to make out BR s and implements them to design the business logics.
• Documenting the developed code, run the sessions and workflows, while keeping track of source and target row count.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Created pre - session and post-session shell scripts and mail-notifications.
• Extensively worked on the Informatica Designer, Repository Manager, Repository Server,Workflow Manager/Server Manager and Workflow Monitor.
• Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.

Environment: Informatica Power Center 8.6(Repository Manager, Repository Server Administration Console, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer,Mapping Designer, Repository manager), PowerMart, PowerConnect, PowerExchange, Oracle 10g, Flat file, SQL Server 2000, SSIS, SQL* Loader, PL/SQL, Control - M, DTS Packages, UNIX, Windows 2000.

Confidential, Irvine, CA

ETL Developer

Responsibilities:

• Worked with different Informatica client Tools like Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server.
• Worked with Business requirements analyst to identify and understand source data systems and developed Mappings between source systems and warehouse components.
• Extensively created different complex mappings using expressions, aggregators, filters, lookup, router, joiner, sorter and procedures to develop and feed in Data Warehouse and used Update strategy transformation to transfer data from source to data effectively.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Used debugger to validate mappings and gain troubleshooting information about data and error conditions.
• Sound knowledge in migrating mappings from development to testing and then to production.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Extraction Involved in the development of Informatica mappings and also tuned them for better Performance.
• Migrated Informatica folders, mappings, workflow, reusable objects from one environment to another and in the process of change control.
• Monitoring the existing ETL jobs and takes necessary actions as per the errors handling methodology.

Environment: Informatica Power Center 8.6(Repository Manager, Repository Server Administration Console, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository manager), PowerMart, PowerConnect, PowerExchange, Oracle 10g, PL/SQL, SAP R/3, TOAD, and Cognos, UNIX, Windows XP, Erwin 4x, UNIX Shell Scripts.

Confidential, Bothell, WA

ETL Developer

Responsibilities:

• Developed various mappings for extracting the data from different source systems using Informatica, PL/SQL stored procedures.
• Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse.
• Extensively used Informatica to load data from MS SQL Server into the data warehouse
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes
• Successfully developed drill down reports and hierarchies, created cascading values using Cognos
• Extensively involved in troubleshooting the issues in UAT.
• Extensively used almost all the transformations, which includes (Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Static and Dynamic), Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier).
• Used Mapplets, Reusable transformations, Parameters and Variables to implement OO (Object Orientation) techniques and to facilitate the reusability of Code.
• Involved in creating and running Sessions and Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Seamlessly migrated the code from Development---Testing---UAT---Production
• Extensively worked on creating and executing formal test cases, test plans for functional, system and regression testing
• Wrote reports for internal and external users of the Credit Card Data Warehouse (Hyperion Interactive Reporting)

Environment: Informatica 8.6/9(Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Mapping Designer, Repository manager) PowerMart, PowerConnect, PowerExchange, SQL* Loader, Oracle10g/11g, DB2, SQL Server, PL/SQL, Flat files, Cognos 7.5,TOAD and Windows.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center Designer.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations for the Sales and Marketing Systems to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
• Developed Mappings for the Category, Specification, Code, Type areas.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations.
• Involved in the development and testing of programs, Informatica mappings and update processes.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules (business rules).
• Developed schedules to automate the update processes and Informatica Sessions/Batches.

Environment: Informatica power center 8.1, WorkFlow Designer, Powercenter Designer, Repository Manager, PowerMart, PowerConnect, Oracle 9i, IBM mainframes, TIDAL, Teradata, DB2, SQL*Plus, Windows 2003,SQL Server, SSIS and TOAD.

Confidential, Cincinnati, OH

ETL Developer

Responsibilities:

• Design and Development of ETL routines using Informatica Power Center 8.1. Within the Informatica Mappings, usage of Expression, Filter, Lookups, Router, Aggregator, Joiner, Update, connected and unconnected stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Design and Development of data validation and load processes (using PL/SQL, SQL).
• Implemented slowly changing dimensions.
• Performance Monitoring and tuning of SQL using Explain Plans and Oracle Hints and tuning of Informatica mappings using SQL overrides and source filters and managing cache file all locations and sizes.
• Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Developed and tested all the informatica Data mappings, sessions and workflows involving several Tasks.
• Strong Experience on writing SQL Queries, PL/SQL Procedures in Oracle Database.
• Implementation of stored procedures and packages utilizing PL/SQL for the enhancements of the existing application level data warehouse.

Environment: Informatica Power Center 8.1(PowerMart/ PowerCenter), PowerConnect, WorkFlow Designer, Powercenter Designer, Repository Manager, Oracle 10g, Cognos, UNIX (HP-UX 11.x), Windows 2K, UNIX Shell Scripts, PL/SQL, DB2 Connect, TOAD

Confidential, Berkeley Heights, NJ

Responsibilities:

• Performed Requirements Analysis, Process Design, Data Design, Development, Testing and Implementation of Data warehouse load processes and Data transformation processes.
• Extensively worked on Informatica Power Center - Designer, Workflow Manager and Workflow Monitor.
• Extensively used Informatica Workflow Manager and Workflow Monitor to develop, manage and monitor workflows and sessions
• Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator, Sorter and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.
• Simplified the data flow by using a Router transformation to check multiple conditions at the same time.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Created Sessions, Workflows and scheduled and monitored the workflows and Tasks using Workflow Manager and Workflow Monitor.

Environment: Informatica Power Center 7.1(WorkFlow Designer, Powercenter Designer, Repository Manager, PowerMart, PowerConnect), MS Visio, Oracle 8i, MS SQL Server, Sybase, SQL, PL/SQL, TSQL, Flat Files, XML, UNIX and Erwin