SUMMARY

• Around 8+ years of professional experience in Software Testing as Software Quality Assurance Engineer on different platforms and environments
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Extensive experience of manual and automated testing of application and use of HP Quality Center, HP Quick Test Pro, Test Director.
• High understanding on the various instruments like Bonds, Swaps, Asserts, commodities, derivatives.
• Responsible for Regression Testing of products using Quick Test Professional (QTP), for every new release to validate that the new enhancements have not caused any issues when compared to existing functionality.
• Performed Siebel Functional Testing, Backend Testing, Integration Testing, Regression Testing and UAT (User Acceptance Testing).
• Expertise in working in Agile (Scrum), Waterfall, Spiral methodologies
• Excellent knowledge on Agile Methodology.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Involved in developing various test plans and test cases for different versions and applications using Quality Center.
• Involved in executing test plan test strategy and test scripts for Functional, Integration, UAT, Negative and Backend testing.
• Experience in ETL and BI testing and worked with many ETL tools like Informatica, SSIS, Ab Initio, Data Stage and few BI tools like OBIEE.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• Excellent hands - on exposure to SDLC lifecycle methodology involving Waterfall, Spiral, RUP, Agile Scrum & Sprint techniques and thorough understanding of Application Life Cycle Management(ALM)
• Experience in Using HP Quality Center and ALM.
• Working Experience on Testing Data Warehousing (DWH) concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process
• Extensive experience of manual and automated testing of application and use of HP Quality Center, HP Quick Test Pro, Test Director.QTP
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Hands on experience with all phases of Software Development Life Cycle (SDLC), and experience in Waterfall and Agile (SCRUM) Models.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Experienced with ETL tools like Informatica, SSIS, Ab Initio and Data stage.
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Extensive experience in working with databases including Oracle MS SQL Server.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows XP, NT, Linux, UNIX.

Languages Known: PL/SQL, SQL

Databases: Oracle, Teradata, MS SQL Server, MS Access, SQL Server, IBM DB2.

Testing Tools: Quality Center 9.2/10, HP ALM, HPQC, Test Director.

Reporting Tools: Cognos 8.4/10.2, Crystal Reports,OBIEE, Business Objects

Web Servers: Web Server, Netscape Enterprise Server, Web Logic

Data Warehousing tools: Informatica 8.6.1/8.1/7.1/6/5.1.1/1.75, Data Stage 8.x

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Sr.ETL/QA/ DWH Tester

Responsibilities:

• Hands-on QA Analyst responsible for coordinating and performing System Integration, functional and data-related testing.
• Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Quality center
• Used Rational Requisite Pro to track, analyze and document the Test Plan.
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Analyzed business requirements and functional documents
• Tested the reports generated by OBIEE and verified and validated the reports using SQL.
• Played a functional data SME role in the development of the Marketing Measurement and Metrics reporting dashboard implemented in Siebel Analytics /OBIEE environment.
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies
• Responsible to create, Execute Test Sets in HP ALM Test Lab
• Performed data centric backend testing of applications using UNIX and SQL scripts
• Tested data migration to ensure that integrity of data was not compromised.
• Identify business rules for data migration and Perform data validations.
• Generate Reports using HP ALM at the time of execution and releases.
• Involved in preparation of Test strategy document that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required conducting the effort
• Involved in development of test plan, test schedules, test cases based on high-level and detailed designs...
• Testing and Defect Management Tools Manual testing, Application Life Cycle Management (ALM).
• Involved in testing according to HIPPA code Claim Processing and Remittance Advice Claims Processing.
• Responsible to create defects using HP ALM
• Worked with various BI tools like OBIEE, Cognos and Crystal Reports.
• Performed consistency and quality checks on data centric processes on the client data warehouse.
• Verification and validation Applications included mainframe data retrieval and selection, XML conversion processes.
• Performed testing in mainframe environment
• Involved in project planning, coordination and implemented QA methodology.
• Extract Workflow Models from Provision into HPQC for testing processes against system functionalities and requirements
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested several data migration application for security, data protection and data corruption during transfer worked with Data Warehousing at Wachovia Securities, Wisdom & Smart Station applications both, leverage the ODS and BDW. ODS is the operational data store which was used for current data and BDW is the Brokerage Data Warehouse which housed historical data.
• Involved in the review of requirements with functional manager and technical specialists
• Created an end-to-end integrated test script that meets business functionality.
• Participated in the test environment setup and in ensuring that the facilities, test tools and scripts are in place to successful perform the required testing effort.
• Performed manual testing executing all the test cases in ALM before switching to automation testing.
• Used HP ALM to Report, track and, monitor defects.
• Developed test cases and scripts for Functionality, Security and GUI Testing
• Conducted Load testing to generate the load on the server by creating Database User scripts
• Database integrity testing by executing SQL statements.
• Coded UNIX awk and sed shell scripts for data migration for the Department of Credit Risk Warehouse and Capital Funding (CAPFUN) Database
• Performed front-end testing on OBIEE Executive Dashboard portal.
• Integration of mainframe and Unix environments in Data warehousing
• Performed extensive Regression Testing for subsequent versions of the application using QTP.
• Developed Test Summary Reports and participated in GO / NO-GO meetings.
• Involved in validation of data on mainframes (DB2)
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Evaluated the results and the project timeline by setting milestones in RUP.
• Used Agile Waterfall methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards.
• Reported defects using HP ALM Verified fixes and closed bugs during regression testing.
• Analyzed system requirements and developed detailed Test Plans for System Testing using Test Director, Performed Agile testing using scrum practices, to keep the customer involved.
• Worked in expert view of Quick Test Pro, Configured Quick Test Pro (QTP) with Quality Centre (QC) and Maintained the project information in Quality Centre.

Environment: Informatica 9.1, RUP, Clarity, Agile, HP ALM /Quality center 11.O, Mainframe, JCL,DB2Web logic, SQL, Rational Clear Quest, OBIEE, XML, HTML and, Rational Requisite Pro

Confidential, Richmond, VA

ETL/QA/ DWH Tester

Responsibilities:

• Analyzed requirement updates and mapped them with the respective manual Test Cases using HP Quality Center.
• Involved in writing and maintaining Test scripts using HP Quick Test Professional to perform Automation testing during the regression and integration testing phase.
• Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.
• Preparation of test cases for Functional, Regression, Integration and System testing.
• Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Tested all OBIEE Dashboards according to the requirement
• Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and eXtreme Programming
• Supporting presales activity for Data centric warehouse testing projects.
• Involved in Data migration and Data distribution testing
• Worked with data reconciliation for the entire data migration project for both target system and rejected records.
• Resolved data quality issues for multiple feeds coming from Mainframe Flat Files.
• Extensively worked on QTP scripts in analyzing the business processes and created UI Automation scripts.
• Automation Test tools development, Test framework development.
• Created the Automation Test Plan and extensively used QTP for creating scripts for functional and regression testing of various features of the application.
• Worked as a consultant in delivering quality data centric solutions for various business domains
• Provided system analysis, design, development and deployment of Business Intelligence Applications.
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key.
• Developed strategies with Quality Assurance group to implement Test Cases in HPQC and worked with business for UAT (User Acceptance Testing) validation
• Assisted in the integration efforts for merging Business Intelligence platforms with enterprise Systems and Applications.
• Wrote complex SQL syntax using case, having, Group by etc
• Design and execute the test cases on the application as per company standards
• Job operated within a very agile environment, with daily scrum meetings; stand up meetings, burn-down charts, presentations and review
• Written several complex SQL queries for data verification and data quality checks.
• Worked with an offshore team also to improve process in the QA environment
• In between Production implementation, execution of Back End testing and data retrieval for another project utilizing Informatica.
• Created dashboard and reports using OBIEE
• Used Agile methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards.
• Involved in testing XML Messages generated thru ETL tool for legacy Mainframe data.
• Created test scripts using Automation tool QTP and checked the functionality of the application for every release.
• Identified the bugs and interacted with the team lead and developers to resolve them.
• Extensively used Rational Clear Quest to track defects and managed them.
• Created reports for OBIEE using pivot tables, compound layouts, drill-ins, and dashboard prompts, etc
• Analyzed and verified the flat, Mainframe IMS and XML data using Informatica Data Explorer.
• Used HP Quality Center for the reporting and tracking of defects.
• Conduct backend testing by querying databases to synchronize testing databases and check for data integrity and proper routing based on specifications.
• Written several complex SQL queries for data verification and data quality checks.

Environment: Agile/Scrum Methodology, Data centric Testing, Informatica 9,OBIEE, Mainframe Window, HP Quality Center, Waterfall, Oracle, Teradata, HP/ALM Quality Center 11, JCL,DB2Windows, SQL, SQL server, Unix/Linux.

Confidential, Tampa FL

ETL/QA/ DWH Tester

Responsibilities:

• Define and implement test suites for various aspects of software testing (e.g. things like functional, System, UAT, Regression etc
• Involved in the Defect tracking Management, and Validated Hospital and Medical claims processing.
• Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment.
• Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment
• Collected requirements and tested several business reports.
• Written complex SQL queries for validating the data against different kinds of reports generated by OBIEE.
• Developed test scripts and test cases for dashboards and reports being developed in OBIEE
• Tested the conversion of 835 EDI transactions from along with ICD 9 to ICD 10 codes.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend testing
• Analyzed the change detection process on Facets database tables to capture the daily changes done by Users through Online Facets Application.
• Helped other groups and managed mainframe-derived-data analysis. Completely involved with all kinds of VSAM Files.
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division. Clean customer data warehouse
• Tested several stored procedures for data migration to ETL
• Worked on issues with Data migration from development to testing.
• Accessing mainframes and validating the data
• Managed and executed the test process, using Agile Methodology.
• Enterprise Data warehouse-Data Migration Delivery
• Tested OBIEE reports and Web Intelligence reports
• Validated the reports and files according to HIPAA enforced standards
• Performed Defect Tracking and Change Control Procedures using Rational ClearQuest, and Configuration Management and Version Control using Rational Clear Case.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation
• Written Test Cases for ETL to compare Source and Target database and Tested records with logical delete using flags
• Using Rational Clear Quest creating the defects which are related to Service plans and Service plan Ids and managing the same.

Environment: EDI, Hipaa, ICD, HP Quality Center, Agile, Windows, SQL server, ETL, Mainframe, Informatica 8.6.1/8.1, Oracle PL/SQL, SQL XML, Unix/Linux.

Confidential, Atlanta, GA

ETL/QA/ DWH Tester

Responsibilities:

• Involved in meetings with Business Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.
• Developed Test Plans, Test Cases to test the Screens and workflows for Quality Assurance.
• Performed manual testing to conduct backend testing using UNIX shell scripts and SQL Queries
• Worked with ETL group for understating mappings for dimensions and facts
• Excellent Understanding of Data warehousing concepts - Data marts, Star, Snowflake, Fact, fact less, Dimensions, Measures, cubes Etc
• Involved in other test planning meetings and submitted test metrics daily to the management
• Participated in defining and executing test strategies using agile methodology.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Created Document for Commercial Package Policy Components (CPP) and Business Owners Policy (BOP) for Small and Medium Sized Businesses
• Extract data from Mainframe data sets against Target Value to compare
• Worked extensively with the end users team in understanding the business rules and writing requirement specs, technical specs and mapping documents from staging to data mart, cubes and reporting needs to the end user community which includes underwriting, claims, finance, accounting, reinsurance and actuarial departments.
• Wrote test plans and procedures for DRI Data Migration tool.
• Data Migration of raw data to excel documents for clients
• Testing and Reporting the Bugs in product releases and performed the Root Cause Analysis for the Defects raised.
• Extensively used Rational Clear Quest to track defects and managed them.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Tested new Data Migration tool used in the mapping of data to new system.
• Performed negative and positive testing using SQL Queries
• Automated the Back-End testing for reusability by writing Unix Shell Scripts, and Tracked defects using Quality Center.

Environment: Informatica Power Center 8.1, Erwin, Mainframe, Mercury Quality Center, Windows SQL, SQL, UNIX, Rational Clear Quest.

Confidential, Baltimore, MD

ETL/QA/ DWH Tester

Responsibilities:

• Adopted AGILE (SRUM) methodology for new projects.
• Responsible for the data for different data cycles, executing the test scripts.
• Interfaced with developers to resolve the problems while executing the test scripts.
• Manually performed Ad-Hoc testing, end-to-end testing, System testing, and Regression Testing, Function testing, Performance testing, and User Acceptance testing.(UAT)
• Analyzed and verified the flat, Mainframe IMS and XML data using Informatica Data Explorer.
• Parameterized the scripts to perform the data driven testing.
• Extensively worked on Virtual User generator and Controller.
• Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using Test Director
• Performed Positive and Negative testing and tested for boundary cases.
• Plan, Design, Analyze, Execute the test cases from Test Director
• Involved also in Configuration Management of the Projects in Test Director
• Manually executed test cases for the functionality testing and security testing using TestDirector.
• Performed Back-End testing of SQL queries to fetch the data from the database for validating the output and also executed the stored procedures.
• Verifying UNIX batch scripts which will provide Verification Reports
• Documented the modification requests and defects using TestDirector.
• Maintained the bug reports for internal evaluation of the product using Test Director
• Did the Black Box and System testing.

Environment: Windows, Informatica, UNIX, Mainframe, Test Director, Crystal Reports, SQL Server, and HTML.