David Dumas

David Dumas

Summary

BI Solutions and Data Warehouse Architect 15 years of enterprise solutions using Oracle, SQL Server, and leading BI Tools

2008 Microsoft Enterprise Insight Award for Business Intelligence Implementation was awarded for a recent implementation at a client.

Proven ability to partner with the business and translate complex business problems into effective technical solutions.

Honesty, integrity, work ethic, encouraging and mentoring others are as important to me as my technical strenghts.

Development Strengths:

·Oracle and SQL Server Database and Data Warehouse Architect and Developer with expert skills in Database Design, ANSI SQL, PL/SQL, and T-SQL.

·ETL Design and Development using Informatica and SSIS.Experienced in developing sophisticated workflow, data mapping, and transformation pipelines from diverse sources.

·Multi-Dimensional OLAP Cube Design and Development using SSAS.Experienced in cube partitioning, Dimension processing, and support for incremental cube update processing.

·Operational and Analytic Reporting Design and Development using SSRS, Crystal Reports, and Tableau.

·Data Modeling using Enterprise tools such as PowerDesigner and Oracle Designer.

·Data Warehouse Architecture, Design and Development.Experienced in building both Inmon (CIF) and Kimball DW architectures utilizing 3NF, and star/snowflake schema dimensional models.

·Building sophisticated Executive Dashboards and Analytics in Qlikview and Tableau.

·15 years experience in developing Commercial OLTP and OLAP Solutions, sold to Fortune Companies, such as Rexall Vitamins, Tupperware, and Retek.

Solutions built and successfully deployed include:

·A data warehouse and BI solution complete with Executive Dashboards and Analytics for a retail company with over 300 stores.This solution enabled business executives to spot key sales, revenue, and cost trends that were not visible in the operational store data.

·A data warehouse and BI solution complete with Executive Dashboards and Analytics for a major fast food franchisor.This system was used to audit the revenue and compliance of franchisees. This solution could potentially help save the company millions of dollars.

·A pharmaceutical data warehouse for a major hospital authority.The warehouse was used to show analytics and trends for inpatient and outpatient pharmacy records, and to help identity improvements in prescribing generic drugs over non generic drugs.

·The backend database architecture for a major commercially sold document management system for the trucking industry.This solution enabled the business to provide online document management to their major customers.

·A CRM Application enabling campaign management, call center order management and customer care. This solution was used by customers with the call centers, such as Nikon.

·A commercially sold and supported order and sales commission management application utilized by companies such as Tupperware, Rexall, UniCity, and Retek.Tupperware alone used this system to calculate commissions and compensate over 25,000 representatives each month.

·A commercially sold Hotel Property Management System, in production at hundreds of hotels.This solution automated reservations, front and back office for the hotels, significantly increasing productivity and reducing overall costs.

Work History

Work History
Jun 2009 - Present

Sr. Software Engineer, R&D

Building a Data Warehouse Solution, complete with database design, ETL, reporting, and analytics.

Feb 2009 - Jun 2009

Data Warehouse Architect

Designed ETL architecture for the Data Warehouse.  Devleoped numerous ETL packages in SSIS, supportingseveral federated Data Marts, from diverse sources, including JD Edwards.  Assisting with BusinessObjects Universe Design.Worked with the new spatial geographic data types in SQL Server 2008 to support analytics and mapping on forecasting data.  Developed an Analytics / Dashboard solution using QlikView, used to support demand forecasting.

Oct 2008 - Feb 2009

Data Warehouse Architect

Tango Group

Developed a data warehouse and BI solution complete with Executive Dashboards and Analytics for a retail company with over 300 stores. Developed the operational data store, stored procedures, ETL packages, operational reports, and Executive Dashboards and Analytics.This solution enabled business executives to spot key sales, revenue, and cost trends that were not visible in the operational store data.

Apr 2008 - Oct 2008

Sr. Architect

Sr. Architect.BI solution for Revenue and Compliance at a major fast food franchosor.Design and development of database architecture, ETL, and OLAP Cubes for the new datawarehouse and BI solutiuon.Data integrated from multiple diverse source systems.OLAP Cubes were used in Executive Dashboards and Analytics.This solution could potentially help save the company millions of dollars each year

Aug 2007 - Mar 2008

Sr. Database Architect

ACS Software
  • Designed and developed the key database architecture and subsystems for their Oracle and SQL Server based commercial document management software product for the trucking industry, enabling the business to provide online document management to their major customers.
  • Created key database structures, complex data flows, and complex SQL process in stored procedures, and functions.
  • Developed an automated ETL solution integrating SQL Server and Oracle data enabling a closed loop for the document data.
Dec 2006 - Jun 2007

Data Warehouse Architect

Denver Health
  • Design and development of a multi-dimensional pharmaceutical Data Warehouse solution, integrating data from several Oracle and SQL Server clinical data sources.
  • Developed a Hypertension Registry for collaboration with Kaiser Permanente.
  • Created an automated database replication of several source data systems from staging to Production.
  • Developed a job execution system, which uses dynamic sql to construct, execute, and report on complex multi-step scheduled jobs.
Aug 2006 - Nov 2006

Data Warehouse Architect

Designed a Data Warehouse solution integrating data from PeopleSoft Financial and CRM Systems, Implemented visual data analysis software into key areas of the business, and developed reports to key executives within the organization.

Jul 2004 - Jul 2006

Database Architect

Infospot

·Extensive Enhancement of the Call Center Order Management system to include a CRM system.Modules added include Customer Case Management, Sales Campaign, and Email Campaign Management.

Oct 2003 - Jun 2004

Solution Architect

Architected, designed and developed Infospot’s Call Center Order Management system used by Startek, Denver, for their clients at various locations.Modules include Call Center Order Management, and fulfillment Interface to SAP.As a product of Infospot, I was responsible for all phases of design and development.

Jan 2000 - Dec 2002

Database Architect

Tupperware Corporation

Architected, designed, and developed the Oracle based Tupperware US Sales Commissions System including WEB enablement of Sales Force applications.This is utilized by their US sales force nationwide.Tupperware alone used this system to calculate commissions and compensate over 25,000 representatives each month.Software was designed using Oracle Designer and Oracle Developer. Design, development and deployment of numerous complex Oracle PL/SQL based back-end, and front-end WEB database solutions for their sales force.Designed, developed and deployed worldwide e-Commerce solutions for b2c requirements.

Oct 1997 - Dec 1999

Database Architect

Designed and Developed Rexall’s Global Data Warehouse usingBusiness Objects. Completed dynamic collaborative community development on the web using Oracle’s PL/SQL cartridge, and Oracle Application Server, as well as ASP Web Page Development.Designed and developed of a personalized, event driven E-Mail system to support e-business objectives utilizing an Oracle database and ASP.Designed, developed and deployed world wide a global, seamless Commissions System in Oracle 8, Designer and Developer.Integrated the commissions system with Oracle ERP for accurate accounting.This system became the base for the core commission component of what is now Retek Direct, Retek Inc.’s Oracle 8 Based E-Commerce System, which is sold commercially.Extensive Data Modeling and Generation, SQL, and PL/SQL development.

Mar 1997 - Sep 1997

Independent Consultant

ACE Computer Consulting

Design and development of Oracle Forms and Reports for an insurance related Accounts Receivable System using Oracle Developer 2000, on Oracle

Mar 1996 - Jan 1997

Independent Consultant

Kemper National Services

Ongoing development of an their medical insurance auditing application using DataFlex 4GL and Database Development System.

Oct 1992 - Jan 1996

Partner

Computel Computer Systems

Architected, designed, and developed a commercial Hotel Property Management System which was deployed to over 300 hotels in the US.

Education

Education

Certified Technical Instructor

Learning Tree International

Bachelors

UNIVERSITY OF FLORIDA