Sales System a Lottery Winner

 
 
By Matthew Kelly  |  Posted 2005-08-15
 
 
 

Sales System a Lottery Winner


Lottery scratch tickets have always been a source of instant gratification or instant disappointment. At the Indiana State Lottery, Andrew Hendricks experienced the latter.

Hendricks arrived at the lottery in 2000 as sales director, with a mission to raise its profile with (and, consequently, sales to) the public. While he envisioned an overall effort of greater advertising and marketing, he faced a grim situation on the IT front as he tried to derive maximum value from those channels: 55 sales agents roaming the state, visiting 4,200 convenience stores and other lottery outlets, trying to calculate the best mix of games to sell—and not a single electronic tool among them.

Hendricks diplomatically described the lottery back then as "an undeveloped shop. ... Our sales force was not only not using e-mail of any kind, they were basically using pen and paper."

Facing fierce competition from other retailers that craved the lotterys space on store shelves, Hendricks knew he needed to bring his sales force online. The agency already operated a database to track which lottery games sold well; Hendricks simply had to give his sales agents tools to access that information at any time.

Why? More timely data would prevent popular games from selling out and less desirable games from taking up shelf space, and it would boost the "haul rate" of how often a sales agent visited an outlet. Historically, an agent might visit a client every two weeks. Hendricks said the Lottery Commission wants to reduce that time lag to several days.

"If we can see more people in a day," he explained, "that will translate into more sales." Annual lottery sales hit $750 million last year, with $470 million of that coming from scratch tickets.

As often happens with public-sector projects, the Indiana State Lottery (promoted as the "Hoosier Lottery" within the state) took several years to move forward. The Indianapolis-based agency did some preliminary experiments in 2002 and 2003 to determine which real-time tools would work best with its field agents. Last year, it struck a deal with Cole Systems Associates Inc., a systems integrator in New York, to install a real-time data distribution system and outfit Hendricks sales staff with tablet PCs to access that data.

Cole Systems designed a straightforward system: a Microsoft Corp. SQL server housed at lottery headquarters that pulls sales data as needed from the agencys main computer, an IBM AS/400. The Microsoft SQL server runs Coles OrderPad Enterprise application, which manages queries from sales agents and supplies them with the data they need in real time. Sales agents make their queries through an OrderPad client application on their tablet or a desktop PC if they happen to be at a lottery office.

According to Adam Perlow, Coles vice president for technology, the linchpin of the system was the ability to achieve timely downloads even with low bandwidth or poor connections. Lottery agents might tap into the database under all sorts of conditions: from a cellular phone while sitting in a car, via dial-up while eating breakfast or from a broadband connection at the office.

"Your bandwidth can be pretty good, or it can be pretty bad," Perlow said. "We wanted to ensure the sync would be successful even when the bandwidth was really bad."

The electronic brainpower behind that part of the system is PeerDirect, a database synchronization technology developed by Progress Software Corp., of Bedford, Mass. Progress has dabbled in real-time data synchronization for several years; PeerDirect allows more flexible slicing of data so that only the precise data sets necessary are sent to the user—meaning less data overall and better performance at lower bandwidth.

Users, Progress Vice President Kenneth Rugg said, "dont want to know whether theres a network there or not. They want to have a high-quality interaction with their application regardless of network connectivity."

During field tests of PeerDirect last year, Perlow said, users fired some "pretty intense" queries to OrderPad, yet PeerDirect still kept overall CPU usage at tolerable levels.

"During the evaluation, we saw that bandwidth was always the bottleneck. That was important to us," Perlow said, because bandwidth can always be increased. "We didnt want the server to be the bottleneck."

Next Page: Synchronize now.

Synchronize Now


In Cole Systems OrderPad application, sales agents see a button on their tablet that says "Synchronize now." When pressed, it launches the PeerDirect engine, which provides feedback so users can see which data updates must occur. Users can even view graphical representations of new sales data streaming in from a retailer, alerting the sales representative that the customer with high volumes of new data might be worth extra attention.

At lottery headquarters, Hendricks faced a fairly easy implementation, ironically because the lottery had been so woefully behind the times technologically. Cole Systems runs OrderPad strictly on a Microsoft platform, so the lotterys biggest IT expenses were the purchase of a Microsoft SQL server and upgrading its telecommunications network both to handle larger numbers of sales agents dialing in to the system and to distribute upgrade patches as necessary.

How does the system work? At lottery headquarters, the AS/400 manages complete profiles on the agencys retail outlets, including contact information on store managers.

That information, along with "pure raw sales data," Hendricks said, is pumped to the OrderPad server each time a sales agent taps into the system from a tablet PC. OrderPad then sends along fresh, updated data to the agent. Downloads usually take no more than 3 minutes.

"Were supplying all the data; theyre just turning it around and putting it into a format thats useful at the sales reps scene," Hendricks said.

At that location, the agent can show the retailer which games are currently hot sellers in the vicinity. The agent can also determine which games sell well at a particular retail outlet and order more in a timely fashion so the store will not run out of them. At lottery headquarters, meanwhile, Hendricks can study aggregate data about orders to develop more accurate advertising and marketing campaigns.

OrderPad cost the lottery $1,900 per user license, a fee that includes various professional services from Cole Systems. The states return on that investment is somewhat difficult to measure, Hendricks said, because the new system is only one of several coordinated efforts to raise the lotterys profile with Indiana citizens. Still, sales of scratch tickets in the second quarter were 15 percent above year-ago levels.

"How much of that revenue can be attributed to this project? Thats hard to tell, but it has been going well," Hendricks said.

Matt Kelly is a freelance writer in Somerville, Mass. He can be reached at mkelly@mkcommunications.com.

Check out eWEEK.coms for the latest news, reviews and analysis on IT management from CIOInsight.com.

Rocket Fuel