Williams Energy — Y2K Compliance & Pipeline Systems Modernization

Served as a PL/SQL developer and systems designer on a mission-critical Y2K remediation and modernization initiative for Williams Energy's LNG pipeline operations.

Key Contributions

•Reverse-engineered non–Y2K-compliant COBOL systems, capturing business logic and operational requirements to re-architect a modern Pipeline Management System built on Oracle PL/SQL–based ERP software.
•Designed the data model and user interface for the Terminal Automation System (TAS)—a highly secure, automated driver verification and truck-loading platform deployed across distributed pipeline endpoints nationwide.
•Conducted on-site field studies at truck terminals to observe real-world workflows, optimizing automation, throughput, and operational safety.
•Defined hardware and system requirements for terminal installations, aligning software design with physical infrastructure and security constraints.
•Designed the core logic for the Load Allocation System, governing inventory distribution during supply-constrained scenarios using a lottery- and points-based model.
•Developed a market-based allocation trading subsystem, enabling pipeline customers to exchange allocations via an ask/bid mechanism.

Technologies

Oracle PL/SQLCOBOL (reverse engineering)ERP SystemsTerminal AutomationData Modeling