Responsible for ensuring the accuracy and integrity of Actuarial data and applications through high-level analysis, efficient coding, writing clear documentation, and identification and resolution of problems as they arise•Continue to develop, design, and implement process for build data and populate Actuarial Rate Filing model, Forecasting model, and IBNR model through VBA, SSIS, and SQL programming.•Work with a third-party vendor to calculate Risk Adjustment and Risk Transfers as part of the ACA regulations. Additionally utilized the vendor model for morbidity and risk adjustment in pricing models. •Designed, developed, tested, and, implemented user end application in Excel for enter in routinely run plan benefits for Actuarial Value Calculator created by CMS and its procedures to create the final product. Procedures range from data import and deliverable report creating. Using a click button dashboard and VBA•Contributed with the migration of Financial Reporting, Trend, Enrollment, and Pricing functions to the new Model Office platform. Assisted in the development and tested of new tools provided as interim support for the new model office business intelligent reporting during transition.

•Assisted in the design of the ACA pricing model and work with a third-party vendor to calculate Risk Adjustment and Risk Transfers as part of the ACA regulations. Additionally utilized the vendor model for morbidity and risk adjustment in pricing models. •Designed, developed, tested, and, implemented user end application in Excel for enter in routinely run plan benefits for Actuarial Value Calculator created by CMS and its procedures to create the final product. Procedures range from data import and deliverable report creating. Using a click button dashboard and VBA•Assisting with MLR data extraction, cleaning, and reporting for regulatory reporting needs. •Continued to work with Dental Operations, to migrate DHMO from a legacy system to SQL Server based data storage and migration to Facets for day to day business.•Contributed with the migration of Financial Reporting, Trend, Enrollment, and Pricing functions to the new Model Office platform. Assisted in the development and tested of new tools provided as interim support for the new model office business intelligent reporting during transition.

•Within Dental Operations, provide day to day support providing information/analysis to Customer Service Reps and Specialist, as well as corporate needs. •Automation of exisitng reports/processes using AREV (legacy system) and MSAccess/MSExcel VBA. •Researching and developing processes for extraction from AREV in preperation for migration.•Develope SOX controls for Claims and Enrollment reporting and processing•Work hands on with Enrollment and Billing to provide accurate processing data for corperate monitor reporting

•Developed comprehensive audit controls for Sarbanes-Oxley (SOX) compliance. Tracking of steps involved with retrieving, processing, and verifying incoming revenue, enrollment, and claims data. Based on these control systems, all data within Actuarial Finance systems can be used for analysis and reporting within SOX compliance, and satisfy Internal and External Audit requirements.•Programming for data extracts from multiple data sources on Mainframe and data feeds from Data & Informatics (D&I) for revenue, claims, and enrollment for monthly data processing. Organized and standardized incoming data into a CareFirst Inc (CFI) database, creating a single source data pull for building analysis cells. Redesigned and enhanced the macros for single click data loading to cells, creating composite builds for rolled up analysis. •Performed and improved the multi-faceted system of Excels and Access that creates quarterly report of Insurance Blanks to Nation Association of Insurance Commissioners (NAIC). Working with Finance directly to gather all data required for reporting and inputting data directly to third party applications, such as eFreedom and Eagle’s Wings as required by NAIC•Designed, developed, tested, and, implemented user end application in Access for enter in routinely run processes and its procedures to create the final product. Procedures range from data import, action queries, excel paste, control tie outs, and deliverable report creating. Using a click button, data entry forms, and VBA to connect to external Access tables, Excel, and TXT •Contributed with the migration of Financial Reporting, Trend, Enrollment, and Pricing functions to the new Model Office platform. Assisted in the development and tested of new tools provided as interim support for the new model office business intelligent reporting during transition.

Division of Accountability and Assessment•Produced descriptive statistics and analytical reports for the Maryland Board of Education, the MSDE Superintendent and Assistant Superintendents for Adequate Yearly Progress (AYP) under the No Child Left Behind Act of 2002 (NCLB). •Created documentation and standardized methods for evaluating Federal requirements for AYP•Performed quality assurance reviews of data distributed to the federal Educational Data Exchange Network (EDEN) by developing detailed analytical programs in SAS. •Developed, tested, documented, and maintained a MS Access database using Visual Basic for importing data collection, cleaning, processing, and exporting data for Non-Public Schools’ state assessments (MSA and HSA).•Assisted with the development, testing, evaluation, and documentation of Oracle designed HSA and MSA/AltMSA processing application.•Managed data collections, and processed reports of student demographic data from Local Accountability Coordinators (LAC), vendors, and internal requests. •Participated in meetings with LACs and vendors to determine data requirements MSA/Alt-MSA

•Researched, collected, and analyzed data on student mobility in Maryland schools for the Casey Foundation for policy and program development.•Developed, tested, and maintained MS Access database for scheduling sampled schools and coordinating the tracking of data processed.•Performed site visits of all Maryland public schools to utilize student data collection and conduct teacher interviews.•Provided quality assurance checks of Processed qualitative and quantitative data using SAS. •Coordinated and administered focus groups with Maryland public schools

United States Patent and Trademark Office (USPTO) •Assisted with the development, documentation, and management of an MS Access database used for sample management and receipt control system•Coordinated the entry of quantitative and qualitative data.•Organized and managed all mailings for a sample of approximately 8,000 customers.Comprehensive Study of the Medical Savings Account (MSA)•Developed, tested, documented, and maintained an MS Access database importing and updating respondent information and data for US Government Accountability Office's congressionally mandated evaluation of the MSA demonstration, which was used for individual medical savings and spending research on future projects. Bureau of Labor Statistics (BLS)•Assisted with developing, documenting, and implementing training materials for a CATI system based study to examine the feasibility of collecting monthly data on job openings and labor turnover statistics (JOLTS) from employers of all sizes.•Assisted with CATI data preparation and editing of the codebook.•Prepared data collection forms for faxing to respondents on a monthly basis.Technical Support Services for Personnel Policies and Programs: Evaluation, Research, and Studies (PERS)Defense Manpower Data Center, U.S. Department of Defense (DMDC)•Attended and administered for several focus groups to collect qualitative data from men and women in the four military services to provide an in-depth understanding of issues related to training effectiveness and gender interaction.•Assisted in gathering content analysis and organized the final production of the report for the Congressional Committee assigned to evaluate training effectiveness and gender interaction.