Full Stack Web Developer, MySql, SQL expert, Team Lead

PROFILE

TECHNICAL PROFICIENCIES

SKILLS

HERNANDEZ

ANDRES

I build solutions and fix problems: it’s what has kept my business thriving for 21 years, a milestone most companies never reach. With 25+ years of experience in technology and business leadership, I’ve built platforms, CRMs, and AI-driven systems that improve performance and user experience. I’m now looking for new challenges where I can bring that same mix of problem-solving, technical expertise, and leadership to make an impact. Fluent in English and Spanish; conversational proficiency in French.

• Languages & Frameworks:

PHP, JavaScript, Node.js, HTML/CSS, jQuery, React (familiar), React Native (familiar), Expo (familiar), Python (familiar), Classic ASP (legacy)

• Databases & Tools:

MySQL, SQL Server (familiar), Redis (caching, session and query optimization), Sphinx Search, database design, replication & clustering, server setup & management (individual + cluster)

• Server & Infrastructure:

Windows Server/IIS, Linux, DNS management, domain setup, hosting administration, dedicated servers, email server configuration, cluster management, performance tuning

• SQL Expertise:

Advanced query optimization, index design, database architecture, reporting from large relational datasets

• Web & CMS:

WordPress administration, content management, creation of WordPress plugins, Elementor customization

• AI & Automation:

OpenAI (ChatGPT, Codex), Gemini, Claude, LLaMA (Meta), DeepSeek, private open-source AI servers, workflow

automation, leveraging AI coding assistants to accelerate debugging and development

• Integrations:

API integration (Payments, SMS, Email, telephony and voice systems), WebSockets, custom middleware development

• Development Tools:

VS Code (primary), Dreamweaver (legacy), Git version control, CLI tools for deployment & troubleshooting

• Design & Graphics Software:

Adobe Illustrator, Photoshop, Adobe Creative Suite, CorelDraw

— for brand design, UI assets, and marketing materials CONTACT

+1-813-***-****

*********@*****.***

Tampa, FL

linkedin.com/in/andreshm1

• Tech Leadership & Team

Management

• Full-Stack Development &

System Design

• Strategic Project

Management

• Advanced SQL Query

Design & Optimization

• AI Integration &

Open-Source Deployment

• Creative Marketing & Brand

Development

• Business Process

Optimization

PROFESSIONAL EXPERIENCE

KEY ACHIEVEMENTS

EDUCATION

• Developed an industry-leading booking system reducing client no-shows by over 40% and staff training time by 75%.

• Built continuous client base growth through creative marketing

- still going strong after 20+ years.

• Continuously led a well-known local business for 21 consecutive years, ensuring stability while adopting new technologies responsibly and with long-term planning.

• Improved SEO performance and site speed year after year, maintaining top search visibility and compliance with evolving web standards.

• Implemented Redis-based database and session caching, reducing repetitive queries and improving performance of day-to-day operations by over 60%.

• Developed an internal automation framework to monitor and recover failed processes, minimizing downtime and operational risk.

• Launched a complete e-commerce system supporting gift card sales with scheduled delivery, customized messages, and tipping logic.

• Universidad ICESI, Cali,

Colombia: Business

Administration (originally

Systems Engineering track)

• Real-world learning has been

the backbone of my career:

25+ years building custom

systems, leading teams, and

guiding a successful business

through continuous growth

and technology adoption

• Skills and leadership proven in

execution; certifications

available if required

Technical Project Lead & Creative Technologist

Total Image Care Inc., Tampa - Pia Esthetics, FL (Hybrid) 2004 – Present

• Designed, developed, and continuously refined a sophisticated web-based CRM and booking platform using PHP, JavaScript, Node.js, Redis, Sphinx, Websockets, MySQL and multiple APIs.

• Directed a development team and led projects from concept to launch, prioritizing features and managing deployments.

• Reduced front desk training time by 75% and decreased no-shows by over 40% through custom workflows and real-time notifications.

• Implemented private AI servers (Meta's LLaMA, DeepSeek), improving reporting and reducing manual tasks.

• Built a browser-based task automation tool for error detection and system monitoring.

• Integrated third-party APIs (SMS, payments, email, telephony) for seamless communication and billing.

• Currently rewriting the online booking platform with React Native and Supabase to create a unified codebase for web, iOS, and Android, simplifying maintenance and ensuring cross-platform feature parity. Creative Marketing & Brand Strategist

Pia Esthetics, Tampa, FL (Hybrid) 2004 – Present

• Designed and launched bypia.com, developing custom front-end interfaces using HTML, CSS, JavaScript, and jQuery.

• Created a high-converting, fully integrated shopping cart connected in real time with the booking platform to streamline gift certificate sales and delivery.

• Enabled delivery of digital gift cards via email, SMS, or postal mail, with support for custom messages and scheduled delivery.

• Established brand identity from scratch, including logo, tone, and brand visuals across all digital and offline platforms.

PERSONAL

NOTES

• Lifelong runner: completed 1

marathon, 12+ half-marathons,

and hundreds of 5Ks, with

multiple first, second, and

third-place finishes in my age

group

• Gym-goer and weightlifter —

committed to daily physical and

mental discipline

• Amateur photographer with

8,000+ Instagram followers

(@andreshm1), focused on

landscapes, travel, and creative

storytelling through imagery

• Married since 1997, proud

father of two grown children

(18 and 27)

• Animal lover — two dogs, two

cats, and zero capybaras

• Enjoys terrible jokes and

believes humor is part of good

teamwork

• Entirely self-taught in all

technical disciplines; always

learning by doing and finishing

projects

• Produced and managed video content, digital ad campaigns, and in-store visuals to increase client engagement and retention.

• Developed birthday, referral, and event-triggered marketing automation using internal tools and third-party integrations. Small Business Mentor & Tech Advisor (Volunteer)

SCORE Mentor - Score.org, Tampa, FL 2021 – Present

• Guided numerous entrepreneurs in optimizing business processes, integrating tech solutions, and strategic marketing to achieve sustained growth.

• Specialized expertise mentoring beauty, wellness, and tech-focused startups - over 60 clients per year.

• Provide guidance on business process design, CRM implementation, and digital tools to support growth.

Freelance Web & Graphic Designer

Self-Employed, Remote 2000 – 2004

• Delivered full-stack web development, branding, and design services to small businesses.

• Created responsive websites and marketing assets using early web tools and design suites.

Web Developer

Planet Finance, Paris, France Jan – Nov 1999

• Developed web-based systems and maintained digital assets for an international microfinance organization.

• Collaborated with teams to modernize access to online services. Graphic Design Assistant

DDB Needham Worldwide, Cali, Colombia 1997 – 1999

• Supported art and production teams in large-scale advertising campaigns.

• Produced visual layouts and design elements for print and broadcast media.

Centro de Aprendizaje en Computación

Cali, Colombia While attending college

• Taught Microsoft Office tools to business professionals and students.

Contact this candidate