AN INTERNSHIP REPORT

ON
ROBOTIC PROCESS AUTOMATION
AT
B.O.K. CAPITAL MARKET LTD.
Naxal, Kathmandu

Submitted by:
Ravin Ghimire
T.U. Registration No: 7-2-39-1638-2017
Exam Roll no: 8407/17
Shanker Dev Campus

An Internship Report Submitted to

Faculty of Management, Tribhuvan University
in partial fulfillment of the requirements for the degree of

Bachelor of Information Management

Shanker Dev Campus

Tribhuvan University

Putalisadak, Kathmandu
July 2022
APPROVAL PAGE

ii
To Whom It May Concern

iii
 ACKNOWLEDGEMENT

An internship report entitles “AN INTERNSHIP REPORT ON ROBOTIC

PROCESS AUTOMATION” has been prepared in the partial fulfilment of the
requirement for the degree of Bachelor of Information Management 8th semester. The
successful completion of this internship report would be incomplete without expressing
heartfelt thanks to people who constantly guided, supported and encouraged me
throughout my intern period.

I would like to express my sincere gratitude towards Mr. Jiwan Kumar Poudel who
took confidence in me and provided me with the opportunity to work as an intern at
B.O.K. Capital Market Ltd. I had wonderful and unforgettable experience being part of
such a lively team. I would also like to convey my heartiest thanks to him who in spite
of being extraordinarily busy with his duties, took time out to hear, guide and keep me
on the correct path throughout the intern period.

I am also grateful to express my sincere gratitude for supervisor of this internship

program Mr. Narayan GC for his guidance, support and valuable suggestions and
coordination until internship program was complete. His suggestions and guidance in
every stage is one of the major reasons of the successful completion of my internship.
I express my sincere gratitude to him for believing in me and giving us the chance to
complete this internship and helping me in the time of uncertainty. It was indeed a great
learning experience.

Finally, I would like to express my sincere thanks to all my friends and colleagues who
helped me directly or in directly during this project.

..................................
Ravin Ghimire
BIM Eighth Semester
Exam Roll No: 8407/17
Shanker Dev Campus
Putalisadak, Kathmandu

iv
 STUDENT DECLARATION

I hereby declare that the presented report of internship titled “An Internship Report
on Robotic Process Automation” at B.O.K. Capital Market Ltd. submitted to Shanker
Dev Campus, Faculty of Management, Tribhuvan University is my original work
prepared after the completion of two-months’ work at B.O.K. Capital Market Limited
done for the partial fulfillment of the requirements of Bachelors of Information
Management (BIM) under the supervision of Mr. Narayan GC.

I also confirm that the report is only prepared for my academic requirement. Any part
of this report and the report as a whole has not been submitted for academic awards of
any other academic institutions.

...................................
Ravin Ghimire
Exam Roll No: 8407/17
TU Reg. No: 7-2-39-1638-2017
BIM, 8th Semester
Shanker Dev Campus
Putalisadak, Kathmandu

v
 TABLE OF CONTENTS

Title page i
Supervisor Approval ii
Recommendation Letter iii
Acknowledgements iv
Student Declaration v
List of Figures viii
List of Tables ix
Abbreviations x
CHAPTER ONE: INTRODUCTION (1 - 4)
1.1 Background of the study.........................................................................1
1.2 Objective of the study.............................................................................2
1.2.1 General Objectives.....................................................................2
1.2.2 Specific Objectives....................................................................2
1.3 Methodology..........................................................................................2
1.3.1 Organization Selection................................................................3
1.3.2 Placement....................................................................................3
1.3.3 Duration......................................................................................4
1.3.4 Activities Done...........................................................................4
CHAPTER TWO: INTRODUCTION TO IT INDUSTRY (5 - 8)
2.1 Brief Introduction to IT Industry..........................................................5
2.2 Brief Introduction of IT Industry in Nepal...........................................5
2.3 Present Scenario...................................................................................6
2.4 Challenges and Opportunities..............................................................7
2.4.1 Challenges.................................................................................7
2.4.2 Opportunities.............................................................................7
2.5 Scope of Information Technology........................................................8
CHAPTER THREE: INTRODUCTION TO ORGANIZATION (9 - 12)
3.1 Introduction of Organization................................................................9
3.2 Philosophy (mission, vision and objectives)........................................9

vi
 3.3 Services provided by organization......................................................10
3.4 Organizational Structure.....................................................................11
3.5 Contact Details....................................................................................12
CHAPTER FOUR: ANALYSIS OF ACTIVITIES (13 - 24)
4.1 Analysis of action performed..............................................................13
4.2 Introduction to Robotic Process Automation......................................13
4.3 Tools used...........................................................................................14
4.3.1 Microsoft Power Automate........................................................14
4.3.2 Robin Script Based Language....................................................14
4.4 Automation Flows...............................................................................14
4.4.1 Data Scraping.............................................................................15
4.4.2 Meroshare Registration.........................................................16-17
4.4.3 Approve Meroshare....................................................................18
4.4.4 Webcds Automation.............................................................19-20
4.4.5 Bulk SMS to clients...................................................................21
4.4.6 Meroshare Result Check............................................................22
4.5 Other Tasks.........................................................................................23
4.6 Experience and Observed Gap............................................................24
CHAPTER FIVE: CONCULSION AND LESSON LEARNT (25)
5.1 Conclusion...........................................................................................25
5.2 Lesson Learnt.......................................................................................25
BIBLIOGRAPHY
APPENDICES

vii
 LIST OF FIGURES

Fig 3.4: Organizational Structure of BOKCML............................................................11

Fig 4.4.1.a: Automation flow of data scraping..............................................................15
Fig 4.4.1.b: Automation flow of data scraping..............................................................15
Fig 4.4.1.c: Automation flow of data scraping..............................................................16
Fig 4.4.2.a: MeroShare Registration Flow....................................................................17
Fig 4.4.2.b: MeroShare Registration Flow....................................................................17
Fig 4.4.2.c: MeroShare Registration Flow....................................................................17
Fig 4.4.2.d: MeroShare Registration Flow....................................................................17
Fig 4.4.3.a: MeroShare Approval Flow.........................................................................18
Fig 4.4.3.b: MeroShare Approval Flow........................................................................19
Fig 4.4.4.a: Webcds Flow.............................................................................................20
Fig 4.4.4.b: Webcds Flow.............................................................................................20
Fig 4.4.4.c: Webcds Flow.............................................................................................20
Fig 4.4.4.d: Webcds Flow.............................................................................................21
Fig 4.4.5.a: Bulk SMS Flow..........................................................................................21
Fig 4.4.5.b: Bulk SMS Flow.........................................................................................22
Fig 4.4.6.a: MeroShare Result Check Flow...................................................................22
Fig 4.4.6.b: MeroShare Result Check Flow..................................................................23

viii
 LIST OF TABLES

Table 1.1 Internship Details............................................................................................4

Table 3.1 Contact Details of Organization...................................................................12

ix
 ABBREVIATIONS

API Application Programming Interface

BIM Bachelor of Information Management
BO Beneficiary Owner
BOK Bank of Kathmandu
BOKCML Bank of Kathmandu Capital Market Limited
CV Curriculum Vitae
HR Human Resource
ISP Internet Service Provider
IPO Initial Public Offerring
IT Information Technology
NCC National Computer Center
NEPSE Nepal Stock Exchange
NIC National Informatics Center
NTA Nepal Telecommunication Authority
PC Personal Computer
RPA Robotic Process Automation
RTA Registrat and Transfet Agents
RTS Regulatory Technical Standard
TU Tribhuvan University
UI User Interface

x
 CHAPTER ONE: INTRODUCTION

1.1 Background of study

An internship is a kind of a temporary position for a student or some trainee who wants
to gain work experience and is working with or without payment while studying at the
same time. The internship program is designed to provide students engaged in a field
experience with an opportunity to share their insights, to explore the links between
students’ academic preparation and their field work, and to assist participants in
developing and carrying out the major research project which will serve to culminate
their internship experience.

This internship report is conducted as the requirement of Bachelor of Information

Management an undergraduate academic degree program at Tribhuvan University, for
the fulfillment of the 3-credit hour internship. Tribhuvan University requires each
student to undergo right weeks internship in an organization to gain real world, practical
knowledge which benefits the students like us to flourish. The prime objectives of the
internship are to be familiar with the organizations culture and day to day operation that
occur in the organization and observe so that the theoretical knowledge we learnt in the
college could be utilize practically. The document contains information about the
organization and the responsibilities performed throughout the internship period. More
than a plan account of tasks, objectives of this text is to reflect upon the experience
collected during the internship from the perspective of a BIM student. An internship
can be an excellent way to try out a certain way to try out a certain career.

An internship is a period of work experience offered by an employer to give students

and graduates exposure to the working environment, often within a specific industry,
which relates to their filed of study. Internship gives a valuable experience which shows
reactiveness and dedication for better career prospects. An internship is a period of
work experience offered by an organization for a limited period. Internship are used to
determine if the intern still has an interest in that field after the real-life experience. An
internship can be used to create a professional network that can assist with letters of
recommendation or lead to future employment opportunities. From the student
perspective, an internship assists with career development by providing real work
experiences that provide students to develop professional skills and competencies.

1
1.2 Objective of study

The main purpose of internship program is to make a graduating student familiar with
the working condition and scenarios of real working environment. It is a remarkable
chance to experience the real-world working environment and culture where the
knowledge learned during the BIM course can be implemented practically. The basic
objective of the internship is to apply classroom theory that we have learned related to
the real-world scenario. As a part of learning, internship helps students to find their
strength and weakness and also gives room for improvement.

1.2.1 General Objectives

• To make a graduating student familiar with the working condition and scenarios
of real working environment.
• To help students to find their strength and weakness and also gives room for
improvement.
• To develop skills in the application of theory to real world work situation.
• To learn how an organization actually operates.
• Build the better resume as more experience and accomplishments make students
more attractive.

1.2.2 Specific Objectives

• To find the use of IT in today’s capital market system.
• To gain the practical knowledge of what we have studied.
• Identify the impact of IT in capital market system.
• To make automation flow for easy and fast computing.
• To develop the personal relationship with IT professional personalities.

1.3 Methodology of the study

Methodology refers to the detailed explanation of the processes involved in

performance of an activity or the particular subject matter. This section talks about
different methods that were followed during the preparation of this internship report.
As I interned at BOKCML, I had to go through different phases to make this internship
report such as selection of organization, placement, study approach and different action
performed.

2
1.3.1 Organization Selection

For every young pre-graduating student, Internship plays vital role in their career and
on the same pace the selection of the organization in which their interest lies is one of
the vital tools to conquer the conquest of leading to the path of eligible career. During
the organization selection process, I get to know that there are various IT companies
established and located in different part of Nepal. Selecting a proper organization will
help us to work with the interest and learning strength.

In order to approach, the requirement were recommendation letter from college and
CV. So, I send my CV to different organization. With a number of the application to
the different organizations, I was called by BOKCML where Mr. Jiwan Kumar Poudel
took short interview and gave brief information about the work of intern in the
organization. I was selected for the intern. The intern was assigned for 2 months and
gave the training for the working procedure.

During the internship period, the project was supervised and mentored by Mr. Jiwan
Kumar Poudel (IT Head of BOKCML). The staff members were very cooperative and
provided the necessary help and support.

1.3.2 Placement

I was selected at BOKCML with an interview and submission of CV. The duration of
internship was 2 months from the month of Falgun under the supervision of Mr. Jiwan
Kumar Poudel. I was hired as an intern in IT department. During the internship, I was
provided as work space sharing with the supervisor and other employees and treated as
homely and friendly environment. I accessed the detail information of the organization,
organizational resources, information and equipment, rules and regulations. I did my
work as per the trainer instructions and discussed about any problems occurred. There
were discussion and meetings as per the trainer requested.

3
1.3.3 Duration

The internship period is as according to BIM syllabus that is 8 weeks. I joined my

internship in BOKCML to pursue my carrier.

The detail duration of internship at BOKCML are presented below:

Table 1.1: Internship Details

Department IT Department
Supervisor Jiwan Kumar Poudel
Start Date Falgun 16, 2078
End Date Baishak 16, 2079
Office Hours 10:30 AM – 5:30 PM
Working Days Sunday-Friday (6 days a week)
Total Duration 2 months
Position Intern

1.3.4 Activities Done

By doing the internship at BOKCML the main goal was to understand the operation of
the organization and learn the different knowledge which is useful in real world in IT
sector. During internship I get the opportunity to learn about automation and its use also
the benefits of it on the supervision of Mr. Jiwan Kumar Poudel as I worked as an intern
and helped in problem solving and as a support to the department. I performed my intern
on RPA using tool like Microsoft Power Automate. The task that I did as an intern in
IT department are listed below:

• Analysis of flow of repetitive task performed in organization.

• Creation of automation using Microsoft Power Automate.
• Handling technical calls.
• Solving arising problems of IT in organization.
• Handling of servers backing up them in interval of time.
• Implement security and safety of data and information.
• Social media content creation and upload after approval.

4
 CHAPTER TWO: INTRODUCTION TO IT INDUSTRY

2.1 Brief Introduction to IT Industry

Over the past decade, the IT industry has become one of the fastest growing industries,
more than any other industry or economic facet, has an increased productivity,
particularly in the developed world, and therefore is a key driver of global economic
growth. IT is computer-based hardware and software systems and communication
systems to enable the acquisition, representation, storage, transmission, and use of
information. Successful implementation of IT is dependent upon being able to cope
with the overall architecture of systems, their interfaces with humans and organizations,
and their relationships with external environments.

The IT industry is now one of the fastest growing industry sectors in the world. The IT
industry is known both for large risks and for the possibility of large returns on
investment. IT industry is the collection of firms providing the different products and
services digitally. IT workers can specialize in fields like software development,
application management, hardware or desktop support, server or storage administrator
and network architectures etc. Common type if IT careers is: Chief Information, Chief
Technology Officer, IT director, System Administrator, Application Manager and
Developer etc. Software development is becoming a most powerful field in IT because
of the more popularity of handheld devices and emergence of E-Commerce, E-Banking,
E-Share Market.

2.2 Brief Introduction of IT Industry in Nepal

The installation and operation of Main Frame IBM-1401 computer in 1971 in the NCC
at Kathmandu in 1971 for the National population census, saw the advent of Electronic
Data Processing Technology in Nepal, NCC was established with the purpose of giving
computer related services to government bodies, developing computer manpower and
enhancing computer consciousness. Later on, NCC used ICL-2950/10 Main Frame
Computer, a DG Mini-computer, a Prime Mini-Computer. Now there is an IT ministry
itself in the government level and NIC under the ministry, instead of NCC to advise
and formulate National level IT polices and plans. Telephone Service exchanges was

5
established by NTC in 1960 in Kathmandu valley. Since 1960 to 2004, the state-owned
NTC, also now known as Nepal Telecom. The credit for introducing internet among
the people mainly goes to the private sector. Although the internet was initially limited
only to email services in 1955 a company Mercantile Communications finally started
the internet services in the country. In 1998, NTA a telecommunications regulatory
body was formed as per Telecommunications Act 1997. It holds power to issue license
to the ISPs in Nepal.

2.3 Present Scenario

Meanwhile, the number of internet users has increased by considerable amount. While
it was just about 0.2% of the total population in the year 2000 who had access to
internet, it has increased to about 2.2% by the year 2010 (Source: ITU). The
advancement in technology due to advent of smartphones and tablet PCs has helped to
increase the public awareness and raise their interest towards technology to a great
extent. And it can be felt in the latest statistics of internet users in the country (for the
year 2012). The number, according to NTA has increased to more than 4 million now
(which also includes the number of people accessing internet via GPRS and CDMA).

Today’s society is relying much on the use of technology and this has indeed created
the demand of experts in the field on IT. IT professionals perform a variety of functions
such as IT Disciplines and competencies that ranges from installing applications to
designing complex computer networks and information databases. As a developing
country Nepal has availed of the opportunity to rapidly develop various sectors such as
education, health, agriculture, tourism, trade, among others, using IT. Also for the
development of country IT can play vital role. So, good policies on software
development are to be maintained by the government and also involvement and
investment on this field has to be increased. Currently there are many IT companies
established during past decades, but due to lack of effective regulation body from
government and the political instability of the country most of the company are on the
stage of collapse. Also, there are some IT companies that become success to establish
their own renowned name in the Nepal IT market. Some of the well-known IT
companies of Nepal are:

• F1 Soft International Pvt. Ltd.

6
 • Deerwalk services Pvt. Ltd.
• Logpoints Nepal.
• Digital Network Solutions.
• AusNep IT Solutions.
• Crypto Gen.
• Mercantile Communication Pvt. Ltd.
• Leapforg Technology Inc. etc.

2.4 Challenges and Opportunities

There are so many challenges and opportunity that organizations have been facing since
long. Some opportunity and challenges that have seen till today are explained below:

2.4.1 Challenges

Nepalese IT industry has many challenges to exist in the market though it also has the
higher market growth rate in context of Nepal. We all know that it’s a crucial part for
the development of Nation some hindrances make it quite tough too. There are also
certain challenges of IT industry in Nepal. These are included as below:

• Allocation of budget for IT is not sufficient.

• Unfair market competition in product and services.
• No effective cyber law.
• Unstable government so cannot work to uplift the standard of IT.

2.4.2 Opportunities

Although, there are so many challenges in Nepalese IT field, it has many opportunities
too. Nepal is in the developing phase where there are various opportunities available.
Now this is a very useful way to communicate with the global market of IT. It makes
everything faster in the context of developing country like Nepal. Some opportunities
of IT in Nepal are:

• Low development costs.

• Establishment of international software company.
• Change in mind of people towards software.
• Increasing trends of using software in organization.

7
2.5 Scope of IT

Career in IT is considered one of the most high-paying jobs and is full of opportunities.
As a name of an undergraduate degree program, it refers to the preparation of students
to meet the computer technology needs of business, government, healthcare, schools
and other kinds of organizations. Information technology helps in production and
manipulation of sensitive information, cultural development and communication,
streamlining of business process and timely upgrading. The following are the list of
common careers for IT graduates.

• IT Consultant
• Cloud Analyst
• Computer Forensic Investigator
• System Administrator
• Network Engineer
• Web Developer
• Web Designer
• Database Developer
• Quality Assurance Officer
• RPA Developer

8
 CHAPTER THREE: INTRODUCTION TO ORGANIZATION

3.1 Introduction of Organization

B.O.K. Capital Market Limited, in short BOKCML, is a subsidiary company of Bank

of Kathmandu (BOK) Limited, which is established under the company act 2063 on
19th of Chaitra and licensed from Securities Board of Nepal on 19th of Mangsir 2073. It
is the financial services vertical of BOK (The Holding Company). Formerly known as
Kathmandu Capital, the company was acquired by BOK on 13th Mangsir, 2074 as it’s
subsidiary. BOK which holds 66.66% of the company has more than 90 branches
around the country and has a paid-up capital of 8 billion Nepalese Rupees. The present
name B.O.K. Capital Market Limited was formally adopted on 13th Mangsir, 2074
BOKCML has an increasing presence in the capital market via various services as
Depository Participant, Portfolio Management Services and Advisory Services.

3.2 Philosophy (mission, vision and objectives)

Vision: “To be best providers of financial services and products delivering a diverse
range of established as well as innovative and pioneering products.”

Mission: “The company aims to invest in and build a portfolio of sustainable

investments, to build shareholder value. They also strive to carry forward our social,
economic and environmental responsibilities, as they remain committed to integrity and
fairness in all their dealing with their stakeholders.”

Objectives:

BOKCML has the following objectives:

• To manage their business honestly and ethically. They always do what is right
and take personal responsibility for their actions. As a financial institution, they
strive to be honest and disciplined in all that they do.
• To help their clients make the best and most informed investment choices.
• To exceed their clients’ expectations and care deeply about the results of their
efforts.

9
 • By providing a certain degree of autonomy and responsibility for decision-
making regarding the staff’s specific organizational tasks.

3.3 Services provided by organizations

• Depository Participant Services:

o Dematerialization and Re-materialization of securities.
o Maintain the record of securities in electronic form.
o Settlements trades by transferring/receiving the securities from/to
Beneficiary Owner
o Settlement of off-market trades that occurred between Bos outside
NEPSE.
o Provide electronic credit of securities allotted by issuers during IPOs.
o Deposit to the non-financial corporate benefits such as a bonus, right
shares etc. issued by issuers in the DeMat account of BO.
• RTA/RTS Services:
o Custody of undelivered certificates and dividend warrants.
o Maintenance and verification of specimen signatures of shareholders.
o Registration of transfer and transmission of shares.
o Payment of dividends and bonus share issuance
o Providing company information for future ownership
o Share ownership information management system.
• Portfolio Management Services.
• Issue Management for IPO, FPO, Rights Issue and other securities issue
initiatives of the institution including debt instruments.
• Advisory Services like valuation, investment/wealth managements of securities.

10
3.4 Organizational Structure

An organizational structure is a system that outlines how certain activities are directed
in order to achieve the goals of an organization. These activities can include rules, roles
and responsibilities.

The organizational structure also determines how information flows between levels
within the company. For example, in a centralized structure, decisions flow from the
top down, while in a decentralized structure, decision-making power is distributed
among various levels of the organization having an organizational structure in place
allows companies to remain efficient and focused.

Fig 3.4: Organizational Structure of BOKCML

11
3.5 Contact Details

Table 3.1 Contact Details of Organization

Organization B.O.K. Capital Market Limited

Address Narayanchaur- Naxal, Kathmandu

Website [Link]

Email info@[Link]

Phone Number 01-4513496,01-4513096

12
 CHAPTER FOUR: ANALYSIS OF ACTIVITIES

4.1 Analysis of action performed

During eight weeks internship at BOKCML, I worked in IT department and spend all
the time of internship period in this department. IT department is an innovative and
seeking for new innovations. So, the objective was to make repetitive tasks easier and
faster. Thus, we landed on RPA automation flow through use of different tools and
techniques. We are living in 21st century, by which to compete and remain in the
competitive environment new trends and tools are to be integrated. This is also
applicable in the world of software system. The current market is fast growing market,
day to day repetitive task can be made easier with the development of automation by
which the efficiency of workers or employees will increase.

BOKCML is still using employees for doing repetitive daily task manually. By which
the efficiency of employees and organization is getting lack. Due to employee finding
difficult to perform daily routine task, especially in this era of technology. To expand
my knowledge and gain real time work experience me and my IT department head
decided to make RPA automation by which software robots will performs the repetitive
daily routine task.

4.2 Introduction to Robotic Process Automation

Robotic process automation, also known as software robotics, uses automation

technologies to mimic back-office tasks of human workers, such as extracting data,
filing in forms, moving files, data scraping etc. It combines APIs and UI interactions to
integrate and perform repetitive tasks between enterprise and productivity applications.
By deploying scripts which emulate human processes, RPA tools complete autonomous
execution of various activities and transactions across unrelated software systems. This
form of automation uses rule-based software to perform business process activities at a
high-volume, freeing up human resources to prioritize more complex tasks. RPA
enables decision makers to accelerate their digital transformation efforts and generate
a higher return on investment from their staff.

13
4.3 Tools Used

For the creation of automation flow we decided to use Microsoft Power Automate as
development environment and the language used by this is Robin Script Based
Language.

4.3.1 Microsoft Power Automate

Microsoft Power Automate is a tool that allows to build and execute flows, which can
automate and streamline any repetitive tasks. It has the ability to connect to wide variety
of applications can also contain complex logic like conditions or loops. It is also
frequently used to develop RPA within businesses. Almost any repetitive task can be
replaced by Microsoft Power Automate. This is intelligent cloud-based solution uses
triggers and actions to create chain reactions within a workflow so that repetitive,
manual and time-consuming tasks are accomplished without human intervention

4.3.2 Robin Script Based Language

Robin script-based language is a programming language designed specifically for

building RPA software bots. While there are several proprietary tools to build RPA
scripts, with Robin you have a free programming language designed to build your own
automation, or software bots. It was developed with three things at its core: simplicity,
ease of use and extendibility. Robin is really easy to learn. Its syntax is pretty straight
forward. Everything happens through modules and actions.

4.4 Automation Flow

Automation flow is an approach to make the flow of tasks across repetitive work-related
activities perform by software bots. Simple or complex processes can be triggered at
regular times of day by the use of automation. By the use of Microsoft Power Automate
and Robin Script Based Language different automation flows was created to solve
repetitive tasks to be performed in the organization. The following are some RPA
automation done during my internship periods:

14
4.4.1 Data Scraping

Data scraping, also known as web scraping is the process of importing information from
a website into a spreadsheet or local file saved on the PC. Likewise, we had a task to
scrap the information of meroshare clients of BOKCML from MeroShare website and
dumping in excel sheet. Which was almost 27,000 of datas. The information of account
renewal or not by the clients of BOKCML in MeroShare has to be collected. As, fiscal
year was coming near to keep the updates and inform the clients.

Fig 4.4.1.a: Automation flow for data scraping

Fig 4.4.1.b: Automation flow for data scraping

15
 Fig 4.4.1.c: Automation flow for data scraping

4.4.2 Meroshare Registration

Meroshare registration is also a repetitive task in BOKCML, from more than 90
branches of BOK the daily request for meroshare registration will be above 100. To
automate this new flow was made. The details for registration were always written in
spreadsheet and the results of registration are written in excel by the bot itself.

Fig 4.4.2.a: MeroShare Registration Flow

16
Fig 4.4.2.b: MeroShare Registration Flow

Fig 4.4.2.c: MeroShare Registration Flow

17
 Fig 4.4.2.d: MeroShare Registration Flow

4.4.3 Approve MeroShare

After the registration of MeroShare for clients DP Head must approve by checking the
details, daily 100+ accounts must be approved by DP Head so for that also we have
created automation flow.

Fig 4.4.3.a: MeroShare Approval Flow

18
 Fig 4.4.3.b: MeroShare Approval flow

4.4.4 Webcds Automation

One of the daily routine tasks of IT department in BOKCML is to download files from
Webcds and Store it into DP-Secure server. For easiness we have created automation
flow for this too. Where bots download necessary files from Webcds.

Fig 4.4.4.a: Webcds flow

19
Fig 4.4.4.b: Webcds flow

Fig 4.4.4.c: Webcds flow

20
 Fig 4.4.4.d: Webcds flow

4.4.5 Bulk SMS to clients

SMS to clients must be sent after the registration of MeroShare account let to know
about the registration of MeroShare and DeMat account. So, for that we have created
automation flow.

Fig 4.4.5.a: Bulk SMS flow

21
 Fig 4.4.5.b: Bulk SMS flow

4.4.6 MeroShare Result Check

For Portfolio Management System department clients, they have to keep update about
checking the result of IPOs as they have numbers of clients to make it easier, we have
also made flow for this.

Fig 4.4.6.a: MeroShare result check flow

22
 Fig 4.4.6.b: MeroShare result check flow

4.5 Other Tasks

During my internship not only creation of automation flow but also different tasks were
done in daily basis. Some of them are listed below:

• Creation of Email Accounts.

• Website Content Upload after approval.
• Social Media Content Creation and Upload after approval.
• Solve Network related problems with constant communication with CDSC,
BOK, ISPs.
• Monitor inflow and outflow of network traffic.
• Implement security and safety of data and information.
• Keep up-to date about the new threats.
• Take backup from servers.
• Handling technical calls.
• Doing different happening tasks that arises.
• Preparation of portfolio tracker using excel sheet.
• Handling servers and creating users if necessary.

23
4.6 Experience and Observed Gap

Studying sitting inside the class room and working in an organization with real-world
problem is far different. All the knowledge we gain from the theoretical books and from
teachers is not sufficient and applicable to the real words. Somehow knowledge is with
us and some we have to gather from the organization. The internship program is the
best on the job method for the implementation of theoretical knowledge to the practical
knowledge. In real IT world practical knowledge plays an important role than a
theoretical knowledge. Study is far easy than applying it to the real-world works. Not
only about the degrees but also its about skills generation new idea formations.

24
 CHAPTER FIVE: CONCLUSION AND LESSON LEARNT

5.1 Conclusion

The eight weeks of internship in BOKCML was really worthwhile and had a memorable
experience. In review this internship has been an excellent and rewarding experience.
One main thing that I have learned through this internship is time management skills as
well as self-motivation. The exposure forms the internship was truly precious for me
who contributed a lot to expand my knowledge on merchant banking, familiarized me
with the working environment, organizational norms and culture, organizational
structure that enhanced my interpersonal skills, professional skills, time management
and developed some sort of confidence in me. After doing internship, I have been able
to acquire practical skills like analyzing and collecting requirements, documentation,
research, innovate and learning new thing that makes easier life. There is a saying in IT
don’t work hard work smart. By this motive I was eager to learn RPA not only learning
but also applicable for the real world. In other part of my life or coming future this
learning will definitely make me easy for doing my tasks anywhere anytime.

5.2 Lesson Learnt

Working two months at BOKCML is one of the great experiences, which will be very
helpful in the future. I had learnt how the different positions in organization works.
How the organization handles all the process of problems in smooth and unique way.
Some of the core findings during the internship period are:

• Coping with real world and practical environment.

• Time management was the most learnt thing by me.
• How to co-operate with colleague to solve the arising problems.
• Learnt how RPA is very useful in merchant banking and other repetitive task.
• Not only learning but also using it in real world problem was the most
happening.
• Increase in experience and confidence to deal with the real problem

25
 BIBLIOGRAPHY

Tech Sansar (2010). History of Computer & Information Technologies (IT) in Nepal.

Pradhan, J. (2002). Information technology in Nepal: what role for the government?
The Electronic Journal of Information Systems in Developing Countries, 8(1), 1-13.

Microsoft, (n.d.). Microsoft Power Automate | RPA Tutorial, From Microsoft:

[Link]

IBM, (n.d.). Robotic Process Automation | RPA Tutorial, From IBM:

[Link]

Microsoft, (n.d.). Power Automate User | Power User Community, From Microsoft:
[Link]
p/MPACommunity
 APPENDICES

Some of the outputs and screenshot of power automate as well as portfolio tracker

Screenshot 1: Dashboard of Microsoft Power Automate.

Screenshot 2: Output of Data Scraping.

 Screenshot 3: Output of MeroShare registration.

Screenshot 4: Portfolio Tracker using Excel Sheet.