Ukmitra
Business Development, Employee Relations,
Mohsin28
Recruitment Consultant
Jamalahmedhr
Hr Executive
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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:
Malfa,
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.
Ukmitra

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.
Ukmitra
Jubail

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, 9760 views)

Hi,
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.
Ukmitra
Jubail

From Saudi Arabia, Riyadh

Attached Files
File Type: xls Master Recruitment Plan 2012 (draft).xls (52.0 KB, 3835 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, 8545 views)

Mohsen,
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
Fahad,
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...
Regards,
Mohsin

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

Please Login To Add Reply






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™