Osman Herrera

• ▸Own the full client engagement for paying customers: scoping, building, deploying, and supporting in production as sole point of contact.
• ▸Build ETL pipelines (Python, webhooks, n8n) that extract structured data from source systems, clean and map it, and sync it into target formats.
• ▸drafrancisherrera.com: gathered requirements from a medical practice and delivered a production site (React, Node.js) plus a WhatsApp chatbot that interprets natural-language patient inquiries through n8n and the OpenAI API and routes them to the right staff member, with fallback handling. Trained the client on the system; retained under a one-year maintenance contract.
• ▸Implemented transactional email dispatch and validation workflows with Resend and Brevo.

• ▸Sole technical owner of a full-stack HR platform (Angular + Node.js REST API): designed the data model and MongoDB architecture, implemented JWT authentication with role-based access rules, and built the per-role dashboards a live organization uses to manage its records.
• ▸Shipped a Talent/Recruitment module end to end: a public Careers application form with rate-limited resume uploads (Cloudinary), a tiered magic-link (JWT) access system for a read-only candidate directory with field-level redaction, and an admin review workflow.
• ▸Deploy and administer the production environment (Ubuntu, Nginx reverse proxy, PM2, SSL); migrated hosting from AWS EC2 to a Hetzner cloud server, accountable for uptime and issue resolution.
• ▸Led the project from initial planning and requirements with the organization through launch and ongoing feature requests.

• ▸Designed and built, on my own initiative, a four-stage Python ETL pipeline that generates the daily revenue report end to end: RPA against Oracle OPERA (no API available) with PyAutoGUI, extraction from three PDF sources, regex parsing into pandas, mapping across 190 transaction codes, and an integrity check that fails loudly on any unmapped code. Output written to the existing Excel workbook with macros preserved. Cut the task from 2-4 hours to roughly 5 minutes. Anonymized version on GitHub.
• ▸Designed an integrity check that halts the run on any unmapped transaction code, so an incomplete figure never reaches a financial report silently; output written to Excel while preserving the existing workbook's macros and links.
• ▸Ran the nightly financial close in Oracle OPERA unsupervised on a fixed deadline: reconciliation, exception handling, and validation of the figures management used to make decisions each morning. Accountable for numbers that had to be right the first time.
• ▸Only staff member in charge of the property overnight: front desk, check-ins and check-outs, guest requests (from late-night meals from the market to linens), directing security staff, granting vendor access, handling medical emergencies, and resolving maintenance issues with outside vendors.
• ▸Became the property's go-to person for Oracle OPERA and trained front desk staff on the system, walking non-technical colleagues through workflows until they could operate independently.
• ▸Handled guest personal and payment-related information daily in line with the property's privacy and security policies.

• ▸Designed and illustrated original characters and graphics for textile printing, including color separation for screen printing and sublimation.
• ▸Planned and delivered product launches on fixed dates against goals agreed with partners, and created and managed Facebook advertising campaigns.
• ▸Co-ran the business for 11 years alongside other employment: client records, quoting, production scheduling, and delivery tracking.

Photographed furniture products (lighting and composition), then edited, retouched, and laid out the collection catalog in CorelDRAW.

Technical support in English for a North American mobile carrier: live troubleshooting under response-time targets. Promoted to Tier 2 escalation supervisor, owning the cases first-line agents could not resolve.

Provided phone support in English to T-Mobile customers: account, billing, and service inquiries.