Coconut shell charcoal market price analytics
Role
Software Engineering Intern
Core Stack
FastAPI · React 19 · MongoDB
Analytics Engine
Highstock · pdfplumber
Client
Haycarb PLC
Introduction
Market-analytics web dashboard for coconut shell charcoal prices (US$/MT) across Sri Lanka, India, and Indonesia. Ingests 35+ monthly WPU reports and Excel sheets with automated pdfplumber table extraction and interactive Highstock analytics.
Architecture Overview
Full Architecture Breakdown
Next.js 16 (App Router) · React 19 · TypeScript
Modular, component-driven client architecture optimized for high interactivity, streaming markdown rendering, and reactive dashboards with zero-layout-shift UI.
Tailwind CSS
Design system & tokens
Recharts
Progress & score charts
Framer Motion
Smooth layout transitions
React Markdown
AI response formatting
Lucide Icons
Vector glyph library
SSR / Streaming
Instant route prefetching
Python 3.11 · Modular Routers
Asynchronous endpoint orchestration with Pydantic validation, structured exception boundaries, and automatic interactive documentation.
Gemini + Groq LPU
Dual-engine AI pipeline: ultra-low latency interactive generation via Groq alongside comprehensive concept analysis via Google Gemini.
Motor (Async) · 13 Models
Asynchronous NoSQL data models with strict schema typing via Beanie ODM and high-throughput vector queries.
Firebase + Playwright
JWT cookie sessions paired with Firebase Authentication and Firebase Admin SDK token validation.
End-to-end automated test suites running across Chromium, Firefox, and WebKit browsers.
Haycarb PLC · Market Analytics Dashboard
Benchmark Quotes in US$ per Metric Ton (MT) · CDA / CDB / UCAP Ingestion
Ingestion & Extraction Pipeline
Ingests monthly "Prices of Coconut Products" WPU reports (Jan 2023 – Nov 2025) plus Excel sheets via drag-and-drop.
Heuristic tabular parser detects date-header rows (dd/mm/yyyy), parses countries and regional markets, skipping non-quoted tokens.
Normalizes quotes into charcoal_prices collection with indexed temporal coordinates.
Serves aggregated time series via FastAPI REST endpoints to interactive Highcharts charts and instant PNG/CSV export.
FastAPI application with automated PDF/Excel parsing, CORS configuration, and asynchronous MongoDB connectivity via PyMongo.
Responsive market analytics portal powered by Highcharts Highstock, Recharts, and automated client-side jsPDF/Excel report exports.
Up Next in Portfolio · Deep Learning · Medical Imaging
A comparative deep-learning study of four convolutional neural network architectures for classifying diabetic retinopathy severity from retinal fundus images.