$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Oracle EBS , PL/SQL, Peoplesoft , C++, Java, VB
Eric Yim
,
Tai Po, Hong Kong SAR China
Experience
Other titles
Skills
I'm offering
I have worked as Oracle Ebs Expert more than 8 years, with the role from Oracle developer to Oracle Technical Account Manager . I have worked freelance experience using c# for desktop application, objective c , java for mobile. I like programming.
Markets
United Kingdom
Language
English
Fluently
Chinese (Mandarin)
Fluently
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2019 - ?
job
Technical Account Manager
Seamatch Asia Limited.
Account Manager, Manager
2018 - 2019
job
Senior Analyst, Financial Applications
VERINT Systems (Asia Pacific) Ltd.
Verint Sytems is a MNC, a New York-basedanalytics company with around USD $1.2 billion annual revenue. The company sells software and hardware products for customer engagement management, security, surveillance, and business intelligence. My major role is to work as individual Oracle Expert in APAC region to listen the requirement from key stakeholders and change these projects or enhancement requirement into technical documents and then work with overseas developers to complete development cycle. This year I have completed the project of New Zealand / India Fixed Asset Setup, India Bill Presentment AR Invoice Automation, China local reports, Multiple functional currencies trial balance report and finished Statement of Work (Sow) in Commission System with vendor agreement.
Also, I need to support the critical and urgency issues and share the experience with overseas Oracle support team. I also involve with the global IT change with my global Oracle Team, and configure oracle for the functional changes such as taxation or other minor setup in the employment period.
Also, I need to support the critical and urgency issues and share the experience with overseas Oracle support team. I also involve with the global IT change with my global Oracle Team, and configure oracle for the functional changes such as taxation or other minor setup in the employment period.
Business Intelligence, Oracle, Automation, Management, It, Security, Support, Analyst, Hardware, Development, Software, China
2017 - 2018
job
System Analyst
Cafe De Coral.
largest Fast Food and Beverage Chain groups with over 200 branches in HK and South China.
Environment: Oracle EBS R12 version 12.1.3 (Linux), Toad, Oracle Forms and Report 10g, PL/SQL, Discoverer
Some of my achievements:
i)Statement Matching / CDCIF PO Receive Fine Tuning: The retailer used a portal system "NBMS" as central point to handle branches activities and it transferred data to the core Oracle GL/AP/PO/FA
There were two critical urgent issues:
The AP team could not figure out the complete PO receive / return transactions by Statement Matching to process AP invoicing. I have fixed all problems in that Statement Matching issue and then it has no further complaint from finance for it.
Month-end closing of finance were always delayed due to the slow processing of IF Po Receive - which was caused by the slow transfer speedfrom NBMS to Oracle.
I tuned the program to speed up from 1 record per 4 seconds to 1 record per 0.4 seconds or less. Then month-end closing can be on schedule.
Oracle Modules involved: AP / PO
ii)EDI ASN & Invoice project:
EDI project consisted of three Phases:
Phase 1 is EDI PO, Phase 2 is EDI ASN and Phase 3 is EDI Invoice
The final objective was to make CDC suppliers to be able to send EDI ASN/Invoiceunder invoice validation rules (instead of paper/fax etc). I gathered all user requirements for the change of process flow, wrote all specification to let all key users and top management to sign-off , and finally managed and delivered UAT successfully.
Oracle Modules involved: AP / PO
This project achieved great success: When the Oracle-EDI system first went live inFeb 2018, there were only 12 suppliers which signed up to join the plan. After 6 months of running (till Aug 2018), there were already 80+ suppliers with 99.7 invoice success submission rate, and covered over 80% PO. The implementation was said to be one of the best EDI projects ever delivered among all F&B companies in HK.
iii)Oracle HK-China EBS Architecture Revamp project (Step 1):
Before the project was started, the HK/China operations used one server embedded with application and database in HK. So all CDC back office users were suffered from instability and slow response issues.
The company decided to increase the numbers of servers to handle applications and database. An external system integrator (DASH) was assigned to support the migration from 1 server to 4 servers. I was assigned to look after the transition and to ensure/test all key features could be run smoothly after the new installation.
My focus was to ensure all external systems such as EDI / Email / NBMS / China CDC (GZCDC) Legacy Systems (U8 or APBMS) could be functioned normally, and processed UAT with DASH and CDC key users. The project was then delivered successfully.
Oracle Modules involved: GL / AP / PO
iv)Oracle EBS PRC Split Instance project (Step2):
Before Step 2, the Guangzhou operation was using Oracle EBS Server based in HK with multiple ledgers which were consolidated into Group Ledger in the same server. DASH used iSetup and some customization programs to split their ledgers, operating units, GL/AP/PN/FA configurations, master data, balances and outstanding AP/PM data into new instance for GZCDC.
My role was to lead SIT/ Data Verification / UAT for Guangzhou finance operation. The transition was complicated as the financial data was required to be input concurrently in the CN and HK servers. I designed programs and instructions for GZ Finance team to transit into the new modules step by step.
Finally, the project was successfully implemented and the GZ operation could extract the necessary financial data.
Oracle Modules involved: GL / AP / PN / FA
Environment: Oracle EBS R12 version 12.1.3 (Linux), Toad, Oracle Forms and Report 10g, PL/SQL, Discoverer
Some of my achievements:
i)Statement Matching / CDCIF PO Receive Fine Tuning: The retailer used a portal system "NBMS" as central point to handle branches activities and it transferred data to the core Oracle GL/AP/PO/FA
There were two critical urgent issues:
The AP team could not figure out the complete PO receive / return transactions by Statement Matching to process AP invoicing. I have fixed all problems in that Statement Matching issue and then it has no further complaint from finance for it.
Month-end closing of finance were always delayed due to the slow processing of IF Po Receive - which was caused by the slow transfer speedfrom NBMS to Oracle.
I tuned the program to speed up from 1 record per 4 seconds to 1 record per 0.4 seconds or less. Then month-end closing can be on schedule.
Oracle Modules involved: AP / PO
ii)EDI ASN & Invoice project:
EDI project consisted of three Phases:
Phase 1 is EDI PO, Phase 2 is EDI ASN and Phase 3 is EDI Invoice
The final objective was to make CDC suppliers to be able to send EDI ASN/Invoiceunder invoice validation rules (instead of paper/fax etc). I gathered all user requirements for the change of process flow, wrote all specification to let all key users and top management to sign-off , and finally managed and delivered UAT successfully.
Oracle Modules involved: AP / PO
This project achieved great success: When the Oracle-EDI system first went live inFeb 2018, there were only 12 suppliers which signed up to join the plan. After 6 months of running (till Aug 2018), there were already 80+ suppliers with 99.7 invoice success submission rate, and covered over 80% PO. The implementation was said to be one of the best EDI projects ever delivered among all F&B companies in HK.
iii)Oracle HK-China EBS Architecture Revamp project (Step 1):
Before the project was started, the HK/China operations used one server embedded with application and database in HK. So all CDC back office users were suffered from instability and slow response issues.
The company decided to increase the numbers of servers to handle applications and database. An external system integrator (DASH) was assigned to support the migration from 1 server to 4 servers. I was assigned to look after the transition and to ensure/test all key features could be run smoothly after the new installation.
My focus was to ensure all external systems such as EDI / Email / NBMS / China CDC (GZCDC) Legacy Systems (U8 or APBMS) could be functioned normally, and processed UAT with DASH and CDC key users. The project was then delivered successfully.
Oracle Modules involved: GL / AP / PO
iv)Oracle EBS PRC Split Instance project (Step2):
Before Step 2, the Guangzhou operation was using Oracle EBS Server based in HK with multiple ledgers which were consolidated into Group Ledger in the same server. DASH used iSetup and some customization programs to split their ledgers, operating units, GL/AP/PN/FA configurations, master data, balances and outstanding AP/PM data into new instance for GZCDC.
My role was to lead SIT/ Data Verification / UAT for Guangzhou finance operation. The transition was complicated as the financial data was required to be input concurrently in the CN and HK servers. I designed programs and instructions for GZ Finance team to transit into the new modules step by step.
Finally, the project was successfully implemented and the GZ operation could extract the necessary financial data.
Oracle Modules involved: GL / AP / PN / FA
It, UP, Processing, Portal, Tuning, EDI, China, Server, Office, Implementation, Analyst, Support, Sql, Architecture, Finance, Less, Embedded, Pl/sql, Test, Management, Database, SoMe, Oracle, Linux
2015 - 2017
freelance
Senior Oracle Consultant
Toplux Hong Kong.
Toplux is an Oracle solution provider which offered IT consulting service for Oracle ERP upgrade. I was hired by the company to support customers to customize and upgrade Oracle EBS.
Environment: Oracle EBS R12.2.5 (Linux), Oracle Forms and Report 10g, PL/SQL, Discoverer, BI Publisher
Project involved:
i)HWL's Oracle R12 upgrade project:
Responsible for upgrading the customized programs and reports in modules AP, AR,GL, FA from 11i to R12. Support HWL to migrate Oracle from R11i to R12. Enhance and upgrade over 80+ Oracle reports and concurrent programs during the upgrade. The enhancement covered R12 SLA accounting and AP Data Structural change.
Oracle Modules involved: GL / AP / FA / CM / SLA
ii)NEC - Oracle R12 upgrade project:
Support NEC to upgrade from Oracle R11i to R12.2.5. Responsible for OM / INV
AP walkthrough, customer gap analysis, user training and implementing form /reports/PLSQL customization for Oracle Project Enhancement.
Oracle Modules involved: GL / AP / OM / INV / Project billing / Project costing
Environment: Oracle EBS R12.2.5 (Linux), Oracle Forms and Report 10g, PL/SQL, Discoverer, BI Publisher
Project involved:
i)HWL's Oracle R12 upgrade project:
Responsible for upgrading the customized programs and reports in modules AP, AR,GL, FA from 11i to R12. Support HWL to migrate Oracle from R11i to R12. Enhance and upgrade over 80+ Oracle reports and concurrent programs during the upgrade. The enhancement covered R12 SLA accounting and AP Data Structural change.
Oracle Modules involved: GL / AP / FA / CM / SLA
ii)NEC - Oracle R12 upgrade project:
Support NEC to upgrade from Oracle R11i to R12.2.5. Responsible for OM / INV
AP walkthrough, customer gap analysis, user training and implementing form /reports/PLSQL customization for Oracle Project Enhancement.
Oracle Modules involved: GL / AP / OM / INV / Project billing / Project costing
Sql, Linux, Training, Oracle, Consulting, ERP, Pl/sql, Service, It, Support, BEE, Costing
2008 - 2015
job
Senior Analyst Programmer (Oracle Financial Application)
VTECH Asia Pacific.
VTECH is one of the world's largest suppliers of corded and cordless telephones (VTT) and electronic learning products (VTE).
Environment: Oracle EBS 11i, Oracle Forms and Report 6i, Oracle Workflow, PL/SQL, Delphi, Oracle 10g Database, Business Objects Data Integration XI, TOAD, Windows/Unix Script, QuickBook
Oracle Modules involved: OM / INV / PO / AR / AP / GL / CM / BOM / WIP
I was initially hired the VTech to develop various in-house applications and to support Oracle data warehouse. Since 2011, I was transferred to the Oracle team to focus on all Oracle related ERP/Financial applications.
Environment: Oracle EBS 11i, Oracle Forms and Report 6i, Oracle Workflow, PL/SQL, Delphi, Oracle 10g Database, Business Objects Data Integration XI, TOAD, Windows/Unix Script, QuickBook
Oracle Modules involved: OM / INV / PO / AR / AP / GL / CM / BOM / WIP
I was initially hired the VTech to develop various in-house applications and to support Oracle data warehouse. Since 2011, I was transferred to the Oracle team to focus on all Oracle related ERP/Financial applications.
Sql, Oracle, Database, Data Warehouse, ERP, Integration, Unix, Windows, Pl/sql, Delphi, Support, Analyst, Workflow
2011 - 2015
job
Senior Analyst Programmer
VTech decided to create a new office.
• I was first assigned by the Oracle Applications Team Manager to support him and other Senior System Analyst to develop and enhance PL/SQL, alerts, report, forms, etc. for VTT manufacturing modules which included BOM, Quality, MRP, WIP etc.
• Then I was also involved in some VTEUS distribution enhancement, e.g. automation in PO/INV receipt etc.
• In 2012, a System Analyst colleague who supported the Vtech UK's Oracle applications had resigned, he was then chartered to take over his role and to support all Oracle distribution modules for Vtech's UK. VTEUK had its own warehouse for shipping with inbound order from EDI or e-Commerce web site (http://www.vtech.co.uk/), and thus they required different interface for Order Import. Besides UK's team, I was also responsible for supporting the finance team of Vtech Australia as well as other tailored made applications in the region.
In 2014, VTech decided to create a new office in Australia for VTE toys. I wasthen chartered to lead the new Oracle project:
• Interacted with users to design solution and accomplish To-Be process Design.
• Work with Finance managers and the Management team in Australia to setup Legal Entity, set of books, Inventory organization etc.
• GL Setup, INV/OM/Shipping/ PO setup such as sub-inventory, transaction type
• Develop customization for interfacing with 3PL warehousing and CRM web site.
• Deliver SIT and UAT testing on Order to Cash Flow and Procure to Cash Flow.
• Prepare and write up various training manuals such as Master Input, OM / PO / AP / AR / GL guide etc.
• Train the users in Australia and rollout to production.
• Then I was also involved in some VTEUS distribution enhancement, e.g. automation in PO/INV receipt etc.
• In 2012, a System Analyst colleague who supported the Vtech UK's Oracle applications had resigned, he was then chartered to take over his role and to support all Oracle distribution modules for Vtech's UK. VTEUK had its own warehouse for shipping with inbound order from EDI or e-Commerce web site (http://www.vtech.co.uk/), and thus they required different interface for Order Import. Besides UK's team, I was also responsible for supporting the finance team of Vtech Australia as well as other tailored made applications in the region.
In 2014, VTech decided to create a new office in Australia for VTE toys. I wasthen chartered to lead the new Oracle project:
• Interacted with users to design solution and accomplish To-Be process Design.
• Work with Finance managers and the Management team in Australia to setup Legal Entity, set of books, Inventory organization etc.
• GL Setup, INV/OM/Shipping/ PO setup such as sub-inventory, transaction type
• Develop customization for interfacing with 3PL warehousing and CRM web site.
• Deliver SIT and UAT testing on Order to Cash Flow and Procure to Cash Flow.
• Prepare and write up various training manuals such as Master Input, OM / PO / AP / AR / GL guide etc.
• Train the users in Australia and rollout to production.
Analyst, UP, Manager, Guide, Production, EDI, Http, Process design, Shipping, Web, Office, Testing, Design, Support, Finance, Pl/sql, Management, Automation, E-commerce, SoMe, Oracle, Training, CRM, Sql
2008 - 2010
job
Application developer
unknown.
• Responsible for developing various in-house applications and supporting daily ETL operations.
• Involved in EDMT applications which measured profitability such as manufacturing cost by product, ODM or branded profitability by customer/product.
• Develop and support Vtech's US applications which measured the forecast for US market and calculated the production of telecom products.
• Design and develop Help Desk platform which supported non-IT users to make the ticket request and seek help from the IT Dept.
• Involved in EDMT applications which measured profitability such as manufacturing cost by product, ODM or branded profitability by customer/product.
• Develop and support Vtech's US applications which measured the forecast for US market and calculated the production of telecom products.
• Design and develop Help Desk platform which supported non-IT users to make the ticket request and seek help from the IT Dept.
Design, ETL, It, Developer, Support, Telecom, Forecast, Production
2007 - 2008
job
Solutions Analyst
The Link Management Ltd.
The Link Real Estate Investment Trust is Hong Kong's first and largest real estate investment trust which was spun off from HKSAR.
I was hired by the CPMS Teams which supported the billing and payment system of the company. I was responsible for analyzing business needs and user requirements, coordinating with vendors to modify and enhance the application wherever necessary.
Environment: J2EE, JSP,Servlet, Oracle 9i Database, Oracle JDeveloper, Excel VBA
I was hired by the CPMS Teams which supported the billing and payment system of the company. I was responsible for analyzing business needs and user requirements, coordinating with vendors to modify and enhance the application wherever necessary.
Environment: J2EE, JSP,Servlet, Oracle 9i Database, Oracle JDeveloper, Excel VBA
Excel, Oracle, Database, VBA, Analyst, J2EE, Jsp
2004 - 2006
job
System Analyst
MERIX Asia Pacific.
Merix was a leading US global manufacturer of advanced multilayer rigid printed circuit boards for automotive, communications and computer peripherals.
Environment: Oracle ERP R11, Paradigm, VB.NET / C#, Windows/Unix Script, IIS, Oracle 10g Database, Excel/Access
• I was initially hired by the company to develop and support Web-based ERP applications which covered modules for Sales and Marketing, Finance (interfacing with Accounting Software), Procurement and Inventory.
• In the 2nd year, the company decided to use Oracle ERP/Financial software. I was assigned to help migrating all in-house designed Web based applications to Oracle E-business.
Environment: Oracle ERP R11, Paradigm, VB.NET / C#, Windows/Unix Script, IIS, Oracle 10g Database, Excel/Access
• I was initially hired by the company to develop and support Web-based ERP applications which covered modules for Sales and Marketing, Finance (interfacing with Accounting Software), Procurement and Inventory.
• In the 2nd year, the company decided to use Oracle ERP/Financial software. I was assigned to help migrating all in-house designed Web based applications to Oracle E-business.
Sales, Vb, Web, Software, IIS, Analyst, Support, Finance, Net, Windows, Marketing, Vb.net, Unix, Procurement, ERP, C, Database, Oracle, .Net, Excel
2002 - 2003
temp
Analyst Programmer/System Support
KODAK Hong Kong.
(Contract)
- Analyst Programmer (One-year contract)
- System Support (One-year contract)
Kodak was once the world's largest imaging expert.
I was hired by the company's Kodak Imaging Centre. The Imaging Centre provided document imaging and digital printing services to banks and governments.
In the first year contract, I was hired to support and maintain its network infrastructure. In the 2nd year, I was working as Analyst Programmer to develop and support tailor-made data-entry and imaging services applications.
- Analyst Programmer (One-year contract)
- System Support (One-year contract)
Kodak was once the world's largest imaging expert.
I was hired by the company's Kodak Imaging Centre. The Imaging Centre provided document imaging and digital printing services to banks and governments.
In the first year contract, I was hired to support and maintain its network infrastructure. In the 2nd year, I was working as Analyst Programmer to develop and support tailor-made data-entry and imaging services applications.
Network, Support, Analyst, Infrastructure
2000 - 2002
job
Analyst Programmer
New Modern Technology.
New Modern Technology was a leading IT solution provider and application software developer in Hong Kong and China
Environment: Oracle Forms and Reports, Oracle 10g Database, VB
I was hired to work under MOL to develop the application "BayPlan" to address theproblem of determining stowage plans for containers in a ship between ports. After that, I was assigned to work for Housing Authority to support its system for Home Ownership Schemes.
Environment: Oracle Forms and Reports, Oracle 10g Database, VB
I was hired to work under MOL to develop the application "BayPlan" to address theproblem of determining stowage plans for containers in a ship between ports. After that, I was assigned to work for Housing Authority to support its system for Home Ownership Schemes.
Oracle, Database, It, Technology, Developer, Support, Analyst, Software, China, Vb
My education
?
-
1998
Hong Kong University of Science and Technology
BSc, Computer Science
BSc, Computer Science
Eric's reviews
Eric has not received any reviews on Worksome.
Contact Eric Yim
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Eric directly in Worksome.
37900+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark