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 by Sutter Pharmacy VP.• 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 reports and managing multiple projects.• Managing outside vendors raw data by monitoring business partners are giving accurate, timely and accountable for their deliverables.• Work with 100,000 of rows in a daily basis and report an analysis by using high volumes of data.• Created Tableau report to capture system level Pharmacy spend, and used Tableau for different AD-Hoc reports.• Trained new team members on how to work with different service lines, financial templates, T-SQL Training and business training. • Designs statistical audits to validate the integrity of vast amounts of monthly data

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)