| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes .Net Developer Sql Server Georgetown, TX Data Warehouse Sql Server Round Rock, TX Software Developer Data Science Austin, TX Sql Server Senior Developer Austin, TX Big Data Developer(Scala, Python, Kafka, Databricks) Austin, TX Data Engineer Sql Server Austin, TX Sql Server Data Engineering Round Rock, TX |
|
Click here or scroll down to respond to this candidateCandidate's Name
Data Modeler, Architect, SQL & Database Conversion DeveloperAustin, TX EMAIL AVAILABLE https://LINKEDIN LINK AVAILABLE https://www.Candidate's Name .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 ExperienceLead Database Conversion and SQL DeveloperCircana12/2023 - 02/2024Converted 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 DeveloperPeopleStrategy12/2022 - 11/2023PeopleStrategy 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 JiraLead Application Designer, Developer and Data Architect, ModelerOrderBasics12/2016 - 12/2023Date 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 wholesalers 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 DeveloperAccenture: Kaiser Permanente01/2022 - 10/2022Accenture's Data Modernization Effort for Kaiser PermanenteMaintained 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 TicketsCreated 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 DeveloperTXHHSC03/2021 - 11/2021Converted 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 SPs (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 SPs and views against SybaseDesigned 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 DeveloperTXDOT02/2020 - 01/2021Lead Data Modeler working closely with Business SMEs 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 implementationReverse engineer from ORACLE database into ER/Studio data modelsCompare/Merge data models from databaseUsed: Oracle SQL Developer v18, ER/Studio Data Architect v17 and ORACLE v12Sr. Data Modeler, Architect and SQL DeveloperTriNet08/2018 - 12/2019TriNet 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 DeveloperGeneral Motors09/2017 - 06/2018Managed, 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 ModelerAccenture02/2017 - 08/2017Remote 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 DeveloperPenton (now Informa)06/2015 - 01/2017Remote 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 DeveloperRRC06/2014 - 04/2015Data Modernization: The Railroad Commission of Texas 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: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 ModelerLead Data Modeler, Architect and SQL DeveloperLifesize07/2013 - 05/2014Designed (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 DeveloperTXHHSC via CMA06/2012 - 05/2013Redesigned (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 DeveloperLISCR05/2011 - 04/2012Designed (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# DeveloperMilliman06/2010 - 03/2011Lead 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, ArchitectManaged Enterprise01/2009 - 05/2010Designed 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 DeveloperRealTech (now John L. Scott)05/2008 - 12/2008Designed and built a database system that quickly and easily imports, stores and retrieves very disparate MLSs (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.EducationAmerican UniversityMaster of Science, Computer ScienceSkillsDatabase Migration - 3 yearsRequirements Discovery & Analysis - 16 yearsData Modeling - 16 yearsERWin Data Modeler - 16 yearsER\Studio Data Modeler - 16 yearsETL & Data Migration - 13 yearsOracle PL\SQL - 16 yearsSQL Server T-SQL - 16 yearsPostgreSQL PL\pgSQL - 5 yearsOLTP, OLAP, B.I., Star Schema - 16 yearsHL7 / EHR - 4 years |
