Franco – Workflow Automation, n8n, SQL

An end-to-end automated data validation and auditing platform. It cross-references complex bills of materials against industrial production order specifications in real time to identify data misalignments, volume discrepancies, and technical configuration errors before they reach the mass production line.

• Built the core logic using advanced LLMs to process and analyze complex, unstructured tabular data from large spreadsheets;
• Translated intricate operational rules, including calibration guidelines, matrix position mappings, and resource allocations, into deterministic prompts and validation pipelines;
• Created automated export mechanisms that consolidate validation findings into clean analytical dashboards and executive-ready reports;
• Owned the project from rapid prototyping in a sandbox environment to recurring execution in critical product launch operations.

Results & Metrics

• Reduced manual data reconciliation time from 2–4 hours per batch to under 5 minutes, achieving a 97% reduction in processing time;
• Caught critical volume discrepancies, including a 29% data pass-rate mismatch on one batch, and missing Priority 0 (P0) components, helping prevent costly full-batch manufacturing reruns estimated at $10,000–$50,000+ per incident;
• Achieved data auditing accuracy that eliminated human error across 100+ line items per run.

A centralized web application for tracking, planning, and reporting complex product releases across four e-commerce and retail sales channels. It serves as a single source of truth for GTM operations, replacing fragmented static spreadsheets with automated data compilation and dynamic exports for executive weekly reviews.

• Owned the entire development lifecycle, refactoring and migrating the initial application from a monolithic single-file prototype of approximately 5,200 lines into a modular, maintainable React architecture;
• Implemented utility features including automated CSV import, dynamic PDF generation, and PowerPoint export for stakeholder meetings;
• Led the field-definition and data-scoping phase to normalize schemas across multiple channel operations and support future data integrations;
• Partnered directly with product leads and GTM managers to translate operational bottlenecks into clean UI/UX components.

Results & Metrics

• Completely eliminated manual slide deck creation and spreadsheet reconciliation for weekly GTM reviews, saving an estimated 2–4 hours per week in pure prep work for the core team;
• Scaled across the broader GTM org, reclaiming 100–200 hours annually of collective team capacity previously wasted on manual data alignment;
• Massively reduced operational friction and coordination errors by establishing a strict data standard for synchronized cross-channel launch dates.

A production-grade AI automation platform for high-growth US clients. It transforms manual operations into intelligent workflows with custom LLM solutions, specializing in intelligent document processing and natural language data analytics interfaces.

• Designed and implemented multi-agent workflows and Retrieval-Augmented Generation (RAG) architectures tailored to client operational bottlenecks;
• Built advanced OCR pipelines to parse, extract, and structure data from high-volume, unstructured enterprise documents;
• Engineered secure text-to-SQL pipelines that allowed non-technical stakeholders to query internal databases using natural language;
• Established the technical client onboarding and intake framework to scope, benchmark, and scale AI automation projects.

Results & Metrics

• Successfully shipped 8+ end-to-end production tools, delivering over $35,000+ in high-value contract automation projects;
• Automated core business workflows that saved client operations hundreds of hours of manual labor and significantly reduced data entry error rates;
• Scaled delivery capabilities to independently manage cross-cultural communications and technical execution, maintaining a 100% project completion rate.

A financial education and investment consultancy serving individual clients with guidance on investment decisions, financial learning, and commercial support. The business combined advisory services with structured operations and data-driven acquisition processes to scale client delivery efficiently.

• Designed and executed data-backed growth and marketing frameworks focused on customer acquisition and long-term retention;
• Led ongoing market research and competitive analysis, continuously refining financial product offerings to match client demand;
• Built and managed strategic commercial partnerships and B2B networks to strengthen distribution channels;
• Developed internal reporting structures, mapped core business workflows, and introduced KPIs to support executive decision-making.

Results & Metrics

• Grew the client base from zero to 1,500+ active clients and scaled the team to 15 full-time employees;
• Optimized internal commercial management processes by introducing technology tools, significantly reducing administrative cycle times for client onboarding;
• Established a recognizable financial brand from zero institutional capital while maintaining strong margins through lean operations.