• 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

• 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 needed

• 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

• 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• 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 FBIdata 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

• 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

• 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

• 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

• 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