Franklin Mok

Environment: Financials 9.2, HCM 9.2, PeopleTools 8.53 Customization to report on Actual Budget History online with drill down capability. Production Support.

Environment: Financials 9.0, PeopleTools 8.52, Financials/SCM 9.1 Context A project involves transforming data from the claim/insurance system to the corresponding payable fields in PS financials for the automation of Account Payable voucher/payment processes Action  Efficiently handled the transfer of development code across multiple environments  Acted as the representative of the Development Team during release management, which entailed transferring the development code to production database Result  Successfully completed the automation of claim payments from an insurance system to PS Financials

Environment: Financials 9.2, PeopleTools 8.54, Oracle Context Production support and system enhancements Action  Built a credit card application form using Form builder, which will replace the manual application process and will be globally available to all PS users  Built an application to generate reports on daily summary of forms submitted, rejected and approved  Rendered expert backfill production assistance for accounts payable, expenses and purchasing modules  Assumed responsibility in developing the data archival strategy for expenses and payables module  Took charge of determining archival requirements and transaction tables, as well as creating archive objects Result  Implemented a credit card form and resolved production issue with PO cleanup process and batch interface

 Account Payable Enhancements:  Designed and developed the Host to Host banking application to automatically pay vouchers with Citibank in APAC and EMEA countries. The design is global in nature, will be used in Latin America countries. This implementation removes all existing manual payment process with Citibank, avoiding manual mistakes, improve efficiency.  Developed and implemented Procurement to Pay application automating 90% of Accounts Payable voucher preparation  co-developed the automation of PO voucher electronically rececived from vendor to automatically voucher prepared. Most of the manual processing is eliminated.  Designed and developed the automation of Non-PO voucher enabling every requestor in the company to be able to electronically submit non-po voucher for approval (complex approval workflow capability), auditing by Accounts Payable and voucher prepared and paid automatically. This implementation has eliminated most of the manual voucher entry process, centralizing approval process (replacing multiple system plus hardcopy paper manual approval process), voucher preparation becomes on-line and immediate, removing all unnecessary delays in the past procedures.  Designed and developed the H2H banking application to automatically pay vouchers with JPM USA and JPM EMEA. This implementation automates the large payment counts (in hundreds daily) improving efficiency  Developed and implemented the EDI services with Bank of America (US), HSBC (Canada), JP Morgan (Europe) and CitiBank (Asia)  Developed a customized Aged Vendor Liability nVision Reports and Crystal Reports  Implemented Vendor-related audit tables and turned on audit features on Vendor-related tables  Configure Integration Broker:  Create Message and Subscription peoplecode  Expense Module Enhancements:  Developed interface with Citibank Visa receiving ‘my wallet’ data enabling employee to retrieve card transactions electronically

 Manage and allocate defects from SIT and UAT to 4 developers for resolutions  Prepare status reports on a daily basis for management on number of defects and status of each defect/resolution  Analyze and develop resolutions for defects during testing involving SQR programs, App Eng programs, Peoplecodes and nVision reports.

 Developed the Global Management Board Report. It is a complete system extracting data from HR-related tables, storing the data in reporting tables in EPM and providing capabilities to prepare many different kinds of analytical data reporting on HSBC global headcount. The reports are used by the senior executives of HSBC.  Designed and developed the reporting tables, configuration tables (PeopleCode), data extraction programs (App Eng programs), error checking routines (App Eng programs + PS/Queries) and Headcount Statistics Report (SQR).  Managed the migration process from development to various testing environments.  Support functional testing, UAT and regression testing.

 Implemented LDR for Vancouver Coastal Hospital, North Shore Hospital, Sea To Sky Hospital, Powell River Hospital, Sunshine Coast Hospital, Providence Health Centre, Vancouver Acute Hospital and Dogwood Hospital.  The LDR reports (both self-serve pages and report) become the official source on actual labour costs (from HR database) and budgeted labour costs (from Financials database) across all hospitals. This report is used by senior management and line managers to manage their labour costs.  Develop ‘GL Transaction Report’ which retrieves and summarizes data from 4 sources – General Ledger, Inventory, Accounts Payable and Purchasing. This report is one of the 3 officially published Financial Reports - ‘Revenue & Expense Report’, ‘Labour Distribution Report (LDR)’ and ‘GL Transaction Detail Report’.  Develop strategy document which leads to the final approval for the project  Develop scope document deciding which hospitals would be included and the timeline for implementing LDR for each hospital  Develop functional specifications with end-user input  Develop technical specifications for on-line pages and batch job components.  Develop on-line self-serve pages using PeopleTools and PeopleCode (over 20 pages)  Develop batch and conversion programs using SQRs. (10 programs)  Develop Labor Distribution Reports using SQRs (8 programs)  Perform budget uploads to Labor Distribution tables for all hospitals.  Convert data from legacy payroll systems for Labor Distribution tables.  Develop project plan and implementation plan  Serve as technical adviser to IT director  Provide technical advice to the IT Security Officer on how to setup up portal security items

Bachelor of Commerce with Honours