Quality Assurance Analyst Resume
Columbus, OH
About 7 years experience in Software Quality Assurance on web based and client sever applications. Expertise in manual testing. Comprehensive understanding of SDLC and methodologies. Proven track record in understanding, analyzing, and testing business requirements.
Summary
- Worked on various projects across Banking, Insurance, and Healthcare domains
- Followed Agile, RUP & Waterfall methodologies for software development
- Tested User Interfaces, ETL processes, and Databases
- Performed functional and non functional testing
- Involved in Regression, Performance, and User Acceptance testing
- Analyzed business requirements to make sure that each requirement is testable
- Interacted with various project teams to exchange information and resolve issues
- Executed test plans, test cases, test scenarios, test data and test metrics
- Used Quality Center to manage test cases and defects
- Created test plans, test cases, test scenarios and test data
- Wrote SQL queries to understand and test backend data
- Produced traceability matrix to map business and functional requirements to test cases
- Identified functional modules for automation and produced test scripts
- Possess strong analytical and problem solving skills
- Facilitated weekly status calls, produce status reports, and ensured smooth signoff
Skills:
DatabasesOracle 9i/10i/11i, MS Access, SQL Server7.0, Sybase,DB2, MS SQL ,RDBMS
Testing Tools
Test Director/Quality Center, Win Runner, Load Runner, Rational Clear quest, Rational Test Manager, Rational Requisite Pro ,QTP
Other Tools
MS Office (Word, Excel, Powerpoint, & Access), MS Visio
Operating systems
MS Windows all Versions , UNIX , SUN Solaris , MAC OSX
Web technologies
HTML, XML, XTML, Java Script, ASP, JSP, .NET Servlet
Browsers
Netscape Navigator, Internet Explorer, and Firefox
PROFESSIONAL EXPERIENCE
Confidential, Columbus, OH Aug 11 Present
Responsibilities:
- Attended requirement review session to make sure that each requirement is testable
- Created functional and regression test scenarios, test cases, and test data
- Performed manual testing and automation testing (regression and performance)
- Wrote SQL queries to validate data load and retrieve existing policy info for expected test results
- Interacted with cross functional teams (Business Analysts, Developers, and DBAs)
- Validate field mappings, interface feeds, end to end functionality, and business rules
- Validated ACORD (80, 85,90) standards for XML transactions
- Managed defects (logged, tracked, and closed) using Quality Center
- Worked with new hires giving them knowledge transfer and assigning tasks
- Maintained good relationship with business and other technology teams
Environment: Windows XP, QC, AS-400, JAVA, Oracle
Confidential,Des Moines, IA Nov10- july11
Quality Assurance Analyst
Responsibilities:
- Attended requirements review sessions to make sure requirements are complete and testable
- Produced deliverables like test plans, test cases, test data from business/functional requirements document
- Executed test scripts (SIT, UAT, PROD Checkout) and managed defects using Quality Center
- Tested input/output files (xml, .csv, flat), validating data quality and business rules supporting ETL
- Created sample files to use them expected results for testing efforts
- Identified modules for automation and implemented automation testing using QTP
- Executed test scripts to automate policy creation for regression and performance testing
- Wrote SQL queries to perform backend testing on loaded data
- Used ACCORD standards to test XML files
- Facilitated daily status calls and produced status reports
- Supported technology and business checkouts
Environment: Windows XP, Quality Center 9.2, QTP, ACCORD, XML, Websphere, Oracle, VB, Java
Confidential,Annapolis, MD Aug 09- Sep 10
Quality Assurance Analyst
Responsibilities:
- Reviewed Business and Functional Requirements and analyzed them to come up with test plan
- Produced Test scenarios, Test cases, and Test data interpreting functional requirements
- Automated the process of policy/claim creation for scenario testing during UAT and regression testing
- Managed test cases, test results, and defects using Quality Center
- Worked with development team to communicate, track, retest, and close defects
- Wrote SQL queries to validate data load into backend tables
- Acted as a point of contact for defect status & resolution for Development team, QA team and business.
- Maintained test metrics and produced daily status reports
- Coordinated SIT and User Acceptance Testing by organizing daily status calls
Environment: Windows NT4.0, Quality Center, QTP, Rational Functional Tester (RFT), UNIX, Java, HTML, DB2, Microsoft Excel, MS Word, Internet Explorer 5.0.
Confidential, IA Sep 08- Jul 09
QA Analyst
Responsibilities:
- Understood the functional requirement document and created test scenarios, test cases, and test data
- Created manual test plans to validate straight through processing (STP) of an insurance policy
- Attended requirements review sessions to make sure requirements are complete and testable
- Developed automated scripts using Quick Test Professional to perform functional and regression testing.
- Inserted Bitmap and Text checkpoints where needed, to compare the current behavior of the application using Quick Test Pro (QTP).
- Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote functions for the parameters to read new data from the table upon each iteration Performed Data-driven testing using Quick Test Pro
- Analyzed QTP scripts execution results at various check points (expected vs actual)
- Managed (logged, assigned, tracked, and closed) defects using Quality Center
- Created sample xml files using ACCORD standards
- Organized defect status calls, produced weekly status reports, and ensured smooth signoff
Environment & Tools: Windows XP, QTP 9.0, QC 9.1, Win runner, XML, Websphere, Oracle
Confidential,Phoenix, AZ Nov 07- Sep 08
Quality Assurance Analyst
Responsibilities:
- Involved in Preparing Test plan as per Agile standards and Guidelines
- Used Quality Center to prepare Test cases, procedures and Requirements Tractability Matrix
- Generated the detailed reports of the Defects/Bugs, Pass-Fail report and Assigned defects using Quality center
- Interacted with Business users, SME (Subject matter experts) and Technical Analysts in providing clear solutions to requirements.
- Involved in defining, planning and conducting QA reviews
- Wrote SQL queries to understand and test backend data
- Responsible for designing, developing test plans and executing test scripts.
- Involved in testing HIPAA EDI, PHI Data Transactions
- Worked on various EDI X12 transaction sets 837 I/P, 275/276, 270/271, 834 etc
- Tested Various levels of FDA regulatory and HIPPA Rules
- Tested based on rules that are shared across applications and organizational boundaries
- Used Load runner as performance tool for load and performance testing
Environment: Data Stages, java, Java Script, File-Aid, Oracle 11i, PL/SQL, UNIX, J Boss, Windows98/NT/2000/XP,UNIX, QTP, Win runner, Quality Center
Confidential, IndiaJul 06 Aug 07
QA tester
Responsibilities:
- Involved in Planning, Coordinating, Developing Test plans, Test Procedures, Test cases and Test Matrices based on the Requirements and Design Documents
- Used Quality Center to create and maintain the Test cases and the Test scripts for both System Testing and Regression Testing
- Extensively used Quality Center for reporting and categorized the bugs based on severity
- Developed scripts using Automated Testing tool QTP for Functional testing and Regression Testing
- Analyzed Test results to meet the end user needs
- Involved in loading of Test Data into Oracle Database using SQL LOADER in Test environment
- Conducted the System Integration testing of the application manually for different Modules
Environment: Windows XP,QC 9.0 ,SQL LOADER, Java , QTP,VB Script.
Education:Bachelor of Technology, Computer Science,