Spandan Roy
Financial Analyst(Risk Division) @Goldman Sachs || Ex-SWE 2 @Celigo
- Role
- Risk Analyst at Goldman Sachs
- Location
- Bengaluru, KA, IN
- LinkedIn followers
- 500 followers
About Spandan Roy
A proactive and fast learning individual working in the industry to help company achieve…
Experience
Risk Analyst
May 2024 — Present · Bengaluru, IN
Led the successful submission of over 52 Tier-1 IICE reports to the Federal Reserve Board (FRB), ensuring 100% accuracy in all variance analysis for CPE(collateralized potential exposure) and CCE(collateralized current exposure) metrics across weekly and monthly cycles.• Developed a full-scale automated report (Frequent Market Counterparty Data Collection) from the ground up using SLANG(Programming Language specific to Goldman Sachs), encompassing 130+ financial metrics at various levels of data granularity for seamless Federal Reserve Board (FRB) submission.• Designed and implemented a Python-based variance generation script to compare current and previous submissiondate reports, enabling early identification of data quality issues and significantly reducing manual review errors.• Enhanced the IICE report codebase, resulting in an 80% boost in efficiency and reducing time spent on weekly submissions by over 200 minutes per cycle.• Instituted robust Maker-Checker controls to eliminate manual errors in adjustment values, strengthening overall data governance and submission reliability.• Automated Variance Investigation in Python (Adding in driver details for sign-off by senior stakeholders),reducing the time spent by 20 hours and also avoiding human–error
Education
International Institute of Information Technology, Bhubaneswar
Bachelor of Technology - BTech
2019 — 2023
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.