Lead Qa Analyst Resume
Lowell, MA
SUMMARY:
- Over 14 years of diversified experience in Business Analysis and quality assurance testing.
- Skills include Manual & Automated Testing on Client/ Server & Web applications maintaining applications in Data Warehouse using ETL tools Informatica and Data Stage.
- Expertise in Web Services testing with Rest API’s and SOAP web services using Eclipse and Selenium.
- Expertise in developing test automation frameworks using QTP and Selenium.
- Expertise in BI testing using Cognos, OBIEE and SSRS reports.
- Possess excellent skills in Automation Testing using Postman, SOAP UI, Selenium, UFT, Quality Center, HP ALM and Microsoft TFS tools along with manual testing that involves the whole SDLC process and continuous integration.
- Hands on experience in testing the Oracle ERP modules Oracle HCM, Oracle HRMS, Oracle Advanced Benefits, Payroll, Oracle Financials Iproc, AP, AR, GL, PO, FA, Quoting, OM and SC
- Good understanding in Oracle Fusion HCM modules Core HR, HDL (HCM Data Loader), File Based Loader.
- Worked both technical and functional aspects of Salesforce.com CPQO, Service Cloud, Sales Cloud and have deep understanding of its underlying principles of SAAS and Cloud Computing.
- Worked with Business Users to enable business processes using SFDC.
- Extensive experience in Functional testing, Unit testing, Usability Testing, Integration testing, Regression testing, GUI testing, Back - end testing, User Interface (UI) Testing, Ad-hoc testing, White Box Testing, Gray Testing, Black Box Testing, System Testing, baseline, Installation, Performance and Build Verification Testing.
- Experienced in analyzing Functional Requirement Specifications (FRS) and System Design Specifications (SDS).
- Tested Web Services call for their working and functioning and parsing XML documents.
- Experienced in RTM (Requirement Traceability Matrix) to know the status of the project.
- Preparing, documenting and implementing of test procedures, test requirements and test cases for full life cycle (SDLC) testing methodology.
AREAS OF EXPERTISE:
- Leading QA projects and QA resources
- Requirements gathering and gap analysis
- Requirements Traceability Matrix
- Coordination with product owners and developers
- Test Planning, Test Strategy, Test case development, Test case execution
- Defect Management and Triage with developers and business user community
- Functional, System, Integration, Regression, Backend testing and UAT testing experience
- SDLC, Waterfall, Agile Scrum Methodology
TECHNICAL SKILLS:
- Business/System Analysis
- Oracle ERP 11i & R12, HCM, HRMS, P2P and Q2C applications
- Requirements gathering and gap fit analysis
- SAP Financials and Supply chain applications
- Test Management & Defect Management
- Salesforce.com
- SDLC, Waterfall, Agile Scrum Methodologies
- Oracle BigMachines
- Collaboration & Business/IT Liaison
- Rev Pro application
- Time and Stress management skills
- Oracle database 9i, 10g, 11g, SQL Server, Javascript
- Interpersonal & Leadership skills
- EDW, Informatica and DataStage
- Computer system validation skills
- Sharepoint, ServiceNow
- Application support and problem solving
- QDoCS(documentum), V-Learn(LMS)
- Business communication
- DAC, OBIEE 10.1.3.2 and IBM Cognos Reporting
- Self-motivation & Team player skills
- Load Runner, Test Director/Quality Center/ALM, JIRA, SOLMAN, Rest APIs, SOAP UI, Micro soft TFS, QTP/UFT, LeanFT, Provar, Postman and Selenium.
PROFESSIONAL EXPERIENCE:
Confidential, Lowell, MA
Lead QA Analyst
Responsibilities:
- Gathered business requirements for Rev Rec project for test planning and test prep.
- Worked with business community to prepare user stories in Salesforce CPQO testing in agile scrum methodology.
- Created Leads, Opportunities, Contacts, Accounts in Salesforce and validated the integrations between Salesforce and Oracle ERP and EDW systems.
- Prioritizing and working on IT financial monthly release support testing CRs (oracle apps, EDW, Cognos, BigMachines, Open Air and Salesforce applications and database testing).
- Created Quotes, Service Contracts, Orders, AR Invoices, Journal Entries in GL for Q2C testing.
- Created Reqs, PO, AP Invoice, and GL transaction for P2P testing in oracle EBS.
- Validated invoices and service contracts to manipulate IB records in Installed base.
- Working on Buzon E upgrade project for Mexico invoicing.
- Tested Rest API’s to communication between Oracle EBS and Buzon E using Selenium.
- Tested all REST API methods (GET, POST, PUT and DELETE) and REST endpoint protocols.
- Validated all request and response from Oracle invoices and Buzon E
- Working on customer warehouse database upgrade from Oracle 9i to Oracle 11i.
- Creating test data for EDW nightly jobs and validating next morning data flown to EDW successfully.
- Tested various financial reports in Cognos using cognos reports studio and adhoc reports.
- Validated materialized views in EDW to master batch performance improvement.
- Created invoice automated regression suite using UFT.
- Organizing defects triage calls with cross functional teams to resolve the testing issues in timely manner.
Environment: Salesforce, Rest API, Selenium, UFT, Oracle APPS 11i, Purchasing, AP, Service Contracts, Quoting, OM, Install Base, AR GL, FA, Cognos, Oracle, TOAD and EDW, HP ALM.
Confidential, Waltham, MA
Agile QA Lead
Responsibilities:
- Coordinating and assigning tasks to all QA resources across Osprey (Albany, Dallas and Waltham).
- Participating all Scrum prioritization meetings to finalize the scrum requirements for the release.
- Participating in daily standup meetings to provide testing status update to project managers.
- Coordinating with PMs, BAs and Developers for release build status on QA environments.
- Tested Mappings worked with Staging area to validate the data with SQL Queries.
- Tested web services for quotes based on geographical are the request and responses from different providers.
- Supporting EBS end-to-end regression testing for different operating units.
- Testing billing process reports and escrow premium reports for different lenders in UniTrac self service.
- Generated reports form Citirx VUT machine and compared with UniTrac reports.
- Testing certificate authorization, quick issue and quick bills processing as part of release regression testing.
- Validating Lender file processing in staging and QA environments.
- Created automation scripts for web services using Selenium and extensively used XML and X Path filters.
- Developing regression suite for web services testing using Selenium.
- Proficiency in using Filters, Assertion and Subs processes using Selenium.
- Validated customer data in XML files and different file formats like (text, .CSV, flat files).
- Reconciling the data between VUT and UniTrac applications.
- Working on reports regression suite development using Selenium.
- Sending daily testing and defects status (Matrix) reports to senior project management team.
- Facilitating daily issues triage meeting with developers and business users.
Environment: Oracle APPS R12, Iproc, PO, AP, OM, AR GL, FA, CE, Visual Studio 2010, SQL server 2008, SSRS, TFS, VB scripting, C#, .Net, QTP, Selenium, Citrix client, Windows XP
Confidential, MA
Oracle EBS Test/Validation Lead
Responsibilities:
- Managing onsite testing resources to drive Saleforce.com, OBIEE, SharePoint Collaboration, EBS Regression and Enhancements Projects testing vertex's drugs commercialization across the globe.
- Gathered business scope and technical requirements for System Life Cycle plan for EBS 2011-Release3, 2012 Release 1 and 2012 Release 2.
- Gathered business scope and technical requirements for System Life Cycle plan for OBIEE Financials Analytics project for phase1 and Procurement & Spend Analytics for phase 2.
- Gathered business scope and technical requirements for System Life Cycle plan for Salesforce.com CRM Project.
- Gathered business scope and technical requirements for System Life Cycle plan for EBS AP Invoice Approval using AME.
- Developing EBS regression suite using OATS tool.
- Prepared Test Plan and Test Strategy for OBIEE Financials Analytics and Procurement & Spend Analytics.
- Prepared Test scripts and different Test scenarios for OBIEE project.
- Supported and performed all the CRP/system testing, UAT and performance for OBIEE.
- Validated all the dashboard reports and Subject Areas in OBIA with existing EBS/Noetix reports.
- Prepared Test Plan, Test Strategy and Functional Test cases for Internal and external document sharing and storage (SharePoint).
- Driven the all test status checkpoint calls and defect resolution meetings on daily basis for all projects under me.
- Created and updated Regression test scripts for EBS regression suite.
- Performed System testing and Regression testing on different environments Worked with development team to ensure testing issues are resolved.
- Prepared Test data for positive and negative test scenarios for EBS testing in DEV1 and EBS VAL environments.
- Tested different types of invoice holds and Escalation notifications in AP Invoice Approval using AME project.
- Closely monitored and escalated on Critical and High defects and logged in e-Room.
- Created a test evidence report for SLC Doc Listing Report test script.
- Executed the QDocs cabinet script in VAL environment.
- Coordinating with business to complete the testing with in the time line.
- Created Reqs, POs, Receipts and Invoices to complete the P2P cycle testing in VCAN.
- Created project related POs to specific vendor site to support the EBS VAL testing for HR family pack in UAT.
- Tested all the concurrent programs in Oracle HR (Delta, BCBS, 401(K), Ceridian, ESPP, Flex Spending and Personal Life Insurance) as part of EBS Regression testing.
- Tested New Hire, Emergency Contacts and Dependents, Change of Address, Salary Change (Fast Path), Transfers, Promotions/Demotions and Enroll in Benefits processes in Oracle HR.
- Coordinating with developers and business as well to resolve the issues during the UAT.
Environment: Salesforce.com, Configuration, Visual Force, APEX classes, Oracle EBS 11.5.10, IProc, PO, AP, GL, CE, Oracle HR, Advance Benefits (AB), OPM and FA, Informatica, OBIEE, DAC, QC, QTP 10.0, OATS, QDoCS, JIRA, Windows XP, Toad, Ms-Excel, ASP.Net, MS-SharePoint, SOPs.
Confidential, MD
Lead QA Automation
Responsibilities:
- Gathered business scope and technical requirements for System test plan.
- As a QA Lead, responsible for working with the team manager, other team members and business users for the data analysis.
- Involved in Preparation of automation Test plan and test strategy for Data Driven Framework
- Identified core Modules, sub-modules, functions and sub-functions for reusable functionality for Automation framework.
- Used Quality Center as a central Library for all QTP shared Object repositories and reusable functions.
- Performed different types of Customer Acceptance, Functional, Build verification testing.
- Performed System testing and Regression testing on different platforms and web browsers Worked with development team to ensure testing issues are resolved.
- Prepared Test data for positive and negative test scenarios for Manual, QTP as Documented in the Test plan.
- Closely monitored and escalated on Critical and High defects in Quality Center.
- Participated in weekly defect resolution meetings with developers and test team.
- Automated the installation of daily builds using QTP and implemented regular expression verification.
- Used Quality Center for development, execution, and maintenance of Test plans, Test cases, Test scripts, Test specifications and Test scenarios for both manual and automated tests.
- Used Quality Center for the entire defect lifecycle- from initial problem detection through fixing the defect and verifying the defect.
- Prepared frameworks for both windows applications and web based applications.
- Optimized QTP scripts for Regression testing of the application with various data sources and data types .
- Managing all QA related projects, and ensuring the all QA & development deliverable are delivered in the most timely and efficient manner possible
- Tailoring, implementing, and utilizing enterprise ISQA processes and tools.
- Managing all verification and validation (V&V) activities for all Production modifications including projects, releases, and changes.
- Created Requirement Traceability Matrix between Requirements and Test Cases.
- Executed User Acceptance Test Plan on completion of system testing before installation of the application in production environment
Environment: HP Quick Test Pro 10.0, HP Quality Centre 10.0, Visual Basic 6, SQL Server 2008, VB.net, ASP.net, SharePoint and Windows XP.
Confidential, St Louis, MO
Data warehouse (ODS/BDW) Test Lead
Responsibilities:
- Actively involved in Plans for integration testing the System Development Life Cycle (SDLC) in the "real world" environments for which it is intended are developed.
- Generated QC report and reported to project management every day on the defect status.
- Identified Facts, Dimensions, and grain of the Dimensional modeling in Informatica.
- Identified the source tables, source columns, and referential joins using Data stage Tools.
- Performed Integration testing, Functional testing, performance testing and user acceptance testing (UAT) support to validate report, mapping.
- Tested Informatica Mappings worked with Staging area to validate the data with SQL Queries.
- Ran the ETL jobs in Unix on ODS and BDW environments for P1226 (Supervision project).
- Validated the data is correctly loaded or not in the ODS and BDW tables.
- Designed Test plans and Test cases for testing the application.
- Performed front end as well as back end testing.
- Involved in several meetings to solve the Critical and High Issues with Developers and Business Team.
- Created test strategies that increase test coverage, validate scalability, failover and recovery and improves quality
- Maintained real time log of executed tests, results and environment history and review with cross functional team.
- Extensively worked on Onsite and Offshore models.
- Ability to develop and execute effective Test strategy plans for quality management.
- Used Quality center’s web defect manager to report defects found during MOCK testing Cycle for data conversion.
- Involved in testing during migration phase of different applications and database.
- Participated in scheduling of target dates for resolving defects, prioritizes and monitors activities to meet such dates by release.
- Provided assessment of project quality at key milestones to project leaders, QA and management.
- Assisted training to new testing team members as needed Involved in reviewing Cross Area Defect Process (BETA, Channel, HO, FSG, BSG and HD Vest)..
- Used Quality Center for development, execution, and maintenance of Test plans, Test cases, Test scripts, Test specifications and Test scenarios for both manual and automated tests.
- Participated in agile/scrum process - scrum team meetings with MOCK team.
Environment: Mercury Quality Centre 9.2, Informatica 8.1, PL/SQL, Oracle 11i, Toad, DB2, Visio, MS Excel, UNIX SHELL scripting, SDLC.
Confidential, Hartford, CT
Lead QA Analyst
Responsibilities:
- As a QA Lead, responsible for working with the manager and other users and creating Work flow diagrams as per the data analysis.
- Involved in working on several E-commerce applications within the project environment.
- Prepared Test data for positive and negative test scenarios for Manual, QTP as Documented in the Test plan.
- Automated the installation of daily builds using QTP and implemented regular expression verification.
- Wrote Use Cases, Test scripts, Business process flows as per the URS and FRS
- Developed and delivering business requirements (BR) documentation.
- Delivered business systems design (BSD) documentation.
- Created Risk Management Plans that included documenting contingency plans, risk mitigation and transference of secondary risks.
- Performed Data analysis and generating Datasets for quantitative analysis.
- Drafted the Remediation Plan for the Project Management approval after Gap Analysis.
- Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
- Validating the Target data based on the test cases.
- Preparing the process flow diagram for ETL Jobs.
- Tested request and response using soap UI for claims processing.
- Created Risk Management Plans that included documenting contingency plans,
- Risk mitigation and transference of secondary risks.
- Involved in validating XML files.
- Generated XML data files using XML Spy.
- Validated the sessions, cookies and security for Web Portals.
- Tested the Web Portals for HTTP errors.
- Tested the applications on different Web Browsers.
- Tested and Validated SOAP Web Services.
- Performed Data analysis and generating Datasets for quantitative analysis.
- Drafted the Remediation Plan for the Project Management approval after Gap Analysis.
- Conducted Functionality, Interface and Regression testing during the various phases of the development using Mercury Tools (Quick Test Pro/Load runner)
- Maintained the Requirements Tractability Matrix (RTM).
Environment: XM, SOAP UI, Data Stage 7.5-Designer, Oracle Apps 11i, AP, AR, GL, FA, DTS, JAVA, J2EE, MS-SharePoint, Microsoft Excel, Oracle, SQL, Toad, QTP, VB Script, QC 9.2, Windows NT, Unix and Windows 95/98/NT/2000.
Confidential, Andover, MA
SAP QA Analyst
Responsibilities:
- Gathered business scope and technical requirements for Master test plan.
- As a QA Lead, responsible for working with the project manager, other team members and business users for the data analysis.
- Prepared the detailed system test plan for functional and regression testing.
- Involved in Preparation of Test approach and test strategy for system testing.
- Created Z-tables in M41 SAP kernel and validated in MCP kernel (industrial instance of SAP).
- Created SW warrantees and hardware warrantees in MQ3 SAP system.
- Tested a SW/HW instance’s initial & upgrade information in one record.
- Tested separate SW & HW Installed Base Information in MP1 (commercial instance of SAP).
- Created end to end automations scripts for O2C (Order to Cash) modules using QTP.
- Involved in testing of Software Product configuration in the installed base for entitlement.
- Tested changes to Equipment Master Structure to support enhancements to installed base.
- Used QC as a central repository for Requirements, Test plan, Test execution and defect management.
- Used TeamTrack as a internal Philips defect management tool.
- Participated in defect review meeting with Dev team to resolve the critical and high severity defects.
- Supported business users in User Acceptance Testing.
Environment: SAP R/3, ECC 5.0, HP QTP 9.0, HP Quality Centre 9.0, TeamTrack, Windows XP, SharePoint
Confidential, CA
Sr QA Analyst
Responsibilities:
- Involved in performing Testing tasks such as testing extensive PL/SQL
- Programs units like procedures, functions, triggers, packages.
- Tested interfaces for Accounts Receivables module.
- Exclusively tested descriptive flex fields through out apps
- Perform testing AOL activities like creation of Value sets.
- Tested customized reports relevant to the needs of the organization.
- Used QC as a central repo for test management.
Environment: Oracle Apps 11i, Pl/SQL, Toad, Quality center 8.2, Windows XP professional, VB Scripting
Confidential
SAP QA Analyst
Responsibilities:
- Analyzed system specifications and involved in creating Performance test plan for the testing
- Developed Test Scenarios against Software Requirement Specifications
- Prepared Test data for positive and negative test scenarios for Load testing as documented in the Test plan
- Involved in complete development of Software Development Life Cycle (SDLC)
- Involved in Performance, L oad and Stress Testing using Load Runner
- Created the Test Scripts based on the End-User Transactions
- Designed scenarios and used LoadRunner Controller to monitor all vusers in a scenario from a single workstation.
- Did payment run testing and ensured automatic payment work well with SD, and MM.
- Tested transactions for Logistics Invoice Verification, GR/IR Account Clearing, Issuing Invoices and Credit memos.
- Validated invoice with PO price and GR quantity by using 3way matching process
- Used Quality center for the defect reporting and tracking
- Created Requirement Traceability Matrix between Requirements and Test Cases
- Executed User Acceptance Test Plan on completion of system testing before installation of the application in production environment
- Used all ISO 9001 and SEI-CMMI level methodologies
Environment: Mercury LR 8.0, QTP 8.2, Quality center 8.2, Windows XP Professional, SAP ECC 5.0 and ABAP/4
Confidential
QA Analyst
Responsibilities:
- Gathered requirements using Use Case analysis and modeled component based system using the UML (Functional models, Object Models, Dynamic models).
- Analyzed system requirements and Involved in preparation of Test Plans for different modules and documented test cases for various screens of the application.
- Performed load testing of the application by creating virtual users using LoadRunner.
- Executed Regression Testing by repeated execution of recorded test procedures to identify errors in each modified build in the process of testing.
- Inserted check points to verify the correct behavior of GUI objects.
- Involved in Back end testing such as validating data sets, importing data sets for different customers.
- Responsible for identifying the functional test cases for Regression Testing and automated these scripts using Win Runner.
- Used Win Runner to conduct Data Driven Testing by pulling data from a table.
- Worked closely with the application developers who created databases, Tables, Indexes, Sequences, Views and involved in loading Data using SQL.
Environment: Test Director, LoadRunner, WinRunner, SQL Server, PL/SQL, Oracle, UNIX, Windows 95/98/NT/2000, J2EE.