personal infos

about avatar
  • First name: Rishav
  • Last name: Dhariwal
  • Location: Kolkata, WB
  • Phone: +91-XXXXX-XXXXX
  • Email: sam.rishav2002@gmail.com

4+

Completed Projects

Python

FastAPI, Scrapy Pandas, Numpy

R

Tidyverse, Shiny Tidymodels

Others

SQL, Docker Machine Learning

Experience

  • Aug 2024 - Sep 2025
    Application OwnerICICI Bank Pvt Ltd
    • Designed and deployed IFRA (Rate Engine for Forex Rates)'s centralized FX price generation system on AWS, integrating multiple price feeds (Reuters, 360T, Flex) via secure socket and websocket connections to deliver real-time forex rates to internal users and client-facing applications.
    • Engineered robust API integrations—including token-based authentication, bulk rate retrieval, and continuous rate streaming—to support round-the-clock FX deal booking.
    • Optimized AWS infrastructure using scalable components (Aurora Postgres, Redis, Lambda, Anthos API Gateway), ensuring high-performance delivery of forex rates with minimal latency.

Education

  • 2024
    B.E. in Mechanical EngineeringJadavpur University

    CGPA: 8.1

  • 2020
    Higher Secondary Education (12th Grade)Birla High School

    Completed ISC (Class XII) from 2008 to 2020.

Projects

  • 2025
    Financial Data Pipeline & OpenBB Integration[View Live Demo]Self
    • Engineered an end-to-end scalable data pipeline, deploying a containerized fleet of Scrapy spiders to extract macroeconomic and equities data across 370+ unique endpoints.
    • Automated data reconciliation and deployed spiders on a home server via Scrapyd, handling the orchestration from remotely available ScrapydWeb dashboard.
    • Developed a highly modular, fully-documented FastAPI delivery layer that achieves near-zero latency rendering.
    • Implemented alerts using log parsers to flag issues or data anomalies
    • Isolated the backend infrastructure within Docker containers and securely routed traffic via Cloudflare Trust tunnels, protecting the internal network perimeter.
    • Leveraged knowledge: Python, FastAPI, R, Scrapy, Docker, Cloudflare, ScrapydWeb, OpenBB, Log Parsing, SQL.
  • 2024
    N-gram Word Prediction Model[View Live Demo]Self
    • Implemented n-grams (unigram, bigram, trigram, 4-gram) frequency tables with stupid backoff.
    • Utilized a dictionary with a Jaccard metric-based string distance to handle erroneous text input.
    • Achieved overall top-3 score of 16.11%, top-1 precision of 11.68%, and top-3 precision of 20.05%.
    • Created a Shiny app hosted on shinyapps.io, featuring an intuitive user interface.
    • Leveraged knowledge: R, Tidyverse, Tidytext, Tidymodels, Shiny, HTML/CSS, Ggplot2, GitHub.
  • 2023
    EXL EQ' Challenge - PM 2.5 Concentration Prediction Tool[View Live Demo][View Research Methodology]Self
    • Developed a robust real-time prediction tool to forecast PM 2.5 concentration across multiple Indian cities.
    • Conducted exploratory data analysis, identifying daily and annual seasonality patterns.
    • Created three models, including two univariate models (one using STL decomposition with ARIMA on seasonally adjusted data and another using Dynamic Harmonic Regression with ARMA errors).
    • Performed multivariate analysis using stepwise regression combined with Dynamic Harmonic Regression with ARMA errors, achieving a final MAPE of approximately 20-25%.
    • Leveraged knowledge: R, Tidyverse, Tidymodels, Tsibble, Fable, Ggplot2.
  • 2022
    Strategic Analysis of Indian Benchmark Yield Curve, Real Interest Rate, and India VIXSelf
    • Assembled historical data for analysis and crafted dynamic visualizations (yield curve with interest rate changes).
    • Analysed and used statistical tests (cointegration and Ljung-Box tests) for hypothesis of how the yield curve changed under different market regimes (mainly liquidity and autoregressively on benchmark).
    • Leveraged knowledge: Statistical tests, Yield Curve Analysis, Web Scraping, SQL, Database Management.