Project Oracle
Resume:
Qian (David) Jiang
Professional experience
Profile Professional Summary:
Overall 11 years of Oracle EBS experience
- Have very good Functional knowledge of Oracle
Finance modules
- Have R12 Implementation knowledge
- Lead and assist services related process design for
Oracle R12 Implementation/Upgrade
- Hands on experience as a Finance functional
consultant and have experience in GL,AP,AR,FA,CE
- Ability to work with business stake holders to collect
business requirements and prepare design documents
- Have the ability to act as a liaison between end-user,
other stakeholders, Support Team and service providers
- Excellent communication to interact with various
business and IT stakeholders
- Work in collaboration with the third party teams to get
the work done in a timely fashion
- Develop operating procedures, training materials,
assist in developing test strategy and plan, test scripts
and cases, and end-user acceptance testing
- Change management Leadership, working with
customers and business users to ensure solution
integrity
Oracle Module Functional Skills:
Primary:
Oracle General Ledger(GL), Oracle Advanced Global
Inter-Company System(AGIS), Oracle Payables(AP),
Oracle Receivables(AR), Oracle Fixed Assets(FA),
Oracle Cash Management(CE), Oracle Internet
Expense(OIE), Oracle Approval Management(AME),
Oracle Subledger Accounting(SLA), Oracle EB-Tax,
Oracle Purchasing(PO) and Oracle Internet
Procurement(iPro)
Secondary:
Oracle Project Management(PJT), Oracle Project
Resource Management(PJR), Oracle Project
Costing(PJC) and Oracle Project Billing(PJB)
Oracle HRMS and Oracle Payroll application and Oracle
SSHR
Module Specialties:
AP, PO, OIE, SLA, CE, AR, FA, GL, AGIS.
iProcurement, PA, PJT and HRMS
EBS table structure, expertized on SQL based queries
for data analysis and trouble-shooting
Professional Development and Training:
Oracle Fusion Application Executive Overview
Oracle R12 EBS Essentials for Implementers
Oracle R12 Project Costing
Oracle R12 Project Billing
PMO Fundamentals
PMP
Employment History IBM Jan 2011 –
Oct 2013
Oracle Corp Jul 2008 – Dec
2010
DoubleBridge Technologies Jul 2006 – Jun
2008
PCCW Sep 2003 – Jun
2006
Talent Technology Development Nov 2002 –
Aug 2003
Norming Consultants Jun 1999 – Oct
2002
TFL Chemicals Apr 1997 –
May 1999
Goodyear Sep 1995 –
Mar 1997
Haier Group Jul 1993 – Aug
1995
Project Name: Hertz STEP ERP Project
Assignment History
Aug 2012 - Oct 2013
Hertz, OKC US
Oracle P2P Consultant
Client Description: The Hertz Corporation, a subsidiary
of Hertz Global Holdings Inc is an American car rental
company with international locations in 145 countries
worldwide. The company is based in Park Ridge, New
Jersey, has the shared service center for Procurement,
Finance and HR located in Oklahoma.
Responsibilities:
• Be responsible for Business Requirement
collection for RICE components
• Developed AP invoice inbound and outbound
interfaces for several legacy systems like
Concur, TACO, LAMDA, Global Recon,
Telapoint, Wright Express, Banned Supplier
Validation, Compose all the Functional
Specifications, Test Cases and complete the
Unit Test and SIT
• Developed Functional Design for PO Accrual
Liability and AP Liability OBIEE, and complete
the unit test and SIT
• AME solution owner for AP Invoice approval and
Purchase Requisitions workflow
• Develop Functional specification for extension
for AP Invoice Hold resolution and complete Unit
Test and SIT
• EBTax setup
• Finished GL Mass Allocation configuration
• Act as backup fill of Fixed Asset lead, focusing
- 3/10 -
on production trouble shooting
• Production support, maintenance and
enhancement
• Environment: Oracle EBS R12 GL, AGIS, AP,
FA, PO, iProcurement, Sourcing; OBIEE; GRC
Project Name: Hertz China AR project
May 2012 - Aug 2012
Hertz, OKC US
Oracle AR Functional Consultant, country SME
Client Description: Hertz China, a subsidiary of Hertz
US Rent A Car, is a car rental company running
business in China.
Responsibilities:
• Collect local billing and receivable requirements
from business side and meet the requirement
from government statutory side like Golden Tax
Integration system
• Lead Fit-Gap analysis workshops and document
them into Target Design Document, transfer the
requirement to the functionality and identified
RICE components
• Finish functional design for Inbound interface
from billing system CDS to Oracle AR
• Provide the Golden Tax Interface solution,
document the functional design specification for
the Outbound interface and complete the unit
test and SIT
• Prepare BR100 configuration document for AR
• Provide remote AMS for production system
• Environment: Oracle EBS 11i GL, AP, AR, FA,
PO
Project Name: John Deere Thailand OLFM Project
May 2012 - May 2012
John Deere Financing Company, Moline, Illinois
Oracle Financial Consultant
Client Description: Deere & Company, commonly
known by its brand name John Deere, is an American
corporation based in Moline, Illinois, and one of the
largest manufacturers of agricultural machinery in the
world. John Deere Financial is in financial business to
finance equipment, parts, or service to for ag producer,
construction or forestry customer, commercial grounds
customer, or a homeowner.
Responsibilities:
• Finish core Financial modules configuration
including GL,AGIS,AR,AP,FA,EBTax and SLA
for UAT as on-site functional consultant
• Finish partial configuration in OLFM
• Participate UAT with business users for P2P
process, O2C process, Acquire to Retire
process, and Leasing process
• Environment: Oracle Applications R12 GL,
AGIS, AP, AR, FA, OLFM
Project Name: Aramark R12 Upgrade Project
Nov 2011 - May 2012
Aramark, Philadelphia, PA
Oracle Financial Consultant, SME
Client Description: Aramark Corporation, known
commonly as Aramark, is an American food service,
facilities, and clothing provider supplying businesses,
educational institutions, sports facilities, federal and
state prisons, and health care institutions.
Responsibilities:
• Act as local country SME for the R12 upgrade
project in International instance, discuss local in-
country statutory requirements
• Finish the necessary upgrade setup for
GA/AP/AR/FA/SLA
• Assist ARAMARK trainers with training activities
• Execute CRP, SIT, UAT, Cutover and Go-live
• Responsible for on-shore production support
• Environment: Oracle Applications GL, AGIS, AP,
AR, FA, Oracle EBS R12
Project Name: UK SSE ERP Project
Aug 2011 - Oct 2011
Scottish and Southern Energy, UK
Offshore Oracle PA&FA Consultant
Client Description: SSE p is an electric utility company
headquartered in Perth, Scotland. It is a constituent of
the FTSE 100 Index.
Responsibilities:
• Write functional spec design for several RICE
objects
• Prepare unit test document and finish unit test
working with the developer
• Environment: Oracle EBS R12 GL, AR, PO, AP,
PA, FA
Project Name: UK CFS HCM Project Phase II
Mar 2011 - Sep 2011
The Co-operative Financial Services, UK
Offshore Oracle HR Consultant and succeeding PM
Client Description: Co-operative Banking Group
Limited (formerly Co-operative Financial Services) is a
UK-based banking and insurance company and a wholly
owned subsidiary of Co-operative Group. Established in
2002; head office is located at the former CIS Tower
known as Miller Street, Manchester.
Responsibilities:
• Review the existing functional spec design and
make the changes as needed for RICE objects
• Prepare use cases for each RICE ID
• Conduct the unit test for each RICE before
delivering to onsite team based on UK
• Play role of succeeding PM for project
progression management and issues track
- 5/10 -
• Environment: Oracle EBS R12 HRMS and
Payroll
Project Name: Shen-Ning Group ERP Project
Jan 2011- Mar 2011
Shenhua-Ningxia Coal Industry Group Co., Ltd,
China
Oracle Financial Consultant
Client Description:Shenhua Ningxia Coal Industry
Group Co., Ltd (Shen-Ning Group in abbreviation) is
Shenhua Group’s share-holding subsidiary, and a
competitive backbone enterprise of Ningxia Hui
Autonomous Region. . It operates in sectors such as
coal mining & washing, coal deep processing, coal
chemical industry, electric power, real estate and so on.
Currently, the coal production capacity has reached 60
million tons/year, and the production in construction has
passed 100 million tons.
Responsibilities:
• Instruct business users to finish Data
Conversion and reconciliation of the opening
balances for GL, AR, AP and FA
• Participate onsite support for over 40
subsidiaries, and assist users to complete
month end closing
• Responsible for AMS in production
• Environment: Oracle EBS R12 GL, AGIS, AP,
EBTAX, AR, FA, PO, INV, COST, HRMS
Project Name: Huawei Marine PJT/PA Project
Jun 2010 - Dec 2010
Huawei Marine Networks, China
Oracle Projects Consultant
Client Description: Huawei Marine Networks Co.,
Limited (Huawei Marine) is a joint venture established in
late 2008 by Huawei Technologies Co., Ltd. and Global
Marine Systems Limited. Based on the advantages of
the two parent companies, Huawei Marine combines
state-of-the-art technologies in telecommunications and
the experiences of marine operation covering 150 years,
committing itself to the construction of global submarine
cable communication networks. Huawei Marine provides
highly reliable, cost-effective solutions and end-to-end
turnkey services including project management,
installation and technical support for submarine cable
system operators.
Responsibilities:
• Collect business requirements and conduct
workshops for high level package solution and
detailed solution design thru Fit/Gap Analysis for
Project Management and Project Accounting for
the following processes:
o Project Kickoff and Plan
o Project Budget and Forecast
o Project Progression Management
o Services Procurement Process
o Equipment Procurement Process
o Billing and Revenue Process
o Issue Management
o Change Management
o Project Closure
• Finish system configuration and provide all
deliverable like BR100, TE020, TE040
• Execute SIT and UAT in R11i environment
• Upgrade instance to R12 and finish all testing
• Environment: Oracle EBS 11i/R12 Project
Management, Project Billing and Project Costing
Project Name: MOTOROLA OIE RFP Project
Mar 2010 - May 2010
MOTOROLA Global Accounting Center, China
Oracle i-Expense Consultant
Client Description: Motorola Solutions, Inc. is an
American data communications and telecommunications
equipment provider that succeeded Motorola Inc.
Responsibilities:
• Led the work shop for OIE with functionality and
business process
• Conduct FIT/GAP analysis to see how to
replace Concur
• Provide Solution Design document to identify
the functionality and RICE components
Project Name: CITICS CRM and PJT POC Project
Dec 2009 - Feb 2010
CITICS Investment Banking, China
Oracle Projects Consultant
Client Description: CITIC Securities Company Limited
is a leading full-service investment bank in China, it
maintains the leading position on business fronts such
as investment banking, brokerage, asset management,
investment advisory service, etc.
Responsibilities:
• Conduct FIT/GAP analysis, match the business
requirement to functionality
• Prepare functional spec for interfaces between
PJT and CRM, PM and BIEE
• Execute CRP workshops to introduce the
system standard functionalities and processes
• Conduct UAT with the key users and finish user
manual
• Environment: Oracle EBS R12 Project
Management, Time & Labor and Project
Resource Management, OBIEE and Siebel
CRM
Project Name: BOC FMS Project
Sep 2008 – Nov 2009
Bank of China, China
Oracle AP Lead
Client Description: As China's most international and
diversified bank, Bank of China provides a
comprehensive range of financial services to customers
across the Chinese mainland, Hong Kong, Macau,
- 7/10 -
Taiwan and 36 overseas countries. The Bank's core
business is commercial banking, including corporate
banking, personal banking and financial markets
services.
Responsibilities:
• Collect detailed business requirements,
compose BR020
• Conduct IT/GAP analysis, provide interface
solution with e-HR system, core-GL module, e-
Banking, finish FD050
• Design AME workflow approval for AP invoice
and customized iAP solution
• Execute SIT1, SIT2, SIT3
• Validate and verify data conversion for all
vendors, employee master data and opening
balances for AP
• Participate pivot site implementation and
countrywide roll outs for all subsidiaries in China
• Environment: Oracle EBS 11i GL, GIS, AP, OIE,
FA, PO and INV
Project Name: Marsh China FMS Rollout Project
Apr 2007 - Jul 2008
MARSH China, China
Oracle Financial Consultant & PM
Client Description: Marsh, a global leader in insurance
broking and risk management, has approximately
25,000 employees and provides advice and
transactional capabilities to clients in over 100 countries.
Marsh China is the subsidiary of MMC group.
Responsibilities:
• Led workshops to gather business requirements
for both PRC GAAP and US GAAP
• Conduct FIT/GAP analysis and provide interface
solution between GL and e-Global, GL Voucher
and FA movements
• Design FSG for US GAAP and PRC GAAP
reports to meet business requirements
• Complete Setup for PRC GAAP book and MRC
book
• Conduct UAT with the key users and prepare
user manuals
• Validate data conversions for master data and
open balances for GL, AP and FA
• Complete Reconciliation with the former legacy
• Environment: Oracle EBS R12 GL, AP, FA
Project Name: Marsh Korea FMS Rollout Project
Jul 2006 - Mar 2007
MARSH Korea, Korea
Oracle Financial Consultant
Client Description: Marsh, a global leader in insurance
broking and risk management, has approximately
25,000 employees and provides advice and
transactional capabilities to clients in over 100 countries.
Marsh Korea is the subsidiary of MMC group.
Responsibilities:
• Led POC workshops to gather business
requirements for both KOR GAAP and US
GAAP
• Conduct FIT/GAP analysis and provide interface
solution between AP and CITI e-BANK, GL
Voucher and AP Voucher
• Design FSG for US GAAP and KOR GAAP
reports to meet business requirements
• Complete Setup for KOR GAAP book and MRC
book
• Conduct UAT with the key users and prepare
user manuals
• Validate data conversions for master data and
open balances for GL, AP
• Complete Reconciliation with the former legacy
• On site AMS support, help user to run
Revaluation and Translation to close the month
end
• Environment: Oracle e-Business Suite R2 GL,
AP
Project Name: CNC ERP Project
Jan 2005 - Sep 2005
CNC (China Netcom Corporation), China
Oracle Financial Consultant & PM
Client Description: CNC (China Netcom Corporation,
now known as 'CUC') is one of the biggest
telecommunication provider in China.
Responsibilities:
• Meet the client to collect business requirements
for GL/AR/AP/FA/CE, finish BP040 and RD020
for current business process practice
• Finish BP080 and RD050 for future business
process model
• Conduct CRP and complete Fit/GAP analysis
• Write MD050 for interfaces with BOSS
(business operation supporting system, e-
Banking and others
• Conduct SIT
• Execute UAT
• Support production go-live
• Environment: Oracle EBS 11i
GL/GIS/GCS/AR/AP/CE/FA/PA/PO/INV
Project Name: CMCC MIS Project Sep 2003
- Dec 2004/Sep 2005-Jun 2006
CMCC (China Mobile Communications Corporation),
China
Oracle HR Lead in PCO & Oracle Financial
Consultant
Client Description: China Mobile Limited is a Chinese
state-owned telecommunication company that provides
mobile voice and multimedia services through its
nationwide mobile telecommunications network.
Responsibilities:
• Collect business requirements based on
templates for GL/AR/AP/FA/CE
- 9/10 -
• Conduct CRP for FIT/GAP analysis and finish
RD050 as solution design
• Write FD050 for interfaces for BOSS (business
operation supporting system), and others like
one 3rd party Procurement Platform application,
e-Banking
• Complete BR100 document and system
configuration
• Execute SIT and UAT
• Prepare TA070 for user manuals
• Complete data conversions for master data and
open balances for AR, AP, GL and FA
• Environment: Oracle EBS 11i
GL/GIS/GCS/AR/AP/FA/CE/PA/PO/INV
Project Name: JingNeng MIS project
Oct 2002 – Aug 2003
Beijing JingNeng Thermal Power Corp., China
Oracle HR Consultant
Client Description: Beijing Jingneng Thermal Power
Co., Ltd. (SHA:600578) is a Beijing coal power producer
and district heating supplier listed on the Shanghai
Stock Exchange.
Responsibilities:
• Meet users to collect business requirements and
finish RD050
• Conduct CRP for FIT/GAP analysis
• Finish system configuration and write BR100
• Execute UT, SIT and UAT
• Complete Cutover activities for system go-live
• Environment: Oracle EBS 11i
HR/Payroll/GL/AP/FA
Education B.S. in Accounting at Inner Mongolia College of Finance
and Economics from 1989 to 1993.
Others aca5cc@r.postjobfree.com
Contact this candidate