Michael Ray

Provides consulting services to pipeline and utility clients, focused on GIS, SQL, and integrity management workflows. Manages GIS modernization and data migration to PODS 7 for a US-based pipeline operator.

Lead database architect and subject matter expert for energy-sector asset management solutions. Re-architected database and data management processes to improve performance by more than 50%, and leveraged SQL Server and Oracle spatial capabilities to reduce long data-integration processing times from days to hours.

Managed pipeline and utility industry projects including enterprise GIS design and implementations, data migrations to Oracle/SQL Server, and support for existing GIS implementations. Built a risk-based route optimization process using Python and SQL and led mobile GIS data collection for construction as-built information.

Executed the integrity management plan for Gulf South and Texas Gas pipelines. Managed high consequence area (HCA) identification and validation, performed system-wide risk analysis, and developed SQL/Python/PLSQL tools to integrate risk results with HCA and assessment data.

Gathered requirements, documented workflows, and managed project budget and schedule for pipeline operations, engineering, and integrity management systems. Led web and mobile GIS initiatives, including enterprise GIS/PODS implementation and data migration to an industry-standard PODS model.

Serves on the PODS technical committee for the non-profit pipeline organization that develops pipeline data and interchange standards.

Developed solutions to support pipeline operations and regulatory compliance within a multi-city team. Built backend processes for asset management and pipeline integrity applications, including data integration, assessment planning, and what-if scenario analysis.

Grade: Cum Laude

Earned a B.S. in Computer and Mathematical Science, graduating cum laude.