David
mbndave@aol.com
516-725-2475
Seaford, NY 11783
Information Technology Consultant
28 years experience W2
0
Recommendations
Average rating
313
Profile views
Summary

The elevator speech of my background is this; From systems programming and installation of DB2 on the mainframe using SMP/E and being an application DBA on Oracle, MS SQL Server, Sybase and it also lead to modeling. I am a modeling expert in Erwin. When CA, who owned the Erwin product at the time needed a data architect to corral two teams of 15 modelers each they hired me to bring it in as one unified data warehouse. I've been doing data architecture ever since. I am a metadata expert with MDM and data profiling as well as process work flow design. I've done design for OLTP, OLAP, Data Lakes and migration to the cloud. I'm self taught AWS and can apply data design and quality practices to any AI or ML system. As a data architect with over 20 years experience, I have migrated databases repeatedly. I have many years with DB2 and UDB and have migrated a few systems. Involved with migrations from mainframe to Oracle (OLTP), to SQL server and to Cloud databases.

Specialties:

  • Information inventory and process inventory asset management
  • Data Architecture and modeling
  • Data Modeling Virtualization Pub/Sub
  • Erwin and other Data Modeling Tools
  • Master Data Management KVI management and remediation management
  • Oracle, DB2/UDB, MS SQL Server, Sybase, Teradata
  • SAS/Excel/Access, some Kafka
  • GCP, AWS cloud

Experience
Education
Attended in BBA, MIS, NIF
Pace University - Lubin School of Business 1984
Skills
DB2
2018
16
IMS
2023
16
Data Migration
2023
14
Erwin Data Modler
2023
9
Data Modeling
2023
6
DBA
2014
6
IBM Mainframe
2023
6
OLAP
2019
5
Snowflake
2023
5
Sybase
2016
5
Capacity Planning
2003
4
OLTP
2022
4
System Architecture
2009
4
UDB
2003
4
Architecture
2018
3
Oracle
2023
3
Analysis
2022
2
Business Analysis
2018
2
Data Architecture
2018
2
Data Management
2022
2
Data Warehousing
2019
2
Enterprise Architecture
2013
2
Information Architecture
2013
2
Performance Tuning
2022
2
Scripting
2019
2
SQL
2020
2
AWS
2023
1
Big Data
2018
1
BPMN
2007
1
Cloud Migration
2022
1
Cobol
2023
1
Compliance
2022
1
Data Governance
2022
1
Data Security
2018
1
Data Virtualization
2013
1
ESB
2013
1
ETL
2023
1
GCP
2022
1
Implementations
2011
1
Kafka
2022
1
Netezza
2013
1
PostgreSQL
2022
1
Powerdesigner
2019
1
Project Management
2019
1
SAP
2019
1
SOA
2013
1
SQL Server
2020
1
Virtualization
2013
1
Warehouse
2023
1
Workflow Analysis
2022
1
Agile Methodology
2015
1
Assessment
2017
1
Asset Management
0
1
BPR
2004
1
Business Intelligence
0
1
Cassandra
2015
1
Data Analytics
2018
1
Data Dictionary
2015
1
Data Integration
2018
1
Data Lakes
2018
1
Data Mapping
2018
1
Data Marts
2018
1
Data Profiling
0
1
Database Design
0
1
Database Maintenance
2018
1
DBMS
2015
1
Documentation
2019
1
E/R Studio
2019
1
Engineering
2023
1
Enterprise Content Management
0
1
Hadoop
2018
1
Hive
2018
1
impala
2018
1
InDesign
2018
1
Metadata
2016
1
Microsoft Excel
2015
1
MS Azure
2019
1
MS SharePoint
2019
1
MS Word
2015
1
mSQL
0
1
ODBC (Open Database Connectivity)
0
1
Portfolio Management
0
1
RAMP
2016
1
RDBMS
2018
1
SAP HANA
2019
1
SAS
2014
1
Solutions Architecture
0
1
Strategic Planning
0
1
Teradata
2019
1
Waterfall
2013
1
Windows
2015
1
z/OS
0
1
Zachman
0
1
Publications
How To Devise a Data Strategy
Information Management, 2011