Table of Content

CLIENT OVERVIEW

Our client is a leading search company, specializing in executive search, business intelligence and recruitment process outsourcing (RPO). Our client facilitates corporate recruitment teams and executive search firms to track, map and engage the best talent for senior management, professional and technical positions.

Our client has an established clientele ranging across various industries, including Financial Services, Legal, Engineering, Technology, Life Sciences and Consumer Products. Our client operates in a blended offshore/onshore model to provide the economic benefits of outsourcing to their customers, which are serviced globally from our client's offices in UK, Australia, Singapore and India.

ENGAGEMENT SITUATION & CHALLENGES

Our client's business requires storing huge amount of candidates' data, which is accessed and referred on an everyday basis. With the increasing number of candidates, it was becoming extremely difficult for our client to store and manage this humungous data.

To facilitate this business critical process, our client had implemented a CRM solution for collecting and storing the entire candidate data. Our client had employed 100+ operators for research, analysis and entry of candidate's data into the CRM solution. Key challenges faced by our client while using CRM solution were:

  • Low productivity for 100+ operators due to cumbersome workflows

  • Performance issues, leading to higher time per candidate profile entry

  • Inflexibility of the solution for any customization

  • Non-intuitive user interface

  • Limited availability of management reports for decision cycles

Due to these reasons, despite of storing a massive amount of data, the system was underutilized and MS Excel spreadsheets were used. The data was entered on the Excel sheets which were then fed into the CRM, resulting in twice the effort and time required for the process.

Our client realized that current CRM solution is not adequate for their growth and it was becoming a huge bottleneck in day to day business operations. Our client was looking for a product engineering partner who would be responsible for end-to-end product development including product architecture and quality assurance. Our client was looking for an agile innovative partner who will understand the complex process of recruitment services and their core business requirements.

A key requirement was also to ensure that the huge data residing on the legacy system is converted into a useful format and is migrated to the new system without any data loss.

KEY ENGAGEMENT OBJECTIVES

Some of the key engagement objectives of the proposed engagement were:

  • Migrating about 200 GB of data from the existing legacy system to the new solution with no data loss.

  • Providing a dashboard view for the senior management to provide them with a summary view of the current open positions and the resource performance.

  • Designing and developing an ad-hoc reporting mechanism to support varied customer requirements.

  • The system was required to be available throughout with zero downtime and providing quick response time.

  • Product was required to be launched within 3 months of the engagement inception.

XORIANT SOLUTION

Xoriant has extensive experience in product engineering and has executed several successful end-to-end product development engagements right from product architecting, development, testing, technical support and quality assurance. Additionally Xoriant provides recruitment services for number of IT companies in the US for their niche resource requirements, thus it has complete knowledge of the recruitment domain. Due to these reasons, Xoriant proved a right match for our client's requirement.

Xoriant formed a core development team of technical architect and domain expert who conducted several meetings with the client personnel to get an in-depth understanding of the client processes and business requirements. An engagement roadmap was charted out with clear milestones and deliverables defined to ensure meeting the stringent release schedules.

Xoriant team proposed a solution with n-tier architecture with the (presentation, service, business, data access and infrastructure layer) for a loosely coupled design so as to enable incorporating changes easily without affecting the other components. (Reusability)

Xoriant team brainstormed with our client representatives and decided to develop the system using nHibernate (Object relational mapper), Spring and Microsoft .Net components to design and develop loosely coupled objects to ensure extensibility and scalability.

This was a critical system with a high volume of inbound requests and outbound data, which was required to consistently provide desired peak output without impacting the performance and with no downtime. Hence, we implemented failover clusters ensuring high availability.

Xoriant team decided to adopt test driven development methodology during component development. NUnit was used to create test cases for extensible solution. Xoriant team decided to develop an automated tool to ensure error free migration of the huge data from the legacy system. The automated tool would also provide the system user the flexibility to import data multiple times without the risk of corrupting the existing data.

We also provided a functionality wherein emails were automatically triggered to a configurable set of users on completion of different events or milestones like adding a new client to the system, closure of any requirements, any client escalations, etc. This was implemented using Quartz.Net.

XORIANT MAJOR CONTRIBUTIONS

Some of our key contributions in this assignment were:

  • Designed and developed a custom component, which retrieves data from multiple Excel sheets, performs data sanitization, data validations and establishes entity relationships within the master tables of SQL database before importing into the new system.

  • Designed and developed a scheduler, which schedules the custom component for data import to run as a nightly job. The scheduler generates a log of records failing the import using Log4Net and triggers an email to the back office administrator for further action.

  • Used JQ grid to design a hierarchical view dashboard, which provides summary of resource performances in real time. A color coded view allows senior management to drill down to lowest work effort on open position or resource performance and facilitates decision making.

  • Designed and developed an ad-hoc reporting tool using JQueryUI & custom SQL backend engine. Several filters were provided to enable generation of various reports in both tabular and graphical format, which could be exported and saved as an MS Excel and pdf documents.

  • Implemented a load-balanced server farm failover safety design of IIS web servers & SQL servers to ensure high availability and improved performance.

TOOLS AND TECHNOLOGIES

  • . Net Framework 3.5

  • ASP, .NET, C#

  • MS SQL Server 2008 R2

  • NHibernate (Object Relational Mapper)

  • Spring.Net (IOC container for object management)

  • Log4Net (For Logs)

  • NUnit (For Automated testing)

  • JQuery (JavaScript library for client side processing)

  • AJAX Toolkit (for processing AJAX requests)

  • IIS Server 6.0+ Web Server

CLIENT BENEFITS

  • Reduced the end user workflow (processing) time by more than 30% leading to improved operator productivity.

  • Facilitated quick decision making by the management by providing a reporting dashboard indicating major performance parameters and statistics.

  • Reduced running cost by upwards of 30% by migrating from legacy systems and adopting several open source software for developing the new system.

  • Improved the performance by 20% due to reduced errors resulting from erroneous data spread across different database in the legacy system.

Client Testimonials

I would like to give a special acknowledgement to the Xoriant team for all their hard work and dedication on this project. Although the workflows within the product were quite complex in nature, the team has done a wonderful job to understand and implement it. We are very happy with the level of commitment shown by every team member of Xoriant towards achieving the aggressive timelines in delivering the product. We look forward to making them our technology partner and work with them on many more engagements.

-Project Director 

Download Case Study

Streamlining Recruiting Operations using Microsoft .Net

Streamlining Recruiting Operations using Microsoft .Net

Developed a flexible recruitment management solution where data from legacy system is translated into the new system with no data loss, new solution facilitated quick decision making and reduced end user workflow time by more than 30%.

Key Contribution

  • Designed and developed a custom component, which retrieves data from multiple Excel sheets, performs data sanitization, data validations and establishes entity relationships within the master tables of SQL database before importing into the new system.

  • Designed and developed a scheduler, which schedules the custom component for data import to run as a nightly job. The scheduler generates a log of records failing the import using Log4Net and triggers an email to the back office administrator for further action.

  • Used JQ grid to design a hierarchical view dashboard, which provides summary of resource performances in real time. A color coded view allows senior management to drill down to lowest work effort on open position or resource performance and facilitates decision making. Know More >>

Benefits

  • Expanded global footprint by launching application on Firefox OS.
  • High acceptance of application due to the ease of use and seamless user experience on mobile. Know More >>
Register here to download the entire case study

Please fill in the below details to access the entire case study

Verification Code * :
Image CAPTCHA
Enter the characters shown in the image.