The Business: The StoreRunner Network offers best-of-class retail content and industry leading technologies that enable merchants and empower Internet enterprises with an unmatched shopping experience.
Business Problem: Storerunner had engineered a web site and was in the process of implementing a complex traffic based business model. The company had no business process technology to effectively track activity, capture billable events, produce accounting transactions and understand marketing program effectiveness.
Solution: Contract management, click stream data warehouse, billing and analytic applications were developed to provide insight into business metrics and to produce accurate financial transactions.
Technology Used: Oracle 8i, Informatica Powercenter, Brio Enterprise, Platinum Erwin, Embarcadero DB Artisian, Borland Delphi, Lotus Domino, TeamTrack, Microsoft SQL Server 7.0, Windows NT, Sun Solaris, Microsoft Office, Microsoft Project
Senior Vice President, Information and Content Systems 1/2000 - 1/2001
Led teams that re-engineered back-end systems 3 times in 10 months as a result of web site re-design and financial systems 6 times in 10 months as a result of revenue model changes.
Saved $1,000,000 in annual personnel costs thru employee attrition by re-engineering content acquisition from manual mining of sites to obtaining feeds of catalog data from merchants. This process also significantly enhanced site usability ensuring that all content was accurate.
Provided real-time revenue sharing projections, traffic statistics and shopper click stream behavior to 50 traffic partners via a secure extranet.
Delivered a 45 minute keynote address on Storerunner at the 2000 Informatica User Conference to 600 attendees.
Vice President, Chief Information Officer 8/1999 - 12/1999
Assembled a team of 10 consultants and internal staff in 3 weeks to begin to implement the plan. Obtained budgetary and company-wide approval to begin work. This team built the following custom applications:
- A custom click stream data warehouse in 120 days that supported the company's need for shopper behavior data as well as revenue recognition. This warehouse was 600 gigabytes in size, had 100 entities, and stored 200,000,000 individual web events from 5,000 traffic sources. This system fed information into the nearly constant web site redesign / business model changes occurring at the company.
- 150+ reports that were used to identify shopper behavior, manage customer relationships and provide financial data into revenue and business model forecasting tools. 99% of all ad-hoc requests for information were complete within 24 hours.
- A system to manage 1000 complex variable merchant contracts and produce invoices within 2 days after month end. Accounting personnel spent 2 days per month on accounts receivable.