SUMMARY

• Over Eight years of diversified experience in the field of Information Technology with an emphasis on Data warehousing tools using industry accepted methodologies and procedures.
• Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries.
• Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 8.x/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Analyzed and designed the database. Involved in database normalization process.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources
• Experience in integration of various data sources like Oracle, SQL server and MS access and non-relational sources like flat files into staging area.
• Extensively worked with SQL loader for bulk loading into the oracle database.
• Strong inData warehousing concepts,dimensionalStar SchemaandSnowflake Schemamethodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience with SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Highly adept at creation, execution, testing and debugging ofInformatica mappings, mapplets, sessions, tasks, workletsandworkflowsinUNIXandWindowsenvironment.
• Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Extensively used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.

TECHNICAL EXPERIENCE

ETL Tools: Informatica PowerCenter/PowerMart 8.x/7.x, Power Exchange 8.x
Business Intelligence: Business Objects 6.5/5.1.7
Databases: Oracle 10g/9i/8i, SQL Server, Greenplum 4.0/4.1
MS SQL Server 2000/2005/2008
Languages: UNIX, Shell scripting, SQL, PL/SQL, C
Web Technologies: HTML, DHTML, Joomla 1.6
Design: ERWin Platinum 4.0/3.5
Tools: MS Office Suite 2003, TOAD, SQL Plus, SQL Developer, Autosys r11.x,
PGAdmin III, SQL Developer Data Modeler
Operating Systems: UNIX, Windows 9x/2000/XP/VISTA, DOS

PROFESSIONAL EXPERIENCE

Confidential,Milwaukee Wi April’12 – Till Date
ETL Developer
Project: Actimize SAM

Confidential,N.A., a subsidiary of Associated Banc-Corp, one of the top 50 bank/financial services holding companies operating in the U.S. It operates in approximately 270 banking offices in more than 150 communities throughout Wisconsin, Illinois and Minnesota. The project involves replace its existing transaction monitoring system with the Actimize Suspicious Activity Monitoring (SAM) system. Working on Actimize SAM which requires data to be loaded on a nightly basis through a series of staging tables that contain all changes to customer, account and loan-specific data from the business day, as well as a load of all new transactions that were posted that day.

Responsibilities:

• Work with project managers, business solution analysts, DBA’s to achieve business and functional requirements.
• Developed PL/SQL Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Design and development of CDC process using time-stamping method and Implemented SCD methodology including Type 2 to keep track of historical data.
• Using complexSQLtoquery the database and involved inSQLoptimization of existing queries.
• Extensively involved in writingOraclePL/SQLStored Procedures/Functions and to create the necessary indexes and work tables for performing the ETL process.
• Developed Stored Procedures using iterative processing with loop, CASE statement process flow, exception handling, records, collection, DML operations, data retrieval using cursor /ref cursor and BULK COLLECT / FORALL, collections, database triggers etc.
• Involved in performance improvement for the transaction load process and optimized the existing SQL queries for performance improvement. Apart form that used the analytical functions, collection, BULK Collect /FORALL and other method to enhance the performance.
• Performing code migrations as part of weekly/Monthly Change request releases.
• Troubleshooted, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Develop high level and detailed level technical and functional documents consisting of Detailed Design Documentation function test specification with use cases and unit test documents.

Environment: Oracle 11g, PL/SQL, SQL Developer, SQL Data Modeler, Windows Server 2008
Confidential,Plano, TX Feb ’11 – April ‘12
Sr. ETL Developer
Project: IRIS
Confidential, is a leading provider of communications infrastructure, services and multimedia solutions. This project is designed to performing scale up of the existing CS 3.0 and dividing the existing data warehouse into primary business categories. The primary part involves loading the data from legacy system to new data warehouse which is Greenplum. The data warehouse server the purpose of reporting, backup and archive and serving API’s. Apart from these the project also involves uplifting and modifying existing reports, modules and programs to the new data warehouse.

Responsibilities:

• Designing, Implement and delivering data warehouse ETL and reporting applications.
• Worked with project managers, design lead and solution architect to achieve business and functional requirements.
• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Review existing systems to determine compatibility with projected and select appropriate systems, including ensuring forward compatibility of existing systems
• Database development and ETL process in Oracle l0g and Greenplum using PSQL, SQL, PERL and UNIX scripting.
• Design/implement queries to extract specific data from legacy system to new data warehouse.
• Worked on the Performance tuning of the programs, ETL Procedures and processes.
• Worked in debugging using Log messages, Server Messages.
• Establish controls to ensure the accuracy and consistency of data.
• Supporting, correcting and following up trouble reports Skills.
• Preparation of the various technical and functional documents consisting of Detailed Design Documentation, function test specification with use cases.
• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Cooperating with stakeholders at handover, system verification, and operations on a need basis.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Oracle 11g, PSQL, PERL, Unix, SQL, SQL Developer, SQL Data Modeler, Sun Solaris, VM Ware, Greenplum 4.0/4.1, SQL Developer Data Modeler, PGAdmin III

Confidential,Providence, RI Sep ’09 – Jan ‘11 Sr. Informatica Designer/Developer
Project: Credit Card System

Description: Confidential,is a brand name of Royal Bank of Scotland (RBS) Citizens, N.A. and Citizens Bank of Pennsylvania. Citizens bank operates over 1,500 branches, more than 3,500 ATMs. The Credit card system project is designed to handle balance transfers and credit limit increase programs from various sources like internet, telephone, mail and also third party vendor files. This project involved extracting data from different sources and loading into Data Mart. The Data Mart is an integrated Data Mine that provides feed for extensive reporting. It enables an insight into the financial situation/needs, scope for delivering superior customer service through a banking operation that is cost-effective.

Responsibilities:

• Analyzed, conceptualized/designed the database that serves the purpose of proving critical business metrics.
• Assisted in the design and Maintenance of the Metadata environment.
• Worked with project managers, business analysts, SME and technical advisor to achieve business and functional requirements.
• Gathered business and technical requirements from both formal and informal sessions through NetMeeting, questionnaire, video conferencing and conference calls.
• Developed high level and detailed level technical documents to define the system components, development environment and implementation planning/strategies.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Experience in Creation of ETL mappings using Informatica PowerCenter to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Created Sessions and Workflows to load data from the SQL Server, Oracle, flat file, and XML file sources that exist on servers located at various locations all over the country.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.

Environment: Informatica PowerCenter 8.6, Autosys r11.3, Oracle 10g, SQL Server 2008, PL/SQL, Erwin, TOAD, SQL*Plus, XML, Windows Server 2008.

Confidential,NYC, NY Sep ‘08 - Aug ‘09

Project: Financial Investment Management

Description: Confidential,one of the largest diversifiedfinancial servicesfirm. The project FIM(Financial Investment Management) aimed to specialized investment management and basically focuses on distinct asset types and strategies, and also in Investment management strategies. Project aimed to monitor performance of resources available, project status, client information. In this process we are involved with maintaining data marts related Resource, Projects and clients according to company’s standard definition and business rules. Informatica was used to load source data to the data marts form staging. It enables an insight in to the current and future investment strategy and helps in making business decisions based on the reports generated from data warehouse.

• Analysis of source systems and work with business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Developed custom data transformation (structured/unstructured data) process using Item field content master data transformation tool.
• Worked on Informatica PowerCenter tool – Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Developed PL/SQL stored procedures for Informatica mappings.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for management reporting.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Providing technical support and troubleshooting issues for business users.
• Actively Participated in problem solving and troubleshooting for the applications implemented with Informatica.
• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

Environment: Informatica PowerCenter 8.1.1, Power Exchange 8.1, Erwin 4.1, EDI, Autosys r11.0 oracle 9i, PL/SQL, SQL,, XML, SQL Server 2005, Windows 2003, Unix.

Confidential,Plano, TX Dec ‘07 – Jun ‘08
ETL/Informatica Developer
Project: Accident & Health

Description: Confidential,over 3.7 million policyholders, offering a variety oflife, health, accident and dentalinsurance plans The Accident and Health Division (A&H) is a part of the Foreign General Group of SLIC. The main objective of this project to automate claim intake, financials, diary/notes/billing, and litigation, and allows claims to be electronically referred to other business units such as AI Recovery, Investigative Services Division (ISD), Fraud Investigations Division (FID) and CSD (Claims System Department) in multiple databases across the country.

Responsibilities:

• 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 Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Extracted data from different sources like SQL server 2005, flat files and loaded into oracle DWH.
• 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.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Responsible for writing SQL queries, stored procedures, views, triggers.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Created test cases and completed unit, integration and system tests for Data warehouse.

Environment: Informatica PowerCenter 8.1.1, oracle, Flat files, SQL server 2005, SQL, PL/SQL, Windows 2003.

Confidential,Pennington, NJ Dec ’06 – Nov’07
InformaticaDeveloper
Project: Trade Cycle Management System (TMS)
Confidential,assets allocation strategies offer globally diversified portfolios of investments. Its provide manager-of-managers, selecting style-specific investment management as sub-advisors to manage these investment portfolios. Monitoring the performance of our managers, we hold them accountable for both investment style continuity and performance. Design and develop sales commission Tracking and Analysis Management System (TMS) for Merrill Lynch. The system provides current and historical sales and commission performance information for management. Help in Developing business requirements, processing specifications, database design and overall project plan. The main aim of project is to developed DSS system (TMS) from production systems for invested money into specific securities, funds of portfolio to manage investment management Strategies and to maintain the historical data.

Responsibilities

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Validates the data according to the user end.
• Re-org the tables and rebuild the indexes in a data base for high performance.
• Used unconnected lookup for populating date-time entered field in the target tables.
• Developed mapplets, mappings and configured sessions.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Work Flow Manager.
• Extracted data stored in different databases such as Oracle, SQL Server 2005, DB2 UDB to load finally into a single Data Warehouse repository, which is in Oracle.
• Worked closely with reporting team and generated reports using Business Objects 6.2.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing.

Environment: Informatica Power Center 7.1.1, DB2 UDB, Oracle 8i, SQL Server 2005, SQL, PL/SQL, Erwin, SQL*Loader, UNIX Shell Script, Business Objects 6.2

Confidential,Bangalore, India Oct ’05 - Nov ‘06
ETL Developer
Project: CIS

Description: Confidential,a global IT services company and delivers end-to-end IT solutions and services worldwide. The Objective of project CIS (Customer Information System) is to create a Data mart for the analysis of sales information of a client company. The client company manufactures many electrical products in Honk Kong. This Project involved designing and creating a Data mart to fulfill their business study and analysis requirement.
Responsibilities:

• Developed mappings in Informatica Power Center 6.1 that catered to the Extraction, Transformation, and Loading from various source systems to target systems.
• Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.
• Used Informatica Power Center 6.1 for mapping and workflow design including the use of maplets, reusable transformations and worklets.
• Extensively used workflow manager to create tasks and workflows.
• Used PL/SQL with Informatica Power Center 6.1 for Oracle 8i database.
• Developed mapping using Informatica Power Center Designer to bulk load data from Oracle and Flat file source system to target database.
• Used Informatica tool to handle complex mappings and extensively used various Transformations including Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter.
• Developed, implemented and enforced ETL best practices standards.
• Informatica Power Center 6.1, Flat files, Oracle 8i, BO 5, Windows 2000

Confidential,Surat, India Feb ‘04 – Sep ‘05
Database Analyst

Description: Confidential,provides consulting and IT services to clients globally.The project was designed to look through the company’s entire customer database for every region and to separate them based on the customer details and their business profiles.

Responsibilities:

• Performed migration of data from one application to another.
• Managed data conversion activity.
• Developed extract reports and MS Access programming to transform data into required upload format.
• Validated completeness and accuracy of converted data.
• Created and extracted reports from existing database.
• Developed MS Access Queries Programs to convert data.
• Analyzed data, validated against business rules.
• Developed tables, reports and programs on short notice, for data migration.
• Some exposure to Business Objects reporting tools and Crystal Reports.

Environment: MS Access 97, Oracle 8i, BO, Crystal Reports