TECHNICAL SKILLS:

Skills: Enterprise Guide SAS 9.4, SAS Studio 9.4, Linux SAS 9.4, Bash 4.2, Cognos 8.1, Vim 8.2, Rstudio 1.1.463, VBA Office 365, Oracle PL/SQL, Visual Basic 6.0, ARCMap 10.4, SQLServer 2008, Crystal Reports 14.1.4.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

SAS Developer

Responsibilities:

• Developed program in SAS 9.4 comparing physician lists between Provider Networks and Contracting. Isolated discrepancies between current member counts and historical data on Oracle 12g server. Create all HEDIS dashboards for clinical reporting. Work with Medical Director to identify underserved Confidential t population. Wrote SAS modules ensuring Confidential t compliance with Medicare/Medicaid. Audited physician billing practices for up coding/fraudulent practices. Analyzed health care claims for conformance to contract riders, benefits. Reviewed interdepartmental data transmissions for auditing compliance with data sharing standards.

Confidential, Albuquerque, NM

SAS Developer

Responsibilities:

• Developed SAS 9.4. program on Enterprise Guide 7.13 reporting A1C scores to clinicians for diabetic Confidential ts. Extract Confidential t data from Oracle 12c server, upload results of SAS 9.4 program for clinician review in EPIC front end. Classify all medications taken by Confidential ts for chart review. Notify clinicians of duplicate prescriptions and potential evaluation for K electrolyte or eGFR diuretic concern. Notify provider of alternative generic medication when applicable. Identified in or out of plan financial responsibility for the current members. Developed Excel spreadsheets with pre - loaded macros in Office 2017 for each disease state.
• Combine internal procedures, external procedures, and Health Maintenance information for Confidential t exams. Capture all medication prescriptions for 97,000 member base, reclassify within EPIC proprietary coding format. Collect all Confidential t diagnosis information by ICD10, alert clinicians for possible pre-diabetes conditions. Flag potential high blood pressure results for clinician review. Establish thresholds for Polypharmacy review of EPIC Pharmacy and Therapy classes. Coded review of ejection fraction events for values less than 40% alerting clinicians in EPIC HMR. Developed text mining routine extracting insulin dosage from Physician scripts, uploaded into EPIC front end. Identify members with potential hypertension, diabetes, prostate cancer, load notification messages in EPIC. Refactored 11,000 line SAS program to 6,000 lines utilizing macro statements, proc tabulate and array loops.

Confidential, Suitland, MD

SAS Developer

Responsibilities:

• Developed SAS programs for Census 2020 data collection on Redhat Enterprise Linux 7.7. Wrote bash scripts automating backup up and removal of files on 21 TB Linux server freeing up disk space for 16 member developer team. Developed macros in Linux SAS 9.4 to dynamically compress and unpack large datasets within SAS programs. Wrote a dozen SAS programs to check compatibility of data sets from vendors files with Census data schema. Loaded xml files onto Census web server using bash curl script. Created two dozen proc sql queries analyzing Census data matching programs for accuracy by address, name, birth date, gender. Assigned all addresses to State, County Basic Collection Units (BCU) for 2020 Census. Wrote all unit tests for final sampling program. Wrote SAS macro to import over 3,000 txt files from Census Bureau field offices.

Confidential, Washington, DC

SAS Developer

Responsibilities:

• Created, developed and implemented over 1,500 separate performance metrics to manage all Agency functions. Researched, solicited bids, scheduled presentations, and selected vendor for new $150,000 Agency Management quality management program. Collected and reported on all inmate data for U.S. Department of Justice. Wrote 150 health informatics programs in SAS 9.4 running on Oracle 11g server. Performed all monthly/quarterly/annual Key Performance Indicator (KPI) reporting to DC City Council. Developed automated VBA email program in Access 2010 notifying U.S. Marshalls Inmate absconds have been returned to District Court. Responsible for developing agency - wide quality management strategy. Successfully improved 12 of 21 Key Performance indicators resulting in Agency status being changed from Underperforming Agency to Performing status. Made all presentations to Senior Management on over 400 quality metrics, highlighting performing, under-performing, and no change. Responsible for data cleaning of over 14,000 intake addresses each quarter, mapping results to city health care, mental health, day care locations in ARCMap 10.4. Provide technical support for 2 million dollar Inmate
• Recidivism grant, including random selection of all participants, building tracking database, preparing reports to the Bureau of Justice. Prepared all reports to DC City Council on annual Agency performance. Wrote macros in Excel 2010 reporting inmate opioid addiction trends, psychotropic medications, substance abuse and mental illness trends. Replaced manual data recording system with web based program, over 100 full time employees on new web-based system. Created DOCSTAT presentations for over 20 different Agency departments, analyzing each department s key processes, writing and preparing PowerPoint decks for presentation to Agency Director. Coordinated Inmate Medicaid coverage with Department of Health Care Finance based on partial matching five different variables in SAS 9.4. Developed facility maintenance reports in SQL Server 2008. Collected data on 11,000 inmates over three year period for VERA Institute of Justice recidivism study, published in 2018. Developed weekly email program identifying incarcerated Veterans in Outlook 2010. Created over 115 Crystal Reports detailing all aspects of inmate movement, health care, supervision, classification, release, parole, grievances, gang affiliation, and Veteran status. Researched, solicited bids, and reviewed presentations for two million dollar Inmate tracking system software upgrade. Helped develop, write and prepare solicitation of $22 million dollar Inmate Health Care contract.

Confidential, Baltimore, MD

SAS Developer

Responsibilities:

• Developed five year moving liquidation analysis in SAS 9.1 profiling average time - to-pay, wallet share. Performed Credit Card cross-marketing analysis, bankruptcy analysis on all consumer loans. Developed contingency funding report to evaluate liquidity of over $20B loan portfolio. Created loan analysis tracking customer loan portfolios by marketing source. Created new branch analysis in SAS 9.1 measuring profitability of new branches by loans booked, renewed, and retained. Performed all branch reporting in Cognos 8.0. Create, develop and deploy Access databases for 2,500 office network. Work with Regional Directors to develop analytics based on FICO score, Weighted LTV, Average APR, and average Month-on-Book for $15B mortgage loan portfolio. Created Access database from over 6 million monthly records analyzing Regional profitability by Fico score, Average Loan Balance, APR.

Confidential, Bethesda, MD

Developer

Responsibilities:

• Manage database tracking all building inspections on Bethesda campus. Developed Visual Basic application to monitor fire alarms and sprinkler sensors. Created inventory system to monitor of all pumps, air handlers, exhaust fans and heating units. Developed reporting system in Access 2000 for the Joint Commission on Accreditation of Healthcare Organizations (JCAHO) to monitor critical items for JCAHO inspections. Created Access 2000 database tracking electrical panel inspections for entire Bethesda campus

Confidential, Columbia, MD

SAS Developer

Responsibilities:

• Managed Survey Center full - time staff of three, developed and maintained Computer Aided Telephone Interview (CATI) programs for Survey Center. Created all PC-based data entry systems for Maryland Clinical Data Abstraction Center (CDAC). Developed all ad-hoc reporting tools for Senior Management. Perform all post-survey analysis in SPSS 11.0. Created networked data entry system for abstracting in Confidential t VA Medical records in Visual Basic 6.0. Created scheduling program to track hours and activities of over 130 sub-contractors in Access 2000. Created in Confidential t coder DRG based auditing tool, also in Access 2000. Created and administered AdvanceMed internal employee satisfaction survey. Developed networked project tracking system to monitor project status for Department supervisors in Visual Basic 6.0. Responsible for maintaining Novell network of over 250 users.

Confidential, Frederick, MD

SAS Developer

Responsibilities:

• Responsible for all analysis of Provider Network of 32,000 Providers with annual reimbursement over 300 million dollars. Developed ad - hoc reporting tools by querying Oracle warehouse with SAS 6.0 to uncover Provider fraud and inefficiencies in payment schedules. Collected administrative claims data from Oracle Warehouse for Intermittent claudication and Osteoporosis studies using SAS 6.0. Implemented RVU-based payment methodology, replacing Specialty-based system. Developed VBA macros in Office 98 to export SAS data set results in Excel. Create and write all documentation for PC-based applications, develop and teach program for claims adjusters. Replaced current pricing application with Oracle-based system. Responsible for all HEDIS administrative data collection. Created and implemented System Support Quality Control program. Created immunization database, improving immunization scores 20%. Replaced manual data entry of Physician applications with Access application, eliminating 20 hours per week in data entry. Increased post-partum care scores 23% with after-delivery reminder program.

Confidential, Frederick, MD

Coordination of Benefits Database Administrator

Responsibilities:

• Analyzed recovery sources and methods over previous two reporting periods. Streamlined existing procedures, improving collection efficiency over 20%. Created and implemented new database application to track annual claims recovery of over 22 million dollars. Brought all financial statements up to level of generally accepted accounting standards. Performed all accrual and forecasting related to claim recovery. Developed commission - based collection database for calling staff. Managed call center database responsible for supplying over 1,000 member phone numbers per week to Coordination of Benefits department. Responsible for removing duplicates, scrubbing, and verifying data integrity of weekly claims downloads. Loaded all Medicare rates from seven states onto UNIX system.

Confidential, Lanham, MD

Database Manager

Responsibilities:

• produced all weekly, monthly, and yearly progress reports for Project Manager and Government Monitors. Implemented Foxbase database to eliminate manual data entry and record keeping. Created and managed database in Foxbase to track spacecraft parts. Developed and put in place Total Quality Management program to bring contract into compliance with Government specifications.