Test Analyst Resume
SUMMARY:
- Over 4 years of experience testing Data Warehouse and Web Based Applications
- Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
- 4+ years of experience in Integration, Functional, Regression, System Testing, Black Box and ETLs, GUI and Report testing.
- Experience in Quality Center preparing Test Plans, detailed Test Cases and Test Scripts, Defect tracking and Reporting
- Experience in QTP for creating regression test beds
- Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
- Experience working with system development team and Business requirement team for any Defectsand clarifications.
- Excellent analytical, communication, problem solving and interpersonal skills.
TECHNICAL SKILLS:
Operating Systems: Windows 95/98/2000/NT/XP, UNIX, Linux,
Languages: C, C++, Java, SQL, PL/SQL, UNIX Shell Scripting
Testing Tools: HP Quality Center, QTP
Databases: Oracle, SQL Server
ETL Tools: Informatica Power Center
Web Design: HTML, XML, Java, J2EE, JSP, ASP JavaScript, VBScript
App Servers: BEA Web logic, IBM Web sphere
Reporting Tools: Cognos
PROFESSIONAL SUMMARY
Confidential, NJ Aug’ 2010 – Jun’2012
Test Analyst
Financial Institution Channel (FIC) Project : Is a Website for Acquisition of Individual Life Insurance Customers of Term Insurance Product.
Environment: Java, J2EE Oracle - Web Application, Quality Center, QTP
Roles and Responsibilities:
- Involved in Test Plan preparation and creating test scenarios for integration and system testing of the web application based on design documents and technical specifications
- Executed test cases and ensured that all requirements are tested.
- Reported and tracked defects in Quality Center
- Researched incidents for the cause and offered solutions
- Offered support to user acceptance testing
- Created QTP scripts for regression testing
- Executed regression test cases using QTP
- Offered support for user acceptance testing
Confidential, NJ
QA Analyst Apl’2009 – July’2010
Provider Access for BCC Medical is an online tool that allows providers (physicians and hospitals) to view eligibility, benefits, claims status and other valuable resources. Provider Access if utilized full-fledged reduces much of an administrative work for a Provider. The Provider Access application is a tool for BCC Medical Providers.
Environment: Java Application (web based application), Oracle, VSS, SQL, QTP, Quality Center
Roles and Responsibilities:
- Responsible for writing Test Plan, Test Cases and Test Scripts. Reviewed test cases.
- Used QC for entire testing life cycle
- Applied Equivalence Class partitioning, B V A and Cause and Effect techniques for V A and Cause and preparing test cases.
- Mapped every single requirement to its associated test-script for traceability.
- Wrote queries in SQL to fetch the data from backend systems
- Developed Regression test beds and created test scripts using QTP
- Executed the manual and automated and test cases.
- Created and tracked defects to the closure.
Confidential, CT
Feb’2008 - May’2009
ETL Tester
BOFA-CI Project: To create new warehouse to maintain Bank of America Customer information.
Environment: .Net, Oracle, SQL, Informatica, Cognos, Quality Center
- Responsible for creating test scripts based on the ETL Specifications and Report Specifications.
- Created Test data based on ETL mapping rules and Report design specifications
- Tested the ETL mappings and other ETL Processes and compared the expected results with the actual outcome and recorded the results.
- Verified correctness of the data loaded into the Data warehouse following the ETL process. performed backend testing of the Database by writing PL/SQL queries and checking the output in the error reports
- Verified correctness of the data pulled into the Reports from the data mart following the ETL process
- Coordinated with the Development team during defect fixing and for any clarifications.
- Involved in Functional, Regression, Integration, Systems and User Acceptance Testing.
- Responsible for creating Requirement Traceability Matrix (RTM)
- Actively involved with status reporting from time to time
EDUCATION:
Master of Computer Applications (MCA)
Bachelor of Science (BSc)