Senior Applications Analyst, UCSD Clinical Systems

UCSD Health System Electronic Medical Record Patient Web Portal Administrator

• Installed, maintained, and administered the UCSD Health System "MyChart" Patient Web Portal for the Epic Systems Electronic Medical Record, a web site visited by 8,000+ patients per month.
• Secured and customized site functionality allowing patients to view portions of their health record, schedule appointments, and communicate with their physicians.
• Collaborated with UCSD Health System Marketing to redesign the look and feel of the site to coordinate with the UCSD Health System home page.
• Customized the site user interface and functionality using a combination of HTML, CSS, ASP.NET/C#, classic ASP, and JavaScript.
• Programmed new custom routines and queries in the back end InterSystems Cache high performance object transactional database.
• Designed and programmed a secure session management solution to allow for integration of affiliated third party sites through a web service built on ASP.NET/C#/SOAP.
• Monitored site security using tools such as NeXpose, WebScarab, and WireShark, and researched and provided remediation for emerging security threats.
• Programmed and administered the departmental Change Management System using HTML, ASP.NET/C#, JavaScript, web services, and SQL Server 2008 under Windows Server 2008.

Programmer Analyst 3, UCSD Division of Family Medicine

Systems Analyst/System Administrator

• Designed and built an automated, extensible, custom technology infrastructure from the ground up, including defining user requirements, generating specifications, and purchasing hardware and software.
• Installed, secured, and regularly administered file, web, media, and database servers using:
  • Multiprocessor Xeon-based Dell servers
  • Microsoft Windows Server OS
  • IIS web server with SSL
  • Windows and Flash Media Servers
  • SQL Server
• 2005 UCSD Health Sciences Employee of the Year Honoree for process re-engineering through system analysis, design, and custom software development work.
• Authored an extensive "Data Systems Analysis and Recommendations Report" commissioned by UCSD Healthcare executive administration, which aided in establishing a new Decision Support team within the Medical Group.
• Created data analyses to detect and recover sources of significant lost revenue.
• Developed relations and coordinated with other IT groups within UCSD in order to establish secure, consistent, and compliant systems.

Database Administrator/Data Analyst

• Built and maintained a Divisional data warehouse, combining data extracted using automated ETL jobs under SQL Server Integration Services (SSIS) from several heterogeneous institutional systems, including:
  • Epic/Clarity clinical data warehouse
  • Medical Group data warehouse
  • IADIS Medical Billing data warehouse
  • IDX Scheduling data warehouse
• Expert knowledge of SQL, T-SQL, stored procedures, functions, triggers, and advanced database manipulation.
• Regularly designed highly complex queries for data analysis and reporting to support Divisional healthcare research, finance, and operations.
• Developed and maintained cubes for multidimensional analysis and data modeling using SQL Server Analysis Services (SSAS).

Application Developer

• Designed and programmed multi-tiered web database applications using ASP.NET, C#, DHTML, CSS, JavaScript, and Java, including several complex systems that see heavy daily use within Family Medicine, Internal Medicine, and other Primary Care Divisions. Systems developed and programmed:
  • Clinical Scheduling and Timekeeping System
  • Data Warehouse Analysis and Reporting System
  • Inpatient Patient Tracking System
  • Online Research Questionnaire and Student Testing System
• Consistently applied rapid development and object-oriented techniques to quickly and efficiently develop and extend complex systems.
• Developed documentation and diagrams, and used source control, to provide system maintainability.

Data Security

• Well versed in industry standard data security policies and practices, as well as technical aspects of data encryption and protection from the perspectives of server administration, database administration, and web application programming.
• Applied programming best practices to prevent unauthorized access and compromise of sensitive data.

Research Consultant

• "California Chronic Care Collaborative"-Developed a system to identify patients at high risk for chronic conditions such as diabetes and cardiovascular disease and to track, analyze, and report their clinical outcomes to clinicians.
• "Shared Medical Decision Making"-Developed a system to enable patients to view health education videos online and answer questionnaires about them. Data analysis included tracking correlations between video viewing behavior, questionnaire performance, and clinical outcomes.

Founder & Guide, Adventure Sport Guides

• Co-founder and guide for an outdoor adventure guide service.
• Expert in technical rock climbing gear and techniques, professional interpersonal and customer service guiding skills.
• Designed curriculum and gave instruction in climbing, training, rescue techniques, and gear use in aid, sport, and traditional free climbing.
• Technical consultant and contributor to climbing publications.
• Certified in First Aid and CPR by the American Heart Association.

Software Development Engineer, D & K Engineering

• Programmed engineering machine control and user interface applications across the entire project life cycle, including R&D, specification, design, programming, documentation, and testing in Visual C++/COM for an industry-award-winning, computer-controlled digital film processing mini-lab developed at Phogenix, a Hewlett-Packard/Kodak joint venture.
• Used Microsoft Visual Studio for multi-threaded application, UI, and COM programming in Visual C++. Utilized Visual SourceSafe for source control, and Numega BoundsChecker and VS native tools for debugging and testing. Used proprietary code libraries, including the Kodak Digital Lab System (DLS) plug-in framework, Kodak KIWI user interface windowing replacement, Hewlett-Packard Mcx state machine control library, and the Gear Writer CDR library.
• Used MFC and proprietary UI code libraries to develop Windows user interfaces. Developed and programmed a real-time, interactive, graphical bitmap class and device-monitoring scheme that was subsequently adopted for system-wide use in development, diagnostics, and maintenance, and integrated into the production UI.
• Collaborated in system architecture design and documentation, utilized Rational Rose and MS Visio for UML, sequence, collaboration, and state diagramming. Authored and co-authored numerous specification and test procedure documents.
• Prepared design reviews with hardware engineering teams, and performed hardware and firmware verification and testing.

EDUCATION/VOCATIONAL TRAINING

• Project Management Training Program - cert by SD Chapter of the Project Management Institute (August 2019)
• Microsoft SharePoint online training (2011, 2012, 2013)
• Work Leader Training Laboratory, Rady School of Management ILT (July 2012)
• Change Management, Rady School of Management ILT (October 2011)
• SANS Defending Web Applications Essentials Security Training (July 2011)
• Epic Chronicles Programmer I Training (InterSystems Cache transactional database ObjectScript M coding) , Epic Systems (May 2011)
• Epic MyChart Patient Web Portal Training and Certification, Epic Systems (August 2009)
• UCSD SysAdmin Training Series: Network Management II, UCSD (November 2008)
• CNDX Computer and Network Security Defense Training, UCSD/SAIC (August 2008)
• UCSD SysAdmin Training Series: Group Policy, UCSD (July 2008)
• UCSD SysAdmin Training Series: Network Management I, UCSD (June 2008)
• Epic Clarity Clinical Healthcare Reporting Training & Certification, Epic Systems (May 2007)
• Computer Science coursework, UCSD (2001)
• Math & Computer Science coursework, SDSU (1998 - 2001)
• Computer Science coursework, Creighton University (1996 - 1997)

REFERENCES & RECOGNITION

References and Letters of Recommendation available upon request. Here are some of the nice things my colleagues have had to say about me over the years: