Project Title:

SaaS Data Infrastructure – SalesPilotDW (Phase 1: Foundation)

Project Description:

Architected and deployed the core data platform foundation for a Next-Gen SaaS Sales Intelligence Hub on Oracle Cloud Infrastructure (OCI). This phase focuses on establishing a reliable data pipeline to centralize multi-source enterprise data.

Core Tech Stack & Tools Used: • Databases: Microsoft SQL Server, PostgreSQL • Infrastructure & DevOps: Oracle Cloud Infrastructure (OCI), Docker, Linux (Ubuntu/Oracle Linux) • Data Pipeline: Python, Medallion Architecture (Bronze, Silver, Gold layers), Crontab Automation

Key Achievements: • Successfully integrated disparate data sources including Sales Logs, Transaction CSVs, and Operational Data into a unified repository. • Built automated logging, execution tracking frameworks, and integrated a Telegram Bot API for real-time status alerts. • This foundational system provided a highly reliable data flow, setting the perfect baseline for subsequent advanced performance tuning and denormalization in Phase 2.