Data Architect Senior
Resume:
John Turman
Austin, TX *****
******.****@*****.***
www.linkedin.com/in/john-turman/
Professional Summary
•25 years of successfully developing multiple database projects from inception to implementation – responsibilities include: analysis, design, database creation, conversion, deployment, and governance of project data
•Proven track record of partnering and successfully meeting customer requirements while also effectively adapting and implementing project requirement changes
•Experienced in successfully collaborating with upper management and stakeholders, as well as other state, federal, and commercial entities to solve complex data processing initiatives
•Extensive experience integrating multiple disparate data sources into a consolidated database using proven data modeling techniques and agile methodologies
Experience Highlights
Senior Data Architect – Advancing the Early Psychosis Network in Texas (EPINET-TX)
University of Texas Dell Medical School - Austin, TX
November 2021 to Present
•AWS PostgreSQL database designer, developer and ETL implementor
•Worked with team to develop multi-version pgModeler data models
•Converted all REDCap data into PostgreSQL database using Python and SQL
•Used Postman and SAS to analyze REDCap data
Senior Data Architect – Rental Data Management
Enterprise Holdings, Inc. – St. Louis, MO
December 2021 to August 2024
•All work was done in an agile methodology utilizing Jira, Confluence and other change management/tracking software
•Worked with multiple teams concurrently to provide Oracle and Postgres AWS database change support
•Developed database change scripts and definitions
•Synced Power Designer repository, data models and reports as needed
Project Data Architect – Adopt a Highway (AAH)
Texas Department of Transportation - Austin, TX
March 2021 to August 2021
•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 3rd 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
Project Data Architect and Developer - Texas Gang Tracking System (TXGANG)
Texas Department of Public Safety - Austin, TX
January 2015 to January 2021
•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
Project Data Architect and Developer - Computerized Criminal History (CCH) Application
Texas Department of Public Safety - Austin, TX
February 2008 to March 2015
•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
Project Data Architect and Developer - Online Vehicle Information Shipping Solution (OVISS)
United Road - Detroit, MI
February 2005 to December 2007
•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
Project Data Architect and Developer - Texas Criminal Information Center (TCIC) Application
Texas Department of Public Safety - Austin, TX March 2000 to October 2006
•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
Senior Database Administrator
Samsung Austin Semiconductor January 1999 to April 2000
•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
Database Administrator and Data Architect
Lower Colorado River Authority - Austin, TX January 1996 to December 1998
•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
Project Manager, Data Administrator, Developer
Texas Comptroller of Public Accounts - Austin, TX August 1984 to December 1995
•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
Education/Memberships
Bachelor of Arts in Mathematics
University of Texas at Austin
T-Association member
Texas Cowboys service group member
Volunteer for Austin-area Bread for All food pantry
DB2 User Group, Oracle User Group, Sybase User Group, Power Designer User Group
Skills
•Agile Methodology
•AWS
Business Objects
•Cherwell
•COBOL
Conversion Strategies
•Data Modeling
•Data Warehouse
•DB2
•Erwin
•ER/Studio
•Expediter
•FileMaker Pro
•GitHub
•JCL
•Jenkins
•Jira
•JSON
•Linux
•Maximo
•Microsoft Access
•MS SQL Server
•MS Office
•MySQL
•Oracle
•PeopleSoft
•Postgres
•Power Designer
•PowerShell
•Python
•SAP
SAS
•Slack
•SQL
•SSIS
•Sybase
•TSO
•T-SQL
•Unix
•Visio
•Visual Code
•Visual Studio
VSAM
• XML
Contact this candidate