SUMMARY:

• Thirteen years of IT Professional experience in ETL and QA with emphasis on Data Warehousing tools using industry accepted methodologies and procedures.
• Extensively worked on ETL and SQL for over 6 years using Informatica.
• Expertise in ETL methodologies, Informatica 6.x/7.x/8.x/9 - Power Center, Client tools - Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Expertise in Data Warehousing, Data Migration, Data Modeling, and Data Cleansing.
• Extensively worked on ETL and SQL for over 6 years using Informatica.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Experience in Performance Tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL Queries
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings and configuring the Informatica Server using Informatica Power Center.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Programming Knowledge of Java, J2EE, COBOL, C, XML, C++, VB, Oracle, and SQL Server.
• Experience in installing and Configuring software and Hardware in testing environment.

TECHNOLOGY SKILLS:

Software: TSL, SQA Basic, C, C++, VB, JAVA, SQL, COBOL, Java, J2EE, Servlets, VB Script, XML

Databases: ORACLE 8i, MS-SQL Server 7.0/2000, MS-Access, Sybase

ETL Tools: Informatica (Power Center 9.x, 8.x, 7.x) (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect, Power Exchange,B2B DTS 8.6/9.1), Informatica Cloud Services

DETAILED EXPERIENCE:

Confidential, MN

ETL Developer

Responsibilities:

• Involved in the Review of Requirements and development of Technical Design documents.
• Participated in impacted business meetings on weekly basis to get project requirements and update the status.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy
• Develop SQL DDL and DML statements
• Preparing ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from Development to Testing environment and then to production environment
• Developed mappings and sessions.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Creating and removing the users in Admin account.
• Startup and Shutdown the informatica servers.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Maintain traceability from requirements in order to design to test results
• Create test case, test Specification and test reports and execute test specs and document the results.
• Identify and resolved the performance issues in Extract SQL queries for quick data retrieval.
• Production support for installed mappings.
• Done Code reviews and validated the mappings.

Confidential, MI

ETL Developer

Responsibilities:

• Involved in the Review of Requirements and development of Technical Design documents.
• Participated in impacted business meetings on weekly basis to get project requirements and update the status.
• Co-ordinate with business team and DBA.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy
• Develop SQL DDL and DML statements
• Preparing ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from Development to Testing environment and then to production environment
• Developed Mapplets and Worklets for reusability.
• Developed mappings which load data mart data into Teradata.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Designed the inbound mappings to load data from HIPAA 5010 834 files into Database to healthcare industry standards.
• Created the outbound mappings to generate HIPAA 5010 834 files from the data in the data bases
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Validated the Flat files using XML transformations.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Maintain traceability from requirements in order to design to test results
• Create test case, test Specification and test reports and execute test specs and document the results.
• Identify and resolved the performance issues in Extract SQL queries for quick data retrieval.
• Production support for installed mappings.
• Done Code reviews and validated the mappings.

Environment: Informatica Power Center 9.5, Oracle 11, Toad and DB2 Flat files. Windows XP Professional.

Confidential, MN

ETL Developer

Responsibilities:

• Involved in the Review of Requirements and development of Technical Design documents.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy
• Develop SQL DDL and DML statements
• Preparing ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from Development to Testing environment and then to production environment
• Developed Mapplets and Worklets for reusability.
• Involved in upgrading Informatica 8.6 to Informatica 9 and worked on Informatica 9.
• Developed mappings which load data mart data into Teradata.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Created AutoSys schedules/jobs for automation of ETL load process.
• Validated the XML files using XML transformations.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Developed ETL mappings to load data into heterogeneous application of different databases.
• Analyzed Source system functionality Identifies and logs issues and perform regression testing.
• Maintain traceability from requirements in order to design to test results
• Incorporated the ETL logic in mappings to update different databases of DB2, Oracle and SQL server using flat files, DB2, Oracle and SQL server
• Create test case, test Specification and test reports and execute test specs and document the results.
• Identify and resolved the performance issues in Extract SQL queries for quick data retrieval.
• Production support for installed mappings.
• Done Code reviews and validated the mappings.
• Designed the schedule of workflow for Monthly loads.

Environment: Informatica Power Center 9.5, SQL, DB2, Oracle 11, MS SQL Server, Unix files, COBOL files, XML, Toad

Confidential, CO

ETL Developer

Responsibilities:

• Analysis of Client’s requirements.
• Preparation of Master reference Documents and Detailed Design Specifications from the Source Field Matrix provided.
• Identifying the complexity involved and preparation of Work Allocation Sheet.
• Identifying and scripting the DDL changes required.
• Creating mappings, reusable transformations, sessions, workflows as per design docs.
• Testing and debugging the mappings and analyzing the data for proper population of data.
• Involved in Data Modeling Using Erwin.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager, PMCMD and also using scheduling tools. Generated completion messages and status reports using Workflow manager.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Identifying the issues and resolving during UAT testing.
• Production environment set up for final promote.
• Performance tuning for the Informatica run time.

Environment: Informatica Powercenter9.1, SQL, DB2, TOAD for DB2 Flat files, Windows7

Confidential, MD

ETL Developer

Responsibilities:

• Extensive use of B2B Data Transformation for handling vendor data, where it is in EDI, Unstructured data and Complex structured data (XML Schemas).
• Extensively worked with structured and unstructured data.
• Worked with HIPAA 5010 for reduces risk and provides flexibility and complete bidirectional transaction crosswalk transactions.
• Involved in analysis, requirement gathering, and documenting functional and technical specifications.
• Involved in the preparation of the mapping document for 5010 by identifying the minor changes from 4010.
• Involved in the installation of B2B plug-ins in the machine.
• Designed the inbound mappings to load data from HIPAA 5010 834, 270, 271 and 271U files into Database to healthcare industry standards.
• Created the outbound mappings to generate HIPAA 5010 834, 271 and 270 files from the data in the data bases.
• Upgraded Informatica power center 8.1 to version 8.6 on servers.
• Hands-On experience in developing Transformations like Joiner, Aggregate, Expression, Lookup (connected and un connected), Filter, Union, Stored Procedures, Router, XML generator and parser, unstructured Data Transformation etc. using best practices.
• Configure the session so that power center server sends the e-mail when the session fails.
• Extensive use of flat files as sources and targets depending on the inbound and outbound processes.
• Deal with data files with lot of data (almost up to 6 million members in one file).
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.

Environment: Informatica Power Center 9.1/8.6, Data Transformation Studio, Oracle 10g, SQL Server 2005, TOAD.

Confidential, MN

Senior QA Analyst, Health Match

Responsibilities:

• Performed Manual & Automation testing on the Health Match application.
• Involved in the preparation of Test Plan and Test Matrix Requirements documents.
• Involved in the formulation of test strategies for quality assurance.
• Prepared and updated the Test Cases and Test Cases Execution Steps for all the Releases.
• Interacted with Business Analysts and developers to coordinate testing efforts.
• Tested the functionality Page Navigation objects and created Scripts for Regression Testing and used across the application.
• Performed front-end Integration Testing with back-end Oracle Database by passing SQL Queries.
• Used ClearQuest for bug reporting.
• Created QA reports, Bugs status, and attended weekly status meetings.
• Used SQL queries to check for successful transactions in Oracle database.
• Participated in all phases of the SDLC.

Environment: Oracle, Toad, Oracle SQL Developer, Documentum, Windows 2000. Rational Suite 2003 (Requisitepro, Test Manager, Robot, Clear Case, Clear Quest).

Confidential, MN

QA Lead, ECPR

Responsibilities:

• Reviewed and analyzed specifications: requirements, design, or functional specifications.
• Reported periodic project status and updates to the QA Lead, and QA Manager.
• Involved in Functional, Regression, Integration and UAT testing
• Automated Web Service test cases using Integra (Solstice)
• Defined new process for testing the functionality of the product housed on Mainframe
• Involved in coordination with the Development Team for changes in requirements.
• Validated the Soap Responses using Xml Spy.
• Tested with HOGAN Application Data.
• All the Web services are implemented by SOA (Service Oriented Architecture).
• Validated the Web Services both Requests and Response messages using Soap Scope.
• Involved in Peer Reviews and validating the test cases.
• Mentoring other team members in defining the process and execution of test cases.
• Involved in gathering Test data and design Test Metrics
• Reporting the defects to the Developers.
• Reported defects using Quality Center.
• Defects were tracked, reviewed, analyzed using Quality Center.

Environment: Mainframe (DB2), HOGAN, Java Beans, Java, Web Services, Web Sphere, JDBC, J2EE, XML, Mercury Quality Center 9.0, SOAP Scope, Xml Spy, Integra 5.3, Windows XP.

Confidential, MN

Software Tester/Analyst, Bankers Systems Inc

Responsibilities:

• Involved in testing Content Development product features.
• Reported periodic project status and updates to the QA Facilitator, and QA Manager.
• ICSTS is the automation tool developed internally for testing the product. This tool helps in converting the test cases into XML format and produces the results in PDF as a document.
• Involved in designing and developing Test Plans based on the functional specifications and user requirements.
• Helped to create manual and automated test assets (test scripts, test cases).
• Reviewed and analyzed specifications: requirements, design, or functional specifications.
• Involved in coordination with the Development Team and the Legal Team for changes in requirements (legal compliances).
• Developed XML test files based on XML schema.
• Generated XML data files using XML Spy.
• Validated the Web Services (SOAP), both Request and Response messages.
• Compared PDF’s with XML data that was passed with the help of Document Assembly Generator.
• Involved in Peer Reviews and validating the test cases.
• Reporting the defects to the QA Facilitator and ensure in fixing the defects.
• Reported defects through Service Requests and Test Director
• Mentoring other team members in defining the process and execution of test cases.
• Defects were tracked, reviewed, analyzed using SR Quick View.

Environment: XML Spy, Epic Editor, Oracle, SQL, Java Beans, Java, Web Services, Web Sphere, JDBC, J2EE, XML, Test Director, ICSTS conversion Tool, SOAP, Visual Source Safe, SR Quick View, Win Runner, Windows 2000/NT

Confidential, CT

QA Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Conducted testing of the system end-end manually.
• Managed the Requirements using Requirements Plan Manager (Test Director).
• Developed Test Cases and Test Design using Test Plan Manager (Test Director).
• Automated the functionality using QTP.
• Conducted Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) and Performance testing.
• Developed VB scripts, used various checkpoints and developed reusable functions using QTP.
• Created Traceability between Requirements and Test Cases.
• Conducted Load, Performance testing by creating VU scripts, Virtual Users and scenarios using LoadRunner.
• Worked with Unix Shell scripts to automate the tasks.
• Tracked the defects using Test Director and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review and GO-NOGO Meetings.
• Configuration management was done using PVCS.

Environment: QTP 8.0 (TestDirector 7.6, LoadRunner 7.5) Java, J2EE Technologies, Windows 2000, IBM Web sphere, SQL Server 2000

Confidential, IL

QA Tester

Responsibilities:

• Involved in writing test plans and developing test cases from Business Requirements.
• Responsible for doing System Testing, Functional Testing, Integration Testing, Load Testing and Smoke Testing.
• Testing is done both Manually and by using WinRunner.
• Developed automated test scripts using TSL defining scenarios and procedures to test the performance, security, recovery and reliability of the application.
• TSL Test scripts were synchronized and Bitmaps inserted for greater accuracy of testing.
• Using LoadRunner analyzed the response times of the business transactions under load.
• Developed Test logs and exceptions.
• JCL was used to schedule jobs.
• Automated IBM MainFrame applications Using QAHiperstation.
• Tested the online and batch programs.
• Developed Charts, Macros & Forms to submit the reports visually and automating repetitive tasks using EXCEL.
• Created Pivot tables using Excel to summarize and view data.
• Worked with SQL Queries in QMF to test the database integrity.
• Worked with DB2 and VSAM files to pull the test data.
• Involved in Processing of Claims, Claim Adjustments etc
• Developed reports and graphs to present the stress test result to management.
• Wrote SQL statements and UNIX Shell Scripts for backend testing.
• Used Test Director as error tracking system. Interacted with developers, users and various members from my team to discuss & resolve defects and their priorities.

Environment: COBOL, VSAM, MVS, JCL, DB2, CICS, PANVALET, SPUFI, QMF, OS/390, IBM Web sphere, Mercury Interactive Tools 7.0 (Test Director, WinRunner and LoadRunner), QAHiperstation, Java, J2EE, Java Script, XML, SQL, Windows 2000, File-Aid, MS-Word, MS-Excel, MS-Project.

Confidential, Chennai

Responsibilities:

• Worked as a QA Tester for PGRD development informatics and involved in testing various clinical projects.
• Maintained requirements in Test Director and requirements are traced to Test Cases in Test Director.
• Test Cases were designed based on Requirements and Use-Cases.
• Test Management and Test Case generation was done using Test Director.
• Conducted System Integration, Functional, GUI, Regression and UAT.
• Mentored users in use of Mercury tools.
• Automated the reusable functionality using WinRunner.
• Developed Traceability matrix between requirements and test cases.
• Maintained Test Logs and developed Test Summary Reports.
• Worked with SQL and PL/SQL to test database integrity
• Worked with PVCS for support in building the software.
• Tracked defects in Test Director and participated in defect review meetings.

Environment: WinRunner, Test Director, Load Runner, Java, JDBC, HTML, XML, Web logic, Web sphere, Oracle 8i, PVCS and Windows NT 4.0, Unix.

Confidential, Bangalore

Responsibilities:

• Sending mails to one or more users at one stroke.
• Checking of mail status like received status with details of date and time.
• Send attachments with mail.
• Password protection or mails (Send/Receive) at individual level.
• To receive mails those are addressed to the login user alone.
• Give Privileged rights to see other received mails for the secretariat personnel of the Group/Detail.
• Creation of Group by the privileged users, mailing lists and communicates list of all users.
• Provide communication within committees

Environment: Visual Basic5.0, FoxPro 2.6.