Obasi Nkemjika

Google Sheet Name: Gnosi Consult Industry: Recruiting Marketers for banks Role: skilled virtual assistant Applicant Tracking Sheet (Recruitment Management) 🔹 Responsibilities: ● ● ● ● ● ● Designed and maintained a structured applicant tracking system using Google Sheets. Entered and updated candidate information for Providus, Wema, and Microfinance Banks. Used color codes and filters to easily identify shortlisted, pending, or rejected candidates. Recorded interview dates, offer statuses, and HR feedback in real time. Ensured data accuracy by cross-checking applicant details with received resumes and email updates. Shared the sheet securely with HR managers for weekly review using Google Drive links. 🔹 Results: ● Reduced applicant follow-up confusion by 80%, as all updates were centralized in one sheet. ● HR teams could quickly filter and find candidates by bank or status. ● Achieved faster communication turnaround, leading to more efficient recruitment decisions. ● Created a clear visual overview of all recruitment activities for the week. Boss Task & Schedule Tracker (Personal Assistant Role) 🔹 Responsibilities: ● Created and maintained a detailed daily task tracker for the CEO of Gnosi Consult. ● Recorded all meetings, reports, and follow-ups across departments. ● Prioritized tasks using a color-coded system (red for urgent, yellow for ongoing, green for done). ● Updated task progress daily and shared updates through Google Workspace. ● Coordinated between HR and the CEO to ensure all recruitment and onboarding tasks were completed on time. 🔹 Results: ● Improved the CEO’s task visibility and accountability across teams. ● Reduced missed deadlines and duplicated work. ● Boosted workflow efficiency by ensuring every task was tracked and updated in realtime. ● Provided a professional, easy-to-read weekly summary for review meetings.