County of Marin

As a Senior Systems Support Analyst, I implemented successful data warehousing projects to bring diverse transactions from differing systems including hospitals, clinics, and service providers into a central repository for client tracking, service analysis, and management reporting. I used dimensional modeling to design and develop the data warehouse to provide a star schema. I designed and developed SQL Server Data Transformation Service (DTS) packages, with ActiveX scripting, stored procedures, custom functions, and triggers to extract, transform, and load (ETL) data from differing source systems. I designed, developed, and distributed On Line Analytical Processing (OLAP) reporting cubes to meet users reporting requirements.