Corios Rosetta Scanner use cases

Chief Information, Data, Compliance and Analytics Officers

“We have 4,000 SAS users and 7 million lines of SAS code, and nobody knows what it all does.” These are the words of the Chief Data Officer of one of our insurance industry clients.

As the pace of digital transformation heats up for our clients in the financial services, insurance, manufacturing and energy industries, one of their primary interests is how to modernize their traditional data and analytics assets and merge them with the capabilities offered by open source frameworks and cloud platforms.  Key to that is having a ground truth mapping to all the existing analytics assets they already possess, which are often hiding in plain sight. That’s where Corios Rosetta comes in.

We created Corios Rosetta to help our clients modernize their traditional data and analytics assets, and especially to answer the question “ok, so what are these 4,000 SAS users up to, and what do these 7 million lines of code actually produce?”

In today’s video, I’ll share an interactive walkthrough of the use cases for four of the most engaged client roles in a Corios Rosetta engagement: the CIO, the Chief Data Officer, the Chief Compliance Officer and the Chief Analytics Officer.  We’ve organized the video in chapters so you can drill to the use cases you find most compelling, or you can simply sit back and take it all in.

Corios Lightning solution walkthrough

Electric utility hourly demand forecasting for distribution planning

If you work for an electric utility and you’ve launched or are planning to launch a grid modernization initiative, you will need load forecasts that meet both top-down regulatory requirements and bottom-up distributed energy resource impacts. If you’re like our other clients, including Southern California Edison, you’ll agree the ideal approach is a transparent, proven, and modular strategy built on a scalable analytics platform. For this business need, Corios is pleased to introduce our Lightning solution.

Corios Lightning is a distribution planning and forecasting solution that provides a ten year hourly forecast of megawatt demand for every substation and feeder on your grid, adjusted for economic growth, load growth projects, capacity transfers and DER adoption.

Want to learn more about Corios Lightning for your utility’s grid modernization? Send me a note to today. Thanks!


Finding end-user models

Harder than hunting for needles in the haystack

The SAS Institute platform is a powerful tool that offers a host of data aggregation, data cleansing and analytical tools to your analyst community. Because of this breadth of capability, you may have analysts or teams creating what regulatory groups would consider models subject to model governance and compliance review. Furthermore, many SAS workloads qualify under the CECL, CCAR and IFRS9 regulatory guidelines as End User Computing workloads, which need to be inventoried, reviewed and placed under a governance scope.

Do you know who these teams and analysts are? Can you prove that your model governance process has identified all these models? Chances are, many of these models and End User Computing instances have gone unidentified, in many cases because they’re hiding in plain sight. SAS workloads can be created, executed and results generated through multiple means; there isn’t just one way to execute a SAS workload.
Read More

Tale of Three Cities

Modernizing traditional SAS business applications to Viya on AWS

Clients ask us this question frequently: “…Should we stick with our business applications on SAS 9.4, or should we take the plunge into SAS Viya? I’ve heard there are some functional differences between the two, and some of my colleagues are concerned that Viya implementations still feels new and a little risky. As a professional designer and implementer, what are Corios’ assessment of the risks and challenges (and benefits)?”

Everyone’s mileage will vary, but here is our experience with migrating three clients from traditional SAS to Viya on AWS. Our clients include a credit card issuing-bank, a commercial bank, and a business financial data clearinghouse. Read More

When the world hands you lemons, make lemonade

Adapting to market conditions with innovation

yellow juice in clear glass jar

We can’t control the market around us, especially in the economic downturn produced by the pandemic, but we can choose how to respond to it.

In a low-interest rate market environment like the US has experienced for the period 2008-2015 following the credit crunch, and again for the period April 2020 onwards, this makes it very challenging for banks to earn interest margins through lending. One strategy that some of our clients have followed is to encourage their commercial banking clients to make the most of treasury services, which generate fee income and aren’t dependent on interest rates. These treasury services are varied transaction and information services that help businesses manage their cash deposits and inter-party transactions. The image on the right illustrates the federal funds rate history for the period 1954-2021, with emphasis on the most recent years. When the federal funds rate is low, the interest rate that banks can charge on loans to their customers is correspondingly low.

Read More