Representative Project Experience
Built dashboards and a data mart that integrated public data sets, purchased data and customer data to predict jet fuel purchasing patterns nation-wide in near real-time.
Planned an enterprise deployment of Microsoft Fabric using Infrastructure As Code (IAC) techniques.
Created a predictive model in R that promised a 9% increase in sales for a multi-location retailer by optimizing staffing.
Recruited, hired and managed dozens of analytics professionals. Worked with clients to develop staffing plans and recruiting efforts for analytics.
Led the creation of a crawler to extract millions of prices from competitors web sites and match their products to those of our client to drive quick reaction to price changes.
Facilitated Business Event Analysis and Modeling (BEAM) design sessions that allowed a large regional health care practice to assess the consistency of their prenatal care delivery.
Built time-series based exploratory models in R to assess retail promotions effectiveness.
Created a sales data mart to analyze channel performance for a major financial investment products firm.
Applied Monte Carlo techniques to multi-variate optimization problems in healthcare delivery.
Implemented enterprise Business Intelligence (BI) applications with over twenty clients in finance, food, forest products,catalog retail, insurance and trucking companies.
Designed and led the development of an application to calculate customer profitability across multiple divisions and product lines for a regional bank.
Developed communication plans to help organizations encourage the use and understanding of data.
Technology Experience
Relational Databases - Over thirty years experience designing and creating relational databases. Most of that experience is with Azure SQL and Microsoft SQL Server with additional project experience in Oracle, DB2 and PostgreSQL.
Structured Query Language (SQL) - Extensive experience in Transact-SQL and ANSI SQL along with some PL-SQL experience. Both data definition and querying. Teaching of advanced SQL to analysts. The last several years have been primarily in Azure SQL Database.
Source control - Many years experience with Git and the automation of data warehouses, ETL code and other artifacts using automated builds.
Extraction, Transformation and Loading (ETL) - Over twenty years experience in loading and transforming data. Many projects with a wide range of data sources from REST APIs, Comma Separated Value (CSV) flat files, JSON, website scraping, relational databases, COBOL file stores, ISAM, etc. We've integrated data from Infor, Dynamics, Navision, Epicor and many other business apps.
Programming languages - over twenty years of heavy software development experience. Working with C#, Python, Javascript/Typescript and Powershell. Over eight years experience in statistical analysis and forecasting time series with R and RStudio.
Cloud services - Working with the Azure cloud services since 2014. Services used include: Azure SQL Database, virtual machines, Azure Functions (serverless), Webjobs, storage accounts, Key Vault, Azure Automation, App services and API Management. Experience in automated deployments and infrastructure as code using Bicep, Terraform, Powershell and ARM templates.
Enterprise reporting - Many years with Power BI. Some of the early years were painful! Worked with TMDL, Power BI REST API and XMLA endpoint for automation and observability. Additional experience with Cognos, Business Objects, Tableau and Crystal.
Frameworks - experience in building web applications with Bootstrap and Angular. Microsoft Fabric deployments using fabric-cicd.
Test Automation - recent heavy experience with Selenium as well as Microsoft Visual Studio Test and SQL Server Data Tools (SSDT) unit testing. We've also built custom frameworks for regression testing of data and ongoing data quality assessment.
Continuous Integration (CI) - we primarily use the CI features of Azure DevOps to automate builds, testing and releases to multiple environments such as Dev, Test and Production.
Dimensional Modeling - using the Kimball dimensional modeling techniques including slowly changing dimensions, snapshots and other techniques to make data more accessible for reporting and analysis.