Developed Teradata and Oracle SQL data mining queries to identify claims from health insurance overpayment scenarios stemming from provider waste, fraud, and abuse, provider contract issues, and benefit coding errors; completed projects using Teradata SQL Assistant, Teradata Studio, and SAS Enterprise Guide.Completed over 250 overpayment capture projects and project enhancements using databases with tables containing up to 16 billion rows.Scheduled project planning meetings with Business Analyst and Recovery Consultant to understand and finalize project requirements; created query result sets for Business Analyst to perform User Acceptance Testing and hit rate determination; modified queries per intermittent revisions to project requirements; maintained SAS Grid-based overpayment identification system.Developed complex array-based Excel VBA applications for reporting, data cleansing, and Stored Procedure Call creation. In charge of the DRG Readmission Project Series since June 2022, which delivers over $570 MM in Total Program Savings annually; applied modifications that captured $49 MM in Cost of Care Savings.Designed and built processes to maintain a three-billion-row Teradata permanent table comprised of 46 commonly referenced fields, which were used to create the initial claims universe for the Department’s data mining queries. Served on the Business Requirements Document, SQL, Stress Relief, SAS Macro, Shared Tables, Project Audit, and Teradata Stored Procedure workgroups.

Supported Primerica's ERP data migration from PeopleSoft 8.4 to 9.2.Created PeopleSoft reports for ChartFields and Business Units; created reports with IBM Cognos TM1 cubes for Business Units and Subsets.Developed Excel VBA solution to replace existing manual testing process by automating the extraction of accounting data from PeopleSoft and TM1 reports to align with ChartField and Business Unit data interchange; developed an indexing solution to expedite report conversion process. Wrote SOX documentation for KPMG auditors; documented how to create PeopleSoft and TM1 reports; created documentation describing Excel macros developed in support of migration testing.

Supported a Java/Oracle-based system used to retrieve auto accident reports for U.S. police jurisdictions. Created Excel-based reports for Director of Operations to monitor quality control and customer satisfaction metrics for insurance companies and adjusters. Developed internal solutions for the administrative staff work distribution system using Crystal Reports.

Created and modified SQL queries in Microsoft Access from health insurance group contract databases supplied by Blue Cross Blue Shield of Minnesota (BCBSMN) in support of the BCBSMN Claims Migration Project; configured VB.NET-driven data mapping application; created ad hoc reports for analysis of groups and benefits. Collaborated with Business Systems Manager to generate requirements for an alternative Excel-driven benefit mapping application after working to phase out aforementioned VB.NET solution; created use cases, activity diagrams, system sequence diagrams, and a shared process flow for new and old systems; created written description of processing logic and productivity gains. Developed and presented to executive leadership aforementioned benefit mapping application using over 20 Excel VBA subroutines, which automated 95% of a manual data entry process by converting 30-page sentence-based HTML health insurance group contracts into standardized data; created a user-updatable benefit translation interchange which mapped data to answer over 3000 multiple choice questions containing all possible group contract specifications. Developed Excel VBA-based prototype application to streamline the reporting of raw mainframe test data; worked with a .NET developer to incorporate application functionality into a more elaborate VB.NET application. Automated data analysis workflows by creating Excel VBA applications for organizing mainframe data, file comparisons, benefits translation, and alternatives for Excel look-up functions.Used mainframe error correction systems for benefit testing to create test scenarios and resolve claim processing issues.