Empowerment and livelihood improvement of Integrated Solutions Limited

Empowerment
and livelihood improvement of Integrated Solutions Limited

 

1.0:
Introduction

 

Database Management System (DBMS)

 

  • It is the software
    that defines a database, stores the data, support a query language,
    produces reports and creates data entry screens

                                                                                    

A Database Management System (DBMS) is a
software package with computer programs that control the creation,
maintenance, and the use of a database. It allows organizations to conveniently develop
databases for various applications by database administrators (DBAs) and other
specialists. A database
is an integrated collection of data records, files, and other database objects. A DBMS allows different user
application programs to concurrently access the same database. DBMSs may use a
variety of database models, such as the relational
model
or object model, to conveniently describe and
support applications. It typically supports query
languages
, which are in fact high-level programming languages,
dedicated database languages that considerably simplify writing database application
programs. Database languages also simplify the database organization as well as
retrieving and presenting information from it. A DBMS provides facilities for
controlling data access, enforcing data
integrity
, managing concurrency control, recovering
the database after failures and restoring it from backup files, as well as
maintaining database security.

A DBMS is a set of
software
programs
that controls the system organization,
storage,
management, and retrieval of data in a database.
DBMSs are categorized according to their data structures or types. The DBMS
accepts requests for data from an application program and instructs the operating
system
to transfer the appropriate data. The queries and responses must be submitted
and received according to a format that conforms to one or more applicable
protocols. When a DBMS is used, information systems can be changed more easily
as the organization’s information requirements change. New categories of data
can be added to the database without disruption to the existing system.

Database servers
are dedicated computers that hold the actual databases and run only the DBMS
and related software. Database servers are usually multiprocessor
computers, with generous memory and RAID disk arrays used for
stable storage. Hardware database accelerators, connected to one or more
servers via a high-speed channel, are also used in large volume transaction
processing environments. DBMSs are found at the heart of most database applications. DBMSs may be built
around a custom multitasking kernel with built-in networking
support, but modern DBMSs typically rely on a
standard operating system to provide these functions.

Definition:
A database management system (DBMS)
is the software that allows a computer to perform database functions of
storing, retrieving, adding, deleting and modifying data. Relational database
management systems (RDBMS) implement the relational model of tables and
relationships.

 

Also
Known As:
DBMS

Examples:

Microsoft
Access, MySQL, Microsoft SQL Server, Oracle and FileMaker Pro are all examples
of database management systems.

 

1.1 Procedure of DBMS:

In a
well-structured database application, SQL statements are typically not
distributed over the entire application but concentrated in a single access
layer instead. This access layer has a procedural interface to the rest of the
application at which the operations for application objects are made available
in form of abstract data types.

In client/server
configurations, the client and server interact when an SQL statement is
executed in the access layer. The number of these interactions can be reduced
considerably by transferring the SQL access layer from the client to the
server.

SAP DB provides a
language (special SQL syntax) for this purpose that allows an SQL access layer
to be formulated on the server side. This special SQL syntax can be used to
define database procedures and triggers.

This has three
main advantages:

  • The number of interactions between client and
    server is reduced considerably (several factors). Client/server
    communication is only required for each operation on the application
    object, and not for each SQL statement. This enhances the performance of
    client-server configurations considerably.
  • The SQL access layer contains the procedurally
    formulated integrity and business rules. By concentrating these rules on
    the server side and eliminating them from the database applications,
    modifications can be made centrally and thus become valid immediately in
    all database applications. In this way, the integrity and decision rules
    also become a part of the catalog in the database system.
  • An SQL access layer in the form of database
    procedures transferred to the server side is an essential customizing
    tool, as it allows customer-specific database functionality to be
    included.

To be able to
execute a database procedure, users must have the call privilege. This call
privilege is independent of the user privileges for the tables and columns used
in the database procedure. As a result, users may be able to use a database
procedure to execute SQL statements that they otherwise would not have access
to.

Database
procedures are called explicitly from the programming language of the
application. They can contain parameters, except for LONG columns.
The extent to which LONG columns can be used within database procedures depends
on the length of the LONG columns and the amount of storage space available.

As
with any SQL statement, precautions must be taken to ensure that calling a
database procedure has the desired effect, and that errors do not have any
lasting effects on the database system. SAP DB provides nested transactions for
this purpose. Each database procedure call can run in a sub
transaction
that can be reset without interfering with transaction
control in the database application

 

2:
 COMPANY PROFILE
 

 

2.1 ABOUT INTEGRATED SOLUTIONS LIMITED

Integrated
Solutions Limited (ISL) is an innovative provider of information and
Communication Technology (ICT) products and services in Bangladesh &
Australia. It is a joint venture company between those two countries. Their
products and services are used by government bodies and large to small
companies at home and abroad through its commitment and dedication towards
quality, innovation and customer satisfaction. 

                                                              

Integrated Solutions brings
the integration of ICT into daily and corporate life by providing products and
services along with mentoring of global standards.

ISL’s computing
professionals are trained at some of the leading institutions in the world, and
have extensive experience in national and international ICT projects. They are
committed to providing the very best in products and services to their clients
who will substantially contribute to their growth and long term prosperity. Its
aim is to inspire and delight their customers and communities with their
innovative products and services at home, on the move and at work.

At ISL, a group of hard
working young talented people, driven by intelligence, taste and patience,
transforms the need and dream of the customer into reality by their core
technical knowledge and expertise.

ISL believes that a good
development needs to be backed up by good customer support and this is a common
practice in ISL. This is the reason the customers rate them so high. They also
believe in achieving perfection through open source collaboration for software
development; therefore they try to practice open source whenever it’s possible.

ISL employs
professionals that are experts in installing, training and maintaining
application software packages. They customize accounting and contact management
software to meet the specific needs of the company and help to get the most out
of client’s word processing and spreadsheet software.

2.1
HISTORY OF INTEGRATED SOLUTIONS LTD.

Integrated Solutions is software
and IT related company that was established in Australia in the early 1995.
Then it starts its operation in Bangladesh as joint venture Company in the
early 2000. In Bangladesh it works in various domains of software development
and offers robust high quality solutions for wide range of platforms. At ISL,
they believe the best way to develop business is through assuring user
satisfaction and quality assurance.

With
monumental changes taking place in the computer Industry, companies need to
keep current of the latest technology and how it affects their business.
Integrated Solutions provides companies with this expertise. They offer a wide
variety of products & services and maintain a staff of systems and software
professionals, whose diverse talents enable them to offer the best solutions to
businesses. Whether you need a complete system design or merely help with a certain
application, ISL can find a solution that will work for you. Integrated
Solutions was founded in Bangladesh early 2000 and has grown substantially, due
to the importance it place on customer satisfaction. ISL understand your
computer systems are an integral part of your daily business activities. It
knows the frustration that occurs when your system is not operating
efficiently. Integrated Solutions is dedicated to ensuring that everything
possible is done to maintain quality in the products, systems and software they
provide their customers. They are available to our customers 24hours a day, 7
days a week as their commitment to quality and excellence that customers
deserve.

 

2.3 MISSION

Deliver
state-of-art software and technology solutions to our customers through
quality, innovation and leadership.

 

2.4 VISION

Our vision is to be recognized as the company of
choice for information technology products and services, which provide value to
our customers and communities.

 

To achieve this vision we aim to

·        
Strengthen
customer commitment by better understanding their needs, leveraging all ISL
solutions to meet these needs and exceeding their expectations.

·        
Position
ourselves competitively in the market with expertise in technologies that are
driving the industry globally.

·        
Maintain
commitment to professional development processes that recruit, nurture and
retain the ‘right’ people and further develop their expertise.

·        
Through
continuous review and improvement, accelerate the development of the
organization as the efficient, low cost operator.

2.5 GOALS

ISL deliver the value to
their customers by providing expertise in:

·        
Business solutions delivered through application
software.

·        
Design, implementation and management of reliable
technology infrastructure.

·        
Cost effective procurement of IT hardware and
software.

 

2.6
CORPORATE VALUES

ISL always try
to be satisfied their valued clients and customers through their requirements.
This means, we will hold the following values and will be guided by them as we
do our jobs.

 

·        
Creating
an honest, open and enabling environment

·        
Have
a strong customer focus and build relationships based on integrity, their
requirements, service, maintenance and mutual benefit

·        
Strive
for profit & sound growth

·        
Relentless
in pursuit of business innovation and improvement

·        
Responsible,
trustworthy and law-abiding in all that we do

 

2.7
ISL’s CLIENTS:

Integrated
Solutions has a growing list of clients ranging from government bodies and
large national and international companies to small businesses. Our clients
appreciate our ability to constantly exceed their own and their client’s
expectations.

·        
Ministry of science and Information
& Communication Technology, Bangladesh

·        
Ministry of planning, Bangladesh

·        
MIS Technologies Centre, Singapore

·        
Turner Freeman Lawyers, Australia

·        
BASF Bangladesh

·        
PHP Group, Bangladesh

·        
Intraco Group, Bangladesh

·        
Bangladesh Army

·        
ZAF Sweaters & Garments

·        
Khan Foundation, Bangladesh

·        
The Millennium University, Bangladesh

·        
Australian Campus Network, Australia

·        
Bangladesh Project Management Institute

·        
Ahmad Medical Centre, Bangladesh

·        
PNS Graphics, Australia

·        
Islam & Associates

 

2.8
ISL PRODUCTS:

ISL
develops markets and supports an ever-expanding line of products. This delivers
the best in terms of quality, security and value to our clients. Our products
are used by public authorities as well as businesses such as garments
industries, medical professionals, accounting and law firms, travel agents,
fleet managers etc.

 

Some
of our recent products are:

Web
portal
is a unique program for online
publication of forms and public notices of all ministries of Bangladesh. The
program is an important step towards e-governance and is funded by the ministry
of Science and information & Communication Technology, Bangladesh.

 

Project-I is a workflow enabled project management system. This
Lotus Notes application provides ‘whole of project’ life cycle tracking system,
offering total control for project management. Project-I has a set of tools for
most project management tasks including budgeting, tracking expenditure, and
cash flows. It comes with a financial system interface and can be customized to
suit any organization.

 

Diagnostic-I is a leading software for streamlining the
complexities of data management in the medical industry. It can be used for registering
patients, creating appointments and consultations, maintaining patient queries
and medical reports.

 

Inventory-I is a complete inventory management system for receipt
of fabrics and accessories against an order as well as issuing to production line
and local store transfer. This is an essential software in garments industry.

 Rim-I
is an innovative research management tool suitable for any private sector
organization that undertakes large scale research activities. Rim-I captures,
stores and indexes the total research process and makes the information
available for access and reuse throughout an organization.

 

Account-I is developed for trading, intending and other uses by
private organizations who need pure accounting to easily create and maintain
their own chart of accounts.

 

Mobile-I specially developed to meet the needs of senior
executives in both private and public sectors. This is an integrated workplace
information management solution which goes beyond standard personal information
management packages. The software is being used in different ministerial
offices in Australia.

 

Travel-I management system uses the workflow capabilities of
Lotus Notes to manage payments related to travels undertaken by employees in
government and large organizations.

Law Soft-I is developed for law firms to keep track of progress
of cases and allows them to monitor staff activities.

 

2.9 SERVICES:

Integrated
Solutions provides a full range of services that offer our clients the benefits
of an experienced IT development, without the expense of developing and
retaining comprehensive in-house resources. We are dedicated to achieving the
best results in software and website development, IT outsourcing, network
design and implementation, security and training.

 

Software Development:

ISL’s
Software Development team can create purpose built software that enhances your
business process, optimizes, resources and streamlines your organization Off-the-shelf
solutions cannot address the unique requirements of information management
technologies with legacy systems, existing networks and subsystems, requires a
complex level of skill and experience.

 

ISL
has access to a team of highly skilled and experienced technologists in the
areas of software design, development and implementation. We use latest tools,
techniques and methodology, and make extensive use of reusable code and objects
that have been stress-tested. Our custom software is designed and developed to
meet your specific needs, and in doing so, we provide the best in information
to your business. The solutions we provide for our clients involve our team in
all key phases of software delivery, from base design through to complete
development.

 

Web
Development

ISL
has the expertise to provide your business with all the very latest in website
development. Our team has expertise in all facets of static and dynamic web
development.

From
a basic website to more complex database driven e-commerce and shopping
facilities, the ISL web development team will be able to provide you with any
service you may need to promote your group to the largest audience available.

 

Network Services:

Infrastructure Design &
Implementation

When
it comes to networking we at Integrated Solutions can design, implement, deploy
and manage any network to custom meet your needs now and in the future. We
understand the

importance
of a quality sound network backbone to ensure your businesses functionality
with critical data, applications and day to day operations.

The
core of your organization is your network and a poorly designed network can
cost your company countless headaches. Whether your upgrading your current
network or planning and designing a new network we will carefully work with you
to design and implement the best possible solution for your company’s needs.

·        
Remote Desktop Support

·        
System Maintenance

·        
Remote Backups

·        
System Monitoring

·        
Email/Internet Access/Web Hosting

·        
WAN’s/Blended WANs

·        
Managed Firewalls

·        
Network Security

LAN/WAN Support

Technology
is evolving over leaps and bounds even as you read this. In order to stay ahead
of your competitors you must accept these changes and implement these new
technologies to keep yourself one step ahead of the competition.

 

Companies
are changing and evolving as readily as technology is. As companies become more
and more mobile or geographically separated, the need to exchange data is
increasingly important. We can offer you timely service through remote desktop
support.

 

We
at Integrated Solutions understand no two companies are alike and that’s why we
will custom design and implement a solution that works specifically for your
needs. Whether you’re a small, medium or large user environment we will assess
your situation and needs and propose and provide state of the art technology
and solutions for your LAN or WAN.

 

Network Security

Security
is one of the most important aspects of any network. You could have one of the
most solid and sophisticated networks in the world, but without a secure
network protecting your businesses critical data it would be considered stone-age
by today’s standards.

 

Malicious
viruses and computer hackers are becoming more and more of a threat every day.
Without awareness, policies, software, hardware and updated technologies to
combat these threats you are leaving yourself and your business accessible and
vulnerable to an endless possibility of nightmares. A network without security
is like storing all your money under your pillow instead of the bank.

 

Integrated
Solutions will work with you to create an intelligent infrastructure by integrating
your existing assets with new technologies to give you state of the art
security solutions for a strong and reliable infrastructure.

 

 

2.10
MANAGEMENT HIERARCHY OF INTEGRATED SOLUTIONS LTD.




THE KEY TASKS
AND OUTPUTS OF THE HR FIRM

As per the agreement, the key tasks and outputs of
Rapport Bangladesh Limited (HR firm) related to Database creation would be as
under:

 

 

 

Key Task

Output

2

2.2

Creation of Database: (All)

Create
a position wise database (Phase-1 & Phase-2) of all applications
received. 

 

Different
sets of reports have been generated based on pre-selected candidates,
including gender and demographic issues.

 

 

2.3

Rejection List

Create
a position wise database (Phase-1 & Phase-2) of all applications which
are not short listed and indicate clearly the reasons for their rejection.

 

List
of position wise rejected candidates mainly for three different reasons:

i.       
Lack of
relevant experience

ii.      Lack of education &

iii.    Age barrier

 

2.6

Invitation for Round-1 Test:

A)
All candidates fulfilling the eligibility criteria must be short listed to
appear for round- 1 selection
tests (Phase-1 & Phase-2).

B)
Inviting short listed candidates to appear for selection process, by sending
admit cards / call letters / contracting them through cell numbers
etc(Phase-1 & Phase-2)

 

a.
Preparation of computerized Admit Cards for candidates for different
examination centers.

b.
Preparation of sitting arrangements for different examination centers and

c.
List of candidates for invigilators and OMR result preparation.

6

 

Repeat the process for
future vacancies, during the period of contract.

We
expect to further furnish the reporting requirements based on SDF’s criteria
in future.

 

USE OF ICT FOR HR SCREENING AND RECRUITMENT

Rapport
Bangladesh Limited is proud for their expertise in using the state of the art
Information and Communication Technology (ICT) tools used in human resource
screening and recruitment procedures. The processes to be followed for SDF
would not be exception to that as well. Our ICT tools and expertise would be
utilized at every step of the HR screening and recruitment processes. The steps
are as follows:

1.      Pre screened of about 8,000 applicant’s CV by expert
professionals.

2.      Advertisement for Recruitment

3.      Collection of CVs from candidates

4.      Develop a Database for Candidates

5.      Use a custom built software to be used for selection
and recruitment of          candidates.

A  Use of ICT for Database Design and
Software development:

ICT
professionals at Rapport Bangladesh Ltd have used the standard software
development methodologies for development of the candidates’ database and
custom built software for recruitment processes. Software Development Life
Cycle plays a critical role in the development of a new system and RAPPORT has
incorporated standard procedures to keep track of the project.

B  Requirement Elicitation:

The
first life cycle activity is the requirement elicitation that has helped the
stakeholders to determine what information and information processing services
are needed to select the best candidates for the service and functions of the
SDF. During this process, the requirements gathering team attempted to discover
important information about how different responsibilities are performed at SDF
at the current scenario and how SDF would need to perform their job in order to
meet future demand.

C  System Analysis:

Analysis
phase immediately followed the requirement elicitation phase and started with
the software requirement specification generated from the requirement
elicitation phase by RAPPORT. The next process followed were the requirements
structuring and strategies for the subsequent system design. 

D  System Design:

System
Design phase used the outcome of the requirements elicitation and analysis
phase of the IT team. This phase elaborated system design methodology in
relation to system analysis.

Object-Oriented
Analysis and Design (OOAD) and Rapid Application Development (RAD) are the
popular system design methodologies. Both of them draw on principles
fundamental to all systems analysis and design approaches. OOAD truly blends
analysis with design through the evolution of techniques but RAD is more of a
general strategy of developing information systems.

E  Software Development:

Software
Development phases will be coordinated with the requirements elicitation and
structuring process. This phase will transform the requirements into meaningful
abstraction through the data structure, algorithm and coding of the business
processes.

F  Testing and
Deployment:

Testing and Deployment phase finalized the SDLC life
cycle and the target solution was taken for the test run. This phase was
carried out on functional test of different application modules and processes
based on functional specification.

G  Potential problems and technical approach adopted to address
them:

Nature of Problem

Level of Importance

Technical Approach Adopted

Data
Management (Incompatibility and Reporting)

High

Will
have expert IT professionals to ensure the best data management system to
store the data and share with the end user.

Multiple
applications by single candidate

Medium

SDF
Will select the position which best suits his/her qualifications.

 

Technology used

The
whole system could be divided in two different parts. In one part, system
design team members have arranged the interfaces and other necessary designs
and in another part developers have stored all the details of candidates in the
databases. In doing so, the following technologies were used:

Interfaces:     

·        
php

·        
Ajax

·        
Java Script

Database:       

·        
MySql 

The
database and system development team have intentionally used open source
technology to avoid any license fee to be paid by SDF in future.

 

Basic Analysis of potential Candidates from Database

 

Analysis: In the database total number of candidates was 8,604.
Among them 4,845 were primarily pre-selected for MCQ test in four different
centers in Bogra and Barisal.

 

Please
find the comparison between number of posts, total number of candidates and pre
selected candidates in the following graph:

 

 

 

 

Sl No.

Position Name

Post Number

Total Candidate

Pre-Selected Candidate

     Cluster
Team Leader 

 128

1,575
 

940

     Cluster
Facilitators ( 1 for 5 villages) 

 1,068

3,224

2,052

     IT
Support Cum Data Entry Operator 

 13

135
 

59

     Data
Entry Operator 

 128

283
 

184

     Cluster
Facilitators, Booking Keeping 

 256

323
 

214

     Cluster
Facilitator Accounts & Administration 

 128

254
 

174

     Cluster
Facilitator ‘Technical’ 

 128

366
 

232

     District
Accountant 

 13

257
 

205

     District
Program Manager 

 13

453
 

253

10 

     District
Program Officer Technical 

 13

77
 

45

11 

     District
Program Officer Environment, Climate Change, Risk Reduction (ECCRR) 

 13

218
 

27

12 

     District
Program Officer, Institution & Capacity Building 

 13

258
 

42

13 

     District
Program Officer, Livelihoods & Agribusiness  

 13

294
 

83

14 

     District
Program Officer , Youth & Employment 

 13

283
 

103

15 

     District
Program Officer, Governance & Accountability 

 13

200
 

59

16 

     District
Program Officer, Community Finance 

 13

104
 

62

17 

     District
Program Officer, Finance & Administration 

 13

167
 

75

18 

     District
Program Officer, ME & L and MIS 

 13

133

36

Total

1,992

8,604

 4,845

 

 

Analysis:  It was found
that the highest percentage of pre selected candidates were from District
Accountant post. Here around 79.77% candidates were pre selected. Where as only
12.39% candidates were pre-selected for District Program Officer (ECCRR) post.
The number of selected candidates was only 27 where the unsuccessful candidates
were 191.

 

Please
find the comparison between pre selected and unsuccessful candidates in the
following graph:

 

 

 

Sl No.

Position Name

Pre-Selected Candidate

Pre-Selected Candidate(%)

Unsuccess Candidate

Unsuccess Candidate(%)

     Cluster
Team Leader 

940

 
59.68

 
635

 
40.32

     Cluster
Facilitators ( 1 for 5 villages) 

2,052

 
63.65

 
1,172

 
36.35

     IT
Support Cum Data Entry Operator 

59

 
43.70

 
76

 
56.30

     Data
Entry Operator 

184

 
65.02

 
99

 
34.98

     Cluster
Facilitators, Booking Keeping 

214

 
66.25

 
109

 
33.75

     Cluster
Facilitator Accounts & Administration 

174

 
68.50

 
80

 
31.50

     Cluster
Facilitator ‘Technical’ 

232

 
63.39

 
134

 
36.61

     District
Accountant 

205

 
79.77

 
52

 
20.23

     District
Program Manager 

253

 
55.85

 
200

 
44.15

10 

     District
Program Officer Technical 

45

 
58.44

 
32

 
41.56

11 

     District
Program Officer Environment, Climate Change, Risk Reduction (ECCRR) 

27

 
12.39

 
191

 
87.61

12 

     District
Program Officer, Institution & Capacity Building 

42

 
16.28

 
216

 
83.72

13 

     District
Program Officer, Livelihoods & Agribusiness  

83

 
28.23

 
211

 
71.77

14 

     District
Program Officer , Youth & Employment 

103

 
36.40

 
180

 
63.60

15 

     District
Program Officer, Governance & Accountability 

59

 
29.50

 
141

 
70.50

16 

     District
Program Officer, Community Finance 

62

 
59.62

 
42

 
40.38

17 

     District
Program Officer, Finance & Administration 

75

 
44.91

 
92

 
55.09

18 

     District
Program Officer, ME & L and MIS 

36

 
27.07

 
97

 
72.93

Total

 4,845

 
56.31

3,759

 
43.69

 

Analysis:  It was found
that the highest number of pre selected candidates were for Cluster
Facilitators (1 for 5 villages) post. The total number of pre selected
candidates for this post were 2,052 where as for District Program Officer
(ECCRR) post the number of pre selected candidates were only 27.

 

Please find the pie chart of the pre selected
candidates for the respective positions:

(due to large number of partitions it was not possible
do show the labels in the graph. But you may view it from the table below)

 

 

 

Sl No.

Position Name

Total Candidate

Pre-Selected Candidate

Pre-Selected Candidate(%)

     Cluster
Team Leader 

1,575
 

940

 
59.68

     Cluster
Facilitators ( 1 for 5 villages) 

3,224

2,052

 
63.65

     IT
Support Cum Data Entry Operator 

135
 

59

 
43.70

     Data
Entry Operator 

283
 

184

 
65.02

     Cluster
Facilitators, Booking Keeping 

323
 

214

 
66.25

     Cluster
Facilitator Accounts & Administration 

254
 

174

 
68.50

     Cluster
Facilitator ‘Technical’ 

366
 

232

 
63.39

     District
Accountant 

257
 

205

 
79.77

     District
Program Manager 

453
 

253

 
55.85

10 

     District
Program Officer Technical 

77
 

45

 
58.44

11 

     District
Program Officer Environment, Climate Change, Risk Reduction (ECCRR) 

218
 

27

 
12.39

12 

     District
Program Officer, Institution & Capacity Building 

258
 

42

 
16.28

13 

     District
Program Officer, Livelihoods & Agribusiness  

294
 

83

 
28.23

14 

     District
Program Officer , Youth & Employment 

283
 

103

 
36.40

15 

     District
Program Officer, Governance & Accountability 

200
 

59

 
29.50

16 

     District
Program Officer, Community Finance 

104
 

62

 
59.62

17 

     District
Program Officer, Finance & Administration 

167
 

75

 
44.91

18 

     District
Program Officer, ME & L and MIS 

133
 

36

 
27.07

Total

8,604

 4,845

 
56.31

 

XI        List of reports that may be generated from Candidate Information
Management System

1)     
Position wise summary of all candidates

 

Sl No.

Position Name

 

Total Candidate

 

 

2)      Position and selection status wise candidates summary with percentage 

 

Sl No.

Position Name

Post Number

Total Candidate

Pre-Selected Candidate

Pre-Selected Candidate
(%)

Unsuccessful Candidate

Unsuccessful Candidate
(%)

 

 

3)      Position wise pre screened candidates gender
distribution
summary with
percentage

 

Sl No.

Position Name

Total Candidate

Male Candidate

Male Candidate(%)

Female Candidate

Female Candidate(%)

 

 

4)     
Position and applying district wise candidates summary

 

Sl No.

Position Name

Total Candidate

Applied Districts

 

 

 

 

 

5)     
Home district wise candidates summary

 

Applied District Name:

 

 Position Name

No. of Pre-Selected
Candidate

No. of Rejected
Candidate

 

 

6)     
Position wise all candidates list

 

Position
Name:

 

District Applied

Candidate Name

District From

 

 

7)     
Position wise all pre selected candidates list

 

Position Name:

 

Preferred District

Candidate Sl No.

Candidate Name

Home District

 

 

 

8)     
Position
wise all rejected candidates list

 

Position Name:

 

District Applied

Candidate Sl No.

Candidate Name

District From

Cause of Rejection

 

 

9)     
All SDF candidates list

 

Preferred District

Candidate Sl No.

Candidate Name

Home District

Position Name

 

 

10)  Position
wise all pre selected candidates mailing address list

 

Position Name:

 

Candidate Sl No.

Candidate Name

Mobile No.

Mailing Address

 

 

11) 
Position wise pre-selected candidate details

 

Position Name:

 

District Applied

Candidate Sl No

Candidate Name

Sex

Mobile Number

Mailing Address

Highest Qualification

Work Experience

 

 

12) 
Position wise candidates preferred district and home
district list

 

Position Name:

 

District Applied

Candidate Sl No

Candidate Name

Home District

 

 

13) 
Position wise candidates highest qualifications

 

Position Name:

 

Candidate Sl No

Candidate Name

Highest Qualification

 

 

 

 

 

 

Degree
Level:

Result/CGPA:

GPA:

Group/Depart:

Institute:

Passing Year:

 

14)  Position
and district wise female candidates list

 

Position Name:

Applied
District:

 

District Applied

Candidate Sl No

Candidate Name

Age

 

15) 
Position and applying district wise candidates highest
qualification list

 

Position Name:

 

Applied District

Candidate Sl No

Candidate Name

Highest Education

Result

Year of Passing

 

 

16) 
Position and applying district wise candidates with
work experience list under certain parameter

 

Position Name:

Applied
District:

Minimum Work
Experience:

  

District

Candidate Sl No

Candidate Name

Total Relevant
Experience

Total Work Experience

 

 

17) 
Applying district wise candidates list

Applied
District Name:

 

Candidate Sl No

Candidate Name

Mobile Number

Mailing Address

 

 

18) 
Applying district wise candidates summary

 

Applied District Name:

 

Position Name

No. of Pre-Selected
Candidate

No. of Rejected
Candidate

 

 

19) 
Home district wise candidates list

District Name:

 

Candidate Sl No

Candidate Name

Mobile Number

Mailing Address

Permanent Address

 

 

20)  Position
and home
district wise candidates list

 

Position Name:

District From:

 

District Applied

Candidate Name

Candidate Sl No

Mobile Number

Mailing Address

Highest Qualification

Work Experience

 

 

21)  Position, applying district and selection
status wise candidate summary

 

 

22)   Individual
candidate’s profile using unique candidate number including photo

 

 

23)  Position and
district wise pre screened individual candidate’s Admit Card with photo

 

 

24)  Position and
district wise pre screened individual candidate’s mailing address

 

 

Candidate’s
sitting arrangement

Analysis of Result

Analysis: The number of pre selected candidates who have
attended the examination were 1,873 which is about 39% of the total pre
selected candidates. Among them highest number of candidates were for Cluster
Facilitator (1 for 5 Villages) post. The lowest percentage of turn out was for
District Program Officer (ME &L and MIS) post with only 25% attendance.

 

Sl
No.

Positions

No.
of Vacancy

Application
Received

Pre
selected Candidates

Appeared
for MCQ

Cluster
Team Leader 

128 

1575
 

939
 

381
 

Cluster
Facilitators ( 1 for 5 villages) 

1,068 

3,224
 

2,049
 

864
 

IT
Support Cum Data Entry Operator 

13 

135
 

59
 

11
 

Data
Entry Operator 

128 

283
 

184
 

64
 

Cluster
Facilitators, Booking Keeping 

256 

323
 

213
 

73
 

Cluster
Facilitator Accounts & Administration 

128 

254
 

174
 

48
 

Cluster
Facilitator ‘Technical’ 

128 

366
 

232
 

88
 

District
Accountant 

13 

257
 

204
 

59
 

District
Program Manager 

13 

453
 

252
 

92
 

10 

District
Program Officer Technical 

13 

77
 

45
 

11
 

11 

District
Program Officer Environment, Climate Change, Risk Reduction (ECCRR) 

13 

218
 

27
 

8
 

12 

District
Program Officer, Institution & Capacity Building 

13 

258
 

42
 

17
 

13 

District
Program Officer, Livelihoods & Agribusiness  

13 

294
 

83
 

38
 

14 

District
Program Officer , Youth & Employment 

13 

283
 

103
 

37
 

15 

District
Program Officer, Governance & Accountability 

13 

200
 

59
 

23
 

16 

District
Program Officer, Community Finance 

13 

104
 

62
 

24
 

17 

District
Program Officer, Finance & Administration 

13 

167
 

75
 

26
 

18 

District
Program Officer, ME & L and MIS 

13 

133
 

36
 

9
 

Total

1,992 

8,604 

4,838 

1,873 

 

Total
Application Received:    8,604 

Pre selected Candidates:          4,838   (56.22 %)

Appeared
for MCQ:                 1,873   (38.71%)

 

Analysis: For Cluster Level posts, maximum number of candidates
has scored between 71 to 80. If we accept the pass mark to be above 50, then
around 88% candidates would pass the MCQ test. But if we consider above 40 as
the pass mark then around 95% candidates would pass. The total number of
candidates appeared in the examination were 1529.

 

Cluster
Level

Score
Range

Sl
No.

Applied
Position

0-10

20-Nov

21-30

31-40

41-50

51-60

61-70

71-80

81-90

91-100

Total

 Cluster
Team Leader

3
 

2
 

1
 

6
 

 
12

 
31

 
98

 
151

 
73

 
4

 
381

 Cluster
Facilitators ( 1 for 5 villages)

5
 

4
 

10
 

32
 

 
82

 
189

 
251

 
234

 
54

 
3

 
864

 IT
Support Cum Data Entry Operator

0
 

0
 

0
 

1
 

 
1

 
1

 
4

 
4

 
0

 
0

 
11

 Data
Entry Operator

1
 

1
 

0
 

4
 

 
6

 
15

 
12

 
11

 
14

 
0

 
64

 Cluster
Facilitators, Booking Keeping

0
 

0
 

0
 

1
 

 
4

 
10

 
17

 
25

 
16

 
0

 
73

 Cluster
Facilitator Accounts & Administration

0
 

0
 

0
 

3
 

 
0

 
2

 
15

 
23

 
4

 
1

 
48

 Cluster
Facilitator ‘Technical’

0
 

0
 

0
 

0
 

 
5

 
7

 
23

 
42

 
11

 
0

 
88

Total

9

7

11

47

110

255

420

490

172

8

1529

Percentage

0.59%

0.46%

0.72%

3.07%

7.19%

16.68%

27.47%

32.05%

11.25%

0.52%

100.00%

 

 

Analysis: For District Level posts, maximum number of
candidates have scored between 61 to 70. If we accept the pass mark to be above
50, then around 75% candidates would pass the MCQ test. But if we consider
above 40 as the pass mark then around 93% candidates would pass. The total
number of candidates appeared in the examination were 344.

 

 

District
Level

Score
Range

 

Applied
Position

00-10

11-20

21-30

31-40

41-50

51-60

61-70

71-80

81-90

91-100

Total

 District
Accountant

0
 

0
 

2
 

7
 

 
16

 
19

 
12

 
2

 
1

 
0

 
59

 District
Program Manager

1
 

0
 

3
 

4
 

 
16

 
27

 
27

 
12

 
1

 
1

 
92

 District
Program Officer Technical

1
 

0
 

0
 

1
 

 
2

 
4

 
3

 
0

 
0

 
0

 
11

 District
Program Officer (ECCRR)

0
 

0
 

0
 

0
 

 
1

 
3

 
3

 
1

 
0

 
0

 
8

 District
Program Officer, Institution & Capacity Building

0
 

0
 

0
 

1
 

 
5

 
2

 
9

 
0

 
0

 
0

 
17

 District
Program Officer, Livelihoods & Agribusiness

0
 

0
 

0
 

1
 

 
2

 
9

 
16

 
10

 
0

 
0

 
38

 District
Program Officer , Youth & Employment

1
 

0
 

0
 

2
 

 
3

 
15

 
9

 
5

 
2

 
0

 
37

 District
Program Officer, Governance & Accountability

0
 

0
 

0
 

1
 

 
4

 
9

 
6

 
3

 
0

 
0

 
23

 District
Program Officer, Community Finance

0
 

0
 

1
 

0
 

 
3

 
10

 
9

 
1

 
0

 
0

 
24

10 

 District
Program Officer, Finance & Administration

0
 

0
 

0
 

0
 

 
7

 
7

 
7

 
5

 
0

 
0

 
26

11 

 District
Program Officer, ME & L and MIS

0
 

0
 

0
 

0
 

 
1

 
4

 
3

 
0

 
1

 
0

 
9

Total

3

0

6

17

60

109

104

39

5

1

344

Percentage

0.87%

0.00%

1.74%

4.94%

17.44%

31.69%

30.23%

11.34%

1.45%

0.29%

100.00%

 

Analysis: Four sets of questions were used during the
examination. It was expected that candidates from Cluster Team Leader to
Cluster Facilitator ‘Technical’ would answer using C and D set. Where as
candidates from District Accountant to District program Officer (ME & L and
MIS) were expected to answer using A and B set.  Please find the actual number of candidates
who have used the different sets of questions.

 

 

Sl No.

Positions

Number of Candidate appeared MCQ
test in Various Set of Questions

A

B

C

D

Total

Cluster Team Leader 

7  

5  

190  

176  

378

Cluster Facilitators ( 1 for 5
villages) 

4  

6  

398  

451  

859

IT Support Cum Data Entry
Operator 

2  

0  

2  

7  

11

Data Entry Operator 

3  

4  

32  

24  

63

Cluster Facilitators, Booking
Keeping 

0  

0  

37  

36  

73

Cluster Facilitator Accounts &
Administration 

1  

1  

19  

27  

48

Cluster Facilitator ‘Technical’ 

0  

0  

33  

55  

88

District Accountant 

20  

37  

0  

2  

59

District Program Manager 

42  

46  

1  

2  

91

10 

District Program Officer
Technical 

8  

2  

0  

0  

10

11 

District Program Officer Environment,
Climate Change, Risk Reduction (ECCRR) 

4  

4  

0  

0  

8

12 

District Program Officer, Institution
& Capacity Building 

5  

12  

0  

0  

17

13 

District Program Officer, Livelihoods
& Agribusiness  

14  

23  

0  

1  

38

14 

District Program Officer , Youth
& Employment 

17  

16  

2  

1  

36

15 

District Program Officer, Governance
& Accountability 

11  

12  

0  

0  

23

16 

District Program Officer, Community
Finance 

13  

11  

0  

0  

24

17 

District Program Officer, Finance
& Administration 

14  

10  

1  

1  

26

18 

District Program Officer, ME & L
and MIS 

3  

5  

1  

0  

9

Total

168 

194 

716 

783 

1,861 

 

 

Analysis: Four sets of questions were used during the
examination. It was expected that candidates from Cluster Team Leader to
Cluster Facilitator ‘Technical’ positions would answer using C and D set. Where
as candidates from District Accountant to District program Officer (ME & L
and MIS) positions were expected to answer using set A and B.  Unfortunately, 33 candidates from Cluster
Level positions have used set A and B, where as 12 candidates from District
level positions have used set C and D. 
The mismatch happened, since the candidates thought that they were pre
selected for vise versa positions.

 

Sl No.

Cluster Level Positions

Number of Candidate appeared MCQ
test in Various Set of Questions

A

B

Cluster Team Leader 

7  

5  

Cluster Facilitators ( 1 for 5
villages) 

4  

6  

IT Support Cum Data Entry
Operator 

2  

0  

Data Entry Operator 

3  

4  

Cluster Facilitators, Booking
Keeping 

0  

0  

Cluster Facilitator Accounts &
Administration 

1  

1  

Cluster Facilitator ‘Technical’ 

0  

0  

Total

17

16

 

Sl No.

District Level Positions

Number of Candidate appeared MCQ test
in Various Set of Questions

C

D

District Accountant 

0  

2  

District Program Manager 

1  

2  

10 

District Program Officer
Technical 

0  

0  

11 

District Program Officer Environment,
Climate Change, Risk Reduction (ECCRR) 

0  

0  

12 

District Program Officer, Institution
& Capacity Building 

0  

0  

13 

District Program Officer, Livelihoods
& Agribusiness  

0  

1  

14 

District Program Officer , Youth
& Employment 

2  

1  

15 

District Program Officer, Governance
& Accountability 

0  

0  

16 

District Program Officer, Community
Finance 

0  

0  

17 

District Program Officer, Finance
& Administration 

1  

1  

18 

District Program Officer, ME & L
and MIS 

1  

0  

Total

 

Findings

After completing my
internship on Integrated Solutions Limited we see some limitations here. We
want to give some suggestions to remove these problems. We suggest the company
to take some initiatives. Like-

·        
The website is
one of the main issues and contains good impression to the viewers. The current
website of ISL is not attractive and dynamic. So they (ISL) should have to
improve this.

·        
There is scarcity
of manpower in ISL. So they need more manpower.

·        
Setting
proper planning for each and every work as well as for the whole department.
Managerial supervision is also wanted to increase.

·        
Updated
technology should be needed for ISL

·        
It needs to
concentrate more on quality of products

·        
Customer services
should be increases from six month to one year.

·        
Proper
maintenance of files and necessary files and documents on daily basis.

·        
Should increase
their Marketing strategies and activities

·        
Provide and
facilitate the training opportunities to their loyal employees

 

At the very end of the ‘internship program’ working
three months, it can be expected that these above suggestions will help to
rearranging some infrastructures, which will support the  customers and clients based service and
maintenance  of  Integrated Solutions Limited.

Conclusions

The
internship is a key element in the technical writing student’s professional
preparation. And the internship report is a key element in the internship
experience. It is through writing the report that the maturity and professional
experience the student gained as an intern becomes fully realized. It is
through the report that the student exercises his or her critical and
analytical faculties and demonstrates newly found skill and identity as a
professional communicator.

 

 

Appendix-1:

 

Tables used in
the database schema

Table
Name: Educational Info

Field

Type

Attributes

Null

Default

Extra

Action

candidateSrl

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

examName

varchar(200)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

candidateResult

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

totalMarks

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

groupDepart

varchar(100)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

instituite

varchar(200)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

passingYear

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

highestDegree

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

 

 

Table
Name: Work Experience

 

Field

Type

Attributes

Null

Default

Extra

Action

cvNo

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

comName

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

joinDate

date

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

endDate

date

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

Expyears

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

responsibility

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

salary

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

relevatExp

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

sdfStatus

varchar(20)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext



Table
Name: Position

Field

Type

Attributes

Null

Default

Extra

Action

positionNumber

int(11)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

positionName

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

positionGroup

varchar(5)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

positionPrefix

varchar(100)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

postNumber

int(11)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

minEduQualification

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

MinWorkExp

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

relevantExp

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

 

 

 

 Table Name: Relevant Fields

Field

Type

Attributes

Null

Default

Extra

Action

positionNo

int(11)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

relFields

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext



Table
Name: Resume

 

Field

Type

Attributes

Null

Default

Extra

Action

applyDistrict

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

sl

int(11)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

applyPost

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

candidateName

varchar(100)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

candidateFathName

varchar(100)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

candidateMonthName

varchar(100)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

BirthDay

varchar(20)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

BirthMon

varchar(20)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

BirthYear

varchar(20)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

nationality

varchar(25)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

nationalId

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

sex

varchar(50)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

image

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

training

text

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

computerLiteracy

varchar(10)

 

No

 

 

Browse

Change

Drop

Primary

Index

Unique

Fulltext

motorcycleDrive

varchar(10)

 

No

 

 

Browse

Change

Drop