{"id":639,"date":"2026-02-15T18:57:59","date_gmt":"2026-02-15T18:57:59","guid":{"rendered":"https:\/\/www.arifulemon.com\/?post_type=portfolio-awesome&#038;p=639"},"modified":"2026-02-15T18:57:59","modified_gmt":"2026-02-15T18:57:59","slug":"media-sales-system","status":"publish","type":"portfolio-awesome","link":"https:\/\/www.arifulemon.com\/index.php\/portfolio\/media-sales-system\/","title":{"rendered":"Media Sales System"},"content":{"rendered":"<p>Sales Billing Software for Broadcast Television Channel<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Media Sales Management System<\/strong><\/p>\n<p><strong>Organization:<\/strong> Ekushey Television Limited<br \/>\n<strong>Developer:<\/strong> Ariful Islam Emon<br \/>\n<strong>Technology Stack:<\/strong> Visual Basic, MS SQL Server 2012, Crystal Report<br \/>\n<strong>Domain:<\/strong> Media Sales \u2022 Revenue Management \u2022 Operational Analytics<\/p>\n<p>&nbsp;<\/p>\n<p>Ekushey Television Limited is a national television broadcasting channel in Bangladesh that generates revenue through the sale of advertising airtime, sponsored programs, and commercial slots. The Sales and Marketing department manages numerous contracts with agencies and clients, generates invoices, tracks collections, and produces periodic financial and operational reports.<\/p>\n<p>Prior to automation, managing advertising contracts, invoicing, and revenue tracking involved manual processes and fragmented record keeping. This resulted in delays in reporting, difficulty in tracking outstanding dues, and limited visibility into sales performance.<\/p>\n<p>To address these challenges, a centralized <strong>Media Sales Management System<\/strong> was designed and implemented to streamline contract management, billing, revenue collection, and reporting operations.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Objectives<\/strong><\/p>\n<p>The primary objectives of the system are:<\/p>\n<ul>\n<li>Automate the end-to-end media sales lifecycle<\/li>\n<li>Manage advertising contracts and airtime allocation<\/li>\n<li>Generate accurate invoices and financial records<\/li>\n<li>Track revenue collections and outstanding dues<\/li>\n<li>Provide comprehensive operational and financial reports<\/li>\n<li>Enable role-based access for different departments<\/li>\n<li>Improve transparency, auditability, and decision support<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>System Architecture<\/strong><\/p>\n<p>The system follows a centralized client-server architecture.<\/p>\n<p><strong>Architecture Components<\/strong><\/p>\n<ul>\n<li><strong>Frontend:<\/strong> Desktop application developed in Visual Basic<\/li>\n<li><strong>Backend:<\/strong> Microsoft SQL Server 2012<\/li>\n<li><strong>Users:<\/strong> Sales, Marketing, Finance, and Administration teams<\/li>\n<li><strong>Data Flow:<\/strong><\/li>\n<\/ul>\n<p>Contract Creation \u2192 Invoice Generation \u2192 Transmission \u2192 Collection Entry \u2192 Financial &amp; Sales Reports<\/p>\n<p><a href=\"https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-641\" src=\"https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow-300x108.png\" alt=\"\" width=\"300\" height=\"108\" srcset=\"https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow-300x108.png 300w, https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow-1024x367.png 1024w, https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow-768x275.png 768w, https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow-1536x550.png 1536w, https:\/\/www.arifulemon.com\/wp-content\/uploads\/2026\/02\/SM-Workflow-2048x734.png 2048w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Key Characteristics<\/strong><\/p>\n<ul>\n<li>Centralized relational database<\/li>\n<li>Real-time data availability<\/li>\n<li>Multi-user environment<\/li>\n<li>Role-based security<\/li>\n<li>Transaction-based financial data handling<\/li>\n<\/ul>\n","protected":false},"featured_media":640,"menu_order":0,"template":"","portfolio-category":[14],"class_list":["post-639","portfolio-awesome","type-portfolio-awesome","status-publish","has-post-thumbnail","hentry","portfolio-category-software"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.arifulemon.com\/index.php\/wp-json\/wp\/v2\/portfolio-awesome\/639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arifulemon.com\/index.php\/wp-json\/wp\/v2\/portfolio-awesome"}],"about":[{"href":"https:\/\/www.arifulemon.com\/index.php\/wp-json\/wp\/v2\/types\/portfolio-awesome"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.arifulemon.com\/index.php\/wp-json\/wp\/v2\/media\/640"}],"wp:attachment":[{"href":"https:\/\/www.arifulemon.com\/index.php\/wp-json\/wp\/v2\/media?parent=639"}],"wp:term":[{"taxonomy":"portfolio-category","embeddable":true,"href":"https:\/\/www.arifulemon.com\/index.php\/wp-json\/wp\/v2\/portfolio-category?post=639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}