We provide IT Staff Augmentation Services!

Qa Lead-data Validation Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Having 17+ experience in Quality Assurance with Planning, Managing, coordinating and testing of Mainframe (JCL, CICS), Web, Retail, E - commerce, ETL, Data Warehouse, ERP and Client/Server based software applications with both Manual and Automation.
  • QA Testing experience ranges in Financial, Securities Trading, Capital Markets, Mortgage and Telecom Companies.
  • Analyze System requirements, Detail designs, Business Rules and Interface Mappings and develop test strategies.
  • Provide estimations and plan resources for the project.
  • Prepare and review detailed Test Plans, set timelines and setup test environment.
  • Expert in functional testing involved in System, Acceptance, Pair, ETL, E2E (end to end) and Regression testing.
  • Create traceability matrices by associating the requirements with testing.
  • Prepare data requirements well in advance and execute the tests timely and report defects.
  • Strong analytical, problem-solving, and organizational skills and attention to detail.
  • Excellent written and verbal communication skills.
  • Expertise in backend and ETL Data Warehouse testing using SQL complex queries
  • Supervise, assign, train and monitor testing groups onshore and offshore.
  • Automation Testing using QTP, Selenium, HP ALM, Rational, Win Runner and other tools.
  • Strength in conveying technical information to non-technical team members and clients.
  • Efficient and accurate work under deadlines and on multiple simultaneous projects.
  • Excellent skills in dealing with end users and developers to discuss the user requirements and functional specifications
  • Involved in following the rigorous system development life cycle (SDLC) and project management best practices, comply with internal Sarbanes-Oxley (SOX) and other processes related to compliance requirements.
  • Having background working with the clients to define processes and develop requirements and to translate the business needs and document them

TECHNICAL SKILLS:

LANGUAGES: C, VISUAL BASIC, JAVA, HTML, XML, SQL, SOAP

DATABASES: ORACLE, DB2 AND MS ACCESS, SYBASE, Hadoop, SQL Server

OS: WINDOWS NT, WINDOWS 95/98, UNIX, MAIN FRAME

ERP: PEOPLESOFT, SAP, Siebel

SOFTWARE: MS OFFICE, MS EXCEL MACROS, UFT/QTP, Selenium, COMPUWAREWIN RUNNER, TEST DIRECTOR, QTP, UFT 11.52, Selenium, QUALITY CENTER (QC), HP ALM 12.20, Clear Quest, Oracle Metasolv6.0, SalesLogix, DOORS, RALLY, JIRA, Clear Case, TSO, XML SPY, RSW Software, Abnitio, ETL, AutoSys, BRIO, Crystal &BOXI Reports, BI and Business Objects.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

QA Lead-Data Validation

Responsibilities:

  • Analyzing the requirements, mappings, design documents and participate in meetings with business analysts and data architects& Engineers.
  • Prepare Test Strategy, Test plan, design and write high level scenarios for different countries, different brands & languages and manage 1 offshore resource to write detail test steps and review with Project team.
  • Expert in creating and maintaining automated test scripts and Quality Assurance and Quality Control Methodologies and mainframe testing majorly with JCL, CICS and Batch environment.
  • Perform validation against counts and values in Hadoop and also verify the front end systems for Changes and coordinate testing with offshore as per the sprints.
  • Uploading the test cases, create project in ALM, create cycles, open the defects in HP ALM, Create new JIRAs, reopen JIRAs, Update comments in JIRA, assign and follow up on resolution.
  • Updating the JIRA and ALM with test results with attachments.
  • Providing the appropriate data to UAT timely and support for their execution in war room and receiving sign off for each user story.
  • Participate in Daily project meetings and provide Daily Status to QA management & Project Management.

Environment: SQL Developer, Hadoop, Tableau, HP ALM 12.01, JIRA, OMS - Call center, POS, Console, ANF web application, XML API, BI, UNIX, JCL, CICS, Batch environment, SQL server, DB2, ALM, Load Runner.

Confidential, WARREN, NJ

Senior QA Analyst

Responsibilities:

  • Attend project change reviews, which include SFO, INVOICE changes and billing calculation rating changes for voice, text and 3G, 4G data with various ESN and IMEI, taxes. Etc.
  • Analyzing the Requirements, Technical design documents, Business Rules & Interface mappings and writing test cases, Test Plan with test strategies and data requirements.
  • Reviewing the test cases and the test case plan with business and development and upload the test cases to HP ALM and receive Signoffs from UAT.
  • Creating the data using the Front End ACSS, POS and verifying XML APIs, oracle data base using SQL for back end testing, verifying inbound and outbound files/results from other interfaces for new, change disconnect, reassign, change MTN, transfers, suspend and other change orders.
  • Testing POS application for new and existing customer orders with devices, new plans, features, promotions and discounts and verify their invoices for both residential and business types.
  • Performed POS transactions in the lab on the terminal with all connections with cash register, scanner and printer. Perform various transactions like new activations, change plans, change devices, add lines, buy accessories, Exchanges, returns and refunds with promotions and discounts, payments with cash, credit, debit, gift cards and verify receipts for both residential and business customers. And also verify that these orders are activated and their invoices are correct after the billing jobs are run and also make sure that the tables are updated correctly and also verify the downstream files
  • Create Data and Voice rating requests for the test MTNs and verify the Billing Information after bill cycles are run in Test environment.
  • Verify Booking and GL information for various products with the changes after the bill cycles are run.
  • Create defects using ALM with needed logs and screen shots and follow up with development, retest and close.
  • Manage projects with both Onshore and Offshore teams.
  • Coordinate and provide test data to UAT, once testing is complete receive sign off from UAT.
  • Provide test projections (execution plans), status and update share point during different phases of testing and their results, escalate any issues to the management.

Environment: ORACLE, JAVA, .NET, SQL, XML, DVS, POS, Clarity, Mainframes, JIRA, Toad, HP ALM 12.20 and MS Office, JCL, CICS, Batch Environment, DB2, Automated test scripts, QC, QA.

Confidential, Parsippany, NJ

Senior QA Analyst

Responsibilities:

  • Review the Change requirements for the upcoming release.
  • Develop functional and BPT test scripts and review with team.
  • Determine the Timelines for coding the QA Automation scripts plan and discuss progress with QA Manager.
  • Develop new scripts for the new changes and also modify the existing scripts for the GUI Changes, etc.
  • Involved in developing Data for the scripts and update the scripts in Test Plan for BPT test cases for automation.
  • Execute the regression test suites for the patch releases for the ongoing production problems and track everything using ALM.
  • Provide daily status to the QA Manger.

Environment: JavaScript, IE, Firefox, ALM 11.53, UFT 11.52, Windows 7, MS Office 2013, Clear quest

Confidential, Atlanta, GA

Test Lead

Responsibilities:

  • Attend business review meetings for new enhancement changes.
  • Assigns test scenarios to the test analysts for preparing test scripts/test cases.
  • Review test scenarios, test cases and steps internally and also with external teams.
  • Complete all action items and Involve in Test design, Test Execution and Defect Reporting/review activities using ALM.
  • Interacts with the test team in exchanging status and resolving all concerns and issues.
  • Plans and monitors all testing related activities and escalate blocking issues. Manage and support ad hoc requests on priority basis.
  • Verify XML APIs and SOAP APIs for preorder and order transactions.
  • Coordinate and have daily sync up calls with off shore team and coordinate testing and provide status.
  • Attend daily defect triage meetings with development and business and update the defect status and assign in ALM.
  • Provide assistance to business users for testing and also verify the results of UAT.
  • Monitors success of deployment every week, coordinate, complete smoke test using Selenium scripts and provide summary results. Involved in developing Framework, new scripts and enhancements.
  • Perform Functional and E2E testing for selected OSS/BSS products using Sage SalesLogix, IQ, Provisioning System MetaSolv and Oracle OSM (Order and Service Management).
  • Coordinate and prepare environment downtime tracking sheet every week on share point and show the down time in graphs.
  • Provide status using metrics o the upper management
  • Plans for Training activities for the team on project specific procedures and standards and coordinate the knowledge transition activities.

Environment: ALM, Windows 7, SOA, MS Office 2013, Sage SalesLogix, iQ, SOAP API, XML API, Provisioning System - Metasolv Solution (M6), Oracle Order and Service Management (OSM), DB Visualizer 9.1.2., Citrix, Selenium, Selenium Grid, Java, Test NG, Jenkins, WebDriver, DB2, AS 400.

Confidential, WARREN, NJ

Senior QA Analyst

Responsibilities:

  • Attend project change reviews, which include SFO, INVOICE changes and billing calculation rating changes for voice, text and 3G, 4G data with various ESN and IMEI, taxes. Etc.
  • Analyzing the Requirements, Technical design documents, Business Rules & Interface mappings and writing test cases, Test Plan with test strategies and data requirements.
  • Reviewing the test cases and the test case plan with business and development and upload the test cases to Quality Center and receive Signoffs from d
  • Creating the data using the Front End ACSS, POS and verifying the oracle data base using SQL for back end testing, verifying inbound and outbound files/results from other interfaces for new, change disconnect, reassign, change MTN, transfers, suspend and other change orders.
  • Create Data and Voice rating requests for the test MTNs and verify the Billing Information after bill cycles are run in Test environment.
  • Testing POS application for new and existing customer orders with devices, new plans, features, promotions and discounts and verify their invoices for both residential and business types.
  • Performed POS transactions in the lab on the terminal with all connections with cash register, scanner and printer. Perform various transactions like new activations, change plans, change devices, add lines, buy accessories, Exchanges, returns and refunds with promotions and discounts, payments with cash, credit, debit, gift cards and verify receipts for both residential and business customers. And also verify that these orders are activated and their invoices are correct after the billing jobs are run and also make sure that the tables are updated correctly and also verify the downstream files.
  • Verify Booking and GL information for various products with the changes after the bill cycles are run.
  • Create defects using ALM with needed logs and screen shots and follow up with development, retest and close.
  • Coordinate and provide test data to UAT, once testing is complete receive sign off from UAT.
  • Provide test projections (execution plans), status and update share point during different phases of testing and their results, escalate any issues to the management.

Environment: ORACLE, SQL, XML SPY, DVS, POS, Clarity, Mainframes (JCL, CICS, Batch Environment), Toad, Quality Center 11 (HP ALM) and MS Office

Confidential, Herndon, VA

QA Lead

Responsibilities:

  • Attend Business requirements, High level Design reviews and Integrity Rules meetings.
  • Prepare data sheets for Loan Setup with various combinations required for testing, test scenarios, test cases, queries and expected results.
  • Review test scenarios, test cases and queries internally and also with external teams.
  • Provide meeting minutes after external review and complete all Action Items and also upload test cases to Quality Center.
  • Prepare and coordinate with team in setting up data using XML data files.
  • Decide Test Environments and co-ordinate Progression Testing and regression testing.
  • Manage execution run instructions for each Release and co-ordinate testing of PME Treasury reports.
  • Provide ER sheets, RTMs for each project and also consolidate the documents using Clear Case.
  • Verify the ETL Job instructions for each release, co-ordinate and prepare steps to run them in sequence and add them in Run Instructions along with daily, weekly, Monthly and EOC Jobs.
  • Verify the results in transactional database after ETL jobs run. Review the results, errors, job failures and advice on restores.
  • Open defects, provide defects list to the DRB coordinator and discuss the resolution with development &Business teams.
  • Managing a test team - assigning tasks, clarifying requirements, review test cases and data requests, providing overall status to upper management.
  • Also involved in testing the risky mortgages from loan originators (LOS) that come from LoanSphere Empower and then transfer the mortgage loans to a trust that entitles the trust beneficiaries to interest and principal of the mortgage loans.
  • Support automation team with execution of QTP scripts for different months of loan setup data in to the system and also identify the fixes need for current release.
  • Attend CRB and DRB meetings and assign new change requests to appropriate team member, provide defect status and other test info to the test team.
  • Provide status using metrics to the upper management
  • Involved in testing reports from data warehouse for couple of releases using Informatica using different dimensions.
  • Validation mainly involves testing the Business Objects/Crystal Reports and verifies the data using queries in Transactional and Data Warehouse (DW) for each baseline.

Environment: ORACLE, SQL, XML SPY, Abinitio, AutoSys, Clear Case, Clear Quest, DOORs, RALLY, BI, BOXI and Crystal reports, ETL, Informatica, Toad, QTP, Quality Center and MS Office.

Confidential, NY

Sr. Quality Assurance Engineer

Responsibilities:

  • Act as a Test Project Manager (TPM) for Main Frame Application- CACTUS and web applications- StreetScape, Oneview, Advisor Channel & Alternative Investments.
  • Review the Change Control CRs, provide test estimation, budget, and plan resources for the upcoming release.
  • Analyze Requirements, design documents, flow charts & Interface mappings and plan testing well in advance.
  • Prepare TPM Checklist, Test Chronology, SIT Test Strategy, Test Plan, Traceability matrix, TestCases, upload approved test cases to Quality Center and Coordinate testing.
  • Involved in developing the test scripts using QTP for Trading, Multicurrency, Redemptions, and Voluntaries. Etc. for Shado Suite, Update and run the scripts for each release and also for Production weekly releases and analyze results. Creating test scripts by recording the business process, adding check points & Data imports from databases, updating automated scripts using Microsoft VB script language for functional testing and data driven testing, Executing the automated scripts and report the failures are some of responsibilities.
  • Attend weekly meetings and discuss progress with Project Manager, Business Analysts and developers.
  • Create test data requirement sheets and also setup/search data minor & data base for appropriate data prior to testing.
  • Coordinate testing with overseas (India) testers and also execute the tests in appropriate test environment and track defects via ClearQuest.
  • Provide daily status to the project team and participate in defect triage meetings and help to resolve issues during testing time line.
  • Share knowledge of the changes of the system with UAT team and support them.
  • Provide weekly QA progress reports to the upper management and also monitor the budget for the projects.
  • Involved in testing various other projects and verified various reports using TSO and discuss the results with business.
  • Provide SIT completion report document, participate in Go/NoGo meetings and also provide metrics for SIT, UAT & Production defects for each project.
  • Participate in preparing QA budgets for upcoming releases for future year.

Environment: CACTUS (Mainframe application), Rumba Mainframes, Oracle, SQL Server, DB2, Web Logic, IIS, MQ Series, MS Office, Windows NT, TSO, Rational and Mercury Tools-QTP, Quality Center, Clear Quest, ReqPro, JCL, CICS, Batch environment

Confidential, Mclean, VA

Quality Services Test Lead Analyst

Responsibilities:

  • Lead the testing effort for Treasury Class a Applications- Wall Street Systems (WSS).
  • Review the Change Order documentation for the upcoming release.
  • Prepare Test Plan, Test Cases and Coordinate testing.
  • Create and maintain all testing documents in accordance with QS and IT SDM standards. Ensure that all documents are in the approved QS document repository.
  • Determine the Timelines for each test plan and discuss progress with Project Manager, Business Analysts and developers.
  • Create test schedules (Cycle Dates) and take data back ups and run COAs.
  • Prepare test environment with the required data and use appropriate system date.
  • Ensure that defect management processes are implemented and followed throughout the test execution phase.
  • Preparing test environment with production backup, Execute Trades, run COA, validate the results and generate G/L Extracts, run final load daily and verify BRIO reports, validate and also get approval from Accounting.
  • Involved in maintaining robust reporting capabilities, integrating and maintaining at the centralized location (Clear Quest) for reviewing their controls, testing status and the end user approval notifications for the Audit purpose as per the Sarbanes compliance standards.
  • Run the QTP scripts (Regression Suite) for every release with current cycle dates and analyze the results and update some scripts with changes.
  • Prepare documentation with the standards while writing the test plans, test cases, Test Steps and metrics as per the SOX Compliance and also attach them to the Clear Quest Ticket.
  • Worked with SCM (Software Configuration Management) to ensure compliance with Sarbanes-Oxley to improve corporate governance for a Third Party package Wall Street Systems.
  • Update Clear Quest System with the documents and results.
  • Notify and receive testing complete approvals
  • Report progress to Quality Services CIS test team and Treasury BIO/ESIA management.

Environment: Wall Street Systems, IE, Netscape, Oracle, SQL Server, DB2, Web Logic, IIS, MQ Series, MS Office, Windows NT, UNIX, Rational and Mercury Tools- QTP, Quality Center, Mainframe (JCL, CICS, Batch environment).

Confidential, VA

Sr. QA Consultant

Responsibilities:

  • Review the Change Order documentation for the upcoming release.
  • Prepare System Design and Detail Design documentation for the QA Section.
  • Attend and involve in the review meetings for the Change Order, System Design, Detailed design with NPAC Development Team (GUI team, Database development, Developers, Business Users, QA Analysts, Project Manager) and also review, identify the issues and status the remarks for QA section.
  • Determine the Timelines for coding the QA Automation scripts plan and discuss progress with Project Lead and QA Manager.
  • Develop new scripts for the new changes and also modify the existing scripts for the GUI Changes, etc.
  • Involved in developing Perl and shell scripts for new functionalities and called them in the new Win Runner scripts.
  • Execute the regression test suites for the patch releases for the ongoing production problems and track everything using Test Director.
  • Involved in developing the shell scripts for some backend processes involved in testing.

Environment: JavaScript, IE, Netscape, Oracle, SQL, DB2, Web Logic, IIS, MQ SeriesMS Office, Windows NT, Perl scripts, UNIX, Win Runner 7.6, Test Director

Confidential, NY

QA Project Analyst

Responsibilities:

  • Review the Process Control documentation for each of the process written for SOX Compliance.
  • Interact with Business Users, QA Analysts and Developers for each Process, identify the Key Financial Controls and derive business requirements when documentation is unavailable.
  • Determine the Timelines for each test plan and discuss progress with Project Lead and QA Manager.
  • Develop the test strategy for each process and prepare SOX regression test plan for each Process.
  • Develop test cases for various key IT financial controls and document them in to Compuware Automation tool (QA Center, QA Director) by creating Test Procedures and Test Scripts.
  • Interact with Test Environment Team to identify the test environment information for each process.
  • Interact with Data Team to identify and copy static data from Production database to the test environment.
  • Review the test plans with Internal, External, IT Controls Team and Audit Teams and receive approvals.

Environment: IBM Mainframe (JCL, CICS, Batch environment), PeopleSoft, Siebel, JavaScript, IE, Netscape, Oracle, SQL, XML, DB2, Web Logic, IIS, MQ Series, MS Office, Windows NT, UNIX, Compuware.

Confidential, NJ

Sr. QA Tester/Team Lead

Responsibilities:

  • Attend actively reviews for System requirements, business rules, Detail designs and E2E mappings for the application and provide feedback and approve the requirements
  • Analyze requirements/Business Rules/E2E mappings well in advance, writing test plans with test conditions to setup the required data in various external & internal systems for both Order and Pre Order functions, develop test strategy, set the timelines and setup request for test environment.
  • Prepare, consolidate and review detailed test plans internally and also with external partners.
  • Execute test conditions in System & Pair test and report defects.
  • Involved in developing various shell scripts and stored procedures to move services orders into different states and status’s for system testing purpose.
  • Writing UAT test plans and detailed test conditions for UAT testing. Preparing data setup requests for UAT testing and send the data setup requests to internal and external systems well in advance. Executing the test conditions in UAT environment, reporting the defects, retest and close the defects and track the defects using MS Access.
  • Verify connectivity information with all interfaces and make sure that environment is ready for test using Level 0 testing method in e2e test environment.
  • Supervise, assign, train and monitor a test teams of 6-10 people and consolidate test plans, defect and status reports.
  • Execute the test conditions and receive & process responses. And also verify that all systems involved were able to check the transactions using logs.
  • Execute regression test cases and also update the test cases for future release with the current release upgrades
  • As a team lead for two years, coordinated many testing efforts involving System Testing, API testing, Automation testing, UAT testing, pair and integration testing. Reporting requirements, set time lines, consolidate test plans and mentor test groups are primary responsibilities.
  • Report the defects timely and make sure the defects are fixed and the testing is complete within the timeline and report any risk factors to the upper management

Environment: JavaScript, IE, Netscape, XVT, Oracle, SQL, XML, XML SPY, DB2, SQL Server, Web Logic, IIS, SOAP, XML, MQ Series, MS Office, Windows NT, UNIX, Win Runner & Test Director.

We'd love your feedback!