Gagandeep Singh

Roles & Responsibilities Project Description Roles & Responsibilities

Project: Core Banking & Wealth Management Platform

Domain: Banking / Asset & Wealth Management

Description:

The system handled fund-level and account-level tracking such as segregated fund P&L, total investments, daily profit-loss reports, recent trades, and trade approval flows.

• Contributed to backend development using ASP.NET Core Web API, .NET Core MVC, and C#, focusing on scalability, maintainability, and performance.
• Developed and maintained secure RESTful APIs for authentication, authorization, and data access, aligned with banking and financial security standards.
• Worked on wealth and portfolio management modules, supporting investment transactions, account handling, and portfolio data processing.
• Designed, modified, and optimized SQL Server stored procedures, views, and triggers to support high-volume transactional and reporting workloads resulting in a 50% improvement in scalability and reduced response times.
• Improved database performance through query optimization and indexing, contributing to better response times and scalability.
• Supported transaction processing and pricing workflows, ensuring data accuracy and consistency across systems.
• Assisted in developing and maintaining ETL and data integration processes for client-specific data transformation and system interoperability.
• Ensured data integrity, auditability , and compliance, critical for regulated banking and investment environments.
• Supported deployment of backend services on Microsoft Azure, following best practices for cloud security, availability, and uptime.
• Achieved data integrity, auditability , and compliance testing, establishing a solid foundation for future enhancements and performance improvements
• Collaborated closely with QA, DevOps, and business teams on testing, CI/CD pipelines, and production deployments using Azure DevOps, Git, and Postman.
• Actively participated in Agile Scrum ceremonies including sprint planning, daily stand-ups, reviews, and retrospectives.
• Assisted in internal testing and defect resolution, contributing to stable releases and continuous system improvements.

Modules: GAM FV NAV Manager Domain: Banking / Asset & Wealth Management

Technology Stack:

• Frontend: Angular 7, TypeScript, HTML, CSS, JavaScript.
• Backend: ASP.NET Core Web API, .NET Core, C#
• Database: SQ Agile (Scrum) ed Procedures, Views, Triggers, Jobs)
• Tools: SSMS, Azure DevOps, Git, Postman
• Methodology: Agile (Scrum)

Worked on an investment and banking platform used for portfolio management, NAV calculation, daily pricing updates, and trade validation.
The system processes AM, PM, and late-night batch jobs, validates financial trades, and ensures accurate pricing and compliance across mutual fund and sub-advised portfolios.

• Contributed to backend development using ASP.NET Core Web API and C# for pricing and trade validation modules.
• Worked on Angular 7 frontend screens, implementing UI changes and usability improvements based on business requirements.
• Supported daily AM and PM price update processes, including updating dates and validating pricing data through SQL queries.
• Actively worked on SQL Server stored procedures and complex queries related to pricing, trade checks, and batch execution.
• Assisted in job scheduling and monitoring, working with database tables such as:
  Jobs
  Job History
  Job Schedule Monitor
  Job Schedule configuration
  Job Specific Configuration
• Updated job run dates, run times, and execution status to ensure smooth daily batch processing.
• Worked on multiple trade validation dashboards, including:
  Combined Trade Check
  MF Trade Check Dashboard
  Trade Check Summary
  Toronto & Vancouver Traded (Sub-Advised)
  Blue Bay Sub-Advised
  Total Gain & Loss Reports
• Implemented and validated trade checks for:
  Security Name and Primary Asset ID
  Transaction and Security Type
  Trade Date and Timestamp
  Backend Trade Price vs Last Price comparison
  Currency validation flags
• Enhanced search functionality:
  Earlier system supported only exact Primary Asset ID search
  Improved it to support partial and keyword-based search, returning similar matching results
• Worked on configuration tables to manage AM Morning, PM, and Late-Night processing windows.
• Supported file upload and batch interfaces related to pricing calculation and trade check processes.
• Collaborated with senior developers, QA, and business analysts in an Agile Scrum environment.
• Assisted in production support activities, resolving data and job-related issues in a financial production system.