Sr.Quality Assurance Analyst

PROFESSIONAL SUMMARY

Over ** years of Quality Assurance software testing experience including designing, developing, and implementing test plans, test cases and test processes for Web, Client/Server, and Legacy projects.

Certified ISTQB Tester with Federal experience.

Specialized in Software Quality Assurance Process, Software Testing in Waterfall and Agile Methodologies.

Expertise in SDLC and Software Testing Life Cycle, including requirements gathering, project planning, tasks scheduling, testing, defect tracking, Test management, and Reporting.

Experience in various testing phases such as Smoke, Functional, Integration, Interface, Ad-Hoc, Data Conversion, Regression, End-To-End and User Acceptance Testing.

Hands on experience in creating Test Frameworks using Selenium WebDriver with Page Object Model, Data Driven Testing and UI Mapping using Java, Selenium WebDriver, Maven, JUnit, TestNG.

Excellent knowledge of RDBMS systems including Oracle, Sybase, MS SQL Server, DB2.

Experience executing regression using Automation tool QTP, Cypress, and Selenium.

Experience in Defect Tracking and Reporting using Atlassian Jira, Confluence, HP ALM, Clear Quest.

SKILL SETS

Operating Systems

MS-DOS, UNIX (Solaris 2.x), Windows XP, Main frames OS/90

Database

Oracle 9i/10g, MS-Access 2003/2007, DB2, Sql Server

Web Technologies

Java, J2EE, IIS, HTML, DHTML, Java Scrip, SAP, Pega

Automated Test Tools

QTP, Selenium, Github, Eclipse, Cypress

Languages

Visual Basic 6.0, Java IDE, C/C++, JavaScript and PHP IDEs

Other Applications and Tools

SPUFI, TOAD, Clear Quest, HP ALM, Doors, Rapid SQL, Share point, Version One, Atlassian Jira and Confluence, Drupal, ServiceNow, Salesforce

WORK EXPERIENCE

Cares Act Treasury – HHS Agency

Jul 2024 – Current Test Lead

The CARES Act (Coronavirus Aid, Relief, and Economic Security Act) is a piece of legislation passed by the U.S. Congress in response to the COVID-19 pandemic. The implementation and oversight of the funds provided by the CARES Act involve multiple federal agencies, including the U.S. Department of the Treasury and the U.S. Department of Health and Human Services (HHS). The Treasury Department is primarily responsible for distributing economic impact payments, managing the Payroll Protection Program, and other financial support programs. The CARES Act enable them to continue to support the public health response and lay the foundation for a strong and equitable economic recovery and provides fast and direct economic assistance for American workers and families, small businesses, and preserves jobs for American industries to the Treasury Programs supporting State, Territory, Tribal, and Local Government as part of the 2021 American Rescue Plan.

Tested custom reports on the Salesforce backend and the Portal annually and quarterly for SLFRF and CPF applications.

Worked closely with team members to plan, coordinate, and ensure the timely delivery of testing activities and test deliverables in an agile environment.

Performed Smoke, User Acceptance, End-To-End, Back-End, and Regression testing.

Reported and managed defects, ensuring resolution in accordance with established guidelines and expectations.

Tested various workflows comprehensively, covering all functional aspects, and utilizing Lightning components to assess diverse test scenarios.

Supported the UAT effort by addressing any client questions and assisting in the release process.

Configured Treasury clients' accounts, contacts, reports, applications, list views, permission sets, and portal access in Salesforce.

Assisted with Salesforce deployments on a bi-weekly basis

Environment: Saleforce.com platform (Classic and Lightning), Salesforce Reporting, Jira, SharePoint, Apex Language, Visual Force, Data Loader, Apex Triggers, Reports, SFDC Sandbox.

Restore Act- Treasury – HHS Agency

Jan 2024 – Jun 2024 Test Lead

The RESTORE Grants Management System (RGMS) is a Salesforce Lightning Application run by the United States Department of the Treasury’s Office of Gulf Coast Restoration. In July 2012, Congress passed the Resources and Ecosystems Sustainability, Tourist Opportunities, and Revived Economies of the Gulf Coast States Act (RESTORE Act) in response to the Deepwater Horizon oil spill. The RESTORE Act dedicates 80 percent of all administrative and civil penalties related to the Deepwater Horizon spill to a Gulf Coast Restoration Trust Fund and outlines a structure by which the funds can be utilized to restore and protect the natural resources, ecosystems, fisheries, marine and wildlife habitats, beaches, coastal wetlands, and economy of the Gulf Coast region. The U.S. Department of the Treasury is responsible for issuing compliance and auditing procedures for the entire Act and procedures for two grant programs administered by Treasury.

Worked closely with team members to plan, coordinate, and ensure the timely delivery of testing activities and test deliverables in an agile environment.

Reported and managed defects, ensuring resolution in accordance with established guidelines and expectations.

Engaged with Business Users and SMEs to capture critical business scenarios, incorporating them into test cases.

Tested various workflows comprehensively, covering all functional aspects, and utilizing Lightning components to assess diverse test scenarios.

Supported the UAT effort by addressing any client questions and assisting in the release process.

Performed Smoke, User Acceptance, End-To-End, Back-End, and Regression testing.

Environment: Saleforce.com platform (Classic and Lightning), Jira, SharePoint, Apex Language, Visual Force, Data Loader, Apex Triggers, Reports, SFDC Sandbox.

Children’s Bureau - Child Welfare Information Gateway (CWIG) – HHS Agency

Jul 2022 – Dec 2023 Test Lead/Scrum Master

The Child Welfare Information Gateway (CWIG) clearinghouse is a national hub for information about the various programs and services provided by the Children’s Bureau (CB). CWIG serves the child welfare field, covering a wide range of topics related to child welfare, child abuse and neglect, out-of-home care, adoption, and more. In addition, CWIG promotes public awareness of CB’s mission and initiatives as well as support to the child welfare field in understanding complex technical and social issues through the conceptualization and development of written and electronic communication, social media, intricate web and database development, technical assistance, Management, presentations, technology and information systems, and logistical planning and execution.

Work closely with the team members, plan and coordinate testing activities and ensure test deliverables.

Developed a Test Plan including Test Strategy, Objectives, Scope, Schedule, Deliverables, Environment, and Responsibilities. .

Analyzed the scope of each release and supported the development team in deployment effort.

Proactively learnt new technologies such as Snow (Admin), Cloud-based API calls, and JSON files testing using Visual Studio.

Identified the gaps in the testing process and provided recommendations to improve the testing process.

Evaluated the benefits of using X-ray Tool in the testing process and played a key role in acquiring and implementing in CWIG project.

Conducted UAT and user training for the program team.

Facilitated Scrum events, removed impediments, facilitated communications, and monitored progress in CWIG project.

Create and update burndown charts, which track the team's progress throughout the Sprint including team's capacity and velocity.

Developed Team Norms and Testing process documentation.

Environment/Tools: ServiceNow, Jira, Confluence, Cypress, AWS Cloud, and SharePoint.

Creative systems and Consulting – CTP Case Management System (CCMS) – FDA Agency, Virginia

Feb 2021 – Jun 2022 Senior Quality Assurance Analyst

The Objective of this project is to implement system enhancements and provide operations and maintenance support for the CTP Case Management System (CCMS). The CCMS system supports CTP’s office of compliance and Enforcement (OCE) that issues penalties/fees and no tobacco sales orders against the retailers that don’t comply with the tobacco rules and regulations. The objective of the project is to develop and support CCMS that is used to manage Tobacco Civile Money Penalty (CMP) and No-Tobacco-Sale Order (NTSO) cases that are brought before CTP. To support its compliance and enforcement activities, CTP Case Management System (CCMS) will allow close collaboration with other systems used to support the filing of CMP actions. The CCMs is built on Microsoft Dynamics 365.

Worked on different project documents like Test Plan, Quality Assurance Management Plan, RTM, and Test Cases.

Performed Functional, Regression, Smoke and UAT testing on the application and strived to deliver a defect free application.

Set up the UAT environment by assigning user roles, creating test data, and assigning test scripts to UAT testers in SharePoint.

Worked closely with the team members, planned and coordinated testing activities and ensured test deliverables.

Conducted the UAT Kick-Off meeting and participated in the UAT Mid-check support call.

Designed and implemented all UAT test cases including coordination and training UAT team members.

Created automation test scripts using VB script and used Tortoise SVN for source/version control.

Presented and participated in internal knowledge sharing sessions.

Environment/Tools: Microsoft Dynamics 365, Jira, UFT and SharePoint.

Creative systems and Consulting, U.S. DEPARTMENT OF AGRICULTURE(USDA) ANIMAL PLANT HEALTH INSPECTION SERVICE (APHIS), Virginia

Oct 2019 – Jan 2021 Senior Quality Assurance Analyst

The Commodity Import Requirements Database (CIRD) is a digital commodity import manual. It contains information currently housed in one live database (FAVIR), 12 pdf manuals, and more than 50 supporting documents. CIRD will provide one place to find information on importing commodities, inspecting commodities, treating commodities, and documenting outcomes. There are three user levels in the outward facing system: Public, Partner Agencies, and APHIS only. Within APHIS, there are also roles for content managers and reviewers. The system will integrate with or replace the current Salesforce based manual change request system while providing better workflows and intake forms.

Participated in Release Planning and Iteration Planning sessions.

Developed and implemented automation scripts using Selenium based Leapwork Studio.

Performed testing of public portal for 508 compliances.

Tested the internal CIRD application built on salesforce platform along with the community portal public website.

Ran the Automation scripts in Leapwork Studio after each iteration and documented the Test Results.

Participated in Functional testing, Smoke test, Regression test, Integration testing and End to End testing.

Report and manage defects to ensure that all issues are resolved according to established guidelines and expectations.

Worked closely with Business Users, SMEs to capture business critical scenarios and incorporate them as test cases.

Assisted development team in troubleshooting and determining root-cause of application defects and issues.

Played a lead role in mentoring junior testers.

Environment: Saleforce.com platform (Classic and Lightning), Apex Language, Visual Force, Data Loader, Apex Triggers, Reports, SFDC Sandbox.

Freddie Mac, (Mortgage) Virginia

Oct 2017 – Sep 2019 Sr. QA Analyst

The Pricing Execution Cash initiative will deliver an enhanced pricing execution platform to support Cash Pricing capabilities. The enhancements will provide improved efficiencies and controls, and greater flexibility to SF Pricing to Allow Freddie Mac to be more adaptable in its pricing strategy, provides new pricing structures that enhance Freddie Mac’s ability to achieve market share objectives and tailor pricing to individual customers and manage profitability of the Cash Window.

Analyzed User stories, Business Ask Stories and System Stories in Agile Methodology

Participated in Release Planning and Iteration Planning sessions.

Actively Involved in different meetings like Daily Scrum, Refinement session, Retrospect and Close Out Sessions

Reviewed Test Cases along with Test Data variations with Business Users, Stakeholders, Business Analyst, System Analysts and team members to ensure complete test scenario coverage, capture inputs/feedback and update Test Cases and Test Data.

Participated in Functional Testing, Smoke Test, Regression Test, Integration testing and End to End Testing

Developed and implemented automation using Selenium WebDriver and java.

Worked on Hybrid automation framework using Page Object Model, Automation framework using Java, Selenium WebDriver.

Worked with Continuous build and Integration and Deployment using Maven and Jenkins.

Developed BDD tests using Cucumber by writing behaviors and step definitions.

Ran the Automation scripts in Eclipse after each Iteration and documented the Test Results.

Written Test Cases in Features Files in Gherkin Language, Documented the Test Scenarios, Test Results and Defects in ALM

Environment: DB2, Rapid SQL, Web Logic Server, JAVA, XML Spy, MS office

Freddie Mac, (Mortgage) Virginia

Aug 2014 – Jun 2017 UAT Analyst

The purpose of the Pricing Execution initiative is to redesign Freddie Mac’s guarantor pricing processes by implementing a new pricing decision rules engine, enhancing existing supporting calculation and rules processes, defining the supporting workflow for different execution paths, establishing a more efficient pricing set-up and price management workflow and corresponding organizational changes. The Pricing Function will be supported on a custom-built technology platform, which is based on a rewrite of the current custom built Pricing Management Application “PMA”. Freddie Mac Sellers will continue to access Freddie Mac pricing for contracting and loan delivery through the existing customer-facing system. This project will provide more accurate pricing which may be based on changes in the mortgage and/or TBA market. It will also allow credit fees to be assessed based on Contract and/or Loan dates which are in the system.

Reviewed Business Requirements, User Acceptance Test Strategy and Test Plan.

Analyzed business requirements and Use cases to identify and report any gaps.

Defined high-level Test Scenarios and detailed Test Cases based on Business Requirements, Use Cases and Wireframes.

Participated in peer review meetings to analyze System Testing test cases and test data variations.

Worked closely with Business Users, SMEs to capture business critical scenarios and incorporate them as test cases.

Prepared test data variations in terms of Base Offering Products, Security Products, Contract Products, Loan Programs, Amortization, Borrowers etc. ensuring complete coverage of business test scenarios.

Reviewed Test Cases along with Test Data variations with Business Users, Stakeholders, Business Analyst, System Analysts, and team members to ensure complete test scenario coverage, capture inputs/feedback and update Test Cases and Test Data.

Performed Smoke, User Acceptance, End-To-End, Back-End, and Regression testing.

Developed SQL Queries to verify the database functionality.

Environment: DB2, Rapid SQL, HP – ALM, DOORS, Web Logic Server, JAVA, XML Spy, MS office

Educational Testing services, (ETS) NJ

Feb 2014 – Jul 2014 QA Analyst

ETS offers consulting services, technical assistance, custom assessments, in-depth research and other solutions for school districts, institutions, businesses, and government agencies throughout the world. Software test team was involved in generating final score reports through batch jobs process for different tests like Praxis, Texas, Georgia, Hiset exams.

Involved in complete SDLC Process, Requirement gathering Phase, Design Phase and Testing Phase.

Involved in entire score reporting process through mainframes jobs.

Analyzed the gaps to improve the process of score reporting and documented the process in detail.

Involved in creating different project documents like LOE, RTM’s, Test Plan, Test cases, Daily SLA’s and EOT.

Participated in functional testing the online application “Item Bank” where all Test Items are placed.

Developed Test Scenarios and Test Data to cover all the Business requirements and SCRs.

Involved in writing the queries in SPUFI based on test data required for generating score reports.

Update and executed JCLs based on the requirement changes.

Environment: IBM Mainframe, SQL Developer, DB2, SPUFI, SharePoint and Silk Central.

CVS Caremark Pharmacy, NJ

Mar 2013 – Nov 2013 QA Analyst

Project – QL Migration Project

CVS Caremark wants to migrate from the existing QL system which was running on IBM Mainframes to RX claim system which was on AS400 with the help of the Benefit builder (in-house tool) Migration was done with current existing functionality and newly added functionality which was tested end to end before migration.

Involved in complete SDLC Process, Requirement gathering Phase, Design Phase and Testing Phase.

Developed test plans, strategies, scenarios, and execution of test cases.

Created Test Plan, Test Approach, and Test cases.

Involved in business reviews, design review along with company stake holders.

Manually tested reports that were not falling under migration Process.

Involved in writing the queries in SPUFI based on business requirements.

Involved in taking the backup of the DB2 tables.

Executed JCLs to restore the data into the db2 tables.

Environment: IBM Mainframe, DB2, SPUFI, SharePoint and Quality Center

Delta Dental, Parsippany, NJ

Sep 2012 – Mar 2013 QA Tester

Project – Core Phase I & II

The nonprofit Council for Affordable Quality Healthcare (CAQH) launched the Committee on Operating Rules for Information Exchange (CORE) with the vision of giving providers access to eligibility and benefits information before or at the time of service using the electronic system of their choice for any patient or health plan.

Responsibilities

Involved in Web Services Testing using SOAP, SOAP UI and WSDL etc.

Tested data elements for the 270/271 Eligibility and Benefits Request and Response.

Involved in running the Automation Scripts for Web project.

Extensively tested 835 Claims processing and Payments for Dental Claims

Regression testing of 5010 version 276/277 Claims via CT Tunnel (EDI Portal)

Executed and verified the results in GUI screens and used SQL query to perform database validations in SQL Server.

Analyzed the table structures and streamlined the process in data manipulation using SQL Server.

Performed Functional Testing, Regression Testing, and System Testing for each release.

Environment: Web Services, SQL Server, Quality Center ALM, Share Point, Agile Scrum Testing, Windows XP, XML, SOAP UI, WSDL, SOA

JP Morgan Chase, Wilmington, DE

Jun 2012 – Aug 2012 QA Tester

Project: Credit Card Processing

The project involves obtaining enrollment, bureau monitoring, and billing files from the 3 vendors who have serviced the products, identifying impacted customers from these files, developing and executing a plan to refund membership fees paid, associated interest and over limit fees billed in any month they were not receiving full benefits from the project. It also involves developing and executing a cancellation strategy, as well as developing and sending communication to the impacted customers.

Responsibilities

Analyzed the business requirements and wrote high level Test plan, Test case and Test scripts.

Developed Test cases and Test Scenarios and Test Data to cover all the requirements.

Executed and verified the results in mainframes screens and used SQL query to perform database validations in DB2.

Performed end to end scenarios by validating from front end application to DB2 database.

Tracked & logged all the defects in defects Management of Quality Center.

Involved in helping Business Users in UAT testing.

Created Test Summary Results Report and Incident Report.

Environment: Mainframe OS/90, Quality Center, Doors, DB2, Share Point

Medco/ ESI, Franklin Lakes, NJ

Nov 2011 – May 2012 QA Tester

Project: Order Processing

Medco is a leading pharmacy benefit manager (PBM), with the nation's largest mail order pharmacy operations. Through advanced pharmacy, Medco improves health and lowers the total cost of care for clients and their members. The primary objective of the project is to build up a unified order processing solution for Drug dispensing for chronic patients adhering to the HIPAA standard. The newly built application takes care of all the patients’ information and has an interface for pharmacies for drug dispensing using Mail Order and Retail Order Pharmacy.

Responsibilities

Tested web services at orchestration level verify the response XML and validate query at the back end.

Involved in testing different SOAP Request using XML Formats.

Verified the results in mainframes screens and used SQL query to perform MAC operations in database for verifying the results.

Performed end to end scenarios by validating from front end application to DB2 database.

Created operators and Workbaskets, Test types, Test Environments and test applications in PEGA environment.

Tested the user interface functionality and the workflow between the various screens of the application.

Tested data mapping and data flow between the Front-End application and the Back End of the application.

Worked on offshore and onsite model coordinating with the offshore team members.

Environment: Java, J2EE, Pega, Web Services, SharePoint, IBM Mainframe, XML, DB2, QTP and Quality Center, PMF.

Independence Blue Cross (IBC), Philadelphia, PA

Apr 2011 - Oct 2011 QA Tester

Project: HIPAA & Oracle 11 G upgrade

The HIPPA Act released a rule supporting the continued transformation of the US Healthcare System. One of these rules addresses the adoption of the Accredited Standards Committee (ASC) X12 5010, for Health care transactions. The current transaction standard is X12 version 4010A1. HIPAA has mandated that the industry upgrade to X12 version 5010. HIPAA requires covered entities to use the mandated standards in the electronic transmission of healthcare transactions, including claims, remittance, eligibility, claims status requests, their related responses and privacy and security standards.

Responsibilities

Worked closely with Developers and Business Analysts and participated in the requirements, design documents, bug reports reviews.

Extensive knowledge on HIPPA 837 I/P claims and administration planning.

Validate EDI Claim process according to HIPPA compliance.

Developed and executed various test cases for testing HIPAA 837I/P (4010)

Experienced in EDI file HIPAA transaction testing EDI HIPAA transactions (837 I/P claim)

Developed Oracle 10g SQL queries for validating the functionality of business by comparison of expected results versus actual results.

Smoke test, Unit test using Input test data, and Full volume performance test using subset of PROD data before oracle 10G migration.

Baselined the data in oracle tables by running jobs through Autosys in Oracle 10g, ran the same jobs in oracle 11g, and compared data.

Involved in running the automation scripts in QTP.

Environment: QC 10.0, HIPAA, EDI, Oracle 11g, Java, J2EE, Citrix, UNIX (Sun Solaris), QTP, Autosys and Quality Center, DB2, Sharepoint, IBM Mainframe, AS400.

Education:

Master of Business Administration (MBA), Osmania University Hyderabad, India 1999 - 2001

Bachelor of Accounting and Finance, Osmania University Hyderabad, India 1996 - 1999

Certifications:

Certified ISTQB Tester ISTQB

Software Test Automator Accredited Certification Test Institute

Certified SAFe 5 Advanced ScrumMaster Scaled Agile

Certified Scrum Product Owner (CSPO) Scrum Alliance

Certified ScrumMaster (CSM) Scrum Alliance

Six Sigma White Belt Performance and Strategy Innovations LLC

Contact this candidate