Sqa Tester Consultant Resume
Parsippany, NJ
SUMMARY
- Quality Assurance Analyst with about 8 years of experience in manual and automation testing with various domains like retail (E - Commerce), banking, POS system and healthcare. Did performance analysis on different platforms, client server environments, web-based applications, Business Process Flows, web services, Business Process Modeling, HPALM
- Working knowledge of SDLC, Agile, RUP methodology and project life cycle
- Extensive Experience in Design, Development, and Execution of Test cases, Test scenarios and Test plans
- Experience in design, development, implementation and integration strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills
- Experience in writing new product/batch releases, changes requests and documentation
- Worked on POS Suite System with discounts, offers, security validation, POS terminals, and Servers
- Sound experience in written communications skills in interpreting, writing and adhering to procedures, creating test cases from scratch as per the business requirements, under various testing phases with strong documentation
- Experience in Requirement Analysis, Arriving at Scenarios from Requirements and Use cases, Test Planning, Test Strategy, Test Case preparation, Test data Preparation, Test Case Execution, Defect Reporting and Documentation
- Knowledge and experience in Manual/Database Testing and Automation testing like QTP, HPQC (HP Application Lifecycle Management), Selenium RC and JIRA
- Performed Black/white box testing, Positive, Negative, Smoke Testing, System Integration Testing, Regression Testing, Back end Testing
- Sound knowledge in QTP and coming out with an automation framework proposal for the client showing casing advantages of an automated approach
- Created, maintained and executed text cases using HP ALM 12.01
- Experience in writing, modifying automation script in VB scripting to create custom testing
- Sound knowledge of web consoles and adding various checkpoints and data points via keyword view while the data integration via complex data excel sheet for automation testing and defect tracking
- Experience in the Analysis of Bug Severity, Bug Tracking Reporting
- Lean Quality Tools (FMEA, Pareto Charts, Fishbone Diagrams, Six Sigma 5S, Statistical Process Controls (SPC), Value Stream Mapping
- Experience in writing SQL queries in MS SQL Server Management Studio 2012 for database testing
- Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques
- Certification done in Automation Testing- QTP 11.0, HP ALM 12.01, LR (Load Runner)
TECHNICAL SKILLS
Methodologies: RUP, SDLC, RAD, Agile, Six Sigma, Lean, SPC
Artifacts: BRD, FRD, RTM, Project Version Control Template, UML diagrams, Use cases, Test Cases, Project status (Gantt Chart, Milestones and Issue list)
Operating Systems: Windows 98/NT/2000/XP/VISTA/UNIX/LINUX
Supply Chain Software: AS/400 system, High Jump Warehouse Advantage
ERP Software: SAP ERP 6.0 Production, SAP SCM 7.0
Applications: Microsoft Office - Word, Excel, PowerPoint, Visio, Access, JIRA 6.1, IBM Rational Rose 8.1, MS Dynamics
Quality Tools: HP ALM 12.0, Quality Center 8.0/9.0/9.2, Quick test Pro (QTP/UFT) Ver- 12.01, Load Runner, Rational Clear Quest, Test Director 7.51/7.6/7.8/8.0 , SOAP UI 4.5/3.x/2.x, Microsoft Test Manager
Database and Tools: Microsoft SQL Server, Oracle 11g/10g, SQL, PL/SQL, Toad 11.6 for Oracle
PROFESSIONAL EXPERIENCE
Confidential, Parsippany, NJ
SQA Tester Consultant
Responsibilities:
- Updated the Basic Project Portfolio with QA tasks in the TASKS tab, issues, and defect fixes in DAPTIV for the business/executive team
- Created and maintained the Technical Documentation for the Dashboard of DAPTIV with QA team updates as per the requirements and testing scope under CAB project
- Performed database and functional testing and made sure that the data sets are latest and relevant to a claim
- Prepared test cases based on scenarios when an invoice pertaining to an specific claim such as weekly, monthly or quarterly basis
- Worked on the UAT test scripts and tested in each releases and various environments with the business team
- Performed testing based on the strict timeline such as daily/weekly/monthly basis which is set as per the application processing and generating data
- Performed heavy Excel and ALM reporting on a timely basis
- Timely brainstorming sessions with the QA lead, other QA and business analysts, developers and making sure each and every aspect is covered
- Reviewed Business Requirements Documents and the Technical Specification documents
- Wrote test Cases from scratch, and guided one newly hired QA tester with the steps required to kick start the project
- Tested the application with respect to a new batch release and data refreshes
- Performed regression testing as every new release took place based on the business requirements
- Tested the SiteMinder Security on four internal QA testing environments; with various configuration settings of these QA environments
- Validated the SalesForce frontend for all the correct fields as per the mapping and design document
- Reviewed the mapping document of data generation of the files by the developer for the test case design
- Created, and executed test cases on all the entities and attributes as per the designed requirements inside the project to validate the robustness of data
- Executed and validated the data in SQL Server 2012 as per the extract rules designed by the business and developer
- Performed the data validation with two initial loads and two incremental loads which comes under one cycle
- Logged defects based on the initial and incremental load testing through which the data consistency became more accurate
- Validated the Invoice Extract File generated from BillGen application and logged defects/issues based on the strategies/rules used
- Compared the data in A/R Summary File (CSV and XML format) with the invoice extract and reported back critical issues
- Worked directly with vendor developers with all kinds of application bottlenecks such as initial load, incremental daily and weekly feeds, file extracts
- Worked on Pricing, Billing Engine, AR Reports, Discounts, Run-Out strategies, etc all related to claims and billing
- Created test scenarios based on requirements and for scenarios like Open Balance, Auto Post, Auto Apply, Finalize Payments, etc.
- Prepared various workarounds for data validation in case of a critical issue with file generation by MS Dynamics
Environment: - HP ALM 12.0, Microsoft Excel, Word, Microsoft SQL Server 2008/2012, UFT (QTP), SiteMinder, EDW, MS Dynamics, XML’s, DAPTIV PPM, Citirix
Confidential, Buffalo, NY
Quality Assurance Analyst
Responsibilities:
- Performed integration testing on inbound and outbound integrations between Oracle MDM and other existing application
- Performed functional testing manually and constructed positive and negative test scenarios as per requirements
- Conducted automated test cases using QTP for Oracle Applications, Recorded and wrote test scripts and created user defined functions in scripts
- Worked on Underwriting and Actuarial and Subscriptions for the specific number of clients/customers
- Worked on SharePoint 2010 to validate the file extracts and uploads (ETL) and performed regression testing
- Executed various Load Runner scripts and performed load tests such as stress test, endurance test and capacity test
- Worked with Developers for the critical code fixes which appeared with the functionality of the application
- Maintain and improve the automation framework used by the automation team
- Followed the Requirements Traceability Matrix (RTM) to track the requirements and prepare the test cases accordingly
- Used Descriptive Programming for developing test script and Functional libraries
- Performed Regression testing using automation tool Quick Test Professional
- Upgraded the regression suite streamlining the code, and improving robustness and repeatability
- Tested extensive backend testing using SQL Queries to retrieve the data from the database and checked data integrity
- Created test cases and scenarios for Unit, Regression, black box, white box, Integration as well as Back-end and GUI testing with QTP and reported/logged the defects to QC/ALM
- Analyzed ROI and made recommendations on capital project requests at various investment levels with Six Sigma and Lean methodologies
- Developed on overall project plan and implementation schedule via Six Sigma 5S methodology through consultations with project team, management, employees and external consultants
- Understood the process flow diagrams for flow of information and report creation process prepared by other Business Analysts
Environment: - Quick Test Professional 11.0 (UFT), QC 11.0, Microsoft Excel, Visio, Oracle PL/SQL, Oracle MDM, Toad 11.6 for Oracle, TFS, QTP Automation Framework, SharePoint 2010, HP Load Runner
Confidential, Miami, FL
Systems Analyst- Quality Assurance
Responsibilities:
- Assisted in documenting Job-aids to achieve consistency among various documents and processes
- Assisted in creating functional test plan for testing the application functionality as configured by the Business Process team for various module requirement of Oracle EBS
- Prepared the summary reports of the testing efforts, defects, issues, UAT, staging issues and provided to the manager on a weekly basis
- Used Test Director to track the Test cases and Test procedures developed and their execution status
- Preparation and execution of test scripts using JMeter to perform Web Services testing
- Customized QTP Scripts using VB Script and also created complex automated scripts in QTP
- Develop fully automated and portable QTP scripts and created reusable modules for the use of other testers
- Worked on Description Objects and Description Strings for various objects for the application which lies outside the object repository
- Designing a versatile automation framework for unattended/lights out testing
- Performed parameterization of the automated test scripts in QTP to check how the application performs against multiple sets of data
- Involved in analysis of Test Plans and Test cases, detecting bugs in the system, preparing the Defect reports using QC 11.0 interacted with developers for Debugging
- Created validation plan and validated the e-signature customization for Quality Centre tool
- Coordinated the Defect Disposition process with Quality, Technology and Business teams
- Developed Testing Analysis Reports (TAR) for every Test Plan executed individually for all applications
- Reviewed and analyzed the Business Requirements documents, Functional Specification document of the core application for a better understanding
- Analyzed and studied the impact of new system implementation on existing system
- Prepared UAT Materials, including the UAT Process, UAT Test document which included step-by step process for UAT as well as all the tests that covered all requirements
- Created and executed Load Runner scripts and reported the results to QA Manager
- Involved in writing Test Cases, procedures, reports and approval of software release
- Created test scenarios for Unit, Regression, Integration, black box, white box, Back-end, GUI and Black box testing
- Wrote SQL statements to extract data from the Tables
Environment: - Microsoft Excel, Visio, Oracle PL/SQL, HP Quality Center 9.0, QTP 8.2 (UFT), Oracle EBS Ver. R12, QTP Automation Framework, SharePoint, Load Runner
Confidential, Brisbane CA
Analyst- Quality Assurance
Responsibilities:
- Conducted manual testing using the Standards, guidelines and structured methodology in testing the application
- Involved in requirements analysis, testing, validation and ongoing support of the POS Suite
- Worked on validation (backend) of new coming Offers, discounts, savings etc and directly on the Servers, POS terminals (POS frontend simulator) with systemsecurity requirements along with ERP integration
- Documenting and executing Test plans, Test cases and Test scripts based on baseline requirements
- Tested monthly MS Security Patches, various smaller projects and several major releases ofPOS code for the parks and resorts
- Performed End-to-End testing manually and was associated with User Acceptance Testing
- Analyzed and documented Business Requirements and detail design of the software for a thorough understanding of the business prepared by Business Analysts
- Created changes in the objects, in the tested application’s GUI and in the testing environment using QTP
- Created Development Requirements, Technical Design, Test Plans, Traceability Matrix, Unit/Integration/ System Test cases and Use cases to explain the systems interaction with the users
- Documented business workflows textually as well as in UML diagrams (Use Case Diagrams)
- UAT Test Case Review and responsible for training plan, validation review and training material creation
- Review Change Control for significant scope changes & summarize for handoff of Benefits Verification Plan.
Environment: MS Excel, MS Word, MS PowerPoint, MS VISIO, UML, Load Runner, Oracle 9i,Oracle 11g Release 2, TFS, QTP (UFT), HP ALM, SharePoint, Vendor POS Suite System
Confidential
Business/Quality Assurance Analyst
Responsibilities:
- Assisted execution of test data and test cases
- Reviewed Business Requirements Documents and the Technical Specification documents
- Identified and Documented functional requirements and mapped them to individual test case requirements
- Managed and executed test cases and logged defects in defect tracking tool
- Documented test cases corresponding to business rules and other operating conditions
- Analyzed user requirements, attended Change Request meetings to document changes and implemented test procedures to test changes
- Wrote test plans, with detailed testing scope, test strategy and hi-level test requirements
- Executed SQL queries (Select statements) using TOAD for data validation
- Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools
- Involved in writing Test Cases, procedures, reports and approval of software release
- Worked on IBM Rational Rose for testing various applications
- Created test scenarios for Unit, Regression, Integration as well as Back-end, GUI and Black/White box testing
- Involved in analysis of Test Plans and Test cases, detecting bugs in the system, preparing the Defect reports using QC interacted with developers for Debugging
Environment: MS Excel, MS Word, MS PowerPoint, MS VISIO, SAP ERP 6.0, SAP Production, Oracle 9i/11g, Toad 11.6 for Oracle, QC 9.0, QTP
Confidential
Quality Assurance Intern
Responsibilities:
- Familiar with automation test tools for performance testing and execute those tests accordingly
- Assisted with workflow mapping for downstream processing of required data elements
- Updated existing test plans as part of regression testing efforts
- Worked directly with the technical writing team giving feedback to any updates needed to documentation prior to client delivery
- Provided daily status of issues and progress during testing of applications
Environment: MS Excel, MS Word, MS PowerPoint, MS VISIO, SAP ERP 6.0, SAP Production, Oracle 9i/11g, Toad 11.6 for Oracle