Galen Long

Galen Long

Field Production/F&C Engineer, E.I.T.

Followers of Galen Long816 followers
location of Galen LongCalgary, Alberta, Canada

Connect with Galen Long to Send Message

Connect

Connect with Galen Long to Send Message

Connect
  • Timeline

  • About me

    Data Professional ◼️ Data Engineering & Analytics ◼️ An engineer unlocking the potential of our Big Data world

  • Education

    • Southern Alberta Institute of Technology (SAIT)

      2021 - 2021
      Data Analytics Post-Diploma Certificate [EDGE UP 2.0 Program] Data Analytics

      Curriculum covered:- SQL coding & querying (DML, DDL)- ETL operations & data warehousing; star & snowflake schemas- Microsoft Power BI - Data cleaning, schema development, visualizing & dashboarding- Python - Introductory coding, including the use of pandas, numpy, sklearn, gensim & spacy libraries- IBM SPSS - Data pipelines, data cleansing & model training- Cloud-based data services, specifically those offered through Microsoft Azure- Capstone project involving… Show more Curriculum covered:- SQL coding & querying (DML, DDL)- ETL operations & data warehousing; star & snowflake schemas- Microsoft Power BI - Data cleaning, schema development, visualizing & dashboarding- Python - Introductory coding, including the use of pandas, numpy, sklearn, gensim & spacy libraries- IBM SPSS - Data pipelines, data cleansing & model training- Cloud-based data services, specifically those offered through Microsoft Azure- Capstone project involving unsupervised machine learning through topic modeling and the use of gensim, scikit & spacy libraries Show less

    • Texas A&M University

      2016 - 2016
      PETE665 - Petroleum Reservoir Engineering Petroleum Engineering A
    • University of Alberta

      2006 - 2011
      Mechanical Engineer Engineering 3.6
  • Experience

    • Talisman Energy

      Jun 2011 - Mar 2015
      Field Production/F&C Engineer, E.I.T.

      • Executed production optimization and engineering construction projects, with data analytics tasks related to trending production, assessing real-time well performance visuals based on on-site IoT devices, economic modeling and KPI reporting • Optimized production from over 150 wells by using a third-party production database system to produce trend graphs, identifying underperforming wells that needed attention• Produced and updated pipeline construction KPI visualizations by inputting project data into Excel and generating line and bar chart visuals that were easily understood by engineering and field managers• Interpreted large production datasets by executing a custom table export from a 3rd party database system which ranked wells in order of optimization potential and reduced the analysis time by at least 10 hours a month• Championed a new well monitoring system where on-site IoT sensors transmitted temperature data to a 3rd party cloud-based platform, allowing for critical decisions to be made quickly to prevent $30,000 or more in repairs • Interpreted large, complex and unstructured production datasets to optimize oil well production by designing and implementing an Excel database that rank ordered wells by highest oil production optimization potential Show less

    • ROIL Energy LLC

      Oct 2015 - Sept 2016
      Exploitation Engineer (Contract)

      • Executed oil & gas asset evaluation and engineering duties, with data analytics tasks related to production analysis, economic modeling, and drilling prospect evaluation as the sole engineer of a start-up energy company• Generated a complex Excel-based economic model that used a custom production decline formula to output a simple chart visual of drilling prospects ranked by ROIs, which allowed the CEO to easily select the top prospect - with a 4:1 ROI - to raise funds for• Impressed the CEO to an extent that when the company could not secure funding for a desired drilling project, a glowing personal reference was made to Fletcher Petroleum Show less

    • Fletcher Petroleum Corp.

      Sept 2016 - Nov 2020
      Senior Production Engineer

      • Executed production optimization and engineering duties, with data analytics tasks related to trending production data and economic modeling, as the sole engineer of a $30M oil & gas exploration company• Managed the production of over 130 wells through the daily analysis of graph and table production visualizations from data hosted both on-premises and in the cloud, resulting in targeted optimization efforts and ease of reporting to management • Constructed a database to house project budgets and real-time expenditures, allowing for percent variances and overspending to immediately be seen, which saved time for the finance department and management• Created a KPI table to track the drilling and wellsite construction performance of new Alabama wells, which resulted in insight into how activities could be adjusted to match or exceed the current pacesetting well• Introduced an Excel-based economic model, at $0 cost to the company, that incorporated key well economic parameters to produce a visual that was easily understood by management and could be used to assess other wells• Evaluated net present value graph forecasts - created by third-party engineering firms - of over 100 wells for an annual bank report update and always identified at least 5-10 wells with incorrect low valuations, which led to at least $250k in value additions Show less

    • DealsGroove

      Nov 2020 - Aug 2021
      Founder

      • Conceptualized and built an e-commerce store from the ground up, selling consumer products to customers worldwide, with a planned eventual pivot to selling helium online • Paused work in order to focus on SAIT data analytics program (EDGE UP 2.0 program)

    • Polyseam

      Jan 2022 - Apr 2022
      Data Engineer

      • Executed data engineering tasks related to testing proprietary software and validation of related documentation for a startup data orchestration software company• Developed a demo based on a Python NLP script to showcase proprietary technology to increase the conversion rates of prospective buyers• Acquired key skills in Apache Airflow, Kubernetes, Github, VS Code, Docker and Google Cloud Platform virtual machines - through both self-initiated study and collaboration with developer co-workers - to create Airflow DAGs to be used in demos to increase sales Show less

    • Chata

      Apr 2022 - now
      Integrations Analyst

      Completing analysis of client databases and developing SQL code that will perform required queries

  • Licenses & Certifications

    • Advance Your Database Administration Skills

      LinkedIn
      Jul 2025
      View certificate certificate
    • Data Analytics Certificate of Achievement

      Southern Alberta Institute of Technology (SAIT)
      Jan 2022