Vamsi Yalamanchili
Summary
Extensive experience working across Healthcare, Retail, Financial Services, Pharmaceutical, and Oracle CPQ Cloud (BigMachines) domains. Strong hands-on expertise in Data Governance, ETL Testing, and Test Automation, leveraging tools such as Collibra, ODI, Selenium WebDriver, TestNG, Coded UI, JMeter, and SOAP UI. Strong understanding of Data Warehouse concepts and dimensional modeling, including Star Schema and Snowflake Schema architectures. Solid experience in ETL Testing with hands-on exposure to ODI and OBIEE. Experience in designing governance frameworks, implementing data quality controls and enabling enterprise-wide compliance. Maintained detailed documentation of data remediation activities and monitored issue resolution to improve data reliability and operational decision-making. Executed data testing procedures to verify consistency, accuracy, and compliance with organizational data quality standards. Built data quality scorecards and acceptance criteria, partnered with owners to remediate issues and report KPI trends to leadership. Promoted data governance best practices by supporting implementation of data quality frameworks, policies, and control processes across department. Collaborated with engineering, security, and business teams to establish governed data lifecycle controls, improving data trust and reducing compliance and operational risk across utility data platforms. Hands-on experience in Web Application Security Testing, utilizing tools such as Acunetix, Wapiti, SQLMap, and Vega to identify and mitigate vulnerabilities. Proven expertise in Test Strategy, Test Planning, Test Approach Definition, Defect Management, Test Effort Estimation, and Resource Planning for large, complex programs. Integrated automated test suites into CI/CD pipelines using Jenkins, Git, Azure DevOps, and GitHub Actions to trigger continuous test execution on every code check-ins. Extensive experience practicing Agile delivery methodologies; Certified Scrum Master (CSM) from Scrum Alliance with strong skills in: ||Agile estimation (Story Points, T-Shirt sizing) || Capacity and resource planning ||Translating business requirements into realistic delivery timelines. Strong focus on process improvement and workflow optimization, driving continuous improvement across QA and data quality practices.
Overview
17
17
years of professional experience
Work History
Project Lead
Duke Energy
Charlotte, NC
02.2022 - Current
- Analyzed Business and System Requirement Specifications (BRS/SRS) and participated in BA walkthroughs to validate ETL and analytics requirements.
- Authored test strategies, test plans, test scripts, and executed complex SQL validations to ensure data accuracy and completeness.
- Performed source-to-target data validation, including detailed field-to-field reconciliation across ODS and target data stores.
- Validated ETL mapping logic, load processes, and data transformations to ensure accurate population of target tables.
- Define and enforce data policies and standards related to data quality, metadata, lineage, classification, and lifecycle management.
- Configure and manage data catalogs (e.g., Collibra) to maintain business and technical metadata.
- Establish and maintain end-to-end data lineage from source systems through ETL pipelines to downstream analytics and regulatory reports.
- Tested and validated data from multiple enterprise systems, including OMS and Customer Connect, ensuring consistency across upstream sources. Support data discovery and self-service analytics for business and technical users.
- Duke Energy is a leading energy company focused on electric power and gas distribution operations, and other energy services in the Americas – including a growing portfolio of renewable energy assets. Worked on OMS – Outage Management Systems, BMS- Billing Management systems and DW-ETL.
- Environment: Oracle, SQL Server, TOAD, Jira, ODI 12c,OBIEE,Collibra,Informatica,MS Project, SharePoint
LeadQA/Onsite coordinator
GGBS – AJ Gallagher
IL
06.2017 - 11.2021
- Business Requirement analysis. Align with business teams to understand and translate business requirements into test requirements.
- Coordinated all facets of testing for Gallagher –GGB-US strategic projects - EPIC, CSP, NBC, and DMS including development of the test strategy.
- Performed System Testing/Functional Testing, Smoke Testing, Integration Testing, API testing, Regression Testing, and UAT testing.
- Developed and Designed TestNG Automation Testing Framework for web services using Rest Assured, Rest Template, Spring and JAVA in Windows platform in Agile Environment.
- Used TestNG for data driven testing and used Spring framework to handle the tests in multiple environments.
- Developed automation scripts for the UI using Java, Selenium and TestNG.
- Web Application Security testing for Vulnerabilities using Wapiti tool.
- Contributed to the code coverage for regression test suite by automating almost all the test scenarios.
- Test Summary Reports, Defects Report and Status Reports.
- Review test plans and specifications to ensure process compliance.
- Define and execute defect management processes, monitoring and communicating project status.
- Production support.
- Deployment on QA and Staging environments using Tools – Microsoft Visual Studio, Jenkins (For automation scripts) and Octopus.
- End-to-end automation of tests to integrate QA into DevOps processes to maintain continuity.
- Integrate the automated test suite in the CI/CD pipeline to ensure that automation batches are executed in an automated manner with every code check-in.
- Weekly Bug triage and review meetings.
- Work closely with cross functional teams to resolve project defects.
- Test Plan, and Test cases for complete end-to-end testing of the application.
- Evaluating the test effort and working with the onsite delivery manager to understand the project scope and expectations, thereby defining test strategies.
- Assisted in preparing presentations, dashboards, and weekly status reports.
- Coordinated logistics for workshops, training sessions, and stakeholder meetings.
- Daily standup meetings, sprint retrospective meetings, Release Plan Meetings etc.
- Offshore QA team mentoring.
- GGBS –Gallagher Global Brokerage Services is a subsidiary division of AJ Gallagher that cater to the internal software development needs. Development involves proprietary ownership of various products – CSP,PAT-E,SLM,NBC, Document Management system, CSO Reports
- Environment: .net, Coded UI, TFS, Selenium, Wapiti,MS- Visio, SQL, SoapUI, Jira, Oracle, TOAD Windows.
Sr.QA Analyst
Kareo
CA
08.2014 - 09.2015
- Business Requirement analysis. Align with business teams to understand and translate business requirements into test requirements.
- Functional Testing, GUI Testing, Regression Testing, Web Services & API testing, Smoke testing and Sanity testing on web and mobile.
- Executing end to end scenarios test cases using sample test data.
- Developed automated test scripts using Selenium.
- Kareo is a complete solution for small practices that helps doctors to manage practices and provides an efficient medical billing system to them. Kareo is expanding and trying to capture more providers by offering EHR (Electronic Health Record) which is a web application to manage clinical data and it also offers marketing module for providers which empowers them to engage with patients. Kareo is built on Java using Micro-Services Architecture.
- Environment: Java, .Net, ROR, Oracle, SQL Server, TeamCity, SoapUI, Selenium, Jenkins, TestStuff, Jira.
QA Lead
Epocrates Online
06.2013 - 08.2014
- Performed System Testing/Functional Testing, Smoke Testing, Integration Testing, Regression Testing, API, UAT testing.
- Involved in preparing Test Summary Report, Defects Report and Status Reports.
- Involved in Backend testing of the database by writing SQL queries to test the integrity of the application
- Review test plans and specifications to ensure process compliance.
- Define and execute defect management processes, monitoring and communicating project status.
- Testing of app on various iOS and android devices.
- Evaluated open-source Load testing tools like Grinder and JMeter.
- Deployment and Production support.
- Preparing Status Reports and participating weekly triage and review meetings for understanding the complexity of the application modules.
- Work closely with cross functional teams to resolve project defects.
- Involved in developing Test Plan, and Test cases for complete end-to-end testing of the application.
- Evaluating the test effort and working with the onsite delivery manager to understand the project scope and expectations, thereby defining test strategies.
- Provide the best possible patient care with Epocrates Online Health portal- a free, fast, and effective way to find clinical information at the point of care. Unlike other online medical references, Epocrates Online organizes practical, peer-reviewed content with a unique patient-centered approach, providing you with answers. The most relevant information by clinicians, for clinicians. Easy-to-use expandable menus that let you go from concise to comprehensive. Look up a monograph directly, or find specific information through an open-text search.
- Environment: JAVA/J2EE, Selenium, JMeter, Oracle,Toad,Jenkins, , MS- Visio, Linux, Windows.
QA Lead
Epocrates EHR
CA
09.2012 - 03.2013
- Integration testing with third party services – Surescripts and Allscripts.
- Preparing load data using UNIX shell scripting.
- Automation of test scenarios using Selenium Web driver.
- Web services and API testing using SOAP UI.
- Executing the test cases using sample test data.
- Creating test data based on the test cases and executing the test cases manually.
- Build Release management from Offshore.
- Daily Status and Defect Status reports.
- Works with technical analysts to identify unit testing coverage and ensure any gaps are addressed.
- Ensure traceability of test cases to requirements, working with the project Business Analyst to ensure all requirements are tested.
- Work with Testing Coordinator to ensure testing of functional areas is complete, tracked and on-schedule.
- EHR is a SOA driven electronic health records Software as a Service (SaaS) application with cross functional integration from Epocrates built to meet the specific needs of the small physician practice. This application allows providers to retrieve patient records and process prescriptions anytime, anywhere with time-saving accuracy that benefits the physician, the practice, and the patients. Providers will have quick, easy access to vital patient information "on the go" with the ability to view their appointment schedule, search for any patient within the enterprise, access and view a patient’s chart including demographics, problems, medications, allergies, vitals, immunizations, history and completed notes, write a prescription and send it electronically to the pharmacy.
- Environment: JAVA/J2EE, Spring Framework, Eclipse Tool Kit, JUnit, Ant, Maven, MySQL, MS-Visio, Oracle, and Web logic.
Principle Engineer -QA
Depotpoint
CA
07.2010 - 08.2012
- Involved in Analysis, Design and Testing of full web application functionality.
- Functional, UI, Integration, Regression testing of various core modules of SSE and REO applications.
- Defect tracking and Test Management.
- Participated in walkthrough and defect report meetings periodically.
- Developed and Designed JUnit Automation Testing Framework for Patient data web-based application using Selenium WebDriver and JAVA in Agile Environment.
- Implemented Data Driven framework using Selenium WebDriver
- As part of compatibility testing, executed the automated test scripts across multiple browsers like IE, Firefox, Chrome and Safari on Windows operating system.
- SSS & REO from Jan 2010 to August 2012 Depotpoint's SSS and REO are web-based solutions that allow investors to close properties faster, increase productivity and drive down the total cost of managing properties and loans. It streamlines REO processing by tracking and automating many required activities, and centralizes all communication and document processing, including offer submittal and acceptance.
- Environment: J2ee, Java Script, JSP, Struts, EJB, API, Tomcat, Dekoh (Pramati server), Embedded Derby database, Oracle10g, Bugzilla, Jira, Win2000, Web services, SOAP, XML, WSDL, AXIS, Hibernate, LDAP, TOAD, CVS.
Principle Engineer -QA
CPQ (BigMachines,CA)
03.2009 - 06.2012
- Involved in Analysis, Design and Testing of BM Unplugged Tool that spanned over testing of full web application functionality.
- Functional, UI, Integration, Regression testing of various core modules of BM platform – Configuration, Commerce, Document engine and Pricing.
- Preparing load data using UNIX shell scripting.
- Worked on BML to create Configuration/Commerce rules & Library functions.
- Worked on layout editors to create configuration, commerce UI
- Defect tracking and Test Management.
- Participated in walkthrough and defect report meetings periodically.
- Prepared Daily Status and Defect Status reports.
- Ss: The Lean Front-End gives the functionality to quickly create own powerful, web-based selling engine and to enable channels, customers, sales staff, and product experts to collaborate in real-time over the Internet. The Lean Front-End reduces customer’s cost, but also helps them grow revenues. The LFE Software is extremely flexible and easy to set-up, maintain, and integrate with the Legacy systems. It has a powerful feature of unplugged software where in Sales representatives can prepare in Quotes without Internet and later on Sync with the Online Application upon availability.
- Environment: J2ee, Java Script, JSP, Struts, EJB, API, Tomcat, Dekoh (Pramati server), Embedded Derby database, Oracle10g, Bugzilla, Jira, Win2000, Web services, SOAP, XML, WSDL, AXIS, Hibernate, LDAP, TOAD, CVS.
Education
MCA - Master’s In Computer Applications
Osmania University
India2002
Skills
- QA Tools: Selenium, Tosca, QTP, Coded UI, SOAP UI, Grinder, JMeter, Accunetix, Wapiti, UiPath
- Data Governance: Collibra
- Databases & Tools: Oracle, Snowflake, TOAD, SQL
- PLUS, SQL
- Loader, SQL Server 2016
- Scripting Languages: Unix Shell scripts, JavaScript, VB scripting
- Languages: Java, SQL, PL/SQL, BML
- Operating System: Sun Solaris, Unix, Linux, Windows NT/XP/2000/98
Other Projects worked
Conformia- SUMS, ASAP, Sargini-ITC, Isethan,cBizmailer. More details for the other projects will be provided on request.
Timeline
Project Lead
Duke Energy
02.2022 - Current
LeadQA/Onsite coordinator
GGBS – AJ Gallagher
06.2017 - 11.2021
Sr.QA Analyst
Kareo
08.2014 - 09.2015
QA Lead
Epocrates Online
06.2013 - 08.2014
QA Lead
Epocrates EHR
09.2012 - 03.2013
Principle Engineer -QA
Depotpoint
07.2010 - 08.2012
Principle Engineer -QA
CPQ (BigMachines,CA)
03.2009 - 06.2012
MCA - Master’s In Computer Applications
Osmania University