I am working in HR department in petrochemical plant as a member of the recruitment team where we recruit national and expats as well and today I recieved the below email from my manager and don't know what to do as I haven't done it before!!??
The email:
you will be the main focal point to handle the recruitment database updates and reporting (replacing .......). Your role is to collect the feedback / status of the recruitment from the recruitment team for each stage and update the system and then generate reports on format that to be agreed on.
I need your help..
Is there any Excel sheet ready to fill the whole recruitment processes from Screening of the applicants CV's to joining the company.

From Saudi Arabia, Jubail
Hi Malfa,
Welcome to the world where people create confusion and heartache for new joinees. This is very typical in all companies in our Saudi Arabia, with very few actually having an induction.
Do following immediately:

1. Go to all the recruitment team and seek guidance from them on types of excel sheet they maintain for recruitment.
2. Understand and seek insight on what systems your companies uses to maintain the candidate database in Excel or using software (SAP, Custom Software) etc. for the entire recruitment process.
3. Ask the recruitment team what types of reports they give to manager and how often.
4. Collect all the information and make your report.

From Saudi Arabia, Riyadh
Thanks Ukmitra I have already asked them but, they have many different formats and to combine them is not easy job. (Specifically creating the Excel sheet for such job)
From Saudi Arabia, Jubail
Yes, it is and I am sure you can. The trick here is to use an excellent excel feature called "Pivot Table". Wish all the Best.
Share with me the format and I will help you create the Reports.

From Saudi Arabia, Riyadh
Thanks here you have the draft I made.. please evaluat it and let me know how can i sort nationals and expats? rgds
From Saudi Arabia, Jubail

Attached Files
File Type: xls Master Recruitment Plan 2012 (draft).xls (37.0 KB, 10185 views)

Here I have attached a crude form of reporting and you need to polish it bit. I am sure you know how to use "Pivot Table".
I have made few changes to your excel sheet.
1. You need to add "Nationality" Column in the excel sheet for the report.
2. I have removed the "Time column" against "Prescreen" and 'final Interview" (put them if have need for any analysis)
3. I have also changed name of few Columns. Have a look.
4. I have made some random entries of candidate names for the report to look meaningful.
5. Report is created in 3rdSheet named "Reports" using Pivot table with data from 2ndSheet named "ukmitra".
6. I have created this report with Nationality as base (note that Nationality is appearing in first column in report)
7. You can make your reports for all the column heads by placing them in First to create reports like "Accepted wise", "Fit/Unit Wise" etc. Hoping I am making sense.
Let me know if this has been of any help.

From Saudi Arabia, Riyadh

Attached Files
File Type: xls Master Recruitment Plan 2012 (draft).xls (52.0 KB, 3981 views)

HI Malfa, Please find attached excel sheet which will help you in reporting & tracking status of all candidates. Regards, Mohsin Jubail
From Saudi Arabia, Riyadh

Attached Files
File Type: xls 2012 & 2013 Recruitment Summary Report.xls (6.41 MB, 9003 views)

I realy do not know how to thank you. That was great and excellent I found it matching my need 100%
Thank you very much and I really appreciate that. By the way, where are you working in Jubail? I might need you help in the future (it is nice to exchange knowledge not information) accept me as a friend.
malfahad at gmail

From Saudi Arabia, Jubail
Greetings of the day,
Wish you very happy and prosperious eid mubarak to you, your family and loved one in advance.
It's my pleasure to exchange knowledge always with others. Nice to hear that it is matching to your need 100%. if you do require any assistance in near future please feel free to write me in citehr or and i will try my best as per my knowledge to help you .
I am working in one of leading petrochemicals company in Jubail Industrial city and residing in Jubail City.
You are most welcome bro...

From Saudi Arabia, Riyadh
Mr. Mohsin, Can I ask one question? I saw two fields marked as EJD and AJD. Can you please clarify both of them. Regards, Jamal
From Pakistan, Karachi

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server