Olga Smith Email & Phone Number

San Rafael, Ca, Us

Responsible for database architecture, integration and database development, data quality and data management for Global Commercial Data Warehouse. Lead an implementation of a single truth Data Warehouse consolidating over 40+ manually generated Tableau reports into an online, self-service, interactive PowerBI dashboards. Lead a team of highly effective BI professionals through 4 product launches globally, including working with Sales, Patient Services and Marketing teams, Senior Leadership, and 3rd party vendors on integrating multiple data sources and changing multiple system configuration to support all launch activities. Manage multiple data providers, ensuring alignment on data standards and formats. Providing a data platform for all Commercial analytics, working cross-functionally with IM and other teams within Commercial.

San Rafael, Ca, Us

Novato, California, Us

Supported growing Medical Affairs and Commercial Marketing Operations teams. Architected and implemented Veeva CRM, Veeva PromoMats, marketing automation tool, Grants Management System. Worked with business on many patient identification projects to fill clinical trials and for pre-commercial activities. Created multiple reports and dashboards. Managed third-party support vendor; increased adoption through training and support

San Rafael, Ca, Us

Supported Global Commercial team by developing Salesforce.com platform to fit growing business needs. Developed Commercial Data Warehouse solution with integrations with Oracle Financial, SFDC, and Patient management hub. Implemented Tableau Server as a departmental information delivery platform. Created numerous reports and dashboards, KPIs and metrics including around patient adherence; regularly presented business insights to Global leadership. Significantly increased user adoption through training and daily support.

Fulton, Ca, Us

Developed and implemented company’s first enterprise Business Intelligence platform using Business Objects. Architected data marts, developed ETL to integrate multiple data sources, created reports and dashboards, maintained data quality processes

San Francisco, Ca, Us

Successfully designed and implemented a company-wide Business Intelligence initiative. Responsibilities ranged from requirements gathering to database schema and ETL design, metadata development, data integrity support and error handling. Project included vendor selection and implementation of Cognos ReportNet reporting tool as a way to standardize enterprise reporting. This phase included mapping of Onyx CRM as a source data and conversion of multiple legacy reports from that system. In addition, effectively managed and implemented multiple reporting projects based on complex user requirements including product pricing, marketing analysis, and sales territory allocation.

Petaluma, California, Us

Financial/Insurance Company. As a part of a team designed, implemented, and enhanced a full-featured data warehouse, including star-schema data marts, multidimensional cubes, and data transformations. Used MS SQL Server, Business Objects and Crystal Reports.