Bryan Ferguson

Responsible for developing and maintaining end-to-end Data Warehouse and GIS systems

Responsibilities

• Directing team consisting of 32 employees and contractors located in Houston, Calgary, Cleveland, and Long Beach
• Business lead on development of mobile data collection applications to optimize field data capture, analytical, reporting, and dashboard capabilities
• Developed and maintain long-term vision and roadmap of GIS system within Plains and its overall integration within IS/IT Enterprise Technology Plan

Lead teams handling

• Data validation and loading of newly constructed pipeline assets
• Management and upkeep of two (2) GIS PODS databases and supporting datasets
• Local, state and federal data reporting requirements (License to Operate) of pipeline and facility assets
• Development and Management of Esri GIS applications
• Web mapping applications and custom mapping support
• Management and integration of third-party GIS datasets
• Direct multiple vendors in support of GIS team and business customer needs

Successes

• Lead transformation of GIS system to Azure cloud to reduce overall operating costs by 15%, minimize downtime of critical data streams, and provide access across Plains Operational environment
• Lead and completed 35 mobile data collection applications supporting teams across organization (HSE, Operations, Business Development, Commercial, etc.)
• Business lead on syncing Maximo work management system and GIS PODS databases to reduce redundant/out-of-date data and defining authoritative data source
• Partnered with IS/IT teams for four (4) GIS Esri software upgrades within 6yr timeframe to address deprecating software and reduce application downtime
• Lead GIS and Integrity team transition of ~8500 miles of pipelines into PODS database model
• Business lead on update to web mapping application to fix deprecating software platform, address user requirements, and replace aging back-office infrastructure
• Eliminated backlog of 8yrs (~18,000) of missing data updates for existing pipelines to restore data confidence and usability for business users
• Completed data loading of ~550 newly constructed pipelines within 3yr window to avoid PHMSA/DOT regulatory fines/NOV
• Developed series of metrics, dashboard, and reporting capabilities to support leadership, provide accountability, and drive growth of GIS across organization
• Reviewed source documents and listings to compile resources for identifying and correcting data issues

Responsibilities

• Oversee three (3) PODS database implementations (~40,000 miles) across US and Canada
• Manage and direct team of 20 in Houston, Tulsa, and Salt Lake City
• Provide support for annual PHMSA requirements per Pipeline Safety and Risk Teams
• Manage annual NPMS submittals and support for all of Williams
• Part of overall integration efforts for Williams Enterprise PODS implementation within 24 month timeline
• Directed team for annual alignment sheet and Structure Verification sheets in support of PHMSA regulations
• Supported Verifiable, Traceable, Complete actions to support PHMSA regulations

Successes

• Integrated 2 PODS database implementations in 2015
• Revamped workflows and SOP for all core PODS database inputs from GIS users
• Redefined standard alignment sheet templates
• Defined standard metrics (KPI) of data inputs into PODS for Leadership Team
• Implemented new data submittal process (Service Now) within team
• Reduced turnaround times from over 100 days to less than 50 days
• Directed team to complete backlog of outstanding PODS changes (4500 outstanding requests) between, Worked directly with Safety and Risk teams to support audit and updated regulation changes

Responsibilities

• Implemented Enterprise GIS system to address immediate needs of Biofuels Agricultural and Land Teams
• Developed field Taxonomy naming structure and workflow process for future field and farm development
• Created folder structure in SharePoint for long-term file management and compliance requirements
• Migrated all Agricultural process documents into OMS system
• Key team member for Land and Farm Management software implementation teams during early stages of project management (CVP) lifecycle

Successes

• Implemented Cloud based GIS system within 4 months of arriving in Biofuels
• Implemented field Taxonomy and workflow process
• Rolled out SharePoint folder structure for use by Agricultural Team
• Migrated over 100 process documents into OMS
• Devised and implemented reliable data management procedures to enable usability and security of company data
• Deployed optimal reporting software and developed dashboards and reporting systems for data summaries

Responsibilities

• Directed and implemented Enterprise GIS (Geographical Information System) Program for BP USPL from inception – 10+ years
• Manage multiple GIS IT related projects ranging from $50k to $2.5m
• Maintain an operation/development budget of >$1m/yr
• Communicate GIS Program Updates and Key Performance Indicators (KPI) to USPL Leadership and parallel Project Teams
• Lead implementation and data quality assurance review during implementation of Pipeline Open Data Standard (PODS) database model for USPL business unit
• Integrated Integrity Management Plan activities/deliverables from the GIS implementation to support federal regulatory requirements
• Developed data management workflow processes within Enterprise GIS Program
• Implemented Standard Operation Processes (SOP) related to Enterprise GIS system
• Integrated GIS Program Processes into internal data management workflow systems
• Held annual and spot training for all GIS customers/users
• Provided Help Desk support for technical difficulties of vendor applications and overall IT issues for GIS system
• Validated with Land Team to ensure landowner information was up-to-date for new alignment sheet development

Successes

• Reduced turn-around efficiency for drawing updates from >200 days down to >60 days
• Lead team that loaded 12+ million records into GIS Relational Database Model over 7 year timeframe including all available history of each pipeline operated by USPL
• Developed and updated USPL standardized Alignment sheet drawing templates for over 6500 miles of pipeline
• Delivered data and analysis output for Integrity Management Plan, DOT 192/195 regulatory requirements, and HCA identification through GIS system
• Reviewed and implemented eight (8) new vendor applications for internal GIS business teams

Additional Responsibilities

• Participated in internal and external Safety and Operational (S&O) Audits for drawings and data management
• Member of cross-functional team that created Taxonomy naming structure (standard database equipment naming structure) for BP Pipelines (USPL)
• GIS SME of project that rewrote format and requirements for Repair and Inspection report to streamline field data capture
• Joint development of new GIS applications and data management (PODS) with BP Exploration & Production (Houston, TX) and BP Alaska (Anchorage, AK)
• SME on selection team for update of Land Management software for USPL
• Volunteered as GIS Lead assisting BP personnel during Hurricanes Katrina, Rita, and Ike

• Lead local GIS development for Gulf Oil Spill in Robert, LA and Mobile, AL
• Directed multiple vendor and team members for daily deliverables of GIS maps and supporting data
• Member of GIS Team developing Enterprise GIS solution in BP offices in Houston, TX in support of Gulf Oil response
• Provided daily GIS updates and overall needs assessment to BP and Coast Guard Leadership Teams in Robert, LA and Mobile, AL
• Directed small agile team on development of Subsurface Oil Observation Program application, data collection, daily output, and overall data management – Mobile, AL
• Interfaced with multiple federal (Department of Transportation, Homeland Security, National Oceanic Atmospheric Administration(NOAA)), military (Coast Guard, Army, National Guard), state, and local agencies teams regarding GIS and data collection and timely dissemination of information