David Waite Email & Phone Number

Hooksett, New Hampshire, Us

Currently leading the development of Merchant’s “Total Connect” analytics application, using Azure, Snowflake, and PowerBI:● The product uses telemetry data streaming off fleet vehicles, integrates these data withinternal system data to create an Azure data lake and then Snowflake analytic data warehouse that supports client-facing dashboard visualizations so customer fleet managers get a comprehensive andcurrent view of the condition of their fleet and drivers● Architect the data model● Lead a mix of on and off shore analysts, data engineers, and PowerBI developers to construct and support the product● Pipelines are a mix of Azure Data Factory, Snowflake stored procedures, and Matillion integration jobs● Liaise between the database build team and business team.Led the “Data Modernization” portion of the major application migration project whereMerchants is upgrading their lease tracking system (which is the core of the business):● I designed the all-cloud data architecture, using a fully-Azure stack, to migrate thelegacy SQL Servers, SSIS and T-SQL sprocs to an event-driven, stream from SQLServers in Azure VMs to Snowflake, using Azure Event Hub, ADF, Logic Apps, AzureFunctions, and Stream Analytics processes● Led a large, mostly offshore, team of analysts, data modelers, and data engineers● Designed the core data model for the warehouse.

Philadelphia, Pennsylvania, Us

● Principal architect and team lead engineering a new data platform to migrate one of the company's divisions from a 15-year-old SAS/Oracle/SQL 2008 core to a fully Microsoft platform using SSIS and SQL Server 2017. Extensive work with the business team translating requirements and driving the design and development.● Serve as the division’s internal consultant, working to innovate new products and ways of making the business run more profitably. I routinely engage with the business to help refine their ideas, learn and apply technology to the idea, and lead the engineering to deliver a tangible product● Managed the database administration team, supporting Oracle 11g, SQL Server 2008 through 2017, MySQL, and MongoDB systems● SSRS report development and migration from older Reporting Services versions to new, on prem, Power BI Reporting Services, working directly with business users● Advisor to senior Rite Aid management on replatforming it’s aging pharmacy system, NexGen, from it’s legacy mainframe/DB2 architecture to a new, cloud-based architecture. Hands-on investigation of MS Azure, primarily in the data area: data lakes, SQL database, and SQL DW/Synapse Analytics.

Bedford, Nh, Us

Solutions Architect Lead (2012-2014)Senior Manager/Technical Lead, Data Integration (2008-2014)Manager, Data Warehouse Development (2005-2008)Senior Business Analyst (2005)Business Analyst (2004)● Principal architect of Rite Aid’s “Rite Aid Health Alliance” program that integrates patient healthdata from many diverse Electronic Health and Medical Record (EHR/EMR) systems into a single clinical data repository. Flat file, web service, as well as HL7 incoming feeds. This repository supplies data to an enterprise application used by several hundred users to deliver health coaching to Rite Aid’s customers in the pharmacy area of their stores. Reporting and business intelligence reports and dashboards use both CDR and health coaching system data. Hands on database design/modelling● Designed, developed, and drove the development of the enterprise operational data store (ODS) and enterprise data warehouse (EDW) that serves as the data integration hub for more than 50 million persons in a health care disease management environment. Hands on database design, development, data integration/ETL design and development, and project management● Built and led a team of up to 25 development, business analyst, project management, and quality assurance resources● Managed hundreds of system integration projects (providing status updates, leading daily stand-up meetings, as well as project plan creation and maintenance)● Played a key driving role in overall solution and systems architecture including data exchange with clients and vendors, internal and external application data design and exchange, as well as with overall enterprise architecture direction and road map design● Developed core data models, developed DDL, and constructed many custom PL/SQL programs that integrated data into the data warehouse. Includes many slowly changing dimensions, fact tables, and conformed dimension tables.