GUJARAT TECHNOLOGICAL UNIVERSITY
Lukhdhirji Engineering College,
INTERVIEW TRACKER SYSTEM
By: Flori Wadher (150310116031)
(Faculty Guide) (Head Of Department)
I would like to extend my heartiest thanks with a deep sense of gratitude and respect to all those
provided us immense help and guidance during my training period.
I would like to express our sincere to our Head of Department Prof.H.S.Dhadhal, our
InternalGuide Prof.R.R.Keshwala who gave us an opportunity to undertake such a great
challenging and innovative work. We are grateful to them for their guidance, encouragement ,
understanding and insightful support in the development process.
Last but not the least I would like to mention here that I am greatly indebted to each and
everybody who has been associated with my project at any stage but whose name does not find a
place in this acknowledgement.
With sincere regards,
I hereby declare that project report titled “Interview Tracker System ” submitted towards the
completion of project in 7 th
semester of bachelor of Information Technology in Lukhdhirji
Engineering College , Morbi in an authenticate record of work carried out.
I further declare to the best of our knowledge the report of CE 7 th
Candidate ‘ signature :
Candidate name : Flori Wadher
Branch : Information Technology
Enrollment Number : 150310116031
Lukhdhirji Engineering College,
Morbi Affiliated to:
Gujarat Technological University
Title Page no.
Candidate Declaration 2
1 Introduction 4
1.1 Project summary 4
1.2 Purpose 4
1.3 Scope 5
1.4 Technology and Literature Review 5
2 Software Management 8
2.1 Project planning and scheduling 8
2.2.1 Project plan 9
2.2.2 Roles and Responsibilities 9
2.2.3 Gantt chart 10
3 System Requirement Study 10
3.1 System Requirement Study 10
3.2 User Characteristics 11
3.3 Hardware and Software characteristics 11
3.4 Constraints 12
3.4.1 Regulatory policy 13
3.4.2 Hardware limitation 13
4 System Analysis 14
4.1 Study of current system 14
4.2 Requirement of system 14
4.2.1 Functional requirements 15
4.2.2 Non functional requirement 15
4.3 Feasibility study 16
4.4 Requirement validation 17
4.5 Function of system 17
4.5.1 Use case diagram 18
4.5.2 Activity diagram 20
4.5.3 Sequence diagram 21
4.6 Data modeling 22
4.6.1 ER diagram 23
4.6.2 Class diagram 24
4.7 Main modules of system 26
4.8 Justification 26
4.9 Design Engineering canvas 27
4.9.1 AEIOU Summary 27
4.9.2 Ideation canvas 28
4.9.3 Product Development Canvas 29
4.9.4 Empathy Mapping 30
5 Summary 31
5.1 Advantages of Interview Tracker System 32
5.2 Scope of Interview Tracker System 33
It is an online system designed and implemented to enhance the communication avenues using
This is the system for Recruitment Team they are currently using the Excel sheet for candidate
history and data and feedback.
This application is used for contain all the data of interested candidate. And recruiter ‘s team will
arrange their interview and all the levels that would be manage through the application so that
technical team can also give the feedback online and HR can also view all the candidate feedback
through this system. Hiring process would be smoothly because application will send email or
message to candidate and Technical Team for conducting the interview. There is also facility to
arrange all the round that any candidate faced than he will clear all the round than get selec ted
HR is responsible to add candidate in HRMS application from where will generate all the
CHAPTER : 1
1.1 Project Summary
? The main aim of Interview Tracker System is to develop the software with the help of
which all the process of interview right from collecting resumes to finalizing candidate
can run smoothly.
? It is a web application which has Admin component to manage the system.
? This application contains central database for all the candidate ‘s data, resumes, selected
? This application also provides tracking facility so that one can find which candidate is
going to appear for interview, which candidate has been selected, etc. We can search
? Data of each resumes is collected and entered in the database. Interviews are scheduled as
per the requirements through mails and sms.
? Feedbacks are taken so that further rounds can be arranged and candidate can be
? Login page is used so that candidate can login and check status.
? It is used by small and large companies to manages and track interview process.
? This system arranges interviews and gives feedback so that candidate should be finalized
on the basis of feedback.
? It does not have any bounds so can be used by any company for their hiring process.
Interview tracker system is targeted to small or big companies which does not have their proper
hiring system i.e. for those companies who still works on spreadsheet and paper work.
Some scopes are:
? The process is driven by job posting portals.
? Hiring organizations
? Human Resource Management Systems(HRMS)
1.4 Technology and Literature Review:
Asp .Net MVC. Database used is SQL.
Whole project will be developed using SDLC lifecycle.
? HTML (HyperText Markup Language) is the most basic building block of the Web.
? “HyperText” refers to links that connect web pages to one another, either wit hin a single
website or between websites.
? HTML uses “markup” to annotate text, images, and other content for display in a Web
? It is a language which is also characterized as dynamic, weakly typed, prototype-
based and multi-paradigm.
ASP.NET MVC is a web application framework developed by Microsoft, which
implements the model –view –controller (MVC) pattern. It is open-source.
ASP.NET MVC allows software developers to build a web application as a composition of three
roles: Model , View and Controller . The MVC model defines web applications with 3 logic
? Model (business layer)
? View (display layer)
? Controller (input control)
A model represents the state of a particular aspect of the application. A controller handles
interactions and updates the model to reflect a change in state of the application, and then passes
information to the view. A view accepts necessary information from the controller and renders a
user interface to display that information.
? SQL is a domain-specific language used in programming and designed for managing data
held in a relational database management system (RDBMS), or for stream processing in
a relational data stream management system (RDSMS).
? It is particularly useful in handling structured data where there are relations between
different entities/variables of the data.
? SQL consists of many types of statements, which may be informally classed
as sublanguages, commonly: a data query language (DQL), a data definition
language (DDL), a data control language (DCL), and a data manipulation
language (DML). The scope of SQL includes data query, data manipulation (insert,
update and delete), data definition (schema creation and modification), and data access
? In addition to the standard SQL/PSM extensions and proprietary SQL extensions,
procedural and object-oriented programmability is available on many SQL platforms via
DBMS integration with other languages.
? Cascading Style Sheets (CSS ) is a style sheet language used for describing
the presentation of a document written in a markup language like HTML.
? CSS is a cornerstone technology of the World Wide Web, alongside HTML
? CSS is designed to enable the separation of presentation and content,
including layout, colors, and fonts.
? This separation can improve content accessibility, provide more flexibility and control in
the specification of presentation characteristics, enable multiple web pages to share
formatting by specifying the relevant CSS in a separate .css file, and reduce complexity
and repetition in the structural content.
SOFTWARE PROJECT MANAGEMENT
2.1 Project Planning and Scheduling
2.1.1 Project Planning
? Project planning is a procedural step in project management, where required
documentation is created to ensure successful project completion.
? Documentation includes all actions required to define, prepare, integrate and coordinate
? The project plan clearly defines how the project is executed, monitored, controlled and
? The project planning stage requires several inputs, including conceptual proposals,
project schedules, resource requirements/limitations and success metrics.
? Project planning begins by setting the scope of a project and eventually working through
each level of dependent actions, tasks, checkpoints and deadlines.
? All of this information is integrated into Gantt charts, or other types of scheduling charts,
to provide a project overview for all involved parties.
2.1.2 Project Scheduling
? Project scheduling is a mechanism to communicate what tasks need to get done and
which organizational resources will be allocated to complete those tasks in what
? A project schedule is a document collecting all the work needed to deliver the project on
? But when it comes to creating a project schedule, well, that ‘s something few have deep
? A project is made up of many tasks, and each task is given a start and end (or due date),
so it can be completed on time.
? Likewise, people have different schedules, and their availability and vacation or leave
dates need to be documented in order to successfully plan those tasks.
2.2 Project Development Approach
The activities followed for this project is listed below:
? Planning work of objectives
? Analysis and design of objectives
? Assigning and controlling risk
? Organizing work
? Database design
? Form design
2.2.1 Project Plan
Software Process Activity Milestones
Project plan Project schedule
Requirement Analysis User Requirement
2.2.2 Roles and Responsibilities
2.2.3 Gantt Chart
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr
1 Preliminary Investigation 03/07/2018 20/07/2018 2 w
2 Requirement Analysis 05/07/2018 Continue.. –
3 Design – – –
4 Implementation – – –
5 Testing – – –
SYSTEM REQUIREMENT STUDY
3.1 System Requirement Study
3.2 User Characteristics:
It describes the type of user which deals with the applications. Basically, this application has
three types of users as given below:
? Recruitment Team
? Technical team
? Human Resource
Admin manages the recruiting team ,technical team ,HR ,candidates and it manages feedbacks
It collects resumes, schedules interviews, checks requirements, manages rounds of interview,
Takes feedback , etc.
Technical team take interviews, sends feedback about the candidate to the HR.
The HR team gets candidate feedback from interviewer and arranges HR round according to the
3.3 Hardware and Software Characteristics:
? Intel core i3 with 2.00 GHz or higher or any other compatible processor.
? 1 TB storage capacity.
? RAM: 4 GB minimum
Microsoft Windows XP Professional SP2 or higher operating system.
? Microsoft Visual Studio 2015
? SQL Server
? Dream Weaver
3.4.1 Regulatory Policies:
? Regulatory Policies or mandates, limit the discretion of individual and agencies, or
otherwise compel certain types of behavior.
? These policies are generally thought to be best applied when good behavior can be
easily defined and bad behavior can be easily regulated and punished through fine and
3.4.2 Hardware Limitation
? The smooth functionality of the portal mainly depends on the speed of hardware and then
on speed of the internet.
? It is always advisable to be update as far as hardware is concerned. The hardware
limitation occurs if the user is still using a very low MHz processor or a RAM or less
? This will generally reduce the portal and also the waste will use a lot of useful time,
energy and resource.
4.1 Study of Current System
? Currently there isn ‘t any system that manages and tracks the whole process of
interview still many companies are using spreadsheets. ?
4.2 Requirement of this System
? We are developing this web based application to manage interviews and track the
candidates in short this system is a tracking system.
? It minimizes the time required in interview process for all rounds and reduces the
4.2.1 Functional Requirement: .
This function will enables HR ,Technical team, candidates and recruitment team to login into the
Import resume :
This function will allow to import resume of candidates and add details of candidate .
The recruitment team arrange and schedules interviews according to the requirements 12
This function will enable HR to view status so that HR can understand that to move the
candidate in next round or not
This function will enable the recruiting team to search a candidate.
This function will enable the HR team to generate report.
4.2.2 Non functional requirement:
How long on average does it take your organization to hire.
Candidate Sourcing :
For each hire, you want your ATS to tell you how many qualified candidates were in the mix.
The way in which the candidate applying for job is changing and getting modern .
User wants that the system should be maintained easily means that if there are some changes
required in the system that can be done easily.
The user wants the data stored in database must be secured and cannot be accessed by
4.3 Feasibility Study
? Feasibility is the measure of how beneficial the development of information system
will be to an organization.
? The feasibility analysis is categorized under four different types.
1. Operational Feasibility
2. Technical Feasibility
3. Schedule Feasibility
4. Economic Feasibility
1. Operational Feasibility:
? The System is to be developed for any user who wants to use it. We want our system
user friendly and easy to use.
? The administrator also may be non-technical, so the user interface will be designed in
such a way that it gets comfortable for non-technical person to operate easily.
2. Technical Feasibility:
It is a partially measurement of specific technical solution and the availability of
technical resorts and expertise.
? The analyst must find out whether the current technical resources, which are available
in the system is capable of handling the job.
? If not, then the analyst with the help of developer should confirm whether the
technology is available and capable or not.
? Here we have to consider those tools which are required for developing the project.
? As far as basic knowledge concerned we have studied basic of objective-C and SQL.
3. Schedule Feasibility:
? Schedule feasibility corresponds to whether sufficient time is available to complete
? Schedule of the project
? Time by which project has to be completed
? Reporting period
4. Economic feasibility:
? Economic feasibility is a measure of cost effectiveness of a project or solution.
? For declaring that the system is economically feasible, the benefits from the project
should exceed or at least to the equal to the cost of development
4.4 Requirement Validation:
? Requirement validation examines this specification to ensure that all the system
requirements have been stated unambiguously.
? These inconsistent, error have been detected and corrected and the work products
confirmed to the standard.
? Source of the requirement are identified, final Statement of requirement has been
examined by original source.
? Requirements related to main requirements are founds.
? Requirements are clarifying stated and are not misinterpreted.
? All sources of requirements are covered to get a maximum requirement.
? All method of finding requirements is applied.
4.5 Function of the System:
? In software and systems engineering, a use case is a list of steps, typically
defining interactions between actor and a system, to achieve a goal.
? The actor can be a human, an external system, or time.
? In systems engineering, use cases are used at a higher level than within software
engineering, often representing missions or stakeholder goals.
? The detailed requirements may then be captured in Systems Modeling Language
or as contractual statements.
? As an important requirement technique, use cases have been widely used in
modern software engineering over the last two decades.
? Use case driven development is a key characteristic of process models and
? With its iterative and evolutionary nature, use case is also a good fit for agile
4.5.2 Activity Diagram:
Activity diagram of recruitment team:
4.5.3 Sequence Diagram:
? The well-known Message Sequence Chart technique has been incorporated into the
Unified Modeling Language (UML) diagram under the name of Sequence
? A sequence diagram shows, as parallel vertical lines, different processes or objects
that live simultaneously, and, as horizontal arrows, the messages exchanged
between them, in the order in which they occur.
? This allows the specification of simple runtime scenarios in a graphical manner.
? The well-known Message Sequence Chart technique has been incorporated into the
Unified Modeling Language (UML) diagram under the name of Sequence
Diagram . A sequence diagram shows, as parallel vertical lines, different processes
or objects that live simultaneously, and, as horizontal arrows, the messages
exchanged between them, in the order in which they occur
4.6 Data Modeling:
4.6.1 E-R Diagram:
? In software engineering, an entity–relationship model (ER model ) is a data
model for describing the data or information aspects of a business domain or its
process requirements, in an abstract way that lends itself to ultimately being
implemented in a database such as a relational database. ?
? The main components of ER models are entities and the relationships that can
exist among them, and databases. ?
? An entity-relationship model is a systematic way of describing and defining a
business process. ?
? The process is modeled as components (entities) that are linked with each other by
relationships that express the dependencies and requirements between them, such
as: one building may be divided into zero or more apartments, but one apartment
can only be located in one building. Entities may have various properties
(attributes) that characterize them. They represents the relationship between
entities so calle as Entity-Relationship Diagram.
? In software engineering, a class diagram in the Unified Modeling Language
(UML) is a type of static structure diagram that describes the structure of a system
by showing the system’s classes, their attributes, operations (or methods), and the
relationships among objects. ?
? The class diagram is the main building block of object oriented modeling. ?
? It is used both for general conceptual modeling of the systematic of the
application, and for detailed modeling translating the models into programming
? Class diagrams can also be used for data modeling. ?
? The classes in a class diagram represent both the main objects, interactions in the
application and the classes to be programmed. ?
? In the diagram, classes are represented with boxes which contain three parts: ?
? The top part contains the name of the class. It is printed in Bold, centered and the
first letter capitalized. ?
? The middle part contains the attributes of the class. They are left aligned and the
first letter is lower case. ?
? The bottom part gives the methods or operations the class can take or undertake.
They are also left aligned and the first letter is lower case. ?
? ? ? ? ? ? ?? ? ? ?
4.7 Main Modules of New System
The Interview Tracker System can be used to manage Interview process and reduce
complexity and time required for the completion of whole interview process right from
importing resumes to finalizing the candidate. It will support both standalone and also
The main modules involved in this system are:
? Recruitment team
? Technical team
Module Wise description
Admin: ? Admin can use system after proper authentication by user name and password.
? In case admin forget password or done multiple fail authentication than can recover
? Manage Recruitment team, Manage Technical team, Manage HR, Manage Candidate.
Recruitment Team :
? They can arrange the interview .
? They can send the contact information to candidate through application.
? They can send interview schedule through application.
? Get candidate feedback from technical Team.
? They can arrange any round of any candidate those are interested.
? Send the resume to Technical Team through application.
Technical Team :
? They can view the interview schedule.
? They can give the candidate feedback category wise.
? They can took technical as well practical feedback.
? They can view all the candidate information and resume.
HR Team :
? HR can generate the report for all the schedule interview report.
It can be monthly yearly as per requirement.
? HR can finalize the candidate and close the process for particular candidate.
? HR can transfer that candidate in MRMS application.
? HR can give the end date for close the particular position.
4.6.2 Asp.Net MVC is one of the best MVC architecture with the support of
many languages to develop web application for small and large
enterprise with portable implementation.
4.6.3 Sql is also best open source database engine to work.
4.6.4 Combination of both will give great web application as output.
4.9 Design Engineering Canvas:
Aeiou summary canvas include all the prior working stuff that are needed to be kept in
mind before the execution of project it include Activity, Environment, Interaction, Objects
4.9.2 Ideation canvas:
Here comes the second task that was to create ideation canvas this canvas consist of the
ideology behind the users , so in this canvas people section consists of person related to
users technically or non technically . then we grouped the activity among social ; technical
and try to find out the importance of each activity and situation ; location regarding ar e
find out related to each. The components included in ideation canvas are people, activities,
situation or context and possible solutions that are required for the project.
4.9.3 Product Development Canvas:
Product development canvas includes all those aspects that are required for the making and
version controlling of any product, the product development clearifies what is done in the
project and what would be the future updates in the project Product development canvas
includes purpose, product experience, product functions, product features, people,
components, costumer revalidation and redesigning of the product.
4.9.4 Empathy mapping canvas:
Empathy canvas includes all the credits to the stakeholders and the review and requirements
of the products The empathy canvas covers up users, stakeholders, activities and story
boarding in it.
5.1 Advantages of Interview Tracker System:
1.Reduces time spent with administrative tasks
This system allows you to speed up your recruitment process and save yourself a huge
amount of time for more important tasks. Stop manually publishing your listing on job
boards, one at a time, or sending follow up emails individually.
2.Facilitates Collaborative Hiring
This Systems come with amazing features that facilitate collaborative hiring. HR teams can
easily and quickly share notes and ratings on every candidate and drive a collective decision-
making process, in which every recruiter has a say.
Collaborative hiring has major benefits for companies, such as allowing to assemble more
diverse and successful teams.
3.Speeds up the Recruitment Cycle
Having all candidates’ information centralized and organised in one single platform, gives
recruiters faster access to the hiring process overview. Automated communication features
also increase the recruitment cycle, making it quicker to provide general follow up and to
move candidates for the next steps. Overall, an Applicant Tracking System allows recruiters
to develop and execute a more efficient workflow.
4. Enhances Candidate Experience
Besides building a more efficient hiring process, This Systems enable an enhanced candidate
experience, which is key for the success of your hiring process. After all, candidates may
become your future ambassadors.
5.2 Scope of future work
Recruitment in any organization is of utmost importance. Be it bringing in fresh talent to a
corporate firm or building a strong & like minded team for a Start Up, recruitment takes the
prime seat. Recruitment is a vast initiative in its own. It is not just about getting the right
talent, but also about setting up the right processes in order to achieve the goal of hiring good
Recruitment is indeed a process in itself. The process is driven by job posting portals, hiring
(consulting) organizations, candidate assessment firms, Human Resource Management
Systems (HRMS), and much more. Bringing them all together in order to match the
‘s hiring practices is not as easy as it sounds.
Complexity of the recruitment process increases with the growth of an organization.
Conventional methods of recruitment no longer stand effective at such scale. These
conventional methods include sourcing over E-mails, maintaining Excel files, online and
offline storage drives and implementation of Enterprise Resource Planning (ERP) modules.
Hence, the need is to replace them with technology that allows them to manage end- to-end
recruitment from one place. Such technology options include Process Management
Softwares, Candidate Tracking Systems ; applications based on machine learning , Natural
Language Processing (NLP), predictive analysis, etc. There is also a need to provide a one
stop solution that integrates different vendors, portals and management softwares for end to
end recruitment execution.