Michael Bramante

Lead Data Modeler / Architect / SQL Developer

Austin, Texas Metropolitan Area

ad1r9i@r.postjobfree.com 202-***-****

https://www.linkedin.com/in/bramante/ https://www.michaelbramante.com

Certificates Big Data 101 10/06/2020

Summary

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

I am a senior data modeler/architect, and SQL developer with a Master of Science degree in Computer Science and over sixteen years of experience designing, developing and implementing large scale database systems (OLTP & OLAP).

I believe in rigorous, diligent requirements discovery.

My experience includes 3.7 years of healthcare/HL7 on 5 different projects, data migration, ETL, systems integration, metadata management, setting data standards and designing for future growth. I seek the largest and most complex database design & build challenges.

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

Work Experience

Sr. Application Designer / Developer; Sr. Data Architect / Modeler

OrderBasics

12/2016 - 07/2023 (6 years 6 months)

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:

oOrderBasics 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].

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

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

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

oOrderBasics includes 58 tables and 95 stored procedures.

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

I also used ERWin, SQL Server Management Studio and Visual Studio

Sr. Data Modeler/Engineer & PostgreSQL Developer

PeopleStrategy

02/2022 - 03/2023 (1 year 2 months)

PeopleStrategy is a PEO (Professional Employer Organization)

Data Modernization Plan: Redesigned and populated one database replacing the current/legacy databases.

Re-designed, forward engineered and populated one multi-tenant database having 60 tables from the current single-tenant databases having 313,500 tables.

My re-design included tables and related 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 PostgreSQL.

Legacy single-tenant DB had 209 single-tenant databases total 313,500 tables and 1,463,000 views. Each DB has 54 PII columns in 17 tables.

I used ERWin 12, PgAdmin/PG Studio and PostgreSQL

Sr. Lead Data Modeler / Oracle Developer

Accenture: Kaiser Permanente

03/2021 - 01/2022 (10 months)

Data Modeler and Oracle Developer:

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.

Also used: Oracle 11g, Erwin Data Modeler 2020, GitHub, Jira, Oracle SQL Developer v17. This includes incidental DBA work.

Sr. Lead Data Modeler / Architect / Developer

HHSC (Texas Health & Human Services Commission)

08/2020 - 04/2021 (9 months)

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 (also adding error trapping, code cleanup and converting ANSI SQL-89 to ANSI SQL-92 syntax)

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). Also used: Oracle SQL Developer v19, ER/Studio Data Architect v18 and HL7.

Sr. Lead Data Modeler / Architect / SQL Developer

Texas Department of Transportation

06/2019 - 05/2020 (1 year)

Worked closely with Business Data Analysts, other modelers and business owners 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

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

Sr. Data Modeler / Architect / SQL Developer

TriNet

10/2017 - 02/2019 (1 year 5 months)

TriNet is a PEO (Professional Employer Organization)

Designed (Data Modeled), built (forward engineered) 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. I used SQL Server, T-SQL, Oracle, ER/Studio and Erwin. Also implemented OLTP, OLAP w star schema and incidental DBA work.

Sr. Data Modeler and Meta Data / SQL Developer

General Motors

12/2016 - 9/2017 (10 months)

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. I used PL\SQL and ERWin.

Sr. Lead Data Modeler

Accenture

03/2016 - 09/2016 (7 months)

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. I used ER/Studio and ERWin and HL7.

Sr. Lead Data Modeler / Architect / SQL Developer

Penton (now Informa)

09/2014 - 04/2016 (1 year 8 months)

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.

I used Pentaho, Oracle 11g, SQL Server 2012, Erwin 7.3 and SQL Developer

Sr. Lead Data Modeler / Architect / SQL Developer

Railroad Commission of Texas

09/2013 - 07/2014 (11 months) Contract:

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

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

They hired me to:

Create data modeling standards and metadata and data dictionary management.

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

Create the Pipeline Permitting Database from concept to production. This involved Modeling, forward engineering, populating and writing all triggers, functions and procedures (totaling 65 entities and 305 attributes). This alone is a multi-million-dollar effort.

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

Sr. Lead Data Modeler / Architect / SQL Developer

Lifesize

09/2012 - 07/2013 (11 months)

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 (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 / SQL Developer

HHSC (Texas Health & Human Services Commission) via CMA

12/2011 - 11/2012 (1 year)

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.

Sr. Lead Data Modeler / Architect / SQL Developer

LISCR

11/2010 - 10/2011 (1 year)

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.

Sr. Lead Data Modeler / Architect / SQL & C# Developer

Milliman

11/2009 - 08/2010 (10 months)

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 VB 6.0 conversion routines which read several thousand HTML files and wrote specific data to the appropriate tables and fields in the database. Also used HL7.

Sr. Lead Data Modeler / Architect

Managed Enterprise

06/2008 - 10/2009 (1 year 5 months)

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.

Sr. Lead Data Modeler / Architect

RealTech (now John L. Scott)

01/2007 - 08/2008 (8 months)

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 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.

Also used: SQL Server 2005, Transact SQL, SSIS and DTS.

Education

American University

Master of Science, Computer Science

Skills

Requirements Discovery & Analysis - 14 years

Data Modeling - 14 years

ERWin Data Modeler - 14 years

ER\Studio Data Modeler - 14 years

ETL / Data Migration - 14 years

PL\SQL - 14 years

T-SQL - 14 years

PostgreSQL - 5 years

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

HL7 / EHR - 4 years

Contact this candidate