Sowmya Regatti
Cumming,GA
Summary
Accomplished QA Lead, ETL Developer, and Manager with a remarkable 16-year career spanning the entire SDLC across diverse industries, including Healthcare, Insurance, Finance, Retail, and Government. Extensive experience in designing and implementing robust test strategies, ensuring comprehensive coverage of functional and non-functional requirements. Expertise in test automation frameworks such as Selenium, Cucumber, Karate, and Appium, streamlining testing processes and improving software quality. Skilled ETL Developer with hands-on experience in designing and implementing efficient ETL processes using SSIS and T-SQL. Thrives in agile environments, leveraging Scrum and Kanban methodologies to collaborate effectively with cross-functional teams. Proven track record of success in delivering high-quality software solutions, staying at the forefront of industry trends and best practices.
Overview
17
17
years of professional experience
Work History
QA Lead/Test Manager (SDET)
PNC Bank
05.2021 - Current
- Designed and implemented automation framework using Java, Gradle, and Karate
- Mentored QA team on automation best practices
- Facilitated defect triage and prioritization
- Utilized Karate for functional, integration, and regression tests of SOAP and REST services
- Conducted Oracle database testing and validated IBM Mainframe applications
- Collaborated with development and DevOps teams to integrate QA into CI/CD pipeline.
Automation QA Lead/QA Manager
Department of Public Safety, State of MN
01.2020 - 03.2021
- Implemented test automation frameworks using Appium and Selenium with C#
- Performed REST API testing and IBM Mainframe testing
- Designed and executed 508 accessibility testing
- Prioritized backlog items and production issues for sprint releases
- Implemented WebServices automation using Karate.
Sr. QA Engineer
UCare
09.2019 - 01.2020
- Configured and tested rules for business processes in healthcare
- Developed SQL scripts for database and ETL validation
- Created performance scripts using JMeter
- Validated ESI Pharmacy Claims files, CCMS to Guiding Care Authfiles, and 837/835 EDI transactions
- Designed and created automated test scripts using Selenium, Selenium Grid, and Spec-Flow.
Senior QA Analyst
State of MN – Department of Corrections
03.2018 - 08.2019
- Developed SQL queries for backend testing and data validation
- Performed UAT testing and wrote acceptance test cases
- Designed and executed 508 accessibility testing
- Coordinated tasks and delegated to team members
- Verified data for data conversion and tested functionality of desktop applications
- Awarded Certificate of Appreciation by Commissioner for outstanding performance.
Senior QA Analyst
Carlson Wagonlit Travel
09.2016 - 03.2018
- Prepared test data and executed test scenarios in Rally
- Created and executed JMeter scripts for performance testing
- Performed unit testing, accessibility testing, and multi-browser/device testing
- Documented results, daily status reports, and project closure reports
- Communicated with offshore QA team for test status.
ETL Developer/QA Analyst
Trustmark Insurance
01.2014 - 06.2016
- Designed and implemented ETL processes using SSIS and T-SQL
- Performed data profiling, cleansing, and validation
- Created Selenium scripts for regression testing using Java & JUnit
- Extensively tested ETL transformation rules and stored procedures
- Verified source data loaded correctly into target database
- Wrote SQL queries for database validation.
QA Analyst
DTL
08.2010 - 12.2013
- Tested integration of sales transactions and reward management programs
- Developed test strategies and plans based on client requirements.
Video Game Tester
EA Sports
06.2007 - 07.2010
- Identified and reported bugs for video games on various gaming consoles
- Documented testing procedures and edited test cases.
Education
B.Tech -
Jawaharlal Nehru Technological University
Skills
- JIRA
- Rally
- Jenkins
- Git
- SSIS
- Kafka
- IBM Mainframe
- Java
- C#
- SQL
- PL/SQL
- JavaScript
- Selenium
- Cucumber
- Karate
- Postman
- JMeter
- Appium
- Quality Center
- SQL Server
- Oracle
Timeline
QA Lead/Test Manager (SDET)
PNC Bank
05.2021 - Current
Automation QA Lead/QA Manager
Department of Public Safety, State of MN
01.2020 - 03.2021
Sr. QA Engineer
UCare
09.2019 - 01.2020
Senior QA Analyst
State of MN – Department of Corrections
03.2018 - 08.2019
Senior QA Analyst
Carlson Wagonlit Travel
09.2016 - 03.2018
ETL Developer/QA Analyst
Trustmark Insurance
01.2014 - 06.2016
QA Analyst
DTL
08.2010 - 12.2013
Video Game Tester
EA Sports
06.2007 - 07.2010
B.Tech -
Jawaharlal Nehru Technological University
Similar Profiles
Gene Vences-SanchezGene Vences-Sanchez
Branch Banker at PNC Bank, Pittsburgh National Corporation BankBranch Banker at PNC Bank, Pittsburgh National Corporation Bank
Tammy BentonTammy Benton
Sr Banker /DMLO at PNC Bank/National City BankSr Banker /DMLO at PNC Bank/National City Bank
Erica HendryErica Hendry
Personal Banker/Loan Officer at PNC Bank/National City BankPersonal Banker/Loan Officer at PNC Bank/National City Bank
Abel Maldonado JrAbel Maldonado Jr
International Trade Specialist at PNC Bank, Pittsburgh National Corporation BankInternational Trade Specialist at PNC Bank, Pittsburgh National Corporation Bank
Daniel FischerDaniel Fischer
Manufacturing Technology Manager at GAFManufacturing Technology Manager at GAF