SUMMARY:

• An enterprising professional with 6+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL & BI), Web and Client - Server Systems and Applications for Healthcare and Banking Domain.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Expert level skills in testing the Enterprise Data Warehouses using Informatica Power Center, Data Stage, and SSIS ETL tools.
• Experience in working with execution of the scheduled jobs by using Autosys.
• Experience on UNIX commands and Shell Scripting.
• Having good experience in Software Automation using QTP.
• Proficient in various Defect tracking tools like Quality Center, Bugzilla, Clear Quest, and Test Director.
• Defects were tracked, reviewed, analyzed and using Quality Center.
• Solid Back End Testing experience by writing and executing SQL Queries
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Having experience in White box testing methods for performance increase.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL Development Toad, WinSQL, PL/SQL Developer, SQL Navigator, Perl, UNIX and Korn Shell Scripting.
• Experience in using Oracle Databases and SQL Server.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL. Competitive experience in functional and non-functional testing.
• Setting QA Test Environment, Good interaction with developers, managers and team members to coordinate job tasks.
• Good communication skills and interpersonal skill and consistently being organized by management and peer for producing high quality works.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Proficiency in Testing Client-Server and Web Applications.
• Accurate and concise documentation skills, used for creating detailed test plans, test reports and other documents required within the test process.
• Ability to communicate effectively with onsite/offshore teams.

TECHNICAL SKILLS:

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology.

QA Tools: Quality Center, IBM / Rational - Clear Quest

ETL Tools: Informatica Power Center 8.x/7.x, Data stage 8.1/8.0/7.5/7. x, SSIS

BI/Reporting Tools: IBM Cognos 8, Micro Strategy, Business Objects, SSRS

ALM: Application Life cycle management

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2UNIX-Sun Solaris, HP-UX

Databases: Oracle 11g,10g, 9i, 8i

Microsoft: MS Access, SQL Server 2005/2008

Languages: SQL, PL/SQL, UNIX Shell Scripts, VB Script, Java, C, XML, HTML, DHTML, Web Services - SOAP UI.

PROFESSIONAL EXPERIENCE:

Confidential

SR.ETL/QA - Credit Card Processing Data Mart

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data Warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, 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.
• Maintained and kept track of stake holder’s requests for enhancements and changes using Rational Clear Quest.
• Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application.
• Responsible in testing Initial and daily loads of ETL jobs.
• Tested several data validation graphs developed in Informatica environment
• Was involved in design part for Extracting data from different source systems into the target database using Informatica
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Extensively used Rational Clear Quest track defects and managed them.
• Worked on exporting data using Teradata.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Manually tested and GTS modules using Quality Center.
• Executed regression tests at each new build in QTP and Inserted Synchronization points in the script using QTP.
• Performed Data Driven Testing using QTP for testing the application for multiple data
• Worked with QTP for Regression Testing.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Involved in analyzing the data, and preparation of ad hoc reports for Business needs.
• Tested Informatica mappings for various ETL functions.
• Tested Cognos reports for verifying and validating the data.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
• Wrote PL/SQL scripts for the usage in Performance testing.
• Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
• Executed automated test scripts using QTP for Regression testing.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Done data validation for the Cognos reports.
• Responsible for documenting the process for future references.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Optimized high volume tables (Including collection tables) in Teradata using various join index techniques, secondary indexes, join strategies SQL UNION and hash distribution methods.
• Prepared test plans/test schedules with inputs from Project manager and development team.
• Escalate the issues about project requirements (software and hardware) to Project Managers.

Environment: Informatica Power Center 8.0, Cognos 7.3, HP Quality Center, Rational Clear Case, Rational Clear Quest, Data Stage, Rational RequisitePro, XML, XSD, XSLT, Web Testing, Java, .Net, TOAD, JCL, Remedy, Quick Test Professional (QTP), Perl, Web logic, Oracle 10g/9i, SQL Server 2008, PL/SQL, Linux, Win XP.

Confidential

ETL/SQL Tester

• Analyzed Business Requirements document for developing Test Plan, Test Cases and providing the Test Estimations per session and prioritize the Test Cases
• Review Business and Functional Requirements and develop Detailed Test Plan and Test Cases
• Involved in batch testing which includes the process of execution of the job and to get completed successfully and generates an extract in the target location
• Reviewed requirements for Testability and Usability, consulted Development staff regarding system functionality
• Provided best practices for MicroStrategy Implementation
• Created the Test data using Altova XML Spy in XML format and made the required modifications that helped extensive Backend Testing.
• Conducted daily Defect Meetings with project team to review defects identified during validation
• Conducted variance management by analyzing and verifying Test Results, providing status and progress reports using TestDirector
• Performed extensive Database Testing by writing complex PL/SQL Queries in TOAD to test different scenarios of the application and to develop and administor relational databases.
• Involved in Functional, Integration, User Acceptance, and Comparison testing.
• Involved in Regression testing of the builds and patches in staging and production environment.
• Involved in Setting up of Test and Staging environment.
• Worked with the project team to accomplish quality assurance and process improvement initiatives.
• Coordinated with Business Analyst, Development team and other project team members to discuss and resolve defects
• Performed End User Testing before the Build is released for actual real time implementation.
• Participated in the T eam Meetings to discuss the issues raised during testing.

Environment: XML, Oracle Application Server, Oracle, Toad, XML Spy, SQL, Toad, Oracle, Informatica, Business Objects.

Confidential

ETL/QA tester

• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules.
• Manage product and release backlogs that reflect the priorities of the business using Rally.
• Involved in daily scrum meetings for agile methodology project.
• Maintained Rally for Task allocation and tracking the tasks to closure. Extensive use of Rally Software to organize user stories, tasks, defects and tests plan and track iterations (sprints) and releases.
• Performed data validation testing after the ETL process using Informatica.
• Used Rally for making the development organization faster, leaner and more agile and to get on the track with the User stories and to improve iteration planning practices.
• Involved in manual testing, preparation of Business Process Test Cases and Test Execution.
• Involved in the review of test cases and test scenarios of the Policy module.
• Performed report testing for both SSRS Reports and BI Reports via Business Objects.
• Maintained all the documentation in Share point.
• Worked on Guidewire Policy Center for ETL testing.
• Used Informatica Workflow Manager to schedule and run Informatica mappings and Workflow.
• Monitor to monitor ETL execution and logs.
• Involved in frond end testing of TOS for policies and NOTUS for claims.
• Preparation of test scenario's based on Mapping documents.
• Extensively use SQL queries for data validation and back end testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents.
• Work closely with the software engineers to ensure successful, high quality releases.

Environment: Agile Test Methodology,Informatica Power Center 8.4, ClearCase, IBM Cognos 8.0, Micro Strategy, Clear Quest, SQL, PL/SQL, Oracle 10g, UNIX, Autosys, Putty, ERWIN, Teradata V2R6, Session log files, Flat files, SOA, Business Object, Web based Testing, Guidewire Policy Center, HP Quality Center, SQL Server 2008, SSIS, and TOAD.

Confidential

BACKEND/QA Tester

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Client interaction for queries clarification
• Designed and developed test cases for Smoke, Functional, Integration, Negative, Regression test suites.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing
• Performed extensive manual testing on critical functionalities of the application.
• Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do; whether the mapping work correctly in relation to other processes in your data logistical flow.
• Writing QTP Scripts and running the tests.
• Defect tracking and logging the defect with complete details.
• Participated in discussions for prioritizing work, developing time estimates and work plans and assisting team members.
• Conduct client demo along with creating documents for the same
• Executed functional test cases for the application.
• Wrote SQL queries for database testing.
• Designed and developed test cases for the application.
• Executed the test cases for the application.
• Involved in running QTP Scripts.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Extensive used TOAD to run SQL queries and monitor quality & integrity of data.
• Actively participated in creating requirements Traceability matrices and Test plans
• Performed Unit and functional testing for all the Mappings and Sessions.
• Implemented automated Processes & scheduling using Autosys.

Environment: Hp Quality Center, Oracle 9i, SQL Server 2005, Rapid SQL, SQL, PL/SQL, Autosys, Toad, Web based Testing, Remedy, IBM AIX, MS Access, Unix.

Confidential

QA/SQL TESTER

• Reviewed and analyzed functional requirement specifications, workflow documents, and Use Cases.
• Performed System Testing, Integration Testing, Functional and Regression Testing.
• Created Data Driven Tests to validate test scenario with different sets of data using parameterization.
• Closely worked with the Business Analyst, Developers and UI team to resolve the requirement issues, deployment issues, change management etc., during the course of the QA testing and actively participated in Review meetings and walkthroughs.
• Prepared test data to verify different types of scenarios.
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Analyzed Manual Test Cases with QA Team for most important & high priority Requirements for conversion to Automated Test Scripts using HP Quickest Professional (QTP)
• Extensively used HP Quality Center as defect tracking system to log, close and generate reports and tracked through to resolution.
• Extensively involved in the Backend / Data base testing using SQL queries.
• Interacted with developers in resolving the defects found in the application during testing.
• Working closely with team members to ensure status and schedules are communicated
• Extensively performed manual testing activities using Quality Center.
• Participate in peer reviews of functional specification, application previews, and test plans/test cases.
• Create and execute SQL queries to fetch data from Oracle database to validate Data.
• Interacted with business analysts and developers to resolve the technical issues so as to meet the client’s requirement for a better quality software product.

Environment: HP Quality Center 9.0, Manual Testing, MS SQL, Oracle 10g, TOAD, HTML, XML, Windows, SQL Server.