Headline

Traded Risk Analyst (Ex-HSBC) | Python-Based Risk Reporting Automation | KRI, MTM & Wrong-Way Risk Reporting | SQL, Power BI, Data Analytics

About

Traded Risk Analyst with hands-on experience automating risk and regulatory reporting at HSBC, backed by a strong quantitative foundation from my B.Tech in Information Technology (CGPA 8.89). At HSBC, I built Python automation for daily financial adjustment calculations across India and Thailand books, deployed to production. I also built an Excel-to-Word reporting pipeline covering 6 regions plus a global aggregated pack, turning raw data into structured reports to support regional risk review. Beyond that, I automated Wrong-Way Risk and Mark-to-Market exposure reporting for regulatory review, and developed an API integration with the CDCP platform to remove manual data retrieval. Beyond risk reporting, I work across SQL, Excel, and Power BI for data analysis and visualization, and I'm currently building a GenAI-based compliance tool using Python, LangChain, and the Gemini API to flag policy gaps against regulatory documents like RBI and Basel guidelines, with source citations and a hallucination guardrail. My background spans risk analytics, regulatory reporting, and process automation, shaped by internships across banking (HSBC), infrastructure (CRIS), and government compliance (GSTN). I care about turning manual, error-prone processes into reliable, automated systems, and about using data to support better risk decisions. I'm looking for full-time analyst roles in risk analytics, data analytics, or regulatory reporting, in Bengaluru, at organizations where I can keep building on this foundation. Open to connecting with anyone hiring or working in this space.

Location

Bengaluru

AI stack

claude code

claude

gemini

perplexity

claudecode

ChatGPT

Work experience

Analyst at HSBC, Feb 2026 - Aug 2026 · 7 mos, Bengaluru, Karnataka, India, Strengthened first-line-of-defense controls by reconciling access across 4 systems for ~438 Traded Risk users, flagging ~70 out-of-department and ~10 unverified users per system as control issues Automated financial adjustment calculations in Python across 2 book keys (India/Thailand), eliminating ~4 hrs/day and ~2 hrs/week of manual effort and accelerating Asia-region risk reporting Built an Excel-to-Word KRI reporting pipeline across 6 regions plus 1 global pack, replacing 10–15 hours of manual effort per regional report for senior risk review Detected and root-caused an FX rate source mismatch via cross-validation against a second data source, escalating and correcting inflated risk values before reporting

Intern at IRIS Business Services Limited, Jun 2025 - Jul 2025 · 2 mos, Remote, Root-caused and resolved integration failures in an event-driven Kafka CDC pipeline (Debezium, MongoDB, MinIO), tracing the fault to an incorrect connector image

Data Analyst at CRIS (Centre for Railway Information Systems), May 2025 - May 2025 · 1 mo, Delhi, Predicted railway infrastructure failure thresholds using regression analysis (R-squared 0.936, MAE 0.195), supporting proactive maintenance planning Applied statistical modeling to real-world degradation data, translating technical output into a maintenance-planning recommendation

Secretary at Terra VIT District 120 Toastmasters (Tamilnadu, India), Jul 2024 - Dec 2024 · 5 mo, Vellore

Data Analyst at GSTN (Goods and Services Tax Network), May 2024 - Jul 2024 · 2 mo, Delhi, Built and cross-validated a Random Forest fraud-detection model on GST compliance data, reaching 0.98 accuracy, 0.84 precision, and 0.94 recall, outperforming a logistic regression baseline Presented fraud-risk findings to stakeholders through a written report and deck, translating model output into actionable compliance recommendations

Education

Bachelor of Technology - BTech, Information Technology, Vellore Institute of Technology

Delhi Public School Ghaziabad

Public links

github: https://github.com/YagyaMohan