# Mauro Franco Consulting

> Bespoke web applications, workflow automation, and custom software systems for small and medium-sized businesses (SMBs). Over 20 years of experience building resilient systems that eliminate manual data entry and operational bottlenecks.

## About
Mauro Franco Consulting is a technology and systems architecture consultancy led by Mauro Franco, based in Montreal, Quebec, Canada, serving clients across Canada, the United States, and internationally in English and French. We architect, build, and maintain custom web applications, workflow automations, and database platforms tailored to the operational processes of growing businesses.

## Core Services
- **Bespoke Web Application Development**: Custom business platforms, client portals, internal management dashboards, and operational tools built without per-user licensing fees.
- **Workflow Automation & Systems Integration**: Automated data sync across CRMs, invoicing, inventory, field tracking, and customer communication channels.
- **Legacy System Modernization**: Upgrading obsolete or fragmented software into scalable, secure, and modern PHP/MySQL applications.
- **Educational Email Courses (EECs)**: Done-for-you 5-to-7 day automated email curricula engineered to educate prospects, build authority, and convert readers into high-ticket clients.

## Target Industries & Case Studies
- **Automotive Mechanics & Vehicle Shops**: Custom booking platforms, parts inventory tracking, work order management, and technician scheduling (e.g., Garage Victor).
- **Property Management & Real Estate**: Automated tenant requests, lease renewals, maintenance dispatch, and owner reporting (e.g., Leimau).
- **Construction & Field Services**: On-site job reporting, crew coordination, progress tracking, and subcontractor invoicing.
- **Restaurants & Hospitality**: Internal ordering workflows, kitchen dispatch, and automated staff scheduling.
- **Professional Office Services**: Streamlined HR, automated expense management, client billing, and approval workflows.

## Technology Stack & Security
- **Languages & Frameworks**: PHP 8.x, Modern Object-Oriented Architecture, JavaScript, RESTful APIs, Bootstrap.
- **Databases**: MySQL / MariaDB relational schemas with ACID compliance, automated backups, and encrypted sensitive fields.
- **Security & Compliance**: Built following OWASP Top 10 standards, strict role-based access control (RBAC), multi-tenant isolation, HSTS, secure session management, and CSRF protection.

## Engagement & Consultation
- **Consultation Process**: Clients start with an operational audit to identify workflow bottlenecks, followed by a fixed-scope architecture proposal and milestone-driven delivery.
- **Languages**: Consulting and system interfaces are fully available in English and French.
- **Direct Contact**: 
  - Email: mauro.franco@maurofranco.com
  - Phone: +1 514 244 1783
  - Consultation Form: https://maurofranco.com/#contact
  - LinkedIn: https://www.linkedin.com/in/maurofranco/
  - GitHub: https://github.com/maurofranco

## Key Links & Resources
- [Main Website](https://maurofranco.com/): Official consulting homepage and service overview.
- [Educational Email Courses](https://maurofranco.com/email-courses): Dedicated packages for automated educational email funnels.
- [Detailed AI Documentation](https://maurofranco.com/llms-full.txt): Comprehensive technical specifications, service outlines, and full project case studies.