Yogesh J.

• (Sears Holding India Pvt. Ltd.) (1, Aug’12 – Till date) (Being first 8 months on contract)

As an Executive

Work Profile :-

1] Maintaining the database of Recruitment.

2] Making presentation based on different Requirement of Management.

3] Collecting data from different business unit heads for making reports.

4] Maintaining accuracy of database.

5] Making Macros using excel wizards and editing them using VBA.

6] Making cost projections and recruitment costing and presenting them to leads.

7] Coordinating with Managers for entire recruits and cost incurring to hire them.

8] Calculating the budgeted cost per hire and Cost per hour.

9] Auditing the entire data on monthly. Weekly, daily basis.

10] Calculating invoice amounts and sending them to concern stakeholders for payments

11] Ageing analysis, GAP Analysis, Trend Analysis, Progression- Regression analysis, Sourcing channel analysis, Vendor Cost per hire trend analysis, Variance analysis, Financial planning in term of expenses Vs Headcount, budgeting for forthcoming quarter, etc.

12] Made entire org chart using MS-Visio based on talent management rules and guidelines.

13] Made competency based role model for proficiency level check and role mapping

14] Making automated templates for various processes using excel automation.

15] Comparative analysis of data based on Year on Year trend, like actual expenses incurred in business unit vis-à-vis benchmark or provision made for the same.