Ashley Patrick Email & Phone Number

Dallas, Tx, Us

o Leads five end-to-end data management and data-delivery service teams – Integration (Internal & Client), Data Engineering (Tech support and Data Warehouse development) and Analytics (Internal & Client).o Led an initiative to move existing reporting infrastructures into Synapse and MSFT Fabric. o Helped the data team to build Aya’s first Data Warehouse in MSFT Azure data lake and ASQL databases.o Helped build out the ETL and integrations service portfolio to provide customers, their data needed for integrated reporting.

o Took a team of 2 Data Engineers and built out the department into 3 teams– Database Administration (DBA), Analytics and ETL/Integrations Team.o Built out the analytics team, to support data-driven decisions for app feature development and ETL system maintenance and support.o Led database clean-up initiatives to support both the OLAP and OLTP environments. o Instituted Github integrated solutions to promote source control of OLAP updates and PBI dashboards.

o Worked with IT and Business Intelligence teams to release the first client-facing Power BI dashboard at Vizient.o Taught the team regression and machine learning principles which led to the first machine learning rate prediction model in the company.o Led statistical and qualitative analytics for clients as well as internal executive leadership.o Built a data warehouse for OLAP support and development.o Responsible for the full data analytics life cycle from understanding department needs, to data preparation, analysis and reporting.o Created and maintained complex stored procedures for ETL and data conversion.o Environment: Python, MS SQL Server 2018, SSMS, SSIS

Management:o Supervises a team of skilled analysts to address the gaps in metric performance.o Serves as a liaison between executive leadership team and project management teams to develop strategic initiatives that lead to the accomplishment of state-funded goals. o Monitors the trends in measure fallout rates by department. o Collaborates with the team on increasing the accuracy of stored procedures based on state mandated specifications.Data Analytics and Reporting:o Leads statistical and qualitative analytics for executive committees and UTSW departments.o Responsible for the full data analytics life cycle from understanding department needs, to data preparation, analysis and reporting.o Creates and maintains complex stored procedures for ETL and data conversion.o Environment: MS SQL Server 2015/2016, SSMS, SAS, MS Excel 2013

o Led statistical and qualitative analytics for executive committees and UTSW departments.o Utilized predictive modeling to deliver actionable insights for care coordination services and disease management. o Performed ongoing evaluation of cost versus quality performance for ~40 quality metrics.o Developed technical and functional requirements for reporting and analytics.o Designed, developed and implemented interactive and intuitive dashboards using Power BI to deliver key metrics to the UTSW departments. o Used Excel Pivot and Power BI to visualize, understand and detect the anomalies in the raw data.o Created and maintained complex stored procedures for ETL and data conversion.

o Coordinated studies with the hospital executive team, Texas Health and Human Services and members of the Accountable Care Organization.o Generated and executed statistical analytics plans, submitted applications for IRB approval, prepared final deliverables (i.e. PowerPoint presentations, tables, figures and a manuscript) and submitted results for publication.o Used innovative biostatistical techniques to assess efficacy of hospital initiatives and identify cost-saving opportunities.o Conducted research on the following indications: Sickle Cell disease, major depressive disorder, cancer, medication management, provider education tools and emergency department use.o Research results led to improved patient outcomes, continued funding of at-risk programs and the presentation of findings at global conferences.

● Developed and/or validated clinical outcomes assessments used for clinical trials that led to FDA approval.● Collaborated with researchers about innovative techniques in assessment of patient insight, meaningful change and quality of life.● Developed and executed statistical analytics plans for numerous clinical trials.● Cleaned data to comply with FDA regulations (i.e. CDISC and TFL formatting).● Wrote project proposals and presented to potential clients.● Relevant indications include Fabry disease, major depressive disorder, radioiodine-refractory thyroid cancer, sarcomas and metastatic breast cancer.

Tucson, Arizona

● Coordinated the execution of over 30 pediatric oncology clinical trials with more than 300 patients. ● Worked directly with the patient and their treatment teams to administer clinical outcome assessments and drug management according to study protocols. ● Assisted in the biopsies of tissues including bone marrow and breast cancer tumor resections.

College Of Public Health, Tucson, Arizona

Worked in both an administrative and instructional capacity for the Introduction to Public Health undergraduate course. Taught lectures as well as graded all course assignments.

College Of Nursing

Interviewed participants for the Family Diabetes Study (Estudio Familiar de Diabetes) in both Spanish and English.

Tucson, Arizona

Interviewed participants for the Home Insecurity, Foreclosures and Public Health project with Dr. Christina Cutshaw. Study participants were interviewed in both Spanish and English.

Bureau Of Ems And Trauma Systems

● Developed a predictive statistical model to assess opioid administration in the pre-hospital care setting.● Results were used to develop an EMS pain management training given to all EMS personnel tailored to state specific gaps in patient care.

Orem, Utah

Worked with Professional Parent Coordinators and Professional Parents to ensure their employee files were updated and monthly reports turned in on time. Trained new employees on basic responsibilities and made sure they were compliant with trainings and renewal documents. Also completed all monthly payroll responsibilities.

Salt Lake City, Ut

Responsible for finding and processing participants for a clinical study that determined the risk of diabetes for family members of a diabetic. Reviewed results with participants and helped them access further support.

Kingdom Of Cambodia

Worked with RACHA to analyze the effectiveness of their midwife training programs. Work included: ●Researched RACHA’s existing programs by traveling throughout the provinces of Cambodia,attending classes and analyzing curriculum as well as developing a survey to assess class recall andincorporation. ● Reviewed and edited RACHA’s grant proposal to the US Agency on International Development. My research was used to implement an ambulance system in Cambodia.

Salt Lake City, Ut

Tobacco Prevention and Control:Arranged classes and taught middle school students who had been found guilty of under-age drug use the dangers of drug use and drug prevention methods.Tobacco Control in Salt Lake City Bars and Clubs:Assisted bars and clubs transition to the new Utah state mandated smoke-free law. Work included the development of a compliance and reward system, program launch, managing local events and assessment of program effectiveness.

Master Of Public Health (Mph), Epidemiology

Activities and Societies: Dean's List Member, Secretary of the Public Health Student Alliance

Bachelor Of Science (Bs), Public Health

Dean's List Member