Lakshmi Surekha Vedantam
Manual & Automation Test Engineer | BI Analyst
Denver
Summary
Seasoned Test Engineer with 8+ years of IT experience specializing in both manual and automation testing to ensure software quality and reliability across diverse platforms. Skilled in Tricentis Tosca Automation, snapshot testing, and API validation with a focus on delivering robust, defect-free releases. Proficient in CI/CD environments using Jenkins and Git, with hands-on experience in SQL-based backend validation and multimedia testing using FFMPEG. Strong expertise in database programming (PostgreSQL, MySQL, SQL Server) and data handling across formats such as JSON, CSV, Excel, and XML. Adept at translating data into insights through Tableau, Excel, and Salesforce Analytics Cloud. Recognized for Agile/Scrum project leadership, efficient defect management using Jira, and strong visualization skills with Lucid chart and Microsoft Visio.
Knowledgeable QA Engineer with solid foundation in automated testing frameworks and tools. Successfully contributed to enhancing software quality and reliability in various projects. Demonstrated ability in scripting test cases and identifying bugs, ensuring efficient and smooth software releases.
Overview
9
9
years of professional experience
Work History
Manual & Automation QA Engineer | CSG CRM & BP Portal
Comcast Business (Telecom)
10.2024 - 07.2025
- Automated and executed API and UI tests using Rest Assured, Selenium, JUnit, and Cucumber (BDD) for BP Self-Service Portal and VeraStream API.
- Validated secure credential flows involving NT login resets, LDAP replication, and password synchronization across CSG systems.
- Performed negative and edge case testing for expired sessions, invalid credentials, and error handling scenarios.
- Collaborated with cross-functional teams to troubleshoot authentication issues and verify production fixes.
- Authored regression suites and test plans aligned with Agile sprint goals, improving coverage and reducing defects.
- Led QA discussions across biller and authentication systems, ensuring quality alignment and delivery.
- Utilized SoapUI, Postman, and Graph Explorer for middleware API testing and exception tracking.
Manual & Automation QA Engineer | Clinical & BI Data
Sharecare (Healthcare)
01.2022 - 09.2024
- Validated clinical and operational datasets by designing and optimizing PostgreSQL queries for backend testing and data integrity.
- Automated ETL workflows using Informatica, improving test data quality and reducing manual effort.
- Built interactive Tableau dashboards and scheduled reports on Tableau Server to support QA reporting and stakeholder insights.
- Performed data wrangling on CSV, JSON, XML formats to prepare structured/unstructured datasets for analytics and test scenarios.
- Developed unit tests, validation checks, and data quality rules to ensure accurate reporting and reliable outcomes.
- Used FFMPEG to validate and process video datasets for multimedia test cases in analytics workflows.
- Collaborated with BI and QA stakeholders to gather requirements and manage the full reporting and testing lifecycle.
QA | BI Analyst
Xoriant Solutions Pvt. Ltd.
07.2020 - 11.2021
- Developed interactive Tableau dashboards for QA metrics, sales performance, and KPI tracking, integrating data from Excel, JSON, and Salesforce Analytics Cloud to support cross-functional decision-making.
- Automated ETL pipelines using SQL and Informatica, ensuring consistent and reliable test data across multiple environments for regression and performance testing.
- Designed QA architecture diagrams in Lucidchart and Microsoft Visio to visualize end-to-end reporting pipelines, middleware API flows, and test automation frameworks.
- Optimized backend validation processes by tuning SQL queries, indexing strategies, and stored procedures across PostgreSQL, MySQL, and SQL Server, improving execution time and system responsiveness.
- Streamlined test data preparation by scripting PowerShell-based automation for external data extraction and transformation, reducing manual effort and setup time.
- Collaborated within Agile Scrum teams, managing sprint tasks, defect triage, and test coverage using Jira, while contributing to BDD scenario design with Cucumber and Gherkin syntax.
Manual & Automation QA Engineer | CSG CRM
Comcast Business (Telecom)
03.2017 - 06.2020
- Specialized in CSG biller functional testing, covering account creation, billing cycle validation, payment processing, and service provisioning to ensure end-to-end telecom workflow integrity.
- Developed robust SQL validation scripts to verify billing transactions, service order accuracy, and backend data consistency across PostgreSQL and SQL Server environments.
- Collaborated with cross-functional teams to interpret business rules and ensure compliance with telecom billing standards and regulatory requirements.
- Automated CRM workflows—including account setup, billing triggers, and service assignments—using Tricentis Tosca, accelerating regression cycles and reducing manual effort.
- Engineered PostgreSQL schemas, tables, and queries to support CRM system performance tuning, reporting, and data integrity validation.
- Built ETL pipelines with Informatica, integrating structured data from CSV, JSON, and XML sources to maintain synchronized test environments.
- Designed KPI-driven dashboards in Tableau and Salesforce Analytics Cloud to deliver actionable insights for QA reporting, customer behavior, and operational trends.
- Implemented snapshot testing and regression validation, reducing release cycle time by 30% and improving defect detection rates.
- Conducted exploratory data analysis (EDA) and ad-hoc investigations to uncover customer behavior patterns and inform test coverage strategies.
- Actively contributed to Agile Scrum ceremonies, managing Jira deliverables, refining test scenarios, and supporting sprint planning and retrospectives
QA Analyst
Dish Network
02.2016 - 02.2017
- Utilized FFMPEG scripting to validate, transform, and prepare video datasets for CRM workflows, enabling automated multimedia test scenarios and ensuring data integrity across service provisioning modules.
- Processed structured and unstructured datasets (CSV, JSON, XML) for test data preparation, backend validation, and analytics across CRM components, integrating with Informatica ETL pipelines and PostgreSQL for scalable reporting.
- Built SQL-based validation scripts to verify multimedia transaction accuracy and service order consistency, supporting cross-platform QA efforts.
- Designed KPI-driven dashboards in Tableau and Salesforce Analytics Cloud to visualize CRM performance, customer engagement, and test coverage metrics.
- Automated CRM workflows—including account creation, billing, and service assignment—using Tricentis Tosca and BDD scenarios in Cucumber with Gherkin syntax.
- Collaborated in Agile Scrum teams, managing Jira deliverables, refining test architecture diagrams in Lucidchart and Visio, and driving sprint-based QA execution.
Education
Master of Science - Business Management and Information Technology
University of Arizona Global Campus
Arizona03.2024
Skills
Technical Details Testing Tools: Tricentis Tosca Automation, Snapshot Testing, Selenium, JUnit, Cucumber
Timeline
Manual & Automation QA Engineer | CSG CRM & BP Portal
Comcast Business (Telecom)
10.2024 - 07.2025
Manual & Automation QA Engineer | Clinical & BI Data
Sharecare (Healthcare)
01.2022 - 09.2024
QA | BI Analyst
Xoriant Solutions Pvt. Ltd.
07.2020 - 11.2021
Manual & Automation QA Engineer | CSG CRM
Comcast Business (Telecom)
03.2017 - 06.2020
QA Analyst
Dish Network
02.2016 - 02.2017
Master of Science - Business Management and Information Technology
University of Arizona Global Campus