Outcome:

The outcome of this use case is the segregation of 1st Year Student Data ensures seamless import into Zoho Desk, improving data accuracy and organization. 

• Use case Implimentation Steps:

Implementation Stage 1:

Raw Data:

Segregation of Names:

• Split the Full Name into First Name and Last Name.

• If there is no lastname then, we have to put a dot(.) without leaving it empty

Implementation Stage 2:

Segregation of Address:

• Street:

• Used a delimiter to split the full address into street components.

• The delimiter was applied to separate the street part of the address from the city, state, and other components.

• This allowed for the extraction of the street details accurately.

Implementation Stage 3:

State:

• Used a Postal Dictionary to match the Pincode to the corresponding State.

• VLOOKUP was applied on the downloaded postal dictionary sheet to extract the State based on the Pincode.

• Formula Used:
  =VLOOKUP(W675, Sheet3!E:I, 5, FALSE)

• This formula looks up the Pincode from the student data in cell W675, searches for it in Sheet3 (columns E to I), and retrieves the corresponding State from the 5th column of the range.

Implementation Stage 4:

City:

• The City was directly extracted from the address field by separating it from the other address components.

Successfully completed 1st Year Student Data Segregation for NTTF Bangalore.

Challanges faced :

• Data shared by NTTF needed lot of corrections.

• Duplicate rows of same data  found multiple times.

• Double pincodes in the address.

• Address mentioned twice in the same record.screenshot of the issue below:

• Target Audience:

• Candidates(Students): Candidates can use the module to apply for jobs, update their profiles, and track their application status.

• Users:

• Placement Cell:

Individuals who will utilize the customized candidate module to manage and track student candidates throughout the recruitment process.

• Recruiters: Allow recruiters to search and filter candidate profiles based on various criteria such as education, skills, and experience.

• Managers/Supervisors:

Those responsible for monitoring the efficiency and performance of the candidate module, ensuring it aligns with organizational recruitment goals.

• Educational Institutions:

Institutions seeking to optimize their recruitment processes for student candidates using Zoho Recruit.

• Flow Chart:

• Link Required:

      Flow Chart