Visvesvaraya Technological University

Belgaum, Karnataka-590 018

A Internship Report on

“Ellucian Internship Program”

Internship Report submitted in partial fulfillment of the requirement
for the award of the degree of
Bachelor of Engineering
In
Electrical & Electronics Engineering

Submitted by
Guru Pratheek JK
1CR16EE027

Under the Guidance of

Mrs. Sanitha Michail.C

Associate Professor, Department of Electrical & Electronics Engineering

CMR Institute of Technology

CMR Institute of Technology,

Bengaluru-560 037
Department of Electrical & Electronics Engineering

2019-2020
CMR INSTITUTE OF TECHNOLOGY
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
AECS Layout, Bengaluru-560 037

Certificate
Certified that the Internship work entitled “Ellucian Internship Program” carried out by
Mr. Guru Pratheek JK (1CR16EE027) is a bonafied student of CMR Institute of
Technology, Bengaluru, in partial fulfillment for the award of Bachelor of Engineering in
Electrical & Electronics Engineering of the Visvesvaraya Technological University,
Belgaum, during the year 2019-2020. It is certified that all corrections/suggestions indicated
for Internal Assessment have been incorporated in the Report deposited in the departmental
library.
The internship report has been approved as it satisfies the academic requirements in
respect of internship work prescribed for the said Degree.

Signature of the Signature of the HOD Signature of the

Guide Principal

--------------------------------
----------------------------- Dr. K. Chitra -----------------------------
Mrs.Sanitha Michail.C Professor & HOD Dr. Sanjay Jain
Associate Professor EEE Department Principal,
EEE Department CMRIT, Bengaluru

External Viva

Name of the Examiners Signature & Date

1.

2.

ii
Company Logo

CERTIFICATE OF ATTENDANCE

This is to certify that Guru Pratheek JK has completed internship from 16/01/2020 to
15/04/2020 at “Ellucian Higher Education Systems India Pvt Ltd” under my guidance.

During the internship period, we found his/her conduct to be good. We wish him/her all the
best for his/her future endeavours.

Sign Sign

Name of internal guide Name of external guide

Designation Designation
CMR Institute of Technology Name of company

CMR INSTITUTE OF TECHNOLOY

DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING

iii
AECS Layout, Bengaluru-560 037

DECLARATION

I, Mr. Guru Pratheek JK (1CR16EE027) hereby declare that the report entitled “Ellucian
Internship Program” has been carried out by me for the internship completed under Ellucian
Higher Education Systems India Pvt Ltd for the duration of 3 months (from 16/01/2020 to
15/02/2020), under the guidance of Mrs. Sanitha Michail.C, Associate Professor, Department of
Electrical & Electronics Engineering, CMR Institute of Technology, Bengaluru, in partial
fulfillment of the requirement for the degree of BACHELOR OF ENGINEERING in
ELECTRICAL & ELECTRONICS ENGINEERING, of Visveswaraya Technological
University, Belgaum during the academic year 2019-20.The work done in this report is original
and it has not been submitted for any other degree in any university.

Place: Bangalore Guru Pratheek JK (1CR16EE027)

Date:

iv
Acknowledgement

The satisfaction and euphoria that accompany the successful completion of any
task would be incomplete without the mention of people, who are responsible for the
completion of the project and who made it possible, because success is outcome of hard
work and perseverance, but stead fast of all is encouraging guidance. So with gratitude I
acknowledge all those whose guidance and encouragement served us to motivate towards
the success of the internship work.

I take great pleasure in expressing our sincere thanks to Dr. Sanjay Jain,
Principal, CMR Institute of Technology, Bengaluru for providing an excellent
academic environment in the college and for his continuous motivation towards a
dynamic career. I would like to profoundly thank Dr. B Narasimha Murthy, Vice-
principal of CMR Institute of Technology and the whole Management for providing such
a healthy environment for the successful completion of the project work.

I would like to convey my sincere gratitude to Dr. K Chitra, Head of Electrical

and Electronics Engineering Department, CMR Institute of Technology, Bengaluru
for herin valuable guidance and encouragement and for providing good facilities to carry
out this project work.

I would like to express my deep sense of gratitude to Mrs.Sanitha Michail.C ,

Associate Professor, Electrical and Electronics Engineering, CMR Institute of
Technology, Bengaluru for his/her exemplary guidance, valuable suggestions, expert
advice and encouragement to pursue this internship work.

I am thankful to Mr. Rajanikantha R, Senior Software Developer, Ellucian

Higher Education Systems, Mrs. Rachana Narasimhamurthy, Lead software
developer, Mr. Anand Gururajan, Senior Manager and all other employees for
helping us in all possible manners during the entire period.

Finally, i acknowledge the people who mean a lot to me, my parents ,for their
inspiration, unconditional love, support, and faith for carrying out this work to the
finishing line.

Lastly, to the Almighty, for showering His Blessings and to many more, whom I

v
didn’t mention here.
Completion certificate from Company (scanned copy)

vi
CONTENTS

Title Page i
Certificate ii

Attendance Certificate from company iii

Declaration iv

Acknowledgements v

Completion certificate from Company vi

Contents vii

Chapter 1: INTRODUCTION 9-15

1.1 Introduction 9-10

1.1 Objectives of the Internship 11

1.2 About the Company 12

1.3 Contribution and nature of work 13-15

CHAPTER 2: SCOPE OF INTERNSHIP 16-19

2.1 Related work and Tasks performed 16-19

Chapter 3: RESULTS AND DISCUSSIONS 20

Chapter 4: CONCLUSIONS AND FUTURE DIRECTIONS 21

Chapter 5: References 22

vii
LIST OF FIGURES

Figure 1: A picture of Eclipse IDE 16

Figure 2: A snap of SQL developer 16

Figure 3: Eclipse IDE Terminal 17
Figure 4: A snap of Postman app 17
Figure 5: Universal Review Page 18

ABBREVIATIONS USED
viii
7
TCSI : Transforming the Collection of Student Information

API: Application Programming Interface

UID : Unique Identifier

HEIMS: Higher Education Information Management System

DE: Department of Education

DHS: Department of Human Services project

CHAPTER 1
ix8
INTRODUCTION

The Higher Education Information Management System (HEIMS) project is designed to

address the needs of the Department of Education (DE) and Department of Human
Services project (DHS) on Transforming the Collection of Student Information (TCSI).
The HEIMS/TCSI APIs enable Banner to interact with the DE (Department of Education)
and the DHS (Department of Human Services) in near real time and reduce duplication at
the education providers' end by allowing to ‘submit one time and inform many' knowing
that the data will reach both agencies.

The HEIMS/TCSI APIs provide the Banner software access to the data elements (or in
API terms, endpoints) in near real time. The education provider gets access to only the
information based on their information access rights. The APIs are designed to be easy to
consume, with a content structure similar to the data and file elements that the industry
has come to know and is familiar with, to enable ease in adoption.
Transforming the Collection of Student Information, or TCSI, is a joint project between
the Department of Education (DE) and the Department of Human Services (DHS)
working together with education providers to build a better solution facilitating the
efficient collection of student information.
The project seeks to provide the following benefits to the different stakeholders in this
information collection process.
For education providers it will:
• Be a more streamlined data exchange with government
• Clearer point of interface with government
• Improve data availability

For students it will:

• Make DHS student claims simpler
• Improve payment accuracy
• Help maintain their student payment to complete their studies

9
For government it will:
• Reduce administrative and system inefficiencies
• Reduce student debt
• Reduce staff processing

TCSI will provide solutions that will replace the Higher Education Provider Client
Assistance Tool (HEPCAT) for all education providers and the Centrelink Academic
Reassessment Transformation (CART) process for universities.\

The solutions provide two interaction channels that will enable education providers to
continue data submission and comply with reporting requirements. These two interaction
channels are:
• A Business-to-Government (B2G) channel for education providers using student
management software to manage student information and their reporting requirements.
TCSI will introduce TCSI APIs (Application Programming Interface) which the software
will be able to interact and perform queries and data submissions.

• A Provider Portal for the education providers who are unable to adopt the B2G
solution. The Provider Portal will be available for providers to upload data files such as a
spreadsheet to support data submission and reporting needs from this group of providers.

10
CHAPTER 1

OBJECTIVES OF THE INTERNSHIP

 To learn all the required technologies to develop API’s

 Java, Git, DataBase Management System(DBMS), Postman(to hit
API endpoints), Java Database Connection(JDBC) are some of the
technologies which was needed to be learnt.
 To develop API’s for the Australian TCSI as per their requirements
mentioned in their handbook.
 To fix the bugs raised by the Quality Analysts after testing the
already built API’s.
 To learn the necessary skills to Present and interact in a a corporate
environment and to work in and as a team.
 To develop APIs which are designed to address the needs of the
Department of Education(DE) and Department of Human Services
project(DHS) on Transforming the Collection of Student
Information(TCSI).

11
CHAPTER 1

ABOUT THE COMPANY

Ellucian is the world's leading provider of software and services higher

education institutions need to help students succeed. Ellucian provides
student information systems (SIS), finance and HR, recruiting, retention,
analytics and advancement software solutions

Ellucian was founded in 2012 after Higher Education industry Leaders

SunGard and Datatel came on to a mutual agreement to operate as a
single company, Ellucian.

Ellucian Banner is the world's leading higher education enterprise

resource planning (ERP) system. It is designed to simplify everyday
processes. It includes self-service options that let users access the features
they need any time, from any device.

Ellucian Experience. Provide the personalized content constituents

need to be more productive, all from a single modern interface, at
home or on the go.

The data model, which will integrate Ellucian solutions and partner
solutions, culls data from various software platforms so that it can be
transformed into a comprehensive, high-definition snapshot of the student
and track progress from recruitment to career placement. This
comprehensive view will enable higher education institutions to better
understand and make use of data surrounding each student.

12
CHAPTER 1

CONTRIBUTION AND NATURE OF WORK

Nature of work

 The internship was focused more on Learning new

Technologies like Java, DataBase Management
System, GIT and Java database connection.

 Initial two weeks was to be utilized to learn the

basics for the necessary Technologies from
Linkedin learning and other online Sources.

 After the first 2 weeks of learning, I was given few

assignments and coding exercises to make us
understand how the actual work will go through.

 It mainly involved manipulating the Data obtained

in the form of JSON array into the Tables.

 The first project was to work on an ongoing

development of APIs, the Aggregated awards and
my job was to develop delete API for the same.

 The work involved code writing, unit testing of the

code and after unit testing the code, if working fine

13
should be sent for the Code Review.

 Once the Code is reviewed by the senior

developers, it will be approved. On approval the
code will be merged with the Dev branch from
where it will be picked up by the Quality Analysts
(QAs) to test the code in the client/Build
Environment.

 There were daily “Standup” meeting with the team

to discuss the progress of the work.

 After each sprint (15days), we would have a sprint

review meeting with the team to analyze how
things went in the current sprint and also planning
session for the next sprint.

14
CHAPTER 1

CONTRIBUTION AND NATURE OF WORK

Contribution:

 Development of Delete API for Course

specialization of Aggregated Awards API.

 Development of GET method for the Early Exit

Award API.

 Performing code clean up for all the previously

developed APIs, and testing them for their
functionality.

 Working on Bug Fixes for the “Course on

campus” API.

 Working on Course Admission and it’s sub

processes for the logic change as required by the
client.

 Representing my team (R&D Titans), along with

my co intern in the interns project Fair and
bagging 3rd place among 18 teams of interns.

15
CHAPTER 2

SCOPE OF THE INTERNSHIP

Related Work:

The coding part was done with Eclipse IDE, which is most commonly
used by Java developers.

Figure 1
The databases were accessed by using SQL Developer.

16
Figure 2

CHAPTER 2
After writing the code , it has to be unit tested, below is the screenshot of
the Terminal while Testing. It gives us the information regarding how
many records were taken up to process, how many were processed
successfully and how many failed

FIGURE 3

17
To check whether the records has been posted/patched successfully we use
the Postman app to hit the endpoints.

METHODOLOGY

Figure 4

CHAPTER 2
After reviewing from the post man, the code is pushed into the Dev Branch and it’s built
using jenkins, after building the code it will be available to the client page(UNIVERSAL
REVIEW PAGE). The picture of the Universal Review page is shown below.

FIGURE 5

TASKS PERFORMED:

18
 Building the functionality for the Aggregated Awards Course Specialization
Delete Process, and testing it.
 An aggregated award is given to a student who has completed a few courses in
one university and wishes to do the rest from the other institution/university.
 Coding for the Early Exit Awards Get API.
 An early exit award is given to a student who has completed all the essential work
to complete a course before completion of it’s actual duration.
 Fixing the Bugs raised, regarding the Course On Campus.
 Performing the code clean up for all the APIs, and testing them again for their
functionality.

 Code cleanup includes removal of all the unnecessary imports, removing unused
variables, formatting the code and to remove hardcoded code by replacing it from
the written library.

CHAPTER 2

 Testing the code from the Build Environment , in a Quality Analyst’s

perspective,by testing the code for all the possible scenarios.

 Types of Tables: Collector table and Bulk Table.

 BULK TABLE: The bulk table will have All the data which has to be posted,
the Data will be created in these tables by some specific Processes.

 COLLECTOR TABLE: The collector table is also called as Staging table.

This table will have all the Latest Data which is there in the TCSI server.

 Types of APIs: GET, GET UID, POST, PATCH, DELETE.

 POST: The Post method is used to send the records/data to the TCSI server. On
successfully posting the server returns an Unique Identifier (UID)for that
particular record

 PATCH: The patch operation can be performed if it is needed to change any

particular field’s value after the record is posted. On patching the Data is changed
in both the TCSI server and the Collector and Bulk Tables.

19
 GET-UID: The Get Uid is performed to get the details like the UIDs and other
fewer related fields of all the Records which are already posted. The data is
returned in the form of JSON array. This Data is segregated and filled into the
corresponding rows of the Collector Tables.

 GET: The Get method is performed to access all the data which has been posted for a
record. This data can be obtained by hitting the endpoint with the particular record’s UID.
The server will return all the fields along with the fields which are already obtained in the
GET UID method. The obtained Data is checked for few validations, and if all the
validations are successful, then the data is entered into the collector table.

 DELETE: The delete operation can be performed by hitting delete API with the
particular endpoint along with UIDs. The data will be deleted from the TCSI server as
well as Collector tables but in the bulk Table the Uid column will be made null but the
entire record exists for future use.

CHAPTER 3

RESULTS AND DISCUSSION

 The main take away from the internship is learning of new technologies
like JAVA, DBMS, GIT etc

 Understanding the working and designing of APIs.

 Learning how to write queries to pick up data from the tables using SQL,
i.e Structured Query Language.
 Learning how to convert the query raised by the customer and converting
it into work to solve or achieve the goal.

 Learning how to present oneself in a corporate environment and all the

things which are required when one is presenting an idea.

 Learning how to debug code in an efficient manner and not getting lost
while doing so.

20
 Learnt how to interact in daily Standup calls (MEETINGS).

 Realizing what’s the best way to learn new technologies fast.

CHAPTER 4

CONCLUSIONS AND FUTURE DIRECTIONS

CONCLUSIONS

 The overall experience was good as I learnt a lot of new and relevant technologies
required to carry out the assigned work.
 The main take away was that “Quality” comes first, rather than just completing
the job.
 Leant a whole new ways in which teams should work in a corporate environment.

 APIs give a whole new level of solutions for problems related to higher education.

 Continuous learning is the only way to achieve Excellency and speed while
working.

FUTURE WORK

21
 To develop working code quickly without compromising it’s quality.

 To learn JavaScript and HTML to develop front end for the projects.

 To learn PL-SQL(Procedural Language extensions to the Structured Query

Language), for ease in programming Page related development.
 Learning Automation to test the quality of written code by writing appropriate
Test Cases.

CHAPTER 5

REFERENCES

 For textbooks – “Head First Java” ,Book by Bert Bates and Kathy
Sierra.

22
23