personal infos

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

4+

Completed Projects

Python

Scrapy, FastAPI Numpy, Pandas

R

Tidyverse, Shiny Tidymodels

Others

AWS, SQL Git, Bash

Experience

  • Aug 2024 - Present
    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

  • 2023
    Constructing a Financial Data Pipeline for Generating SignalsSelf

    Built a scalable data pipeline scraping 100+ economic/financial indicators (e.g., stock prices, bond markets, monetary policies) using Python and Scrapy. Reverse-engineered 30+ APIs, deployed spiders on a home server via Scrapyd, and automated scheduling. Designed 100+ schemas for structured data storage in JSONL format, ensuring consistency across topics like inflation, employment, and commodities. Implemented alerts using log parsers to flag issues or data anomalies and made a ScrapydWeb dashboard with Ngrok for API endpoint for remote monitoring. Leveraged knowledge: Python, Scrapy, Pandas, R, Scrapyd, ScrapydWeb, JSONL, SQL, Log Parsing, Cron.

  • 2023
    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.

  • 2023
    EXL EQ' 2023 Challenge - Real-Time PM 2.5 Concentration Prediction ToolSelf

    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
    N-gram Word Prediction ModelSelf

    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.