Tasked with redesigning and building their entire database as well as assist in maintaining their current system.

Senior Data Architect/Developer for Texas Department of Health and Human Services.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.Also used: Oracle 11g, Oracle SQL Developer v19, ER/Studio Data Architect v18

Senior Data Modeler for Texas Department of Transportation data infrastructure modernization effort.Worked closely with Business Data Analysts, other modelers and business owners to: • 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 databaseAlso used: Oracle SQL Developer v18, ER/Studio Data Architect v17 and Oracle 12c

Designed and built the Payroll Management System data warehouse from concept through to production/go live. Also analyzed, reverse engineered and documented PeopleSoft Financials, PeopleSoft HR and MasterTax. PeopleSoft Financials and 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, Oracle 11g, ER/Studio and ERWin.