Back to all experience

June to August 2021

Cloud Engineering Intern at Dover Fueling Solutions

I helped move two petabytes of company archives to Azure and wrote the code that turns gas-station transactions into reports.

Role
Cloud Engineering Intern
Where
Austin, Texas
When
June to August 2021

The business

Dover Fueling Solutions, part of Dover Corporation, makes what a fuel station runs on: the dispensers, the payment terminals built into them, the tank gauges and the software behind the counter. Wayne and Tokheim are two of its brands, and its headquarters is in Austin.

Every fill-up and every purchase leaves a record. For a station owner that data says what sells and when. Turning it into reports an owner can read is part of what a fueling company can offer beyond the hardware.

The problem

Two things stood in the way. Years of company archives sat on a legacy SAP server, and station transaction data arrived raw from the site controller, too messy to report on.

What I built

  • The transfer application. A C# application that sorts transaction data coming off Verifone Commander, the controller that runs a station’s registers and pumps, and sends it to Microsoft Azure.
  • The cleaning algorithm. An algorithm that cleans and wrangles that transaction data into business intelligence reports.
  • The archive migration. Carried out the transfer of two petabytes of company archives from the legacy SAP server to Azure.
  • The meeting. Ran the interns’ weekly DevOps meeting with senior management, which kept the projects organized.

Station data

  1. Verifone Commander at the station
  2. C# sort and transfer
  3. Microsoft Azure
  4. Clean and wrangle
  5. Business intelligence reports

Company archives

  1. Legacy SAP server
  2. Two petabytes of archives
  3. Microsoft Azure

What changed

  • 2 PB

    of archives moved off a legacy server. That is two million gigabytes.

  • Raw to report

    Station transactions go from controller output to something a business can read.

  • Weekly

    DevOps meeting with senior management, run by an intern.

What I used

  • Language: C#
  • Platform: Microsoft Azure
  • Platform: SAP
  • Tool: Verifone Commander
  • Skill: Cloud migration
  • Skill: Data wrangling
  • Skill: Business intelligence
  • Skill: DevOps