Designed and deployed Marketing Data Warehouse to support Duke Health marketing initiatives in the areas of new patient acquisition and existing patient experience and retention.Implemented Salesforce CRM back-end data management platform, allowing for the complete integration of consumer data with healthcare propensity models and over 50 decision making attributes to generate marketing offers.Designed and deployed critical new patient acquisition metrics, including click-to-patient conversion rates and cycles, return-on-investment analysis, and economic life-cycle computation and churn forecast.

Increased appointment completion rate inside MyChart patient portal by over 45% using database log analysis. This allowed Call Hub to provide better service to new patients and patients with complex requirements.Improved accuracy and reduced cost of campaign targeting of patients for MyChart patient portal sign up using Bayesian Networks model. The model identified top tier patients to respond to marketing offers for MyChart.Created marketing campaigns ROI tracking system using data blending procedures. The ROI system complete with marketing attribution model allows management to keep and optimize profitable campaigns and terminate unprofitable campaigns.Identified treatment locations with the highest patient churn to improve customer retention.Classified profitability of all major Duke Marketing publications using Victor Lo’s True Lift incremental response model to increase marketing investment into profitable publications and retire losing ones.Provided wide variety of reporting, analysis, and target list generation to support marketing operations.Lead marketing analytics team specializing in market research, data design, and digital marketing.

Data Warehouse design and development using Microsoft BI stack. Database design, SSIS package development, dimensional modeling, OLAP development, and Data Mining modeling.

Data Mining Modeling and Data Analysis

Designed enterprise-scale dimensional database model for military healthcare data warehouse on Oracle 11g platform using ERwin Data Modeler.Performed in-depth data profiling analysis using SQL Server 2005 tools and Business Intelligence Development Studio Helper tools to correctly extract, transform, load, and display complex data structures from 53,000 cell towers across the country into data warehouse dimensional model.Designed ETL computational logic for monitoring data quality including handling of missing, off-scale, invalid, duplicated, and overflowing data anomalies.Designed and implemented in SQL Server 2005 Analysis Services using MDX over 5,000 Radio Frequency Engineering operational measures designed to assist over 600 network engineers with optimizing Sprint’s wireless network performance for Lucent, Nortel, and Motorola equipment.Created over 100 operational reports designed for network capacity planning, cell site performance optimization, and forecasting of utilization of critical network voice and data elements using Panorama NovaView.

Design, Testing, and Management of Advanced Supply Chain Management Software FunctionalityProduced in-depth insights into customer product usage behavior by extracting, analyzing and modeling customer production data on MS SQL Server 2000, resulting in better customer account management and more targeted product design.Designed new product functionality and provided technical specifications for implementation, resulting in new customer acquisition and existing customer retention with direct revenue impact of over $500K.

Demand and Supply Planning for International Consumer Goods CompanyDesigned inventory, logistics, and product management data marts with data extracts from AS/400, SQL Server 2005, and user-defined Excel and flat files.Streamlined global procurement and achieved over $12 million reduction in product inventory while maintaining planned customer service levels.Saved over $600K in transportation cost by performing extensive data analysis of international supply chain and modifying related cost allocation to over 5,000 SKUs.

Supply Chain Management Division - Senior Data Analyst/Forecaster (8/2001-5/2004)Demand Planning and Advanced Data Analysis for a Global Telecommunications CompanyDesigned data profiling rules for procurement and inventory production data using Informatica for SCM Data Warehouse loading on Oracle 9g DBMS platform.Generated and analyzed forecast accuracy of over $3 billion of telecommunications equipment, including over $250 million in replenishment SKUs in 27 public warehouses.Integrated Business Solution Center - Project Analyst III (5/2000-8/2001)ERP System Integration Planning and Implementation for Global Procurement and InventoryImproved Peoplesoft maintenance and upgrade process scheduling.Designed and implemented mixed-integer mathematical optimization model using MPL/CPLEX to optimize scheduling of IT projects and enhancement requests.Received Sprint enterprise wide IT award for innovative application development of SPC Log application.