Sidharth Bijo

Data Analyst • Data Engineer • Data Scientist

I build data pipelines, analytics tools, and end-to-end applications that turn messy data into clear insights. Strong in Python, SQL, ETL, and dashboarding.

ResumeGitHubLinkedIn

Projects

Selected work

Stock Market Data Pipeline

Python • Apache Airflow • AWS S3 • PostgreSQL • Pandas

GitHub
  • Built a fully automated ETL pipeline to extract, transform, and load stock market data into an analytics-ready warehouse, implementing a data lake pattern in AWS S3 for raw and processed datasets.
  • Orchestrated daily pipeline execution with Apache Airflow, implementing task sequencing and failure handling.
  • Integrated PostgreSQL as a data warehouse for downstream SQL analytics.

Real Estate Portfolio Dashboard

Power BI • DAX • CSV Data Modeling

View Dashboard
  • Designed and developed an interactive Power BI dashboard analyzing Q1 2025 performance across 6 properties tracking $794K in revenue, occupancy rates, and net income by location.
  • Created DAX measures to calculate net income and average occupancy, enabling dynamic KPI reporting across property types and locations.
  • Built interactive slicers for real-time filtering by location, property type, and month to support operational decision-making.

Personal Expense Tracker Web Application

Python • Flask • SQLAlchemy • SQLite • Bootstrap

GitHub
  • Designed and developed a full-stack financial tracking application managing expenses, budgets, and incomes.
  • Implemented relational models and CRUD operations in SQLite to store and query structured financial data.
  • Developed interactive dashboards for trend analysis and financial forecasting.

NBA Player Probability Calculator

Python • NumPy • SciPy • Pandas

GitHub
  • Calculates the likelihood of an NBA player exceeding performance lines using historical stats.
  • Uses statistical analysis and probability distribution functions to provide insights.
  • Includes optional filtering by specific opponents.