Niranjan C

• Daily cryptocurrency ETL: extract from CoinGecko, transform with Pandas, load into a PostgreSQL star schema (fact_prices, dim_coins, dim_date).
• Airflow DAGs with retries, idempotency checks, and failure alerts; containerized via Docker Compose.

• Change Data Capture pipeline tracking source drift over time, with SCD Type 2 history in PostgreSQL.
• Trend data exposed via a FastAPI REST layer for downstream consumers.

• REST API backend with JWT auth, role-based access control, and a normalized schema via SQLAlchemy ORM.
• pytest coverage with GitHub Actions CI/CD running on every push.

• Retrieval-augmented Q&A over uploaded documents using pgvector similarity search and LangChain retrieval chains.

Data Analytics & Automation Pipeline

• Automated data cleaning, transformation, and reporting workflows for recurring analytics tasks.