Created and modified over 80 reports using Cerner Command Language (CCL, Cerner’s version of SQL, based on Oracle RDBMS), the Cerner Millennium Data Model, all phases of the Software Development Lifecycle (SDLC), change control processes and sprint planning. Led customer-focused troubleshooting activities to resolution on over 30 incidents.
CCL techniques learned: Record Structures |Data extraction from BLOBs | Temporary tables | Subroutines | Aggregates | Reports with multiple query and report writer sections.

HL7 interface development using Cloverleaf, TCL, FTP, TCP/IP. Project coordination, requirements analysis, testing, and implementation.

Analysis and programming support of application software and interfaces in a multihospital healthcare system. Participation in off-hours on-call rotation.• Requirements analysis, design, development and implementation of HL7 interfaces using Cloverleaf v6.0 (TCL) in a multi-hospital organization, including radiology orders and results. Updated interfaces based on helpdesk tickets and change control processes.• Utilized Cerner Foreign System Interfaces (FSI) and CCL tools: OpenView, SI_Manager (ESI/ESO contributor system configuration), Core Code Builder, CCL.• Worked closely with the user community, application vendors (Epic) and other information services teams to ensure proper data flow between systems.

Provided engineering and information technology expertise to a functional magnetic resonance imaging research team of psychologists, engineers, and students. • Co-authored and presented an academic poster at an international conference. Cote, D.M., Clark, U.S., Jerskey, B.A., Walsh, E., Sweet, L.H. Altered Blood Oxygen Level Dependent Response Independent of Cognitive Function in Older Adults. Journal of the International Neuropsychological Society, 2011, 17 (S1).• Managed daily task assignments for up to four Research Assistants to support screening and recruiting.• Led the development of methods to determine cortical thickness from MRI data and to correct motion artifacts from physiological processes in fMRI analyses. Co-author on four publications using these methods.• Added these methods to the existing pipeline and created a data processing guide, documenting the new procedures.• Created a study database with SQL queries, a user interface and an ODBC connection to a statistics package (SPSS) from user requirements for 1000+ variables. Uploaded data files from multiple sources.

Part-time contract position to install, configure, test, and utilize neuroimaging software. • Created and documented Linux C-shell scripts to convert DICOM images from 100+ subjects into anatomical statistics, with minimal manual intervention.

Provided analysis and programming support of application software and interfaces. + Presented XML DTD and diagnosis/procedure code requirements for a Core Measures implementation to the data warehouse team. Utilized Microsoft SQL Server/Siemens’ Data Warehouse stored procedures to query existing data clusters. Generated Crystal Reports using extracted data.+ Coordinated small project implementing an automated FAX solution for verifying physician contact information prior to entry in the master database. Resulted in increased quality and reliability of stored physician information.+ OPENLink HL7 interface development, testing (unit through integrated) and support. Development work was primarily with ADT interfaces.