Project Data Lead, Data Architect Resume

SUMMARY

Senior database developer with extensive process re - engineering experience
Agile scrum master directing cross-departmental teams to successful, on time, within budget projects
Experienced leader in converting legacy systems into logical, flexible, maintainable applications

TECHNICAL SKILLS

Databases: DB2, SQL Server, Oracle, Sybase, MySQL, SQL Anywhere, Access, SAS, FileMaker

Languages: SQL, SAS, Java, PeopleSoft, SAP, Perl, COBOL, BASIC, PowerBuilder, Mantis, FORTRAN

Software: SSIS, Visual Studio, Eclipse, JIRA, Jenkins, Git, Cherwell Service Management, Power BI, Tableau, Business Objects, Desktop DBA, Oracle Enterprise Manager, Enterprise Backup Utility, Omniback, SQL Central, SQL Loader, VSAM, S2K, Mark IV, Legato, Visio, Exceed

Case Tools: Erwin, Power Designer, ER/Studio, DBDesinger4, Popkin System Architect

PROFESSIONAL EXPERIENCE

Project Data Lead, Data Architect

Confidential

Responsibilities:

Met with numerous law enforcement units throughout the State of Texas to develop data models
Wrote all conversion programs which ran with no issues
Developed code to send TxGang records to the FBI’s National Crime Information Center (NCIC) system
Created SQL Server and SSIS/Visual Studio processes to monthly merge the Houston Police Department’s GangTracker database into the TxDPS TxGang database and send the updates to NCIC
Computerized Criminal History (CCH) system for TxDPS to track arrests, prosecutions and convictions in the State of Texas
Worked with executive team to create data models
Architected the application and created all z/OS DB2 databases
Developed and executed all conversion programs which ran with no issues
Re-architected the NYSIIS soundex algorithm to work with the large quantity of names in the database
Wrote the primary SQL procedures to return all CCH information within the required response times
Online Vehicle Information Shipping Solution (OVISS) for United Road to track vehicle transports
Developed all data models without having access to the existing application or database per customer copyright concerns
Created all SQL Server databases - development, test and production
Converted customer provided data extracts into the new OVISS database without issue
Application was delivered on time and within budget
System was marketed to similar companies in the US and abroad
Texas Criminal Information Center (TCIC) system for The Texas Department of Public Safety (TxDPS) to track criminal, missing and unidentified person activity in the State of Texas
Worked with executive team to create data models
Architected TCIC application and created all z/OS DB2 databases
Converted all 10 disparate data structures into the new consolidated database without issue
Designed and wrote primary SQL stored procedures to meet mandated response times requirements
Successfully trained TxDPS staff to independently maintain application

Senior Database Administrator, SAP Administrator

Confidential

Responsibilities:

Administered all Oracle, Sybase and SQL Server database environments
Successfully managed all Y2K database conversions
Developed database triggers and procedures
Created Unix shell scripts
Provided SAP Basis support
Detailed database backup and recovery procedures

Database Administrator, Data Administrator

Confidential

Responsibilities:

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 and physical data models
Reversed and forward engineered databases and data models
Implemented data modeling standards and guidelines
Implemented data dictionary solution

Re-engineering Project Manager

Confidential

Responsibilities:

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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship