Microsoft SQL Server - SSMS
TROY MATHEW MELANDER
Senior Developer
San Diego,CA
Summary
Focused Clinical Informatics Specialist aiming to leverage five years of exceptional Healthcare-Data knowledge. Highly skilled in assessing workflow processes and clinical operations to identify deficiencies and build data driven tools used for continuous improvement. Aiming to utilize expertise in information systems to assist in realizing business mission and goals.
Overview
11
11
years of professional experience
5
5
years of post-secondary education
Work History
Clinical Informatics Specialist IV
University of California, San Diego Health
San Diego , CA
02.2023 - Current
- Area of Focus: Clinical Research.
- Assisted in optimizing health information systems throughout company by demonstrating advanced knowledge of clinical processes and supporting technology.
Clinical Informatics Specialist I-III
University of California, Health
San Diego
01.2017 - 02.2023
- Clinical Informatics Professional I-III, Extensive experience building T-SQL stored procedures, automating reporting through SSMS, SAP Business Objects Enterprise, and Tableau.
- Stored Procedures used in Epic-Crystal integration.
- Stored Procedures used in Tableau Server integration.
- Stored Procedures used in SAP Business Objects Enterprise automation of ad-hoc reports.
- Automated productivity metric dashboards from SSMS to Tableau visuals.
- Integrated ServiceNOW data in SSMS stored procedures used in Tableau for visual productivity dashboards.
- Wide range of experience within a large scale Health System.
- Data manipulation, data integrations, data rule logic and migrating from Legacy systems, data governance in Change Control.
- Extensive database Extract Transform Load (ETL) experience.
- Project-Lead of Go-Lives for Epic modules for Clinical Research Billing, and other projects.
- EPIC Data Models: Professional Billing, Hospital Billing, Clinical Research & Billing, Clinical Data, Health Information Management (HIM), Patient Access, Patient Flow, among others data models encompassed in a large healthcare system.
- Provided guidance in development, implementation and maintenance of company clinical information system.
- Liaised between providers and IT team to inform management and facilitate project completion.
- Provided guidance for cross-departmental clinical improvements.
- Led, facilitated and attended focus groups and meetings to strategize workflow issues.
- Applied knowledge, data, information and workflow to develop evidence-based models for health information technology solutions.
Service Representative
24 Hour Fitness, Inc
San Clemente , CA
01.2014 - 01.2015
- Awarded Outstanding Team Member, three consecutive months and 2014 overall.
Membership Counselor
University of California
01.2014 - 01.2015
- Promoted from service to sales in five months; company cited outstanding sales.
Undergraduate Research
Artificial Kidney
01.2012 - 01.2013
- Provided hands-on research, in individual and team projects, to identify new methods for improved clinical and economic outcomes.
Education
Bachelor of Science - Public Health
University of California – San Diego
San Diego 01.2015 - 06.2017
Associate of Science - Sciences, Business and, entrepreneurship
Saddleback College
08.2012 - 06.2015
Skills
5 Years of Epic experience
undefinedAccomplishments
1. Epic Clarity - Professional Billing
2. Epic Clarity - Hospital Billing
3. Epic Clarity - Clarity Data Model
4. Epic - Radar/Cogito Fundamentals
5. Epic Clarity - Clinical Data Model
6. Epic Clarity - Clinical Research Billing
7. Epic - Caboodle
8. Epic - Revenue Data Model
Additional Information
- Published Author in the American Journal of Public Health for the California State Legislature: Universal Lead Screening Requirement A California Case Study.
- Hobbies: Surfing, Backpacking, Scuba, Paragliding, Kayaking, Skiing.
Software
EPIC - Cogito & Radar
Epic - TEXT & Batch Scheduler
Epic - RWB SQL
Epic - RWB
Epic - Table Wizard
ServiceNOW - Agile Workflows
Microsoft Suite - Excel, Outlook
Tableau
Power BI
Timeline
Clinical Informatics Specialist IV
University of California, San Diego Health
02.2023 - Current
Clinical Informatics Specialist I-III
University of California, Health
01.2017 - 02.2023
Bachelor of Science - Public Health
University of California – San Diego
01.2015 - 06.2017
Service Representative
24 Hour Fitness, Inc
01.2014 - 01.2015
Membership Counselor
University of California
01.2014 - 01.2015
Associate of Science - Sciences, Business and, entrepreneurship
Saddleback College
08.2012 - 06.2015
Undergraduate Research
Artificial Kidney
01.2012 - 01.2013
Similar Profiles
Mary ConnollyMary Connolly
Sr. Contact Center Engineer at University of California, San Diego HealthSr. Contact Center Engineer at University of California, San Diego Health
Alec MorganAlec Morgan
Adjunct Professor at National UniversityAdjunct Professor at National University
Sara WagnerSara Wagner
Sports Videographer at University Of California San DiegoSports Videographer at University Of California San Diego