Public tool
Synthetic Dataset Generator
A Python tool for generating realistic synthetic ecommerce datasets for SQL, BI, data science, and portfolio projects.
PythonSynthetic DataData EngineeringAnalyticsData ScienceCLI
Projects
Analytics products and automation systems
A first set of portfolio project summaries focused on business reporting, analytics assistants, data pipelines, and internal tools. Case studies will be added as public writeups are prepared.
Early working version
Job Seeking MCP
Remote MCP connector and Claude Skill that turn a CV into a structured AI-assisted job search workflow.
MCPAI WorkflowJob SearchClaudeAutomationPython
Live demo
Interview Andres Chatbot
A secure interview assistant that answers questions about my experience, projects, skills, and technical background using a server-side portfolio proxy.
Next.jsTypeScriptFastAPIOpenAIRailway
Live case study
Synthetic Web Data Pipeline
A synthetic web analytics data generator with Postgres, dbt-ready models, and a live portfolio dashboard for BI and analytics engineering practice.
PythonPostgresdbtYAMLSQLAnalytics engineering
Public case study
Synthetic Ecommerce SQL & Looker Studio Analysis
An analytics case study built on a synthetic ecommerce dataset, with documented SQL analysis and Looker Studio reports for customer, sales, and lifecycle insights.
SQLBigQueryLooker StudioCustomer analyticsRFMEcommerce
Case study coming soon
AI-Assisted Business Reporting System
A reporting workflow concept that combines structured analytics outputs with AI-assisted summaries to help stakeholders understand performance faster.
Next.jsTypeScriptSQLLLM workflowsBI reporting