Sai Rajesh
Tanikonda
I build data systems that enable real-time decision-making across supply chain, operations, and analytics workflows.
About Me
I build data systems that enable real-time decision-making across supply chain, operations, and analytics workflows.
I've built data pipelines and analytics systems used across supply chain and operational workflows, improving data latency, reliability, and decision speed.
My work spans batch and streaming systems, analytics engineering, and data platform design, with a focus on performance, reliability, and usability.
Projects
SkyStream
Real-time global flight tracking pipeline. Ingests ADS-B telemetry from ~9,000 aircraft every 10 seconds via Kafka to Spark Structured Streaming to Redis, rendered on a GPU-accelerated deck.gl map with sub-5-second end-to-end latency. Includes email landing alerts and 48-hour historical trail queries via TimescaleDB. Provides real-time visibility into global flight activity, enabling low-latency tracking and analytics for operational monitoring.
FinSight
AI-assisted financial analytics platform that brings market dashboards, portfolio intelligence, research notes, curated news, and Telegram delivery into one full-stack product powered by FastAPI, React, DuckDB, Spark, Kafka, and dbt. Enables near real-time financial analysis and portfolio tracking by combining streaming data pipelines with scalable analytics and intuitive querying.
Scalable URL Shortener
Cache-first URL shortener engineered for high read throughput. Redis handles the redirect hot path; async background workers flush click counters to PostgreSQL in batches. Real-time analytics UI, one-command Docker Compose deploy.
NYPD Arrests Pipeline
End-to-end analytics pipeline over 500K+ NYPD arrest records (2023-2024). Cleaned with Alteryx, modeled dimensionally, loaded to BigQuery for sub-second aggregations, visualized in an interactive Power BI dashboard by borough, offense type, and demographics. Transforms raw public data into structured datasets and dashboards for analyzing trends across geography and time.
EV Adoption Analysis
Visual deep-dive into U.S. electric vehicle adoption from 2010-2024. Analyzes charging infrastructure gaps, state-by-state adoption rates, and federal policy impact from 200K EVs in 2013 to over 4 million by 2024.
DIY CNC Plotter
2-axis CNC plotting machine built with Arduino UNO + GRBL firmware, 3D-printed components, and NEMA 17 stepper motors. Extended with an ESP32 IoT layer for wireless G-code transmission, browser-based control, and real-time telemetry.
Experience
- >Built and scaled a centralized analytics layer integrating multiple operational data sources to support real-time decision-making across resource allocation and distribution workflows.
- >Built a unified analytics layer across 6 data sources, eliminating 20+ hours per week of manual reconciliation.
- >Implemented data quality validation and reconciliation logic, reducing reporting discrepancies by 40%.
- >Developed a metrics service to standardize KPI definitions and reduce ad hoc reporting.
- >Enabled leadership to identify underperforming programs and optimize resource allocation.
- >Supported coursework in SQL and analytics while helping students and faculty use data more effectively.
- >Assisted 140+ students in SQL and analytics concepts.
- >Built dashboards to help faculty identify at-risk students and improve course outcomes.
- >Worked across multiple client engagements in supply chain and retail domains, building scalable data pipelines and analytics systems to support demand planning, inventory tracking, and operational decision-making.
- >Built supply chain data pipelines enabling near real-time inventory visibility and faster operational response.
- >Designed dimensional data models for procurement, supplier performance, and shipment analytics.
- >Reduced data latency from 12+ hours to under 1 hour using batch and streaming architectures.
- >Improved query performance and reduced compute costs through optimized data transformations.
- >Enabled business teams to analyze revenue and demand trends through Power BI and Tableau dashboards.
Blog Posts
Deep dives into the systems I build, the architecture, the decisions, and what I learned.
Every layer of the system: Kafka checkpoint gotchas that blanked the map, why Redis writes must precede Postgres, how deck.gl handles 9,000+ GPU-accelerated points, and the four production bugs I actually hit.
Read PostHow I combined market data pipelines, warehouse modeling, portfolio tooling, news aggregation, and a natural-language query layer into one end-to-end investing product.
Read PostHow cache-first architecture and async click tracking combine to build a URL shortener that stays fast under heavy read load without sacrificing analytics accuracy.
Read PostProfiling, cleaning, and modeling 500K+ arrest records into an interactive Power BI dashboard that surfaces borough-level crime patterns and demographic trends.
Read PostFrom 200K EVs in 2013 to over 4 million by 2024, a state-by-state breakdown of adoption rates, charging infrastructure gaps, and the policy drivers behind the transition.
Read PostContact
I'm actively looking for data engineering roles where I can work on high-throughput streaming systems, large-scale data infrastructure, and the tooling that makes data reliable at scale.