Manages a team of up to 10 data & software development professionals in support of Sutter Valley Medical Foundation. The team is tasked with the creation of business intelligence solutions in support of the $2.3 Billion in revenue generated by over 1,200 providers and 3,000 front line staff. Our areas of focus are to support Clinician Compensation Analytics, Financial Operations, and the improvement of Patient Quality health outcomes.• Creates and manages implementation of technical strategy and data management for Decision Support department.• Works with stakeholders across the business to develop standard analytical toolkits that include data marts, semantic layers in SQL & Power BI datasets/SSAS Tabular Models, and AI/ML.• Coaches employees, focusing on developing stronger technical, interpersonal, and project management skills.• Instituted Development Operations (DevOps/DataOps) best practices to the Business Intelligence solution, including GIT, SSDT, Azure DevOps, and daily standups.• Championed migration of key assets to Azure, implementing a hybrid cloud architecture solution. Worked across the organization to be the pilot of utilizing Azure resources at the affiliate level.• Architects overall BI solution. Reviews implementation of solution with employees thru a code review process.• Builds relationships with both internal and external customers. Positions BI team to focus on areas of strength in order to deliver greater value to the business.

Promoted from Lead Data EngineerResponsible for the operational & government data and reporting systems. Architected the data warehouse system, designing and implementing all applicable subsystems. Oversaw the health, maintenance, and optimization of the Epic Electronic Health Record information systems. Developed strategy for IT application systems.• Architected and implemented custom data warehouse solution from end to end• Responsible for all governmental & grant reporting, including UDS, OSHPD, PCMH, and Ryan White (RSR)• Built provider dashboards to target clinical quality, productivity, and financial measures• Implemented a project management solution for business intelligence development, increasing productivity by up to 50% and lowering bugs reports by 30%• Managed the transition of EHR systems from Next Gen to Ochin Epic

Developed the data and reporting strategy for a Federally Qualified Health Clinic(FQHC) in Sacramento. Responsible for all clinical data for government reporting programs, such as UDS, OSHPD, Ryan White Services, and PCMH. Improved the reliability and consisiteny of all clicnical reporting.* Architect and modeler of the data warehouse design.* Uses SSIS to implement and automate the ETL process.* Uses SSRS to develop paginated reports and dashboards for all levels of employees, from front line to executive management.* Uses SSAS to implement the reporting and data mining needs based on the DW design.* Uses advanced level T-SQL, including window functions, CTE's with recurrsion* Mapped data to industry standards such as LOINC, SNOMED, ICD, and CPT. Improved on these standards to reflect the unique need of Cares.

Board Member and Secretary of the Board for a non-profit corporation. We promote the arts and positive social change within our community. Helped take the corporation into its official 501(c)(3) status.

Technical Systems Analyst working in the Error Prevention and Remediation Analysis of Health Net. Performs ETL operations, cleansing of data, and pulling reports on Medicare, Medi-Cal(Medicaid) and Affordable Claims Act claim errors. Designs data flows relating to such government programs. Uses Oracle, PL\SQL, MySQL, MS SQL, and Informatica.

Worked as the Lead Business Intelligence Developer in charge of a team that developed an agency management system for a life insurance brokerage. Architect of the database & middle tier layers of the application. Worked out process flows for all incoming life insurance data. Developed daily reporting programs and dashboards over all parts of the policy life-cycle.• Designed, documented, and implemented ETL process for 28 different carriers input for commission, policy, agent, and submitted case data• Used C# & Selenium to automate the daily extraction and transformation process • Created dashboards for executive team using Power BI• Improved reporting frequency from monthly to daily• Created and maintained SSAS OLAP multi-dimensional and tabular models for transactional data• Created and optimized database model for agency management system

Provides business intelligence advice and programming to insurance, casino, and tribal organizations. Analyzed slot player gaming patterns, made marketing recommendations. Tracked effectiveness of marketing campaigns.

One of 3 founding employees for a startup focused on serving the insurance and risk needs of Native American tribes and businesses. In my capacity as director, I created all operational & regulatory workflows, selected and maintained business systems, and developed new lines of business. I also designed databases, performed ETL, and analyzed self-insured health care information.• Worked as a liaison between carrier & insured in order to align expectations vs. actual coverages• Created all workflows for brokerage relating to regulatory and E&O compliance • Used MSSQL to develop healthcare data warehouse for claim data totaling $16M/year• Worked with tribal councils and executives, developing risk management strategies that would work for tribes with assets up to $4B dollars• Developed database and reporting systems for self-insured health plans• Head researcher on insurance contracts and treaties. Assisted research on tribal sovereignty.

Worked as an actuarial analyst in charge of all workers’ compensation reporting, rating, and regulatory compliance for a large self-insured plan. In addition, I created a data warehouse from multiple payroll, HR, claims, and benefit systems that produced executive dashboards and custom reporting that integrated into SharePoint. Worked across multiple departments to develop project specifications while balancing end user vs. IT needs.• Performed ETL and data architecture of workers’ compensation system using MSSQL• Outlined ETL & reporting workflow using MS Visio • Developed project specifications as liaison between HR, finance, underwriting, claims & IT depts.• Created real time reports in SSRS tailored to individual departmental needs• Established KPIs and dashboards for executive team and department heads using SharePoint• Use statistical modeling to develop rates and claims projections based on CAS models• Delivered quarterly actuarial projection of the self-insured workers’ comp plan to executive team• Streamlined new client underwriting workflow & sales tools using C#