SUMMARY

• Currently engaged in QA projects at Confidential in St Louis, Missouri, as a Senior Software QA Analyst.
• IT experience for over nine years through the diversified fields of Software Development Life Cycle (SDLC) in analysis, design, development, installation, deployment and testing in the projects under Waterfall and Agile methodologies.
• Qualifications include five years in QA and software testing experience in Web based, client server, desktop and legacy applications and four years of software development and user - acceptance testing experience.
• Expertise in using testing tools ALM, QC 10.0, QTP11, Rally and exposure in Selenium.
• Proficient in different phases of testing like Black Box, White Box, Functionality, Unit, Integration, System, Modular, Backend, Load, Regression and User Acceptance testing.
• Expertise in preparing Application Test Strategy (ATS), Requirement Traceability Matrix (RTM), Project Test Plan(PTP), Execution Cycle Plan, Test Scenarios and Scripts.
• Sound knowledge in automation testing using HP Quick Test Pro.
• Experience in executing and debugging automated test scripts in HP QTP.
• Good experience with SQL queries for data verification in Oracle and other RDBMS.
• Experience in projects under Agile Methodologies, Scrum calls, Sprint planning and tracking test execution status through Rally.
• Hands on experience with GAP Analysis, Impact Analysis and Risk Analysis.
• Exposed to the various business domains such as insurance, banking, healthcare, telecom, agriculture, transaction processing, energy and education.
• Excellent management skills with proven ability in mentoring and leading the offshore teams.
• Self-starter, pro-active and comfortable in a high intensity and challenging work environment.
• Highly motivated, with the ability to work independently and as a part of the team with excellent technical, analytical and communication skills.

TECHNICAL SKILLS

Software Testing Tools: HP ALM, HP Quick Test Professional (QTP), HP Quality Center, Rally, CA Service Virtualization, Selenium.

Programming/Scripting skills: SQL, C, Java, PL/SQL, MSSQL, HTML, JavaScript, VB Script, Unix Shell script, JCL, COBOL, XML, Base SAS.

Web Technologies: HTML 4.0, and DHTML, Java,HTML, FrontPage, and Flash Web Servers, Web Logic, SOAP UI.

Mainframe Technologies: Mainframes (ISPF, DB2, IMS, File Aid), AS400.

Databases: DB2, Oracle, SQL server 2008 R2, VSAM.

Operating Systems: Windows NT, 2003 & XP, MVS OS/390, UNIX.

PROFESSIONAL EXPERIENCE

Sr. Software QA Analyst

Confidential, St Louis, MO

Responsibilities:

• Performed requirement analysis and understood the functional/business requirements.
• Estimated efforts and prepared tier 1/tier2 estimation for testing phases, planning, design, execution and warranty support.
• Prepared ATS, Application Test Strategy, RTM, Requirement Traceability Matrix, Test scenarios and project test plan overview documents.
• Designed and executed the test cases manually based on the BRD, ADS, TDS and user case documents, identified the application functionalities, test requirements and coverage.
• Primarily focused on the system, integration, release, regression and automation testing the pricing application, SOAP UI, Web services, Hyperion reports, Oracle databases for new development and enhancements in the payer pricing system.
• Designed the SQL queries and tested front end developed data in the databases.
• Executed the automated test scripts in QTP to validate the regression scripts and the Web pages.
• Executed the sync jobs with respect to the test scenarios and validated the fee schedules.
• Framed new queries in TOAD, Hyperion, SANP and Window QMF based on the business requirement document.
• Validated the Web services and Web forms by using SOAP UI.
• Generated the defect reports from ALM, for defects involving program functionalities, output, online screening and communicated to the software developers.
• Building up regression suite and identified the test scripts for automation.
• Involved in the automation team and in the automation test scripts in QTP.
• Developed excel macros and data mining tools to support the test data creation.
• Reviewed the test evidences and closed out activities by the team.
• Walked through the deliverables with the clients.
• Coordinated with offshore continuously in all of the test phases and activities.
• Hosted the weekly status meetings for the testing phases.
• Shared the daily/monthly status dashboard and metrics.

Environment: HP ALM, HP Quick Test Professional(QTP), CA Service Virtualization, VB scripts, Java, Oracle 11g, TOAD, Hyperion Reports, SOAP UI, Windows 7, Unix, MS Excel, MS Word, Putty, Office Communicator, SharePoint.

Sr. Software QA Analyst

Confidential, St Louis, MO

Responsibilities:

• Analyzed the requirements obtained from the client and estimated the time required to in corporate the requirements in the system.
• Prepared application test strategies, test scenarios, test plan overview documents and conducted test scenario walkthroughs with the business and project teams.
• Designed and executed test cases for the BRD, ADS, TDS, and User Case documents, identified the applications functionality, test requirements and coverage and loaded in ALM.
• Provided test data support and data mining for test data creation as per the test scenarios.
• Executed jobs/SQLs with respect to the Test scripts & created SQL, queries in Toad and AS400.
• Validated new functionalities and online screening of the application.
• Executed test cases for the Oracle, Toad schemas and Tables updates for new requirements.
• Updated and modified UNIX files consumed by the various process of the eligibility process.
• Identified the test scripts for automation and built regression suites.
• Involved in developing automation scripts in QTP 11.
• Executed the automation scripts in Quick Test Prof and debugging.
• Hosted weekly status meeting for the testing phases.
• Shared daily/monthly status dashboard and metrics.

Environment: HP ALM, HP Quick Test Prof(QTP), COBOL, VB scripts, Java, SQL, Oracle11g, TOAD, SOAP UI, Windows 7, Unix, MS Excel, MS Word, Putty, Office Communicator, SharePoint.

Sr. Software QA Analyst

Confidential, St Louis, MO

Responsibilities:

• Requirements analyses, involved in kick off meetings & gathered the requirements from the business clients.
• Involved in preparing estimation & project plans for QA activities in all the phases of the project.
• Prepared and reviewed the ATS (Application Test Strategy) and test scenarios overview.
• Attended the scrum meetings iteration planning, daily standup, demos and retrospectives.
• Ensured all activities and deliverables were completed within the time frames for each sprint.
• Involved in Sprint planning and execution and tracked the status through Rally.
• Designed and executed the test cases for the user stories for each sprints covering claim migration functionalities and loaded in ALM.
• Designed and executed the regression test cases for the each sprints and loaded in ALM.
• Analyzed the test data requirements for each sprint and involved in test data creation.
• Created and executed batch jobs/SQLs with respect to the test scenarios to validate the claim migration functionalities.
• Validated the Oracle database tables and online screens of the application for migrated claims.
• Executed test cases for the Oracle, Toad schemas and Tables updated migrated claims.
• Tested the reports and extract layouts as per the new mapping.
• Validated the back-end files and the database Tables using SQL queries to compare and retrieve data for migrated claims.
• Test execution and defects for each sprints that are tracked using Rally.
• Generated defect report/metric from ALM and tracked all of the defects.
• Identified the test scripts for automation and built regression suites.
• Reviewed the test cases, test evidences and close out activities by the team.
• Hosted weekly status meetings for the testing phases.

Environment: HP ALM, HP Quick Test Professional(QTP), Rally, Agile Methodology, COBOL, VB scripts, Java, SQL, Oracle 11g, TOAD, SOAP UI, Windows 7, Unix, MS Excel, MS Word, Putty, Office Communicator, SharePoint.

Sr. Software QA Analyst

Confidential, Bloomfield, CT

Responsibilities:

• Requirements analyses and gathered the requirements from the business clients.
• Prepared and review the ATS, test scenarios overviews and project test plans.
• Designed and executed the test cases for the test scenarios covering new dental claim flow functionalities and loaded in ALM.
• Conducted test scenario walkthrough with the business and project teams.
• Created and executed batch jobs/SQLs with respect to the test scenarios to validate the dental claim flow functionalities.
• Validated the EDI 837 format and processed the dental claims successfully.
• Tested all the formats of the dental claims, EDI 837, ECHCF, NEIC format throughout the flow from inbound to gateway to outbound back to gateway.
• Performed testing back end files and database using SQL queries.
• Generated defect report/metric from ALM and tracked all the defects.
• Identified the test scripts for automation and built regression suite.
• Executed the automation scripts in QTP and debugging.
• Hosted weekly status meetings for the testing phases.
• Responsible for giving demonstrations and presentation to the management and mentored other junior team members.

Environment: HP QC, HP Quick Test Professional(QTP), COBOL, VB scripts, Java, SQL, Oracle 11g, TOAD, SOAP UI, Windows 7, Unix, MS Excel, MS Word, Putty, Office Communicator, SharePoint.

Software QA Analyst

Confidential, Bloomfield, CT

Responsibilities:

• Performed requirement analysis, functional and business requirements.
• Prepared ATS, Application Test Strategy Document, understanding the functional requirements.
• Designed and developed the test plan, test scenarios and test scripts in ALM.
• Built the test data grids for test execution in excel macro and AS400.
• Involved in test execution, system, integration and release testing.
• Detected bugs and classified them based on severity and priority basis.
• Created batch jobs and queries in mainframe/AS400 for test execution.
• Validated database files using mainframe utilities/tools, FileAid, QMF
• Executed the automation scripts in QTP and debugging
• Ensured timely completion of all requirements as per the corporate guideline.

Environment: HP QC, HIPPA EDI Transactions, COBOL, JCL, DB2, MQ Visual Edit, ISPF, VSAM, Changeman, Xpeditor, SPUFI, FileAid, UNIX commands, MS Office, Visio, Putty, SOAP UI.

Software QA Analyst

Confidential

Responsibilities:

• Requirement analysis, functional and business requirements.
• Designed and developed test plans and test scenarios overview documents.
• Prepared and executed the test cases for the test scenarios based on BRD, FRD, TDS documents covering all of the test scenarios and loaded in ALM.
• Created/prepared the test data grids for test execution and data mining.
• Involved in test execution, Sys, Int and Rel testing the payroll and tax service application.
• Created jobs and queries to extract data and tax calculations for test execution.
• Validated database files using mainframe utilities/tools, FileAid and QMF.
• Executed the automation scripts in QTP and debugging
• Coordinated with offshore continuously in all the test phases and activities.
• Ensured timely completion of all requirements as per the corporate guidelines.

Environment: HP QC, COBOL, JCL, DB2, VSAM, Changeman, Xpeditor, SPUFI, FileAid, UNIX Commands, MS Office, Putty, SOAP UI, Oracle, Unix.

System Programmer

Confidential

Responsibilities:

• Analyzed the requirements obtained from the client through HPSM.
• Prepared Case Diagrams, depicting high level business process flow and interaction diagrams from the business flow in BRD.
• Prepared technical system design and application design specification documents.
• Developed new jobs with respect to the requirements. Created new JCL, programs in COBOL, SAS and AS400.
• Framed new queries in Hyperion, Brio Intelligences and Window SAS based on the Business requirement documents.
• Designed and developed analytical and statistical reports for business analysis by extracting data from different databases, IMS tables, DB2, CAA data mart’s and One-source.
• Reviewed the codes, prepared the test plans for various scenarios and prepared the test results documents for verification of the codes.
• Automation tools have been created using SAS and Mainframe utilities to automate the process and to increase the performances.
• Automated the reoccurring reports by developing SSIS Packages in SQL server 2008.
• Tracking the request through HPSM Tool and Governances Database.
• Hosted weekly status meetings.
• Ensured the quality and defect free deliverables by following all necessary policies and procedures of Client.

Environment: Base SAS, Window SAS, Hyperion, OneSource, Toad, SQL Server, OS/390, Enterprise COBOL, DB2, SYNCSORT, JCL, TSO, ISPF/PDF, SQL, Xpeditor, File-Aid, File-Aid for DB2, Changeman, SPUFI, QMF, MS Access data mart.

System Programmer

Confidential

Responsibilities:

• Involved in analysis, coding, unit and regression testing, implementation of the new requirements.
• Prepared the HLD and LLDs for all the functional requirements.
• Developed new jobs (with respect to the requirements, creating new JCL and COBOL programs).
• Worked on production fixes for tickets opened through Remedy.
• Coordinated with the client teams during the production moves.
• Created test cases, test data and recorded test results for new/enhanced requests and coordinated in testing with the QA team.
• Debugged and implemented the system using IBM Debug tools.
• Handled Ad-Hoc requests.
• Involved in preparing the test plans for independent unit testing and work package testing.
• Tested the applications for the business requirements and responsible for delivery on time.

Environment: OS/390, Enterprise COBOL, DB2, VSAM, SYNCSORT, JCL, TSO, ISPF/PDF, SQL, Xpeditor, File-Aid, File-Aid for DB2, Changeman, IBM Utilities, MQSeries, SPUFI, QMF.

System Programmer

Confidential

Responsibilities:

• Prepared Technical Design documents and high level application design specifications.
• Involved in analysis, coding, unit, regression testing and implementation of the new requirements.
• Developed new jobs (with respect to the requirement creating new JCL and COBOL programs).
• Conducted code walk through and prepared the test results for various scenarios to verify the code changes.
• Deployed the programs and other components using Changeman.
• Worked on production fixes, scheduled and tracked the jobs scheduling tools and CA scheduler.
• Extracted the application structure and the program flow using Xpeditor to trace the Abend.
• Analyzed irregularities occurring in production that were logged in Remedy and determined the causes for their occurrence.
• Debugged codes using IBM Debug tools and involved in implementation activities.
• Delivered the enhanced programs, impact analysis document and UTR to the client.

Environment: OS/390, Enterprise COBOL, DB2, VSAM, SYNCSORT, JCL, TSO, ISPF/PDF, SQL, Xpeditor, File-Aid, File-Aid for DB2, Changeman, IBM Utilities, MQSeries, SPUFI, QMF.