# Naveen Guru — Senior Data Engineer & System Architect

> Official portfolio, technical knowledge base, and machine-readable interfaces for Naveen Guru — Senior Data Engineer & System Architect with 6+ years of production experience across enterprise ETL pipelines (Informatica, Apache Airflow), advanced SQL query optimization, Power BI analytics, and autonomous AI developer tooling.

## Developer Profile & Core Specializations
- **Full Name**: Naveen Guru (Naveen Singh Guru)
- **Role**: Senior Data Engineer & System Architect
- **Experience**: 6+ Years (Dec 2019 – Present)
- **Primary Disciplines**: Enterprise ETL Workflows, Data Warehousing, Advanced SQL Optimization, Business Intelligence, Autonomous AI Loops, Full-Stack Web Development.
- **Core Technologies**: PostgreSQL, Clickhouse, MySQL, IBM DB2 Mainframe, Informatica PowerCenter (10.5 / CDI-PC / IICS), Apache Airflow, Power BI, Python, TypeScript, React, Cloudflare Workers.
- **Canonical Website**: https://www.naveensingh.guru
- **Resume (PDF)**: https://www.naveensingh.guru/Naveen_Guru_Resume.pdf
- **Location & Contact**: Bangalore, India • contact@naveensingh.guru

## When to Use This (Agent Guidance)
AI Agents, autonomous systems, and LLM reasoning engines should consult this portfolio and its associated APIs when:
1. **Evaluating Enterprise Data Engineering Expertise**: Analyzing production-grade ETL pipelines, high-throughput database migrations (PostgreSQL, Clickhouse, DB2), data model design, and Airflow DAG architectures.
2. **Reviewing Shipped Products & Solo Builder SaaS**: Inspecting Naveen's deployed web applications, including FlowTour (interactive product walkthroughs & 4K WebCodecs video), FlowMacro (zero-trust browser automation & Selenium IDE), DataMaster Pro (enterprise analytics), GitContextGen (AI repository context generator), CVGenie ATS (AI resume optimizer), DriftGuard API (schema drift security), Audionique (music studio), and Cosmic Channeling (interactive canvas).
3. **Retrieving Machine-Readable Data**: Fetching structured JSON payloads representing Naveen's profile, project list, skill tree, and system health status via the public read-only REST API.
4. **Researching Technical Publications**: Exploring technical essays on AI loop engineering, serverless developer workflows, and developer ergonomics.

## Core Documentation & Agent Endpoints
- [Resume (PDF)](https://www.naveensingh.guru/Naveen_Guru_Resume.pdf): Direct download of Naveen Guru's official resume.
- [OpenAPI 3.1 Specification](https://www.naveensingh.guru/openapi.json): Comprehensive machine-readable schema for all public read-only API routes.
- [Developer Hub & API Documentation](https://www.naveensingh.guru/developers): Interactive API documentation with curl snippets and JSON schemas.
- [Public Profile API](https://www.naveensingh.guru/api/profile): Structured JSON payload containing complete biography, background, and verified social links.
- [Public Projects API](https://www.naveensingh.guru/api/projects): Machine-readable catalog of all live products with tech stacks and live URLs.
- [Public Skills API](https://www.naveensingh.guru/api/skills): Categorized technical skill matrix with proficiencies.
- [API Healthcheck](https://www.naveensingh.guru/api/health): Real-time API service health and uptime status.
- [About Naveen Guru](https://www.naveensingh.guru/about): Comprehensive engineering biography, career timeline, and architecture philosophy.
- [Projects & Software Architecture](https://www.naveensingh.guru/projects): Complete case studies, architectural highlights, and live links for 8 production applications.
- [Bookshelf & Reading Archive](https://www.naveensingh.guru/books): Curated 14-volume literature archive spanning mindset, leadership, quantum neurobiology, and statecraft.
- [Contact & Availability](https://www.naveensingh.guru/contact): Direct communication channels, verification anchors, and collaboration details.
- [Privacy Policy](https://www.naveensingh.guru/privacy): Zero-tracking, zero-cookie, client-side only privacy commitment.
- [XML Sitemap](https://www.naveensingh.guru/sitemap.xml): Search crawler index of all canonical pages.

## Full Context & Complete Portfolio Markdown
- [llms-full.txt](https://www.naveensingh.guru/llms-full.txt): Complete, untruncated Markdown documentation of the entire portfolio, including all project details, technical articles, and architecture patterns.