Aug 2003
- Present |
Senior Analyst Programmer
Mayo Clinic Rochester: Media Support Services, Publishing & Media Technology Services |
|
|
|
|
• |
Quarterly on-line |
|
|
|
overview: |
Web based directory of Mayo Clinic employees, yellow pages (classifieds) and
committees. |
|
|
|
audience: |
All Mayo Clinic employees. |
|
|
|
duties: |
Lead on-line developer: analysis, coding, design and web design. |
|
|
|
technologies: |
Adobe ColdFusion, Microsoft SQL and Sybase |
|
|
|
url: |
quarterly.mayo.edu |
|
|
|
|
|
|
|
• |
Policies and Procedures Program |
|
|
|
overview: |
Web based policies and procedures system using Oracle/Stellent
Universal Content Management System. |
|
|
|
audience: |
All Mayo Clinic employees. |
|
|
|
duties: |
Lead
developer: analysis, coding, database, design and server
administration. |
|
|
|
technologies: |
Oracle Site Studio, Oracle CMS, Oracle/Stellent Idoc script and
Microsoft SQL |
|
|
|
url: |
mayocontent.mayo.edu |
|
|
|
|
|
|
|
• |
This Week at Mayo Clinic Rochester and
Florida Newsletters |
|
|
|
overview: |
Web based publication for allied health staff at Mayo
Clinic Rochester and Florida. Its purpose is to communicate information
regarding Mayo Clinic programs, services, initiatives and policies,
as well as provide items of interest and links to helpful resources. |
|
|
|
audience: |
All Mayo Clinic employees. |
|
|
|
duties: |
Lead
developer: analysis, coding, database, design and server
administration. |
|
|
|
technologies: |
Oracle Site Studio, Oracle CMS, Oracle/Stellent Idoc script and
Microsoft SQL |
|
|
|
url: |
newsletters.mayo.edu/thisweek |
newsletters.mayo.edu/thisweek-florida |
|
|
|
|
|
|
|
• |
Voting/Consulting Staff Newsletter |
|
|
|
overview: |
Web based publication for physicians, researchers and
voting administrative staff. Its purpose is to communicate
information regarding Mayo Clinic programs, services, initiatives
and policies, as well as provide items of interest and links to
helpful resources. |
|
|
|
audience: |
Primary audience is
Mayo voting/consulting staff. |
|
|
|
duties: |
Lead
developer: analysis, coding, database, design and server
administration. |
|
|
|
technologies: |
Oracle/Stellent Site Studio, Oracle CMS, Oracle/Stellent Idoc script
and Microsoft SQL |
|
|
|
url: |
newsletters.mayo.edu/voting |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
• |
CATS (Cards & Tags System) |
|
|
|
overview:
|
Web application for requesting business cards,
name tags, mailbox tags, stationary and letterheads.
|
|
|
|
audience: |
Accessible by all Mayo Clinic employees (primary audience is
administrative assistants). |
|
|
|
duties:
|
Lead
developer: analysis, coding, database, design and server
administration.
|
|
|
|
technologies: |
Adobe ColdFusion, CodeCharge Studio, CFX DynamicImage, FTP,
PatternStream and Sybase |
|
|
|
url: |
cfprod.mayo.edu/pmts/cats |
|
|
|
|
|
|
• |
CME (Continuing Medical
Education Printing/Mailing Request) |
|
|
|
overview: |
Web application for ordering standard printed products related to
Mayo continuing medical educational courses |
|
|
|
audience: |
Continuing Medical Education Specialists and PMTS Publishing
Analysts. |
|
|
|
duties: |
Lead
developer and web designer. Database design and
maintenance. |
|
|
|
technologies: |
Adobe ColdFusion and Sybase |
|
|
|
url: |
cfprod.mayo.edu/pmts/cme |
|
|
|
|
|
|
• |
CultureWatch |
|
|
|
overview: |
Web application reporting system for activity of various infectious
diseases. |
|
|
|
audience: |
Accessible by all Mayo Clinic employees (primary audience is
physicians and health care providers). |
|
|
|
duties: |
Lead
developer and web designer. Database design and
maintenance. |
|
|
|
technologies: |
Corda PopChart, Adobe ColdFusion and Microsoft SQL |
|
|
|
url: |
culturewatch.mayo.edu |
|
|
|
|
|
|
• |
MHS Print (Mayo Health System
Stationary & Nametag Requests) |
|
|
|
overview: |
Web application for requesting stationary, business cards, name
tags, and letterheads. |
|
|
|
audience: |
MHS administrative assistants. |
|
|
|
duties: |
Lead
developer. Database design and
maintenance. |
|
|
|
technologies: |
Adobe ColdFusion, CodeCharge Studio, CFX DynamicImage, FTP and
Sybase |
|
|
|
url:
|
cfprod.mayo.edu/pmts/mhsprint |
|
|
|
|
|
|
• |
PatternStream |
|
|
|
overview:
|
Database Publishing Software
|
|
|
|
audience: |
PMTS employees and customers. |
|
|
|
duties:
|
Design and maintain database publishing jobs for
printed Quarterly phonebook, Mayo business cards, calendars and
committees. Database design and
maintenance. Server administrator.
|
|
|
|
technologies:
|
Finite Matter's PatternStream, Adobe FrameMaker,
Adobe ColdFusion and Sybase
|
|
|
|
url:
|
neo.mayo.edu/patternstream |
|
|
|
|
|
|
|
• |
RPD (Referring Physicians Directory) and
IMOUTRPD (Internal Medicine Outreach Referring Physicians Directory) |
|
|
|
overview: |
Referring Physician Directory website and publishing system for
Internal Medicine |
|
|
|
audience: |
Internal Medicine Outreach Program office. |
|
|
|
duties: |
Lead developer. Database design and
maintenance. |
|
|
|
technologies: |
Adobe ColdFusion, CodeCharge Studio, PatternStream and Sybase |
|
|
|
url: |
cfprod.mayo.edu/pmts/rpd,
cfprod.mayo.edu/pmts/imoutrpd |
|
|
|
|
|
|
|
• |
PMTS Web Developers |
|
|
|
overview: |
Web application documentation system. |
|
|
|
url: |
neo.mayo.edu/apps |
|
|
|
|
|
|
|
|
|
June 2000
- Aug 2003 |
Analyst Programmer
Mayo Clinic Rochester: Information Services, Internal Medicine Management
Support (IMMS) |
|
|
|
|
|
|
• |
STARS
(Strategy Tracking and Reporting System) |
|
|
|
overview: |
Web based executive reporting system which displays
measurements in the following areas: serve the patient, advance the
science, financial performance, planning for the future and staff
satisfaction. STARS uses a data warehouse populated with an aggregation of data from different transactional databases. |
|
|
|
audience: |
Department of Medicine administrators. |
|
|
|
duties: |
Web
Project lead. Primary ColdFusion developer, report
and user interface designer. Database and
stored procedures. |
|
|
|
scope: |
Approximately 48 reports, 150 screens, 600 graphs
and 800 cfm pages.
Database: 150 tables, 250 MB data and 800 stored procedures. |
|
|
|
technologies: |
Adobe ColdFusion, Corda PopChart and Sybase. |
|
|
|
url: |
cfprod.mayo.edu/dom/stars/ |
|
|
|
|
|
|
|
• |
FREES
(Faculty Resident and Rotation Electronic Evaluation System) |
|
|
|
overview: |
Web based evaluation and scheduling system for medical faculty &
residents. |
|
|
|
audience: |
Internal Medicine residents and fellows. |
|
|
|
duties: |
Redesign user interface and clean-up code. Perform feature
enhancements and migrate from Access to SQL. |
|
|
|
technologies: |
Adobe ColdFusion, CFXGraphicsServer and Microsoft SQL. |
|
|
|
|
|
|
|
• |
RECARS
(Resident Elective Catalog and Review System) |
|
|
|
overview: |
Web based catalog of medical resident electives with review system. |
|
|
|
audience: |
Internal Medicine residents and fellows. |
|
|
|
duties: |
ColdFusion developer and user interface designer. Database and
stored procedures. |
|
|
|
technologies: |
Adobe ColdFusion and Microsoft SQL. |
|
|
|
|
|
|
|
|
Sept 1997
-
May 2000 |
Mayo Foundation
Mayo Clinic Rochester: Communication Technology Services |
|
|
|
|
|
|
• |
Knowledgebase project |
|
|
|
overview: |
Web browser based
HTML authoring with database document storage and querying.
Migrate from Access to SQL. |
|
|
|
technologies: |
ASP, eWebEditPro, JavaScript and Microsoft SQL |
|
|
• |
Phone answering, callback and on-site support for PC, Macintosh and
Mainframe |
|
|
|
|
|
|
|
|
Oct 1992
-
Aug 1997 |
Systems
Software Programmer
University of Minnesota: Medical School, Department of Pediatrics,
Minneapolis, Minnesota |
|
|
|
|
|
|
• |
Supervision of two computer professionals (User
Specialist and Analyst/Programmer) |
|
|
• |
Custom programming and design of client/server patient care
application relational databases for Echocardiography Laboratory and Neonatology |
|
|
• |
Advise and consult with faculty and staff concerning
their computing needs |
|
|
• |
Installation and maintenance for approx. 250 computers, 80 printers and 7 servers |
|
|
• |
Planning and supervision of computer projects |
|
|
• |
www design and server maintenance
(www.peds.umn.edu) |
