# Naveen Guru — Senior Data Analyst & Data Engineer

> Official portfolio, technical knowledge base, and machine-readable interfaces for Naveen Guru — Senior Data Analyst & Data Engineer 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
- **Role**: Senior Data Analyst & Data Engineer
- **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://naveensingh.guru
- **Location & Contact**: Bangalore, India • singhnaveen360@gmail.com

## 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 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
- [OpenAPI 3.1 Specification](https://naveensingh.guru/openapi.json): Comprehensive machine-readable schema for all public read-only API routes.
- [Developer Hub & API Documentation](https://naveensingh.guru/developers): Interactive API documentation with curl snippets and JSON schemas.
- [Public Profile API](https://naveensingh.guru/api/profile): Structured JSON payload containing complete biography, background, and verified social links.
- [Public Projects API](https://naveensingh.guru/api/projects): Machine-readable catalog of all live products with tech stacks and live URLs.
- [Public Skills API](https://naveensingh.guru/api/skills): Categorized technical skill matrix with proficiencies.
- [API Healthcheck](https://naveensingh.guru/api/health): Real-time API service health and uptime status.
- [About Naveen Guru](https://naveensingh.guru/about): Comprehensive engineering biography, career timeline, and architecture philosophy.
- [Contact & Availability](https://naveensingh.guru/contact): Direct communication channels, verification anchors, and collaboration details.
- [Privacy Policy](https://naveensingh.guru/privacy): Zero-tracking, zero-cookie, client-side only privacy commitment.
- [XML Sitemap](https://naveensingh.guru/sitemap.xml): Search crawler index of all canonical pages.

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