Sivagurunathan Sivaprakash

BBCRD: Currency Migration & Platform Upgrade
Led a critical modernization initiative for a core banking application involving currency migration and platform upgrades. The project included upgrading Spring Boot to the latest stable version, transitioning the runtime environment to JDK 17, and implementing enterprise-grade security using CyberArk and Vormetric Data Security Agent. This initiative enhanced application performance, security compliance, and long-term maintainability.
Key Responsibilities & Achievements:
• Directed end-to-end migration strategy and led a cross-functional team through Spring Boot and JDK 17 upgrades.
• Ensured seamless integration of CyberArk for secrets management, eliminating hardcoded credentials and improving auditability.
• Deployed Vormetric agent for encryption of sensitive financial data at rest, aligning with banking regulatory requirements.
• Coordinated with security, DevOps, and QA teams to ensure successful deployment with zero downtime.
• Conducted technical risk assessments, code refactoring, regression testing, and performance tuning across environments.
• Delivered comprehensive documentation and knowledge transfer to internal stakeholders and support teams.


EDLM - Data Purging Framework

Led the design and development of a scalable, configurable Data Purging solution implemented as a shared library and Spring Boot microservice, with extended support for deployment as an Azure Function App. The solution enabled consistent, policy-driven data retention management across banking applications while ensuring compliance and performance optimization.
Key Responsibilities & Achievements:
• Architected a modular Data Purging framework as a reusable shared library with externalized configurations for retention rules, batch operations, and error handling.
• Developed a Spring Boot service and integrated support for Azure Function App to enable cloud-native, event-driven execution with minimal infrastructure overhead.
• Enabled secure, tenant-aware data purging with support for audit logging, exception tracking, and rollback capabilities.
• Integrated with enterprise schedulers, Azure Logic Apps, and monitoring tools for seamless orchestration and observability.
• Delivered a deployment guide and configuration toolkit to accelerate adoption across internal product teams.
• Contributed to improved regulatory compliance, reduced storage costs, and enhanced operational efficiency across multiple lines of business.

• Prime brokerage is a set of services designed to facilitate the trading of equities, fixed income securities, commodities and derivatives, facilitate securities lending between institutional investors.
• PSDI Framework is Strategic initiative to develop a Global Database for Stock Borrow Loan sourced from Global One. The source information includes Counterparty, Positions, Activities, Cost of Funds, Pending Marks files are processed, transformed by applying business rules driven by business logic and Loaded into the database which then used to generate reports /feeds to downstream systems.
• Successfully led the upgrade of PSDI framework to the latest spring libraries to enhance its functionality and performance.
• Conducted a comprehensive analysis of the existing system to identify outdated Java 6 based components and spring dependencies.
• Researched and evaluated the latest spring libraries and frameworks relevant to the project, ensuring they align with the organization's recommended libraries and requirements.
• Rewritten existing single threaded model to an optimized multi-thread model by using thread pools to manage threads efficiently, reuse threads, and limit the number of concurrent threads to match hardware capabilities.
• Introduced Netty based api-gateway services and upgraded protocols to use HTTP/2 to reduce network latency. And used SFTP connection pooling to minimize overhead.
• Developed a detailed upgrade plan, including risk assessment and mitigation strategies.
• Collaborated with a cross-functional team of developers, system administrators, and stakeholders to execute the upgrade, ensuring minimal disruption to ongoing operations.
• Implemented code branching strategies, ACCP pipeline integration, Fortify / black duck integration to safely manage the transition.
• Actively monitored and tested the upgraded platform, promptly addressing any compatibility issues or bugs that arose during the process.
• Ensured that the upgrade adhered to industry best practices and coding standards, maintaining high code quality.

• Engaged in the product development cycle of Road to Paperless Implementation which allows customers to capture e-Sign for all Personal/Private Banking needs.
• Involved in the Enhancement of Chequing/Savings/ODP origination transaction to integrate with e-sign experience and integration with consent Capture API.

• PSDI EQL Next Gen Trading Service is designed to calculate and publish the target availability in real time based on the Loan One security summary position and static global configuration and client profile.
• Target availability base line will be published to EQUILEND over MQ. PSDI will receive real time updates for L1 Security Summary positions and G1 Activity, based on change in position will target availability will be published to EQUILEND via MQ.
• PSDI will be receiving (pulling) OOIN messages from EQUILEND via MQ. The order will processed & validated by Multithreaded based service called PSDI EQL service.
• Engaged in the entire product development cycle of PSDI EQL Next Gen Trading Service from understanding business objectives, user goals, and provided solution that are real-time, fault-tolerant end-points for availability posting, Order processing and Trade ticket processing system (Spring Integration API, Hazel cast based Microservices using IBM MQ & Oracle).
• PSDI_EQL is developed as Multi thread application by leveraging the concurrency utilities such as synchronized blocks, locks, atomic variables to prevent race conditions and ensure thread safety as it require near real time processing.
• Liaison with company subject matter experts and provide solutions.
• Identify opportunities for operational improvement and assist in the development and roll-out of new development/configuration methods for PSDI platform.
• Performs performance tuning to improve performance over multiple functions.
• Conduct module level work effort estimates & task lists using the established estimation tool.
• Designed and implemented an intranet Web Application to view reports and maintain the Auto lending Process (Vue JS, HTML, JavaScript, Jquery).

• Piloted, Re-Architected, Designed and developed an Integration solution for Special Loan and Advisory Services Engagements (SLASE) Project which manages RBC’s global high risk portfolio Relationship business loans, Investment and commercial mortgages using Spring Boot Rest Micro-services and VueJS Framework for a faster UI Development and ETL framework using Spark, Hive and Hadoop.
• Reviewed and analyzed existing architecture Special Loan Recoveries Details Application and made recommendations for improving and enhancement by switching to a Spring Boot based Micro services Framework.
• Developed reusable UI components using VueJS and aide the development team to seamlessly integrate with existing JQuery based Web applications.
• Involved in Data modeling to develop models for Hive tables to retrieve data from Data Lake.
• Developed ETL batch Process in spring boot framework to retrieve data from Data Lake using HDFS, Hive and Spark and loaded to SQL Server using spring batch as the sqoop support was limited.
• Configured and setup Project for Continuous Integration using Git, Jenkins, Nexus, UCD and Blue Mix.

• PSDI is a Spring based Integration Framework which provides different services to source security information from CSM for GPF Securities Lending database which includes sourcing security static & analytics, prices, corporate actions & dividends, foreign exchange rates and index (bench mark) rates.
• Piloted and spearheaded the implementation of PSDI framework, a custom-developed SOA platform based on Spring Integration which provides different services to source security information from CSM for GPF Securities Lending database which includes sourcing security static & analytics, prices, corporate actions & dividends, foreign exchange rates and index (bench mark) rates.
• Designed, developed an PSDI Transformation Service as a service solution which provides capabilities to enable subscribers to extract, process, transform and load data involving any combination of endpoints like file, database, message queues with support to most industry standard data transfer formats including XML, delimited, fixed-length, database query sets, EXCEL, SWIFT, JSON.
• PSDI Transformation was developed as configurable service which is highly scalable and extensible in nature.
• Designed, Developed the File Distribution Service which enables PSDI Platform to have a configurable, centralized and managed file transfer service.
• Apart from providing automated file transfers, FDS provides a data workflow orchestration model for the inbound files from their origin through various steps like executing reporting service, ETL (extract, transform, load) using PSDI transformation etc., to their final destinations.
• It also supports error notifications and escalations which delivers greater business value to PSDI platform.
• FDS service provided a quick, easy and timely transition of all GPFIS FTP jobs from legacy ftp server.
• Designed and developed a configuration-based Rule evaluation Service modeled on spring expression language with a human readable syntax which can be integrated to any of PSDI Services to aide better data processing capability.
• Migrated the legacy Global Locate Lender Availability email reader process to Email distribution Service implemented on PSDI platform to read & identify emails, extract attachment and content.
• Integration with FDS, Rule Service and Transformation Service provides end to end workflow to distribute lender availability to Global Locate application.
• Configuration and rule driven setup helps to quickly on-board new lenders.
• Using PSDI message services, developed real time SWIFT interface with complete ability to track and process SWIFT messages and acknowledgments.
• Extended PSDI transformation to parse and compose SWIFT messages.
• Achieved an efficient straight through processing to enable Cash Prime Broker clients to subscribe and publish SWIFT message.
• Message router configuration allows to distribute incoming SWIFT message to different subscribers with Multithreaded Model to enhance performance.
• Developed Asset Allocation Engine for Cash Prime Broker Phase I of Re-hypothecation process to calculate client indebtedness, project settlement ladder to compute availability and implement rules to optimize the asset selection based on user defined criteria/rules.
• Implemented a data model to allow users to select special securities, exclude position based on security, security class, market and/or account.
• Lead and developed a rest-based Report Execution Service in association with data-cache service to simultaneously render reports and distribute to clients.
• Extended the PSDI transformation service to support PDF rendering.
• Configuration based approach provides flexibility to generate and/or distribute reports to new clients.
• Compared to the legacy style report generation, the service-based approach provided great efficiency and reliability, it also provided ease of tracking and re-running selective reports via Prime Services Dashboard.
• On-boarded Pleeco by orchestrating the Docker deployment to different nodes of Scotia Private Cloud through indigenously developed puppet scripts.
• Developed PSDI dashboard for tracking and support activities using Angular Js and spring boot rest services.
• Lead the CIAD initiative to migrate PSDI framework into continuous integration platform using Bit bucket, Jenkins, Frog’s Artifactory and Puppet.

• Designed and developed multiple software applications for various clients like Controller General of Defense Accounts, ITEC, and GE.
• Implementing design compositions using JSP, Servlets, EJB, portlets and several Design patterns in a standard, maintainable and compliant way.
• Instrumenting, debugging and profiling applications to focus optimization efforts.
• Developing coding conventions and standards to enhance source code management and increase software maintainability.
• Developed modern web applications using JSP, Servlets, and HTML and JavaScript technologies.