Doug Stevens

Manage Data Service team to support business in the areas of Data Warehousing and business intelligence. Focusing around the Microsoft stack (SSIS, SSRS, SSAS and SQL Server 2017) as well as Tableau. Create and support VLDB warehouses and datamarts. Leverage Always on High Availability Groups and manage multiple and stretched domain security.

Created custom CRM and industrial scheduling and planning systems for manufacturing assembly. Created supply chain forecasting features to support Kanban workflow. Generate data warehousing features to support corporate e-commerce rebuild.

Managed enterprise-wide data services, complex server configurations, capitalized application implementation and migration projects, data security compliance following SOX, HIPAA, PHI and NCQA guidelines. Designed and developed custom data warehouse design and architecture, self-service BI solutions and SharePoint portal structures. Mastery in application implementation and migration on a capitalized level. Expertise in ETL, custom data warehousing, data repositories and multiple business intelligence solutions. Hands-on management facilitating onsite replication, cloud storage and cloud SaaS applications, disaster recovery, active directory security groups and VM Ware server configurations. Expertise in SQL Server query language focused on highest levels of performance and presentation of high-volume data. Working with the Microsoft stack including SSMS, SSRS, SSIS and SSAS. Working with BI solutions including PowerPivot, PowerBI, cube technologies, SharePoint and Reporting Services.

DBA Architecture, Data Modeling, Ground-Up BI systems design, Micro Strategy development & deployment, Project Management, ETL development and design, Big Data reporting designs. Build Retail, Pharmaceutical and PBM insurance Business Intelligence systems through reverse engineering of legacy systems into Big Data data warehouses, built BI dashboards and high volume ETL systems. Generate Forecasting and Trending models for 100+ Rx Pharmacy and 100+ Retail point of sale locations. Design, Model, Build and Deploy multiple BI solution data warehouses to support BI pertaining to new business development and historical trending data. Reverse engineer multiple legacy systems into current technology data warehousing solution closing gaps of migrating multiple data storage technologies into singular BI data warehousing.

Build data warehousing solutions to handle high volume ETL processing for large customer based energy company. Provide technical expertise in all aspects of data modeling and data architecture. Build complete B2B EDI systems solutions through ground-up development of data and operations solutions for multidimensional trading partner solutions. Expert in system migration & integration, tying multiple platformed based solutions into seamless single point data warehouse and operations. Generate high availability reporting solutions for sales, marketing, accounting and business development. Closed million dollar accounting gaps through system design and analytical BI reporting.

Design, build and maintain data warehouse, CRM, ERP and Billing systems for multibillion dollar deregulated energy company. Design, build, deploy and maintain corporate EDI solutions.

Created corporate solution for EDI / X12 ETL solutions. Design & Build data warehouse solutions to support EDI and back-office CRM solutions. Sat on and participated with GISB X12 standards design & technical committee for NY, New England and PJM energy markets.