Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

William Holder

Austin,TX

Summary

Results-driven Database Engineer with proven ability to deliver high-quality database solutions efficiently. Specialize in SQL optimization, data modeling, and cloud-based database management systems. Excels in problem-solving, teamwork, and adaptability, ensuring smooth collaboration and innovative solutions in fast-paced environments.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Senior Software Engineer

General Motors
Austin, Texas
04.2015 - 01.2025
  • Designed database structure to optimize data flow while ensuring integrity and security.
  • Oversaw migration of large database systems, including testing and validation.
  • Investigated production issues reported by users and provided timely resolutions.
  • Collaborated with team members to ensure successful project completion within timeline constraints.
  • Coded business logic into stored procedures with a focus on optimization and accuracy.
  • Updated and created new stored procedures to address complex business requirements while preserving legacy code.
  • Managed interactions between end users and developers to gather system requirements.
  • Documented capabilities of current software systems for the software conversion project baseline.
  • Analyzed database security risks, creating a plan to eliminate database links from all code.
  • Performed ETL activities to maintain integrity between client databases and TDI storage objects.
  • Troubleshot existing database systems for errors or inconsistencies in data output.
  • Implemented best practices for database architecture design and development processes.
  • Executed tests on newly developed databases prior to release into a production environment.
  • Optimized queries for maximum efficiency and scalability in a production environment.
  • Created stored procedures, triggers, functions, views, indexes, and constraints on databases.
  • Analyzed business requirements to recommend appropriate database solutions.
  • Assisted other teams with troubleshooting complex SQL queries or stored procedures.
  • Worked as part of project teams to coordinate database development and determine project scopes and limitations.
  • Created conceptual, logical and physical data models for use in different business areas.

Senior Data Warehouse Developer

Accenture
Austin, Texas
03.2014 - 04.2015
  • Performed analysis, design, coding, and testing of complex reports and data extracts.
  • Supported multiple Texas Medicaid data warehouse systems while managing concurrent assignments.
  • Utilized SQL, ETL, OLAP reporting, and data warehouse concepts for effective solutions.
  • Combined technical skills with Texas Medicaid expertise to deliver impactful results.
  • Engaged in significant client interactions, both written and verbal, with minimal supervision.
  • Developed and maintained strong client relationships to enhance collaboration.
  • Participated in deploying production releases and introducing new services into the environment.
  • Identified continuous improvement opportunities and mentored peers during project execution.

Senior EDW Developer, Global Information Systems

Hewlett-Packard
Austin, Texas
09.2012 - 10.2013
  • Analyzed and documented legacy data warehouse ETL scripts to clarify functional data flow in daily roll-up process.
  • Updated and created SQL scripts to fulfill business unit functionality requests.
  • Optimized performance of SQL scripts within data warehouse environment.
  • Developed retrieval scripts to compare datasets on unconnected mirrored servers.
  • Conducted data mining to compare archived data against current warehouse information.
  • Generated compliance reports using archived data warehouses and source system databases.
  • Created transformations and extractions with Pentaho data integration tool.
  • Evaluated Informatica for potential replacement of existing ETL process tool.

Senior Database Engineer

Experior, Inc.
Round Rock, Texas
10.2011 - 08.2012
  • Architected database structure enhancements, including new tables, columns, and keys.
  • Developed and updated stored procedures to improve server-side processing capabilities.
  • Optimized codebase by reducing execution run times and boosting overall database performance.
  • Documented all alterations and enhancements to database code and structure.
  • Created scripts for modifying existing production database structures and stored procedures.

Database Engineer

Telvent, USA
Austin, Texas
05.2011 - 10.2011
  • Migrated Oracle Forms and Reports code to stored procedures for FLEX web-based reporting.
  • Analyzed offline database structure to recover data, supporting real-time transactions.
  • Enhanced legacy database stored procedure code for improved performance.
  • Created reporting structures for online publication and electronic mail delivery.

Oracle Programmer

The National Alliance for Insurance Education & Research
Austin, Texas
06.2010 - 03.2011
  • Optimized Oracle 10g database to enhance support for customer service and operations.
  • Documented business rules through interviews, improving data management processes.
  • Led migration of reporting tools from Crystal Reports to Oracle Business Intelligence.
  • Developed stored procedures for real-time website shopping cart functionality.
  • Implemented scripts and configuration rules to eliminate duplicate records, ensuring data integrity.
  • Executed application fixes and enhancements in Omnis7 development environment for legacy systems.
  • Analyzed integration of new data sources into company database using Oracle Warehouse Builder.

Database Developer (Database Conversion Specialist)

McLane Advanced Technologies
Temple, Texas
08.2008 - 05.2010
  • Analyzed Sybase, Oracle, and SQL Server legacy database systems for data mapping and conversion requirements.
  • Developed integrated C# programs to migrate user data into enhanced Oracle 11g database structure.
  • Coded and optimized PL/SQL programs for Service Oriented Architecture applications.
  • Collaborated with colleagues using TRAC software to document code base changes.
  • Created custom reports in TRAC with SQLite to meet management documentation requests.
  • Maintained and documented codebase through development lifecycle using TortoiseCVN.

Database Developer

Knowledgeable & Innovative Technical Solutions, Inc. (KITS, Inc.)
Round Rock, Texas
08.2005 - 08.2008
  • Developed Oracle database functions, procedures, and packages to support Java application development in n-tier SOA environment.
  • Created Hibernate modules to connect relational Oracle database with object-oriented Java applications.
  • Maintained database system reliability through production environment support activities.
  • Generated XML files with Ant for deploying database code upgrades using Incanto as SQL execution environment.
  • Refactored and optimized existing stored procedures in Oracle 10g environment.
  • Collaborated using ClearQuest for documentation of code changes during development.
  • Documented codebase changes and enhancements utilizing ClearCase for version control.

Database Program Manager

Tarleton State University
Stephenville, Texas
03.2005 - 06.2005
  • Conducted client interviews to gather technical specifications for information requests.
  • Executed anonymous PL/SQL blocks and SQL queries within Oracle 9i database environment.
  • Developed web-based reports utilizing Crystal Reports and Oracle Reports in data warehouse setting.
  • Maintained and enhanced office website using HTML with embedded Oracle SQL.

Education

Bachelor of Science - Computer And Information Systems

Tarleton State University
Stephenville, TX

Master of Science - Computer Information Systems

Tarleton State University
Stephenville, TX

Skills

  • Database design
  • SQL optimization
  • ETL processes
  • Data warehousing
  • Stored procedures
  • Database optimization
  • SQL coding
  • Data modeling
  • Reporting tools
  • Business requirements gathering
  • Documentation skills
  • Effective communication
  • Team collaboration
  • Data quality assurance
  • ETL development
  • Big data technologies
  • Performance tuning
  • SQL programming
  • PL/SQL Programming
  • Cloud Database Solutions
  • RDBMS Understanding
  • Database troubleshooting
  • Database structures

Certification

  • Oracle Advanced PL/SQL Developer Certified Professional
  • Oracle PL/SQL Developer Certified Associate
  • Oracle Database: SQL Certified Expert
  • IBM Certified Database Associate – DB2 9 Fundamentals
  • IBM Certified Application Developer – DB2 9
  • IBM Certified Solution Designer – IBM Rational Unified Process V7.0
  • IBM Certified Solution Expert – U2 Family Application Development

Timeline

Senior Software Engineer

General Motors
04.2015 - 01.2025

Senior Data Warehouse Developer

Accenture
03.2014 - 04.2015

Senior EDW Developer, Global Information Systems

Hewlett-Packard
09.2012 - 10.2013

Senior Database Engineer

Experior, Inc.
10.2011 - 08.2012

Database Engineer

Telvent, USA
05.2011 - 10.2011

Oracle Programmer

The National Alliance for Insurance Education & Research
06.2010 - 03.2011

Database Developer (Database Conversion Specialist)

McLane Advanced Technologies
08.2008 - 05.2010

Database Developer

Knowledgeable & Innovative Technical Solutions, Inc. (KITS, Inc.)
08.2005 - 08.2008

Database Program Manager

Tarleton State University
03.2005 - 06.2005

Bachelor of Science - Computer And Information Systems

Tarleton State University

Master of Science - Computer Information Systems

Tarleton State University

Similar Profiles

CREATE PROFILE