Skip to content
  • Blog
  • Events
  • Help
  • Careers
  • Contact
New Signature
  • About
      • Company

        Cognizant Microsoft Business Group is dedicated to changing the way businesses innovate, transform and run based on a unique cloud operating model. You will now be redirected to our new microsite to learn more.

        View Company

      • Awards

        As a company, we are regularly recognized within the IT industry as well as the communities we serve.

        View All Awards
      • News

        Read the most up-to-date corporate announcements, Microsoft technology updates, innovative business solutions and learn more about how the Cognizant Microsoft Business Group can take your business even farther.

        View News

      • Partners

        New Signature works with a number of outstanding technology companies to deliver the best experiences to our customers.

        View Partners
      • Leadership

        Cognizant Microsoft Business Group’s executive team is comprised of innovative leaders with proven experience and deep industry expertise. You will now be redirected to our new microsite to learn more.

        View Leadership

      • Industries

        Our solutions are tailored to empower organizations across a wide range
        of industries.

        View Industry Experience
    Close
  • Solutions
      • Intelligent Enterprise
        Solutions

        Going Digital
        Unleash cloud capability, deliver change and compete at speed with a Microsoft digital operating model, enabling you to work more efficiently as you transform your IT environment. Learn More

      • Featured Solution

        Secure Cloud
        In a world of constant threat, ensuring that your underlying cloud platform is protected is the first step on your organization’s journey towards a secure, compliant operating environment. Learn More
      • Intelligent Workplace
        Solutions

      • Secure Workplace

        Work Anywhere

        Endpoint Health

        Identity Health

        Teamwork Support



        VIEW WORKPLACE SOLUTIONS
      • Intelligent Cloud
        Solutions

      • App Factory

        Azure Accelerator

        Azure Launchpad

        Azure Launchpad for DevOps

        Application Health

        Platform Health

        VIEW ClOUD SOLUTIONS
    Close
  • Services
      • Begin your journey towards becoming a digital business with GO, our unique end-to-end framework based on the Microsoft Cloud Adoption Framework.

        GO DIGITAL OPERATING MODEL
      • Intelligent Enterprise

      • Consulting

        We go beyond just technology to help your organization understand how digital can help you uniquely differentiate and better serve your employees and customers.

        VIEW ENTERPRISE SERVICES
      • Intelligent Workplace

        • Identity

          Identity is your new first-line-of-defense. It’s vital to your users and clients that your identity platform is properly configured and secured.

          Endpoint

          Whether your devices are on-premises or remote, personal or business-owned, we can ensure they are properly managed and protected.

          Teamwork

          Today’s workforce is collaborating than ever before.  We can empower your current teams with tomorrow’s progressive technologies.

          VIEW WORKPLACE SERVICES
        • Intelligent Cloud

          • Platform

            The cloud is no longer some future-state. It’s the here and now. Adopting a cloud-first platform is one of the best ways to maintain a future-proofed competitive advantage.

            Applications

            We build cloud-native apps and modernize legacy systems with the power of Azure to give your organization a competitive edge.

            Data

            We can help your organization create secure, scalable data platforms to deliver simpler and more sophisticated insights to your business.

            VIEW CLOUD SERVICES
        Close
      • Client Stories
          • Case Studies

            Browse a comprehensive list of companies who have created successful partnerships and experienced transformative solutions with New Signature.

            View All Case Studies

          • Featured Case Study TalkTalk Modern Workplace

            New Signature worked with TalkTalk to define a new Modern Workplace solution based on Microsoft 365, which kept the user firmly at the center of the transformation.
            View Case Study

          • Testimonials

            We love transforming our customers businesses, take a look at what they have to say about New Signature.

            View Testimonials

          • Featured Testimonial Davis Construction

            With New Signature’s help, Davis was able to take a progressive step forward by migrating their private branch exchange (PBX) phone system to a Voice of Internet Protocol (VoIP) system.
            View Testimonial

        Close
      • Explore
          • Guides & Ebooks

            Dive deeper into education with your team by leveraging our expert-developed guides and eBooks.

            View All Guides & Ebooks

          • Infographics

            Rich with statistics and information, our infographics are great tools for quick but insightful learning.

            View All Infographics
          • Podcast: Office Explorers

            Join Kat and Rob monthly as they chat with New Signature experts and explore the world of O365.

            Listen to Podcasts

          • Videos

            Visit our videos stream to access recorded webinars, service information and to learn more about us.

            WATCH ALL VIDEOS
          • Flyers

            Searching for information about our services? Our flyers are a great takeaway for all those details.

            VIEW ALL FLYERS

          • Featured Stream

            Learn more about the tooling and expertise required to unlock productivity and mobilize your teams.

            MODERN WORKPLACE
        Close
        Close
      Blog

      What is the business value of data modernization?

      New Signature / Blog / What is the business value of data modernization?
      June 14, 2019July 9, 2019| Channa Wijesinghe
      • Facebook
      • Twitter
      • LinkedIn
      • Print

      These are common phrases you hear around a business:

      “Why upgrade? It works fine just the way it is.”

      “If it ain’t broke don’t fix it.”

      “It is what it is. “

      They are rooted in the key concept that the cost of changing is expensive. But the cost of not changing could be more expensive.

      Case in point, Customer X had a manual data entry process that would consume 10 days of time from 5 interns. This process was sound – ultimately it had 5 people entering line by line data from excel into an access database (~30K rows).

      Conservatively this was costing the business $20K each year in time and resources

      “It is what it is.”  How does someone know that the process is broken? How would someone know it’s an issue?

      Another example, Customer Y has a data ETL strategy, where they have a complex understanding of database design and architecture. They adopted an agile process, with multiple skilled technicians. Yet once they deploy changes to UAT or Production there are multiple data discrepancies, and the team struggles to know why. They know its broken, but struggle to understand how to fix it.

      Issues with deployment and quality result in $24K lost per day as technicians “pull everyone” into calls to help trouble shoot issues. 

      I’ve heard this customer say, “if we had more time, we would have time to test and develop then the quality would be better.”

      The reality is if they had all the time they needed they would still be plagued by issues.

      So what do we do? Data Modernization. By using the Microsoft Azure data frameworks and integration with 100s of platforms it’s a golden era of fast, simple, scalable solutions with very little overhead. Below are 2 examples of how we used the Azure data tools to build cost effective solutions

      Customer X – We need to make things simple and Fast

      At Customer X the staff doesn’t have detailed technical knowledge so they would like to keep things simple.

      We have created a process where the customer simply needs to drop Excel files into a folder, the files get processed automatically and loaded into a fault tolerant, cloud-based SQL database. The business leads then get a report on what data has been successfully loaded.  We do this simply using Azure functions, blob storage and data functions to load data into Azure SQL. 

      Customer Y – We need to fail fast. We need to know it’s broken early so we can fix it or set expectations that we will not meet sprint commitments.

      At customer Y each sprint we deliver large complex projects. 4 – 6 days are allocated for development, 3 days for testing and releases happen after the 2-week sprint has completed.  Data and deployment is truly tested during deployment to UAT which starts the second week of the 2 week sprint cycle. This is when the developer code starts interacting with production data.

      Why do I have to wait for developer code to interact with production data? If we have issues – let’s find them fast.   This is a bit more complex than Customer X –we need to get this right otherwise it will just another “process” that doesn’t get us closer to quality.

      We need to recreate production data, and test our changes against prod data

      1. We leverage Azure DevOps, IaaS, and IAC to recreate the production environment in the Azure cloud.
      2. In this customer’s case – most test cases are basically SQL scripts so we can capture the test cases in an automation test suite
      3. Deploy SSIS packages to recreated SSIS server, deploy SQL bits to recreated production instance, run SSIS packages, run automation test suite


      Once testing is complete, we tear it down.  This entire process happens twice a day every day.

      We email a report of health of the build to business owners, where we track the health of the build. As we continually test against production data the team will observe fewer and fewer production issues.

      Quality improves and developers are free for more frivolous pursuits, like this.

       

       

      Categories
      Tips and Tricks
      Contact New Signature

      Related Information

      Technologies

      • Microsoft Azure
      • SQL Server

      Blog Posts

      • Cognizant Microsoft Business Group Achieves New Microsoft Advanced Specialization 
      • Azure Sentinel Workshop
      • How to Modernize Your Apps Securely in Azure – Webinar
      • Deploy Kubernetes on Azure, AWS and GCP with Terraform using Azure DevOps

      Events

      Thu 28

      Power Platform Series: Drive Organizational Productivity with Power Virtual Agents

      January 28 @ 10:00 am - 10:45 am EST
      Feb 16

      Cognizant’s Experience Lab for Continuous Testing with Azure

      February 16 @ 12:00 pm - 2:00 pm EST

      View More

      New Signature
      New Signature HQ
      901 K Street NW, Suite 450
      Washington, DC 20001
      Phone: 202-452-5923
      New Signature Canada HQ
      7th Floor, 5140 Yonge Street
      Toronto, ON M2N 7J8
      Phone: 416-971-4267
      New Signature UK HQ
      57 Bermondsey Street
      London SE1 3XJ
      Phone: +44 (0) 845-402-1752

      About

      • Company
      • Awards
      • News
      • Leadership
      • Partners
      • Industries

      Solutions

      • Intelligent Enterprise Solutions
      • Intelligent Workplace Solutions
      • Intelligent Cloud Solutions

      Services

      • GO
      • Intelligent Enterprise
      • Intelligent Workplace
      • Intelligent Cloud

      Client Stories

      • Client Stories
      • Testimonials

      Explore

      • Guides & Ebooks
      • Podcasts
      • Flyers
      • Infographics
      • Videos
      Copyright © 2021 New Signature
      • Blog
      • Events
      • Careers
      • Help
      • Anti Slavery
      • Privacy Policy
      • Contact
      • About
        • Company
        • Awards
        • News
        • Leadership
        • Partners
        • Industries
      • Services
        • GO
        • Intelligent Enterprise
        • Intelligent Workplace
        • Intelligent Cloud
      • Client Stories
        • Case Studies
        • Testimonials
      • Technologies
      • Explore
        • Guides & Ebooks
        • Infographics
        • Podcast: Office Explorers
        • Videos
        • Flyers
      • Blog
      • Events
      • Careers
      • Contact
      • Search
      Cookie Settings
      New Signature uses "Required Cookies" to run our website, "Functional Cookies" used by third parties to personalise marketing, including social media features.

      Change your preferences by clicking the “Cookie Settings” link at the bottom of every page. Learn more about cookies in our Cookie Policy and our Privacy Policy. By clicking the “Accept Cookies” button below, you consent to our use of cookies.

      Please note that “Required Cookies” will be set regardless of your consent.
      Cookie SettingsAccept Cookies
      Privacy & Cookies Policy
      Performance

      Performance Cookies provide Content Delivery Network assets that deliver faster site content delivery capabilities.

      Required

      These cookies are required mainly in order to deliver Multilanguage site capabilities.

      Functional

      Functional Cookies allow us to provided advanced media capabilities including videos, surveys and other multimedia capabilities.

      Disabling Functional cookies will block the playing of videos and other multimedia site components.

      Targeting

      Targeting Cookies are used to capture user information in order for New Signature to deliver better user experiences.

      Save & Accept