The Client provides best-in-class services for leading hedge funds around the world. Their solution included fund administration, integrated risk & portfolio management, middle office services, tax support, regulatory & compliance reporting, and complete shadow accounting services, underpinned by SOC 1 certified controls.
Intricity is a team of specialized Data Management, Data Warehousing, and Business Intelligence experts. The team members at Intricity have been handpicked over the course of 20 years, and represent the top talent globally in Data-oriented disciplines.
Challenge and Wins
Reporting and Analytics were an important part of the Client’s administration platform. However, these data-hungry applications were bottlenecked by the limitations imposed by SQL Server. The Client could see that Snowflake would provide the scale they needed to eliminate the limitations imposed by a fixed hardware solution. However, making such a transition appeared to be a daunting task to their team, as many years of work had been put into their SQL Server Data Warehouse. While the desire to move to the cloud was high, the team was looking for wins that they could obtain in the current fiscal year.
Win 1: Mirroring
To build an immediate win, Intricity designed a reference architecture that used the first step in Intricity’s “Do No Harm” DW Migration solution. (see https://view.attach.io/r1lxy6l2X) This step produces immediate value because the operational benefits of being on Snowflake can be realized by end users instantly. This strategy focuses on replicating the schema and data on the old Data Warehouse into the new target platform. The ETL and other core data integration routines remain untouched in this step.
Win 2: Non-Disruptive Performance
As the Client began to reroute their BI content to point to Snowflake rather than SQL Server, the users of that content saw an immediate change in performance. Not only was the data access faster, but the concurrency barriers were now a non-issue. To the community of users, it simply appeared that their analytics suddenly got a shot in the arm.
Win 3: Room to Redesign Integration Logic
While the replication solution provided an immediate fix to performance issues, the Client would ultimately want to take SQL Server out of the picture. To do this, the integration logic needed to be rewired to point directly to Snowflake. While this would be a pressure cooker situation in most projects, the solution satisfied the user's need for performance and allowed the Client to take its time converting the integration logic. After Intricity designed and deployed the replication solution, the Client team was able to take over and work over an extended timeline, greatly reducing impacts on the conversion budget.
Who is Intricity?
Intricity is a specialized selection of over 100 Data Management Professionals, with offices located across the USA and Headquarters in New York City. Our team of experts has implemented in a variety of Industries including, Healthcare, Insurance, Manufacturing, Financial Services, Media, Pharmaceutical, Retail, and others. Intricity is uniquely positioned as a partner to the business that deeply understands what makes the data tick. This joint knowledge and acumen has positioned Intricity to beat out its Big 4 competitors time and time again. Intricity’s area of expertise spans the entirety of the information lifecycle. This means when you’re problem involves data; Intricity will be a trusted partner. Intricity's services cover a broad range of data-to-information engineering needs:
What Makes Intricity Different?
While Intricity conducts highly intricate and complex data management projects, Intricity is first a foremost a Business User Centric consulting company. Our internal slogan is to Simplify Complexity. This means that we take complex data management challenges and not only make them understandable to the business but also make them easier to operate. Intricity does this through using tools and techniques that are familiar to business people but adapted for IT content.
Intricity authors a highly sought after Data Management Video Series targeted towards Business Stakeholders at https://www.intricity.com/videos. These videos are used in universities across the world. Here is a small set of universities leveraging Intricity’s videos as a teaching tool:
Talk With a Specialist
If you would like to talk with an Intricity Specialist about your particular scenario, don’t hesitate to reach out to us. You can write us an email:email@example.com
(C) 2020 by Intricity, LLC
This content is the sole property of Intricity LLC. No reproduction can be made without Intricity's explicit consent.
Intricity, LLC. 244 Fifth Avenue Suite 2026 New York, NY 10001 Phone: 212.461.1100 • Fax: 212.461.1110 • Website:www.intricity.com