Brian Pederson Email & Phone Number

San Francisco, Ca, Us

San Francisco, Ca, Us

Austin, Texas, Us

My recent assignments have been with Oracle’s Health Sciences Global Business Unit which develops software supporting healthcare and life sciences enterprises (e.g. hospital, pharmaceutical, medical insurance companies, etc.). Some of my major assignments include:• 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. An associated component is a large star schema data model providing data marts optimized for analytics and reporting. 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.• Performed an urgent consulting engagement at a very large customer deployment of the previously mentioned healthcare hub product. The customer was not achieving targeted SLAs and I was able to boost performance 30% with minimal need to change existing product code base and no need to modify the customer/consulting code. • 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.

Austin, Texas, Us

Transferred to Oracle Application Development. Several projects include:• 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.• 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.

Austin, Texas, Us

At Oracle Consulting, I participated in a wide variety of assignments a sample of which include:• An internal assignment building Oracle’s first "modern architecture" Java middle tier application - a 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 temporarily 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.

Led a project to build a system to manage pricing information for a consortium of seven trans Pacific shipping lines. My responsibilities included:• Led all project phases including analysis, design, and build; managed 15 staff at two locations.• Performed extensive user liaison (seven fractious partners) including JAD sessions and training.• Handled management tasks such as software, hardware and staff evaluation and hiring.• Defined coding and ‘look and feel’ standards. • Designed and implemented common code libraries for use in both the client and database tiers.

Designed and supervised the development of a custom software suite for a Japanese container shipping line. This project employed 60 technical staff (of which I directed 20) over three years and included four major operational subsystems. My responsibilities included:• Building the Documentation/Bill of Lading subsystem.• Providing architectural support for the entire project with respect to application design, database design (data model and stored procedures), and user interface design.• Assisted in other project scope tasks such as customer JAD sessions, programmer and user training, project scheduling, and subcontractor/consultant coordination.