What's wrong - and right - with this picture?
This is a real-world example (found in the wild) of how the simplest of things (in this case, a misunderstanding of roleplaying) can lay waste to a multi-million-dollar project. The problem as...
Dennis Towers
Mentor
(1 reviews)
US$20.00
For every 15 mins
1
Sessions/Jobs
ABOUT ME
Data Modeller, Coach, Mentor, 22 Years Experience
Data Modeller, Coach, Mentor, 22 Years Experience
• 3NF (OLTP), Inmon, Kimball Star (OLAP) and One Big Table (OBT) schemas for Operations (ODS), Enterprise Data Warehousing (EDW), and BI Analytics.
• An ability to reduce complex problems into simple patterns.
• Creative repeatable designs to substantially reduce the cost of ownership.
Eastern Time (US & Canada) (-04:00)
Joined April 2023
EXPERTISE
22 years experience
Modelling fits my mind. I solve data modelling problems the way some people solve crossword puzzles: to relax while having fun. Or like a...
Modelling fits my mind. I solve data modelling problems the way some people solve crossword puzzles: to relax while having fun. Or like a grandmaster who simultaneously executes dozens of high-level chess games against worthy players in good spirits.
ER/Studio
22 years experience
Although I prefer ER-Studio, I can work with ER-Win (Erwin), Oracle SQL Developer, or any modelling tool you have, even Visio or LucidChart.
Although I prefer ER-Studio, I can work with ER-Win (Erwin), Oracle SQL Developer, or any modelling tool you have, even Visio or LucidChart.
22 years experience
This is where so much that can wrong does go wrong, often resulting in bloated cookie-cutter anti-patterns and worse. I can help prevent ...
This is where so much that can wrong does go wrong, often resulting in bloated cookie-cutter anti-patterns and worse. I can help prevent that from happening. Twenty plus years of experience lets me cut through the fog of war to clearly see what is required and how to accomplish it.
22 years experience
• GCP (BigQuery)
• Azure (Synapse)
• SQL-Server v.7-2019
• GCP (BigQuery)
• Azure (Synapse)
• SQL-Server v.7-2019
22 years experience
Multiple greenfiend end-to-end designs and implementations for on-prem and cloud environments.
Multiple greenfiend end-to-end designs and implementations for on-prem and cloud environments.
REVIEWS FROM CLIENTS
Dennis's profile has been carefully vetted and approved as a Codementor. Connect with Dennis now, and leave a review for them once you're done!
SOCIAL PRESENCE
EMPLOYMENTS
Lead Data Modeller / Coach
Tyson Foods, Inc.
2022-03-01-2023-01-01
• Design and implement a greenfield proof-of-concept 3NF and Star Schemas, establishing new standards for persistent hub (ODS), an analyt...
• Design and implement a greenfield proof-of-concept 3NF and Star Schemas, establishing new standards for persistent hub (ODS), an analytical (Cube) and OBT layers for a system migration from SAP, WorkDay, Employee Service Platform (ESP) to Google Cloud Platform (GCP).
• Coach-mentor junior and mid-level modelers in working sessions and peer-reviews. Signoff responsibilities for enterprise modeling prior to going to qa/production.
Database
Coaching
Requirements Gathering
View more
Database
Coaching
Requirements Gathering
Mentoring
Data structure
Data Modelling
Data Warehouse
View more
Data Modeller / Consultant
HCA HealthCare
2021-08-01-2021-12-01
Reverse engineer an existing data warehouse, provide a fresh schema for data marts to include Patient, Order, Diagnosis, Procedure and DR...
Reverse engineer an existing data warehouse, provide a fresh schema for data marts to include Patient, Order, Diagnosis, Procedure and DRG (billing). Also provide a single materialized dataset. (One Big Table, ER-Studio, Visual Studio 2017 SSDT).
Database
Data structure
Data Modelling
View more
Database
Data structure
Data Modelling
Data Warehouse
View more
Data Modeller / Consultant
Highlights for Children
2021-04-01-2021-08-01
Design conceptual, logical, and physical data models (ER-Studio) for a 3NF Operational Data Store (ODS), and a Kimball star schema in an ...
Design conceptual, logical, and physical data models (ER-Studio) for a 3NF Operational Data Store (ODS), and a Kimball star schema in an Azure Synapse environment.
Database
Data structure
Data Modelling
View more
Database
Data structure
Data Modelling
View more
PROJECTS
Snowstorm
Tyson Foods, Inc.
2023
Identified and resolved several core (day one) design issues that caused anti-patterns to form throughout an enterprise cloud database al...
Identified and resolved several core (day one) design issues that caused anti-patterns to form throughout an enterprise cloud database already under migration for more than a year. In tandem, I provided a complete ‘city on the hill’ greenfield solution, including design patterns, naming conventions, methodologies, and more across a set of 3NF/Star/OBT schemas, in a kind of ‘matched pair plus one’ form, and implemented them against a live project within the migration. I dubbed this solution Snowstorm (a methodology).
Database
Data Modelling
Data Warehouse
View more
Database
Data Modelling
Data Warehouse
View more
Vertical Ledger
WinSupply, Inc.
2020
WinSupply: Identified and resolved a core (day one) design issue relating to order fulfillment in a mature database by applying a novel d...
WinSupply: Identified and resolved a core (day one) design issue relating to order fulfillment in a mature database by applying a novel design based on standard formations. Processing loads that were crashing an iSeries AS-400 could now run against a box w/ one quad processor and 64GB of ram, returning results in 2/10th seconds or less (the box was, however, connected to a spindle). I dubbed this solution Vertical Ledger (an ontology).
Database
Data Modelling
Data Warehouse
View more
Database
Data Modelling
Data Warehouse
View more