VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION THESIS BUILDING AN INFORMATION MANAGEMENT SYSTEM FOR PREPARING BIDDING DOCUMENTS AND EVALUATING BIDS AT THANH DUNG NEW TECHNOLOGY CONSULTING AND CONSTRUCTION CO., LTD TA THI DIEM MY Hanoi - Year 2024 VIETNAM NATIONAL UNIVERSITY, HANOI INTERNATIONAL SCHOOL GRADUATION THESIS BUILDING AN INFORMATION MANAGEMENT SYSTEM FOR PREPARING BIDDING DOCUMENTS AND EVALUATING BIDS AT THANH DUNG NEW TECHNOLOGY CONSULTING AND CONSTRUCTION CO., LTD SUPERVISOR: MS. HOÀNG TRỌNG TIẾN STUDENT: TA THI DIEM MY STUDENT ID: 20070757 COHORT: INFORMATION SYSTEMS SUBJECT CODE: INS401101 MAJOR: MANAGEMENT INFORMATION SYSTEM Hanoi - Year 2024 ACKNOWLEDGEMENT For the completion of this graduation thesis, I first want to send my special thanks to my supervisor, Mr. Hoang Trong Tien. Throughout the process of doing my thesis, Mr.
Tien has been fully supported with great professionalism. He has scheduled his time instructing me on the problems that I have and guiding me to face the problem. He also devotes his time to finding useful insight to support me in improving my performance. From the very first process of finding a suitable idea, he has been very supportive and professional.
Under his weekly supervision, I have been able to balance my time between my thesis and other subjects. Especially, he has been providing valuable and useful knowledge suitable to my research. During my project, I have been facing many difficulties but he has been supportive and calm. I want to express my deepest gratitude to Mrs.
Dang Thi Than and the staff from Thanh Dung New Technology Consulting And Construction Co., Ltd for giving me the opportunity to have practical experiences and knowledge about the company's business during my internship. I would also sincerely appreciate the guide of every lecture from International School – Vietnam National University, Hanoi for giving me the useful knowledge that allows me to complete my thesis. Sincerely, Ta Thi Diem My 1 PROMISE I hereby declare that this is my graduation thesis which is the outcome of my own, under the guidance of Mr. Hoang Trong Tien as my graduation thesis supervisor.
The data and research results are honest and consulted from Thanh Dung New Technology Consulting And Construction Co. To ensure confidentiality and comply with the company information privacy policy, I have altered and concealed the sensitive information. I would like to take full responsibility before the department, faculty, and school for this commitment. Hanoi, 2024 Ta Thi Diem My 2 LIST OF FIGURES Figure 1.
2 Company annual financial status from 2019 to 2021. 4 Business model canvas. 5 Bidding document preparation process. 1 Project Status Dashboard.
2 Project customer dashboard. 3 Adding data page. 4 Adding data form. 5 Region display selector.
7 Share component- Data load definition. 8 Preview CSV before upload. 11 Master search to display all of the related information to the project. 12 Sub-table in master search.
13 Calendar on project start and end date. 16 Comments without a picture. 17 Comments with a picture. 18 Comments from the account being used.
21 Application process to get the file link. 22 Page process to receive the file link. 46 3 LIST OF TABLES TABLE 1. COMPANY GENERAL INFORMATION.
20 4 TABLE OF CONTENT ABSTRACT 7 INTRODUCTION 8 1. LITERATURE REVIEW 9 CHAPTER 1. GENERAL INFORMATION OF THANH DUNG NEW TECHNOLOGY CONSULTING AND CONSTRUCTION CO. COMPANY VISION, MISION, AND CORE VALUE 12 VISION 12 MISSION 12 CORE VALUE 13 1.
BUSINESS MODEL CANVAS 14 1. BUSINESS PROCESS 15 CHAPTER 2. ENTITY RELATIONSHIP DIAGRAM 20 2. AUTO-INCREASE SEQUENCES 24 2.
DOWNLOAD, DELETE AND UPDATE INFORMATION 25 2. READING DATA AND SEARCH DATA 25 2. PREVIEW THE FILE 25 2. READ THE FILE AND SAVE DATA TO THE CLOB COLUMN 28 3.
IMPLEMENT THE FUNCTION ON THE NEW FILE 28 3. BREAKING DOWN ON OPTICAL CHARACTER RECOGNITION 29 5 3. OPTICAL CHARACTER RECOGNITION ALTERNATIVE 29 3. IMPLEMENT OPTICAL CHARACTER RECOGNITION IN APEX 30 CHAPTER 4.
BUILDING THE MANAGEMENT SYSTEM 31 4. ADDING NEW DATA BY FORM 32 4. ADDING NEW DATA BY CSV FILE 34 4. SYSTEM EVALUATION AND RECOMMENDATION 47 5.
RECOMMENDATION 47 CONCLUSION 48 REFERENCES 49 APPENDIX A 53 APPENDIX B 60 APPENDIX C 62 6 ABSTRACT With the development of information technology, almost every business and organization has been storing documents on a computer and managing the document by using basic methods such as saving the file to different folders. However, for many organizations that must adjust the document frequently such as Thanh Dung New Technology Consulting And Construction Co., Ltd in their business of preparing bidding documents and evaluating bids with the different employees working on the same project, there might be many inconvenient in updating, sharing and storing the document. Making use of the knowledge received from the university and my experience during the internship, this graduation thesis aims to provide insight into a managing system that supports the document managing process in the business of preparing bidding documents and evaluating bids. Based on the use of one of the most popular enterprise low-code application platforms, Oracle APEX in building the managing system, the report includes 5 main chapters.
The first chapter is the introduction to Thanh Dung New Technology Consulting And Construction Co. The second chapter is the basic requirement of the system. The third chapter performs the specification of the system, the fourth chapter is the details process of building the system and the last chapter is the summarized evaluation of the system with some of my recommendations on the possibility of further improving the system. 7 INTRODUCTION The rapid growth of technology in recent years is displayed with the application of IT in almost every business and field.
As a result, organizations are capable of storing enormous amounts of data and files. However, this benefit also comes with an inconvenience since the stored data could be duplicated or hard to find. Especially for those businesses that have to frequently work with files, update, and share them among the staff. Thanh Dung New Technology Consulting And Construction Co., Ltd is one of the companies in that group.
For a smaller amount of data, it is very easy to control the file locations and the member adjustment to each file. On a larger scale, when the company works with multiple projects, one employee plays different roles in different projects. There are many cases when a file has already been updated and saved has been relocated. One can only be found after contacting many staff, which reduces the efficiency.
Noticing this problem, this study was created to solve the problem by creating a system to manage the file within the process of preparing bidding documents and evaluating bids so that company members can locate the file quickly the system even works as a backup to save the file in case it being removed by mistake. Motivation In the construction field, the bidding process is one of the most significant stages. Construction companies aim to increase their business volume by winning bids on different projects which means they must submit reasonable bid proposals. A construction company's ability to grow its business volume depends on its ability to successfully win bids while making sure that the winning bid offers the highest profit.
This encourages the construction company to work with experts like Thanh Dung New Technology Consulting And Construction Co. to find the best joining option. (5) Due to the complexity of E-bidding, Thanh Dung New Technology Consulting And Construction Co., Ltd has to work with multiple files, and managing them can be challenging. It is essential to thoroughly review the contracting documents in order to make a bidding proposal.
Elaborate and comprehensive paperwork (up to hundreds of pages) promotes a seamless building process, thereby fulfilling project objectives and averting possible disagreements (21). 8 Oracle APEX function allows users to create, develop, and implement database-driven applications with just a web browser which combines the benefits of low code, productivity, user-friendliness, and flexibility, with enterprise development features, like security, integrity, scalability, and availability. (9, 38) This makes the application suitable for making a file-managing system. Literature review Bidding is the process of selecting contractors to sign and implement contracts to provide consulting services, non-consulting services, goods procurement, and construction based on ensuring competition, fairness, transparency, and economic efficiency.
The legal basis that ensures openness, transparency, and economic efficiency in bidding activities in Vietnam is based on the Bidding Law. (1) Deciding and regulating contractor selection is very important, especially in cases where to appoint contractors and assign competent people for the bidding package that has specific and separate elements. A significant amount of time and work must be put into the bidding process. By increasing the bidding process's effectiveness, speed, and accuracy, e-technology might reduce these demands.
(5) When calculating a bid price for a building project, construction companies consider the features, profitability, competitiveness, and risk aspects of the project. The project owner's bidding document contains the most representative information that the bidders will find during the bidding process. The owner's project planning objective and the general construction criteria are included in the bidding document. Specifically, the information in the bidding document—which is also closely tied to the contractual issue—determines the project's level of uncertainty.
However, the bid proposed must be realistic and accurate, following the general standard. (21) Document information extraction with Optical Character Recognition is being used more and more to improve and automate business processes. Organizations use Optical Character Recognition to handle text that is handwritten or printed. It helps identify different sorts of documents and analyze data based on intricate criteria.
It is possible to 9 adapt the Optical Character Recognition model, procedure, and method to any handwritten style. However, numerous Optical Character Recognition tools have been trained on a variety of handwriting styles and can be used in the file management system. (25) The bidding process involves many uncertainties that need to be predicted and reflected. In this stage, service providers like Thanh Dung New Technology Consulting and Construction Co., Ltd must thoroughly understand the construction risk factors that make the requirement category to correctly evaluate the contractor quality and prepare suitable bidding documents.
The winning chance can be decreased if the information in the bidding document is imprecise and confusing. GENERAL INFORMATION OF THANH DUNG NEW TECHNOLOGY CONSULTING AND CONSTRUCTION CO. Company outline Thanh Dung New Technology Consulting And Construction Co., Ltd is a limited liability company that operates under the Enterprise Law passed by the 11th National Assembly of the Socialist Republic of Vietnam on August 8, 2005. Company general information THANH DUNG NEW TECHNOLOGY CONSULTING AND CONSTRUCTION CO., LTD Company name -Vietnamese name: Công ty TNHH Tư vấn và Xây dựng Công nghệ mới Thành Dũng -Short name: Thanh Dung Start date of operation June 08th, 2012 Tax code 0105911916 Tax authorities Thanh Xuan District Tax Department Representative Đặng Thị Thân Office address Le Van Luong, Nhan Chinh, Thanh Xuan, Hanoi Main job Consulting service related to construction Telephone 02432222136 Email dichvuthanhdung@gmail.
1 Company logo Thanh Dung New Technology Consulting And Construction Co., Ltd's business focuses on 7 main services including consultancy in planning, surveying, designing, inspecting, supervising, consulting on preparing bidding documents, and construction field. Thanh Dung New Technology Consulting And Construction Co., Ltd's Financial figures 14,000,000,000 12,000,000,000 10,000,000,000 8,000,000,000 6,000,000,000 4,000,000,000 2,000,000,000 - Total Total Short-term Total Revenue Profit Profit after assets liabilities assets short-term before tax tax liabilities 2019 2020 2021 Figure 1. 2 Company annual financial status from 2019 to 2021 1. Company Vision, Mision, and Core Value Vision To become a professional contractor, maintain stability within the organization, and excel in both production technology and the quality of products.