Sandeep Sarngadharan

Building a Resilient ODS Integrating Graph Algorithms and Azure for Enterprise Analytics.

Abstract:

The establishment of a contemporary Operational Data Store (ODS) design and architecture incorporates investment, financial, operational, and market-related datasets across various countries into one central repository at a multinational Private Equity Firm. The architecture incorporates an event-driven and graph-aware design methodology with a selective refresh approach for overcoming challenges related to very large datasets, multiple dependencies between financial indicators, and real- time updating and synching of data. By utilizing various Azure-native services paired with superior graph algorithms, the Platform offers more scalability around data management, better manages intelligent re-calculation capabilities, and provides near- real-time analytics. By offering a consolidated view in terms of corporate reporting this architecture has also significantly improved overall operational efficiency while simultaneously lowering costs and increasing the speed at which decisions can be made. Additionally, this research provides the groundwork for further developing automation and predictive analytic capabilities while emphasizing the value of creating innovative ODS designs that revolutionize the way in which financial/market-related data is managed.

Profile:

Sandeep Sarngadharan is a seasoned Solutions Architect with over 15 years of experience in the information technology industry, including more than six years specializing in Azure cloud architecture and data engineering. Throughout his career, he has been passionate about designing scalable, secure, and high-performing cloud solutions that help organizations modernize their technology landscape and achieve meaningful digital transformation
Sandeep has extensive expertise in architecting enterprise-grade systems using Microsoft Azure and other modern cloud technologies. He has successfully led several large-scale initiatives involving the migration of legacy applications to the cloud, modernization of data platforms, and implementation of resilient, high-availability architectures. His work often focuses on building robust data pipelines, enabling advanced analytics, and ensuring strong governance and security practices across enterprise environments.
Over the years, Sandeep has worked across multiple industries including private equity, life sciences, retail, and asset management. His technical skill set spans a wide range of technologies such as C#, Python, Node.js, Spark, SQL, Azure services, and DevOps tools. He is particularly skilled at bridging the gap between business goals and technical architecture, helping organizations adopt modern cloud-native approaches such as microservices, event-driven systems, and scalable analytics platforms.
In addition to his technical expertise, Sandeep is known for his collaborative approach and leadership in cross-functional teams. He enjoys mentoring engineers, evaluating new technologies, and guiding strategic decisions such as build-versus-buy analyses to ensure long-term scalability and value. With a strong background in software development and cloud architecture, he continues to focus on delivering innovative solutions that drive operational efficiency and long-term growth for organizations.