Masud Rana

HR Intern

Square Food & Beverage Ltd • Full time

Sep 2025 - Present • 8 mos

• Developed a fully functional ATS (Excel + Google Apps Script) currently used by SFBL for automated CV sorting, scoring, and generating candidate summaries with a single click. • Built a web-based candidate application system using Google Apps Script, HTML5 & CSS for seamless applicant data collection. • Created a Primary Data Collection Form and Employee Information Form with validation rules ensuring 100% accurate HR records. • Developed an AI-powered Candidate Summary Generator using Gemini API integrated with Google Sheets. • Created multiple HR automation tools including Proposal Letter Generator, Email Generator, Attendance Sheet Generator from CVs. • Reduced manual recruitment data processing time by 40–60% through automation and workflow redesign. • Actively supported HR digital transformation by implementing App Script codes and tools now regularly used by the recruitment team. • Posted 30+ job circulars in Bdjobs based on hiring requisitions. • Screened and shortlisted 1000+ candidates from 10,000+ applications. • Performed candidate communication & interview coordination; handled 1000+ phone calls. • Designed and managed automated email merge workflows to generate candidate evaluation forms for interviews. • Validated employee and applicant information ensuring 100% accurate HR records. • Prepared interview files, onboarding documents, and staffing records. • Automated candidate summary sheets using Google Sheets, Apps Script & data processing. • Developed a custom ATS used for CV sorting and candidate management. • Created job test assessments (English, Math, Logical Reasoning) for screening candidates. • Conducted Excel tests for various job roles. • Managed physical and digital HR documents by scanning, printing, and organizing them for efficient record management.