Data Architect Senior

John Turman

****Driftwood, Texas ***** 512-***-**** ******.****@*****.*** LinkedIn

Professional Summary

Over 20 years of experience in developing and implementing complex database designs, ensuring data integrity and performance optimization. Expertise in transforming business requirements into efficient, scalable data solutions using normalization, indexing, and advanced data modeling techniques. Proven collaboration with stakeholders and leadership to integrate disparate data sources into cohesive systems and achieve critical project objectives.

Skills

•Database & Data Management: MS SQL Server, MySQL, Oracle, Postgres, DB2, Sybase, FileMaker Pro, Microsoft Access, VSAM, SQL, SSIS

•Data Modeling & Business Intelligence: Data Modeling, Data Warehouse, Business Objects, Power Designer, Erwin, ER/Studio, Visio

•Programming & Scripting: COBOL, Python, T-SQL, PowerShell, XML, JSON

•Development & DevOps Tools: Jenkins, GitHub, Jira, Visual Studio, Visual Code, Agile Methodology, Cherwell

•Systems & Enterprise Applications: AWS, Linux, Unix, Microsoft Office, Slack, JCL, TSO, SAP, SAS, Maximo, PeopleSoft, Expediter, Conversion Strategies

Experience Highlights

University of Texas Dell Medical School Nov 2021 - Present

Senior Data Architect Advancing the Early Psychosis Network in Texas (EPINET-TX) Austin, TX

•Engineered AWS PostgreSQL database architecture as a designer, developer, and ETL implementor, aligning with normalization and performance best practices

•Collaborated with team to develop multi-version pgModeler data models, illustrating robust data relationships and design patterns

•Converted all REDCap data into a normalized PostgreSQL database using Python and SQL, ensuring data integrity and query efficiency

•Leveraged Postman and SAS to analyze REDCap data, identifying opportunities for database optimization and enhanced data retrieval

Enterprise Holdings, Inc. Dec 2021 - Aug 2024

Senior Data Architect Rental Data Management St. Louis, MO

•Executed agile methodology using Jira, Confluence, and other change management tools to drive database updates and enhancements

•Coordinated with multiple teams concurrently to provide Oracle and AWS PostgreSQL database change support, incorporating normalization and indexing techniques

•Developed and implemented database change scripts and definitions, aligning with security management and backup/recovery practices

•Synchronized the Power Designer repository, data models, and reports to ensure consistent database design and effective integration of business requirements

Texas Department of Transportation

Project Data Architect Adopt a Highway (AAH)

•All work was done in an agile methodology work environment with daily scrum meetings

•Worked with management team to decide which AWS RDS would be used for the project

•Redesigned legacy database into third normal form

•Identified data anomalies and presented them to subject matter experts

•Wrote the ETL conversion programs for the new AWS SQL Server database

•Worked with GIS/ArcMap consultants to integrate GIS database with business database

Texas Department of Public Safety Jan 2015 - Jan 2021

Project Data Architect and Developer Texas Gang Tracking System (TXGANG) Austin, TX

•Met with law enforcement agencies throughout the State of Texas to develop logical and physical data models

•Designed and created new TXGANG AIX and Linux DB2 databases

•Wrote ETL conversion programs for agencies with existing databases for the new database

•Developed code to send TXGANG updates to the FBI's NCIC database

•Created SQL Server SSIS ETL processes to monthly merge the Houston Police Department's Gang-Tracker database into TXGANG

Texas Department of Public Safety Feb 2008 - Mar 2015

Project Data Architect and Developer Computerized Criminal History (CCH) Application Austin, TX

•Worked extensively with executive team to create logical and physical data models

•Architected the application and created all z/OS DB2 databases (dev, test, prod)

•Developed and executed all ETL conversion programs for the new CCH database

•Re-architected the NYSIIS SOUNDEXING algorithm to work with the large quantity of names in the CCH database

•Wrote the main querying SQL to return all CCH information within the required response times

•Developed processes to send dispositions to the FBI

United Road

Project Data Architect and Developer Online Vehicle Information Shipping Solution (OVISS)

•Worked exclusively with the company's CIO to develop logical and physical data models

•Project team developed application without having access to the existing application or database per CIO's copyright infringement concerns with the previous application provider

•Created all SQL Server databases - development, test, and production

•Created all ETL conversion jobs for the new OVISS database without issues

•Completed system was marketed to similar companies in the US and abroad

Texas Department of Public Safety

Project Data Architect and Developer Texas Criminal Information Center (TCIC) Application

•Worked extensively with executive team and subject matter experts to create logical and physical data models

•Architected the TCIC application and created all z/OS DB2 databases

•Created all conversion ETL jobs for the new consolidated database without issues

•Designed, developed and tuned the mission critical querying SQL to meet State and Federal mandated response time requirements

•Successfully trained TXDPS staff to independently maintain the application

Samsung Austin Semiconductor

Senior Database Administrator

•Administered all Oracle, Sybase and SQL Server database environments

•Successfully managed all Y2K database upgrades and conversions

•Developed database triggers and procedures

•Created Unix shell scripts

•Provided SAP Basis support

•Detailed database backup and recovery procedures for existing staff

Lower Colorado River Authority

Database Administrator and Data Architect

•Administered all Oracle, Sybase, and SQL server databases

•Configured PeopleSoft databases, process schedulers, application, and web servers

•Tuned databases improving SQL performance response times

•Administered Business Objects repositories and universes

•Developed conceptual, logical and physical data models

•Reverse and forward engineered databases and data models

•Implemented data modeling standards, guidelines and data dictionary solution

Texas Comptroller of Public Accounts

Project Manager, Data Administrator, Developer, Supervisor

•Architected the Integrated Tax System (ITS) database for The State of Texas

•Managed high profile business re-engineering projects and initiatives

•Managed data administration and application development staffs

•Developed applications and reporting systems

•Trained business analysts, programmers, and data administrators

University of Texas at Austin

Bachelor of Arts, Mathematics

•Achievements: T-Association member, Texas Cowboys service group member, Volunteer for Austin-area Bread for All food pantry

Mar 2021 - Aug 2021

Austin, TX

Feb 2005 - Dec 2007

Detroit, MI

Mar 2000 - Oct 2006

Austin, TX

Jan 1999 - Apr 2000

Jan 1996 - Dec 1998

Austin, TX

Aug 1984 - Dec 1995

Austin, TX

Education/Memberships

Contact this candidate