SUMMARY

• More than 9 years of software experience in System Analysis, Application Design, Development, Implementation and ETL, Reporting for Data Warehousing.
• As a ETL Developer in designing and implementing Data Mart / Data Warehouse applications using INFORMATICA Power Centre 9.x/ 8.x / 7.x / 6.x (Designer, Workflow manager, Workflow monitor and Repository Manager).
• Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Preparing the High level Design Specifications for ETL Coding and mapping standards and experience in Performance tuning.
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, Teradata, and XML, EBCDIC files. Experience in Data Flux, ERWIN/ ER studio.
• Expertise Informatica B2B Data Transformation, DT and DX, pre - built transformations for most versions of industry standard messages including the following EDI standards Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center. Experience in working with scheduling tools like Autosys and Control M.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerExchange, InformaticaPowerCenter.
• Expertise in writing Oracle PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Develop a transformation by marking the relevant data directly on a sample of the data source, and mapping that data to a chosen XML schema
• Expertise in writing DDL, DML, DCL, and TCL commands and also experience with UNIX commands, VI editor and writing Shell scripts.
• Experience in creating reports using Oracle Business Intelligence 10x, and Siebel Analytic
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Team Player, Able to Work with a new and fresh perspective on work assignments, good in debugging, creative and able to learn new things.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.0 /8.6.1 / 8.1.1/7.1.3 / 6.2, Informatica Power Exchange 8.5, Informatica Data Quality, Informatica Data Explorer, Humming Bird Genio

Business intelligence: Business Objects XI/Business Objects 6.5, Oracle Designer

RDBMS: Oracle 11g/10g/9i/8i, SQL*LoaderIBM DB2 UDB 8.1/7.0, MS SQL Server 2005/2000/7.0 MS Access 7.0/2000

Data Modeling: Erwin 3.5.2, Microsoft Visio

Tools: Toad, AQT, SQL Developer, Quest Central for DB2,SQL Assistant 7.1, Putty, Winscp, Autosys, Business Objects 6.0/5.1/5.0., Cognos 8BI/7.0.s, Sybase, OBIEE 10.1.3.x.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, JavaOracle SQL Developer 1.5.5, Control-M, Syncsort, SQL, PL/SQL, ts 0, Visual Basic 6.0/5.0, HTML, DHTML, XML.

Operating Systems: Win 95/98/2000, HP-Unix 11/10/9, AIX, Sun Solaris 2.6/2.7.

PROFESSIONAL EXPERIENCE

Confidential, CT

Sr. Informatica developer

Responsibilities:

• Involved in the design and development of ETL code for the investment management system using Informatica.
• Involved in the Study of the business logic and understanding the source and target system.
• Developed mappings, sessions, workflows and workflow tasks based on the user requirement and scheduled the workflows in workflow manager and monitor the status of the workflow runs in workflow monitor.
• Created and imported different source and target definitions in source analyzer and warehouse designer and called them into the Informatica mapping Designer.
• According to the business logic created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression, and Update Strategy.
• Responsible for migrating code from development to testing then to the production environment and experience in creating Reusable Transformations and Mapplets and used them in Mappings.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning techniques.
• Used PMCMD command to start, stop, and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Successfully Implemented Slowly Changing Dimensions. Used type 2 dimension to keep the history changes in data by versioning, effective data and flags.
• Extensively used Workflow Manager and Workflow Monitor for creating and monitoring workflows and sessions.
• Developed workflow tasks like Event wait, Event Raise, Timer, Command, Decision.
• Created Oracle Stored Procedures to implement complex business logic for good performance and called from Informatica using Stored Procedure transformation.
• Used Informatica debugger to test and fix the mappings and created test cases for Unit Test, System Integration Test and UAT.
• Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.

Environment: Informatica Power Center 9.0, Oracle 11g, SQL Server 2007, PL/SQL, Flat Files, Mainframe DB2, Cobol Files, Business Objects 6.5, ERWIN Data Modeling tool, UNIX, Shell Scripts, Autosys, Windows Server 2008 .

Confidential, NE

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.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Extract data, Transform data, Load data 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.
• Worked on various active & passive transformations like Aggregator, Expression, Filter, Router, Lookup, Update Strategy, Stored Procedure, Update Strategy, and Sequence Generator. Used debugger to test and fix the mappings.
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Extensively used Workflow Manager and Workflow Monitor for creating and monitoring workflows and sessions. Developed Informatica parameter files.
• Used various Oracle Index techniques to improve the query performance
• Designed and Developed Oracle PL/SQL Stored Procedure for efficient customized data loading, retrieval and implement complex business logic for good performance
• Created Materialized views for summary tables for better query performance
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality
• Involved in writing UNIX shell scripts to automate the business process and also provided End - user training and support.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL, PL/SQL, and Windows, Autosys, Unix, Power Exchange 8.1, Metadata Manager, C#, Java, Oracle BI Applications, Power Connect, SQL Server 2005, XML,, 10+ Teradata, Erwin 3.5, DB2 on Mainframe.

Confidential

Senior ETL Developer

Responsibilities:

• Management to forecast their markets accurately identifies the factors that most impact involved in all phases of SDLC from requirement, design, development and testing.
• Each segment's profitability. Warehouse is supposed to assist in defining strategy for extensively involved in requirement analysis and created ETL mapping design document.
• Each product segment. The project is focused on developing various details and summary Extensively Designed, Developed, Tested complex Informatica mappings and mapplets reports that will prove helpful for the sales and marketing teams. This application to load data from external flat files and other databases.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings.
• Extensively worked on the Repository Manager to create/modify/delete users/group/roles.
• Involved in running the loads to the data warehouse and data mart involving different environments.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, Transform and cleanse data, and Load it into data marts.
• Extensively used PL/SQL programming in backend and front - end functions, procedures, packages to implement business rules.
• Integrated various sources into the Staging area in Data warehouse and provide technical support to Quality Assurance team and Production group.
• Hands on experience in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze, standardize and cleanse the data.
• Strong knowledge in multidimensional analysis using Business objects XI.
• Fair amount of knowledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.

Environment: Informatica Power Center 8.1.1, Trillium, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, ERWIN 3.5,SQL Server, Unix Shell Scripting using AWK/ SED, HP-UX 10.20/NT, Windows Server 2008 and 2003, TODA, Linux, Business objects .

Confidential, CA

Sr. Informatica Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in Designing the specifications, Design Documents, Data modeling and design of data warehouse.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatic Power center.
• Created the repository manager, users, user groups and their access profiles.
• Created Logical & Physical models, used Erwin for Dimensional Data Modeling.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Extracted data using BTEQ scripting which includes Fast Export and Multi Load utilities
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as Mapplets using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
• Used parallel processing capabilities, Session - Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Worked on UDB/ DB2 on AIX, Tested the target data against source system tables by writing some QA Procedures.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution.

Environment: Informatica Power Center 7.1.3, Power Exchange, Test Director, Auto Sys, HP, UNIX, Windows 2000, Erwin, Oracle 9i/10g,, DB2, Erwin 4.0, SQL, PL/SQL, SQL * Loader, T SQL, TOAD, XML,Cognos 8.0.

Confidential, Santa Clara, CA

Informatica Consultant/Lead

Responsibilities:

• Reviewed data models, system and designed Extracting architecture, Applications design, requirements documentation and program specifications.
• Documented database models, designs, analysis, architectures and applications.
• Work closely with business areas to identify high value business issues.
• Created Informatica administration, database administration, application support, performance management, security management, problem resolution and operation procedures and infrastructure.
• Created Informatica repositories in different stages of project, which supports multi - language data (Unicode data) and created users, user groups and connections.
• Enabled the version control in DEV environment to determine the changes in the folders and copied them to TEST environment.
• Designed the mappings and sessions to extract Real-Time data from Teradata systems.
• Created Simulation mappings, sessions and workflows for processing error records while loading into informatica.
• Workflows have been scheduled dynamically according to the business usage by using UC4 scheduler.
• Written UNIX shell scripts to process the Real time extracted staging files for the load process
• Written and executed SQL Queries for Functional, Regression, Integration testing, User Acceptance Testing.
• Written SQL queries and stored procedures to check data integrity by logging test results in Mercury Quality center.
• Documented all the Transports moved, memory adjustments and connection strings created in different environments.

Environment: Informatica Power Center 7.1.3, Oracle, DB2, PeopleSoft, HP Quality Center, Erwin, UC4 Dynamic Scheduler, UNIX Shell Scripting, Sun Solaris server, Teradata, Windows 2000.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL mappings, transformations using Informatica power center.
• Implemented source and target definitions in workflow designer.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, Router, Filter, sequence generator, joiner, aggregate transformation and expression.
• Mappings were designed to cater the slowly changing dimensions.
• Used various stored procedures in the mappings.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Worked on the server manager to run several sessions and batches concurrently and sequentially.
• Mappings were designed to the utmost performance by optimizing expressions in expression editor of transformation, filtering source data at the source qualifier, and applying transformation logic.

Environment: Informatica power center 6.2, Oracle, Windows 2000, PL/SQL, STAR Schema, Flat files.

Confidential

Oracle Developer

Responsibilities:

• Involved in creation of Schema Objects like indexes views, and stored procedures. Involved in the Analysis of how the purchase order process is organized.
• Involved in a team in designing the Database Schema, for the metadata for storing the informative queries that are generated dynamically.
• Identifying integrity constraints for tables.
• Involved in writing the Triggers which internally calls procedures and functions.
• Involved in testing the database for the queries that are generated and handled the performance issues effectively.
• Involved in documenting the entire process.
• Involved in Implementation and Testing phases of the system.

Environment: Oracle 8i, SQL *Plus, windows98, MS SQL Server 2000, DB2.