A Modern Approach to Asset Management: Integrating Simcorp Dimensions with Cloud Data Platforms

This paper will describe the way in which UNIFY has successfully integrated multiple technologies, including SimCorp Dimensions, Informatica PowerCenter ETL, Snowflake Cloud-based Data Warehouse, as well as IDL's Data Hub orchestration (or ETL), in order to convert a disparate and fragmented Asset Management platform into a truly cloud-native architecture. Through the use of Phased ETL Strategies and Agile/Scrum governance, UNIFY addresses many of the common challenges associated with legacy systems, including Fragile Integrations, Insufficient Data Sources, and High Maintenance Costs. Additionally, the UNIFY design has standardised data flows, provided for Very High Availability and enabled Seamless Migrations. Performance Studies conducted by the UNIFY development team indicate a marked improvement in overall efficiency, including Significant reductions in Query Costs and Increased Cache Hits; additionally, UNIFY has identified optimization opportunities using its Cost Dashboard. Future efforts will focus on the adoption of advanced technology, including GraphQL Federation, Real-Time Streaming, and AI-Driven Operations, as well as additional opportunities to improve scalability and reduce costs. Overall, the design created by UNIFY establishes a New Industry Standard for IT Transitioning of Asset Management platforms, while ensuring Compliance with Regulatory Requirements and Eliminating Legacy Silos.

Informatica PowerCenter ETL, Snowflake Cloud-based Data Warehouse, Seamless Migrations, GraphQL Federation, Real-Time Streaming, AI-Driven Operations

1. “Asset Management Explained: Key Roles and Benefits”, Meeyeon Park, https://corporatefinanceinstitute.com/resources/career-map/sell-side/capital-markets/asset-management/. [Google Scholar] [Crossref]

2. “5 Advantages of Hiring an Asset Management Company”, July 20, 2020, https://www.focusfinancial.com/5-advantages-of-hiring-an-asset-management-company/. [Google Scholar] [Crossref]

3. "Asset Management Explained: Key Roles and Benefits", Meeyeon Park, 2015, https://corporatefinanceinstitute.com/resources/career-map/sell-side/capital-markets/asset-management/. [Google Scholar] [Crossref]

4. "Redundant Software Functionality and Legacy Modernization : To Merge or Not to Merge", John Chang , 2019, https://www.castsoftware.com/pulse/merging-redundant-software-functionality-in-legacy-modernization . [Google Scholar] [Crossref]

5. "Mawer selects SimCorp Dimension as its investment management platform", Pavithra R, September 10, 2020 , https://ibsintelligence.com/ibsi-news/mawer-selects-simcorp-dimension-as-its-investment-management-platform/.. [Google Scholar] [Crossref]

6. "Streamlining Laboratory Operations: Overcoming the Challenges of Point-to-Point Integrations", June 23, 2023, https://scitara.com/blog/streamlining-laboratory-operations-overcoming-the-challenges-of-point-to-point-integrations/. [Google Scholar] [Crossref]

7. “Project, program and portfolio management as modes of organizing: Theorising at the intersection between mergers and acquisitions and project studies”, Joana Geraldi, Satu Teerikangas, Gustavo Birollo, May 2022, https://doi.org/10.1016/j.ijproman.2022.03.005. [Google Scholar] [Crossref]

8. “Unified Asset Investment Portfolio Management”, 2023, https://riio3.cadentgas.com/ documents/aejp_05.pdf. [Google Scholar] [Crossref]

9. “Transforming IT Asset Management”, 22 June 2023, greenbox, https://www.greenbox.com.au/ blog/2023/06/22/transforming-it-asset-management/. [Google Scholar] [Crossref]

10. "Improve Business Agility Through Platform Consolidation", June 2018, https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/analyst-report/servicenow-forrester-platform-consolidation.pdf . [Google Scholar] [Crossref]

11. “10 Best Practices to Avoid Cloud Vendor Lock-In”, Muhammad Raza, May 12, 2020, https://www.bmc.com/blogs/vendor-lock-in/. [Google Scholar] [Crossref]

12. “4 Reasons Why Building Your Own Portfolio Accounting System Is Risky”, Stephen Van de Wetering, Feb 27, 2020, https://www.empaxis.com/blog/in-house-portfolio-accounting-system-risks. [Google Scholar] [Crossref]

13. “Snowflake: Bar Chart in Native Streamlit”, Eric Heilman, 2023, https://ericheilman.com/2023/12/11/snowflake-bar-chart-in-native-streamlit/. [Google Scholar] [Crossref]

14. “8 Snowflake Metrics to Help You Optimize Your Spend Now”, Skye Callan, June 4, 2024, https://keebo.ai/2024/06/04/8-snowflake-metrics-to-help-you-optimize-your-spend-now/. [Google Scholar] [Crossref]

• Drone-Based Phenotyping and its Utilization in Crop Improvement: A Review
• An IoT-Enabled Smart Healthcare Monitoring System Using Machine Learning for Early Health Risk Prediction
• Strategic Integration of Artificial Intelligence for Achieving Operational Excellence in Container Freight Stations Using Evidence from Chennai, India
• Adoption of OTT platforms: Analyzing User Behavior through the UTAUT2 Model
• Customers’ Buying Behaviour in Relation to Online Food Delivery (Evidence from National Capital Region (NCR) of India)