| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name
Driftwood, TX Street Address
EMAIL AVAILABLELINKEDIN LINK AVAILABLEPHONE NUMBER AVAILABLEProfessional 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 methodologiesExperience HighlightsProject Data Architect -- Advancing the Early Psychosis Network in Texas (EPINET-TX)University of Texas Dell Medical School -Office of the Associate Dean for Research Austin, TX
November 2021 to Present Volunteer 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 dataSenior Data Architect Rental Data ManagementEnterprise Holdings, Inc. St. Louis, MODecember 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 Synced Power Designer repository, data models and reports as neededProject Data Architect Adopt a Highway (AAH)Texas Department of Transportation - Austin, TXMarch 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 databaseProject Data Architect and Developer - Texas Gang Tracking System (TXGANG)Texas Department of Public Safety - Austin, TXJanuary 2015 to January 2022 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 TXGANGProject Data Architect and Developer - Computerized Criminal History (CCH) ApplicationTexas Department of Public Safety - Austin, TXFebruary 2010 to March 2016 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 FBIProject Data Architect and Developer - Online Vehicle Information Shipping Solution (OVISS)United Road - Detroit, MIFebruary 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 abroadProject Data Architect and Developer - Texas Criminal Information Center (TCIC) ApplicationTexas 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 applicationSenior Database AdministratorSamsung 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 staffDatabase Administrator and Data ArchitectLower 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 solutionProject Manager, Data Administrator, DeveloperTexas 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 administratorsEducation/MembershipsBachelor of Arts in MathematicsUniversity of Texas at AustinBaseball letterman and member of 1983 national championship teamT-Association memberTexas Cowboys service group memberVolunteer for Austin-area Bread for All food pantryDB2 User Group, Oracle User Group, Sybase User Group, Power Designer User GroupSkills Agile Methodology AWSBusiness Objects Cherwell COBOLConversion 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 PostgreSQL Power Designer PowerShell Python SAPSAS Slack SQL SSIS Sybase TSO T-SQL
Unix Visio Visual Code Visual StudioVSAM XML |