Resume

Name

Johnson Yan

Subject

Oracle EBS Consultant

Gender

Male

Experience

* ****

Education

Undergraduate

Email

acw1tt@r.postjobfree.com

Phone

+86-180********

Basic Skill

Language

Mandarin

Mother Language

English

Good

Japanese

Communication Skill

well

Oracle ERP

Basic Skill

Module

Business research and analysis

Program

Design

System setup and testing

Customer

Training

System

Operation

GL

AR

AP

FA

CE

PA

PO

I Procument

INV

OM

HRMS

WIP

MRP

CST

Oracle Tech Skill

Content

Excellent

Skilled

Basic

None

ADI

Work Flow

OAF

OSA

PL/SQL

System Admin

Report design

Form design

Oracle App

And Implementation

PLSQL OAF FORM WORKFLOW IREP webservice

Other Skill

MS Office, java

Work Experience

2016.07-Now

INTERNATIONAL BUSINESS MACHINES (IBM)

Department/Position: EBS Senior Technical Consultant

Report to: Department manager

Subordinate: none

Location: China Shenzhen

2011.07-2016.07

HAND Enterprise Solutions Co., Ltd.

Department/Position: EBS Technical Consultant

Report to: Department manager

Subordinate: none

Location: China Shanghai,Beijing,Guangzhou,Shenzhen,Mongolia

Education background

2008.9-2012.6

Bachelor Degree

Software Engneering,Yunnan University,China.

School Project: J2EE,Java swing,Ext js,JQuery

IBM Project Experience

2016/07 – Now Shenzhen CRLand Development Project

Development tool

JDEVLOPER/PLSQL Developer/Form Builder/Report Builder

Project Desc

CRLand is a property company. They use customer OAF module to manage their cost message.Now they need some addition requirement to change the custom module.

Responsible Desc

Technical support. Technical Consultent. Use Jdevloper to implement oaf pages include some complicated page which uses tree, hgird, international language management, subTab etc. Use EBS webservice module IREP to make it enable to communicate with OA system via webservice. Finish these development work high quality and on time.

Hand Project Experience

2015/12 – 2016/7 AMWAY develop and maintenance Project

Development tool

PL/SQL Developer/Form Builder/Report Builder

Project Desc

Mostly the development and technical support of this Project.

Responsible Desc

Technical director,Technical support. Help functional consultant solve some difficult problem. This Project’s UI is all OAF.

2015/7 – 2015/11 CATIC UI optimization Project

Development tool

PL/SQL Developer/Form Builder/Report Builder

Project Desc

CATIC is a wholly owned subsidiary of China national aero-technology import and export corporation. They want the people who use ERP system can be more convenient and quick..

Responsible Desc

Technical director, design the implementation of the project . Project UI,Project transfer UI, SO UI,SO PO transfer UI…

2015/3 – 2015/7 Potevio Reports Maintenance Project

Development tool

PL/SQL Developer/Form Builder/Report Builder

Project Desc

Mostly the development and technical support of Potevio Reports Maintenance Project

Responsible Desc

Technical support. Help functional consultant solve some difficult questition.

2014/8 – 2015/2 Potevio Reports Implementation Project

Development tool

PL/SQL Developer/Form Builder/Report Builder

Project Desc

Mainly engaged in mobile products sale and service. It is one of the largest mobile products sale and service company in China. Here the ERP system was just on live September 2013, but not be able to use the system well.They decide to re-implement the system.

Responsible Desc

Migrate program,profile,lookups,value set and so on. Migrate basic setting of GL,AP,AR,FA module.

2014/3 – 2014/8 Potevio Reports Developments Project

Development tool

PL/SQL Developer/Form Builder/Report Builder

Project Desc

Mainly engaged in mobile products sale and service. It is one of the largest mobile products sale and service company in China. Here the ERP system was just on live September 2013, our team come here to implement some essential reports.

Responsible Desc

Technical director, report evaluation, communicate with the functional consultant and users, understand what they want .Lead the technical consultant to develop reports. Include AP,AR,OM,PO,GL,INV module’s over 60 reports

2014/2 -- 2014/3 China Steel Group Maintenance project

Development tool

PL/SQL Developer/Form Builder

Project Desc

Sinosteel is manly engaged in metallurgy mineral resources development and processing. Has almost 80 subcompany .We went here to support it department solve the users’s problem, operation and some develop problem.

Responsible Desc

c, Technical support. Help functional consultant solve some difficult questition.

2013/9 -- 2014/2 Erie Master Data Management Project

Development tool

PL/SQL Developer/Form Builder

Project Desc

Erie is the one of the largest dairy industry, the product line is the most perfect enterprise of China. Cause of the large data, Erie need a wonderful way to manage its master data. Then the rest of other systems can get the data they want just from this system.

Responsible Desc

Technical director, design the implementation of the project .

Search the master data that not used for one year or two year, inactive these master data.

Make it is possible to transfter all of the master datas like items,customers, vendors, banks, organizations and so on master data from a instance to another instance.

2013/7 -- 2013/9 CATIC Process optimization Project

Development tool

PL/SQL Developer/Form Builder

Project Desc

CATIC is a wholly owned subsidiary of China national aero-technology import and export corporation. They want a special platform to manage the flow from inquiry, purchase and sale .We come here to implement it.

Responsible Desc

Technical director, design the implementation of the project . Made a platform that can go through from material inquiry to purchase to sales.

Customer special workflow to manage the approve . Customer form they can download and upload data, and directly view the wrong message. Customer PO,SO form that can import as standard PO, SO.

2013/3 -- 2013/5 AEROSPACE INFORMATION CO.,LTD Maintenance project

Development tool

PL/SQL Developer/Form Builder

Project Desc

Mostly the development and technical support of AEROSPACE INFORMATION CO.,LTD

Responsible Desc

Technical consultant, Technical support. Help functional consultant solve some difficult questition.

2012/10 -- 2013/3 Panasonic China Energy EBS R12 Upgrade Project

Development tool

PL/SQL Developer/Form Builder

Project Desc

Panasonic China used oracle 11i system . Cause 11i is almost a legacy system,they want to upgrade to oracle R12.

Responsible Desc

Technical director, Technical support. Search all of the customize form and request, manage the difference of oracle ebs 11i and R12,leading technical consultant to correct the customize program. Manage the issue list, code version. Search the program needed to be changed.

2011/7 -- 2012/9 Panasonic China Oracle ERP Project

Development tool

PL/SQL Developer/Form Builder

Project Desc

Mostly the development Panasonic China system. This is a big project,can subdivision into many small project. Our company sent some consultant to develop, others to management the system. I almostly do the development of the project.

Responsible Desc

ERP and PSP AP invoice matching project: transfer the receive data into another system,then get the invoice data from the third system. Finally import as standard invoice.

Electronic Sales ledger project: develop a function manager AR invoice and receipts, view the customer’s balance.

PAVCSH_EDI Commercial trend change project: develop EDI interface, import Sales Order, export packing data, auto ship confirm.

PAPWMHZ_system optimization Project: optimized the customerize code,make it faster.

Help functional consultant solve some difficult questition . maintenance the system.

Contact this candidate