John Petring Email & Phone Number

Kaiser Foundation Health Plan of Washington (KPWA)• Successfully managed projects for Business and Operations including: o Implementation of LeanTaaS' "iQueue for Infusion Centers" at six KPWA clinics o Evaluation of Public Option participation for KPWA o Transfer of Health Information Exchange (HIE) functionality to a different company. • Utilized SmartSheet, PowerPoint, MS Word, MS Excel, and SharePoint.

Massachusetts, United States

Commonwealth Care Alliance (health plan) (contract) • Business Requirement Documents (BRD) o Wrote BRD on Claims Subrogation project o Wrote BRD on Coordination of Benefits project• Medicare Prescription Payment Plan (M3P): Analyzed M3P impact on Pharmacy Benefit Manager (PBM) contract with the health plan• Claims Escalation: Analyzed process improvement measures for claims issues from providers and members.• Agile environment• Requirements gathering, documentation, eliciting information• Utilized Visio, PowerPoint, MS Word, MS Excel, and SharePoint.

Bakersfield, California, United States

Kern Health Systems (KHS), a public health plan (contract)• DHCS 2024 Contract Readiness project• NCQA accreditation preparation• Analyzed issues, performed cross-functional coordination. • Requirements gathering, documentation, eliciting information• Agile • MS Office: Visio, PowerPoint, Word, Excel, SharePoint.

Kaiser Permanente, Revenue Management department (contract)• Oversaw data collection and reporting for 40+ revenue enhancement initiatives.• Managed data transfers from vendors and internal resources.• Managed data files and imports to Power BI.• Requirements gathering, documentation, eliciting information• Utilized Power BI, PowerPoint, MS Word, MS Excel, and SharePoint.

Los Angeles, California

Enterprise Performance Optimization team. Focused on Regulatory Compliance Gap Analysis. Focused on pro-active compliance analysis across multiple functions and departments. L.A. Care is the nation's largest public health plan with over two million members.

Greater Los Angeles Area

Abbott Laboratories (contract). Provided Database Development and Data Analysis to support Regulatory Compliance for this major biotechnology company. (On contract through Oxford Global Resources.)

Greater Los Angeles Area

Evaluates and approves all contracts for the Information Services Department. Reports to Director of Portfolio Management and the Chief Information Officer. • Member, CHLA Organizational Improvement Committee• Collaborates with General Counsel Office, Compliance Officer, Contracts Administration

Greater Los Angeles Area

SQL Server Database Administrator / MS Access Developer / Business Analysis / Systems Analysis• Saved the hospital $500k annually by creating an MS Access tool to ensure all billable events are billed in time. This MS Access database application tied out medical visits with billing to insurance companies. (Clinical Research Investigation Center)• Improved patient care in the Cardiology Department by creating an MS Access database application to track patients’ pacemaker devices. Pacemaker recalls can now be immediately communicated to patients.• Improved the Endocrinology Department’s ability to perform patient care and research by repairing and improving an MS Access database. Created a Cerner data feed and an import process to eliminate manual data entry. • Created several MS Access databases for other departments to improve data management, analysis, patient care and decision support.• Improved the security of MS Access databases by migrating them to SQL Server.• Kept dozens of SQL databases operational through database administration. • Supervised dozens of vendors as they deployed their products in SQL environment.• Managed the upgrade of an old Oracle application to Oracle 10g web-based application. Conducted User Acceptance Testing and communicated requirements to the vendor.

Thousand Oaks, Ca

Business Analyst / Application Developer • Enabled Amgen to evaluate blood samples for a prostate cancer study. Developed specifications and created a complex Excel application to evaluate the samples. This application was deployed at several international laboratories and accommodated variations in Microsoft regional settings. • Improved clinical research tracking process by programming Outlook forms (VBScript) with an MS Access backend database.• Improved project management tracking by creating new Access databases.

Irvine, Ca

• Managed the data for a mass-certification process, thus enabling PacifiCare to participate in Medicare Part D by certifying thousands of insurance agents.

Los Angeles

• Improved business processes in various departments by analyzing data management issues, creating MS Access databases and repairing existing databases. • Improved the Social Medicine Department’s functioning with an MS Access database• Upgraded database for Windows 7 compatibility

Los Angeles, California, United States

John Petring has owned and operated Petring & Associates since 1998. He has been an independent contractor / consultant providing database services to over 35 companies in a variety of industries including healthcare, entertainment, biopharmaceutical, insurance, finance, sales, marketing, manufacturing, legal, and tax. Those companies include Amgen, Kaiser Permanente, Disney, Mattel, Toyota, CalOptima and the Los Angeles Times. He demonstrates expertise in analyzing each business’ data management requirements, designing solutions, developing those solutions and implementing them. He manages all phases of his projects and works with all staff levels from administrative to management to leadership. His primary tools have been Microsoft Access and SQL Server databases.

Master Of Health Administration (Mha), Health/Health Care Administration/Management

Activities and Societies: Healthcare Executives in ResidenceGraduated from USC's Executive Master of Health Administration program.

Doctor Of Law - Jd, International Law And Legal Studies

Graduated from Georgetown's evening law school program while working full-time in Energy and Environmental Consulting.

Bachelor Of Arts - Ba, Political Science

Activities and Societies: Political Science, Russian Studies, International Relations.Analyzed joint business ventures in the USSR.

Bachelor Of Music, French Horn Performance

Activities and Societies: UNM OrchestraAmerican-Soviet Youth Orchestra (1988)