Summary:

• Around 7 years of IT experience in developing and designing of ETL methodology for supporting data transformations using Informatica Power Center 7.x/8.x/9.x
• Working Knowledge on different data sources as Flat Files, Cobol Files, Oracle, SQL Server, DB2 and XML
• Designed and developed complex mappings, from varied transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more
• Involved in all phases and complete life cycle of the Datawarehouse/ETL project i.e. Data modeling, Designing ETL strategies, Development, Testing, Validation of test ETL scripts, Implementation and Production Support
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions
• Having sound knowledge in OLAP Multi-Dimensional Data Modeling. Designing star- schema / snowflake schemas, Data Marts, Data Mining, Data quality Analysis, Data Integration and Slowly Changing Dimensions SCD
• Extensively worked on transformations, creation of Worklets, Mapplets, reusable transformations, usage of parameter files, edit rules and validation of business rules
• Experience in automating of the ETL processes for migration
• Experience in Relational Database concepts
• Multi Environment working experience UNIX, Windows
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure

Technical Skils:

• ETL: Informatica PowerCenter 9.x/8.x/7.x, Sagent Data Flow 5.5.1
• Tools: SQL PLUS, PL/SQL Developer, TOAD, WinSQL, Control-M Scheduler, Cybermation Workload Automation, PuTTy, MS Office
• Languages: SQL, PL/SQL, C, XML, HTML

Databases:

Oracle 9i/10g/11g, MS SQL Server 2000/2005, MS Access Operating Systems: Windows 7/Vista/XP/2003/2000/NT,UNIX

Professional Experience:

Confidential

ETL Developer

Confidential is a premier and diversified health benefits and Information Company that provides innovative products, services, and technologies to improve the availability, quality, and cost of health care.

Public Exchange Edge Server

This main goal of the Edge Server project is to send the Member records, Pharmacy Claims and Medical Claims of all active enrollees to Center for Medicare and Medicaid Services CMS in XML format

Responsibilities:

Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications Prepared ETL design specification documents with information on implementation of business logic Worked with Target XSD's in order to generate the output XML files Extracted data from DB2 source tables, loaded them in SQL Server Intermediate Data Store tables for Auditing purposes before loading them to XML target files Extensively used transformations like Joiner, Expression, Connected/Unconnected lookups, and Filter, Aggregator, Rank, Update, Router and Sequence generator Generated Informatica parameters and variables effectively through scripts for developing mappings Responsible for developing Mapplets to implement the reusable logic Maintained and modified mappings as per changing reporting requirements Prepared Unit test case document and System Test case document Responsible for designing, developing and implementing the incremental load strategy, full load and disaster recovery Involved in the code migration from Development to UAT and Production Scheduled the jobs using Cybermation Workload Automation tool Involved in FTP of data from Target path to Edge Server location Responsible for troubleshooting the informatica tasks and performance related issues and data issues using the session logs and debugger

Environment: Informatica Power Center 9.5.1, DB2, SQL Server, XML, WinSQL, UNIX, Cybermation Workload Automation, PuTTy 0.58, Windows XP/7

Confidential

ETL Developer

Confidential is a diversified metal manufacturing company. It has three primary business units steel processing, metal framing and pressure cylinders and several joint ventures.

Automated Steel Position The overall scope of this project is to minimize risk by streamlining the existing process for compiling and maintaining the Worthington Industries Steel Position. This will include reducing manual calculations, consolidating existing reports, and identifying/correcting business processes that lead to manual position modification. This will be executed by developing reports in Cognos using extracted Oracle data to summarize daily steel position information

Responsibilities:

Worked with the customers and business analysts for requirements gathering Developed the detailed design document of the required data warehouse system Designed and developed Informatica mappings to extract data from Oracle source system to staging and from staging to target Used Parameter files to manage the relational connection in different environments Developed the test cases with the client for his business requirements Performed Unit test and Integration test for the process created in Informatica and all the test cases were well documented for process improvements Monitored the database usage and the ETL mappings so as to complete and refresh the datawarehouse within the time frame Implemented Informatica best tuning techniques to increase the performance of the process

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL Developer, TOAD, UNIX, PuTTy 0.58, Windows XP

Dedicated Fleet optimization

This project is to create a process using Informatica to send information related to freight to IBM Ilog Transportation Analyst system for historical performance review and forward-looking routing. The current process to manage the fleet is manual and traditionally based on limiting empty miles and increasing turns per day, neither of which accounts for route optimization or common carrier comparison.

Responsibilities:

Involved In Design Specifications and Technical Sessions Involved in documentation and presentation of the methodology to the client Created Informatica ETL mappings that transfer data from Oracle to flat file targets Developed complex mapping logic using various transformations like Expression, Lookups, Joiner, Filter, Sorter, Router Created re-useable sessions, worklets, workflows for the mapping to run based on the business requirements Used Parameter files to manage the relational connection in different environments. Tuned SQL Queries in Source qualifier Transformation for better performance Created UNIX shell scripts for scheduling and file processing Responsible for Migrating the Informatica mappings form lower environment Development to higher environment. Involved in Unit and Integration testing in lower/higher environments. Also responsible for post validation and provide validation scripts. Prepared data validation documents.

Environment: Informatica Power Center 9.1, Oracle 11g, PL/SQL Developer, TOAD, UNIX, PuTTy 0.58, Windows XP

Confidential

ETL Developer Confidential

is a leading global financial services firm with operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small-business and commercial banking, financial transaction processing, asset management and private equity DOJ Settlement - SCRA Rider This initiative supports the requirements of the agreement with the United States Department of Justice in exchange for a full release of the United States Attorney General's potential claims prior to the date of the agreement related to violations of the SCRA as it pertains specifically to foreclosure and interest rate provisions.

Responsibilities:

Created Technical design document based on business requirement Analyzed the data to be able to identify the data quality issues and validated test cases Prepared ETL standards, naming conventions and wrote ETL flow documentation Created Informatica ETL mappings that transfer data from COBOL source systems to Oracle Database. Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter Used Parameter files to define values for parameters and variables used in a mappings Used workflow manager to create workflows, sessions, and also used various tasks like command task Prepared unit test cases to meet the business requirements and performed unit testing of mappings. Provided SQL scripts to validate source to target validations Migrated the code from Development Testing UAT Production Efficient Documentation was done for all phases like Analysis, design, development, and testing

Environment: Informatica Power Center 9.0, Oracle 11g, COBOL, PL/SQL Developer, TOAD, UNIX, PuTTy 0.58, Windows XP

ICTL Replacement Project

This project is to retire the use of ICTL and transition all current data to another system which would offer better avenues and access to information contained within. An Informatica process was developed to transfer CReST data Chase Records and Storage System , required by the Report Automation team to be loaded into Info One CReST schema and available to use for report creation.

Responsibilities:

Interacted with the business in business analysis and technical design sessions with business to develop requirements document and ETL specifications Created Functional document and Technical design document based on business requirement Involved in presentation of the methodology to the client Analyzed the data to be able to identify the data quality issues and validated test cases Analyzed the requirements to identify the necessary tables that need to be populated into the staging area, prepared ETL standards, naming conventions and wrote ETL flow documentation Extracted the data from flat files into Oracle database. SFTP process was developed to access the data from source system Used update strategy transformation to effectively migrate data from source to target. Created mappings using transformations like Source Qualifier, Expression, Lookup, Filter, Update Strategy, Joiner Used workflow manager to create workflows, sessions, and also used various tasks like command tasks Create workflows based on dependencies in Informatica for the code changes. Coordinated with system operators to schedule batch jobs in Control-M scheduler. Unit test the Data Mappings and Workflows and validate the data loaded into database.

Environment: Informatica Power Center 9.0, Oracle 11g, SFTP, PL/SQL Developer, TOAD, UNIX, Control-M Scheduler, PuTTy 0.58, Windows XP

Confidential

Informatica Developer

Due to recent organizational changes, Motorola Networks business had been brought by Nokia Siemens Networks NSN which subsequently requires its associated applications to be replicated on NSN infrastructure. This project deals with new infrastructure creation for Enterprise Datawarehouse applications in NSN environment. These Datawarehouse applications will be retained by NSN for Networks business users.

Responsibilities:

Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications Analyzed the impact of changes on the existing systems Analyzed the data to be able to identify the data quality issues and validated test cases Prepared ETL standards, naming conventions and wrote ETL flow documentation Analyzed the requirements to identify the necessary tables that need to be populated into the staging area Importing source and target tables from their respective databases Created mappings using transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Union and Normalizer Used Parameter files to define values for parameters and variables used in a mappings Used workflow manager to create workflows, sessions, and also used various tasks like command Involved in Performance tuning at various levels including Target, Source, and Mapping. Prepared unit test cases to meet the business requirements and performed unit testing of mappings. Provided SQL scripts to validate source to target validations Seamlessly migrated the code from Development Testing UAT Production Worked on Informatica Debugger to identify root cause and do data fix. Also provided recovery plan for data loss Perform ETL Administrator jobs like maintaining Folder/User level Privileges, Scheduling Jobs based on target system dependencies Worked on on-shore off-shore model being the only Datawarehouse developer on-shore Provided knowledge transfer and technical support in the production environment and hands-on mentoring in the use of Informatica. Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance Responsible for the assignment of tasks for the team members, communicating with the clients for creation of Metrics reports, weekly status reports, preparation of project plan and quality related documents migration documents etc

Environment: Informatica PowerCenter 8.6/9.1, Oracle 11g, PL/SQL Developer, UNIX, CITRIX, Compass, PuTTy 0.58, Windows XP

Confidential

ETL Developer

Confidential is a member of Ascension Health, is a group of affiliated medical campuses, outpatient centers, primary care locations and ancillary health care organizations with a mission and history of improving our community's health for over 80 years. The main goal of this project is to support multiple requests from over 40 clinical and financial systems that come in for data to be analyzed, as well as managing the flow of data. Data is extracted from different database systems SQL Server, Oracle and different file formats such as flat file, XML, transformed and loaded into the target database.

Responsibilities:

• Interacting with customers to define business needs and translating them to system requirements Using PowerCenter Designer to design various plans to extract the data from SQL Server and Oracle Assist the ETL architect on the design of star schema, fact and dimension tables required for OLAP and reports in conjunction with ETL team Moved projects from development to production servers Managing requirements and reports that are requested from customers Writing scripts, functions and stored procedures using SQL or Oracle PL/SQL. Enhanced existing data model to respond to requirements set forth by the client. Modeled data and developed reporting on SQL Server database Develop SQL queries as needed against development and production databases for quick-response ad hoc reporting Migrated plans and tasks between repositories
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once using Workflow Manager

Taking daily online Backups, weekly off-line Backups and frequent exports Troubleshooting and performance tuning which reduced several jobs from several hours to less than one Create functional and technical documentation for all reports, outlining processes to create an easily readable roadmap of all procedures for end users Create Oracle functions and stored procedures to supply comma-delimited lists and date information Performed unit testing at various levels of the ETL.

Environment: Informatica PowerCenter 8.6, Sagent Design Studio 5.5.1, SQL Server 2000, Oracle 10g, Windows XP

Confidential

Informatica Developer

Confidential is an international group of quality supermarkets based in the United States and Europe. Stop Shop is one of its food retailing brands in the Northeast United States. The company operates superstores some of which include gas stations, full-service pharmacies and conventional supermarkets. Main goal of the project was to replace an obsolete legacy system which delivered a limited view of some of the many different business units to decision-makers across the company with Oracle DB. This was done using Agile Methodology.

Responsibilities:

Involved In Design Specifications and Technical Sessions Involved in documentation and presentation of the methodology to the client Worked with Informatica Power Center tools - Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplets and Transformations to define source and target definitions and to create mappings between them Primarily involved in the loading of Orders and Sales data marts. Created Informatica ETL mappings that transfer data from Oracle and flat file source systems to the SQL Server Data Mart. Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations. Used various tasks like Sessions, commands, Decisions, Timer, Control, Email, Event wait and Event Raise to arrange the tasks in the order and to satisfy business criteria Designed reusable components such as transformation, Mapplets, lookups and reusable objects sources and targets for ETL process Created and Monitored Workflows using Workflow Manager and Workflow Monitor Used Debugger and breakpoints to view and edit transformations output and debug mappings Developed mapping to load data in slowly changing dimensions Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well Responsible for migrating mappings/workflows from Development to Test and Test to Integration environments. Perform the Informatica deployment Export / Import multiple objects, copy folder, copy deployment group from development to production repository using the Informatica repository Manager Done extensive testing and wrote queries in SQL to ensure the loading of the data. Performed unit testing at various levels of the ETL.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL Server, PL/SQL, SQL PLUS, Windows XP

Confidential

Informatica Developer

Confidential project was driven by the goal of providing coordinated and targeted marketing messages to customers across touch points. For this Nextel deployed Oracle's Real-Time Decisions RTD product to manage the decision process for marketing messages. The project structured to house Person and Activity data elements in specifically designed tables.

Responsibilities:

Attended Subject Matter Experts SME meetings for requirements gathering, created analysis/functional specifications. Performed the requirement. Designing and customizing data models for Data warehouse supporting data from multiple sources. Involved in performance tuning of SQL Queries, Sources, Targets and sessions. Prepared ETL design specification documents for developers with information on implementation of business logic. Specified job flow and allocated task and assisted the team. Worked Extensively with Expression, Lookup, Joiner, Sorter, Aggregator, Update Strategy, Stored Procedure, and Sequence Generator, Filter, Rank and Router transformations. Designed reusable components such as transformation, Mapplets, lookups etc and reusable objects sources and targets shared folder for ETL process. Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads. Designed and executed Error and Exception handling processes and used Informatica Debugger for session failures. Extensively worked on Informatica tools like Designer, Workflow Manager, Repository manager and Power Analyzer. Created complex mappings and also tuned for better performance. Developed UNIX Shell scripts to implement the ETL load and integration management process.

Environment: Informatica 8.6, Oracle 8i 9i, MS SQL server2000, PL/SQL, Erwin, SQL Loader, Windows NT, UNIX and SQL PLUS

Confidential

Informatica Developer

This System is developed to maintain an Integrated Sale / Inventory Management System for Bharath Imports Inc. for consolidated online sales and inventory management. Primary goal of the project is to extract data from different data base systems such as Oracle and also from different file formats such as flat file, XML and transforming the data, loading the transformed data into target Data Mart for data warehouse operations.

Responsibilities:

Designed Informatica process and involved in mapping development to load data from different ERP Sources like Flat File, Relational database into the target Oracle relational database. Data is migrated by applying business logic using transformations in mapping for deleting and inserting records. Designed data transformation from Transient to Staging Fact and Dimension Tables to Warehouse Involved in the design of ER diagrams, logical model relationship, cardinality, attributes and, candidate keys and physical database capacity planning, object creation and aggregation strategies as per business requirements. Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer. Extensively used Transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator. Used workflow manager and workflow monitor extensively to create tasks, worklets, workflows and execute the tasks and monitor the workflows Developed reusable Mapplets, Transformations, Sessions and Parameterized Database connections ,Session logs, Reject files logs Implemented Error Handling Strategies. Writing PL/SQL Stored procedures for processing business logic in the database. Tuning of SQL queries for better performance. Involved in Unit Testing and preparation of the test cases.

Environment: Informatica Power Center 7.1, Oracle 9i/10i, Windows 2000