Resume

December 2002 – Present
State Compensation Insurance Fund
1275 Market Street, San Francisco, CA

I was brought in to help State Fund establish a Business Intelligence initiative and provide employees an adhoc reporting environment. Their existing project had gotten off to a bad start and quickly ground to a halt as the employees struggled with the Business Objects tools and the lack of solid infrastructure.

I was responsible for designing and deploying the Business Intelligence infrastructure for a deployment that grew from 40 reporting end users to over 400 users. The purpose of this deployment was to replace legacy-reporting systems with an on-demand query and analysis tool that can be easily deployed to any end-user in the enterprise. The infrastructure was built around the Business Objects reporting tool software suite.

This deployment included designing the security structure to control users access, server configuration for the WEB INTELLIGENCE server, writing the standards and procedures for creating universes and documents. A key activity in this deployment was working with the network security team to define a solution for deploying the BUSINESS OBJECTS software from the WEBI server to locked user desktops under Windows 2000 Professional operating system and eventually to Windows XP Professional desktops.

I am currently in the process of performing the upgrade of the installation to the Business Objects XI version R2. The migration progresses as planned and should be completed as planned in December 2006. This upgrade will also lay the groundwork for future expansion into other Business Objects tools like the Dashboard Manager.

April 2002 – Feb 2003
McKesson, Inc.
1 Post Street, San Francisco, CA

Key member of the project team tasked with designing and then building the Business Objects infrastructure for a deployment of 2,500 end users. This assignment included the design and creation of the security environment, document distribution domains, writing Business Objects standards for universe and document creation, and actually building and deploying universes within the structure.

I was brought in to assist the project team meet a critical deadline in a universe redesign effort. I was responsible for taking fifty two critical management documents with multiple reports and graphs and mapping these into the redesigned data mart. The primary scope of the redesign was to implement aggregate awareness within the new universe that would support the exiting data providers in the management documents and cut overall query times.

The key requirement with this effort was to make certain that all existing corporate documents and any user developed documents would continue to work properly within the new universe structure. All existing objects had to have an equivalent object in the new universe. The effort included mapping an existing database structure to a revised data warehouse structure.

Originally the effort was scheduled to take 6 months. I completed the mapping within one month. This saved Pfizer considerable expense

Environment: Business Objects 5.1.3, Win NT Servers, Win NT desktop, Win 98 Laptops, Sun Solaris data servers, Oracle 8.1, MS SQL Server.

Working with the Dialog MIS department I was responsible for the worldwide deployment of Business Objects software in support of the Sales Analysis and reporting functions.

My responsibilities included the installation and support of all Business Objects software including desktop products, enterprise server products and Broadcast Agent server.

I designed and implemented a comprehensive security strategy to control product features access, document and data access by user. The strategy implemented the corporate policy for data access by functional area and job responsibility.

I designed and developed universes to access data within the corporate data warehouse and data maintained in disparate databases. Universes designed included multiple contexts with Aggregate Awareness to improve query response time and security restrictions to maintain access requirements.

I was responsible for training the trainers. I trained MIS personnel in all aspects of Business Objects development and administration. I worked with the training staff to produce training materials for end users training. I also delivered the training class to the end users in the Mountain View office.

Developed VBA scripts to work in concert with the Broadcast Agent server to create and distribute reports via email to users who did not have access to the Business Objects. This provided a cost effective method for report distribution to a constantly changing sales force.

Dialog’s user base is deployed in multiple sales office locations throughout the continental United States, Canada, and Europe. Offices in Europe and South America were also served by the Business Objects installation.

Environment: Business Objects 5.1.3, Win NT Servers, Win NT desktop, Win 98 Laptops, Sun Solaris data servers, Oracle 8.1, MS SQL Server. User base 60+ in Mountain View, CA, 100+ in Cary, NC, and 20+ in London, England.

Working with the Executive Information Systems (EIS) group I was responsible for the department’s worldwide Business Objects deployment. Activities included Universe creation and maintenance, security administration, and end-user support. The EIS group was chartered with building Business Objects environments and web-based reports for Cisco Executive staff.

Modified and maintained the two existing Universes. I also developed ten new universes against Cisco's Oracle data warehouse. The universes segregated functional areas by overlay type to deliver reporting for multiple product areas and multiple compensation configurations. Universes included many complex table structures with multiple contexts and implementations of Aggregate Awareness.

I was responsible for the upgrade from Business Objects 4.1.4 to version 5.0.2 for the entire EIS user community. The EIS users were the first users to be totally converted to version 5.0 at Cisco.

I built a series of reports and VBA scripts to integrate Business Objects with Cisco’s in-house developed access control system. The scripts refreshed reports, created web pages, examined the resultant HTML files to rename the output pages to comply with the existing security structure and moved the results to various web servers. This was a significant effort as it reduced the time to deliver new reporting systems from an average of 3 months to 3 weeks.

Environment: Business Objects 5.1.3, Win NT Servers, Win 95 Laptops, Sun Solaris data servers, Oracle 7.3, 8.0. User base of +300 users located in Cisco offices worldwide.

April 1997 - March 1999
Sun Microsystems, Inc
Enterprise Services Division,
Milpitas, CA.

I was responsible for the design, implementation and support of a multifunctional DSS reporting system using Business Objects, Oracle 7 RDBMS on a Unix platform. I delivered four separate universes supporting several different functional business areas.

System delivered included a REVENUE universe for sales analysis reporting, an AGING universe to support Accounts Receivable, a CUSTSVC universe to provide a multi-system search facility for Customer Service call desk, and a CONTRACTS universe for customer services reporting. Each universe was delivered with a complement of queries and reports that provided flexible reporting formats to meet end-users requirements.

The AGINGS universe was built directly on top of Oracle Financials database to provide the Collections department the tools to attack outstanding receivables in excess of $160M. Create a number of summary queries and reports that enabled the collectors to provide customers immediate responses to their account inquiries and expedite their payments.

Environment: Business Objects 3.1 for Unix, Sun Solaris servers and desktop.

I was responsible for the design, implementation and support of a DSS reporting system using Business Objects, Sybase RDBMS, on a Unix platform. I delivered a highly flexible DSS system to provide sales analysis reporting for the Billings, Booking and Backlog requirements in an MFG/Pro environment. Combined Business Objects with other data tools to provide innovative new reporting capabilities to end-users with highly specialized reporting requirements.

I was responsible for requirements definition, database design, data conversion, universes construction, repositories, queries, and formatting of all reports. I was also responsible for deploying the system to the users workstations, user training and on going support. This project received corporate wide recognition for being delivered on time and under budget. Final project included converting the Sybase backend to Oracle 7.x data server.