Data Engineering • Applied AI • Analytics

Data & AI Engineer building reliable data platforms and AI-ready systems

Building cloud data pipelines, analytics-ready datasets, and applied ML/RAG solutions with Python, SQL, AWS, Azure, and Databricks.

Rihua V. - Data & AI Engineer

Featured Projects

NYC 311 Service Requests Lakehouse project thumbnail

AZURE DATA ENGINEERING

NYC 311 Service Requests Lakehouse

Azure-first medallion lakehouse for NYC 311 operational analytics, transforming raw API data into analytics-ready bronze, silver, and gold datasets.

Azure Data FactoryADLS Gen2DatabricksPySparkDelta LakePythonSQLPower BIGitHub Actions
CivicLens RAG architecture showing curated NYC 311 docs, local embeddings, PostgreSQL/pgvector retrieval, cited answers, sample analytics, and Streamlit UI.

AI DATA ENGINEERING / HYBRID RAG

COMPLETED LOCAL PROTOTYPE

CivicLens RAG — NYC 311 Operations Copilot

Local Hybrid RAG prototype for grounded NYC 311 documentation Q&A with citations, PostgreSQL/pgvector retrieval, sample analytics, and a Streamlit UI.

PythonPostgreSQLpgvectorStreamlitDockerRAGGitHub Actionspytest

Data Engineering

Cloud Flight Fare Pipeline project thumbnail

REAL AWS CLOUD PROOF

Cloud Flight Fare Pipeline

Real AWS cloud proof project showing EventBridge Scheduler -> ECS/Fargate -> Flight API -> S3 Bronze -> Redshift Serverless -> dbt staging/marts/tests -> CloudWatch Logs, with proof screenshots, runbooks, and cost/secret safety notes.

AWSECS/FargateEventBridgeS3RedshiftdbtDockerCloudWatch
Travelpayouts Flight Collector project thumbnail

PYTHON DATA INGESTION

Travelpayouts Flight Collector

Python API ingestion project that collects live Travelpayouts flight fare data and publishes dated CSV snapshots for analytics.

PythonAPI IngestionCSVSchedulingpytestGitHub Actions

Applied AI & Machine Learning

Leakage-safe financial complaint-routing architecture showing parallel TF-IDF and DistilBERT model paths, shared 2024 evaluation, model-specific routing, auto-route recommendations, and human review.

NLP CLASSIFICATION / SELECTIVE ROUTING

COMPLETED V1–V2 STUDY

Financial Complaint Auto-Routing with NLP

Leakage-safe eight-class CFPB complaint-routing study comparing a locked TF-IDF + Linear SVM benchmark with a frozen DistilBERT challenger, using development-selected routing policies and retrospective 2025 evaluation.

  • Corrected duplicate-text leakage and created group-aware 2024 development and final-test partitions with zero normalized-text overlap.
  • Compared the locked TF-IDF + Linear SVM benchmark with the frozen DistilBERT challenger; Macro F1 on the shared 2024 benchmark improved from 0.7671 to 0.7949.
Pythonscikit-learnTF-IDFLinear SVMPyTorchTransformersDistilBERTHuman-in-the-LoopGitHub Actions

Supporting Work

Sumryze - AI-Powered SEO Reporting Dashboard project thumbnail

AI REPORTING SAAS

Sumryze - AI-Powered SEO Reporting Dashboard

SaaS-style dashboard for automated SEO reporting, AI-generated summaries, analytics visualizations, and client-ready insights.

Next.jsTypeScriptTailwindOpenAIREST APIsVercel
Floral Daily SKU Analysis project thumbnail

DATA ANALYTICS

Floral Daily SKU Analysis

Daily SKU sales, margin, promotion, holiday, and waste analysis using Python, SQL, and Power BI to support inventory and business decisions.

PythonSQLPower BIInventory AnalyticsTrend Analysis
Flight Price Analytics project thumbnail

DATA SCIENCE

Flight Price Analytics

Time-based Buy/Wait classification and fare forecasting using route-level price snapshots, feature engineering, and backtesting.

Pythonscikit-learnForecastingTime-Based SplitPower BI

Skills & Tools

Orchestration & Workflow

Apache AirflowAzure Data FactoryEventBridge SchedulerGitHub Actions

Cloud Execution & Containers

DockerECS/FargateECRCloudWatch Logs

Storage, Lakehouse & Warehouse

ADLS Gen2Delta LakeDatabricksAmazon S3Redshift ServerlessPostgreSQL

Transformation & Modeling

PythonSQLPySparkdbtDimensional Modeling

Data Quality & CI

dbt TestspytestData ValidationValidation SQLGitHub Actions

Analytics & BI

Power BISQL MartsKPI DesignBI HandoffDocumentation

Data Science & Experimentation

EDAFeature EngineeringTime-Based ValidationClassificationForecastingBacktestingModel Comparison

Machine Learning & NLP

scikit-learnTF-IDFLinear SVMPyTorchTransformersDistilBERTText ClassificationModel Evaluation

AI / RAG Engineering

RAGVector SearchEmbeddingspgvectorCited AnswersStreamlitAI Evaluation

About

I’m a Data & AI Engineer focused on building reliable cloud data platforms and applied AI systems. I work across API ingestion, cloud storage, transformation, data quality, analytics, and ML/RAG workflows using Python, SQL, Azure, AWS, Databricks, and PostgreSQL.

I value reproducible workflows, clear evaluation, maintainable code, and documentation that makes technical decisions easy to review. My background in analytics and web development helps me connect backend data systems with reporting needs and polished user-facing applications.

Contact

Interested in collaborating on data engineering work or portfolio projects? Reach out and I will follow up.