Oracle Autonomous Database is changing business practice
Drop Tank is a small company in footprint–it started with only 22 people–but with an outsized mission to provide loyalty and discount programs to thousands of gasoline retailers. It has been decades since gas stations offered incentives to purchase their products. Last time, in the 1960s, retailers would routinely offer silverware, glassware, and china for fill ups. Alternatively, some would offer Green Stamps–collectable coupons redeemable for merchandise. That was the state of the art for loyalty programs.
All of these arrangements were relatively easy to administer and there was no back-end data to massage. A customer made a purchase and got a reward on the spot. Those were the days! Today’s loyalty programs often capture metadata from the transaction that credits points to a customer’s account and the customer can determine how best to spend them.
Drop Tank started out providing single-use, cents per gallon discount cards to customersin 2012. Today it offers the same fuel discounting scheme but also gift cards and combined offers for gasoline plus consumer packaged goods sold in convenience stores that also sell gas.
Less than five years ago (2016), Drop Tank began designing a back-office system to ride herd on customer gas purchases and the points they accumulated. Any customer could join by adding a phone number which could then be used at the pump to identify the purchaser. The system has been through several iterations in its short life, each time becoming simpler and more efficient and thus better able to support an expanding mission.
When Drop Tank started out, it produced a small black box device that connected to the pumps capturing customer data and purchases for later upload and processing. The device was needed because 65 percent of retailers are independent and have the ability to choose their POS (point of sale) system. This resulted in integration challenges best met by hardware. But less than ten years later, the black box is gone and the latest iteration leverages the Oracle Autonomous Database which enables several important improvements for Drop Tank and its customers.
Drop Tank’s principal partner is Marathon Oil, a vertically integrated petroleum company that leads in oil refining in the US and runs a large distribution network located primarily in the Eastern half of the US, though recent acquisitions have spread the footprint into the West.
Although the original black box solution was good for its time, installing those boxes at more than 3,500 retail locations was time consuming and expensive, requiring a visit to each retailer.
Tim Miller vice president of technology for Drop Tank, was a co-founder of the company and he has run IT since founding so each iteration of the system was his responsibility to develop, deploy, and maintain–all the incentive he’d need to support continuous improvement.
Over time, Miller has been able to replace the black boxes with server-side software for all of the POS systems popular with his customers, the retailers. Importantly, the evolution of technology in the dealer network mimicked and supported the evolution of increasingly sophisticated services provided by Drop Tank to the retailer and, recently to CPG companies. Consider these milestones,
Stage 1, 2012
Initially, Drop Tank functioned as a promotional products company with cards and codes that dropped the price at the pump. Customers didn’t need to enroll in a program to enjoy savings, but Drop Tank had limited ability to leverage data to engage with them.
Stage 2, 2016
The original cents off system was built on Rackspace and was adequate for the need. But by 2016 Miller and a small team designed an improvement that would take the black boxes out of the equation letting the retailer simply connect a POS system to Drop Tank’s headquarters using Oracle Cloud Infrastructure. It made sense because it reduced the time and expense associated with deploying hardware from four hours per site to 30 minutes. Now all of the integration and conversion could be handled by software. It also appealed to retailers who wanted fewer devices behind the counter connecting to other systems and printers. So, simplification was good for all parties.
The dealer network reacted, and Drop Tank’s new retailer signups doubled..
Stage 3, 2018
With its system built and in place and connected directly to the POS systems Miller and his team discovered they could gather additional point of sales data that other systems either were not capturing or, because there were so many disparate systems in use, no one could easily aggregate. This was in stark contrast to the way other retailers could capture data and provide it to CPG companies. For example, supermarkets can routinely report to CPG vendors not only what sold but what other items made up the transaction.
Enabling business analysis with Oracle Autonomous Data Warehouse
Drop Tank discovered that it could collect data that CPG vendors needed and also provide more information to a growing set of CPG vendors. But the company needed a data warehouse that could handle the load while enabling the company to retain its small size, now a 22 people business. So, finding the right amount of automation was critical. That’s when they turned to Oracle.
While Drop Tank captures a great deal of data in its data warehouse, there are always times when CPG companies might want specialized information that’s not easily available as the system was set up.
It’s a common problem. For years data warehouse users have tried to build a perfect warehouse containing every kind of data and every possible analysis, but that’s not real. So, Miller took the company in a different direction. Today he says, “Don’t try to build a data warehouse that’s perfect, instead, leverage the power of the Autonomous Database,” which he does.
When a CPG customer makes a special request, Miller says that, thanks to the Oracle Autonomous Data Warehouse, Drop Tank can simply spin up a new database automatically in about an hour without the traditional overhead of building, tuning, and maintaining it. “Spinning up a traditional database and tuning it can take days or weeks. Within an hour I can have the database running, within 4 hours we can load data and then within another hour we can have answers. That’s as difference-maker.”
Oracle technology has enabled Drop Tank to grow in several ways. Oracle PaaS and IaaS have enabled the company to run its IT in the cloud using a service-oriented architecture (SOA) that helps the company reduce overhead and save headcount. Oracle Autonomous Database enabled the company to branch into providing information services to CPG companies from its starting point as a loyalty program provider. And, Oracle automation has enabled this small company to remain small in headcount but to continue to grow its services while significantly increasing productivity.