David Dumas Email & Phone Number

Denver, Co, Us

Newton, Ma, Us

Snowflake and dbt tech lead with expert SQL skills, building Snowflake applications for large snowflake enterprise clients. Proficient in end to end design and development using dbt, Snowflake, and FiveTran. Examples include full NetSuite historical reporting in snowflake, exceeding NetSuite capabilities alone. I am a leader in building innovative, and scalable models in dbt, including full scale dbt semantic models across the enterprise.

Seattle, Wa, Us

Sr. Data Engineer. Responsible for building Snowflake data pipelines supporting data warehouse and reporting, using snowflake built-in features, Azure Data Factory, and dbt. Also used PowerBI to build analytic reports, supporting the business.

Consultant. Data Warehouse and BI

King Of Prussia, Pa, Us

QlikView BI Solutions Architect Responsible for the Design and development of QlikView analytic applications for enterprise clients. Enabled results, from strategy to delivery, to support rapid development and delivery for the business sponsor. Defined all KPIs used in the applications. Extracted data from both relational and dimensional models into QlikView data models. Created best practice Analytic Dashboards and reports

Designed and developed Talend ETL jobs moving and transforming data for the airline and healthcare industries.

London, England, Gb

Designed and developed a multi-tenant QlikView application complete with dashboards and load scripts for a global logistics firm. Provided visualization and exploration of weight, cost, and route data across worldwide shipping carriers.

Designed and developed an 0.B.I.E.E. based financial reporting solution and dashboard enabling financial control of all government projects. Project based on Oracle financial data and still used daily by hundreds of users. Built and maintained repository metadata layer, security, numerous frontend dashboards, agents, and reports, enabling rich ad-hoc reporting for financial analysts and hundreds of project managers.analyses, enabling rich ad-hoc reporting for financial analysts and hundreds of project managers.

Morristown, New Jersey, Us

Created Oracle 0.B.I.E.E. based Data Warehouse and Business Intelligence solutions marketed to thousands of customers, and thus creating a new revenue stream. Designed and developed ETL framework, used by multiple teams. Created PL/SQL package to dynamically create parameterized Oracle scheduler ETL jobs. Modeled the data warehouse and dimensional schemas in PowerDesigner. Designed and developed numerous ETL jobs in Talend ETL. Developed the 0.B.I.E.E. metadata layer, dashboards and reports, enabling rich ad-hoc reporting. Skills and tools used: SQL, PL/SQL (numerous packages), 0.B.I.E.E., Talend, and PowerDesigner.