SUMMARY

• 10+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial, Telecom and Timeshare Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong experience with Ralph Kimball and Inmon data modelling methodologies.
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.1/8.6.1/8.5/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Familiarity with Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with various sources such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, flat files, COBOL/VSAM.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Utilized AUTOTRACE and EXPLAIN PLAN for monitoring the SQL query performance.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Created pre-session, post session, pre-sql, post sql commands in Informatica.
• Worked with different Informatica transformations like Aggregator, Lookup, Joiner, Filter, Router, Update strategy, Transaction Control, Union, Normalizer, SQL in ETL development.
• Worked with Event wait and event raise tasks, mapplets, reusable transformations.
• Worked with Parameter file for ease of use in connections across Dev/QA/Prod environments.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys, Tidal.
• Worked with QA team to perform testing, writing test cases, documenting test results, raising defects in HP QC.
• Worked extensively with slowly changing dimensions SCD Type1 and Type2.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Lead/Sr Informatica developer

Responsibilities:

• Involved in all phases of the project SDLC to gather business requirements.
• Worked closely with the Business analyst to understand the various source data.
• Involved in designing of star schema based data model with dimensions and facts
• Designed ETL mapping document to map source data elements to the target based in Star-Schema dimensional model.
• Used Informatica Dynamic partitioning, push down optimization to improve session performance.
• Worked with stored proc to truncate table, drop indexes and recreate indexes to use in pre-session and post session properties.
• Worked with Scheduler to schedule Informatica sessions on daily basis and to send an email after the completion of loading.
• Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformation transformations.
• Used parameter files for storing database connection of sessions for reusability across all the environments Dev/QA/PROD.
• Lead the off-shore team for development and production support tasks.
• Worked with QA team to debug and resolve defects raised during QA phase.
• Used reusable tasks like session task, email task, command task in workflow manager.
• Worked in production support tasks, on-call rotation basis for daily production jobs.

Environment: Informatica Power Center 9.6, Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, UNIX Shell Scripting, SQL Server 2005, SQL Server 2008.

Confidential, Atlanta, GA

Lead/Sr Informatica developer

Responsibilities:

• Worked as Lead for the projects, involving in all the phases of SDLC.
• Worked with Data Architect in designing the data mart, defining, designing and building FACTS and DIMENSIONS using Star Schema model.
• Worked with SCD Type1, Type 2, and Type3 to maintain history in Dimension tables.
• Developed Informatica workflows/worklets/sessions associated with the mappings across various sources like COBOL copy book files, sources, flat files.
• Worked with transformations Source Qualifier, Update Strategy, Java transformation, Normalizer, Lookup (Connected and Unconnected).
• Worked with Push down optimization to improve performance.
• Worked on UNIX shell scripting for file processing to third party vendor through SFTP, encryption and decryption process.
• Documentation of ETL process for each project and KT to Offshore and team.
• Work closely with DBAs, application, database and ETL developers, and change control management for migrating developed mappings across Dev, QA, and PROD environments.
• Production support for the Informatica process, troubleshoot and debug any errors.

Environment: Informatica Power Center 9.5, Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, UNIX Shell Scripting and Windows 2000, Windows 2003, SQL Server 2005, SQL Server 2008.

Confidential, Atlanta, GA

Lead/Sr Informatica developer

Responsibilities:

• Lead design, development and implementation of the ETL projects end to end.
• Responsible for ETL technical design discussions and prepared ETL high level technical design document.
• Worked with Business users to understand the data, understand the business and gather requirements.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Involved in designing of star schema based data model with dimensions and facts.
• Interacting with onsite and offshore team to assign Development tasks and scheduling weekly status calls with offshore team on status.
• Extracted data from flat files, mainframe files, Golden Gate, Oracle, Sql server using Informatica ETL mappings and loaded to Data Mart.
• Created complex Informatica mappings using transformations Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, Lookup and Router transformations to extract, transform and loaded data mart area.
• Used Teradata utilities fastload, multiload, tpump to load data from various source systems.
• Worked extensively on shell scripting for file management.
• Created re-usable transformations/mapplets and used across various mappings
• Wrote complex PLSQL scripts /functions/procedures/packages.
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager.
• Worked on performance tuning of Informatica sessions using partitioning like pass through and dynamic partitioning.

Environment: Informatica Power Center 9.5/ 9.1.0/8.6.1 , Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, Unix Shell Scripting and Windows 2000, Windows 2003, SQL Server 2005, SQL Server 2008

Confidential, Brea, CA

Lead/Sr Informatica Developer

Responsibilities:

• Worked as Informatica Lead for ETL projects to design, develop Informatica mappings.
• Involve in all phase of SDLC, i.e. design, code, test and deploy ETL components of data warehouse and integrated Data Mart.
• Created reusable objects like Mapplets, reusable transformations, user defined functions, short cuts etc.
• Created Informatica mappings using various transformations like Source Qualifier, Expression, Look up, stored procedure, Aggregate, Update Strategy, Joiner, Normalizer, Union, Filter and Router in Informatica designer.
• Created pre-session, post session, pre-sql, post sql commands in Informatica.
• Used UNIX scripts for file management as well as in FTP process.
• Developed scripts using NZLoad and NZSQL Netezza utilities to load the data from and to Netezza database.
• Work closely with DBAs, application, database and ETL developers, change control management for migrating developed mappings to PROD.
• Created stored proc to drop and recreate indexes while loading the data into target to improve performance.
• Production support for the Informatica process, troubleshoot and debug any errors.

Environment: Informatica Power Center 9.5/ 9.1.0/8.6.1 , Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, Unix Shell Scripting, SQL Server 2005/2008, Netezza.

Confidential, Orlando, FL

Sr Informatica/SSIS Developer

Responsibilities:

• Work with offshore/onsite team and lead the project and assign tasks appropriately to the team members.
• Responsible for projects estimates, design documents, resource utilization and allocations.
• Interacting and assigning development work to Developers that were offshore and guiding them to implement logic and troubleshoot the issue that they were experiencing.
• Worked with transformations like Normalizer, Update Strategy, Lookup, Router, Filter, and Joiner.
• Created Parameter files for Connection strings in Workflow Manager for reusability of Connections across Dev/QA/Prod Environments.
• Migrated the code from lower environments Dev/QA to prod from Repository Manager.
• Worked with Unix Shell scripting for file management.
• Used pmcmd commands to execute Informatica workflows.

Environment: Informatica Power Center 9.1.0/8.6.1 , Flat Files, Mainframe Files, Oracle 11i,Quest Toad Central 9.1, Unix Shell Scripting and Windows 2000, Windows 2003,SQL Server 2005,SQL Server 2008.

Confidential, Miami, FL

Senior Informatica Developer

Responsibilities:

• Lead and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations.
• Analyzed the existing mappings and understand the dataflow process.
• Fixing the existing issues by introducing the data cleansing techniques into the mappings rather than cleaning the source data files manually.
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers
• Extensively used Toad for analyzing the queries in the existing the mappings to better understand the business logic implemented.
• Created complex mappings in Power Center Designer 8.6 using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner and Stored procedure transformations.
• Performed performance tuning by identifying the bottlenecks in informatica mappings and sessions and also using explain plan in oracle using TOAD.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Created pre-session, post session, pre-sql, post sql commands for email notifications with the Email Task, also to update target tables after the data is loaded.
• Created and used tasks like Email Task, Command Task, and Control task in Informatica workflow manager and monitored jobs in Workflow Monitor.
• Developed UNIX scripts for file management like to zip & unzip the files.
• Developed the automated and scheduled load processes using TIDAL Scheduler.

Environment: Informatica Power Center 8.6.1, Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, Unix Shell Scripting and Windows 2000, Windows 2003, SQL Server 2005,SQL Server 2008

Confidential, Denver, Colorado

Informatica developer

Responsibilities:

• Worked closely with the Business analyst to understand the various source data.
• Involved in designing Logical and Physical models for staging, transition of the Data.
• Involved in designing of star schema based data model with dimensions and facts
• Designed ETL mapping document to map source data elements to the target based in Star-Schema dimensional model.
• Created Stored Procedure, Functions and Triggers as per the business requirements
• Used Update Strategy and Lookup transformation to implement the Change Data Capture (CDC) process
• Partitioned sources to improve session performance.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate One time and Monthly loading of Data
• Utilized the Aggregate, Join, Router, Lookup and Update transformations to model various standardized business processes
• Worked with Scheduler to schedule Informatica sessions on daily basis and to send an email after the completion of loading
• Created design documents and performed Unit Testing on the Mappings.
• Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformation.

Environment: Informatica 7.1/6.x, Oracle 10g, SQL Server 2005, Autosys, Business Objects 6.5

Confidential

Software Programmer/Oracle developer

Responsibilities:

• Involved in creating Functional and Program Specification documents.
• PL/SQL Development and Implementation.
• Extensive Performance Tuning (SQL Tuning, PL/SQL Tuning)
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL)
• Involved in the creation of Partitioned Tables and Indexes
• Involved in the creation and modification of Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL Queries to implement the business requirements.
• Involved in loading data into Database using SQL*Loader.
• Data Migration using PL/SQL stored Procedures.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Involved in analyzing Schema’s, Tables and Indexes as part of OPTIMIZATION.
• Used data pump to refresh the development and test database environment.

Environment: Oracle 9i, HP-UX 11.0, SQL DEVELOPER, TOAD, Cognos Report net (Report Studio, Query Studio, Cognos Connection) Framework Manager, Cognos Series 7 (Impromptu Administrator, Power play Enterprise Server, Power play Transformer, Access Manager), Microsoft IIS