Résumé
OBJECTIVE
A position in Information Services with special interests in project management, application integration, and business intelligence.
SKILLS
Languages & Software
MS SQL Server and Reporting Services, Oracle, MySQL, SQLite, IBM Showcase, MS Office (advanced Excel and Access training), Tableau, Infosphere CDC, Talend Open Studio for Data Integration, Jitterbit, DB2 Web Query, R, PHP, Perl, Python, Haskell, Java, Javascript, Ruby, Shell scripting
Operating Systems
Windows, Linux, Mac OS X
EXPERIENCE
Data Engineer (Data Systems Analyst 4) (March 2018 to present)
UCI Health IT, Orange, CA
Enterprise Data & Analytics
- Developed Quality Measure Platform based on OMOP CDM and Collibra. In production use calculating daily results for seven quality/value programs.1
- Coordinate Quality Value Program Team to continuously improve code.
Programmer/Analyst III (March 2011 to March 2018)
UCI Health Affairs, Orange, CA
Clinical Informatics
- Co-designed UCI Physician Quality Reporting System
- Developed interface to EMMI Solutions patient engagement system
- Converted legacy SQL Server DTS and SSIS packages to Talend Open Studio for Data Integration
Athena Technical Project Coordinator (March 2011 to present)
University of California, Irvine, Irvine, CA
Department of Epidemiology, School of Medicine
- Athena Breast Health Network Technical Coordinator
- Developed interfaces between hospital enterprise systems, Radiology Information System, and Athena Salesforce API
- Developed local database to publish weekly dashboard and researcher data export
- Developed data workflows for distinct clinics and provided technical support
- Maintained Cancer Genetics Research Information System, managed biospecimen collection migration to Forte OnCore
Awards
- 2013 ICTS Interdisciplinary Team Science Award
Programmer/Analyst (June 2009 to March 2011)
Irvine Ranch Water District, Irvine, CA
Information Services
- Managed Tabware Enterprise Asset Management (EAM) upgrade and migration to browser-based clients
- Managed EAM integrations with custom financials, payroll, HR and other enterprise applications
- General end user training, workflow optimization, and technical support
President, IT Director (2007 to present)
Plug In America, San Francisco, CA
Board of Directors
- Worked with IT team to migrate enterprise to Google Apps
- Managed www.pluginamerica.org website redesign in Drupal
- Set up corporate blog, Democracy In Action Customer Relationship Management system, and web/email server
- Developed in-house PHP/MySQL Content Management System
- Worked with team preparing organizational strategic plan
- Elected Board President from January 2013 to present
- Elected Board Secretary from 2007 to 2010
Programmer/Analyst (July 2008 to June 2009)
Irvine Ranch Water District, Irvine, CA
Engineering & Operations Support
- Designed integration of EAM with district custom time reporting system, and developed new reports
- Developed automated SCADA reports for lab and operations staff
- Worked with teams designing EAM/SCADA integration, and SNMP network monitoring project
- Guided field operations departments into utilization of EAM (total 130 users)
- Training: MS SQL Server and Reporting Services, MIMOSA
Administrative Analyst (July 2002 to July 2008)
Irvine Ranch Water District, Irvine, CA
Wastewater Operations Administration
- Migrated four maintenance departments, and a new plant, from paper-based system to work management system
- Developed pipeline maintenance, hazardous materials, and training databases
- Developed automated permit compliance reporting script, generated monthly strategic measures
- Administered access control, fire alarm, video surveillance, and A/V systems
- Managed workforce assessment project
- Prepared department operating budget
- Worked with teams setting up emergency operations center, designing custom time reporting system, selecting district 457 plan provider, and standardizing strategic measure reporting
- Training: Xerox Total Quality Management
EDUCATION
Bachelor of Science, Information and Computer Science (1993)
University of California at Irvine, Irvine, CA Projects: environmental controller electronic design, simple operating system
McDonnell Douglas Scholarship recipient
Online
- Health Informatics on FHIR. Georgia Institute of Technology 2018. (verify)
PUBLIC SPEAKING
Presentations to other utility agencies, California Air Resources Board, IRWD Earth Day, OEVA EV Awareness Day, Go Green Expo
COMMUNITY SERVICE
Plug In America, ASES National Solar Tour
PERSONAL
California native, married with two children, fluent in Spanish, basic French
PUBLICATIONS
Kelly, Richard. “Quality Measurement Engine (QME) at UC Irvine Health.” May 5, 2019. University of California, Office of the President. https://www.ucop.edu/information-technology-services/initiatives/sautter-award-program/sautter-2019/uci-health-quality-measurement-engine.pdf
Park et al. “Abstract 2599: Association of periodontal disease and breast health in women undergoing screening mammography.” 2016. American Association for Cancer Research. <>
Park et al. “A pilot study comparing breast cancer risk scores using models with and without breast density among women of different race/ethnicities undergoing breast screening in the University of California, Irvine Athena Breast Health Network cohort”, Journal of Cancer Research, October 1, 2014 74; 3243, doi: 10.1158/1538-7445.AM2014-3243, http://cancerres.aacrjournals.org/content/74/19_Supplement/3243
Kelly, Richard. “Do Gas Prices Correlate With Plug-in Vehicle Sales?”. Plug In America. http://www.pluginamerica.org/drivers-seat/do-gas-prices-correlate-plug-vehicle-sales
REFERENCES
Available upon request
PRIME/QIP, QPP, TCPi, UDS, CAPG, and MSSP ACO.↩︎