SANDRA M. CAUDILL
Independence,KY
Summary
Dedicated Quality Assurance Leader with more than twenty years background in insurance. Excellent resource management and allocation skills. Outstanding communication, organizational and time management talents.
Overview
24
24
years of professional experience
2
2
Certification
Work History
QA Lead - End to End
Great American Insurance Group
01.2020 - Current
- Established direction and led QA efforts for top ten, high-priority corporate projects
- Supervised onshore and offshore QA leads and engineers to support UI, forms, API, automation, ETL, interfaces, data, and analytics for SIT and UAT efforts
- Managed QA relationships with business and downstream stakeholders for clear communication and collaboration across efforts
- Represented QA in management and executive leadership forums
- Served as QA workstream representative on QA leadership and Testing Center of Excellence committee
- Served as the primary mentor for onboarding and cross-training new QA leadership members on processes, tools, and insurance domain knowledge
- Supervised proofs of concept for test case traceability within Rally for large-scale complex efforts and automated data loads for UI test data setup
- Provided mentoring and supervisory leadership on QA processes and tools across project teams
- Served as subject matter expert and mentor for enterprise and financial data warehouse testing
- Supervised end-to-end QA efforts across technology platforms, including UI, interfaces, SQL data warehouse, cloud data lake solution, and analytic platforms
- Served as QA point of escalation for project risks and mitigation plans
- Designed and implemented test management processes and toolset to support agile and waterfall project implementations in support of enterprise QA strategy
- Defined QA estimates to support testing of internal and commercial off the shelf applications
- Documented project status and QA metrics, including test design, test execution, defect status, and various levels of traceability
- Supervised automation efforts to support smoke, regression, API service testing, ISO Forms validation, and downstream data testing needs through the utilization of Selenium, GitHub, and Jenkins
- Implemented defect management processes, configured tool structure, and led daily defect triage meetings
- Implemented processes for traceability of defects between the vendor tracking system and the internal tracking system
- Supervised incident reconciliation workgroup with the vendor to ensure alignment of open incidents
- Established processes, standards, and templates for data testing of the enterprise data warehouse and financial data warehouse, including training QA engineers on SQL for data validation efforts
- Implemented a formal vendor deployment schedule for releases and patches, providing increased environmental stability
- Implemented project reporting and analytics to summarize large scale testing efforts, providing visibility into the test results and established action plans for outstanding testing items
- Served as interim Scrum Master including facilitating QA retrospectives at the end of each project release
- Served as Rally security administrator for project areas
QA Lead - Data
Great American Insurance Group
05.2019 - 01.2020
- Served as QA lead for large-scale data validation efforts, including ETL, enterprise and financial data warehouses, and BI analytical reporting
- Established best practices for data validation efforts, including test planning, defect tracking and remediation, traceability matrix, and data validation guidelines
- Coordinated data validation efforts for downstream stakeholders to support reinsurance, claims, billing, and BI reporting
- Developed project estimates for QA efforts
- Served as the central point of contact for data QA project efforts
- Assigned and reviewed deliverables of QA data engineers
- Interviewed QA leads, manual test engineers, and automated engineers
- Established QA processes, standards, and templates to support data testing
- Trained and mentored QA engineers on SQL for data validation
- Worked with product data standards team on validation efforts for statistical bureau reporting requirements
Sr. Technical Business Analyst
Great American Insurance Group
05.2018 - 05.2019
- Elicited and documented business and technical requirements for the enterprise and financial data warehouses – including ETL requirements and reference data mappings
- Performed data validation for ETL, data elements, interfaces, and reference data
- Represented property and casualty data standard enhancements at the data stewardship council sessions
- Supported SQL Server reporting requirements
- Represented SQL Server reporting changes in the Department Change Approval Board sessions
- Validated the new report functionality
- Mentored junior associates on processes, tools, and SQL
Lead Business Systems Analyst - BI
Anthem Blue Cross And Blue Shield (Onebridge)
07.2017 - 05.2018
- Served as the lead BI business systems analyst for eliciting and documenting business and technical requirements for underwriting reporting
- Led the consolidation effort for two core case management systems and their associated BI reporting
- Led the consolidation effort for enterprise underwriting reporting
- Facilitated the effort to consolidate more than 300 regional-specific reports into an Enterprise solution of 30 reports, reducing administrative costs by 90%
- Facilitated the effort to consolidate four regional data warehouse reporting sources into one centralized data mart
- Developed technical source-to-target mappings for large-scale BI reporting projects
- Developed wireframe models for BI reporting requirements, including filters, prompts, dimensions, and measures
- Represented BI reporting projects in Scrum meetings, project status meetings and provided daily status updates to Business stakeholders, sponsors, and executive leadership
- Mentored junior associates on applications (SharePoint, Teradata, SQL, Jira, and Confluence), BSA processes, data warehousing, business intelligence concepts, and provided project artifact guidance
QA Manager
Lighthouse Technology Inc.
09.2016 - 01.2017
- Managed end-to-end testing, including UI, interfaces, and data testing efforts for Medicaid implementations
- Defined and implemented a test strategy to support testing of QA Medicaid solution
- Coordinated code releases from project scrum teams
- Served as QA point of escalation and worked with the projectt team on issue mitigation and prioritization
- Managed project plan, resource allocation, and QA budget
- Managed resource allocation and time management to ensure budgetary alignment
- Provided QA guidance for testing internal and external systems, inbound and outbound interfaces, data dependencies (input files, batch files, and independent data components), and environment structure
- Managed QA communication strategy, test schedule, project dependencies, constraints, assumptions, risks, issues, and overall testing status
- Conducted performance management and onboarding activities
IT Quality Assurance Sr. Advisor - Commissions
Anthem Blue Cross And Blue Shield
10.2015 - 09.2016
- Supervised onshore and offshore data test leads for enterprise commission’s SIT and UAT testing efforts
- Served as QA point of escalation for QA-related issues during project efforts
- Implemented enterprise QA strategy in compliance with PMO methodology
- Established QA processes for traceability, deployment schedules, and test data management
- Provided testing estimates for people and work efforts
- Severed as the QA representative for Release Management activities, ensuring production readiness of code before production deployment - provided supporting test evidence, issues, defects, and supporting resolution documentation
IT Quality Assurance Sr Advisor - BI
Anthem Blue Cross And Blue Shield
12.2013 - 10.2015
- Led onshore and offshore test leads and test engineers for healthcare analytics’ BI UAT teams
- Led QA efforts for testing of enterprise data warehouse, data marts, and Business Objects reporting
- Mentored QA organization on testing processes and supporting toolsets
- Defined and implemented quality metrics to provide executive management with the health status of the testing effort
- Provided strategic direction for functional, performance, and services testing efforts
- Led defect review meetings and coordinated patch fixes and code deployments for QA retesting
- Established test asset traceability for SOX compliance - test plan, test scenarios, test cases, and defects
- Served as enterprise QA process mentor and subject matter expert for the Enterprise Testing Center of Excellence
- Provided input into enterprise Lean SDLC processes and supporting toolsets
IT Quality Assurance Sr. Advisor - BI
Anthem Blue Cross And Blue Shield
12.2009 - 12.2013
- Led onshore and offshore test engineers for Data Strategy and Integration (DSI) QA efforts – SIT and UAT
- Developed people and time estimates in support of QA efforts
- Led data testing efforts for enterprise data warehouse, data marts, and Business Objects reporting
- Facilitated requirement discussion and ambiguity reviews, ensuring a clear understanding of the requirements
- Defined test objectives and strategies for SIT and UAT efforts, including the testing scope and environmental needs
- Served as QA and project mentor for Enterprise SDLC toolsets and processes to reinforce Lean test management compliance
- Developed team and project-specific guidelines around tool and process utilization
- Managed issue and defect tracking for the project, utilizing the Enterprise defect management processes and toolset
- Served as DSI subject matter expert on the defect management committee and point of contact for all SDLC tool needs
Primary Enterprise Test Management Architect
Anthem Blue Cross And Blue Shield
04.2002 - 12.2009
- Enterprise test management application owner and system administrator
- Primary test management process architect
- Primary test management SOX compliance auditor
- Led the enterprise implementation of the SDLC for the test management discipline
- Led the effort to consolidate 12 regional-specific test management process and tool solutions into a single centralized enterprise solution
- Defined SIPOCs to illustrate test management process definition and framework
- Designed and implemented the framework and technical infrastructure for the enterprise Testing Center of Excellence – workgroup, communication platform, and interactive SharePoint site
- Led SOX auditing for the enterprise test management discipline to ensure compliance for SOX testing controls
- Developed and implemented remediation plans to assist projects in resolving audit failures, bringing the teams into compliance
- Led workgroups to define the future state of the enterprise SDLC toolset, utilizing the CMMI framework
- Designed Business Objects custom reports for defect management enterprise reporting needs
- Installed, configured, and supported the software and hardware to support the enterprise test management software and hardware solution, including server installations, monitoring, storage, desktop installations, and product upgrades
- Served as secondary enterprise administrative support for defect management and requirement management disciplines
- Served as the enterprise SDLC representative and provided impact analysis in the release management and change approval board forums
- Implemented training curriculum for test management toolset – test management and automation
- Delivered training to Anthem IT on test management and defect management processes and toolsets
- Implemented production support model for test management toolset
Education
Associate of Science - Information Technology
Indiana Wesleyan University
Marion, IN10.2022
Court Reporting And Business
Stenotype Institute of Cincinnati
Cincinnati, OhioCourt Reporting And Business
Cincinnati School of Court Reporting And Business
Cincinnati, OHGED -
Kentucky Board of Education
Covington, KYSkills
- Vendor Management
- Project Management
- Change Management
- Release Management
- Cloud Technology
- Business Intelligence
- Database Design/SQL
- Data Warehouse/ETL
- Data Modeling
- Data Lake
- Business Objects
- Tableau
- Cognos
- Service-Oriented Architecture (SOA)
- XML
- Java
Certification
- Certified Scrum Master, Scrum Alliance - August 2019
- Lean Six Sigma Green Belt - June 2013
Timeline
QA Lead - End to End
Great American Insurance Group
01.2020 - Current
QA Lead - Data
Great American Insurance Group
05.2019 - 01.2020
Sr. Technical Business Analyst
Great American Insurance Group
05.2018 - 05.2019
Lead Business Systems Analyst - BI
Anthem Blue Cross And Blue Shield (Onebridge)
07.2017 - 05.2018
QA Manager
Lighthouse Technology Inc.
09.2016 - 01.2017
IT Quality Assurance Sr. Advisor - Commissions
Anthem Blue Cross And Blue Shield
10.2015 - 09.2016
IT Quality Assurance Sr Advisor - BI
Anthem Blue Cross And Blue Shield
12.2013 - 10.2015
IT Quality Assurance Sr. Advisor - BI
Anthem Blue Cross And Blue Shield
12.2009 - 12.2013
Primary Enterprise Test Management Architect
Anthem Blue Cross And Blue Shield
04.2002 - 12.2009
Associate of Science - Information Technology
Indiana Wesleyan University
Court Reporting And Business
Stenotype Institute of Cincinnati
Court Reporting And Business
Cincinnati School of Court Reporting And Business
GED -
Kentucky Board of Education
Similar Profiles
Dustin CraigDustin Craig
Senior Claims Specialist, Property & Inland Marine at Great American Insurance GroupSenior Claims Specialist, Property & Inland Marine at Great American Insurance Group
Lucas GriffinLucas Griffin
Senior Agency Executive at Great American Insurance GroupSenior Agency Executive at Great American Insurance Group
Brianna CurryBrianna Curry
SIU Investigator Analyst at Great American Insurance GroupSIU Investigator Analyst at Great American Insurance Group
Justin BuchholzJustin Buchholz
Crop Adjuster at Great American Insurance GroupCrop Adjuster at Great American Insurance Group
Mckenzie MoffettMckenzie Moffett
Server at Longnecks Sports GrillServer at Longnecks Sports Grill