Home

ENERGIZE YOUR DATA ASSETS

Formed by a Life Long Data Enthusiast, FlynLoch specializes in helping clients quickly leverage electronic data and technology to improve processes and time to execution while decreasing manual clerical tasks.  The result is improved data quality, a forward looking data strategy, and realization of the value of data assets.  Having better and timely data allows your personnel to spend more time affecting the bottom line, as opposed to adding to it.  With over 20 years of experience in database design, application evaluation and implementation and process change, you’ll find FlynLoch delivers immediate value in a short time horizon – and allows your business to be poised to leverage new technology faster.  Get the most out of your SCADA Automation, and back-office applications!!

At FlynLoch, we succeed if you succeed.  Whether you need Data Analytics, Strategy and Integration, FlynLoch can assist you on your data journey.  We have quick-win solutions to get the most value for your business, and position you for mid and long term wins now and into the future.

Data Analytics

Get the most out of your Data Assets – FlynLoch can quick-start your reporting and analytics with industry standard tools like Power BI, SQL Server Reporting Services (SSRS), Spotfire and Tableaux. We specialize in identifying methods to:

  • Identify data that is out of tolerance
  • Automate reporting tasks
  • Exception reporting
  • Cross-application reporting (add context to application-specific data)

Data Strategy

FlynLoch can help you progress in your data strategy. Make sure your employees are not creating “reactive” reporting, and back your business into a corner that requires rework. If you are just starting out, or a mature data driven organization, we can help hone your path to make the most of your Data Assets.

Data Integration

Are you spending unnecessary time entering the same data to multiple systems? Are you unable to get your automated systems to integrate to your business systems? Do you have difficulty analyzing time series data vs corporate relational data? FlynLoch has over 20 years experience integrating systems, from real-time time series data (SCADA) to corporate relational databases (EDW and Application Databases). We utilize numerous tools, but can quickly start your data integration journey with industry standard tools like SQL Server Integration Services (SSIS).

Recent Projects

Production Reporting and Accounting

  • Plunger settings from Infor EAM to Procount (IFS/P2) via EAM Workorder
  • Custom ARIES Forecast Monthly Updates from Corporate Reserves and Engineering Databases
  • Curve Fit algorithm for Daily Forecasts for Smart Alarming via Cygnet
  • Aveva PI (OSI) Integration of real-time oil rates (tank fill based)
  • Custom tank level production and sales allocations to completions from Aveva PI to Carte and SSRS Reporting (using Procount allocation factors)
  • Custom Python algorithm to track inter-lease and inter-pad oil and condensate transfers as “Transfer as Credit” method, with offsetting ticket adjustments at the time of sale as opposed to time of transfer
  • NGL processing and allocation for gas systems in including systems with Vapor Recovery Units (VRU)
  • Custom SQL and SSRS Reporting to validate accuracy of Procount NGL allocations (SQL procedure “hand-allocates” the results to compare against Procount results)
  • Cygnet SCADA to Procount Integrations (tank levels, coriolis, well level pressures, gas meters)
  • Cygnet FMS to Procount Integrations (gas meters)

Peloton Wellview

  • Tubing Component Set Depths with Deviation Survey Inclination Reporting (interpolated inclines)
  • Flowback Statistics Reporting and Analysis
  • Aveva PI Integration of choke set points, max drilling rates, point of entry, lateral length calculations

Real-Time Data (Aveva PI and Weatherford Cygnet)

  • Calculate real-time tank-level-based oil rates (based on tank level changes) – Aveva PI
  • Regulatory reporting of EHS excursions and GHG calculations – Aveva PI
  • Identify Frac Stage key operational points on data signals – Aveva PI
  • Aveva PI Integration of choke set points, max drilling rates, point of entry, lateral length calculations
  • Combustor and Tank graphs sent to individual pumpers – Cygnet and Aveva PI
  • Data excursion alerts to key personnel – Aveva PI and Cygnet

API Integrations

  • Pason HIVE 1 second drilling metrics (hourly updates) to Aveva PI
  • Pason WITSML 1 second drilling metrics (real-time) to Aveva PI
  • Halliburton FracVault completions metrics (post-stage) to Aveva PI and Peloton Wellview
  • Halliburton Frac Datashare (Azure) to Peloton Wellview
  • Halliburton OctivConnect API (post-stage) to Aveva PI and Wellview
  • IWS Frac completions metrics (real-time) to Aveva PI