SUMMARY

• Experienced Software Engineer with a demonstrated history of working in the software development and healthcare industries.
• Skilled in Oracle Database, Enterprise Software, Agile Methodologies, Data Model design and Database tuning.
• Seeking a position leveraging my experience in database technology applied to large scale data warehousing applications.

TECHNICAL SKILLS

• SQL
• PL/SQL
• Python
• Java Oracle Database
• Oracle Business Intelligence EE
• Oracle Data Integrator
• JDeveloper
• Oracle Enterprise Manager
• SVN
• CVS
• Git
• Jira
• SQL*Navigator
• Oracle SQL Developer Data Modeler
• ERWin
• Windows
• Linux
• MS Office Suite (Word
• Excel
• Visio

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Senior Principal Applications Engineer

Responsibilities:

• Performed multiple roles during the design and implementation of an Enterprise Data Warehouse product which provides a ‘single source of truth’ data repository for DW/BI information within the healthcare enterprise.
• It includes a large 3NF data model with multiple healthcare subject areas including clinical, ADT, billing, claims as well as generic corporate subject areas such as finance, HR, supply chain, fixed assets, etc. This component is optimized for ingestion of operational data from multiple disparate source systems commonly encountered in the healthcare industry. An associated component is a large star schema data model providing data marts and optimized for analytics and reporting.
• The ETL infrastructure necessary to load the various data models comprise the remaining components of the product.

  Throughout this project I performed multiple functions that span from conceptual modeling, logical modeling through to physical data model design. I worked with the strategists and lead customers via JAD sessions to build the conceptual models and then worked with the functional analysts to build the logical data models.

• I worked as a lead physical data modeler for the 3NF component and was the sole physical data modeler for the star schema component.
• Participated in the development of a DW/BI product designed to support hospital surgical departments. The product is built on a classic star schema which provides business intelligence functionality in the domains of operating room efficiency, staff performance, financial performance, etc. The technology used in this project was Oracle DB and Oracle Business Intelligence EE. In addition, PL/SQL and ODI (Oracle Data Integrator) were used to perform data generation and ETL tasks respectively. I participated in a small ‘agile’ team that built a prototype and when that was well received, I participated in the team that built the product that was based on the prototype.
• Performed a large - scale performance benchmark of Oracle’s healthcare hub product. This entailed coordinating the acquisition and configuration of nine large servers as well as a large disk array used to conduct simulations of a deployment serving 8 million patients.
• I wrote various utilities to efficiently generate 8TB of realistic test data and then used LoadRunner and homegrown utilities to record and document the performance characteristics of the product. During the project I performed a great deal of tuning activity to research performance bottlenecks and eliminate them as they were identified. I applied techniques such as database partitioning and index tuning to significantly improve performance of the product in the simulated deployment. At the conclusion of the project I wrote the white paper that documented the performance findings, recommendations and lessons learned.

Confidential, Redwood Shores, CA

Senior Software Engineer

Responsibilities:

• Worked on one of Oracle’s first web services-based products designed to serve as a platform (i.e. APIs and services) on which healthcare applications and EDI data hubs are constructed. It utilized a full range of Java (J2EE, EJB, ADF BC) and XML (DOM, SAX) related technologies.

Confidential, San Diego, CA

Senior Consultant

Responsibilities:

• Worked on one of Oracle’s first Java middle tier applications - a CRM sales management product which utilized a Java based tech stack (JSP, Tomcat) instead of the ‘traditional’ Oracle client-server tech stack (i.e. Oracle Forms, database stored procedures). For this project I was transferred from Oracle Consulting to Oracle Applications development to provide Java support (at the time few Oracle developers were proficient in Java). I built several of the application modules using Java, JSP, JDBC, JavaScript, and HTML. This project predated the availability of Java frameworks providing MVC support (e.g. JSF, Hibernate, etc.) so I built my own framework implementing a JSP Model 2 architecture based on patterns borrowed from Oracle Forms such as pages, blocks, fields, row sets, etc. It utilized Java reflection and introspection APIs to allow generic framework classes to dynamically interpret classes tailored to each page or block of the user interface JSP pages.
• Designed and developed a web-based application used by six state run hospitals in New Jersey. The system performs functions including recording patient information on admissions, discharges, census, diagnosis, legal/criminal status, insurance, contacts, etc. During the project, I performed multiple roles including business analyst, system architect (designed data model, business logic, and user interface), team leader and programmer.