Cable Network Advertising System
Work with staff of eight consultants to maintain and enhance several Paradox based systems. Together these systems are responsible for managing the entire flow of advertising from Quotations to On Air Scheduling. They process and report on over $200 million in business on an annual basis. My expertise has been applied to design, code and install a true “Production” environment featuring change control, redundant backups, security and alpha and beta development areas.
Categories: Projects Tags: Advertising, DATABASE, Paradox, Reports, Sales, Scheduling, SQL, SQL Server
US Government Mainframe Conversion
Acted as Lead Consultant for an ongoing DOE Conversion effort. Designed and wrote flexible conversion software for converting mainframe data to PC Databases. Reviewed and finalized data element migration between existing mainframe data and new Oracle database. Interfaced with various contractors. Conducted search for additional staff.
Categories: Projects Tags: Conversion, Government, metadata, Oracle, Paradox
WWW Restaurant Guide
Design the “look and feel” of a World Wide Web site for the review and promotion of restaurants on a national level. Conceptualize marketing materials and direct outside consultants in their development. Develop collateral marketing methods and conduct market testing. Design database and automatic HTML “publishing” software. This was done in the days before modern tools like XML, XSLT, XHTML and the like were available.
A separate tool allowed for the ability to create CD-ROMs of the website for various regions of the country.
Cable Network Advertising Sales
For a major cable network, led a small team of developers making enhancements to and deploying a system that provided salespeople with the capability to maximize advertising revenue. It let them quickly scan amongst a large demographic database and cross-referenced with the programming catalog and scheduling system to allow salespeople to suggest the most profitable time-slots and packages available at the time a potential advertiser submitted a inquiry.
Categories: Projects Tags: Advertising, DATABASE, Oracle, Paradox, Reports, Sales, Scheduling, SQL
Access Report Server
Enhance an existing Client-Server reporting tool for one of the world’s premier Cable TV Networks. My contribution consisted of adding several new reports as well as packaging and documenting the system for “Production” use.
Airport Status Map
FedEx Package Tracking
Find A Zip Code
UPS Package Tracking
US Postal Package Tracking