Nikka Roberta A.

Google Apps Script Developer | Internal Tools, Web Apps & Workflows

🔧 𝗜 𝗯𝘂𝗶𝗹𝗱 𝘀𝘆𝘀𝘁𝗲𝗺𝘀 𝘁𝗵𝗮𝘁 𝗿𝘂𝗻 𝘆𝗼𝘂𝗿 𝗼𝗽𝗲𝗿𝗮𝘁𝗶𝗼𝗻𝘀 — 𝗻𝗼𝘁 𝗷𝘂𝘀𝘁 𝘀𝗽𝗿𝗲𝗮𝗱𝘀𝗵𝗲𝗲𝘁𝘀 𝘁𝗵𝗮𝘁 𝗵𝗲𝗹𝗽 𝘆𝗼𝘂 𝗺𝗮𝗻𝗮𝗴𝗲 𝘁𝗵𝗲𝗺. Most teams don't need more tools. They need better structure. When work lives across disconnected spreadsheets, manual follow-ups, and processes only one person understands — things slow down, errors multiply, and everyone does double the work. I fix that. ✅ $𝟭𝟬𝟬𝑲+ 𝒆𝒂𝒓𝒏𝒆𝒅 𝒐𝒏 𝑼𝒑𝒘𝒐𝒓𝒌 · 𝟲𝟭 𝒄𝒐𝒏𝒕𝒓𝒂𝒄𝒕𝒔 𝒄𝒐𝒎𝒑𝒍𝒆𝒕𝒆𝒅 · 𝟱.𝟬 𝒓𝒂𝒕𝒊𝒏𝒈 · 𝟭𝟮+ 𝒚𝒆𝒂𝒓𝒔 𝒆𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 🏗️ 𝗥𝗘𝗖𝗘𝗡𝗧 𝗦𝗬𝗦𝗧𝗘𝗠𝗦 𝗕𝗨𝗜𝗟𝗧 📱 Student Portal Web App Mobile-first PWA deployed via QR code for a residential training facility — class-gated access, live announcements, facility booking, maintenance reporting, guest registration, and contacts. One URL, never reprinted. Config-driven. Serving real users daily. 🗓️ Facility Booking System Replaced a broken Google Form with a smart web app — real-time availability checks, dynamic time slots by day of week, one-tap email approvals (no login required), UUID-based cancel links. Diagnosed and fixed a production race-condition bug in the legacy system during live migration. Zero downtime. 👥 Volunteer Management System Role-based web app with fuzzy name matching (Levenshtein), alias-aware autocomplete, duplicate detection, admin dashboard, and data cleanup tools. 400+ volunteers, 3,700+ records, tested at 150+ concurrent users. 🔧 Maintenance Reporting System QR-deployed web app with role-based UI from a single URL, live search across 84 locations, PIN authentication, concern tracking, and HTML email notifications on every status change. 📦 Inventory & Supply System Dual-flow issuance/replenishment tracking with dependent dropdowns, real-time stock recomputation, auto status (OK / For Reorder / Out of Stock), and a non-destructive period-close that archives, rebases, and clears — one-click from a custom Sheets menu. ⚙️ 𝗪𝗛𝗔𝗧 𝗜 𝗕𝗨𝗜𝗟𝗗 𝗙𝗢𝗥 𝗖𝗟𝗜𝗘𝗡𝗧𝗦 📊 Dashboards & Reporting — KPI trackers, summaries, filtered views, always current 🔄 Workflow Automation — triggers, notifications, status updates, approvals, scheduled tasks 🗂️ Data Architecture — relational Sheets structures, clean schema, scalable from day one 📋 Form & Intake Systems — conditional logic, validation, automated responses 🤖 AI-Assisted Workflows — Gemini-powered email triage, lead scoring, structured outputs 📱 Internal Web Apps — role-based UIs, PWA support, email automation, zero hosting cost 🛠️ 𝗦𝗧𝗔𝗖𝗞 Google Apps Script · HTML · CSS · JavaScript · Google Sheets · Google Forms · Gmail · Drive · Docs · Calendar · LockService · CacheService · UrlFetchApp · Gemini API · Microsoft Excel 💡 𝗪𝗛𝗬 𝗜'𝗠 𝗗𝗜𝗙𝗙𝗘𝗥𝗘𝗡𝗧 I come from operations — not just code. 12+ years in executive support, admin, and medical transcription means I understand how workflows actually break before I touch a script. I combine technical fluency with human judgment and problem-solving skills, allowing me to design systems that are not only technically sound but practical for real teams to use. I don't build what you ask for. I build what actually solves the problem. 𝗦𝘁𝗿𝘂𝗰𝘁𝘂𝗿𝗲 𝗳𝗶𝗿𝘀𝘁. 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝘀𝗲𝗰𝗼𝗻𝗱. 𝗗𝗼𝗰𝘂𝗺𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻 𝗮𝗹𝘄𝗮𝘆𝘀. Clear scope before work starts. Updates without chasing. Systems your team can maintain independently.