Home

Srilakshmi Vishnubhotla - ETL Test Engineer/QA Analyst

[email protected]

Location: Dallas, Texas, USA

Relocation: YES

Visa: H1B

Resume file: Srilakshmi Vishnubhotla_ETL Test Engineer_1775843627540.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Srilakshmi Vishnubhotla |ETL Test Engineer/QA Analyst | Phone: 4695819864 | Email: [email protected] PROFESSIONAL SUMMARY Over 8 years of experience as a Senior ETL Test Engineer and QA Analyst, with a strong background in ETL/data warehouse testing, report automation, and manual/functional testing. Expertise in designing and executing ETL testing strategies including unit, integration, regression, and user acceptance testing (UAT) across banking, finance, healthcare (PBM), and MDM domains. Strong hands-on experience in validating data pipelines using SQL, Python, and SAS, ensuring end-to-end data accuracy from source systems to reporting layers. Proficient in report testing and automation, including rationalization and validation of reports across Tableau, MicroStrategy, Excel, and SAS, ensuring consistency with legacy outputs. Adept at reverse-engineering SAS scripts to extract business logic, transformations, and dependencies; created SQL validation scripts to test row-level and aggregate-level data. It played a key role in report factory automation, helping eliminate 40+ hours of manual effort per day through Python-based workflows and test automation. Experience in data quality assurance, implementing checks, thresholds, alerts, and validations to maintain reporting integrity and reliability in production. Involved in report rationalization projects, analyzing 300+ reports for redundancy, usage, and business value, categorizing them for optimization or decommissioning. Successfully validated automated scheduling, data refresh, and delivery mechanisms for reports (e.g., email, portal, batch jobs) to ensure system readiness. Led PBM domain testing for CVS Health, focusing on RxClaim, eligibility validation, benefits configuration, clinical testing, and formulary validation across multiple lines of business. Strong knowledge of PBM tools such as EZ Query, NDC Lookup, and EZTest; performed claim/query testing and production issue root cause analysis. Experience in Master Data Management (MDM) testing using Tamr, including entity resolution, data enrichment, golden record validation, and data consistency testing. Skilled in creating detailed test plans, test cases, defect logs, validation checklists, and test summary reports for each test cycle or deployment. Worked in Agile/Scrum and Waterfall environments; actively participated in sprint planning, client discussions, requirement gathering, and UAT signoffs. Strong communication and stakeholder engagement skills; created user documentation, training materials, and led knowledge transfer sessions for automation adoption. CMS Platforms : OpenText Web Experience Manager (WEM), Adobe Experience Manager (AEM) Testing Tools : Query Surge, EZ test, Tosca ETL & Data Tools : Snowflake, SQL Server, Rx Claim/AS400 Languages : HTML, XML, SQL CMS : OpenText Web Experience Manager (WEM) Defect Tracking Tools: JIRA, Rally, Confluence Operating System : Windows, Unix Cloud Platform : AWS, Snowflake Productivity Tool : MS Excel Certifications : Tricentis Tosca Fundamentals Automating web application testing (AS1) Tricentis Tosca Fundamentals Optimizing test automation with centralized test data (AS2) Certified ScrumMaster SnowPro Core Certification Quant System Solutions USA Client: Truist Project: Report Factory Senior ETL Test Engineer December 2024 Present Description: The CSBB Report Factory Automation and Support project aims to automate the manual reporting processes currently handled by the Report Factory team, thereby reducing the dependency on manual interventions from EDA developers. The project involves designing and implementing automated reporting solutions in collaboration with CSBB LOB partners while ensuring business continuity for approximately 140 existing reports until full automation is achieved. Key objectives include rationalizing reports, categorizing inventory, identifying redundancies, planning consolidation, assessing technical feasibility, executing automation, testing and validating, providing training, and transferring knowledge. Responsibility: Automated report generation workflows by sourcing data from Excel, relational databases, and cloud systems using Python, eliminating 40+ hours of manual effort per day. Designed and executed end-to-end testing strategies for automated report generation pipelines: oUnit Testing: Validated script logic, row counts, and data type transformations. oIntegration Testing: Ensured seamless data flow across multiple data sources and report formats. oRegression Testing: Compared automated report outputs against historical/manual reports to confirm consistency. oValidation Scripts: Created SQL-based test cases to verify KPIs, metrics, and aggregation logic. Generated comprehensive test reports documenting test coverage, defect logs, and remediation status for each report automation cycle. Evaluated the existing reporting ecosystem, identified data dependencies, stakeholder usage patterns, and created a usage classification matrix (High/Medium/Low). Collaborated with business stakeholders to gather reporting requirements and translated them into user stories, acceptance criteria, and validation checklists. Assessed automation feasibility by testing data availability, refresh timing, and integration compatibility with the tool. Implemented data quality checks and alerts to monitor report integrity, ensuring reliability and accuracy over time. Created user documentation and participated in UAT (User Acceptance Testing) cycles, capturing business feedback and ensuring final outputs met stakeholder expectations. Developed training content and hosted sessions for end-users to validate usability and adoption of new reporting dashboards and workflows. Maintained dual-run processes to support manual and automated reporting in parallel during transition, with side-by-side report comparisons to ensure business continuity. Project: Report Rationalization ETL Test Engineer March 2024 - December 2024 Description: Rationalized over 300+ stakeholder reports across Tableau, MicroStrategy, and SAS by analyzing report usage logs and audit trails to identify redundant, low-usage, and obsolete reports. Categorized reports into critical, high-usage, occasional, and decommission buckets to streamline reporting strategy and reduce maintenance overhead. Tested automated report generation workflows to ensure: Correct reports were triggered based on defined schedules. Output formats and delivery mechanisms (email, portals) worked as intended. Report contents matched existing business expectations and legacy outputs. oCreated test plans, test cases, and validation scripts to compare historical outputs with newly generated reports from optimized pipelines. oConducted regression testing to ensure no data or layout discrepancies post-migration or after automation implementation. SAS Script Decoding and Data Validation Testing: Analysed and reverse-engineered complex SAS programs to extract embedded logic, transformations, and data dependencies, including Database names, schemas, tables, and specific column usage. Created validation scripts for row-level and aggregate-level data comparisons between legacy SAS outputs and target data marts. Participated in User Acceptance Testing (UAT) cycles, capturing feedback, logging defects, and supporting remediation and revalidation efforts. Quant System Solutions USA Client: Western Union ETL Test Engineer October 2023 - March 2024 Designed and executed ETL test cases to validate data ingestion from multiple source systems (CRM, KYC, transactional systems) into Tamr s data lake. Developed and executed SQL-based test scripts to verify data mappings, data type consistency, and null/default handling during ingestion and transformation stages. Validated source-to-Tamr transformation logic, ensuring accurate application of business rules, mapping configurations, and deduplication logic. Performed data lineage and traceability testing to confirm records were correctly tracked across the Tamr pipeline, from raw ingestion through entity resolution to golden record creation. Created test scenarios to validate entity matching, clustering logic, and confidence scoring, ensuring Tamr s ML-driven deduplication aligned with expected results. Tested incremental loads and delta processing to verify system behaviour under real-time/near-real-time data enrichment workflows. Validated master data survivorship logic, ensuring the most trusted and recent attributes were retained when merging duplicate records into a single golden record. Conducted data integrity and consistency testing post-Tamr processing to ensure no data loss, duplication, or corruption during the enrichment pipeline. Designed and validated reconciliation reports comparing source data counts with processed records in Tamr to detect mismatches and ingestion failures. Participated in performance and volume testing to assess Tamr s ability to handle large-scale ETL jobs with millions of records across systems. Supported data quality profiling by integrating data quality rules and metrics into the Tamr pipeline validation process. Worked closely with data engineering teams to test and validate API-based integrations between Tamr and downstream systems consuming master data (e.g., analytics platforms, customer 360 views). Quant System Solutions USA Client: CVS Health Senior QA Analyst-PBM (Pharmacy Benefit Management) June 2023 - October 2023 CVS Health Pharmacy Services, the pharmacy Benefits Management (PBM) and Specialty pharmacy division of CVS Health, provides a full range of PBM services, Medicare Part D services, retail pharmacy network management services, prescription management systems, clinical services, and disease management services. CVS will implement Clients on the Rx claim platform. As part of the implementation, benefits plan designs, eligibility load, and multiple IT projects are developed and implemented. Responsibilities: Experience in CVS Health Care Manual testing. I started as a tester and am currently in the role of test manager for CVS in PBM (Pharmacy Benefit Management) Manage cases for 31 clients across all lines of business (MEDD, COMMERCIAL, EXCHANGE, MEDICAID) Strong understanding of the plan benefits Firsthand experience on Test Estimation, Test Strategy, and Test planning based on the project schedule and timelines Firsthand knowledge in Rx Claim, EZ Query, NDC Lookup, EZTest Experience in claim and query testing, PC diagnosis, Root cause analysis, and corrective plan measures Ownership for TCP (Test Check Point) for cases Worked on Health Plan Benefits Testing Project, which includes analyzing client requirements and performing commercial and clinical testing. Performed RX Claim validation before loading into all portal applications. Involves claim and query testing. Responsible for system and regression testing before the project goes live Actively participate in client meetings to understand the requirements for new business implementation Responsible for benefits and clinical testing that involves understanding the requirements, collecting test data from the Rx claim, and using the NDC lookup tool Introduced best practices for effective case management, which helped to increase the volume of case management efficiently and thus improved the client cases from 5 to 30 by showing consistent growth in case handling/management Single-handedly managed one welcome season in CVS Health to validate new plan benefits for CVS clients, including end-to-end formulary testing of health plans and error fixing Document project status reports as required by internal guidelines and work on RCA as per client guidelines and standards on production corrections reported Leading mentoring & guiding team members Quant Systems Inc., INDIA Client: CVS Health QA Analyst - PBM (Pharmacy Benefit Management) April 2019 - May 2023 CVS Health Pharmacy Services, the pharmacy Benefits Management (PBM) and Specialty pharmacy division of CVS Health, provides a full range of PBM services, Medicare Part D services, retail pharmacy network management services, prescription management systems, clinical services, and disease management services. CVS will implement Clients on the Rx claim platform. As part of the implementation, benefits plan designs, eligibility load, and multiple IT projects are developed and implemented. Responsibilities: Experience in CVS Health Care Manual testing. Started as a tester and currently in the role of test manager for CVS in PBM (Pharmacy Benefit Management) Manage cases for 31 clients across all lines of business (MEDD, COMMERCIAL, EXCHANGE, MEDICAID) Strong understanding of the plan benefits Firsthand experience on Test Estimation, Test Strategy, and Test planning based on the project schedule and timelines Firsthand knowledge in Rx Claim, EZ Query, NDC Lookup, EZ Test Experience in claim and query testing, PC diagnosis, Root cause analysis, and corrective plan measures Ownership for TCP (Test Check Point) for cases Worked on Health Plan Benefits Testing Project, which includes analyzing client requirements and performing commercial and clinical testing. Performed RX Claim validation before loading into all portal applications. Involves claim and query testing. Responsible for system and regression testing before the project goes live Uniti Technical Consulting India PVT LTD, INDIA QA Analyst MAY 2017 MAY 2019 Performed end-to-end functional testing of web pages and content components within WEM to ensure proper rendering across different browsers and devices Conducted pre-launch QA checks to verify link accuracy, image rendering, meta tagging, and alignment with SEO standards Collaborated with QA teams to define content validation checklists and workflows for automated and manual testing of product pages Identified and resolved content-related bugs or layout issues by troubleshooting WEM templates and coordinating with developers Verified content migration and version control accuracy during page updates or bulk uploads Participated in UAT (User Acceptance Testing) cycles for new content features and enhancements in CMS workflows Supported regression testing efforts after CMS releases to ensure previous content structures remained intact and functional Utilized WEM tools to preview and test publishing workflows, ensuring accurate live deployment of authored content M.Sc in Computer Science & Engineering from Hindu College (Acharya Nagarjuna University). Keywords: quality analyst machine learning access management information technology microsoft mississippi South Carolina