Nguyễn-Thị-Kiều-Trang -17071372 MIS2017 A PDF

Preview

Summary

VIETNAM NATIONAL UNIVERSITY, HANOIINTERNATIONAL SCHOOLPROGRAMGRADUATE INTERNSHIP REPORTINTERNSHIP COMPANY/INSTITUTION: FPT Securities Joint Stock Company Address:52 Lac Long Quan Street, Tay Ho District, Hanoi CityStudent’s name Nguyen Thi Kieu TrangHanoi - Year 2021 ...VIETNAM NATIONAL UNIVERSITY, ...

Description

VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL

PROGRAM

GRADUATE INTERNSHIP REPORT INTERNSHIP COMPANY/INSTITUTION:

FPT Securities Joint Stock Company Address: 52 Lac Long Quan Street, Tay Ho District, Hanoi City

Student’s name Nguyen Thi Kieu Trang

Hanoi - Year 2021...

1

VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL

PROGRAM

GRADUATE INTERNSHIP REPORT INTERNSHIP COMPANY/INSTITUTION: FPT Securities Joint Stock Company Address: 52 Lac Long Quan Street, Tay Ho District, Hanoi City

SUPERVISOR: Dr.Tran Thi Oanh STUDENT: Nguyen Thi Kieu Trang STUDENT ID: 17071372 CLASS: MIS2017A

Hanoi - Year ..2021.

2

ACKNOWLEDGEMENTS Through an 6-week internship as planned by the International School - Hanoi National University (from March 22, 2021 to May 4, 2021) at FPT Securities Company (Hanoi) I have been learning and improving the necessary skills, applying basic knowledge to the work of information technology staff. Although the internship and working time are not long, I am confident that what I learned from this practical environment will be the first step for me to have more suitable orientations for my future career. To complete " Graduate Internship Report " I would like to express my sincere thanks to the teachers of the International School. In particular, Ms. Tran Thi Oanh, thank her for all her enthusiasm and dedication in supporting relevant knowledge, her own practical experience to help me and other students complete right target practice. Furthermore, I would also like to acknowledge with much appreciation, Manager – Ms. Nguyen Thi Viet Ha who gave the permission to use relevant and necessary documents, as well as access to facilities of company to complete my internship. I could not have accomplished this report without support of Miss Ha. That is a lucky for me. In addition to, I would like to express sincere gratitude to my advisor – Tran Thi Thuy as well as the guider for her patience, motivation, immense knowledge during complete thesis. Her guidance helped me in all the time of researching and writing of this report. The countless time she spent me as well as beside and support me during all of time. Although, I myself have tried hard to complete this "Graduation Internship", but surely there will be unexpected shortcomings. Therefore, I would like to receive comments from teachers and all the member of the Information Technology Department so that I can learn from my own experience and have the best basis to prepare to develop the " Graduate Internship Report " in the near future. Thanks for everyone sincerely! Student, Nguyen Thi Kieu Trang.

3

GUARANTEE I hereby certify that this is my graduate internship report in the past time. The information and the results of the internship are honest, completely performed at the Information Technology Department of FPT Securities Company, without copying any other sources. In addition, in the report using a number of references, the source and notes are clearly stated. I take full responsibility to the subject, faculty and the school for this commitment. Student, Nguyen Thi Kieu Trang.

4

LIST OF ABBREVIATION FPTS

FPT Securities Joint Stock Company

FIT

Information Technology Department

List of Firgures Figure 1. FPT Logo ......................................................................................................................................... 8 Figure 2 Model of Organizational structure............................................................................................... 10 Figure 3 Chapter 3 a .................................................................................................................................... 19 Figure 4 Chapter 3 b.................................................................................................................................... 20 Figure 5 Chapter 3 c .................................................................................................................................... 20 Figure 6 Chapter 6 b.................................................................................................................................... 22 Figure 7 ASP.NET result .............................................................................................................................. 24 Figure 8 ASP.NET result ............................................................................................................................... 24 Figure 9 ASP.NET result .............................................................................................................................. 24 Figure 10 ASP.NET result ............................................................................................................................. 25 Figure 11 ASP.NET result ............................................................................................................................ 25 Figure 12 ASP.NET result ............................................................................................................................ 25 Figure 13 ASP.NET result ............................................................................................................................. 25 Figure 14 ASP.NET result ............................................................................................................................ 26 Figure 15 ASP.NET result ............................................................................................................................ 26 Figure 16 ASP.NET result ............................................................................................................................ 26 Figure 17 OPD.NET result ............................................................................................................................ 27 Figure 18 3 Layer Architecture.................................................................................................................... 27 Figure 19 3 layers architecture result ......................................................................................................... 28

5

TABLE OF CONTENTS

ACKNOWLEDGEMENTS .............................................................................................. 3 GUARANTEE .................................................................................................................... 4 LIST OF ABBREVIATION ............................................................................................. 5 List of Firgures ................................................................................................................... 5 Chapter 1. Introduction .................................................................................................... 7 1.1.

Vision ................................................................................................................. 7

1.2.

Mission ............................................................................................................... 7

1.3.

Core Values ....................................................................................................... 7

1.4. Overview of FPT Securities ................................................................................ 8 1.4.3. Model of Organizational structure............................................................... 10 Chapter 2. Business Activities ........................................................................................ 12 2.1. Business performance results ........................................................................... 12 2.2. Evaluate the Company's performance in 2020 ............................................. 12 Chapter 3. Internship Process ........................................................................................ 14 3.1. Tools and Programming language ................................................................... 14 3.2. Practices .............................................................................................................. 18 Chapter 4. Conclusion ..................................................................................................... 29 REFERENCES ................................................................................................................ 31

6

Chapter 1. Introduction 1.1.

Vision FPTS aspires to become a financial institution strong, by efforts to build a contingent of cadres and technological capabilities, delivering products and highest quality service to customers life is full of material, rich in crystals god to all members.

1.2.

Mission To attach importance to investment in improving the qualifications of the team officers and employees, uphold professional ethics, to achieve maximum satisfaction and trust of customers. Constantly investing in research, take advantage of all strengths of technology to create the highest quality products and services, provide customers with a trading system convenient and safe, fast and accurate, fair and transparent. Become the number choice one of businesses, investors in and foreign.

1.3.

Core Values

1.3.1. Human Identifying people as the core strength, FPTS always focuses on building a professional working environment industry, dynamic, bearing the FPT culture. Thanks to our efforts in building human resources, appreciating talents, paying attention to training staff, promoting professional ethics, FPTS currently has nearly 400 cadres and experts with high professional qualifications and experience in working in the whole domestic environment and internationally. 1.3.2. Technology With concentrated investment and maximum exploitation of technological advantages, FPTS has successfully built a public system information technology of international standards. With modern equipment and advanced technology, FPTS's trading system can serve a very large number of transactions Large customers with high speed, anytime, anywhere in the trading floor as well as by phone or internet.

7

The stock trading platforms are selected to meet current and similar requirements hybrids according to international standards, being used widely in countries with very stock markets development such as Australia, UK, Hong Kong, India, Malaysia, Singapore, ... FPTS Web sites are authenticated by a reputable organization in the world with SSL security protocol, ensure safety of data access and data on transmission line. Remote transactions over the Internet, over the phone are secured with a Human Authentication Device Use - Token Card of RSA firm

1.4. Overview of FPT Securities 1.4.1. General Information Company Name: FPT Securities Joint Stock Company Logo:

Figure 1. FPT Logo

Email: [email protected] / Website: www.fpts.com.vn Headquarter Address: 52 Lac Long Quan Street, Tay Ho District, Hanoi City Introduce FPT Securities Joint Stock Company - a member of FPT Corporation - was licensed established and operated under the License of the State Securities Commission issued on 13/7/2007. Over nearly 15 years of establishment and development, FPTS has continuously gained many successes public, gaining customer trust, claiming to be one of the companies leading securities in Vietnam.

1.4.2. Business Field ❖ Securities Trading 8

Securities Trading: Trading in underlying securities Derivative securities trading Secured warrant transactions • Margin Trading • Advance Service • Securities Certification • Investment Advisory ❖ Advisory Enterprise • Investment Banking Service Consulting stock issuance / offering stock Consulting listing, trading registration Divestment consulting, auction Merging and buying advice • Corporate Governance Consulting: EZGSM EZSearch EZLink • Enterprise Complete Consulting HR consulting and solutions EzHRM; Consulting, accounting and financial management France EzFAM; Business Plan Construction Consulting; Financial forecasting consulting

9

1.4.3. Model of Organizational structure General Meeting of Shareholders Administrative Council

Internal Audit

Board of Directors

Risk Management Department

Hanoi Head Office

Da Nang City Branch

Investment Advisory Block

Investment Consulting

System Department

Corporate Finance Advisory Block

Corporate Finance Consulting Department

Ho Chi Minh City Branch

Investment Block

Investment Analysis Department

Function Block

Finance and Accounting Department

Human Resources

Company Office

Customer Service Department

Investment Officer

Transaction Custody and Shareholder Management

IT Department

Figure 2 Model of Organizational structure

10

1.4.4. IT Department IT department is responsible for requirements analysis, feature design, programming in Web application development projects as well as participating in requirements analysis, feature design, database, programming in development projects. .Net and C# product development. In addition, this department is responsible for operating the database system and participating in research and presentation of new technologies. The information technology department is divided into the following sub-sections ❖ Team in charge of Web ❖ Team in charge of Database ❖ Team in charge of Mobile ❖ Team of Developers Currently, I am in the team responsible for Database. The team's job is to do database administration, financial tools and business development

11

Chapter 2. Business Activities 2.1. Business performance results In 2020, total revenue is recorded at VND 445.14 billion, reaching 114.14% of the plan set by the General Meeting of Shareholders. Accounting profit before tax reached 250.25 billion, equivalent to 113.75% of the plan. Including: - Revenue from securities brokerage reached 193.89 billion, with an outstanding growth of about 94% due to the lane Wave of new investors increases into the stock market, especially stocks. - Revenue from securities advisory and depository is relatively stable, not much change

2.2. Evaluate the Company's performance in 2020 Although the Covid 19 epidemic took place around the world, heavily affecting the world economy, the Vietnamese stock market still grew in both scores and liquidity, especially in the last months of 2020. Only the VN Index increased by 14.87% (at the beginning of the year 960.99 at the end of the year 1,103.87), the HNX Index increased by 98.15% (at the beginning of the year 102.51 at the end of 203.12), the average daily transaction value reached 7,434 billion VND, an increase of 61.4% over the same period (4,605 billion VND) In 2020, the company is in the TOP 10 in terms of share brokerage market share, fund certificates and warrants at both the Hanoi Stock Exchange (HNX) and the Ho Chi Minh City Stock Exchange. Ho Chi Minh City (HOSE). In addition, the company is also ranked 7 in the TOP 10 in terms of stock brokerage market share. By 2020, share and securities brokerage market share only funds and warrants at two Stock Exchanges securities HOSE and HNX are 3.76% and 4.31%, respectively.(The brokerage market share in 2019 on HOSE is 2.58% and on the HNX it is 4.18%). In the past year, the company continued to research, perfecting existing technology products development and launch of a number of new products, ensure stable technology system operation effectively serve business activities. 12

Basically, in 2020, the company remains the same scale, structure, organization, personnel and stable in all your activities. Total revenue from business activities and financial activities implemented in 2020 reached VND 445.14 billion, completed 114.14% of the revenue plan in 2020, an increase of 13.23% compared to the implementation in 2019. Total profit The realized pre-tax profit for the whole year 2020 reached VND 250 billion, completing 113.75% of the 2020 profit plan, an increase of 7.06% compared to the implemented in 2019. In 2020, the company has opened 15,821 new underlying securities trading accounts and 7,356 derivative securities accounts for investors. Number of investor accounts opening trading accounts securities at the Company as of 31/12/2020 were 157,849 underlying securities accounts and 9,995 derivative securities accounts. -

Organization and personnel:

Basically keep the structure, scale, organization and personnel. The staff at the beginning of the year was 369 people, at the end of the year 386 people - Technology: - New product: EzAdvisorSelect (selected investment advisor), EzIR service package of Corporate Finance. - Product upgrade: + EzMobileTrading + Price list + EzFuture - Other: - Complete operation of the process system and quality assessment - Completion of the 2019 dividend payment in cash to shareholders at the rate of 5% and in shares at the rate of 10%. Accordingly, the charter capital of FPTS increased by 10% to 1,322,673,490,000 VND. Disclosure of information fully, promptly and transparently.

13

Chapter 3. Internship Process 3.1. Tools and Programming language 3.1.1. Oracle Oracle is one of the largest providers in the technology market today. The name Oracle is the abbreviation of its flagship product, the relational database management system (RDBMS), officially the Oracle Database. Database software is often central to a company's IT business, supporting a variety of tasks including transaction processing, business intelligence (BI), and analytics applications.

3.1.2. Visual Studio -

Introduction: Visual studio is a powerful supporting software to support website programming. This tool is created and owned by the giant Microsoft technology. In 1997, the programming software was codenamed Project Boston. But then, Microsoft combined development tools, packaged into a single product. Visual Studio is a collection of everything related to application development, including code editor, designer, debugger. That is, you can write code, fix errors, edit application design easily with just one Visual Studio software. Not stopping there, users can also design interfaces and experiences in Visual Studio like when

developing Xamarin, UWP applications by XAML or Blend. - Important features of Visual Studio Code: ➢ Multi-platform support If with other programming tools usually only used for one of the following 3 operating systems: Windows, Linux, Mac Systems, on the contrary, Visual Studio allows you to program easily on all three platforms above without meet any obstacles. ➢ Supports many programming languages Also, Visual Studio scores in the eyes of the user thanks to the advantage of supporting multiple programming languages at the same time from C / C ++, C # to F #, Visual Basic, HTML, CSS, JavaScript ... Therefore, it can detect and prompt notification as soon as the program has errors. ➢ Code editor Like every other IDE, Visual Studio also provides a code editor that supports code completion and syntax clarification using IntelliSense.This tool is not only used for 14

functions, variables, and methods, but also applies. for language constructs including query or control loops. In addition, the Visual Studio code editors also support setting bookmarks in code to help users easily navigate through the code block, incremental search ... In particular, Visual Studio also has the function to compile the background code to provide feedback on syntax or compile errors and are marked with red dashes. ➢ Design Windows Forms Designer This design of Visual Studio is used with the goal of building GUI for Wind...