{"id":6878,"date":"2021-06-15T09:00:22","date_gmt":"2021-06-15T16:00:22","guid":{"rendered":"https:\/\/www.microsoft.com\/insidetrack\/blog\/?p=6878"},"modified":"2023-06-08T16:17:47","modified_gmt":"2023-06-08T23:17:47","slug":"moving-microsofts-financial-reporting-processes-to-microsoft-azure","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/insidetrack\/blog\/moving-microsofts-financial-reporting-processes-to-microsoft-azure\/","title":{"rendered":"Moving Microsoft\u2019s financial reporting processes to Microsoft Azure"},"content":{"rendered":"
This content has been archived, and while it was correct at time of publication, it may no longer be accurate or reflect the current situation at Microsoft.<\/p>\n<\/div>\n<\/div>\n
Managing Microsoft\u2019s financial reporting processes is a formidable task.<\/p>\n
Although Microsoft had a reliable system in place, fresh thinking was needed to respond to increasing complexity and much higher volumes of financial data.<\/p>\n
In short, the company needed to rethink how it automates its financial reporting.<\/p>\n
Our goal was to modernize our financial reporting processes and make them more digital as part of our digital transformation journey, and we wanted to make effective use of the Microsoft Azure product stack\u2014Azure Data Services, Azure Data Lake, almost anything Azure.<\/p>\n
– Bridgette Link, general manager, Microsoft Finance Business Intelligence group<\/p>\n<\/blockquote>\n
The Microsoft Finance Engineering group, the organization that powers the number crunchers on the business side of Microsoft, used Microsoft Azure to create a tool that the company\u2019s financial experts can use to understand and analyze those massive financial figures more easily. Microsoft Azure allowed the team to unlock value in the financial information and connect that information to key stakeholders.<\/p>\n
Dubbed Mercury 2.0, the effort aims to streamline and simplify the task of creating reports for the many Microsoft lines of business and operations in more than 100 countries and regions around the world.<\/p>\n
\u201cWe have lots of complexity in our various financial processes,\u201d says Bridgette Link, the general manager for the Finance Business Intelligence group at Microsoft. \u201cOur goal was to modernize our financial reporting processes and make them more digital as part of our digital transformation journey, and we wanted to make effective use of the Microsoft Azure product stack\u2014Azure Data Services, Azure Data Lake, almost anything Azure.\u201d<\/p>\n
Mercury is the backbone of the company as far as producing its financial statements. It’s what Wall Street gets. It’s what all of our filings are based on, so you can’t find a system more important for financial compliance and the reporting of our numbers.<\/p>\n
\u2013 Arthur So, director, Microsoft Finance Business Intelligence group<\/p>\n<\/blockquote>\n
Mercury 2.0 is designed to handle a wide range of financial information\u00a0including earnings releases, financial filings, financial closes, expense allocation, operational reporting, and more. It also seeks to automate more financial processes, simplify them where possible, and standardize across different business units.<\/p>\n
<\/p>\n
<\/p>\n
Making things simpler and faster isn\u2019t easy. This chart shows the complex web of data sources and analytical tools used in Mercury 2.0 to accelerate and refine Microsoft\u2019s financial reporting processes. Mercury 2.0 follows on in the footsteps of Mercury 1.0, which has been crunching Microsoft\u2019s numbers for the past decade.<\/p>\n
\u201cMercury is the backbone of the company as far as producing its financial statements,\u201d says Arthur So, director of Finance Business Intelligence for Microsoft. \u201cIt’s what Wall Street gets. It’s what all of our filings are based on, so you can’t find a system more important for financial compliance and the reporting of our numbers.\u201d<\/p>\n
[Learn how to create a data governance structure that accelerates digital transformation.<\/em><\/a> Watch this video about how Microsoft manages its corporate firewalls with Microsoft Azure Firewall Manager.<\/em><\/a>]<\/p>\n
Upgrading Mercury 1.0<\/strong><\/p>\n
Mercury 1.0 has been a company powerhouse, but it was time for an update.<\/p>\n
\u201cWe did a darned good job with Mercury 1.0,\u201d says Timm Rulison, principal program manager for Finance Engineering. \u201cBut like anybody else, we had changes in our business processes, such as moving to a consumption-based (subscription) model, which is lower margin but higher volume. As a result, we\u2019ve just seen an exponential explosion in revenue data.\u201d<\/p>\n
Spark is a programming language that takes all of the data and moves that into a single pipeline. That gives you much greater scale, as well as access to virtualization that you don\u2019t necessarily get through SQL.<\/p>\n
– Timm Rulison, principal program manager, Microsoft Finance Engineering<\/p>\n<\/blockquote>\n
Mercury 1.0 is based on Microsoft SQL Server, a venerable relational database management tool that was launched in 1989, a time when the internet had only 100,000 host machines. And although SQL is a rock-solid product, even its modern iterations aren\u2019t designed as \u201cbig data\u201d solutions.<\/p>\n
Enter the Microsoft Apache Spark connector<\/a>, which can tackle the large-scale data processing the Microsoft Azure stack is designed to perform.<\/p>\n
\u201cSpark is a programming language that takes all of the data and moves that into a single pipeline,\u201d Rulison says. \u201cThat gives you much greater scale, as well as access to virtualization that you don\u2019t necessarily get through SQL.\u201d<\/p>\n
Moreover, Spark allows a process called \u201csharding\u201d that breaks massive amounts of data into smaller chunks that can be distributed across a wide range of cloud-based high-performance servers.<\/p>\n
As both the database size and number of transactions increase, so does the response time for querying the database. Costs associated with maintaining a huge database can also skyrocket due to the number and quality of computers you need to manage your workload. By moving Microsoft\u2019s financial reporting processes to Microsoft Azure and using data shards, on the other hand, hardware and software requirements can be managed on less expensive servers.<\/p>\n
\u201cBecause of statutory requirements, we have to submit data going back 10 years,\u201d Rulison says. \u201cThat\u2019s a huge amount of data, so we shard it month by month. Sometimes we can combine several months or years into a single shard.\u201d<\/p>\n
A faster way to handle complex financials<\/strong><\/p>\n
The automated financial reporting used in Mercury 2.0 is beginning to roll out, and is demonstrating several advantages of a near-real-time data platform over the older but still capable SQL-based system.<\/p>\n
Most importantly, it\u2019s incredibly fast. Mercury 1.0 processed financial data in batches, sometimes with only a few data publications in a day.<\/p>\n
\u201cMercury 2.0 can process financial data to generate reports as soon as transactions are recorded in the SAP ledger in near-real time,\u201d says Sudhahar Jayapalan, a principal software engineering manager for Finance Engineering. \u201cA batch system takes time to create those reports for financial users.\u201d<\/p>\n
Mercury 2.0 is built for future data growth, with the ability to autoscale as workloads grow. Its architecture is designed to intake both batch and event streams of data to process, then distribute it to multiple endpoints to address different scenarios in data consumption. Users can choose to receive data insights using a variety of tools such as Microsoft Power BI, Excel, Web Reports, and a mobile app.<\/p>\n
\u201cWe\u2019ll be a lot more efficient and automated when Mercury 2.0 is fully operational,\u201d Jayapalan says. \u201cWe expect to see a 20 to 30 percent improvement in performance along with the data at speed to users. And we\u2019ll keep improving the system, so it reflects how its users utilize the core statutory financial systems.\u201d<\/p>\n
Providing a personalized experience is another objective of Mercury 2.0.<\/p>\n
\u201cThe system is designed to use AI and machine learning to determine user needs based on their daily interactions,\u201d Jayapalan says.<\/p>\n
Other improvements include a more graphical, user-friendly interface\u2014including a voice command feature, the Microsoft Cortana natural speech language product, to reference particular types of information\u2014as well as embedded analytics to enhance or replace manual work performed by accountants.<\/p>\n
A great collaboration<\/strong><\/p>\n
Link sees Mercury as a notable example of collaboration between quite different teams\u2014in this case, finance and engineering.<\/p>\n
\u201cFinance was very enthusiastic about the capabilities we could give them with Microsoft Azure,\u201d she says. \u201cIn fact, their enthusiasm sort of caught us off guard. I really owe a lot of thanks and gratitude to the engineering team.\u201d<\/p>\n
Not only does Mercury 2.0 offer a more user-friendly and detailed experience, it also emphasizes the solid reliability and foundational numbers Microsoft requires.<\/p>\n
\u201cWe can serve up more customer enrichment and better customer analytics,\u201d So says. \u201cWith Mercury 2.0, we can store the preferences of a user\u2014such as information they might want about incoming costs\u2014and proactively alert them when certain conditions are met.\u201d<\/p>\n
Mercury 2.0 is also designed to offer mobile usability by narrowing down financial information to key numbers a user might need.<\/p>\n
\u201cJamming a million reports onto a phone isn\u2019t really a true mobile experience,\u201d So says. \u201cBut there are things that are optimized for a small device.\u201d<\/p>\n
Finally, because Microsoft is hardly the only multinational corporation with complex financial reporting requirements, Mercury 2.0 clearly has commercial potential.<\/p>\n
\u201cA modern profit and loss system is key for any publicly listed company,\u201d Jayapalan says. \u201cIf Microsoft can run that sort of system on Microsoft Azure, so can other big companies.\u201d<\/p>\n
In the coming months, Link says, Microsoft will continue refining Mercury 2.0 and rolling it out to additional parts of the company. \u201cThis is a showcase for demonstrating to our customers the capabilities of Azure,\u201d she says.<\/p>\n
Learn how to create a data governance structure that accelerates digital transformation.<\/a><\/p>\n