Dolcy Sareen

Dolcy Sareen

Auto-generated profile, based on publicly available information

Dolcy Sareen

Okanagan College,Computer Science,Kelowna,Canada

Research Focus & Metrics

Academic Career Length

2Years (2025-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
7 April 2025
Verified
Conference Paper
Closed access
APAjitesh Parihar
Ajitesh Parihar
DSDolcy Sareen
Dolcy Sareen
DHDylan Huitema
Dylan Huitema
KCKristina Cormier
Kristina Cormier
YKYoury Khmelevsky
Youry Khmelevsky
AWAlbert Wong
Albert Wong
A DW is needed to efficiently and continuously prepare data for practical real-time data analysis and forecasting with machine learning (ML) algorithms. This paper discusses extraction, transformation, and loading process (ETL) automation and the critical subsystems integration for algorithmic trading ML modelling and stock market forecasting. Additionally, we discuss a new API designed for direct access to the DW. It opens vast opportunities for performance and data processing time to become critical nonfunctional requirements.

7 April 2025
Verified
Conference Paper
Closed access
KCKristina Cormier
Kristina Cormier
KGKeona Gagnier
Keona Gagnier
JPJoshua Padron-Uy
Joshua Padron-Uy
DSDolcy Sareen
Dolcy Sareen
APAjitesh Parihar
Ajitesh Parihar
AWAlbert Wong
Albert Wong
This research intends to implement a data warehouse (DW) and ETL (Extract, Transform, Load) process to handle time-series data used by an XGBoost model to predict stock market prices. The ETL pipeline automates data ingestion from Financial Modelling Prep (FMP) API [2], performs necessary transformation, and stores it for future use. Furthermore, it leverages its design to optimize resource usage. The paper also explores the DW performance and estimations for growing workloads.