Duane Dieterich
Home Page
Project maintained by DDieterich
Hosted on GitHub Pages — Theme by mattgraham
Your suspicions are correct. We are not here because of random chance. There is a Creator and He loves us so much that He allowed His only Son to be sacrificed to pay for our sins and save us all.
Psalms 111:10, “The fear of the Lord is the beginning of wisdom; all those who practice it have a good understanding.”
Links
Personal
- Send Me Email
- @DuaneDieterich on X - Free speech social media platform.
- Freedom of Religion - Do I have the freedom to practice a religion …
- Church Audio PDF
- Church Memberships:
- Messiah Lutheran Church, Plano, Texas
- Lamb of God, Flower Mound, Texas
- Grace Lutheran Church, Seguin, Texas
- Mt. Olive Lutheran Church, San Antonio, Texas
- Concordia Lutheran Church, San Antonio, Texas
- St. Paul Lutheran Church, Waco, Texas
- St. Mark Lutheran Church, Waco, Texas
- Boy Scouts of America Alamo Area Council
- Cub Master: Jan. 2007 - Jan. 2008, Seguin, Texas
- Tiger Cub Leader: Jan. 2006 - Jan. 2007, Seguin, Texas
- Included attending training, recruiting cub scouts, arranging field trips, filing reports, and organizing den/pack meetings.
- Private Pilot 583 hrs, Instrument Rated, SE Land Airplane, Complex Endorsement
- 1958 Cessna 175
Professional
- DMSTEX - Advancing automated software engineering for relational technology.
- LinkedIn - Business and employment focused social media platform.
Publications
Open Source Projects
- ODBCapture - Native PL/SQL Application to Capture Source Code and Configuration Data.
- Wiki Based Issues - Wiki Based Issue Tracking System for GitHub/GitLab.
- wtPLSQL - White-box testing framework for Oracle database objects.
- utPLSQL_Lite - Intended to be a seed for utPLSQL version 3.
- DTGen Project - Data driven source code generator for Oracle DDL and Oracle APEX files.
Oracle Services
Work Experience
Feb. 2015 - Present: Richardson, Texas
Proprietor - Self-employed
Jul. 2023 - Feb. 2024: (Remote) Fresno, California
Update:
Senior Application Development Engineer
- Continuation from TEKsystems contract.
- Created Solaris scripts and Oracle PL/SQL to load and process a variety of files for the Pharmacy Benefit Manager.
- Corrected a variety of problems with transaction processing, state transitions, and error handling in Oracle database.
- Developed Excel spreadsheets to generate SQL Table and SQL*Loader column definitions.
- Created comprehensive documentation to include ERD, state machine, and logic flow diagrams.
- Developed other misc. ETL and synchronization packages.
- Worked with multiple Git branches under simultaneous development.
- Developed a custom set of re-runnable unit test scripts for Solaris File Loading Scripts and for Oracle Database Packages. (Software security constraints did not allow outside unit test frameworks.)
Oct. 2022 - Jul. 2023: (Remote) Charlotte, North Carolina
Oracle PL/SQL Developer
- Contracted to Centene Corporation.
- Created custom MS-Excel to generate test data.
- Created schema and data load scripts for Oracle database.
- Analyzed, repaired, and created Solaris shell scripts.
- Created and implemented custom unit test utility for shell scripts.
- Development tools included: SQL*Developer, VS-Code, Putty, GitLab, and Jira.
Oct. 2015 - Mar. 2022: Richardson, Texas
Update:
Oracle Database Architect
- Key contributor to state of the art CI/CD implementation for Oracle database. Specific contributions include:
- Created custom PL/SQL package to generate database source code with schema and data using DBMS_METADATA, including binary images stored in database, Java source, Java fine grained permission, XML ACL network access permissions, and out-of-sequence cross-schema object dependencies (grants, indexes, and triggers).
- Created stub schema and “loopback” database links to resolve compilation errors from unresolved database link targets.
- Created custom SQL build script that creates entire database with seed data in a new PDB, runs wtPLSQL unit tests, creates JUnit XML for Jenkins reporting, unplugs and zips PDB for storage on Nexus server.
- Created custom Linux scripts to setup, list, load, and remove complete databases in local docker containers from PDB zip files stored on a Nexus server.
- Created comprehensive Wiki site for all database/PDB setup and operational procedures.
- Provided critical support of database rollout from Intel to SPARC technology (unable to clone between these platforms).
- Instrumental in avoiding the removal of crucial account balance shared locking in enterprise application.
- Identified, corrected, and deployed major correction to data encryption package in Oracle database.
- Helped troubleshoot and resolve numerous daylight savings and time zone storage and usage issues.
- Created comprehensive enterprise E-R Diagrams of entire tolling system using SQL*Developer Data Modeler.
- Created spreadsheet that generates required SQL to update toll rate plans.
- Helped resolve and implement various tolling functions like discount and special rates, registration hold/scofflaw processing, cash management and bank deposits, and invoicing.
- Supported resolution to numerous issues during go-live.
- Developed and delivered Continuous Build and Test (CBT) training courses and seminars.
- Seminar: CBT Database Brancing in Git
- Training: CBT Database Capture
- Training: CBT Build Process
- Training: CBT Development Process
- Training: CBT Unit Testing
- Training: CBT Final Releaese Process
- Seminar: CBT Synchronization
- Seminar: CBT Sample Exercise
- Seminar: CBT Review
May 2015 - Oct. 2015: Plano, Texas
Sr. Database Developer
- Contracted to ETC (Electronic Transaction Consultants).
- Corrected errors and coordinated fixes in “Master Change Fund” design.
- Implemented “Master Change Fund” design in Oracle PL/SQL.
- Implemented full “utPLSQL” testing for “Master Change Fund”.
- Repaired “Mismatch Process” testing problems.
- Completed major reconciliation/update of data configurations in “Master Control Document”.
- Located/confirmed/corrected 4 major errors in “Interoperability” documentation.
- Consolidated PL/SQL Coding Standards and developed compliant formatting rules for SQL*Developer and SonarQube.
- Fixed several minor defects.
Feb. 2014 - May 2015: Irving, Texas
Sr. Database Developer
- Worked on “thankyou.com” platform for Citibank.
- Supported 24/7 Oracle 11g database operations and application/platform troubleshooting.
- Significantly improved use of “ManageEngine” Application Manager monitoring tool.
- Developed batch processing capacity model with observed data validation.
- Documented, developed, and implemented numerous solutions, including LSP to Amazon data updates with throughput pacing and member tier check with multi-threaded processing.
- Developed and presented 2 Seminars
- “Message Logging Options in the Oracle Database”
- “PL/SQL Call Tree Reporting and Review of PLSCOPE”
Sep. 2011 - May 2015: Flower Mound, Texas
Update:
- Moved to Dallas County as DMSTEX
Proprietor
- Developed and delivered custom federal government procurement reports to Cross Timbers Procurement Center.
- Deployed prototypes and Continuous Integration (CI) for Oracle 11g database on Amazon Web Services.
- Developed Data Warehouse prototype for “fedcontractintel.com” including Atom XML feeds, snowflake design, custom multi-stage loading of Oracle 11g database. Assisted with Oracle 11g licensing requirements and limitations.
- Developed Product/Servce Overview Videos
- DDGS Deliverables
- DDGS Generated API
- DDGS Generated Data Handling
- DDGS Generated Subtypes
- DDGS Generated History/Audit
May 2011 - Sep. 2011 Irving, Texas
Update:
Sr. Technical Consultant
- Learned Oracle 11g Exadata and assisted with a successful Oracle 11g Exadata Proof-of-Concept (POC) for Noble Energy.
- Upgraded Pro*C programs to Oracle 11g Exadata for Argo.
- Developed a PowerBuilder Library (PBL) converter using Yabasic. Generated 1.2 million lines of Oracle11g PL/SQL code using the converter, saving the Cirro project an estimated $250K-$500K in manual coding efforts.
TEXOra (Guadalupe County)
Oct. 2010 - May 2011: Seguin, Texas
Update:
- Moved to Denton County as DMSTEX
Proprietor
- Developed and published Database Source Code Generation Tool for Relational Designers as Open Source on Google Code.
- Developed an Oracle 11g database to PayPal interface for a Community News and Classified Ads prototype system.
Jul. 2010 - Oct. 2010: Atlanta, Georgia (Remote)
Database Architect
- Designed, built, and tested a “monitored object” MS SQL Server database for Alcatel-Lucent.
- Onsite work done at Bank of America in Plano, Texas.
- The system was successfully demonstrated with the database.
- The database included full referential integrity, transaction control, and multi-threading coordination.
Apr. 2009 - Jun. 2010: San Antonio, Texas
Sr. Consultant
- Development DBA for the US Army Workload Management System for Nursing technology refresh project.
- Performed task management, logical model design, database generation, PostgreSQL implementation, and Oracle implementation,
- Developed custom ETL business logic and star-schema data warehouse storage using PL/SQL.
- Developed a data driven source code generator for PostgreSQL using GNU/Unix shell scripts.
- Converted generator for Oracle 10g source code generation for final system delivery.
- Developed a data driven test data generator for PostgreSQL using GNU/Unix shell scripts, which I also converted for Oracle 10g for final system delivery.
- Completed ETL performance testing using generated test data.
Apr. 2004 - Apr. 2009: San Antonio, Texas
Sr. Research Engineer
- Technical contributor to the Veterans Health Administration Replacement Scheduling Application project.
- Optimized core search function on Oracle 9i database (7x improvement).
- Developed Oracle Designer and Oracle 9i Database configuration management and deployment strategy.
- Developed an Excel based Oracle 9i data loading utility.
- Created a mid-tier performance test simulator using data collected from the Oracle trace utility.
- Developed a comprehensive technique for task management that included reconciling MS Project with timecard/financial system.
- Task lead on the Skills Database Development and Training System and the HealtheVet Reports Engine Quick Look Internal Research & Development project.
- Lead effort to obtain Southwest Research Institute’s (SwRI) membership as an Oracle Partner.
- Built an Oracle 9i Real Application Cluster (RAC) “from the ground up” on AIX servers and Dell SAN (Brocade Fabric Switch and EMC Clariion).
- Funded Projects:
- Awarded and completed the “Sub-$500 Database Server” Technical Advancement (TA) project using National Oceanic and Atmospheric Administration (NOAA) Integrated Surface Hourly (ISH) data on an Oracle 11g database.
- Demonstrated 2,000 record/sec load rate on an indexed table with over 300,000,000 records and 6 to 17 second response time for complex queries that on the same table.
- Developed and demonstrated KML output from Oracle 11g database to dynamically map data elements on Google Earth.
- Completed follow-up consulting for U.S. Air Force (USAF) Recruiting Service (AFRS) project.
- Presentations:
- Authored and presented “Oracle for Project Managers” at the September 2005 SwRI Developers Forum.
- Co-authored and presented “Oracle Partner Network” at the January 2006 SwRI Developers Forum.
Mar. 1997 - Apr 2004: San Antonio, Texas
Update:
Technical Lead
- Responsible for the hiring, direction, and performance of up to 32 technical consultants.
- Played a key role in reducing turnover, growing the local practice, and establishing employee review policy for the corporation.
- Key technical contributor on projects for
- San Antonio City Public Service (CPS)
- U.S. Air Force (USAF) Recruiting Service (AFRS)
- Air Force Information Warfare Center (AFIWC)
- U.S. Long Distance (now Qwest Communications)
- The Psychological Corporation (Harcourt).
- Presentations:
- Authored and presented “Custom Application Development with PL/SQL Server Pages” at the June 2003 Oracle Tech Day in San Antonio, Texas.
Jun. 1986 - Mar. 1997: Seguin, Texas
Update:
Sr. Manufacturing Engineer
- Involved with two major Computer Aided Manufacturing (CAM) projects.
- Instrumental in the implementation of a state-of-the-art shop floor system
Education
1988: College Station, Texas
BS, Industrial Engineering with a focus on Automated Manufacturing
Activities and societies:
- Dec 1986 Distinguished Student Award
- May 1986 Distinguished Student Award
- 1986 National Dean’s List
- 1985 National Dean’s List
- 1984 McLennan County Texas A&M Club Scholarship
1984: Waco, Texas
Activities and societies:
- 1983-84 Certificate of Merit for Outstanding Scholarship in Engineering
- 1983-84 Student Supreme Court Chief Justice
- 1982-83 Student Supreme Court Clerk
1982: Robinson, Texas
Activities and societies:
- Varsity Football
- Marching Band
- Concert Band
- Stage Band