Sql Developer Data Modeler

Michael Bramante

Data Modeler, Architect, SQL & Database Conversion Developer

Austin, TX ad5r1k@r.postjobfree.com https://www.linkedin.com/in/bramante/ https://www.MichaelBramante.com/

While I have contracted, my preference is full time employment.

Lead data modeler/architect, and SQL developer with a Master of Science degree in Computer Science and over sixteen years of experience designing, developing, implementing and converting large scale database systems.

Believe in rigorous, diligent requirements discovery.

My experience includes data modeling, database conversion, data migration, ETL, systems integration, metadata management and designing for future growth. I seek the largest and most complex database design and build challenges.

My experience spans diverse industries including Healthcare, Real Estate, Oil & Gas, Aerospace, Taxes, Telecommunications, Investment, Insurance, Shipping and the U.S. Federal Budget. My clients include The White House, The IRS, Microsoft, Boeing and The Seattle Seahawks.

Work Experience

Lead Database Conversion and SQL Developer

Circana

12/2023 - 02/2024

Converted an Oracle 11 database to a PostgreSQL 16.2 database having over 1k tables:

Wrote 10 PL/SQL queries outputting PL/pgSQL: tables, constraints, indexes, sequences, views, m-views, triggers and functions.

Converted language and moved data using Ora2Pg.

Used C# and Visual Studio to enable main desktop dashboard to use the new PostgreSQL database. (3 month remote contract)

Sr. Data Architect and PostgreSQL Developer

PeopleStrategy

12/2022 - 11/2023

PeopleStrategy is a PEO (Professional Employer Organization)

Re-designed, forward engineered and populated one multi-tenant database having 60 tables from the legacy 209 single-tenant databases totaling 313,500 tables and 1,463,000 views.

Re-designed included structures for [HR], [Payroll], [Direct Deposit], [Person], [Institution] and [Contact].

Symmetrically encrypted all PII (Personally Identifiable Information) columns.

Wrote triggers, stored procedures and views in PL/pgSQL.

Used Erwin Data Modeler v12, Postgres 12, PgAdmin/PG Studio, PostgreSQL, GitHub and Jira

Lead Application Designer, Developer and Data Architect, Modeler

OrderBasics

12/2016 - 12/2023

Date Overlaps: I work for OrderBasics between other projects and in my spare time.

Designed and developed OrderBasics B2B Web Portal from concept through to Beta release.

Requirements discovery involved working closely with leading experts in fabric retail and wholesale.

Order Basics Features:

OrderBasics enables fabric Retailers to search for and Order fabric from multiple Wholesalers by using a wildcard search or one or more standardized sets of lookup values including [Line], [Shape], [Theme], [Basic Color], [Vendor] and [Designer].

OrderBasics relies on wholesalers uploading a standardized dataset of their new fabric releases and images.

OrderBasics standard lookup values are applied to each row of a wholesaler’s upload.

oExample: Although uploaded Fabric data may have hundreds of different color names, OrderBasics applies one or more of 17 standard colors to each uploaded row.

OrderBasics includes 58 tables and 95 stored procedures.

I designed the UI and wrote code using: T-SQL, C#, JavaScript & HTML. This included ETL, OLTP, OLAP w star schema and incidental DBA work.

Used ERWin, SQL Server Management Studio and Visual Studio.

Lead Data Modeler and Oracle Developer

Accenture: Kaiser Permanente

01/2022 - 10/2022

Accenture's Data Modernization Effort for Kaiser Permanente

Maintained Erwin Data Models containing 16 subject Areas; 46 data models; 1,799 tables.

Redesigned 46 relational data models and sub-models to be intelligible by anyone.

Created, wrote and tested 3,598 Oracle DDL scripts.

Closed 650 Jira Tickets

Created monthly Erwin Data Model reports and Data Dictionary reports as well as ‘How to’ instructions for both.

Used: Oracle 11g, Erwin Data Modeler 2020, GitHub, Jira, Oracle SQL Developer v17. Also some DBA work.

Lead Database Conversion and SQL Developer

TXHHSC

03/2021 - 11/2021

Converted five (5) Sybase v15 databases to SQL Server 2018:

The 5 databases totaled almost 2,000 objects (including tables, views, and stored procedures).

Used SSMA (Microsoft SQL Server Migration Assistant 8.5 for Sybase Adaptive Server Enterprise)

Manually fixed all converted DB SP’s (adding error trapping, code cleanup and converting ANSI SQL-89 to ANSI SQL-92 syntax)

Implemented ETA/Data migration. Also created test cases and test converted SP’s and views against Sybase

Designed two Audit tables in their own DB fed by insert, update and delete triggers on all DB tables (DBA work).

Used: Oracle SQL Developer v19, ER/Studio Data Architect v18 and HL7.

Lead Data Modeler, Architect and SQL Developer

TXDOT

02/2020 - 01/2021

Lead Data Modeler working closely with Business SME’s and other modelers to:

Created data modeling policies and standards and ensured compliance of other data modelers.

Create intelligible logical and physical relational data models and sub-models. The current data model has 288 entities.

Generate/write DDL from model for database implementation

Reverse engineer from ORACLE database into ER/Studio data models

Compare/Merge data models from database

Used: Oracle SQL Developer v18, ER/Studio Data Architect v17 and ORACLE v12

Sr. Data Modeler, Architect and SQL Developer

TriNet

08/2018 - 12/2019

TriNet is a PEO (Professional Employer Organization)

Designed (Data Modeled), built (forward engineered) and populated (ETL) the Payroll Management System data warehouse from concept through to production/go live. Also analyzed, reverse engineered and documented Oracle PeopleSoft Financials, Oracle PeopleSoft HR and Oracle MasterTax. Oracle PeopleSoft Financials and Oracle PeopleSoft HR have a combined total of nearly 100,000 tables. Their relationships are purposefully obfuscated. Over the course of a few months, I was able to accurately identify and model most their relevant data marts. Used SQL Server, T-SQL, Oracle, ER/Studio and Erwin. Also implemented OLTP, OLAP w star schema and incidental DBA work.

Sr. Data Modeler, Architect and SQL Developer

General Motors

09/2017 - 06/2018

Managed, created and maintained Metadata for mapping tables and columns from disparate data sources to a target database. Back engineered databases into intelligible data models. Used Oracle PL\SQL and ERWin.

Lead Data Modeler

Accenture

02/2017 - 08/2017

Remote Work: I reverse engineered 12 Medicaid & Medicare databases into intelligible data models. Texas shops out all its Medicaid & Medicare to Accenture. Accenture had no pre-existing data models for any of the 12 Medicaid & Medicare databases that they manage for the state of Texas. Some data models had over 2,000 entities. Not all of these tables were used.

Used ER/Studio and ERWin and HL7.

Lead Data Modeler, Architect and SQL Developer

Penton (now Informa)

06/2015 - 01/2017

Remote Work: Penton (now Informa) aggregates and sells data from various industries. Re-designed (Data Modeled), built (forward engineered) and populated five (5) different databases: Aircraft, Automotive (2) and Agriculture (OLTP & OLAP). I took all of these from concept to go-live/production. This includes all ETL/Data Migration, triggers, stored procedures and functions.

Used Pentaho, Oracle 11g, SQL Server 2012, Erwin 7.3 and SQL Developer.

Lead Data Modeler, Architect and SQL Developer

RRC

06/2014 - 04/2015

Data Modernization: The Railroad Commission of Texas regulates the gathering, transmission and distribution of oil, gas, coal and uranium in Texas.

The RRC’s database system of record resides on an antique hierarchical IMS Mainframe (initially designed in 1966 for the Apollo program).

They hired me to:

Relationally model all 22 IMS databases (totaling 573 entities and 4,799 attributes).

Create data modeling standards and metadata and data dictionary management.

Create the “Pipeline Permitting Database” from concept to production. This involved Modeling, forward engineering, ETL and writing all triggers, functions and procedures (totaling 65 entities and 305 attributes).

All 638 entities and 5,104 attributes are well documented with both: Purpose and ETL Source. Used Oracle 10 and Erwin Data Modeler

Lead Data Modeler, Architect and SQL Developer

Lifesize

07/2013 - 05/2014

Designed (Data Modeled), built (forward engineered) and populated an Oracle data warehouse having 45 tables and an ETL process that reads in 71 different kinds of NoSQL data mapping (unstructured & structured) JSON objects totaling several hundred thousand events daily. I also created an Informatica processes interacting with JSON source and Salesforce. This involves rigorous requirements discovery, data modeling and ETL/data migration. Used ERWin Data Modeler, Oracle 11 and Informatica.

Sr. Data Modeler, Architect and SQL Developer

TXHHSC via CMA

06/2012 - 05/2013

Redesigned (Data Modeled), engineered and populated database systems for the Texas WIC program (Women, Infants and Children) of the Texas Department of State Health Services. This includes the databases for each of the 600+ WIC clinics across Texas as well as the State DSHS database. This involved requirements discovery, Data Modeling and ETL/data migration.

Used ERWin Data Modeler, SQL Server and T-SQL and HL7.

Lead Data Modeler, Architect and SQL Developer

LISCR

05/2011 - 04/2012

Designed (Data Modeled) one single enterprise-wide corporate database incorporating six large disparate departmental databases. LISCR is the second largest ship registry in the world having almost 400 employees.

Used ERWin Data Modeler, SQL Server and T-SQL.

Lead Data Modeler, Architect and SQL, C# Developer

Milliman

06/2010 - 03/2011

Lead data modeler and developer for Milliman & Robertson's Milliman Care Guidelines® (MCG) database product which is now used in over 1,000 hospitals. The MCG database stores Milliman & Robertson's managed healthcare guidelines. These guidelines previously existed only in seven volumes of hard copy as well as in several thousand HTML files.

The data model I designed (using ERWin 3.5.2) has 72 entities and stores four of the seven volumes of Milliman & Robertson's managed healthcare guidelines. I generated a SQL Server database from the ERWin data model; then wrote ETL routines which read several thousand HTML files and wrote specific data to the appropriate tables and fields in the database.

Used HL7, Visual Basic and C#.

Lead Data Modeler, Architect

Managed Enterprise

01/2009 - 05/2010

Designed and built a database system Managed-Enterprise for use by HMO's. It is a healthcare transaction processing and information system integrating communications between healthcare providers, health plans, and ancillary groups, significantly reducing claim and payment processing time, and lowering the administrative cost of provider and health plans. Managed-Enterprise is a standardized, all-insurer, Internet-enabled connectivity system to handle claims submission, referrals and authorizations, eligibility verification, formulary compliance, and rapid electronic payments. It is HL7 compliant enabling interoperability between disparate electronic Patient Administration Systems (PAS), Electronic Practice Management (EPM) systems, Laboratory Information Systems (LIS), Dietary, Pharmacy and Billing systems as well as Electronic Medical Record (EMR) and Electronic Health Record (EHR) systems. Also used HL7.

Lead Data Modeler, Architect and ETL, SQL Developer

RealTech (now John L. Scott)

05/2008 - 12/2008

Designed and built a database system that quickly and easily imports, stores and retrieves very disparate MLS’s (Multiple Listing Service) real estate data sources. This system allows searching across all imported MLSs from one unified database. MLS data sources do not adhere to any standards of structure or content. They are as different from one another as snowflakes. The system I designed includes all ETL routines, an OLTP and OLAP (with Star Schema) database. The OLTP database I designed has fifty- one tables. The legacy system had sixty-nine different databases, all of which had 500 tables.

Used: SQL Server 2005, Transact SQL, SSIS and DTS.

Education

American University

Master of Science, Computer Science

Skills

Database Migration - 3 years

Requirements Discovery & Analysis - 16 years

Data Modeling - 16 years

ERWin Data Modeler - 16 years

ER\Studio Data Modeler - 16 years

ETL & Data Migration - 13 years

Oracle PL\SQL - 16 years

SQL Server T-SQL - 16 years

PostgreSQL PL\pgSQL - 5 years

OLTP, OLAP, B.I., Star Schema - 16 years

HL7 / EHR - 4 years

Contact this candidate