SUMMARY

• Around 7+ years of professional experience in ETL Informatica Development, Oracle PL/SQL program for industries like Pharma, Retail, manufacturing, human resource, etc.,
• Having good experience in the implementation of Data Warehousing and Database business systems.
• Data warehousing experience using Informatica Power Center, Power connect/exchange Designer, Workflow Manager, workflow Monitor, ETL, Data mart, OLAP, OLTP.
• Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, etc.
• Created Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2, and Type 3) mappings.
• Experience in extraction of data from various Heterogeneous sources (Relational database, Flat Files, XML, Excel, COBOL) and load into various layer of data warehouse.
• Experienced in Performance Tuning of ETL Objects.
• Written complex SQLs using joins and sub - queries.
• Database experience using Oracle, TOAD, SQL, PL/SQL, SQL*Plus, SQL*Loader
• Knowledge in the OLAP Reporting tools like Business Objects, Cognos, etc.
• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing and Business Intelligence.
• Experience in Modeling Transactional Databases and Data Warehouses Data Modeling using Erwin.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.
• Developed UNIX shell scripts (UPROC in $U application) for scheduling, Process Automation and periodic job scheduling.
• Experience in developing Oracle PL/SQL Programs such as - Developing Packages, Stored Procedures, Functions, Creation of Triggers, Views, and DB Changes as per spec etc.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6/ 8.5/8.1/7. x/6.x Repository Manager, Designer, Server manager, Workflow Monitor, Workflow Manager, Power Exchange 8.5.

RDBMS: Oracle 10g/9i/8i/8.x, Teradata

DB Tools: TOAD 9.0.1, SQL*Plus, PL/SQL Developer 7.1.4.1390

Modeling Tools: Erwin 4.0

Reporting Tools: Business Objects XIR3/R2

Oracle Tuning: SQL Tuning, Explain Plan, Table Partitioning, Materialized views, HintsB-Tree/Bit-Map Indexing

Languages: C/C++, Java, HTML, JavaScript, SQL, PL/SQL, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

ETL Informatica Developer

Responsibilities:

• Developed complex mappings to load the data into facts and categories.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed Mapplets and Reusable Transformations for calculated business units.
• Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Developed data mapping for Sources, Targets, and Business Transformation rules.
• Developed mappings for slowly changing dimensions (Type I, II) and Facts using Informatica Tool.
• Provided performance tuning ETL mappings to diagnose slow performing mappings and develop solutions to improve mappings performance
• Involved in the performance tuning of the programs.
• Developing Packages, Stored Procedures, Functions, Creation of Triggers, Views, and DB Changes as per spec etc.
• Responsibility for ETL Objects and Database Objects migration for each release.
• Used different Data Warehouse techniques like Star-Schema, snowflake schema.
• Done unit testing to check for any errors in the data loaded.
• Created functions with exceptions handling for various modules as per the requirement.
• Effectively used Conditional Control Statements in programs.
• Involved in Analyzing and Performance Tuning of the SQL queries
• Managed the database and performed the basic tasks like creating users, assigning roles and privileges, creating new tables etc. Created and Maintained Oracle Schema.
• Involved in designing of Unix Shell Scripting with the help of UNIX server.
• Worked closely with Development and maintenance ETL processes to support the data warehouse using Oracle Warehouse Builder.
• Participated and involved in the team meetings.
• Created data models using ERWIN as per the business requirements.

Environment: ETL-Informatica Power Center 9.1/8.6, Oracle 10g, Flat Files, CSV, SQL Developer, Toad, UNIX, ERWIN

Confidential, Boca Raton, FL

ETL Informatica Developer

Responsibilities:

• Developed and modified High Level Design (HLD) documents for technical requirements
• Involved in development of complex mappings to load the data into facts.
• Implemented Slowly Changing dimensions.
• Work with the Data Warehouse Reporting team to understand data sources and implement new requirements
• Responsible for the Technical Support for the environments and interacting with internal and external IT and user personnel.
• Developed and maintained ETL processes to support the data warehouse using Informatica
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Implementing the complex business rules by creating re-usable transformations, Mapplets.
• Extensively used Transformation Language functions in the mappings to produce the desired results.
• Involved in Performance Tuning of Informatica mappings, SQL Query, views etc.
• Successfully moved the Sessions from the Development environment to Production environment.
• Ran Daily, Weekly and Monthly reports as the user requirements.
• Involved in different Team review meetings.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting.
• Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.

Environment: ETL-Informatica - Power Center 8.6, Oracle 10g, Flat Files, PL/SQL Developer 7.1, Shell Script

Confidential, Groton, CT

ETL Informatica Developer

Responsibilities:

• Involved in full life cycle development including Design, ETL strategy, troubleshooting, and Identifying facts and dimensions.
• Analyze and design Common Dimension Layer (CDL) and implemented Slowly Changing dimensions (Type1, Type2, Type3)
• Developing complex data processing objects using Informatica, SQL and UNIX Shell Scripts to meet data load requirements of business
• Technically Responsible for Quality of the Deliverables, ETL performance and scalability, Daily load operations
• Work with the Data Warehouse Reporting team, Web Engineering team and Business Systems team to understand data sources and implement new requirements
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, SQL, Filter, Router, Rank, Aggregator, LOOKUP (Target as well as Source), Update Strategy, Source Qualifier and Joiner
• Coded Stored Procedures, Database Triggers and Functions and Packages using PL SQL.
• Involved in Tuning SQL, PL/SQL codes, Stored Procedures and Database Trigger.
• Optimizing the query using Plan Table.
• Involved in database mapping creation and performance tuning.
• Designed the daily, weekly, monthly, quarterly batches with complex dependencies and scheduled them.
• Worked with various DB objects like Materialized views, Stored Procedures, Functions, Sequence Generators and Partitions of tables.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & to different servers.
• Involved in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc. .
• Error handling in ETL Process using Common Component Architecture.
• Developed reusable transformations, Mapplets and Worklets to reduce development
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures, Triggers, Function and packages

Environment: ETL-Informatica - 8.1.1/8.6 Power Center, Power Center Metadata Manager 8.6.1, Business Objects 9.2.0.6 64/10 g, MS SQL Server 2000, SQL Navigator 5.5, Flat Files, Toad 9.1.0.62, Teradata, Visio 2003, ERWIN 3.5.2/4.x/7.2.5, Live link, SharePoint, Shell Script, Unix SUNOS 2.8 and Windows 2000/XP

Confidential, Rhode Island

ETL Informatica Developer

Responsibilities:

• Worked closely with the Applications Development and Project Management teams coordinating, scheduling and implementing.
• Worked with development and production support for a multi-source star schema data warehouse
• Create/Maintain database stored procedures, functions, packages, views, types, tables.
• Responsible for the Technical Support for the environments and interacting with internal and external IT and user personnel.
• Developed and maintained ETL processes to support the data warehouse using Informatica
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Participated in metadata management and implementing Data Quality processes.
• Created reusable transformations and mapplets to use the transformation logic in multiple mappings.
• Monitored workflows and performance tuning in a data warehouse environment.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table
• Designed and Developed the Informatica workflows/sessions to extract from My-SQL Data Base, transform and load the data into oracle.
• Analyzed existing database schema DDL/instance layout and determine impacts migrating to new target schema/instance environment.
• Involved in data modeling for an expanding data warehouse.
• Responsible for performance fine-tuning of SQL and PL/SQL queries for better performance.
• Incumbent will troubleshoot any issue to determine root cause of the problem and recommended solution to insure outcome is accepted by the business.
• Ran Daily, Weekly and Month reports as the user requirements.
• Responsible for creating scripts for loading data using SQL* Loader.
• Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Worked with UNIX system to run patient claims.

Environment: Informatica Power Center 8.6.1/8.1, Oracle 9i/10g, SQL plus, PL/SQL, Windows 2000, SQL, SQL loader, OWB, TOAD 8.5/8.6, Excel (2003, 2007)

Confidential, San Antonio, TX

ETL Informatica Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements.
• Worked on production support which requires off-hour availability and connectivity.
• Involved in writing complex queries for generating different reports as per client needs.
• Provided performance tuning OWB ETL mappings to diagnose slow performing mappings and develop solutions to improve mappings performance.
• Extracted the data from Flat files and loaded the data into Data were house using Informatica Power center.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Managed Data Analysis, Data Conversion, mapping, Data Processing, Financial Analysis, System Analysis, Reports Design, Reports Development including Statistical Reports, Implementation, Reports Quality Testing and reports maintenance
• Created shortcuts for source and target and also created Reusable Transformations in Shared folder.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Worked closely with Development and maintenance ETL processes to support the data warehouse using Oracle Warehouse Builder and Oracle workflow manager
• Wrote stored procedures, functions, packages, views, types, tables in database.
• Involved in designing and implementing Change Data Capture techniques like Slowly Growing Target and Slowly Changing Dimension (Type1, Type2, Type3) simple pass through mapping.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target tables in warehouse using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Extensive use of SQL Loader for migration of data from Flat File to Oracle.
• Used the PL/SQL protocols to access the repository.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Experience in UNIX shell scripting, PL/SQL and SQL scripting for automation of ETL processes.
• Designed/Created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis.
• Involved in complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Prepared weekly status reports and Quality related documents.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex problem troubleshooting.
• Defined the entity-relations - ER Diagrams and designed the physical databases for OLTP and OLAP (data warehouse

Environment: Informatica Power Center 8.5/ 8.1/7.1.2 , Oracle 10g, PL/SQL, SQL Plus, UNIX ScriptingWindow 2000, SQL Loader, OWB, TOAD 9, Windows 2003 Server, ERwin 4.1, UNIX Server

Confidential, WI

ETL Informatica Consultant

Responsibilities:

• Participated in the entire Software Development Life Cycle (SDLC) phases including (Data Analysis, Data Modeling, Development, Supporting)
• Analyzed Business Requirements and converted them into mapping design.
• Developed data mapping for Sources, Targets, and Business Transformation rules.
• Developed mappings for slowly changing dimensions (Type I, II) and Facts using Informatica Tool.
• Used different Data Warehouse techniques like Star-Schema, snowflake schema
• Created various active & passive transformations like Expression, Lookup, Filter, Rank, Aggregator, Router, Update strategy, Stored Procedure, Joiner etc…
• The project called for extensive work using the Informatica tool involving - Source Analyzer, Target designer, Mapping designer & Mapplet and Transformations.
• Provided performance tuning ETL mappings to diagnose slow performing mappings and develop solutions to improve mappings performance
• Worked with development and production support for a multi-source star schema data warehouse
• Developed Mapplets and Reusable Transformations for calculated business units.
• Involved in the performance tuning of the programs
• Developed Quality control process purely in Oracle PL/SQL that calculates all the financials using the business rules and checks those amounts with those coming out of informatica maps.
• Developing Packages, Stored Procedures, Functions, Creation of Triggers, Views, and DB Changes as per spec etc.
• Responsibility for ETL Objects and Database Objects migration for each release.
• Tested the target data against source system tables by using SQL scripts /PL/SQL procedures.
• Monitored the daily data loads and provided support after hours.

Environment:, Informatica Power Center 8.1/7.1.2, Oracle10g/ 9i, PL/SQL, SQL Plus, UNIX Scripting, Window 2000,SQL Loader, Erwin 4.0/3.5.2, Flat files, XML, TOAD 8.6.1.0

Confidential

Senior Software Engineer

Responsibilities:

• Upgraded Informatica Power Center 6.2 to Informatica Power Center 7.1.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
• Developed complex mapping in order to implement slowly changing Dimension type 1 and type 2
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the Normal run of the workflow.
• Involved in development and production support for a multi-source star schema data warehouse
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process.
• Worked with performance tuning ETL mappings to diagnose slow performing mappings and develop solutions to improve mappings performance.
• Document new and enhanced functionality in the form of ETL specification documents
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the Sales Force Data according to the business logic.
• Perform data validation and integrity checks for the data migrated from one database to other
• Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Design for the product, preparing the Internal Design documents, delegating development and design tasks to team members, brief project planning in terms of scheduling, development, review, preparing of Unit test plans, reviewing Unit test plans, executing Unit test plans, assisting team members.
• Written packages, triggers, procedures, functions as per the requirement.
• Created all the data base objects using Erwin data modeling.
• Using SQL loader by writing control files and oracle pl/sql scripts to upload the flat file data in to target tables

Environment: Informatica 7.1, Oracle PL/SQL, Oracle 9i, Erwin Data Modeling