Qa Consultant Resume
Houston-, TX
SUMMARY
- An accomplished quality assurance tester with over 7 years of Software development life cycle with hands on experience in B2B, B2C and SAP applications.
- Well versed with Automated/Manual Testing, Regression Testing, Functional Testing, System Testing, Integration Testing, Black Box Testing and Test Documentation. Experience in User Acceptance Testing.
- Analyzed functional requirements, Design Documents, Business Use Cases and developed Test Plans, Test Cases, Test Scripts, Test Procedures, Test Data, analyzing bugs/defects, Test Scenarios for the Functional and Performance testing.
- Experience in writing and executing positive and negative test cases.
- Well versed in Verification/Validation and other Quality Assurance activities.
- Experience in Web and Client/Server testing in Windows environments
- Experience in Back End Database testing in Oracle, DB2, SQL Server and MS-Access databases.
- Experience in testing various Front End GUI Applications.
- Strong database functionality testing using SQL & Oracle.
- Good knowledge of RDBMS and programming concepts.
- Strong knowledge in SQL Queries, Stored Procedures and Triggers for database testing.
- Capable of problem solving and delivering realistic and practical solutions. Enthusiastic, innovative and challenge oriented.
- Good experience in Quality Center
- Excellent written & verbal Communication, Interpersonal and Organizational Skills.
- Excellent documentation skills.
- Strong desire for continuous learning new tools & technology.
EDUCATION: Bachelor’s degree- Post Graduate Diploma in Computers Science
SKILLS
Testing Tools/Software : QTP, HP Quality Center, Win Runner
Languages : C, C++, SQL, PL/SQL
Databases : SQL, Oracle 8.x/9.x /10g/11g and Microsoft Access, SAP BI Analyzer,
Platforms : Trizetto Facets, Windows and MS DOS.
Query Tools : SQL Plus, SQL Developer, Rapid SQL, Crystal Reports, Business Objects.
GUI : Visual Basic 5.0, 6.0, ASP.Net, .Net
WORK EXPERIENCE:
QA Consultant- Confidential, Houston- TX July’ 12 – Present
LyondellBasell is one of world’s largest plastics, chemical and refining companies. They participate in the
Entire petrochemical value chain, from refining to specialized petrochemical product end uses. Lyondell
Basell is a leading provider of technology licenses and supplier of catalysts of polyolefin production.
Responsibilities:
- Test cases and business requirements in management in Quality Center.
- Develop and execute test cases in the SAP Financial package utilizing Business Objects, Crystal reports and Xcelsius components.
- Grouping test cases at individual object level and validate against classifications, Flat file testing and validation points, business scenarios.
- Communication Integration with downstream applications such as ERP, CRM, SAP, MDM, Salesforce, MES, BI, Data Warehouse.
- Validating all components against Consolidated Income Statement and Segment pages.
- Define key figures CIW Income Statement, Balance Sheet and Cash flow
- Test Consolidated Income Statement, Cash Flow, Balance sheet and Business Segment Summary-EBITDA
Projects: CRI, SAP CAPEx, Consolidation, Buy Sell elimination & Financial packages Phase I, II & III applications.
Environment: SAP BW, Business Objects, Crystal Reports, Xcelsius, BI Analyzer 7.20, HP Quality Center 11.00, 355 LYB BWD, Group server- BWDAPP
From March’ 12 to July’ 12- Attended online training in Business Objects & SQL Scripts to enhance my technical skills.
QA Tester- Confidential, Sep ’11 – Feb’ 12
Universal American a family of healthcare companies provides healthcare benefits to people with Medicare. I was involved in testing of Membership, Billing, Claims Medicare data, Financial and Accounting.
Responsibilities
- Involved with Business analyst teams to prepare a detailed Business Requirement document.
- Developed test plans, and written test scenarios and cases to cover overall quality assurance testing.
- Performed manual testing to test the usability of applications.
- Experience in Trizetto Facets Configuration.
- Ability to understand Facets Data Model.
- Ability to understand various Facets utilities for performance of specific task.
- Experience in reviewing the defect logs for MMS.
- Conducted GUI Testing, System Integration testing, Functional testing and Regression Testing.
- Conducted Back End Testing using SQL.
- Wrote user defined functions and reused them by storing them in compiled modules.
- Conducted End-to-End testing on applications.
- Reviewed test scenarios and test cases in Quality Centre.
- Logged the errors and coordinated efforts with the development team to solve the problems.
- Responsible for documenting test cases.
- Experience in testing for Online Enrollment Verification (OEV) System.
- Actively participated in Status reporting meetings and interacted with Development to discuss the technical issues.
Projects: CVS Caremark, Member Move, ANOC, ANOC Errata, ID Cards and Welcome Kit, ID Card Record, OEV, Provider Link Portal.
Environment: SQL, Trizetto Facets 4.8, Quality Centre 11.0, MS-Access, Windows XP, SQL Server 2008, Prism, Horizon, Macess, Pegasus.
QA Tester- Confidential,- Houston- TX
Apr 2010- June 2011
Natural Gas- Pipeline, Storage & Security Applications
Responsibilities
- Involved in Test Plan and created Test Cases for System Testing.
- Performed Positive Testing, Negative Testing, and Black Box Testing.
- Performed extensive testing of application’s functional testing, integration testing and regression testing.
- Involved in system testing of the application.
- Extensively written test cases in QC test Plan and executed in QC test lap and logged defects in defect module.
- Ensured the execution of UAT test cases and documentation of test results.
- Provided UAT testing status information to the quality assurance lead, project manager, and various business stakeholders.
- Created and executed the test cases on various forms of the application manually.
- Verified the images to make sure they are loading properly.
- Prepared defect reports using Excel and interacted with developers for bug fixing and tracking debugging.
- Conducted Regression Testing on various builds of the application and reported defects to the developers.
- Involved in UAT test plan creation and created test cases.
- Used SQL to test integrity of data by querying the database
Environment: Quality Center 9.0, Visual Basic 6.0, .Net, SQL, PL/SQL, Oracle 11g, Windows 2000
QA Tester- Ensoft Professionals (Client- GASTAR) - Houston-TX Aug 2008–Mar 2010
Natural Gas- Business Transaction Applications
Responsibilities:
- Created and executed test cases on various forms of application manually.
- Test cases generated for each functionality and automated bug free test cases
- Performed Positive Testing, Negative Testing, and Black Box Testing.
- Performed extensive testing of application’s functional testing, integration testing, and regression testing.
- Tested manually on various verification points on GUI Objects like Windows, Menus, Dialogs, Bit Maps and Navigation, Database.
- Prepared defect reports and interacted with developers for debugging.
- Conducted Regression Testing on various builds of the application and identified defects, coordinated with developers for bug fixing.
- Used SQL plus to test the integrity of data by querying the database.
- Analyzed the Expected verses Actual results.
- Written test cases in QC test plan
- Executed test cases in QC test lab
- Logged defect in Quality Center
- Developed final test reports, Coordinated and supported user acceptance testing.
Environment: Quality Center 9.0 Visual Basic 6, ASP, XML, SQL, Oracle 11g
QA Tester- Allsoft Tech (Client- Broward County Traffic Engineering Division) - FL/CA Jul 2006- Jul 2008
AIMS (Asset Inventory Management System) was designed for the Traffic Engineering Division of Broward County. This Systems helps track the inventory of traffic devises. Workflow capabilities track all the approval steps from the initial request through post-implementation support
Responsibilities:
- Analyzing Business requirements and specification with Developers and Analysts.
- Developed detailed Test Plans.
- Performed web-testing for Links (TEXT, GRAPH, IMAGE), Frames (size manipulation, refresh issues etc.,) Browser dependency, Applets, Cookies and Forms.
- Tested Software Documentation for Packaging and Text Graphics, Warranty /Registration, Marketing materials, ads and EULA.
- Developed Linear, Structural and Data driven scripts for the respective functionality of the application using Test Script Language in Win Runner
- Extensive comments sprinkled throughout test cases and scripts with narrative descriptions.
- Involved in the Manual Testing and automation Testing.
- Extensively worked on Virtual User generator and Controller.
- Performed functional, regression, System testing for the application.
Environment: Windows 2000, Visual Basic 6.0, Win Runner, SQL Server 7.0, ASP.Net
QA Tester/Analyst- Allsoft Tech (Client- Kaiser Permanente), CA Mar 2005-Jun 2006
Project Title: PIMS (Foundation Compliance)
Involved in various projects like e-Refill, it is a web application provides facility to refill the prescription. KP-CIS and other releases. PIMS (Pharmacy information and management system) application has been used for outpatient. The outpatient module is composed of four major parts. Take-In, Batch Edit, Input and Point of Sale.
- Reviewed Business Requirements Documents and the Technical Specifications.
- Participating with users to take test requirements and testing analysis.
- Testing the Outpatient for transition from one plan to other (e.g. one HDHP Plan to other, Part D to HDHP and vice versa)
- Dispensing the drugs and checking for the response from the PBM (Pharmacy Benefit Manager)/ HT (HealthTrans)
- Testing for Claim reversal for the Outpatient.
- Workflow Integration Testing (WIT)
- POS (Point of Sale) Developed scripts to perform functional tests, content retrieval to test database tables and data validation.
- Involved in writing Test plans, which detailed the testing scope, strategy, test requirements, and necessary resources.
- Documented test cases based on corresponding business /user requirements documents & technical specification and other operating conditions.
- Reporting daily status to QA Lead.
- Participating in QA/Development meetings to meet the testing standards.
- Performed Black box testing.
- Perform End-to-End testing manually.
- Perform Regression testing using Win runner 7.1
- Used Test Director for Executing the Tests and Tracking the defects
- Closely worked with respective personnel to nail down the bugs.
- Reporting of bugs to all concerned.
- Used customized bug-reporting tool to create TRs.
Environment: Windows NT, COBOL 85, Tandem and Guardian 90 using a SQL/MP database and
Enscribe file System Win Runner, Test Director