Kristopher Dubble Email & Phone Number

Sacramento County, California, United States

Sacramento, Ca

• Behavioral Health Medi-Cal data subject matter expert.• Utilize ArgGIS Online to build interactive healthcare dashboards and maps.• Utilize SAS Enterprise Guide to query, combine, and prepare datasets for Business Intelligence apps.• Utilize ArcGIS Pro to import and upload data and map layers into ArcGIS Online environment.

Sacramento, Ca

• Utilize SQL Server Management Studio, SAS and Teradata SQL Assistant for querying and analyzing large claiming and eligibility databases.• Develop reports using Microsoft Excel, Microsoft Access, SQL Server Reporting Services and SAP Business Objects Software.• Actively participate in stakeholder meetings to develop methodology for new performance metrics in Statewide reporting. • Serve as a database, technical expert and provide input and recommendations to the Project Manager.• Write SQL code for ad-hoc analyses on claiming, encounter and eligibility data for executive management.• Lead developer for the Performance Outcomes Systems reports (http://www.dhcs.ca.gov/provgovpart/pos/Pages/Performance-Outcomes-System-Reports-and-Measures-Catalog.aspx).

Sacramento, Ca

• Provided technical support to 58 counties using the Short-Doyle/Medi-Cal claiming system.• Performed business analysis on the Short-Doyle/Medi-Cal II claiming system to identify what adjudication processes must be fixed and/or updated to meet new Federal, Departmental, or Executive Management mandates.• Generated ad-hoc reports for management via SQL data extracts on Medi-Cal Specialty Mental Health Services claiming and payment data.• Created the Katie A. Subclass Member Report: http://www.dhcs.ca.gov/Pages/SMHSReports2014.aspx• Assisted with the Mental Health Services Division budget GAAP Accrual.

Rancho Cordova, Ca

• Reviewed the Program's database business requirements and created a Microsoft Access database to track grievances filed against the Franchise Tax Board utilizing the Systems Development Lifecycle.• Performed ad-hoc analyses via Excel.• Greatly streamlined processes using Visual Basic Applications - Microsoft Excel, Word, and Access.• Maintained excellent customer service with internal and external stakeholders.

Elk Grove, Ca

• Supported and updated Quality Management Dashboard which displays patient-inmate healthcare data from 33 institutions.• Utilized software such as Microsoft Excel, SQL Server Reporting Services, and Adobe Photoshop to create reports and display aggregate, Statewide data to the Public.• Developed and created SQL queries. • Developed and created forms using Microsoft Visual Basic for Applications with Excel and Word. • Traveled to institutions and assisted in developing a Performance in Improvement plan to address patient-inmate, healthcare delivery under-performance identified by the Quality Management dashboard.

Sacramento, Ca

• Provided excellent over-the-phone technical support and troubleshooting for the website www.landmarkhealthcare.com to medical providers with varied levels of computer experience.• Abided by HIPAA rules & regulations while handling confidential health information.• Created training documents and presentations for coworkers.• Reviewed medical practitioner files and updated databases.

High School Diploma

Associate'S Degree, Information Technology