TEXT PREVIEW
APPLICATION_MESSAGE_v1.txt
APPLICATION_MESSAGE_v1.txt · 6 KB
Subject: Application: Executive Virtual Assistant & Operations Coordinator (Job 1763483) Hello, I am applying for the Executive Virtual Assistant & Operations Coordinator role. I come from an IT and data operations background, where I have managed systems, led small teams, documented processes and built tools that save time. My resume (V9.3) is here: https://vinceaboy.com/files/public-folder/executive-virtual-assistant-operations-coordinator-ai-excel-proficient EXPERIENCE I have not held the formal title of executive assistant. My closest experience is nearly a decade at THOR Group (Sep 2014 to Jan 2024), where I prepared reports and spreadsheets and followed up on tasks with other people for U.S.-based executives. Earlier, as IT Manager at Kinden Philippines (Apr 2005 to Mar 2014), I managed IT infrastructure for a company of under 300 employees, built and maintained BOQ databases for project costing and reporting, and ran preventive-maintenance schedules. EXCEL AND TOOLS I regularly use pivot tables, XLOOKUP or INDEX/MATCH, conditional formatting, filters and sorting, duplicate checks (COUNTIF or Remove Duplicates), and charts and dashboards in Excel and Google Sheets. I have tracked tasks in Google Sheets and Excel trackers rather than in ClickUp or Asana, and I learn new tools quickly. For automation I have used n8n, not Zapier or Make. RATE AND AVAILABILITY My rate is $8 per hour. I am available for about 25 hours a week, 9 am to 2 pm U.S. Central Time (11 pm to 4 am Manila time). QUESTION 1: ORGANIZATION Day 1: Listen and get access. I ask for his top 3 priorities, what is urgent now, and what I may handle alone versus what needs his approval. I get access to his email, calendar and shared files. I make no changes yet. Day 2: Triage email. I sort the inbox into four groups: urgent today, needs a reply, waiting on someone else, and can be archived. I use labels or folders, and I send him a short list of the few messages that need his decision. Day 3: Build the tracker. I make one shared task sheet (in Google Sheets, or ClickUp or Asana if he prefers). It lists each task, its owner, its due date and its status. I fill it with the overdue reports and missed follow-ups I found. Day 4: Follow up and fix the calendar. I send follow-ups within the guidelines he approved, and I put deadlines and reminders on the calendar. Day 5: Report and set the routine. I send a short summary of what is done, what is still open and what I recommend. I also set up a daily morning briefing and an end-of-day update, so the system keeps running. QUESTION 2: EXCEL & ATTENTION TO DETAIL 1. Protect the original. I save a copy and work only on the copy, and I count the rows (150) and note the totals before I touch anything. 2. Find the problems. For duplicates, I check by employee ID first, not by name alone, because two different people can share a name. I use conditional formatting to highlight repeats and COUNTIF or Remove Duplicates to confirm them. Filters show blank cells and odd values. A pivot table helps me spot wrong categories or repeated entries quickly. 3. Fix them. I make dates, names and number formats consistent. I recalculate the wrong formulas myself and check a few by hand. For missing information, I look in the source records first. If I can't find it, I flag the row and ask, rather than guessing. 4. Verify. I compare the final row count and totals with the originals and explain every difference. I run a second duplicate check and a blank-cell check, and I spot-check a sample of rows against the source. 5. Submit. I send the clean file with a short change log: what I found, what I fixed, and what still needs someone's answer. QUESTION 3: AI PROFICIENCY I design the process and business rules, then build the tools with AI coding assistants (Claude Code, Codex) and OpenAI. I review, test and document everything. 1. Booking and service reports (family aircon business). Booking requests are stored in a database. n8n then sends owner reports to Google Sheets and retries failed deliveries automatically. When reports showed "pending" even though they had been delivered, I traced it to a missing confirmation step in n8n and fixed it. The owner piloted it with real bookings. It is not in daily use now. 2. ProductWatch and PriceWatch Radar (Sufco). I turned manual stock checks and competitor research into dashboards that leadership used daily. My estimate is that the stock check went from 10-20 minutes to a few minutes. PriceWatch Radar tracks competitor prices and stock, with an AI checker for product matches and a person making the final decision. 3. Woflow. An AI-assisted categorization tool took about 1+ hour of manual work down to usually under 45 minutes, with human review of unclear items. The team adopted it. I always verify AI output before using it. QUESTION 4: INDEPENDENT THINKING 1. Look at the facts first. I check how late the report is each time, who prepares it, who needs it and what it depends on. I look for a pattern, such as the same day, the same missing input or the same person. 2. Ask, don't blame. I talk to the person who prepares it in a neutral way and ask where it gets stuck. The cause is often not forgetfulness. It could be a late data source, unclear ownership, an unclear deadline or too much work. 3. Find the underlying problem. I separate the symptom (the report is late) from the cause (for example, the data arrives after the deadline, or nobody knows who owns it). 4. Recommend a lasting fix. Examples are a clear owner and deadline, a template or checklist, an earlier request for the data, or an automatic reminder. I write the recommendation down with its reason. 5. Respect my authority. I send the findings and recommendation to the executive and let him decide. I do not change anyone's responsibilities myself. After he approves, I put the fix in the tracker and check that the next reports arrive on time. Thank you for your time and consideration. Vincent Gregory C. Aboy