Patrick Kim Email & Phone Number

Davis, CA, US

Washington, District Of Columbia, United States

• Developed an all-in-one executive dashboard within an accelerated timeline, surpassing expectations.
• Collaborated closely with division leaders and subject matter experts (SMEs) to gather requirements, integrate data sources, and uphold data accuracy.
• Engineered and validated data models linking information across diverse systems and divisions.
• Spearheaded directorate-level presentations to prototype designs and facilitate development.
• Applied DAX formulas in Power BI to transform data efficiently.
• Established web and cloud-based connections to unify disparate data sources.

Davis, California, United States

• Created a Vizient Vulnerability Index (VVI) heat map using MicroStrategy Dossier as a pivotal component of Executive Reports for Hospitals, enhancing insight into patient demographics.
• Orchestrated and upheld a monthly performance report enabling clients to gauge their performance against benchmarks.
• Engineered data models and ETL processes, meticulously ensuring data accuracy across development, testing, staging, and production environments.
• Automated processes for enhanced efficiency, streamlining tasks from table loading to executing predefined Automic Automation packages.

• Developed and designed dashboards using Logi Composer to deliver actionable analytical insights.
• Supported ad-hoc data analysis requests and engaged in solving analytical problems.

Roseville, California, United States

• Created a Power BI report that captures $26 million dollars on savings and showing performance review by each hospital sites for Pharmacy departments. The report has been using for Pharmacy Lead Team meeting each month.
• Currently maintaining Pharmacy Data warehouse, AD-Hoc reports, maintaining 10 different reports in excel or Power BI each month, supporting Pharmacy Supply Chain department and Pharmacy System office.
• Loading 12 different vendors data (70,000+ rows) through ETL process to the Pharmacy Purchase Data warehouse each month.
• Assisting Sutter Pharmacists on AD-Hoc requests, creating reports, and providing service to navigate data to find value on daily basis.

Roseville, California, United States

9100 Foothills Blvd, Roseville, CA 95747

• Manage the successful delivery of development projects across with monthly data loading from 12 different vendors for Pharmacy Data Warehouse.
• Developing, managing, designing and upgrading complex Pharmacy Purchase data warehouse with business intelligence solutions by communicating with each vendor’s data representative.
• Create ETL process by using SSIS to create package for direct purchases for new vendors.
• Provide with high accuracy, service and communication for AD-Hoc reports with timely manner by using T-SQL and writing complex query.
• Worked with 7 different service lines (MedSurg, Cardiology, Imaging, Non-Clinical, Information Services, FPS, Pharmacy) by supporting each service lines to capture financial savings with different AD-Hoc report, Urgent.
• Managing outside vendors raw data by monitoring business partners are giving accurate, timely and accountable for their deliverables.

2495 Natomas Park Dr #400, Sacramento, CA 95833

2495 Natomas Park Dr #400, Sacramento, CA 95833

• Monitors availability of prices, indices, exchange rates for CALPERS portfolio
• Ensures all financial statements meets accuracy in daily reports to clients.
• Managing, reporting and operating 21 CALPERS funds in a daily basis
• Maintains accurate accounting records using an internal database application (MCH)
• Run reports using Excel macro (daily, weekly, monthly)