Alexander Kovalev Email & Phone Number

Durham, NC

Raleigh-Durham, North Carolina Area

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.

Durham, NC

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.

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.

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.

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.

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.

M.B.A., Operations Management, Information Systems

M.A., B.A., East Asian Studies