build a small e-commerce database in MYSQL and used SQL to turn raw data into useful sales insigh...build a small e-commerce database in MYSQL and used SQL to turn raw data into useful sales insigh...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
build a small e-commerce database in MYSQL and used SQL to turn raw data into useful sales insights. worked with multiple tables, joins, revenue analysis, product performance, customer spending and monthly trends
One of my recent projects is ReachFlux, a SaaS marketing platform built with PHP, Laravel and MySQL.
I worked on the application structure, authentication, user roles, dashboards, database management, APIs, campaign management, and responsive frontend.
Tech stack:
PHP · Laravel · MySQL · JavaScript · AJAX · Bootstrap · REST API
The project involved building a complete web application with different workflows, dashboards, automation features, and data-driven functionality.
Always enjoy turning an idea into a functional web application.
AI Lead Qualification & Appointment Automation System
AI Lead Conversion Platform — Telegram, CRM & Automated Scheduling
Designed and developed an AI-powered lead conversion system that handles incoming Telegram conversations from first contact to qualification, CRM synchronization, and appointment booking.
The AI works with conversation history, lead profile data, unanswered questions, current funnel stage, available actions, and verified CRM data to determine the next appropriate step and generate structured responses.
The system automatically creates and updates leads in the CRM, manages qualification stages, books meetings, generates Yandex Telemost links, sends reminders, handles rescheduling, and escalates exceptional cases to a human manager.
The architecture includes dialogue state management, message deduplication and batching, PostgreSQL persistence, concurrency protection, validation before actions are executed, and safeguards against sending unverified or prohibited information.
This is not just an AI chatbot — it is an automated sales workflow that connects Telegram, AI, CRM, scheduling, and human escalation into one controlled process.
AI makes decisions within controlled business rules instead of operating as an unrestricted chatbot.
The concurrency safeguards and validation-before-actions detail is a strong distinction here—booking systems usually fail at the edges, not in the happy path. I’d expose a compact lead state to the operator (stage, next action, last unanswered question) so a human can resume...
Your Booking System Should Prevent Problems Before They Happen
An appointment system should do more than display a calendar.
It should calculate availability from staff schedules, service duration, breaks, closed days, and existing appointments. It should prevent double bookings, keep customer information organized, and give the business a clear daily view.
I develop custom PHP and MySQL booking systems for clinics, salons, veterinarians, consultants, psychologists, and other appointment-based businesses.
Customers receive a simple mobile-friendly booking flow, while the business manages services, staff, schedules, statuses, reminders, and reports from one panel.
If generic booking tools do not match your workflow, a custom system may be the better solution.