● Review IRB protocols for inclusion/exclusion criteria and data to display● Fulfill data extraction requests for researchers by creating SQL queries against Clarity, Caboodle or OMOP databases using the provided criteria● Work with various Clarity Data Models (Mostly Clinical and Access Data Models)● Create data extracts to be used for importing data into REDCap● Search for patient cohorts using SlicerDicer or CohortDiscovery (I2B2)

● Modified or created Beaker Crystal Reports to cater to UC Davis Lab requirements● Handled ad-hoc report requests related to non-Beaker data models● Edited Oracle PL/SQL Queries for use in Crystal Reports● Promote Crystal Reports in Business Objects server to production BO server and schedule as needed● Fixed several reporting workbench related reports related to orders and patients● Created and edited HCLL reports in SSRS using Microsoft T-SQL. ● Validated data in lab business objects universe● Tested reports to make sure they worked with 2018 Epic upgrade as well as BO server upgrade

● Provided support related to result entry, the outstanding list, specimen inquiry, lab label printing, result reports, containers, and requisition entry● Built tests, components and tested with reference labs as required● Created SQL Queries for use in Crystal Reports, Excel and SSRS o Created a query to track blood bank utilization, linking prepare orders to transfusions that also brought in resulted labs based on the date the transfusion took place o Created a query based on an Epic Reporting Workbench report to find labs where the collection information was not documented properly by non-lab staff.● Edited Epic-released Crystal reports to lab specifications, adding parameters and changing queries to better suit labs needs● Designed, built and validated new Beaker functionality and build during various SUs as well as most recently during the 2014 to 2017 double upgrade, reviewing necessary release notes

● Built, mapped and participated in integration testing for components and procedures to be used in connection with the go-live of an interface with a legacy lab system● Worked with Lab Medicine on projects to fix mismapped components, their associated base names, the smartlinks that use them, and their common names.● Started the process of rebuilding the results review tree.● Acted as a liaison between the Ambulatory and Bridges Teams, handling lab, radiology, and pathology related interface errors.● Reviewed Epiccare Ambulatory 2014 release notes and tested as needed

● Smart Tool build and modification● Built and modified navigators.● Supported and modified Workflow Engine Rules and Order Transmittal Rules as needed● Built and modified print reports and print groups● Built and supported Cancer Staging Form● Tested Epic 2012 release

● Ensured that LRRs and EAPs are mapped appropriately by working with Lab Medicine● Tweaked various print groups to UW standards.● Built and validated unsolicited result● Performed monthly medispan loads● Helped build, validate, and troubleshoot surescripts during and after its implementation● Helped consolidated order transmittal rules.● Built and maintained various smart tools.● Trained new UW employees and supported end-users during several implementations● Participated in integrated regression testing for SU packages and updates as needed, including the 2010 upgrade.● Worked closely with interfaces, suggesting and requesting changes to profile variables and interfaces as needed as well as troubleshooting interface errors.● Built destination maps and provided troubleshooting for existing maps as needed.

● Provided phone and email support for Physicians, RNs, and other medical staff from various Sutter hospitals and medical offices for the EpicCare InPatient and EpicCare Ambulatory systems.● Built and edited EMP and SER records.● Build and edited pools and classes

● Analyzed users' computer competency to determine the training that was needed for optimal use of the Epic Software Suite.● Worked cooperatively with department heads and the region to determine what security access was needed for each user in a department.● Participated in workflow meetings to determine how each department would use Epic and what "smart phrases" each department would need to be built prior to the go-live date.● Trained and supported doctors, nurses, and other medical staff in the use of EpicCare Ambulatory and Cadence● Supported EpicCare Ambulatory and resolved issues as needed ● Audited account requests for users in various regions.

●Troubleshot advanced internet connectivity issues for Tier 2 internet support, from modem and hardware issues, to connectivity issues related to the operating system and 3rd party software. ●Troubleshot any supported router issues for end-users.

● Provide technical support for users at a university computer lab. ● Fix and clean student computers of spyware and viruses ● Show students how to use various programs.

● Provide email and internet support for staff and faculty at SDSU, specifically in the use of Eudora

● Maintained and managed excess computer equipment, including testing, wiping as necessary, and reutilizing for internal departments and external companies.