MTV Networks S-LINK

offsiteteam developed and is continuing to enhance and support a large enterprise applications which provides all the tools necessary for managing the affiliate segment of MTV Networks business. Various modules of S-LINK cover the work flow from Signal launch (Device Activation) to Billing and Invoicing. The following is a short list of the main modules of the application:

• Account Management
• Contacts
• Mailing Lists
• Device Management
• Billing Transactions
• Contract Management
• Promotions
• Reporting

The system is used by hundreds of people in the Sales, Marketing, Finance, Operations and Business Development departments and interfaces with mtvn.com extranet application, JD Edwards A/R, Business Objects, Khalix Analytical Tools as well as Motorola and Scientific Atlanta controllers for Device Management uplink transactions.

An integral part of the system is a Custom Billing Calc module which is used to calculate rate and revenue for all MTV Networks affiliates. S-LINK also serves as the main source of marketing information and is used for managing MTVN promotions and events.

Technologies and Tools: Powerbuilder 9.0, C# .NET, ASP.NET, ADO.NET, MS SQL Server 2000, ErWin

MTV Networks Events Management

offsiteteam developed a web-based Events Management application for MTV Networks. The application allows users to enter and maintain information about marketing events such as the MTV Music or Movie Awards and track information about people invited to and attending the event.

Technologies and Tools: C# .NET, ASP.NET, ADO.NET, DHTML, MS SQL Server 2000, ErWin

SOX Dashboard

"SOX Dashboard" web application is used by the MTV Networks Internal Audit department to manage the SOX Controls, Tests and Evidences. Control owners (managers at various departments) submit Evidence files for each of their controls. Evidence files are stored in the database and are then reviwed by Testers and approved by Reviewers. Executive Reports are then produced and presented to top managament on quarterly basis.

Technologies and Tools: .NET, C#, Infragistics Controls, MS SQL Server 2000, ErWin

Showtime Networks ARS

offsiteteam developed and continues to enhance and support an "Affiliate Revenue System" for CBS Showtime Networks. System provides deal management, rate calculations and revenue management transactions and reports. Rates and Revenue are calculated and stored at a very low level and the MS SQL Server based calculation process updates and re-calculates millions of records daily.

Technologies and Tools: PowerBuilder 6.5, MS SQL Server 2000, Borland StarTeam

Showtime Networks AMMO

offsiteteam provides maintenance and support for SNI "Affiliate Marketing Material Orders" application.

Technologies and Tools: PowerBuilder 6.5, Sybase ASE 12.0