Summary
Overview
Work History
Education
Skills
Certification
Awards
Timeline
Generic

Swetha Patil

Orlando,FL

Summary

Over 12 years of experience in software testing and test management of Web-based applications, Client / Server applications, Mobile Applications, Mainframe and data warehousing applications. Provide end-to-end testing support for time and business-critical projects by leading test strategy, plan, execution, documentation, defect management, and status reporting. Good experience in the financial, federal government, Satellite Telecommunications, clinical, and healthcare sectors. Worked in different areas of Healthcare – Claims, Accumulators, Enrollments, and Benefits. Experience with health care Systems: QNXT and HIPAA standards. Experience with industry-standard methodologies like Waterfall and Agile. Working knowledge of operating systems like Windows, Unix and Ubuntu. Demonstrated experience in using RBDMS like Oracle10g/9i, Teradata, Postgres, SQL Server and MS Access. Strong technical skills in ETL tools Informatica and SSIS. Well versed with the Agile Methodology. Good experience in working with AWS S3 Storage and lambda process. Expertise in testing mobile applications. Good experience in working and coordinating with offshore teams. Hands on experience with working on the DevOps tools like Jenkins, GitLabs, GitHub and Docker. Good experience in writing automation scripts using Selenium tool, Gauge tool and Test Rigor. Extensive experience in performing various types of testing such as Integration, Functionality, System, Regression Testing, User Acceptance testing. Good experience in handling multiple projects concurrently and interacting different stakeholders. Extensive knowledge in gathering and understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), SRS (Software Requirement Specifications) and Used cases. Participated in Status, Defect Review and Go/No-Go meetings. Good experience in performing Performance Testing using Load Runner, Jmeter. Excellent analytical, problem solving, communication & interpersonal skills.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Test Manager

Caregility
11.2021
  • Involved in product design reviews to provide input on functional requirements, product designs, schedules, and potential testing execution and deliverable timeline risks and administered working of vendors, and ensured the scheduled progress of projects
  • Created and Managed User Stories, Test cases, and Defects in Agile Central
  • Played an instrumental role in product deliverables and was involved in all stages of testing from requirement gathering to testing execution
  • Lead the QA team in testing the iConsult application for all the releases
  • Involved in End to End testing of the iConsult application with all new features like Multi call, Clinician to Clinician calls, and Clinician to Guest calls in both desktop and mobile applications
  • Performed Rest API testing using Postman for the endpoints and validated the responses
  • Involved in testing Admin Portal to verify various user registrations, and user permissions depending on the user role
  • Performed Clinician registrations and verified bedside patient calls on both desktops and mobile applications
  • Participated in product implementation meetings with different healthcare clients
  • Automated the clinician-to-patient calls using the Test Rigor tool
  • Tested iConsult and iObserver products following HIPAA-compliant audio and video communication
  • Performed ETL testing for the User Management module
  • Performed Batch Job Testing for the users registration module
  • Active participation in the daily standups to update on the testing status
  • Performed HL7 messages testing for the iObserver project
  • Involved in all the sprint refinements, sprint planning, and sprint retrospective meetings
  • Lead the Defect Triage meetings with the product manager and tech leads to triage all the open bugs and decide on the fixed versions
  • Performed Database Back-End integration testing by writing SQL queries and validating the data for all the workflows
  • Managing the Offshore team in all the testing activities.

Senior QA Analyst / ETL Developer

Kaizen Technologies Inc, Edison, NJ
10.2009
  • Responsibilities include Business Requirement Analysis, Functional Requirement Preparation, Over All Design, Use-Case analysis, Initial Summary, Risk Analysis, Test Plan development, Test Case generation, Test script Preparation
  • Requirement Traceability Matrix (RTM) is created to trace all the system requirements to the test cases
  • The tracing of requirements to the test cases was done in Quality Center
  • Involved in doing the System testing, Regression testing, Integration testing and volume testing for various projects
  • Interacted with the developers in understanding the requirements through out the testing process
  • Involved in writing SQL queries with joins and filters to validate the Referential integrity and Data integrity between different related tables in the Data warehouse
  • Custom reports are developed using ETL tools for the business group
  • Supported and participated in UAT (User acceptance testing) by loading the data into the data warehouse for the users to do UAT and to clarify the technical related questions during the UAT
  • Extensively worked with the Session logs generated by the ETL jobs in finding the errors, successful rows, rejected rows of the target data
  • Involved in Claims processing system, Membership, Claims, Provider Enrollment, Benefits and Payments on QNXT systems
  • Involved in testing EDI ANSI X12 837P, 837I, 837D and 835 Transaction sets as a part of EDI testing
  • Generated the bug reports for the managerial review
  • Ensure that all system modifications are performing in accordance with functional specifications
  • Involved in extensive data validation using SQL queries and back-end testing
  • Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs
  • Involved in testing the batch programs by using the Autosys tool
  • Reviewing UAT Test Plans and Test Scripts
  • Provided management with daily status reports.

Integration Test Lead

Kythera Space Solutions
11.2020 - 10.2021
  • Working with the client team in daily standup meetings, requirements meetings, project gate review processes, and defect triage meetings
  • Work with the team members in the project progress and mentoring the team in understanding the Satellite Telecommunications applications
  • Extensively worked on documenting the test strategy for all the releases
  • Working on setting up the integration environment for verifying the different modules
  • Good experience in making merge requests in GitLab when any updates required for any test data, ReadMe documentations and merging the code changes from develop branch to the testing branch
  • To create any new builds extensively used Jenkins tool
  • Before any integration testing starts, Linux test terminals are updated with all the latest merge requests and builds
  • Verification of the ARC optimizers, data collectors, preprocessing input, post processing outputs are all done by running the unix commands
  • Each application has Docker container set up so the execution of each application is executed independently with containers
  • Understanding the outputs from the ARC flow with the user terminals, gateways and satellites
  • Database setup, populating all the tables, executing the scripts are done through the python scripting
  • Gauge tool is used to automate the scripts for some of the modules in ARC by writing the python scripts
  • Team follows agile process and all day to day activities are updated in the daily standups
  • Any issues reported while testing are coordinated with the developers and help them in debugging the issues
  • Performed Rest API testing using Insomnia tool
  • Cypress tool is used to automate the UI for UI provisioning services
  • Active participation in the entire gate review process in the project
  • Jira tool is used in creating the user stories, defects found in testing, and any tasks related to capabilities are created in Jira
  • One-to-One sessions are conducted with the team members on a monthly bases to get to know the QA team both personally and professionally and help them in their career growth
  • Generated the splunk reports for the user search words in the system
  • Worked with the testers in the performance appraisal meetings in assessing the performance, setting goals
  • Helping the HR team in the interview process for bringing up the talented people in the team.

QA Lead

DSA Inc.
12.2018 - 10.2020
  • Managed a team of testers on various task orders in NARA project
  • Worked with product owners in understanding the requirements and created test plans based on the scope of the project
  • Actively participated in all the agile meetings throughout project and worked with all team members before starting testing
  • Mentoring the testers to make them understand the NARA catalog system and the integration with the DAS system
  • Worked in all the data migration projects 'Task Order 6 - Oracle to Elastic Search' and 'Task Order 8 - Solr to Elastic Search'
  • Worked with the Business Analysts at client to understand the requirements and write the use cases based on the requirements
  • Attended weekly O&M meetings with the client to know the status of the releases
  • Involved in regression testing whenever the changes are made to the existing system
  • Coordinated with the developers thought out bug life cycle
  • Extensively used TFS system for the help tickets or defects created by the user and get it fixed by working with the developers
  • Involved in writing the Test Plan, Test Summary documentations for all the releases and made sure they are submitted to client in time
  • Involved in doing the functional walkthroughs with the client before the client UAT starts
  • Participated in daily scrum meetings, refinement and sizing sessions of the user stories as part of the agile process
  • Supported Performance Testing to track the performance of the Search using the JMeter
  • Built the automation scripts to perform the regression testing using Selenium tool
  • Worked with different team members to understand the system while performing the System Integration testing
  • Performed lambda process testing as part of OCR in testing extracted files in S3 bucket
  • Extensively tested SQS message queue in AWS to make sure that the records are making correct entry in queue with correct action
  • Extensively used Kibana in testing Elastic Search when the data is migrated from Oracle to Elastic Search
  • Worked on AWS S3 storage whenever any digital objects are needed to upload into the DAS system and very good understanding of the lambda process
  • AWS data storage and once lambda process has been applied to the objects verified the extracted files generation like score files, .txt files, thumbnails
  • Very good understanding of the Tesseract and Tikka tools as part of the lambda process
  • Worked on ingestion of the test data with digital objects into the solr by generating the exports of test data through API in postman
  • Worked on multiple projects and was able to deliver the tasks on time
  • Performed database testing writing sql queries in validating the data inserts/updates/deletes when the application goes through the workflow process
  • Manually executed the indexing jobs with Linux commands in Gitbash
  • Extensively used Splunk to generate reports for evaluating performance metrics
  • Extensively used Chrome Dev Tools for inspecting browser errors and issues
  • Day to day working with the QA resources in assigning the task and getting updates on their tasks
  • Participated in the day to day meeting with the team members to know the status of the projects
  • Reviewing UAT Test Plans and Test Scripts and active participation in the UAT process
  • Actively participated in the sprint demos and performed demos on the user stories, which are completed as part of that sprint
  • Participated in the KT sessions to the juniors or newly joined in the team
  • Involved in the recruitment process by interviewing the QA candidates in the interview process.

Principal Test Engineer

REI Systems Inc.
05.2023 - 12.2018
  • Very good understanding of the stored procedures and tested the integrity checks that are scheduled weekly
  • Involved in testing the weekly and monthly jobs by creating the test scenarios
  • Involved in testing the Data migration by writing the complex sql queries when data is moved from one system to another
  • Coordinated with Business Analysts in gathering the requirements and analyzing the use cases
  • Attended bi-weekly meetings with the client and business analysts in requirements process
  • Actively participated in the defect triage meetings and prioritizing the defects
  • Involved in regression testing whenever the changes are made to the existing system
  • Coordinated with the developers thought out bug life cycle
  • Worked on testing the JSON files generation
  • Extensively used TFS system for the User Stories Management at Sprint Level and for maintaining the testing tasks for all the User Stories
  • Involved in writing the Test Strategy, Test Summary documentations for all the releases and made sure they are submitted to client in time as part of the client EPLC process
  • Involved in doing the functional walkthroughs with the O&M vendors
  • Involved in the process of transitions to the O&M vendors
  • Participated in testing Members, Providers, and Claim Processing and Pricing and Payment modules and HEDIS functionalities
  • Tested the end-to-end process from loading the claims into QNXT system, processing them through the Payment process
  • Participated in daily scrum meetings, refinement and sizing sessions of the user stories as part of the agile process
  • Tested the integrity checks by writing the complex sql queries
  • Involved in Section 508 compliance testing with respect to 508 standards using Wave, JAWS tools
  • Performance Testing has been performed on the web applications to track the performance of the pages in every release using Load Runner
  • Worked with different team members to understand the system while performing the System Integration testing
  • Worked with the managers in giving the QA estimations for every project release
  • Worked with the operations team in analyzing any production issues
  • Worked with the Configuration Management team in the build process when the developers make any new code check-ins
  • Tested the reports by writing the SQL queries and cross validating the data with the applications
  • Participated in the day to day meeting with the team members to know the status of the projects
  • Reviewing UAT Test Plans and Test Scripts and active participation in the UAT process
  • Attended the Bi-weekly defect triage meetings with the clients
  • Participated in the KT sessions to the juniors or newly joined in the team
  • Involved in the recruitment process by interviewing the QA candidates in the interview process.

CRM Consultant

SAP Labs, Bangalore, India
07.2008 - 11.2008
  • Requirement Traceability Matrix (RTM) is created to trace all the system requirements to the test cases
  • The tracing of requirements to the test cases was done in Test Director
  • Involved in doing the System testing, Regression testing, Integration testing and volume testing for various projects
  • Coordinated with various upstream and downstream systems to do integration and end to end testing for different projects
  • Interacted with the developers in understanding the requirements throughout the testing process
  • Tested the reports generated by the reporting tool Business Objects
  • Involved in writing SQL queries with joins and filters to validate the Referential integrity and Data integrity between different related tables in the Data warehouse
  • Used Test Director to store and report bugs
  • Responsible for driving E2E Test scenarios efforts and in identifying test data for UAT
  • Efficiently used the Error Handling methods and implemented throughout the mappings
  • Involved in extensive data validation using SQL queries and back-end testing
  • Participated in Go/ No-Go meetings
  • Provided management with daily status reports.

Quality Analyst

Informatica Business Solutions Pvt Ltd, Bangalore, India
12.2007 - 05.2008
  • Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data, and Traceability Matrix
  • Conducted Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT), and Performance testing
  • Involved in functional testing of the Informatica Client tools i.e
  • Power Center Designer, Repository Manager, Workflow Manager and Workflow Monitor
  • Experience in defining data quality dimensions, building data quality scorecards using Informatica Data Quality
  • Involved in Regression testing by making use of PMAAT Tool
  • Worked with SQL queries and Unix Shell Scripts
  • Involved in installation testing of the Informatica client and server on Windows and Unix Operating Systems
  • Executed Informatica Mappings to test extraction from SQL Server and oracle-based sources
  • Worked on Relational database connections and FTP connections to test database integrity
  • Executed Informatica Maps to test extraction from legacy, SQL Server and oracle-based sources
  • Created Traceability between Requirements in RequisitePro and Test Cases in Test Manager.

Education

Skills

  • Test Tools: Jira, Xray, TFS, ALM Quality Center, Load Runner, Rational Tools, Selenium, Test Rigor, Gauge, Cypress
  • ETL Tools: Informatica 86/85, SSIS 2005
  • Healthcare Systems: Facets, QNXT
  • Reporting Tools: Micro strategy, Tableau
  • Database: Elastic Search, Oracle, Postgres, SQL Server, MS Access
  • UNIX Tools/Utilities: Bash, Gnome, Vi
  • ERP Packages: SAP CRM
  • API Tools: Insomnia, Postman
  • Languages: XML, Java, Json, Python scripting
  • Operating System: Windows 11/10, Linux, Unix
  • Methodologies: Agile, Waterfall
  • DevOps Tools: GitLab, GitHub, Docker, Jenkins, Kubernetes, Slack, Kibana
  • Cloud Platform: AWS
  • OCR Tools: Tesseract, Apache Tika
  • MS Office Tools: MS Office, MS Word, MS PowerPoint, MS Teams, MS Visio, Outlook, SharePoint, One Drive

Certification

  • International Certificate in ISTQB - Foundation level.
  • International Certificate in ISTQB – Agile Tester.

Awards

GEM Award for the excellent performance in the project.

Timeline

Principal Test Engineer

REI Systems Inc.
05.2023 - 12.2018

Test Manager

Caregility
11.2021

Integration Test Lead

Kythera Space Solutions
11.2020 - 10.2021

QA Lead

DSA Inc.
12.2018 - 10.2020

Senior QA Analyst / ETL Developer

Kaizen Technologies Inc, Edison, NJ
10.2009

CRM Consultant

SAP Labs, Bangalore, India
07.2008 - 11.2008

Quality Analyst

Informatica Business Solutions Pvt Ltd, Bangalore, India
12.2007 - 05.2008

Similar Profiles

CREATE PROFILE
Swetha Patil