Software Engineering Health Care

Avita D’Costa

QA Test Lead Raleigh Metro +1-804-***-**** *****.*******@*****.*** Green Card

Qualifications Overview

Avita has 16+ Years’ experience in leading, managing and delivering large QA testing projects in BFSI, investment banking, wealth management and Health care finance domains products in onshore-offshore model in client server and web-based applications & products. She has experience with Waterfall and Agile work environments and is very familiar with SDLC.

Education/Certifications

Master of Science in Software Engineering from Birla Institute of Technology and Science - 2009

Bachelor of Science in Computer Science from University of Mumbai -2004

Technical Skills

Testing Tools

HP ALM, Jira, Test Rail Postman, Azure Dev Ops

Tools

VM Ware, VSS, HP QC 10, HP Load Runner 6.5, HP UFT 12, Bugzilla, Mercury Test Director, Snag It, MS Visio, MS Project, Rapid SQL Share 7.5, Secure CRT 6.5, e Room, Beyond Compare, Compare IT, Clear Quest, Postman, SOAP UI

Operating Systems

Windows, MS DOS, UNIX

Methodology

Process Improvement, Scrum, Kanban, Agile Safe 5.0

Languages

Junit, Python, C, Visual Basic 6.0, JavaScript, VB Script, Seagate Crystal Reports 8.0, Lotus Script & Formula Language, UNIX Scripting, XML, HTML, CSS, Path, XQuery

Databases

MS SQL Server 2K, Oracle8i, MS Access, Lotus Domino 6.5.1

Others

MS Office Products, Rapid SQL, SQL plus, TOAD, VSS, GitHub, MS Project Reporting Tools

Crystal Reports 8.0, Business Objects, SharePoint

Professional Experience

Employer: Concord USA LLC 5/2022- To Date

QA Tester/QA Lead – SunStream Financial Loan Accounting applications for Farm Credit Associations of Agri Bank for estimating designing and testing all the features end to end and API for SIT/UAT

Responsibilities:

Managed project requirements and incident tracking using STLC for testing projects.

Developed Requirements Traceability Matrix (RTM), estimates, and test planning documents to ensure product delivery.

Coordinated with stakeholder teams to execute comprehensive functional and regression testing.

Implemented data-driven testing techniques in API to validate application behavior across multiple data sets, enhancing the robustness of test scenario

Executed manual test cases, documenting results and verifying those applications met predefined quality benchmarks and user expectations.

Developed and executed SQL queries to extract, analyze, and validate data from DB2 databases, identifying discrepancies and ensuring data quality.

Performed data reconciliation between DB2 databases and external data sources, identifying and resolving data discrepancies to ensure consistency.

Implemented automated data validation scripts using SQL, significantly reducing manual testing efforts and improving overall efficiency.

Executed stress and endurance tests using LoadRunner to assess application stability under prolonged load conditions, ensuring the system meets performance standards.

Developed performance baselines to establish acceptable performance thresholds, facilitating ongoing monitoring and performance tuning efforts.

Created and maintained comprehensive test plans, ensuring alignment with project requirements and objectives in ALM.

Developed and maintained reusable test scripts in UFT, enhancing test efficiency and reducing script maintenance time.

Coordinated defect management processes within ALM, including defect logging, tracking, and resolution to enhance software quality.

Documented application flows and processes to identify gaps and manage requirement changes.

Analyzed test strategies, performed gap analysis, and prepared test environments for execution.

Conducted BAU and strategic release testing for new functionality, regression, defect retesting, smoke testing, and build verification.

Executed database testing to verify functionality in trading and portfolio accounting application modules.

Conducted defect summary reporting and provided insights to IT management.

Facilitated status meetings, managed risks, and ensured data backup activities in the project.

Mentored team members and conducted knowledge transfer sessions on both functional and technical aspects.

Environment: MS ADO, Postman,Swagger, AQT, SQL

Employer: Artech LLC 10/2021-5/2022 QA Tester/QA Lead – Truist (BBT) Raleigh Greensboro Remote

WebVault association services and Treasury Project for estimating designing and testing all the features end to end for SIT/UAT Treasury, Billing, Lockbox and Association services for migration of Web Plus application from lower .net frame work to Web Vault client users.

Responsibilities:

Project Requirements Management & Incident Tracking using STLC and managing process for testing projects

Understanding product specifications and developing RTM, Estimates, Test planning and design documents to verify the product to be delivered.

Coordinating with stakeholder teams for complete test steps and handle functional and regression execution

Assisted in the integration of ALM with other tools in the development ecosystem, such as CI/CD pipelines, to streamline workflows.

Implemented process improvements within ALM to enhance testing efficiency, including automated reporting and improved defect tracking workflows

Coordinating with users and documenting applications flows and processes to find gaps and manage requirement changes

Updated and maintained test cases based on changes in application features, ensuring test coverage remained relevant and effective.

Performed integrity checks and reconciliations between mainframe and other data sources, ensuring consistency and reliability of information across systems.

Assisted in troubleshooting data-related issues, leveraging DB2 and SQL expertise to identify root causes and implement corrective measures.

Conducted thorough data validation tests to verify data migrations and transformations, ensuring successful transitions with minimal data loss or corruption.

Analyzing the test strategy, planning, gap analysis, estimating for Test Execution and preparation of the test environment.

Assisting the automation team to identify major test which could be automated for specific trade flows.

Performing BAU and Strategic releases for New Functionality, Regression, Defect Retesting, Smoke testing, Build Verification, Database testing for the functionality required in the trading and portfolio accounting Application modules.

Managing Test process and responsible for providing recommendations for resource needs

Documentation of data analysis for reconciliation, test scripting and production issues for mapping and sourcing information

Working as SAFE ART for Testing of modules migrating to new Web environment

Environment: Jira, HP ALM, UNIX, VSS, SQL, PL SQL scripting

Employer: Cognizant Tech Sons. US Corp 07/2015- 03/2021 Sr. Agile Product Test Lead – BSBCNC Durham, Credit Suisse Raleigh, LPL Financial Charlotte

Large group 51+ Migration project aimed at migration of existing Large Companies seeking employee Health Care coverage with BCBS NC from legacy system to Cognizant built health care products.

Portia Replacement project involved replacing Wealth management legacy Portfolio accounting system to a Web-based Fiserv product for managing high network client investment accounts of LPL Financial with downstream applications for Advisory fee billing, performance reporting

FX Trading WSS Retirement Loan IQ project verifying FX trading suites of front back-office application interacting and sharing messages/acknowledgements for success trade settlements.

Loan IQ the testing involved complex functional testing for Loan IQ application and

in-house and cross vendor's applications. There are verifications involved with Unix and Oracle.

Responsibilities:

Project Requirements Management & Incident Tracking using STLC and managing process for testing projects

Understanding product specifications and developing RTM, Estimates, Test planning and design documents to verify the product to be delivered.

Coordinating with stakeholder teams for complete test steps and handle functional and regression execution

Coordinating with users and documenting applications flows and processes to find gaps and manage requirement changes

Analyzing the test strategy, planning, gap analysis, estimating for Test Execution and preparation of the test environment.

Assisting the automation team to identify major test which could be automated for specific trade flows.

Performing BAU and Strategic releases for New Functionality, Regression, Defect Retesting, Smoke testing, Build Verification, Database testing for the functionality required in the trading and portfolio accounting Application modules.

Managing Test process and responsible for providing recommendations for resource needs

Documentation of data analysis for reconciliation, test scripting and production issues for mapping and sourcing information for post migration

Active Participation in Daily Scrum stand up meeting highlighting the risk

Preparation of complex test scenarios and data for the applications web automation

Analyze the mapping between test case and requirements for monthly releases

Updating the existing test cases and creating additional cases for in depth testing

Negotiating with the business on questions, schedule and test reprioritization for Agile releases.

Track project testing activities, issues, documenting defects and defect summary report generation. Coordinating with teams in different time zones for techno functional discussions & QA assignments’ time lines.

Developing test scripts in VB/Junit classes for functional and Oracle queries for database testing to verify application performance.

Preparation of weekly/monthly/task-based project status reports and minutes of conference calls and metrics data to be shared with client.

Conducting defect prevention activities, root cause study, preventive meetings and action items and diagrams to study root cause analysis, KT to be shared with client.

Worked as Demand manager for the account in the Manages Capacity Model for health care QA business and Tammi level certification for the practice.

Responsible for QA deliverables for multiple projects, QA audit, escalations and tracking for post go- live production incidents and closure from testing stand point.

Training and Knowledge management activities for BFS, Wealth management and Trading application, getting new test area knowledge and sharing documents with teams, execution strategy and implementing agile methodology in the project with QA Audit Approach.

Environment: HP ALM 12, Putty, Rapid SQL Oracle, Unix, MS SQL Server.

Employer: Splinter Inc. 10/2014-07/2015 Credit-Suisse - Sr. QA Technical Analyst

Financial Banking project caters to regression, upgrade/installer, new functionality, smoke & sanity testing of various modules of the Banks’s IB Trading modules for STP of Post Trade Pre-settlement profiling, confirming and matching in trading system of US Stock exchange (Financial Services). The testing involves migrations and enhancement to the features involve STP, Trade life cycle testing flow of data between applications

Responsibilities:

Reviewing the requirements send by the customer for testing the functionality by detailed study SRS & FS.

Coordinating with Business Analysts and Technical Analysts for the development & effective test coverage, preparation of use cases and test cases/scenarios based on functional requirements to develop/ enhance the automation test suite.

Analyzing the test strategy, planning, gap analysis, estimating for Test Execution and preparation of the test environment.

Migrating manual test to automated test cases using project-based Test Case database repository and adding created test cases for new functionality.

Implementing Automation framework for Regression, Installations, Upgrade, Upgrade Installer, RPC M/F, Web Functionality, Defect Retesting, UAT and Smoke & Sanity Testing for the functionality required in the TS Application modules.

Managing Test process and responsible for providing recommendations for resource needs

Preparation of complex test scenarios and data for the applications web automation

Analyze the mapping between test case and requirements

Modifying the existing test cases and creating additional cases for in depth testing

Dealing with the customer on questions, schedule and test reprioritization for Agile releases.

Monitor project testing activities, documenting defects, defect summary report generations, leading the team for technical and estimations of daily testing assignments.

Developing test scripts in VB/Junit classes for functional and Oracle queries for database testing to verify application performance.

Preparation of weekly/monthly/task-based project status reports and minutes of conference calls and metrics data to be shared with client.

Conducting defect prevention activities, root cause study, preventive meetings and action items and diagrams to study root cause analysis, KT to be shared with client.

Training the team members with the risk management & securities domain, execution strategy and implementing agile methodology in the project with QA Audit Approach.

Environment: Selenium, HP QTP9.2, HP QC, VMware, M/F, UNIX, VSS, Snag It (Active Directory) utilizing PHP scripting to securely communicate between systems.

Employer: Apples A CSC Company INC 07/2011- 02/2012 Time Warner HBO Inc - Sr. QA Analyst

CTCI QA – The project deals with the products used by HBO for dropping video, images assets from different inter systems and the .com website which includes workflows developed in Interwoven Team site for each asset deployment on various Media platforms.

The Products covered for testing are

HBO GO/MAX GO Services

HBO .com web site

HBO for iPhone/iPad/Samsung/XBOX

Responsibilities:

Requirements Elicitation: Analyzing the requirements send by the customer for testing the functionality by study and review of BRD.

Coordinating with Business Analysts and Development team for effective test coverage, preparation of use cases and test cases/scenarios based on functional requirements.

Preparation of Test Plans for major end to end components, migration of application in different windows or UNIX environment.

Generating the test strategy, planning, gap analysis, estimating for Test Execution and Test Environment Creation

Automation test design and creation of test suites for application modules using project-based Test Case database repository and adding created test cases for new functionality.

Updated existing test cases and designing new test for new features and better test coverage

Executing Regression, Performance, New Functionality, Defect Retest and Smoke & Sanity Tests for the application releases for HBO IT project.

Working on automation, performance and functional testing involved in HBO Web technologies products and client specific daily reports.

Construction complex java classes, scripts, SQL oracle queries for GUI and back end with end-to-end component testing of Media Asset data.

Interacting with the customer on various forums to discuss the status of the project, clarify any queries regarding the functionality, risk management and any foreseen issues in testing, environments set up etc. for major agile releases.

Daily Task Status Management & Test Management for metrics, defects and defect summary report generations to be shared with customer.

Participated in daily standup meeting

Involved in defect investigation and escalation for faster resolution • Maintaining functional, technical and process training information for team members for knowledge management.

Environment: Manual HP QTP 10, HP QC, Odyssey Jira, Selenium, Interwoven TeamSite, TOAD, MS Project, UNIX, Windows, Securocrat 6.5

Employer: Cognizant Technology Solutions Pvt. Ltd. 02/2010-02/2011 Credit Suisse Sr. QA Analyst

The project deals with the Managed Lending of Securities domain of Investment Banking and Brokerage. The client server-based application is used for securities lending and their returning trade life cycle, reports and master database set up with Database End to End components testing. The application Global 1 built in UNIX is moved to .net Mamba application for Securities Lending and Borrowing. The project involves database testing, trade life cycles and features of Securities Lending.

Responsibilities:

Requirements and Analysis: Understanding the requirements for testing functional checkpoints & Gap analysis using SDS.

Discussions with Business Analysts and Development team for effective test coverage, preparation of use cases and test cases/scenarios based on business requirements.

Creation & Design of Test framework for major functional components, migration of application in different windows & browser environments. Developing VB scripts, classes and framework to automate the regression suite

Develop the test strategy, planning, gap analysis, estimating for Test Execution and prepare the test environment.

Enhancing the existing automated test cases of application using project based existing Test sets or newly created test cases as per SRS.

Regression, New Functionality for trade life cycle, UAT, Defect Retesting and Smoke & Sanity Testing for the application releases for Global 1 replacement project in NY.

Reported defects using HP ALM and interacted with developers to resolve defects or issues

Leading the team of 4 members in automating functional tests involved in

tasks allocation and generating client specific task reports.

Providing guidance to Subordinates for testing of complex modules • Modification of the test cases based in the defects encountered in the applications

Automation Execution for applications using VB Script, Java, Oracle, UNIX and DB schedule runs of Workflow as per service platform.

Performed project knowledge management activities

Identified and escalated system, business issues and risks within the project structure

Providing details to Project Managers on project status, queries regarding the functionality, risk calculation and any foreseen issues in testing, environments set up etc. for agile projects.

Daily Project Status reporting, Test & defect Management for metrics, defect summary reports generations to be shared with larger audience during scrum meetings.

Presentations and cross functional trainings to members from other functional modules.

Environment: HP Quality Center 10.0, Manual, UNIX, Rapid SQL Share 7.5, Windows .net.

Employer: Patni Computer Systems Ltd. (Capgemini / IGATE Solutions) 07/2008- 02/2010

Omega LLC Sr. QA Tester

Trade suite is .net based and project caters to regression, upgrade/installer, new functionality, smoke & sanity testing of various modules of the DTC Company’s trade suite module for STP of Post Trade Pre-Settlement profiling, confirming and matching in trading system of US Stock exchange (Financial Services). The testing involves migrations and enhancement to the features involve Post Trade life cycle testing flow of data between applications

Responsibilities:

Reviewing the requirements send by the customer for testing the functionality by detailed study SRS &FS.

Coordinating with Business Analysts and Technical Analysts for the development & effective test coverage, preparation of use cases and test cases/scenarios based on functional requirements to develop/ enhance the automation test suite.

Analyzing the test strategy, planning, gap analysis, estimating for Test Execution and preparation of the test environment.

Migrating manual test to automated test cases using project-based Test Case database repository and adding created test cases for new functionality. • Implementing Automation framework for Regression, Installations, Upgrade, Upgrade Installer, RPC M/F, Web Functionality, Defect Retesting, UAT and Smoke & Sanity Testing for the functionality required in the TS Application modules.

Managing Test process and responsible for providing recommendations for resource needs

Preparation of complex test scenarios and data for the applications web automation

Analyze the mapping between test case and requirements

Modifying the existing test cases and creating additional cases for in depth testing

Dealing with the customer on questions, schedule and test reprioritization for Agile releases.

Monitor project testing activities, documenting defects and defect summary report generations. Leading the team for technical and estimations of daily testing assignments.

Developing test scripts in VB/Junit classes for functional and Oracle queries for database testing to verify application performance.

Preparation of weekly/monthly/task-based project status reports and minutes

of conference calls and metrics data to be shared with client.

Conducting defect prevention activities, root cause study, preventive meetings and action items and diagrams to study root cause analysis, KT to be shared with client.

Training the team members with the risk management & securities domain, execution strategy and implementing agile methodology in the project with QA Audit Approach.

Environment: Selenium, HP QTP9.2, HP QC, VMware, M/F, UNIX, VSS, Snag It (Active Directory) utilizing PHP scripting to securely communicate between systems.

Employer: Patni Computer Systems Ltd. (Capgemini / IGATE Solution) Genworth Financial Inc. Automation Functional Tester05/2006 – 06/2008 The scope of this project Domino COE includes testing and support of the existing and to be added features to the Genworth Financial Lotus Notes applications like SAFE file access system, Genworth Calendar, COI & Deal room. This involved major migrations of data due to change in File Systems and developing of Test Plan, Execution and Test Data to ensure stability after migrations

Responsibilities:

Requirements Understanding for the enhancement of domino applications and impact analysis for module.

Designing test scripts and classes for the functionality required in these applications.

Testing the functionality added using VB Java scripts using existing frameworks and deploying the deliverable.

Creating the test metrics, defect reports and traceability matrix for applications tested

Resolving functional and performance issues encountered in these applications sent by the client.

Conducting defect prevention activities and meetings within the team, data backup and restoration activities.

Discussing with client for the support, maintenance and enhancements of SAFE, COI, HR Ticketing domino applications.

Defect retesting in production and UAT environments for critical defects fixed • Documentation of approach/User Manual, new features and functionality added to the lotus domino applications.

Troubleshooting production support issues and providing resolutions for the issues encountered at client side.

Building advanced QTP framework scripts to test functionality and SQL queries and joins for data manipulations and verification.

Research for migration and upgrade activities in domino doc manager.

Configuration management and SQA activities for the Domino Application suite

Participating in daily project status meetings with the customer

Generating monthly effort sheet metrics, mentoring delegating tasks and conducting techno functional trainings for the team.

Environment: QTP, VB Script, Lotus Notes and Domino R6, HP QC, Core java, DHTML, HTML, Java Script, Visual source safe, Windows NT, MS SQL Server

Employer: Patni Computer Systems Ltd. (Capgemini / IGATE Solutions) Genworth Financial Inc. Manual Tester 01/200504/2006 The scope of this project C.L.A.I.M.S. Application makes use of Visual Basic 6.0, MS SQL Server7.0 (RDBMS) and Seagate Crystal report technology for adding & testing new functionality for Claims module and generation of reports for the Claims Stage of the Policies administered in the Cyberlife Mainframe System of GEFA LAMPS. The project also involves testing flow of data from M/F to Client Server and regression testing for new products added in CLF policy system.

Responsibilities:

Requirements Study for the customer requirements for maintenance change requests for the C.L.A.I.M.S. Application.

Techno Functional Designing and Coding for the C.L.A.I.M.S. Application Screen as per the functional requirement.

Functionality testing for the new features required in the C.L.A.I.M.S. Application.

Regression, Automation Scripts and Database testing for enhancements of the C.L.A.I.M.S Application.

Worked on high end SQL queries and joins for data manipulations and verification.

Meetings with the client to discuss the status of the project, clarify any queries regarding the functionality etc.

Participating in building knowledge repository for future use

Updating the existing test automation framework for existing features of the application

Performing defect summary reports to IT management

Discussing scope, estimates and resource requirements with senior management

Conducting status meetings, risk management and data backup activities in the project

Training and Documentation for all functionality added in the Claims Application.

Mentoring & Giving KT sessions to the team both functional & technical.

Creating task metrics related activities using project monitoring tools.

Environment: Manual Visual Basic 6.0, MS SQL Server 2K & Seagate Crystal Reports, Visual source safe, Windows NT, Test Director

Employer: Patni Computer Systems Ltd. (Capgemini / IGATE Solutions 05/2004-01/2005

GE Aircraft Engines QA Engineer

The GE Aviation HR – Corporate Systems had a requirement to make the resource data, posting, Interview change request etc. for the employees of GE Aviation through GE Support central Site and testing database updates. The project deals with verifying the workflow of users accessing the data of forms after submission.

Responsibilities:

Requirements Analysis: Clarifying the requirements sent by the client and explore the Support central Workflow Community viz. Workflow Form Community.

Modify Data Form Community having default data populated to develop all the features required for the Workflow forms.

Designing and Coding for the forms to automate the testing process as per the requirement.

Developing RTM, test cases documents for the feature of the Support Central Site

Testing the Workflow for the forms and data population in data forms. • Reporting the status of the project, clarify any queries regarding the functionality etc. with client.

Performing Security testing for various roles and verifying the DB updates

Defined the entrance and exit criteria, ensure business and technology acceptance

Documentation of the features used to develop workflow forms for Knowledge Management.

Conducting defect prevention activities in the project

Managing the documents of the project and configuration management related activities

Building classes scripts and SQL queries and subqueries to fetch data for the data forms.

Verifying the process management activities

Discussing risks associated during execution phase with leads

Providing knowledge transfer sessions to new members joining the team

Participating in review & status meeting with the Senior

Management/Customer

Environment: QTP, VB Script, Test Director, GE Support central Workflow Tool, PL/SQL, UNIX, TOAD, Oracle 7i, Visual Basic 6.0, MS SQL Server 2K & Seagate Crystal Reports, Visual source safe, Windows NT, HP QTP 9.1

Contact this candidate