Tala193's 

A fast-growing e-commerce company with 85 employees was struggling to manage employee leave and attendance. Their existing process relied on email requests and manual Excel tracking, leading to:<ul><li>Overlapping leaves</li><li>Missed approvals</li><li>Payroll confusion</li><li>HR burnout during peak holiday seasons</li></ul>The company needed a centralized, simple, and error-free way to track leave requests and manage balances — without investing in an expensive HR system.<h3>🎯 Mission</h3>To design and implement a reliable leave management solution that would:<ul><li>Reduce HR workload</li><li>Improve visibility for managers</li><li>Give employees clarity on their leave balance and approval status</li><li>Prevent errors in payroll processing</li></ul><h3>🛠️ Solution Provided</h3>I led a 3-step solution using existing tools the company already used (Google Workspace + Excel):1. Audit &amp; Mapping<ul><li>Reviewed the leave policy and approval hierarchy.</li><li>Collected feedback from HR and employees about common issues.</li></ul>2. System Creation<ul><li>Created a Google Form for leave requests.</li><li>Built a connected Google Sheet that logged requests, leave types, and balances automatically.</li><li>Used conditional formatting and formulas to flag overlaps or exceeded balances.</li><li>Integrated email notifications to alert managers when a request was submitted.</li></ul>3. Training &amp; Rollout<ul><li>Wrote a clear guide for employees and managers.</li><li>Conducted a 1-hour training session on Zoom for staff.</li><li>Trained the HR team to update leave balances monthly.</li></ul><h3>🛠️ Solution Provided</h3>I led a 3-step solution using existing tools the company already used (Google Workspace + Excel):1. Audit &amp; Mapping<ul><li>Reviewed the leave policy and approval hierarchy.</li><li>Collected feedback from HR and employees about common issues.</li></ul>2. System Creation<ul><li>Created a Google Form for leave requests.</li><li>Built a connected Google Sheet that logged requests, leave types, and balances automatically.</li><li>Used conditional formatting and formulas to flag overlaps or exceeded balances.</li><li>Integrated email notifications to alert managers when a request was submitted.</li></ul>3. Training &amp; Rollout<ul><li>Wrote a clear guide for employees and managers.</li><li>Conducted a 1-hour training session on Zoom for staff.</li><li>Trained the HR team to update leave balances monthly.</li></ul><h3>⏳ Duration of the Project</h3>3 weeks total:<ul><li>5 days: Research + planning</li><li>7 days: Build &amp; testing</li><li>9 days: Rollout &amp; support</li></ul><h3>📈 Quantified Impact</h3>Before Manual email-based system 5+ hours/week of HR timeFrequent payroll errorsComplaints from employeesAfter Centralized digital system &lt; 1 hour/week 0 errors in 2 months 95% satisfaction (survey)

Tala Yaacoub

About me

Education

Lebanese International University

Portfolio

Streamlining Leave Management for a Growing Team

Tala193's

Talents

Recruiters

About