operation and maintenance of apec engineer data bank (1) operation and maintenance of apec engineer...
TRANSCRIPT
![Page 1: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/1.jpg)
Operation and Maintenanceof APEC Engineer Data Bank (1)
Dr. Hsieh, Shang-Hsien (Patrick)Professor of Department of Civil EngineeringNational Taiwan University
![Page 2: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/2.jpg)
Development of Chinese TaipeiAPEC Engineer Management System
Introduction and Experience Sharing
![Page 3: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/3.jpg)
Objectives
• Improve process efficiency by implementing electronic workflow
• Assist applicants in filling out the application forms
• Minimize errors and inconsistency of data• Automate CPD credit-hours calculation• Manage the assessment and registration
data systematically to facilitate operations such as renewal, statistics and audit, etc.
![Page 4: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/4.jpg)
History
• 2006– Plan and design APEC engineer mgmt. system – Implement and test the online application and
assessment sub-system– Construct the web portal
• 2007– Refine the CPD management interface– Digitize historical application data– Start accepting application online
• 2008– Implement renewal function– Add new disciplines
![Page 5: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/5.jpg)
History
• 2009– Migrate systems to the private cloud
• 2010– Upgrade software framework and portal CMS
• 2012– Implement functions to exchange information
between web portal and engineer mgmt. system
• 2013– Add tools for assisting CPD editing– Add tools for managing registration documents
• 2014– Add tools for managing registrant information
![Page 6: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/6.jpg)
Chinese TaipeiAPEC Engineer Management System
System Overview
Online Application System
Web PortalCPD Activities
Register
Assessment System
Registrant Info. Manager
Portal ContentDatabase
Registration Data Manager
EngineerDatabase
Engineers &Guests
Administrator(MonitoringCommittee)
Forms Generator
![Page 7: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/7.jpg)
Web Portal
![Page 8: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/8.jpg)
Account Profile
Input format
validator
Hint
Data will be reused in form 1~6
![Page 9: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/9.jpg)
Form 1: Checklist
Will generate Microsoft Word
documents
Automatic form checker
![Page 10: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/10.jpg)
Form 2: Personal Info.
Add/edit/update education background
![Page 11: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/11.jpg)
Form 3: Engineering Experiences
Add/edit/update work items
Organizations and projects input here will be listed in form 4 and form 5
![Page 12: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/12.jpg)
Form 4: Significant Experiences
Fill details of the selected work item into suggested paragraphs
Refer a work item filled in form 3
previously
![Page 13: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/13.jpg)
Form 5: Elective Experiences
Select three work items in the list and fill out the
details
![Page 14: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/14.jpg)
Form 6: CPD Summary
Show and edit CPD credit-hours in recent five years
![Page 15: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/15.jpg)
Form 6: CPD-hours Editor
This activity list is composed of items entered by other
applicants and “CPD activity register”
User can clone details of an activity on the list or enter
data manually
![Page 16: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/16.jpg)
Form 7: Code of Ethics
Check this box to agree
![Page 17: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/17.jpg)
User log
The system will keep records of the user activity such as updating the data or sign-in/out
Registrants can look up their own logs
![Page 18: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/18.jpg)
Registrant Information Manager
Used by administrators of monitoring committee
Used to look up or update a part of registrants’ personal information
![Page 19: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/19.jpg)
Registration Data Manager
• Used to retrieve scanned application forms, certificates, assessment documents by searching applicant name
![Page 20: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/20.jpg)
CPD Activities Register
Add a conference / workshop / seminar information
Post an announcement on the web portal
Register an item in CPD activity list (form 6 editing page)
Send registrant an email about this activity
![Page 21: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/21.jpg)
Challenges
• How to design friendly user interface for applicants with little computer experience
• How to attest the application forms by electronic signature/approach
• How to gather conference information or training records in bulk automatically to assist user in updating CPD
![Page 22: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/22.jpg)
Operation and Maintenance
• Monitoring committee employee:– Manage or validate data
• 1 part-time system administrator: – Take care of daily hardware and software operation
and information security– Manage web site
• 1 part-time programmer: – Fix bugs, tune the user interface, and enhance
some existing functions
• Other manpower (project-based):– Develop new features– Evaluate framework upgrade plan
![Page 23: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/23.jpg)
APEC Engineer Data BankDesign Considerations
- from viewpoint of data management
![Page 24: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/24.jpg)
Function Requirements• Store professional profiles of All APEC engineers, which may include
– General information– Certificates
• Domestic• International
– Specialties• Categorized specialties as tags/labels• Endorsements
– Engineering experiences• Engineering projects• Field• Position• Time span• Details• Endorsements
– Continuing professional development records– Publications– Patents
![Page 25: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/25.jpg)
Function Requirements (cont.)
• Find and display engineers information according to:– Profile details– Combination of skills– Organization– Engineering projects (experiences)
Findengineer(s)
Search keywords + conditionsin engineer profiles
Drill down from the organization list
Browse the hierarchical specialties category
Drill down from the engineering projects
Result sets
Sort
Filter
Check details
![Page 26: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/26.jpg)
Function Requirements (cont.)
• Update engineer profiles• Update organization information
• Manage engineering project information• Share and lookup job opportunities• Share and lookup procurement information
• Manage advertisement• Manage pay services or functions
• Specialties endorsement mechanism
![Page 27: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/27.jpg)
Roles & Responsibility
– System Administrator• Manage system settings• Manage roles and permissions
– Data Manager (Monitoring Committee)• Import and validate external data• Manage data integrity• Manage advertisement
– Engineer• Manage personal profile
– Organization• Manage organization profile• Update job opportunities• Update procurement information
– Public user
![Page 28: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/28.jpg)
Data Management
![Page 29: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/29.jpg)
Engineer Profiles
Publications
Patents
Developments
Experiences
Specialties
Engineering ProjectsOrganizations Bids
Certificates
Job Opportunities
Data Entities
reference
![Page 30: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/30.jpg)
Engineer Profiles
Publications
Patents
Developments
Experiences
Specialties
Engineering ProjectsOrganizations Bids
Certificates
Job Opportunities
Existing Member’sAPEC EngineersDatabase
Existing ProfessionalEngineer Official Database
import
Engineer Info. Integration
Define protocols for exchanging online or
Define format for exchanging offline
![Page 31: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/31.jpg)
Engineer Profiles
Publications
Patents
Developments
Experiences
Specialties
Engineering ProjectsOrganizations Bids
Certificates
Job Opportunities
Existing E-ProcurementSystemreplicate
Procurement Info. Integration
![Page 32: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/32.jpg)
Engineer Profiles
Publications
Patents
Developments
Experiences
Specialties
Engineering ProjectsOrganizations Bids
Certificates
Job Opportunities
Existing Engineering ConsultantsManagement System
import
Organization Info. Integration
![Page 33: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/33.jpg)
Engineer Profiles
Publications
Patents
Developments
Experiences
Specialties
Engineering ProjectsOrganizations Bids
Certificates
Job Opportunities
APEC Engineer Portal
populate and update (manually)
APEC Engineer Data Bank Portal
![Page 34: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/34.jpg)
Engineer Profiles
Publications
Patents
Developments
Experiences
Specialties
Engineering ProjectsOrganizations Bids
Certificates
Job Opportunities
Social Network Service
endorse
Specialties Endorsement
![Page 35: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/35.jpg)
Operation considerations
• Demand of fetching the registrant information from existing economy’s engineer management system?– None– One-time– Regularly– Continuously
• Need of data curator or validator for each signatory?
• Responsibility of user support?
Require implementing a protocolRequire a standard format May need a standard format
![Page 36: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/36.jpg)
Operating Cost
• Computer Infrastructure– Physical or virtual (cloud-based) platform– Internet service (networking) fee– Software license fee
• Personnel cost– Data manager (local, global)– System administrator– Database administrator– Programmer
May be outsourced
![Page 37: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/37.jpg)
Data Bank Operating ModeCentralized APs & DBs
Integrated APs &Distributed DBs
Portal only
Data residency central local local
Application residency
central central & local local
Software complexity
fair high low
Privacy issue major minor minimum
Development cost fair high low to high*
O&M cost low high high
Security issue fair major minor
Format consistency
high fair low* Depend on how many economies need to
implement a new local data bank
![Page 38: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/38.jpg)
Possible Revenue Sources
• Sponsors:Advertisement space on the web
portal• Chargeable services, such as:– Register job offers– View “detail” profile of an engineer– Search procurement information
Need a billing sub-system
![Page 39: Operation and Maintenance of APEC Engineer Data Bank (1) Operation and Maintenance of APEC Engineer Data Bank (1) Dr. Hsieh, Shang-Hsien (Patrick) Professor](https://reader035.vdocuments.us/reader035/viewer/2022062519/5697bf901a28abf838c8dc7a/html5/thumbnails/39.jpg)
Thanks for your attention