My Ssec Capstone Project GUJARAT TECHNOLOGICAL UNIVERSITY 1174757334254651375733425 Lukhdhirji Engineering College

GUJARAT TECHNOLOGICAL UNIVERSITY 1174757334254651375733425 Lukhdhirji Engineering College

Lukhdhirji Engineering College,
By: Flori Wadher (150310116031)

(Faculty Guide)

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!

order now

(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,
Flori Wadher(150310116031)
Candidate’s Declaration
I hereby declare that project report titled “Interview Tracker System” submitted towards the completion of project in 7th 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 7th semester.

Candidate’ signature

Candidate name

: Flori Wadher

: Information Technology
Enrollment Number

: 150310116031
Submitted to:
Lukhdhirji Engineering College,
Morbi Affiliated to:
Gujarat Technological University
No. Title Page no.

Acknowledgement 1
Candidate Declaration 2
Abstract 3
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 technologies concepts.

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 selected HR is responsible to add candidate in HRMS application from where will generate all the employee records.

1.1Project 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 candidates, etc.

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 candidate also.

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 finalized.

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.4Technology and Literature Review:
The front end used in our project is HTML, Javascript, CSS, JQuery and the back end used is
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 within a single website or between websites.

HTML uses "markup" to annotate text, images, and other content for display in a Web browser.

JavaScript s a high-level, interpreted programming Language.

It is a language which is also characterized as dynamic, weakly typed, prototype-based and multi-paradigm.JavaScript enables interactive web pages and thus is an essential part of web applications.5
Asp.Net MVC
The 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 layers:
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.








statements, which




as sublanguages,

a data
language (DQL), a data
definitionlanguage (DDL), a data
language (DCL),


a data
manipulationlanguage (DML). The scope of SQL includes data query, data manipulation (insert, update and delete), data definition (schema creation and modification), and data access control.

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 and JavaScript.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.

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 additional plans.

The project plan clearly defines how the project is executed, monitored, controlled and closed.

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 timeframe.

A project schedule is a document collecting all the work needed to deliver the project on time.

But when it comes to creating a project schedule, well, that’s something few have deep experience with.

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
2014 2 0 ID Task Name Start Finish Duration 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 – – – 6515100-1104265
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 also.

Recruitment Team:
It collects resumes, schedules interviews, checks requirements, manages rounds of interview,
Takes feedback , etc.

Technical Team:
Technical team take interviews, sends feedback about the candidate to the HR.

Human Resource:
The HR team gets candidate feedback from interviewer and arranges HR round according to the interviewers feedback.

3.3 Hardware and Software Characteristics:
Hardware Requirements:
Intel core i3 with 2.00 GHz or higher or any other compatible processor.

1 TB storage capacity.

RAM: 4GB minimum
Software Requirements:
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 sanctions.

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 than 128Mb.

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 paperwork.

4.2.1 Functional Requirement:.

Log in:
This function will enables HR ,Technical team, candidates and recruitment team to login into the system
Import resume:
This function will allow to import resume of candidates and add details of candidate .

Schedule Interview:
The recruitment team arrange and schedules interviews according to the requirements
View feedback:
This function will enable HR to view status so that HR can understand that to move the candidate in next round or not
Search candidate:
This function will enable the recruiting teamto search a candidate.

Generate report:
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 unauthorized user.

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.

Operational Feasibility
Technical Feasibility
Schedule Feasibility
Economic Feasibility
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.

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.

Better Considering:
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.

Schedule Feasibility:
Schedule feasibility corresponds to whether sufficient time is available to complete the project.

Factor considered:
Schedule of the project
Time by which project has to be completed
Reporting period
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:
4.5.1 Use-Case:
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 frameworks.

With its iterative and evolutionary nature, use case is also a good fit for agile development.

4.5.2 Activity Diagram:
1 login:
304800307340307340304800304800103860607254240304800Activity 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 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.

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
304800304800exchanged 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.

3048003073403073403048003048001038606072542403048004.6.1 Class 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 code.?
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?
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 networking environment.

The main modules involved in this system are:
Recruitment team
Technical team
Module Wise description
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 password.

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.

304800307340307340304800304800103860607254240304800It 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.8 Justification:
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.9Design Engineering Canvas:
AEIOU Summary:
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
304800307340307340304800304800103860607254240304800and Users.

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 are 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.

304800307340307340304800304800103860607254240304800CHAPTER 5
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 employees.

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 organization’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.