· Research studies involving a variety of non-invasive clinical research trials primarily in cardiac arrest, sepsis/septic shock, respiratory failure involving mechanical ventilation, influenza, coronary artery bypass graft, liver failure, and traumatic brain injury· Look through in-patient medical records for eligible patients that fit research criteria and enter patient information into database after admission including demographics, past medical history, vitals/labs· Manage all research databases via REDCap and construct/maintain databases for quality standards for numerous protocols· Perform a variety from basic to complex queries via SQL from in hospital database servers for research purposes· Validate data entered from other staff for accuracy· Collaborate with principal investigator to analyze study data for table and graph preparation· Maintain and develop the SQL Server research database specific to the research group and conduct data mining and analysis· Assist with manuscript and abstract submission and writing· Automate research work flow through a variety of coding languages

Created internal auditing/compliance program to qualify prescriptions from different contract pharmacies for 340B eligible reducing the need, work, and fees of third party administratorsQuery pharmacy related data via SQL to create a variety of reports involving 340B compliance, drug usage/projections, outpatient volume, etc.Perform a variety from basic to complex queries via SQL from in hospital database servers for pharmacy purposes including research pharmacyCreate dashboards for high level overview of day to day pharmacy workload and for quality assurance/improvement needs and kpi monitoringOptimize drug formulary for retail and specialty pharmacy

Created internal auditing/compliance program to qualify prescriptions from different contract pharmacies for 340B eligible reducing the need, work, and fees of third party administrators· Query pharmacy related data via SQL to create a variety of reports involving 340B compliance, drug usage/projections, outpatient volume, etc.· Perform a variety from basic to complex queries via SQL from in hospital database servers for pharmacy purposes including research pharmacy· Created dashboards for high level overview of day to day pharmacy workload and for quality assurance/improvement needs

· Created internal auditing/compliance program to qualify prescriptions from different contract pharmacies for 340B eligible reducing the need, work, and fees of third party administrators· Query pharmacy related data via SQL to create a variety of reports involving 340B compliance, drug usage/projections, outpatient volume, etc.· Perform a variety from basic to complex queries via SQL from in hospital database servers for pharmacy purposes including research pharmacy· Created dashboards for high level overview of day to day pharmacy workload and for quality assurance/improvement needs