Learn Data Skills
Beta
Eric Vasquez

Eric Vasquez

Senior Financial/Data/BI Analyst

University of Kentucky

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Project

Dr. Semmelweis and the Discovery of Handwashing

My New Track

Data Scientist

My New Course

Introduction to Python

Quantitative architect, building solid foundations of insights with data.

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

course

Introduction to R

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to R
Intermediate Python
Data Manipulation with pandas

My Work Experience

Where I've interned and worked during my career.

CommonSpirit Health | Feb 2022 - Present

System Manager Pharmacy Analytics

Develops data architecture, data culture, and structure of Analytics team in a way that maximizes the efficient delivery of varied analyses to organizational wide leadership while ensuring data integrity and standardization. Provides thought-leadership and oversight for the development of critical analytic solution(s) in support of pharmacy cost and utilization management goals. Responsible for providing leadership and oversight for pharmacy analyst staff; financial analyses; design, generation and interpretation of reports and dashboards; and presentation of key findings. Validating and presenting findings to stakeholders by expressing assumptions and validation work in a way that can be easily understood. Provide guidance for standardization of analytic processes for the Pharmacy Enterprise including the 340B Program, Contract Pharmacy, Pharmacy Operations and Pharmacy Business Analytics. Oversee the integration and preparation of varied/disparate datasets, along with the creation of product categorization schemas necessary for providing actionable insights that link product cost, quality and safety together to enable successful patient and business outcomes. Propose innovative ways to look at problems by using data mining approaches on the set of information available. Leadership for Pharmacy Enterprise analytics staff including the 340B Program, Contract Pharmacy, Pharmacy Operations and pharmacy business analyst staff. Provides guidance and serves as a mentor to team members providing analytic support. Oversees, coordinates and actively contributes to data and analytics in facilitating the interrelationship within pharmacy management and other CommonSpirit Health departments as appropriate. Works with IT and BI to design algorithms, logic, test hypotheses, and build models. Qualifies what information can be stored or what information, internal or external to the organization may be used in support of the use case.
Show More

University of Kentucky | Apr 2019 - Mar 2022

Pharmacy Financial Senior Specialist

Business Partner who facilitated and led reporting, dashboarding, analyzing, and modeling data from various sources for a department that generated $1B in operating margin over the last ten years and grew operating margin per month by $18M (+900%) since joining the team • Design, develop, standardize, and present month/year-end reporting packages of financial performance, that totaled ~$180M in annual operating margin, to C-Suite, VP, Sr. Director, and Directors • Design, build, update, maintain, and distribute interactive and dynamic dashboards that highlight KPIs and key drivers and are used for operations, labor allocation, compliance, revenue collection, and expense analysis • Deliver training/education for all planning and analysis to hospital-based departments while also providing mentorship and leadership to junior members of the organization and serve as a role model • Provide training and be an SME for Tableau dashboard analysis for Directors, Administrators, Leadership, etc. • Support strategic decisions via data and business analysis for new products/ services, performing business case reviews, data validation, and feasibility studies in collaboration with clinical leadership and department owners • Perform data ETL, validation, modeling, and dashboarding utilizing database skills, various programming languages (R, SAS, Python, SQL, DAX), and BI tools (Tableau, PowerPoint, Qlik, Excel) • Manage projects for dashboards for departments and clinics to include conception and initiation, definition and planning, execution, performance and control, and the formal closing of the project • Business process design, creation, and implementation for new products and services with an emphasis on operational efficiency, financial reporting accuracy, business forecasting, and compliance • Provide input regarding data requirements during new internal and external relationship building • Most duties and responsibilities as listed for previous positions

University of Kentucky | Jul 2017 - Mar 2019

Sr Financial Analyst/Auditor

• Furnish 340B compliance team with data after ETL procedures and data validation • Data validation and report generation for multiple accreditation and auditing bodies • Proactively researched, designed, and initiated reporting system (Tableau) that saved the position ~8 hours/week • Process automation via utilization of programming languages and BI tools • Variance analysis for budget-to-actual, year-over-year, expected-to-actual, and trend analysis for various KPIs • Forecast potential impact on operations and financials of various organizational initiatives including purchasing, product substitution, and contract commitments • Analyze current business SOPs and redesign where appropriate with detailed documentation updates • Work collaboratively with marketing and clinics to identify patients filling RXs externally and quantify the operating margin opportunity of targeting those patients and then forecasting the financial impact of various capture rates • Responsible for financial month-end close and analysis of operational/ financial activity for all pharmacy cost centers (specialty, retail, contract, and inpatient) including revenue/expense accruals • Assist in developing policies on cash handling, responsible for managing day to day procedures, reconciliations, and audits in all retail pharmacies (seven) in areas of cash, check, and credit cards

University of Kentucky | Oct 2013 - Jun 2017

Financial Analyst

• Some responsibilities listed in subsequent position • Developed and performed the daily audit process for comparing charges files posted to patient accounts versus the underlying source system reports and investigated material variances • Developed and performed the daily audit process to validate correct J Code assignment to pharmacy transactions • Complete various ad-hoc analyses as requested by customers (Pharmacists, Doctors, Researchers, Administrators, Directors, and other Leadership personnel)

Kring Ray Farley & Riddle, PSC | Mar 2007 - Jul 2013

Senior Accountant Audit/Tax

• Designed audit plan; designed and performed audit procedures of all financial statement areas including cash, receivables, prepaid assets, pledges/grants receivable/payable, inventories, fixed assets, investments, accounts payable, accruals, deferred revenues, notes payable, and net assets/equity; all in accordance with GAAS • Prepared GAAP financial statements including Income Statement, Balance Sheet, Statement of Retained Earnings, Statement of Cash Flows, and GAAP required note disclosures • Analyzed current operating results, compared to Budget, investigated, and corrected material variances from Budget or other expectations • Performed walkthroughs and control testing on internal controls and communicated any findings and recommendations for improvement to management and Board of Directors • Prepared tax returns for individuals, estates, trusts, corporations, partnerships, and non-profit organizations

KPMG US | Sep 2006 - Feb 2007

Staff Accountant

• Prepared matrices to document internal controls and associated risks • Read client position narratives and prepared flowcharts to document flow of operations • Performed walkthroughs and control testing on internal controls • Performed audit services in areas of cash, receivables, fixed assets, and payables • Performed audits/observations of physical inventory counts

My Education

Take a look at my formal education

Master of Science in Data Science Eastern University | 2023
Master of Business Administration - MBA University of Kentucky | 2021
Bachelor of Science - BS, Major: AccountingUniversity of Kentucky | 2006
Bachelor of Business Administration - BBA, Major: Finance, Minor: EconomicsUniversity of Kentucky | 2003

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free