- Provides inventory and productivity reporting for a team of 30+ members- Creates and maintains automated inventory reduction reports, using big data and SAS to eliminate excess and unnecessary work. In one case, a reduction process has on average eliminated the work that would require 2 full time employees an entire week to resolve- Has developed several early warning systems to detect and mitigate business issues arising from large scale scripting mistakes, failed data loads, and previously unknown issuesPRT Employee Spotlight - September 2016PRT Employee Spotlight - July 2017

- Designed, coded, and maintained a scalable automated reporting framework currently producing over 40 unique reports.- Coded, tested, and implemented SAS software with SQL that queried, generated, and compared data sets from external files and central databases while creating output datasets and reports.- Programmed the load of ICWS information to SQL Server from raw files.- Acted as the subject matter expert for ICWS information to enrollment, ABX, and executive teams.- Owned, maintained, and enhanced 3 inherited separate work systems utilizing raw file imports and .NET user interfaces, used by 100+ users on a daily basis- Developed mainframe screen scraping code for automated quality assurance of open enrollment group setups.- Converted Access database back-ends to SQL Server, greatly improving the speed of querying and worker efficiency.- Produced ad-hoc reporting for membership, TRR, ICWS, and employer groups upon request.MPS3 Employee of the Month - September 2015MPS3 Employee of the Month - June 2015

Data Analysis:- Conducted small-sample results verification by comparing internal information to CMS systems and data feeds.- Fulfilled data requests and generated raw datasets, summarized data, and wrote reports detailing requested information such as member details, regional or local enrollment, payment records, and medical claim summaries.- Produced daily and weekly reports distributed across multiple departments which were utilized by Executive Vice Presidents in forecasting and shareholder meetings.- Advised and consulted team members at all levels of access on data and results, which included providing data origins, logic, or operational code.- Investigated, processed and reported on the root causes of vendor-identified errors, and distributed the results companywide to all relevant parties.- Analyzed Transaction Reply Reports (TRRs) and identified and assisted in correcting member files that did not correlate with information listed by CMS.- Produced and automated daily enrollment reports, weekly executive enrollment report roll-ups, reconciliation reports, MSP reconciliations, future discrepancy reports, and ad-hoc payment and member information packages.Process Design and Improvement:- Automated and designed production SAS reports and reconciliation projects, saving up to thirty minutes of manual work per report and eliminating unnecessary programming.- Prioritized workloads, developed process improvements, detailed specific cases, and provided consultation on uncommon errors in collaboration with outside departments in cross-functional groups.- Implemented SAS code to pre-identify enrollment, compliance, and payment issues.- Implemented internal systems data integrity cross checks that identified systems or scripting issues.- Created a Medicare Secondary Payer status reconciliation process that identified over 5K discrepant members and $14MM worth of mismatching member premiums.