Projects

FrescoLogic — AI-Powered Enterprise Warehouse & Order Management System

Production System Processing 23,000+ Units Monthly | Built with Advanced PHP/MySQL Architecture & Native OpenAI Integration

Engineered a second-generation order management platform replacing 3 years of manual warehouse operations (700,000+ historical records). This system represents enterprise-grade integration combining QuickBox ERP data pipelines with deep AI capabilities and real-time warehouse automation.

Advanced AI Integration (Not Automation Tools):

• Direct OpenAI API Integration: Custom PHP middleware connects OpenAI GPT models directly to MySQL database for real-time analysis—unlike generic automation (n8n, Zapier), enabling deep contextual intelligence impossible through standard workflows.
• AI Executive Summaries: Automatic generation of multi-dimensional business reports analyzing 800+ monthly invoices, 10,000+ line items, customer concentration, product performance, and predictive recommendations.
• Natural Language Chatbot: Custom-built AI assistant querying live database via GPT, answering complex business questions in milliseconds (e.g., "Which product sold most this month?" → instant cross-referenced analysis).
• Advanced Reporting Engine: Real-time analytics dashboard with top customers, top products, sales trends, and actionable business intelligence.

Enterprise Integration & Automation:

• QuickBox ERP Integration: Seamless CSV import pipeline transforming raw QuickBox invoice/order data into optimized warehouse operations in seconds.
• Warehouse Operations Automation: End-to-end order fulfillment: automated batch processing, picking optimization, shipment coordination—reducing manual warehouse work from hours to minutes.
• Smart Inventory Management: Real-time stock tracking with automatic low-stock alerts, predictive reordering based on sales velocity, preventing stockouts for high-volume products.
• Customer Portal: Secure multi-tenant interface allowing 76+ clients to access invoices, orders, delivery status, and historical data in real-time.

Technical Architecture:

• Pure PHP/MySQL Stack: No ORM overhead—optimized SQL queries, database-driven business logic, enterprise-grade security.
• API-First Design: RESTful architecture enabling seamless third-party integrations and scalability.
• Production Performance: Handles 23,000+ units monthly, 76 active customers, sub-second query response times with intelligent caching.

Impact: Transformed warehouse operations from manual/error-prone processes into fully automated, AI-informed system. Reduced order processing time by 90%, eliminated manual data entry, and provided client with AI-powered business intelligence previously unavailable.

FrescoLink — Secure, Infrastructure-Aware Messaging Platform

Built 100% from scratch by one developer. Enterprise-grade real-time messaging system with military-grade security, passwordless authentication, and end-to-end encryption. FrescoLink enables users to create verifiable digital identities and communicate securely with anyone, leveraging cutting-edge infrastructure technologies for enterprise-scale reliability.

Full-Stack Development (100% Solo):

• Backend API: Custom PHP API with enterprise-grade architecture, handling authentication, message routing, encryption, and real-time event streaming.
• Database Architecture: Designed and implemented scalable MySQL database schema optimized for high-concurrency messaging workloads.
• Frontend Application: Complete UI/UX design and React-based frontend, responsive across all devices with real-time message updates.
• Security Implementation: End-to-end encryption, JWT token management, SQL injection prevention, CSRF protection, and secure session handling.

Core Architecture:

• Zero-Dependency Core: Custom PHP router and middleware pipeline engineered from the ground up, eliminating bloat for maximum performance and security.
• Real-Time Communication (SSE): Server-Sent Events for instant message delivery, notifications, and status updates with millisecond latency.
• End-to-End Encryption: All messages encrypted at rest and in transit, ensuring complete privacy and compliance with enterprise security standards.

Advanced Authentication:

• Passwordless Security: Proprietary JWT-based authentication combined with dual-factor verification (email + SMS via Twilio) for maximum security without friction.
• Verifiable Identity: Users create and manage secure digital identities without traditional passwords, reducing attack surface by 90%.
• Enterprise Grade: Twilio integration for reliable SMS delivery, ensuring authentication reliability across global networks.

Cloud Infrastructure Stack:

• AWS Deployment: Complete system architecture on AWS — EC2 for API servers, RDS for MySQL database, and robust security groups for network isolation.
• Cloudflare Integration: Edge caching, DDoS protection, SSL/TLS termination, and R2 object storage for media files with CDN acceleration.
• Scalable Architecture: Engineered for horizontal scaling with load balancing, auto-failover, and high availability across multiple regions.

Real-Time Core Engine:

• JavaScript Message Hub: Ultra-responsive frontend core that manages real-time message delivery, notifications, and presence synchronization.
• Instant Notifications: Push-style updates via SSE keep users informed without polling overhead.
• Optimized Performance: Engineered for sub-100ms message latency even under high concurrency.

HelloFellow

Developed the entire frontend APP of the main project, transforming Figma designs into a responsive, pixel-perfect UI in under two weeks.
Developed the app using Flutter (iOS) and designed, programmed, and implemented all APIs required for full app functionality and seamless integration.
Designed, developed, and implemented AI-powered systems, including:

• Chatbot assistant to support user inquiries.
• License data extraction app using AI to process driver's license information in seconds.
• Image and icon generator with DALL-E to automatically create visuals for vehicle listings and system assets.
• Database + AI integration for automated reporting and statistical insights.

Contributed to backend development using PHP and MySQL for the desktop version.

NYC Restaurants Dashboard

Explore over 30,000 restaurants in New York City with a powerful dashboard offering instant search, rich details, and map insights. Access up-to-date information, including address, phone number, and cuisine type for 30,485 venues. Locate restaurants on Google Maps and find direct links to Google, Yelp, and OpenTable for more details.

This tool is designed for businesses aiming to market or sell products and services to restaurants, providing a direct channel to a massive market. When integrated with AI-powered marketing applications, this database has demonstrated the ability to significantly multiply customer acquisition.

AI Order System — Advanced Intelligent Order Processing (Not Just Chatbot)

Enterprise-Grade AI Integration Using Pure Code & OpenAI API | Unlike generic chatbot builders, this system uses deep programming expertise to create advanced AI-database intelligence.

Why This Is Different from Generic Chatbots:

• Not a Pre-Built Chatbot: No drag-and-drop builders (Bubble, Make, n8n). Built from ground zero using advanced PHP, JavaScript, and native OpenAI API integration for true custom intelligence.
• Direct Database Integration: AI models connected directly to MySQL database, enabling real-time contextual understanding of product inventory, pricing, availability, customer history, and business rules—impossible with standard chatbot platforms.
• Advanced Order Intelligence: System analyzes complex order patterns, validates against business rules, detects anomalies, cross-references inventory, and optimizes fulfillment—beyond simple order placement.

Dual-Module Architecture:

1. AI Customer Assistant Module: Natural language order interface powered by OpenAI GPT with deep database context. Customers converse in plain language while system:
   • Queries live inventory in real-time
   • Applies dynamic pricing & promotional rules
   • Cross-references customer history & preferences
   • Validates order feasibility before placement
   • Handles complex multi-SKU orders with intelligent recommendations
   Try AI Assistant
2. Order Management Dashboard: Real-time operational dashboard processing AI-generated orders with:
   • Automated batch processing & fulfillment workflows
   • Smart routing & logistics optimization
   • Real-time tracking & exception handling
   • Performance analytics & predictive insights
   View Management Dashboard

Technical Differentiation:

• Custom API Architecture: Proprietary middleware layer (not API wrapper) enabling bidirectional AI-database communication with custom business logic injection.
• Context-Aware AI: Unlike standard chatbots, system maintains session context, business rules, inventory state, and customer data for intelligent decision-making.
• Performance-Optimized: Sub-second response times processing complex queries through optimized SQL and intelligent caching.

Impact: Transforms order placement from static forms into intelligent conversational commerce with AI actively ensuring accuracy, compliance, and customer satisfaction at scale.

FrescoRoyal.com — The World's Finest Luxury Water Membership

The first luxury water subscription service in New York, delivering exclusive springs' finest waters directly to elite households. Sourced from the most exclusive springs on Earth, FrescoRoyal offers effortless hydration starting at $99/month.

Key Features:

• Effortless Luxury: Automatic replenishment tailored to your lifestyle. Never think about hydration again.
• Complete Control: Choose your delivery schedule, monthly, bi-weekly, or weekly. Cancel anytime, no questions asked.
• Bank-Level Security: PCI-DSS Level 1 Compliant, powered by Stripe (trusted by Amazon, Google, Zoom, and Uber). Your card data never touches our servers.
• Curated Selection: Choose from the world's finest still and sparkling waters.

Technical Highlights:

• Built entirely with vanilla JavaScript, PHP, and MySQL, zero dependencies, zero bloat.
• Powerful, scalable backend without thousands of lines of code or unnecessary frameworks.
• Integrated Stripe payment system for secure, seamless transactions.
• Clean, efficient architecture optimized for performance and security.

Dynamic Icons for Your Apps — Generated with AI and DALL·E 2

Add an item and automatically generate its icon using artificial intelligence (DALL·E). This example can be used for inventory systems, product lists, vehicles, spare parts, CRM, web apps, or any management system.

License Scanner AI

Effortlessly scan and extract license data with high precision. Simply take a photo or upload your license, and AI system will accurately read and input the information. Designed for seamless integration with any form, CRM, or management system, License Scanner AI streamlines data entry and enhances operational efficiency.

Passwordless Login

Sign in securely using your phone number or email—no password required. The system automatically detects your country and sends an access code anywhere in the world. Perfect for integration into any modern application, Passwordless Login offers a seamless, secure, and user-friendly authentication experience.