SUMMARY

• Over 16 years of total IT experience, 8 + years of experience in System Analysis, Design, Development, Testing and Implementation of Business Intelligence solutions .Extensive experience in Informatica Power Center/Power Mart to implement Data Marts which involved creating debugging and executing Informatica Mappings, Sessions, Tasks and Workflow
• Over 8 years of Data Warehousing experience using Informatica Power Center as Workflow Manager, Mapping Designer, Workflow Monitor and Repository Manager.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Strong experience in 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 relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Designed, Installed, Configured core Informatica MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Expertise in Extraction Transformation Loading (ETL) process, Dimensional Data Modeling experience using Data modeling, Star schema/ Snowflake modeling, Fact and Dimensions tables, Dimensional, Multidimensional modeling and De-normalization techniques
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence Generator, and Source qualifier and SCD Type-2 etc.
• Expertise monitoring workflows, pipeline partitioning, configuring email.
• Strong back end experience in writing PL/SQL stored procedures, functions, packages and triggers.
• Involved in Performance Tuning of the Data Warehouses including the creation of materialized views, bitmapped indexes and partitions.
• Expertise in Business Model development withDimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in implementing Power center Mappings, Mapplets and Workflows for the different stages of ETL.
• Experienced inUNIX shell scriptsto run Informatica workflows and controlling the ETL flow.
• Excellent Programming experience in SQL, Stored Procedures and Macros.
• Expertise in Query Analyzing and Performance tuning.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Vast experience 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.
• Experienced in working with tools like TOAD,SQL Server Management studio and SQL plus for development and customization

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x. Informatica Power exchange

Tools: Erwin 4.1, Toad, Rational Rose, MS Project, Test Director, MS Visio, Autosys

Data Modeling/Tools: Erwin, Star Schema, Snowflakes Modeling

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, Teradata, IBM DB2, Sybase

Operating Systems: UNIX, Windows XP/NT 4.0, Windows 2000 Server, Windows Vista, LINUX and Mainframe.

Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Database Design.

Domain Skills: Healthcare, Insurance, Energy, Utilities, Government, Banking, Finance, Logisticse-Commerce, Retail, Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr. Informatica Developer

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
• Developed technical specifications of the ETL process flow
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in SQLServer and Oracle.
• Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, tablespaces, tables using Datapump(10g) as well as traditional export/import (until 9i).
• Scheduled various daily and monthly ETL loads using Control-M
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.
• Created Cognos Impromptu reports utilizing existing Oracle views and tables.

Environment: Informatica Power Center 9.x/8.x, SQLServer 2005, PL/SQL, Oracle 10g, Toad 8.0,, Windows NT, UNIX Shell Scripting.

Confidential, Nashville, TN

Sr. Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Involved in analyzing the source data coming from different Data sources such as XML, DB2, flat files and identifying data anomalies in operational data.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping &Mapplet Designer, and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Worked on Exchange Management Console(EMC) or theExchange Management Shell(EMS) related topics.
• Performed admin related activities related to Power exchange like starting and stopping power exchange, starting and stopping dtlcacon/pwxccl process using screen utility or manually, registering different tables in Power exchange through PWX GUI tool.
• Automated the process of starting and stopping dtlcacon/pwxccl process by creating a shell script.
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Used Mapping variables for Incremental Extraction of operational data.
• Wrote Unix Shell scripts to automate workflows.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.
• Used FTP services to retrieve Flat Files from the external sources.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.
• As a SCRUM MASTER drive Daily SCRUM calls, prepare Burn-down chart, facilitate resolving issues and be an Agile Coach.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows 2000,Teradata V-14.

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Involved in analysis of different source systems and prepared technical specifications for the ETL.
• Involved in enhancing the data model for new additions of dimension and reference tables.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Created mappings and Mapplets using the transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Sequence Generator and Update Strategy.
• Used Informatica Power Exchange to handle the change data capture (CDC) data from the source and load into Data Mart by following slowly changing dimensions (SCD) type II process.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
• Restructured the Data stage jobs to enhance the performance and clarity of the job and also sent the exact data to the downstream systems.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching.
• Created BTEQ scripts to in corporate the transformation rules.
• Used Toad to write queries and interact with Oracle database.
• Developed several PL/SQL procedures, functions to provide data consistency.
• Developed Unix scripts to automate different tasks involved as part of loading process.
• Performed Unit Testing and Integration Testing on the mappings.
• Did Informatica mapping specification documents for the mappings developed and did documentation according to Business standards.

Environment: Informatica Power Center 8.5,7.X, Erwin, Oracle 11g, SQL, Power Connect, PL/SQL, UNIX, C#, Windows XP, TOAD, Teradata.

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in analysis of different source systems and prepared technical specifications for the ETL.
• Involved in enhancing the data model for new additions of dimension and reference tables.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Created mappings and Mapplets using the transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Sequence Generator and Update Strategy.
• Used Informatica Power Exchange to handle the change data capture (CDC) data from the source and load into Data Mart by following slowly changing dimensions (SCD) type II process.
• Used Power Center Workflow Manager to create workflows, sessions, and also used various tasks like command, event wait, event raise, email to run with the logic embedded in the mappings.
• Restructured the Data stage jobs to enhance the performance and clarity of the job and also sent the exact data to the downstream systems.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Extensively worked on performance tuning of Informatica Mappings and Sessions by implementing parallelism, partitioning and caching.
• Created BTEQ scripts to in corporate the transformation rules.
• Used Toad to write queries and interact with Oracle database.
• Developed several PL/SQL procedures, functions to provide data consistency.
• Developed Unix scripts to automate different tasks involved as part of loading process.
• Performed Unit Testing and Integration Testing on the mappings.
• Did Informatica mapping specification documents for the mappings developed and did documentation according to Business standards.

Environment: Informatica Power Center 8.5,7.X, Erwin, Oracle 11g, SQL, Power Connect, PL/SQL, UNIX, C#, Windows XP, TOAD, Teradata.

Confidential

Sr. Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Identified and tracked the slowly changing dimensions and determined the hierarchies within the dimensions.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, DB2, SQL*Plus, SQL Loader, SQL Developer, Autosys, Flat files, UNIX, Windows 2000,Teradata V-14., DB2 UDB EE/8.1, AIX 4.3, Solaris

Informatica Developer

Confidential

Responsibilities:

• Involved in the creation of the Technical design document on the basis of the Functional design document.
• Designed ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin 4.0.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mapping and complex transformations (Aggregator, Joiner, Lookup, Normalizer, Filter).
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts.
• Analyzed and created Facts and Dimension tables.
• Involved in Performance Tuning of the mappings.
• Implemented Slowly Changing Dimension (SCD- Type II) dimension mappings.
• Wrote validations using PL/SQL Stored Procedures before transferring data from temporary table to Interface tables.
• Used Repository Manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to Target systems using Informatica Power Center.
• Created the Informatica mappings to extract the data from Oracle and load into Target database.
• Involved in Performance testing of all the workflows/Mapping, which helped in analyzing its performance before moving into production.

Environment: Informatica PowerCenter 6.0, Power Exchange, Erwin, Oracle, SQL, BTEQ, Power Connect, PL/SQL, UNIX, TOAD.

Development Lead

Confidential

Responsibilities:

• Managed multiple projects
• Responsible for client-interaction and deliverables
• People Management
• Project Planning and Execution
• Responsible for defining the solution architecture and design

Sr. Software Engineer

Confidential

Responsibilities:

• Project lead for 15 member team
• Application Design using OOA/D and UML
• Project Plan Preparation and Execution
• Developing N-tier applications using ASP.NET, VB.NET, ADO.NET and SQL SERVER 2000
• . NET Remoting and Web Services
• Exposure to CMM and ISO procedures
• Handling enhancement and maintenance requests for the existing COM / COM+, Visual Basic, and SQL server applications

Software Engineer

Confidential

Responsibilities:

• Application Design using OOA/D and UML
• Developing N-tier applications using ASP.NET, VB.NET, ADO.NET and SQL SERVER 2000
• . NET Remoting and Web Services
• Handling enhancement and maintenance requests for the existing COM / COM+, Visual Basic, and SQL server applications

Analyst Programmer

Confidential

Responsibilities:

• Full software development life cycle: gathering and preparing business requirements, design, development, quality control testing and deployment
• Technical Lead for five-person team
• Developed Applications in a 3-tier architecture using ASP, Visual Basic COM Components and SQL.
• Designed, developed and deployed web solutions for AA using Microsoft’s IIS with a combination of VB, ASP, VBScript, Active X, and COM objects with Oracle as back-end

Customer Support Engineer

Confidential

Responsibilities:

• Visual Basic distributed applications: Graphical user interface, navigation design, COM/DCOM client -server development
• Technical and user documentation.
• Worked extensively on the design and development of middle tier business objects and user interface components using Visual Basic
• Wrote Complex Ad hoc SQL queries and used Excel automation to generate various MIS reports
• Development, unit testing and deployment of Visual Basic Applications