Description
This is a PPT highlights on Automated Management of Broadcast Activities.
System for Automated Management of Broadcast Activities
SAMBA
RAJIV ADVANI (101) VEDA IYER (115)
CHETAN KALE (119)
AKASH KARNIK (124) KUMAR GAURAV (129)
BUSINESS NEED
?
1st system was Television Management System which was used for managing bookings for Advertisements There was a need for an Integrated Television Management System as business was growing Mission Critical Decision Taking modules were required to align with business as Strategic Information Systems
?
?
?
Data was growing at a tremendous pace which required more storage capacity and wider scope of data access
STRATEGY
? ? ? ?
Requirement Definition Document was outsourced The database was created as per the document
Small project groups and teams were created
Reviews at regular intervals with functional members
IMPLEMENTATION
CREATION OF SAMBA
The client server technology on Dec Alpha Server with D2K as the front end and Oracle 7.x as the back end with UNIX as the O/S was used. The following modules were to be incorporated in the SAMBA system: DREAMS – DIGITAL RIGHTS MANAGEMENT PROGRAM PLANNER – FOR PROGRAMMES AD-SALES – FOR ADVERTISEMENT SALES BILLING – FOR ADVERTISEMENT BILLING ACCOUNTS RECIEVABLES – COLLECTION
?
? ? ? ?
INDIA IMPLEMENTED Programming Prod Legal
FPC RIGHTS MANAGEMENT
SINGAPORE
PROGRAM PLANNER
Agency or Advertiser
R.O. DEAL
Sales Person
T.O.
Sales Coordinator ENTERPRISE
Sales Coordinator AD SALES
ENTERPRISE SCHEDULING
Revenue Management BILLING ACCOUNTS RECIEVABLES
BILLS
MET
?
REQUIREMENTS
Since the management of deals was done manually in excel a Deal Tracking System was required in India Since the bills received from Singapore were reentered automatic generation of Client wise bills was required The Traffic Orders were being faxed to Singapore which required an audit trail to be maintained for the document
?
?
IN PROGRESS
?
Since the maintenance of Enterprise in Singapore was millions of dollars alternative would be to use SAMBA
INDIA PROPOSED Programming Prod Legal
FPC RIGHTS MANAGEMENT
SINGAPORE
PROGRAM PLANNER
Agency or Advertiser
R.O. DEAL
Sales Person
T.O.
Sales Coordinator AD SALES
Sales Coordinator AD SALES
TRAFFIC SCHEDULING
Revenue Management BILLING ACCOUNTS RECIEVABLES
RUN LOGS
RELOCATION OF INFRASTRUCTURE AND DISASTER RECOVERY SITE
ONSITE PROBLEMS
Issues ? High content of sulphur in atmosphere ? Corrosion of all hardware components ? Downtime of system affected business ? Vendors AMC’s were getting affected ? Extensive working hours for technology Action: Scrubbers and special air filters installed Result: Frequency of system downtime reduced Solution: Relocation of Infrastructure & Systems
INFRASTRUCTURE
Performance
Network response time is good with no latency ? Application running fine with limited no of users ? SAP standard programs running fine with load
?
Issues ? Application freezes as no. of users increases ? SAP customized programs running very slow
Action: Increased memory to 32 GB Action: Database tuning in progress Solution: Convert to 3tier architecture
BENEFITS
?
? ?
Managed Infrastructure with 99.9% uptime
Daily Log monitoring and backup of data Three levels of physical security in premises
?
24 * 7 support on systems and 3 tier backup
SAMBA – The System
? Multi channel operations
? Multi currency operations
? Audit trails for transactions ? Security and Administration
PROGRAM PLANNER – FPC Screen
AD SALES – Release Order Screen
AD SALES – DEAL SCREEN
BILLING – Reconciliation Screen
Thank you..
doc_530318119.ppt
This is a PPT highlights on Automated Management of Broadcast Activities.
System for Automated Management of Broadcast Activities
SAMBA
RAJIV ADVANI (101) VEDA IYER (115)
CHETAN KALE (119)
AKASH KARNIK (124) KUMAR GAURAV (129)
BUSINESS NEED
?
1st system was Television Management System which was used for managing bookings for Advertisements There was a need for an Integrated Television Management System as business was growing Mission Critical Decision Taking modules were required to align with business as Strategic Information Systems
?
?
?
Data was growing at a tremendous pace which required more storage capacity and wider scope of data access
STRATEGY
? ? ? ?
Requirement Definition Document was outsourced The database was created as per the document
Small project groups and teams were created
Reviews at regular intervals with functional members
IMPLEMENTATION
CREATION OF SAMBA
The client server technology on Dec Alpha Server with D2K as the front end and Oracle 7.x as the back end with UNIX as the O/S was used. The following modules were to be incorporated in the SAMBA system: DREAMS – DIGITAL RIGHTS MANAGEMENT PROGRAM PLANNER – FOR PROGRAMMES AD-SALES – FOR ADVERTISEMENT SALES BILLING – FOR ADVERTISEMENT BILLING ACCOUNTS RECIEVABLES – COLLECTION
?
? ? ? ?
INDIA IMPLEMENTED Programming Prod Legal
FPC RIGHTS MANAGEMENT
SINGAPORE
PROGRAM PLANNER
Agency or Advertiser
R.O. DEAL
Sales Person
T.O.
Sales Coordinator ENTERPRISE
Sales Coordinator AD SALES
ENTERPRISE SCHEDULING
Revenue Management BILLING ACCOUNTS RECIEVABLES
BILLS
MET
?
REQUIREMENTS
Since the management of deals was done manually in excel a Deal Tracking System was required in India Since the bills received from Singapore were reentered automatic generation of Client wise bills was required The Traffic Orders were being faxed to Singapore which required an audit trail to be maintained for the document
?
?
IN PROGRESS
?
Since the maintenance of Enterprise in Singapore was millions of dollars alternative would be to use SAMBA
INDIA PROPOSED Programming Prod Legal
FPC RIGHTS MANAGEMENT
SINGAPORE
PROGRAM PLANNER
Agency or Advertiser
R.O. DEAL
Sales Person
T.O.
Sales Coordinator AD SALES
Sales Coordinator AD SALES
TRAFFIC SCHEDULING
Revenue Management BILLING ACCOUNTS RECIEVABLES
RUN LOGS
RELOCATION OF INFRASTRUCTURE AND DISASTER RECOVERY SITE
ONSITE PROBLEMS
Issues ? High content of sulphur in atmosphere ? Corrosion of all hardware components ? Downtime of system affected business ? Vendors AMC’s were getting affected ? Extensive working hours for technology Action: Scrubbers and special air filters installed Result: Frequency of system downtime reduced Solution: Relocation of Infrastructure & Systems
INFRASTRUCTURE
Performance
Network response time is good with no latency ? Application running fine with limited no of users ? SAP standard programs running fine with load
?
Issues ? Application freezes as no. of users increases ? SAP customized programs running very slow
Action: Increased memory to 32 GB Action: Database tuning in progress Solution: Convert to 3tier architecture
BENEFITS
?
? ?
Managed Infrastructure with 99.9% uptime
Daily Log monitoring and backup of data Three levels of physical security in premises
?
24 * 7 support on systems and 3 tier backup
SAMBA – The System
? Multi channel operations
? Multi currency operations
? Audit trails for transactions ? Security and Administration
PROGRAM PLANNER – FPC Screen
AD SALES – Release Order Screen
AD SALES – DEAL SCREEN
BILLING – Reconciliation Screen
Thank you..
doc_530318119.ppt