Experience

Western Health Advantage
• United States
• Hospitals and Health Care
• 100 - 200 Employee
• Business Intelligence Manager

  • Jul 2006 - Present

Sutter Health
• United States
• Hospitals and Health Care
• 1 - 100 Employee
• Senior Data Warehouse Developer

  • Feb 2003 - Jun 2006


Sutter Connect

• United States
• Primary and Secondary Education

• Senior Developer

  • Oct 2001 - Jan 2003

  Sacramento, California Area  Responsible for implementing and maintaining IDX Analyzer operational data store. Currently working with Sutter Health Data Management team to build the Sutter Health Enterprise warehouse (SHEW). Responsible for extracting, transforming and loading data from the IDX Analyzer operational data store into the SHEW (SQL Server 2000 based) using Informatica. The data currently being loaded consists mainly of outpatient fee for service invoices and managed care claims. In the future the SHEW… Show more  Responsible for implementing and maintaining IDX Analyzer operational data store. Currently working with Sutter Health Data Management team to build the Sutter Health Enterprise warehouse (SHEW). Responsible for extracting, transforming and loading data from the IDX Analyzer operational data store into the SHEW (SQL Server 2000 based) using Informatica. The data currently being loaded consists mainly of outpatient fee for service invoices and managed care claims. In the future the SHEW will contain all types of Healthcare data. Also, created and maintains the BAR (billing and accounts receivable) data mart using Cognos Impromtu, Upfront and PowerPlay products. The cubes are currently being deployed through the web using Cognos Upfront as the portal. Show less



UC Davis Medical Center

• United States
• Medical Practices

• Data Warehouse Developer

  • Jul 2001 - Oct 2001

  Sacramento, California Area  Responsible for all maintenance and design changes to UCD’s data warehouse. The UCD data warehouse is a subset of the warehouse that was developed at Western Health Advantage. Responsible for creating and maintaining CRMS data marts. Currently developing a patient registry system to track diabetic patients. The system will be used for grant purposes. Assisting the utilization department in the creation of web based provider profiling. Began development on patient face sheets to assist… Show more  Responsible for all maintenance and design changes to UCD’s data warehouse. The UCD data warehouse is a subset of the warehouse that was developed at Western Health Advantage. Responsible for creating and maintaining CRMS data marts. Currently developing a patient registry system to track diabetic patients. The system will be used for grant purposes. Assisting the utilization department in the creation of web based provider profiling. Began development on patient face sheets to assist providers Show less