SUMMARY

• Over 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Worked with IT Operations to ensure test environment readiness.
• 7+ years of experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Data Stage and Ab Initio on multiple platforms.
• 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.
• Experience in Data migration and Data distribution testing.
• Proficient experience with SQL Server and MSBI tools like SSIS, SSAS, and SSRS.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experience in Software Development Life Cycle (SDLC) using the Waterfall Model and good understanding of Agile Methodology.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in co-coordinating resources within Onsite-Offshore model
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• SAS Eminer trained in Applied Analytics and Data Preparation. Supported user community needs for SAS administration in absence of a formal SAS administrator.
• Have knowledge on the web services.
• Experience working with HP ALM, Element Tool, Team Track.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Experience with Agile, waterfall Methodologies.
• Experience in automation testing utilizing QTP, Load Runner, Win Runner and Rational Suite
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in testing HIPAA, 837/997, 835, 270/271, 276/277 EDI Transactions..
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Business Objects and Cognos
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on clearly communicating & documenting detailed Test Requirements & Tests.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS

ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.

Data modeling tools: Erwin, MS Visio

OLAP Tools: Business Objects XI r2/6.x/5.x, Cognos 8.0/8.1/8.2/8.4/7.0/

Languages: SQL, PL/SQL, UNIX, Shell scripts, VB Script, C++

Scheduling Tools: Autosys, Control-M

Testing Tools: QTP, WinRunner, LoadRunner, Quality Center, Test Director

PROFESSIONAL SUMMARY:

Confidential, Phoenix, AZ

Sr. ETL/DWH/QA Tester

Responsibilities:

• Validated the data on the application against the source system Teradata.
• Determine level of testing required to validate new or revised system capabilities.
• Based on the design specification and business requirements developed the scope of the testing.
• Developed Test Plans and developed various test scenarios and test cases with input from assigned Business Analyst and data architect.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing
• Report accurate testing status and test summary reports.
• Continuously improve test models, Test data and Test processes based on lessons learned.
• Extensive experience in Functional, system, Integration, Regression Testing, User Acceptance Testing.
• Reconciled test results from different tests and different group’s accesses readiness and deviation of product/project performance based upon test results and product specifications.
• Responsible for the management, design, and continuous development of the Data Migration.
• Conducted Data Migration and Data Cleansing.
• Worked on different versions of Business Objects 4.1/5.1.5 /6.0 /6.1b /6.5/XI R1/XI R2
• Created and maintained the business complex reports using the Business Objects Reporting Module as per user requirements.
• Created Business Objects reports customizing for the user browser environment and scheduled documents using Info View.
• Conducted HIPAA Gateway Testing.
• Tested Subscribers/Providers and claims in Facets.
• Tested the Membership and claims files (XML) in Facets.
• Transactions focused on were 270,271,276,278,834, 835, and 837.
• Validated the reports and files according to HIPAA X12 enforced standards.
• Loaded the data into the Teradata database using Load utilities like (Fast Load, and Multi Load).
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Performed Black System testing, Regression and end-end testing.
• Customized the QTP Test as per the Test Case by using the VB-Script.
• Involved in Descriptive programming using VB Script.
• Developed detailed Test Plans and Test Cases in Quality center and executed them
• Reported bugs and tracked defects using Mercury Quality Center 9.2/10.0.
• Maintained the Traceability Matrix between Project release, Requirements, Design Components, Test Cases and Defects.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Performed Load Testing using SOAPUI Test Suite
• Worked with SOAPUI for testing Web Services Analyzed current claims data model tables and relationships and wrote queries to understand the data related to Claims processing
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote, prepared and executed Manual Test Cases based on Requirements and Use Cases, and Automated Test Scripts throughout Software Development Life Cycle (SDLC).
• Involved in creating manual Test cases.
• Tested the Oracle PL/SQL testing programs.
• Involved in automation of test cases using QTP.
• Worked on the batch testing using the Test batch runner tool.
• Validated the data in the reports and dashboards using SQL queries against the database.
• Worked with the development team in testing the Automation, Implementation, blackout, backup and recovery plans.
• Participate in weekly meeting with the management team and walkthroughs

Environment: Informatica 9.1, Business Objects XI r2/6.5, SQL, PL/SQL, Teradata SQL Assistant 13.0 HP ALM 11.0, SQL Server 2008, Quality Center 9.2/10, EDI 837, HIPPA 5010, SOA, SOAP UI, Shell Scripting, VB Script, XML, HTML, UNIX, Windows XP.

Confidential, Pittsburg, PA

ETL/QA Tester

Responsibilities:

• Created Tables, Custom views and Materialized Viewsused specifically for the application.
• Worked on Performance tuning to ensure reports and reporting environments are optimized to the fullest extent.
• Wrote and modified Oracle PL/SQL procedures and functions that are called in the Java Scripts.
• Created database objects like stored procedures, function, packages, Cursor and Ref Cursors.
• Performed Unit Testing and Prepared Application for Release to Testing Team. Analyzed defects found in testing and fixed Coding errors.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Excellent experience on SQL tuning.
• Prepared test environment for QA team to test the developed application from end-end.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan and Test strategy from the Business Requirements and Functional Specification for the integrations.
• Developed Test Cases for Deployment Verification, ETL Data Validation, and application testing.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Developed processes for data synchronization and data migration.
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Tested ad hoc and canned reports for Business objects.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor
• Followed waterfall and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Functioned as the Onsite / Offshore coordinator for a team.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Involved in extensive DATA validation using SQL queries and backend testing.
• Created custom views to improve performance of the PL/SQL procedures.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Extensively used VB Script for customizing the Automated Test Script.
• Created test scripts using VB Script and by Creating Checkpoints, Synchronization points and Output values. Enhanced the test scripts if necessary.
• Creating customized HP QC/ALM Excel reports (Macros & SQL) for test plan, test execution & Defects.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• SQL Navigator is used to perform manual test in regular basis. Oracle is used in this project to write SQL queries.
• Wrote complex SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Creation of detailed test cases by understanding the user requirements for manual testing.
• Writing the test scripts for manual testing.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center8.6, Business Objects XI r2/5.1, PL/SQL Procedures, SQL, SQL Navigator 6.6, Toad 9.6.1, Oracle 10g, HP Quality Center 10, HP ALM, SOA, SOAP UI, UNIX, VB Script, Java based web application, XML, HTML, MS Excel, MS PowerPoint, Microsoft Share Point, Windows NT/XP//2003

Confidential, Kansas City, MO

ETL /QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports
• Involved in testing the Business Objects performance & connectivity across different domains.
• Written several UNIX scripts for invoking data reconciliation.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Extensively used Informatica power center for extraction, transformation and loading process.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Strong exposure to the Software Development Life Cycle (SDLC) and extensive experience with QA testing methodologies and procedures.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Involved with ETL test data creation for all the ETL mapping rules.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Tested stored procedures & views in MS SQL 2000/2005.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.1, PL/SQL, SQL, SQL Server Analytical Server, Quality Center, SQL Server Reporting Server, TOAD 9.2, Oracle SQL developer, Oracle 9.2, HP Quality Centre 9.2, DB Artisan 8.5.2, Autosys, Metal (Meta Data Driven ETL), SOA, SOAP UI, BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//2003.

Confidential - Chicago, IL

ETL/QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attending Client calls for Business understanding and Clarifications.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Written several shell scripts using UNIX Korn shell for file transfers and cleanup process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Executed test cases manually in Rational Test Manager and identified the mismatches and logged defects through Test director.
• Developed TSL scripts and GUI maps for all the test cases to be tested manually and automation using WinRunner for functionality, integration and regression testing.
• Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Full Life Cycle Testing (SDLC) and development of both claim submission and remittance retrievals.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Tested several data migration application for security, data protection and data corruption during transfer
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Involved in creating source target mappings based on the Technical Design requirements.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created different user defined functions for applying appropriate business rules

Environment: Informatica, Quality Center 7.1, SQL, PL/SQL, Business Objects XIR2, EME, Mainframe Flat Files, ITG, Service center, UNIX, Oracle 10G, DB2, TOAD.