{"id":56257,"date":"2025-05-28T09:56:18","date_gmt":"2025-05-28T09:56:18","guid":{"rendered":"https:\/\/www.sigmainfo.net\/?post_type=case-studies&#038;p=56257"},"modified":"2025-05-28T09:56:18","modified_gmt":"2025-05-28T09:56:18","slug":"automating-email-and-sms-communication-systems-with-real-time-tracking-for-a-lender","status":"publish","type":"case-studies","link":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/automating-email-and-sms-communication-systems-with-real-time-tracking-for-a-lender\/","title":{"rendered":"Automating Email and SMS Communication Systems with Real-time Tracking for a Lender"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iunukx-1a72cfb30a6a724c87dd62f34635c89d\">\n#top .av-special-heading.av-m1iunukx-1a72cfb30a6a724c87dd62f34635c89d{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-m1iunukx-1a72cfb30a6a724c87dd62f34635c89d .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-m1iunukx-1a72cfb30a6a724c87dd62f34635c89d .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-m1iunukx-1a72cfb30a6a724c87dd62f34635c89d av-special-heading-h1 blockquote modern-quote modern-centered'><h1 class='av-special-heading-tag'  itemprop=\"headline\"  >Automating Email and SMS Communication Systems with Real-time Tracking for a Lender<\/h1><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-1ifn2cj-705325db918af87c2a90147a9ba33eca\">\n#top .hr.av-1ifn2cj-705325db918af87c2a90147a9ba33eca{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-1ifn2cj-705325db918af87c2a90147a9ba33eca .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-1ifn2cj-705325db918af87c2a90147a9ba33eca hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-mamehes2-59e8952cb0360fc94bf4355bde626610\">\n.avia-image-container.av-mamehes2-59e8952cb0360fc94bf4355bde626610 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-mamehes2-59e8952cb0360fc94bf4355bde626610 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-mamehes2-59e8952cb0360fc94bf4355bde626610 av-styling- avia-align-center'   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" fetchpriority=\"high\" class='wp-image-56300 avia-img-lazy-loading-not-56300 avia_image ' src=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Benefits-of-Automated-Communication-System.webp\" alt='Benefits of Automated Communication System' title='Benefits of Automated Communication System'  height=\"258\" width=\"1030\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Benefits-of-Automated-Communication-System.webp 1030w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Benefits-of-Automated-Communication-System-300x75.webp 300w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Benefits-of-Automated-Communication-System-768x192.webp 768w, https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Benefits-of-Automated-Communication-System-705x177.webp 705w\" sizes=\"(max-width: 1030px) 100vw, 1030px\" \/><\/div><\/div><\/div>\n<div  class='flex_column av-1gp7c4z-aadcb0ec890a28d0f286b485b501a9a0 av_one_half first flex_column_div  '     ><p>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-1e8ue8z-8a4e82aace684a37107fd962118ed752\">\n#top .av-special-heading.av-1e8ue8z-8a4e82aace684a37107fd962118ed752{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-1e8ue8z-8a4e82aace684a37107fd962118ed752 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-1e8ue8z-8a4e82aace684a37107fd962118ed752 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-1e8ue8z-8a4e82aace684a37107fd962118ed752 av-special-heading-h3 blockquote modern-quote  heading'><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Client Organization<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div><br \/>\n<section  class='av_textblock_section av-m1iuoa18-7e12bca8e0896f808354334a386d6dca '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The client is an installment lender based in the US with multiple branches in Georgia and Tennessee. Serving customers since 2007, the client makes personal financing easy by providing a wide range of loans for home improvement, debt consolidation, and more. As a flourishing financial institution, the client required automated communication with real-time interaction tracking.<\/p>\n<\/div><\/section><\/p><\/div><div  class='flex_column av-1c4o743-7e32a0d62f54157280748352e4e7592d av_one_half flex_column_div  '     ><p>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-1brp5ub-75af835200a4243d522f5f67a1261bf2\">\n#top .av-special-heading.av-1brp5ub-75af835200a4243d522f5f67a1261bf2{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-1brp5ub-75af835200a4243d522f5f67a1261bf2 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-1brp5ub-75af835200a4243d522f5f67a1261bf2 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-1brp5ub-75af835200a4243d522f5f67a1261bf2 av-special-heading-h3 blockquote modern-quote  heading'><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Project Brief<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div><br \/>\n<section  class='av_textblock_section av-m1iuokj2-534873d1b216c0d631296565599e067c '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The client engaged Sigma Infosolutions to build an automated communication channel for sending payment reminders and late fee warnings via SMS and emails to customers, tracking their interactions, managing opt-in and opt-out preferences, and gaining insights into customer engagement while ensuring real-time data updates across systems.<\/p>\n<\/div><\/section><\/p><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-19zshrn-3a79ef9054718e37d55af7bfeeab3e54\">\n.avia-section.av-19zshrn-3a79ef9054718e37d55af7bfeeab3e54{\nbackground-repeat:no-repeat;\nbackground-image:url(https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/07\/business-office-work-300x200.webp);\nbackground-position:50% 50%;\nbackground-attachment:fixed;\n}\n.avia-section.av-19zshrn-3a79ef9054718e37d55af7bfeeab3e54 .av-section-color-overlay{\nopacity:0.9;\nbackground-color:#35383c;\n}\n<\/style>\n<div id='av_section_1'  class='avia-section av-19zshrn-3a79ef9054718e37d55af7bfeeab3e54 main_color avia-section-default avia-no-border-styling avia-full-stretch avia-bg-style-fixed av-section-color-overlay-active container_wrap sidebar_right'  data-section-bg-repeat='stretch'><div class=\"av-section-color-overlay-wrap\"><div class=\"av-section-color-overlay\"><\/div><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iuovfd-1936b51acff663e9cd3ba5b96945199b\">\n#top .av-special-heading.av-m1iuovfd-1936b51acff663e9cd3ba5b96945199b{\npadding-bottom:10px;\ncolor:#ffffff;\n}\nbody .av-special-heading.av-m1iuovfd-1936b51acff663e9cd3ba5b96945199b .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-m1iuovfd-1936b51acff663e9cd3ba5b96945199b .special-heading-inner-border{\nborder-color:#ffffff;\n}\n.av-special-heading.av-m1iuovfd-1936b51acff663e9cd3ba5b96945199b .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-m1iuovfd-1936b51acff663e9cd3ba5b96945199b av-special-heading-h2 custom-color-heading blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Key challenges that had to be addressed<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-18n00qr-6a3dbf7812d73d8cf5a317770656c72e\">\n#top .hr.av-18n00qr-6a3dbf7812d73d8cf5a317770656c72e{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-18n00qr-6a3dbf7812d73d8cf5a317770656c72e .hr-inner{\nwidth:50px;\nborder-color:#ffffff;\n}\n<\/style>\n<div  class='hr av-18n00qr-6a3dbf7812d73d8cf5a317770656c72e hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div  class='flex_column av-15mm22b-1a0cba207d2e3710b2803059f04ae860 av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iusgrc-facca32c484bc1c3c29a1fd5350a20f4\">\n#top .avia-icon-list-container.av-m1iusgrc-facca32c484bc1c3c29a1fd5350a20f4 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-m1iusgrc-facca32c484bc1c3c29a1fd5350a20f4 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-m1iusgrc-facca32c484bc1c3c29a1fd5350a20f4 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-m1iusgrc-facca32c484bc1c3c29a1fd5350a20f4'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-m1iusgrc-facca32c484bc1c3c29a1fd5350a20f4 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-m1iurk5g-f8aa2f6ccd464cd3667d934f52e92126 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Data Preparation Limitation:<\/strong> Email and SMS recipient lists were being managed manually or in fragmented systems, making them error-prone and time-consuming<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-m1iurx4s-67090e4291be7652d0757590ee1fb542 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Non-Automated Communication Workflow:<\/strong> Manual processes for sending emails or SMS messages lacking dynamic content capabilities.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mamdl99f-09b6952bbf1c5a93eeff46de02336f85 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>No Real-Time Tracking:<\/strong> Owing to fragmented systems and manual processes, the client had limited scope for tracking email\/SMS delivery rate, open rate, and click-through rate, leading to poor insights into campaign performance.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7lp0v0-906f1d22a1e48bbf3f2db788fc506e4c avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Inadequate Preference Management:<\/strong> Customer communication preferences were not tracked effectively, creating a higher risk of compliance issues.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7lpehg-286851768e3e16407578196d9ba198a6 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Multiple repositories for storing SMS responses:<\/strong> Customer replies via SMS were not being logged or stored in a dedicated table, making tracking and analysis difficult.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><div  class='flex_column av-14mvmc3-94ecd77a5145ca2ce875c6cd6d0b72a2 av_one_half flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iut0dl-b53834f6590664e3c96905ea8589d535\">\n#top .avia-icon-list-container.av-m1iut0dl-b53834f6590664e3c96905ea8589d535 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-m1iut0dl-b53834f6590664e3c96905ea8589d535 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-m1iut0dl-b53834f6590664e3c96905ea8589d535 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-m1iut0dl-b53834f6590664e3c96905ea8589d535'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-m1iut0dl-b53834f6590664e3c96905ea8589d535 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-m1iuspr1-f39b0f75296daddea42c759f67f41354 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Manual Updates to Customer Status:<\/strong> Manual intervention for updating customer subscription statuses, creating delays and potential message mismatches.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-m1iusz44-7fc487884cd39903270f07f5a7128e34 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Unsubscribe process constraints:<\/strong> Glitches in handling unsubscription requests due to no real-time tracking of email responses.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mamdmzvq-9d3216e87e81117fef06e2e4663ab532 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Desynchronized subscription logic:<\/strong> The absence of a unified system for handling resubscriptions and status changes increased the risk of sending misaligned communication.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7lql2j-4fbfe2908794bfae1af866a7eb321c52 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Unsynced sign-up data:<\/strong> Delayed communication to customers about newsletter subscriptions from the website was not immediately reflected in the client\u2019s CRM systems.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div><\/div><div id='after_section_1'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'><\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-12xo9cj-6db17fdcfde9af76a16b67780c4c0c21\">\n.avia-section.av-12xo9cj-6db17fdcfde9af76a16b67780c4c0c21{\nbackground-color:#f2f2f2;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_2'  class='avia-section av-12xo9cj-6db17fdcfde9af76a16b67780c4c0c21 main_color avia-section-default avia-no-border-styling avia-bg-style-scroll container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-114cskj-aa4a5d71674882cd0087bb7c64a49d07\">\n#top .av-special-heading.av-114cskj-aa4a5d71674882cd0087bb7c64a49d07{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-114cskj-aa4a5d71674882cd0087bb7c64a49d07 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-114cskj-aa4a5d71674882cd0087bb7c64a49d07 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-114cskj-aa4a5d71674882cd0087bb7c64a49d07 av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Solutions<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-7cf49ece2e3b5cdf27bdd6a9ddac5721\">\n#top .hr.av-av_hr-7cf49ece2e3b5cdf27bdd6a9ddac5721{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-av_hr-7cf49ece2e3b5cdf27bdd6a9ddac5721 .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-av_hr-7cf49ece2e3b5cdf27bdd6a9ddac5721 hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-m1iutg80-21e0c83ff984763bddedbfb0ded6de5a '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p style=\"text-align: center;\">The client sought Sigma Infosolutions\u2019 expertise for a robust electronic communication channel to improve on-time payments, reduce late fees, and recover delinquent accounts. These were the solutions pitched:<\/p>\n<\/div><\/section>\n<div  class='flex_column av-xfc4lf-790c9c06cce59df63478f743ab9f37ed av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iuuqje-ad5b8438c29c782fc5725abafd896b46\">\n#top .avia-icon-list-container.av-m1iuuqje-ad5b8438c29c782fc5725abafd896b46 .iconlist_icon{\ncolor:#000000;\n}\n#top #wrap_all .avia-icon-list-container.av-m1iuuqje-ad5b8438c29c782fc5725abafd896b46 .av_iconlist_title{\ncolor:#000000;\n}\n.avia-icon-list-container.av-m1iuuqje-ad5b8438c29c782fc5725abafd896b46 .iconlist_content{\ncolor:#000000;\n}\n<\/style>\n<div  class='avia-icon-list-container av-m1iuuqje-ad5b8438c29c782fc5725abafd896b46'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-m1iuuqje-ad5b8438c29c782fc5725abafd896b46 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-m1iutwb2-ba4b6f0d2b63f25dd70a6a721a4a1107 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Azure data factory for database Preparation:<\/strong> SQL queries and components used to create email content and generate a list of recipients in Excel files to be stored in Azure Blob Storage. This ensures easy access to details necessary for sending out emails or SMS messages.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-m1iuu9ju-d35f4f94831acd93b6c49534b41be2c9 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Azure Functions for SMS Tracking and Management:<\/strong> Azure functions are integrated to read the generated files from Blob Storage and send emails or SMS using SendGrid and Twilio, respectively. Multiple dynamic templates were created in SendGrid for varied email content.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mamdogxe-a1177e698737fa37e4408ef7f6fe21ed avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Real-Time Tracking and Webhooks:<\/strong> Webhooks were configured to track SMS delivery status and click-through rate for each message sent, logging customer behavior in real-time.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7ls5fx-80c3978655344689821fd2206950cb5b avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Opt-in\/Opt-out Management:<\/strong> Necessary amends were made to manage the customer\u2019s opt-in or opt-out of SMS communication. A confirmation auto-response was configured in Twilio and tracked in an SQL database for record-keeping.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7lsh7y-81dbb4d1dadd65c634d03ebc0535ead5 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Repository of incoming SMS:<\/strong> All incoming SMS messages are stored in a separate table to track customer queries and responses.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7nbif2-c6e94dad80ca166c4c064b37d861c1d0 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Real-Time Updates:<\/strong> All interactions (opt-in, opt-out, subscription changes) are captured in real-time using Logic Apps, ADF, and webhooks, ensuring the database remains up to date without any scope for manual intervention.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><div  class='flex_column av-w29smr-fd55e09c19ae950c5f6129601c5a44e4 av_one_half flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iuvez5-e2132692f4d686c36c5143ca06332ed2\">\n#top .avia-icon-list-container.av-m1iuvez5-e2132692f4d686c36c5143ca06332ed2 .iconlist_icon{\ncolor:#000000;\n}\n#top #wrap_all .avia-icon-list-container.av-m1iuvez5-e2132692f4d686c36c5143ca06332ed2 .av_iconlist_title{\ncolor:#000000;\n}\n.avia-icon-list-container.av-m1iuvez5-e2132692f4d686c36c5143ca06332ed2 .iconlist_content{\ncolor:#000000;\n}\n<\/style>\n<div  class='avia-icon-list-container av-m1iuvez5-e2132692f4d686c36c5143ca06332ed2'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-m1iuvez5-e2132692f4d686c36c5143ca06332ed2 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-m1iuv2ab-857350941564b1f436ca151d30de65e4 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Real-Time DB Updates:<\/strong> Logic Apps are used to continuously monitor Blob Storage for updates related to SMS delivery status, opt-ins\/opt-outs, and incoming messages, triggering ADF pipelines to update the database in real-time.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mamdpp7l-8f3b67745460a40b2e6dd6ec0b84ab25 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>SendGrid Email Tracking and Management:<\/strong> Webhooks are set up to track email delivery, open rate, and click-through rate, logging these activities in the database. A provision was made for a default reply email to be sent and tracked as well for better management of communication.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7ltd1m-b4b25094599b191bb1e7979e21beda76 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Unsubscribe Management:<\/strong> Unsubscribe links are included in all emails, allowing customers to opt out at any time. A provision was made to send out a confirmation mail to the customer upon unsubscribing and also to record the same in the SQL database in real time.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7ltpmb-33780ad137fcc62a4246c92225f50cd0 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Subscription Updates:<\/strong> The subscribe or resubscribe status is tracked through emails and SMS replies, confirmed, and conveyed to the customer. The status is updated in the master contact table, eliminating the scope of unwanted or irrelevant communication.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7luj2r-54fde3e51b3f0ca190c602f61ddb4fed avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Integration with Website for Newsletter Subscription:<\/strong> A webhook is configured to capture customers\u2019 newsletter sign-ups from the client\u2019s website. This data is further pushed to SendGrid for managing email subscriptions and is also updated in the SQL database.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_2'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'><\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-v9rrwj-2d30f54f2e56256dc3943177643b9557\">\n.avia-section.av-v9rrwj-2d30f54f2e56256dc3943177643b9557{\nbackground-repeat:no-repeat;\nbackground-image:url(https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/07\/business-office-work-300x200.webp);\nbackground-position:50% 50%;\nbackground-attachment:fixed;\n}\n.avia-section.av-v9rrwj-2d30f54f2e56256dc3943177643b9557 .av-section-color-overlay{\nopacity:0.9;\nbackground-color:#35383c;\n}\n<\/style>\n<div id='av_section_3'  class='avia-section av-v9rrwj-2d30f54f2e56256dc3943177643b9557 main_color avia-section-default avia-no-border-styling avia-full-stretch avia-bg-style-fixed av-section-color-overlay-active container_wrap sidebar_right'  data-section-bg-repeat='stretch'><div class=\"av-section-color-overlay-wrap\"><div class=\"av-section-color-overlay\"><\/div><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-sl2jtv-e55c1d492f32900ade8c171fa84f7bdd\">\n#top .av-special-heading.av-sl2jtv-e55c1d492f32900ade8c171fa84f7bdd{\npadding-bottom:10px;\ncolor:#ffffff;\n}\nbody .av-special-heading.av-sl2jtv-e55c1d492f32900ade8c171fa84f7bdd .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-sl2jtv-e55c1d492f32900ade8c171fa84f7bdd .special-heading-inner-border{\nborder-color:#ffffff;\n}\n.av-special-heading.av-sl2jtv-e55c1d492f32900ade8c171fa84f7bdd .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-sl2jtv-e55c1d492f32900ade8c171fa84f7bdd av-special-heading-h2 custom-color-heading blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Benefits<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-f9cbe5a8bc6db256dad8c59f4ea3b236\">\n#top .hr.av-av_hr-f9cbe5a8bc6db256dad8c59f4ea3b236{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-av_hr-f9cbe5a8bc6db256dad8c59f4ea3b236 .hr-inner{\nwidth:50px;\nborder-color:#ffffff;\n}\n<\/style>\n<div  class='hr av-av_hr-f9cbe5a8bc6db256dad8c59f4ea3b236 hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div  class='flex_column av-pygk37-4ad1ecb544754340224e6616f4007d9c av_one_half first flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iuwwvx-d2ea82b98460db145278dba85325b920\">\n#top .avia-icon-list-container.av-m1iuwwvx-d2ea82b98460db145278dba85325b920 .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-m1iuwwvx-d2ea82b98460db145278dba85325b920 .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-m1iuwwvx-d2ea82b98460db145278dba85325b920 .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-m1iuwwvx-d2ea82b98460db145278dba85325b920'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-m1iuwwvx-d2ea82b98460db145278dba85325b920 avia-iconlist-animate'>\n<li><div class='iconlist_icon av-m1iuw5vh-463c62b47d8b1bfbed9bd2c0e57a22dd avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Automated Communication:<\/strong> Emails and SMS messages are sent automatically based on predefined templates and customer data.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-m1iuwsd8-1f5fe73a23ae0049d8e75d94b70a3a85 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Real-Time Interaction Tracking:<\/strong> Deliveries, opens, clicks, and replies are tracked in real time, enabling accurate reporting and analysis.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-m5nnp4vy-6a0f21da802f3682e0cca47cc67f0e92 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Opt-in\/Opt-out Management:<\/strong> Easy management of customer preferences to ensure compliance with marketing regulations.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb7lvz1v-b58fe0f53d77ab4f4de2c70ea59960fe avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Customer Engagement Insights:<\/strong> Click and open tracking provides valuable insights into customer behavior.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><div  class='flex_column av-os6s4z-5133d78c3f122dae1339be8817695723 av_one_half flex_column_div  '     ><style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-m1iuy7fn-ed405555caa57093c2b7f8d7179afaae\">\n#top .avia-icon-list-container.av-m1iuy7fn-ed405555caa57093c2b7f8d7179afaae .iconlist_icon{\ncolor:#ffffff;\n}\n#top #wrap_all .avia-icon-list-container.av-m1iuy7fn-ed405555caa57093c2b7f8d7179afaae .av_iconlist_title{\ncolor:#ffffff;\n}\n.avia-icon-list-container.av-m1iuy7fn-ed405555caa57093c2b7f8d7179afaae .iconlist_content{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-icon-list-container av-m1iuy7fn-ed405555caa57093c2b7f8d7179afaae'><ul class='avia-icon-list avia_animate_when_almost_visible avia-icon-list-left av-iconlist-small av-m1iuy7fn-ed405555caa57093c2b7f8d7179afaae avia-iconlist-animate'>\n<li><div class='iconlist_icon av-m1iuxn3e-55d7d6e9236700b91cf2a4724de0c758 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Dynamic Content Delivery:<\/strong> The use of dynamic templates in SendGrid allows for personalized messaging, improving customer experience.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-m1iuy3ye-2597eee74cb7cf55ec93989dfb87ddd9 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Scalable and Reliable:<\/strong> Leveraging Azure&#8217;s services ensures system scalability with minimal overhead while remaining reliable.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<li><div class='iconlist_icon av-mb0bmtug-e03bdd2795ae1143c5933b7bd286d257 avia-font-entypo-fontello'><span class='iconlist-char' aria-hidden='true' data-av_icon='\ue871' data-av_iconfont='entypo-fontello'><\/span><\/div><article class=\"article-icon-entry \"  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class=\"iconlist_content_wrap\"><header class=\"entry-content-header\"><\/header><div class='iconlist_content av_inherit_color'  itemprop=\"text\" ><p><strong>Data Consistency:<\/strong> Real-time data updates and synchronization ensure that customer preferences and interaction histories are always up to date.<\/p>\n<\/div><\/div><footer class=\"entry-footer\"><\/footer><\/article><div class=\"iconlist-timeline\"><\/div><\/li>\n<\/ul><\/div><\/div><\/div><\/div><\/div><!-- close content main div --><\/div><\/div><\/div><div id='after_section_3'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'><\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='av_section_4'  class='avia-section av-mgenw3-16b77dbdd603d642680dac82f649a9a7 main_color avia-section-default avia-no-border-styling avia-bg-style-scroll container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l29jbn-51bf17fdc9aad61339eb2dd182437b43\">\n#top .av-special-heading.av-l29jbn-51bf17fdc9aad61339eb2dd182437b43{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-l29jbn-51bf17fdc9aad61339eb2dd182437b43 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-l29jbn-51bf17fdc9aad61339eb2dd182437b43 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-l29jbn-51bf17fdc9aad61339eb2dd182437b43 av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Tools <span class='special_amp'>&amp;<\/span> Technologies<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-iurqmr-a5e376e26f41b1c9212552a09a6c216a\">\n#top .hr.av-iurqmr-a5e376e26f41b1c9212552a09a6c216a{\nmargin-top:10px;\nmargin-bottom:10px;\n}\n.hr.av-iurqmr-a5e376e26f41b1c9212552a09a6c216a .hr-inner{\nwidth:50px;\nborder-color:#8dc321;\n}\n<\/style>\n<div  class='hr av-iurqmr-a5e376e26f41b1c9212552a09a6c216a hr-custom hr-center hr-icon-no'><span class='hr-inner inner-border-av-border-fat'><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div class='avia-data-table-wrap av-hbt02b-674a7198a41b24e154b74e941fd00a5b avia_responsive_table avia-table-1'><table  class='avia-table avia-data-table avia_pricing_default'  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/Table\" ><tbody><tr class=''><td class=''>Twilio<\/td><td class=''>SendGrid<\/td><\/tr><tr class=''><td class=''>Azure<\/td><td class=''>Azure Functions<\/td><\/tr><tr class=''><td class=''>Logic Apps<\/td><td class=''>Azure Data Factory (ADF)<\/td><\/tr><tr class=''><td class=''>SQL Server<\/td><td class=''>Blob Storage<\/td><\/tr><\/tbody><\/table><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_4'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'><\/div><\/div><\/div><!-- close content main div --><\/div><\/div>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-mcwr7-8d7d250759bdb0f01388ade1571dd90d\">\n.avia-section.av-mcwr7-8d7d250759bdb0f01388ade1571dd90d{\nbackground-color:#f3f3f3;\nbackground-image:unset;\n}\n<\/style>\n<div id='av_section_5'  class='avia-section av-mcwr7-8d7d250759bdb0f01388ade1571dd90d main_color avia-section-default avia-no-border-styling avia-bg-style-scroll container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-4o96jn-9bd6a3fb0d4fccc7036683c8340b458e\">\n#top .av-special-heading.av-4o96jn-9bd6a3fb0d4fccc7036683c8340b458e{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-4o96jn-9bd6a3fb0d4fccc7036683c8340b458e .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-4o96jn-9bd6a3fb0d4fccc7036683c8340b458e .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-4o96jn-9bd6a3fb0d4fccc7036683c8340b458e av-special-heading-h2 blockquote modern-quote modern-centered'><h2 class='av-special-heading-tag'  itemprop=\"headline\"  >Get in touch with us, let\u2019s create value together.<\/h2><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<div  class='avia-button-wrap av-2bbp3n-e37f0c3022e36d7b9b5bab9a73a14504-wrap avia-button-center '>\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-2bbp3n-e37f0c3022e36d7b9b5bab9a73a14504\">\n#top #wrap_all .avia-button.av-2bbp3n-e37f0c3022e36d7b9b5bab9a73a14504{\nfont-size:14px;\ntransition:all 0.4s ease-in-out;\n}\n<\/style>\n<a href='\/contact-us\/'  class='avia-button av-2bbp3n-e37f0c3022e36d7b9b5bab9a73a14504 av-link-btn avia-icon_select-yes-right-icon avia-size-large avia-position-center av-icon-on-hover avia-color-theme-color'  ><span class='avia_iconbox_title' >Connect with us<\/span><span class='avia_button_icon avia_button_icon_right' aria-hidden='true' data-av_icon='\ue87d' data-av_iconfont='entypo-fontello'><\/span><\/a><\/div>\n<\/div><\/div><\/div><!-- close content main div --><\/div><\/div><div id='after_section_5'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-56257'><div class='entry-content-wrapper clearfix'><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automating Email and SMS communication systems with real-time tracking to improve on-time payments, and for recovering delinquent accounts.<\/p>\n","protected":false},"author":36,"featured_media":56258,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-56257","case-studies","type-case-studies","status-publish","has-post-thumbnail","hentry","case-studies-cat-fintech","industries-financial-services","casestudies-featured"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Automated communication systems with real-time tracking!<\/title>\n<meta name=\"description\" content=\"Automating Email and SMS communication systems with real-time tracking to improve on-time payments, and for recovering delinquent accounts.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/56257\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"opengraph-title\" \/>\n<meta property=\"og:description\" content=\"opengraph-description\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"Sigma Infosolutions\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"twitter-title\" \/>\n<meta name=\"twitter:description\" content=\"twitter-description\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/automating-email-and-sms-communication-systems-with-real-time-tracking-for-a-lender\/\",\"url\":\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/\",\"name\":\"Automated communication systems with real-time tracking!\",\"isPartOf\":{\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Automated-communication-systems-with-real-time-tracking.webp\",\"datePublished\":\"2025-05-28T09:56:18+00:00\",\"dateModified\":\"2025-05-28T09:56:18+00:00\",\"description\":\"Automating Email and SMS communication systems with real-time tracking to improve on-time payments, and for recovering delinquent accounts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#breadcrumb\"},\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#primaryimage\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Automated-communication-systems-with-real-time-tracking.webp\",\"contentUrl\":\"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Automated-communication-systems-with-real-time-tracking.webp\",\"width\":600,\"height\":400,\"caption\":\"Automated communication systems with real-time tracking\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Studies\",\"item\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"bctitle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/#website\",\"url\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/\",\"name\":\"Sigma Infosolutions\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sigma-ai.sigmainfo.net\/au\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-AU\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Automated communication systems with real-time tracking!","description":"Automating Email and SMS communication systems with real-time tracking to improve on-time payments, and for recovering delinquent accounts.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/56257","og_locale":"en_US","og_type":"article","og_title":"opengraph-title","og_description":"opengraph-description","og_url":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/","og_site_name":"Sigma Infosolutions","og_image":[{"width":500,"height":500,"url":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_title":"twitter-title","twitter_description":"twitter-description","twitter_image":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2024\/06\/loading-image-1.jpg","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/automating-email-and-sms-communication-systems-with-real-time-tracking-for-a-lender\/","url":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/","name":"Automated communication systems with real-time tracking!","isPartOf":{"@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#primaryimage"},"image":{"@id":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#primaryimage"},"thumbnailUrl":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Automated-communication-systems-with-real-time-tracking.webp","datePublished":"2025-05-28T09:56:18+00:00","dateModified":"2025-05-28T09:56:18+00:00","description":"Automating Email and SMS communication systems with real-time tracking to improve on-time payments, and for recovering delinquent accounts.","breadcrumb":{"@id":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#breadcrumb"},"inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#primaryimage","url":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Automated-communication-systems-with-real-time-tracking.webp","contentUrl":"https:\/\/sigma-ai.sigmainfo.net\/wp-content\/uploads\/2025\/05\/Automated-communication-systems-with-real-time-tracking.webp","width":600,"height":400,"caption":"Automated communication systems with real-time tracking"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sigmainfo.net\/case-studies\/scaling-loan-processing-and-empowering-growth-through-microservices-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sigma-ai.sigmainfo.net\/au\/"},{"@type":"ListItem","position":2,"name":"Case Studies","item":"https:\/\/sigma-ai.sigmainfo.net\/au\/case-studies\/"},{"@type":"ListItem","position":3,"name":"bctitle"}]},{"@type":"WebSite","@id":"https:\/\/sigma-ai.sigmainfo.net\/au\/#website","url":"https:\/\/sigma-ai.sigmainfo.net\/au\/","name":"Sigma Infosolutions","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sigma-ai.sigmainfo.net\/au\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-AU"}]}},"_links":{"self":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/56257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies"}],"about":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/types\/case-studies"}],"author":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/users\/36"}],"replies":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/comments?post=56257"}],"version-history":[{"count":4,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/56257\/revisions"}],"predecessor-version":[{"id":58308,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/case-studies\/56257\/revisions\/58308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/media\/56258"}],"wp:attachment":[{"href":"https:\/\/sigma-ai.sigmainfo.net\/au\/wp-json\/wp\/v2\/media?parent=56257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}