Accounting Sap

Yan LIU Lead / Senior SAP Financials

* * * * *

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

Yan Liu

Certified Lead/Senior SAP S/4HANA Finance (FICO/Treasury/FSCM) Consultant Email: **.******@*****.***

Mobile: +1-403-***-****

Summary

A Certified SAP S/4HANA Finance (FICO/FSCM/Treasury) Team Lead / Senior Consultant with accounting background and 10+ years of internal & external management & consulting experience working with senior management, cross-functions and multicultural teams transforming core business process, developing operations and information systems strategies, and integrating technology solutions. 13 full lifecycle global implementation and roll-out projects across 5 Continents North America (Canada & US & Mexico), South America (Columbia & Brazil), Europe (UK, Italy, Switzerland), Asia Pacific (China, Australia, New Zealand, Iraq), East-Central Africa (Uganda), Latin America, etc. more than 15 countries. Industry covers Oil & Gas, Mining, Transportation, Manufacturing, Pharmaceutical, Electronic manufacturing, Telecommunication, Chemical, etc.

Professional expertise / functional hands-on experience in the domain of SAP FI (Financial Accounting), CO

(Management Accounting), FSCM (Bank Communication & Cash Management / Treasury & Risk Management- Money Market / Foreign Exchange / Derivatives / Securities & Credit / Collections & Dispute Management/ Biller Direct), JVA, PRA(Production & Revenue Accounting)component adhering to SAP Waterfall & Agile methodology. In addition, I also equipped with lots of integration experience with other modules such as Project System (PS), Human Resources (HR), Material Management (MM), Sales and Distribution (SD), Product Production (PP), and Plant Maintenance (PM), have exposure to Fiori. Effective and motivated senior consultant with Project Management / Team Lead experience, also a high energy strong polished bilingual communicator with keen organization / coordination ability, and a positive attitude, always enthusiastic and can work independently and collaboratively, and handle multi-tasks simultaneously under time constrains & high pressure.

Very familiar with other management tools & products: SAP Solution Manager, WPB, HPALM, SharePoint, Remedy, and Microsoft Suite of Office Products, Concur, RightAngle. Area of Specialization

• Strategy and Business planning

• Business Analysis and Process Reengineering / Mapping / Modelling

• SAP Implementation & Rollout

• Financial and System Audit Compliance

• Business case and Road-map development

• Financial Forecasting, Economic Analysis

• Engagement Management

• Project Management

• Change Management/ Stakeholder Management

Yan LIU Lead / Senior SAP Financials

2 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

• Financial Accounting (FI)

o General Ledger (GL) / Accounts Receivables (AR) / Accounts Payables (AP) / Assets Accounting (AA) / Taxation / Flexible Real Estate Management (RE-FX) / Travel & Expenses (T&E) / Funds Management (FM)

• Financial Supply Chain Management (FSCM)

o Bank Communication / Cash & Liquidity Management o Treasury & Risk Management (TRM) - Money Market (MM), Foreign Exchange (FX), Derivatives (DE), Securities (SE), Hedging Accounting

o Credit / Collections & Dispute Management/ Biller Direct (SAP S/4HANA Cloud for Customer Payments)

• Management Accounting (CO)

o Cost Element Accounting (CEA) / Cost Centre Accounting (CCA) / Internal orders (IO) / Product Costing (PC)

/ Profit Centre Accounting (PCA) / Profitability Analysis (COPA) / Material Ledger (ML)

• Joint Venture Accounting (JVA) & Production Revenue Accounting (PRA)

• Financial Closing: Month-end Closing (ME) / Year-end Closing

• SAP other modules Integration: MM / SD / PP / PS / HR / PM / WM

• Development: Programming knowledge includes Report Writer, Report Painter, LSMW / CATT and ABAP Query & codes, Batch-input, ALV reports, PI, BW and BPC Working Experience

2016 – Present Independent Consultant

Lead SAP Financials Consultant

2012~2015 PricewaterhouseCoopers – Canada

Consulting Manager, Senior SAP Financials (FICO/Treasury) 2010~2012 Atos Origin Co., Ltd

Senior FICO Consultant - Implementation

2009~2010 Infosys (China) Technology Ltd.

FICO Consultant - Implementation

2007~2009 Publications International Ltd. Beijing Office Accountant, In-house FICO Consultant

2006~2007 Walt Disney Ltd. Beijing Branch

Accountant, SAP End User

SAP Projects Profile

Cenovus Energy, Oil & Gas (Feb. 2020 – May. 2020)

https://www.cenovus.com

Role: Treasury & Finance Lead Consultant – SAP S/4HANA Implementation Project (S/4HANA 1909) Mainly focus on:

• Lead on Treasury & FI business process design

o Lead Business Process Design on Treasury: Banking, Cash Management, Treasury and Risk Management. o Lead Business Process Design on FI & Closing Cockpit o Demo in SAPS/4HANA Fiori Apps

• Single contact person for project milestone: Requirements gathering, solutions, testing deliverables.

• Communicate and coordinate cross 10 counterparties with different levels: o Cenovus 5 internal teams: Cenovus Business: Treasury Team, Finance Team, Tax Team, Project Management team, IT

o Project team: MM / PM / Development / Basis

o SAP

• Lead Functional Design Workshops / Meetings

o Requirements gathering & analysis with different levels of the organization; Understand As-Is process. Yan LIU Lead / Senior SAP Financials

3 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

o Lead design To-be process as per SAP S/4HANA best practice delivery.

• Lead System Integration Design:

o Treasury integrated with FI.

o SAP Banking configuration and integration with BOA (Bank of America) & RBC o Cash Management

o Treasury and Risk Management: Money Market, Foreign Exchange, Derivatives and Securities. 30 Instrument

/ product type; interfaces with Bloomberg.

o Treasury integration with other modules.

• Lead System Build/ Configuration phase:

o Bank: configuration DMEEX as per ISO2002 bank format. o Cash Management configuration

o Treasury & Risk Management: Product type/ transaction type/ flow type / transaction type etc.

• Lead Testing phase:

o Working with Testing Leads on: Testing Plan & Strategy, Testing Script design, etc. o Provide guidance for onsite testing team.

o Unit Testing, Integration Testing, Pre-UAT, guide User Acceptance Testing (UAT) and, HPALM management for testing auditing purpose.

• WRICEF: all Treasury Functional Specs writing including: o 5 banking interfaces for Bank of America (BOA) & RBC (Royal Bank of Canada) o 2 Bloomberg interfaces

• Security design.

• Professional documentation and review for project deliverables: o PDD (Process Design Document)

o CRD (Configuration Rational Document)

o On-demand basis such reference document, etc

• Stakeholders management

• POC (Prove of Concept); Problem solving, investigate, analysis etc.

• Mentor offshore junior resources

CNOOC International Limited, Oil & Gas Upstream (July 2019 – April. 2020) https://cnoocinternational.com/

Role: Lead Finance Consultant – Global Implementation Project Phase I – Blueprint Phase (S/4HANA 1909) Project Scope:

• Geography: 5 continents, 10 countries (11 main locations): North America (Canada & US & Mexico), South America (Columbia & Brazil), Europe (UK London & Aberdeen), Asia Pacific (China & Australia & Iraq), East-Central Africa (Uganda). Being selected to represent NA Finance team to travel with the Client globally.

• Engagement: hundreds of workshops; 80+ topics; thousands of people involved in various topics discussion Mainly focus on:

• Lead on Finance business process design (46 in total including 44 Global template and 2 Country-specific template)

o Lead Global Template Business Process Design on Tax & Asset Management (AM) o Lead Local (NA & UK) Business Process Design on Financial Accounting (FI), Project System (PS), Joint Venture Accounting (JVA), and Production Revenue Accounting (PRA) o Support Project System business process (PS) Global Template design and Management Accounting (CO)

• Single contact person for project milestone: Requirements gathering and Solutions.

• Communicate and coordinate cross 21 counterparties with different levels: o CNOOC 16 internal teams:

CNOOC Limited: Finance Team

CNOOC International: Finance Team, Project Management team, Budget and Planning team; IT

Norther America: Finance Team, Tax Team, Project & Cost Control (E&C); Global Exploration & International Development Team; Budgeting and Planning Team; IT Yan LIU Lead / Senior SAP Financials

4 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

UK: Finance Reporting Team, Tax Team; Project Operation Team; IT

Colombia: Finance Team

o Project team: MM / PM / Development / Basis

o 3rd parties: Budget System

• Professional documentation and review for project deliverables and on-demand basis such reference document, etc.

• Lead Functional Design Workshops / Meetings (hundreds of) o Requirements gathering & analysis with different levels of the organization across three countries; Understand As-Is process.

o Lead design To-be process as per SAP S/4HANA standard delivery.

• Lead System Integration Design:

o PM integrated with PS.

o MM integration with FI.

• WICEF: for Headquarter and all subsidiaries

• Security design for Global template and all locals.

• Stakeholders management

• POC (Prove of Concept); Problem solving, investigate, analysis etc. Suncor Energy, Oil & Gas Downstream (April 2019 – July 2019) https://www.suncor.com

Role: Senior FSCM Consultant – Treasury Transformation Program-Treasury Credit & Collections Project Project Scope: Canada & US 3 legal entities, team locates three places (Montreal, Toronto and Calgary) Mainly focus on:

• Lead Credit & Collections Management business process transformation and design; Dispute Management assessment.

• Single contact person for project milestone: Design (Requirements gathering and Solutions) and Testing, Training, Data conversion, Cutover, etc.

• Communicate and coordinate cross 10 counterparties with different levels: o SAP

o Suncor 6 internal teams:

Business team : Collections / Credit / Financial Performance

Digital & Enterprise Technical: Solution designer

Information Technology Operations – SAP FI Operation (Suncor)

Suncor Sustainment Team (IBM)

o Project team: Testing / Development / Training / Security. o 3rd parties: Dun & Bradstreet and Equifax

• Professional documentation and review for project deliverables and on-demand basis such reference document, etc.

• Lead Functional Design Workshops / Meetings

o Requirements gathering & analysis with different levels of the organization; Understand As-Is process. o Lead design To-be process as per SAP standard delivery. o Solution architect: SAP integrated with Dun & Bradstreet, Equifax, SAP FSCM integrated with SD & FI- AR.

• Lead System Configuration:

o CVI (Customer Vendor Integration): Customer -> BP (Business Partner) synchronization. o Credit Management: Organizational element, Credit exposure, Credit limit, Master data, Credit check types, Credit rating, and Credit block etc.

o Collections Management: Collection Strategy, Collection Segments, Collection Groups etc. o Dunning

• Lead Testing phase:

o Working with Testing Leads on: Testing Plan & Strategy, Testing Script design, etc. o Provide guidance for onsite testing team.

Yan LIU Lead / Senior SAP Financials

5 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

o Unit Testing, Integration Testing, Pre-UAT, guide User Acceptance Testing (UAT) and, HP QC management for testing auditing purpose.

• Lead Training:

o Lead training plan development

o Training material review & support development.

o Conduct the training sessions: train the trainer.

• Security:

o Design roles for Business.

o Credit Management & Collections Management Sustainment ownership mapping.(Technical role naming convention & True owner are different)

o Working with Security to assess associated risk.

• Lead Data Conversion & Cutover:

o Cutover / Deployment Plan

o Data Management: lead Data Conversion & Migration.

• Technical development:

o Lead batch job solution options selection and schedule. o Functional Design specifications by ABAP program / code, to perform functional analysis of programs; de- bug; batch processing procedures, function modules and technical objects. Interface with Dun & Bradstreet, Equifax

• Stakeholders management

• Problem solving, investigate, analysis and defects fixing both in transactions and in reports level. Canadian National Railway, Transportation & Logistics (Dec. 2017 – Mar.2019) https://www.cn.ca/

Role: Senior FI / Treasury / PM Functional Designer – Leasing Project Project Scope / Methodology: Canada & US 25 legal entities. Mainly focus on:

• Lead Finance / PM / Treasury Leasing business process / scenarios implementation to meet new lease accounting standard (ACS 842) after adoption in Jan. 2019. Lead 11 process designs out of 44, total 8 designers.

• Single contact person for project milestone (leasing equipment & Assets): Design (Requirements and Solutions) and Testing, Cutover, etc.

• Communicate and coordinate cross 8 internal teams with different levels and 3rd party: o Finance: Leasing Team / Property Accounting / Treasury o Project Team – Solution Architect, Solution Integrator, etc. o Development Team

o APM team: FICO & PM sustainment

o Project offshore team: Development Team, Testing Team o 3rd party: Power Plan - The leader in Lease Accounting.

• Professional documentation and review for project design deliverables on both functional (mainly) and technical, and on-demand basis such reference document, etc.

• Lead Functional Design Workshops / Meetings

o Requirements gathering & analysis with different levels of the organization; Understand As-Is leasing process as per ASC 840.

o Lead design To-be process (ASC 842): leasing accounting lifecycle such as Lease Contract Management, Lease Asset Management, Lease Payment & Valuation Processing, etc. o Solution architect: SAP Integrated with PowerPlan, FI integrated with PM within SAP environment on Leasing Assets (Capital & Operating Equipment / Assets), AP and Treasury.

• Lead System Configuration & Integration Design:

o FI: Leasing Assets lifecycle management: acquisition to retirement, and AP. o PM: Equipment integrated with Assets.

o Treasury: Treasury & Cash Forecasting.

o RE-FX (Flexible Real Estate)

• Lead Testing phase:

Yan LIU Lead / Senior SAP Financials

6 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

o Working with Testing Leads on: Testing Plan & Strategy, Testing Script design, etc. o Provide guidance for onsite & offshore testing team. o DOA (Development Object Acceptance), Integration Testing, User Acceptance Testing (UAT) and Regression Testing, Managing HP ALM for testing auditing purpose.

• Security design.

• Lead Cutover:

o Cutover / Deployment Plan

o Data Management: Design Data Conversion & Migration (ABAP program / LSMW).

• Technical development:

o Lead batch job schedule.

o Functional Design specifications by ABAP program / code, to perform functional analysis of programs; de- bug; batch processing procedures, function modules and technical objects. Interface with PowerPlan system, Umler system.

• Stakeholders management

• Problem solving, investigate and defects fixing both in transactions and in reports level. Husky Energy, Oil & Gas (May. 2017 – Dec. 2017)

http://www.huskyenergy.ca/

Role: FI Functional Lead & Testing Lead - BMO- PrimeRevenue Supply Chain Payables Project Project Scope / Methodology: Canada / US & China legal entities / Agile Methodology. Mainly focus on:

• Perform business analysis on Supply Chain Financing to improve working capital.

• Single contact person for project functional milestones: Design (Requirements and Solutions), Testing, Training, and project go / no-go.

• Communicate and coordinate cross 10 inter-teams with different levels and 3rd party: o Finance: Accounts Payable / Taxation / Treasury (Cash & Banking) o Safety, Engineering & Procurement: SCM Effectiveness and Compliance / Procurement Service Center

(PSC) / Category Management / SCM Process, System and Master Data o Information System (IS) team: FI sustainment / Integration sustainment (PI) / Steering committee o 3rd party: PrimeRevenue - The leader in Supply Chain Finance. o Project offshore team: functional and technical

• Professional documentation and review for project all phases’ deliverables on both functional (mainly) and technical, and on-demand basis such reference document, etc.

• Lead Blueprint workshop

o Requirements gathering & analysis with different levels of the organization; Understand As-Is manual process outside and inside SAP.

o Lead designing To-be process SAP & Integration with PrimeRevenue. o Solution architect: automate AP processes with BMO/PrimeRevenue: vendor onboarding, transactions trading, fund maturity, reconciliation between systems / payment settlement, and Error Handling etc.

• Lead System Configuration:

o SAP FI: AP vendor master data, payment settlement, bank structure, house banks & bank account setup, bank interface, etc.

o Tax: Withholding Tax, PST, etc.

• Lead Testing phase:

o Testing Plan/ Strategy owner, Testing Script design, testing execution & guidance in different sections: o Unit Testing, Integration Testing, User Acceptance Testing (UAT) and Regression Testing, Managing HP ALM for testing auditing purpose.

• Lead Training: training instructor & training material review and development

• Security design.

• Lead Cutover:

o Cutover / Deployment Plan

o Data Management: Data Conversion & Migration (ABAP program / LSMW). Yan LIU Lead / Senior SAP Financials

7 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

• Technical development: design Functional specifications by ABAP program / code, to perform functional analysis of programs & PI; de-bug; batch processing procedures, function modules and technical objects. Interface with PrimeRevenue system.

• Stakeholders management

• Problem solving, investigate and defects fixing both in transactions and in reports level. Husky Energy, Oil & Gas Downstream (Mar. 2016 – Mar. 2017) http://www.huskyenergy.ca/

Role: FI Lead – FSCM & SMS US Replacement Project (Downstream) Project Scope / Methodology: Canada / US legal entities / Agile Methodology. Mainly focus on:

• Single contact person for project functional milestones: Design (Requirements and Solutions), Testing, Training, and project go / no-go.

• Communicate and coordinate cross 8 inter-teams with different levels and 3rd party: o Finance: Accounts Receivables / Treasury (Cash & Banking) / Accounts Payables / Taxation o Middle Office: Credit (Retail Credit)

o Information System (IS) team: FI sustainment / System Integration sustainment / Steering committee o Project offshore team: technical

o 3rd party: RightAngle / NGS etc.

• Professional documentation and review for project all phases’ deliverables on both functional (mainly) and technical, and on-demand basis.

• Lead Blueprint workshop:

o Requirements gathering & analysis with different levels of the organization; Understand As-Is: SMS

(Structured Management System) processes, and design To-be process in SAP. o Solution architect: automate AR process, Bank process: bank reconciliation and payment settlement, etc.

• Lead Integration AR with FSCM (collection / dispute / credit management) throughout the project.

• Lead System Configuration:

o SAP FI Banking: Bank structure, house banks & bank account setup, electronic bank statements, bank interface (with HSBC by EDI / PI) etc.

o Cash Management: Cash Positioning & Forecasting configuration. o Account Receivables: AR operation / reports, Tax reports, etc. o FSCM: Credit / Collection & Dispute Management.

• Lead Testing phase: testing script design, testing execution & guide in different sections: o Unit Testing, Integration Testing, User Acceptance Testing (UAT) and Regression Testing, track the testing results in HP ALM for auditing purpose.

• Lead Training: training instructor & training material development

• Security design.

• Lead AR cutover: Cutover Plan / Data Management: Data Conversion & Migration (LSMW).

• Technical development: design Functional specification by ABAP program / code, to perform functional analysis of programs; de-bug; batch processing procedures; function modules and technical objects. Interface with other systems e.g. RightAngle, NGS, Customer Portal, etc.

• Problem solving, investigation and defects fixing either in transactions or in reports level.

• Understand of credit card settlement process

Goldcorp Inc., Gold Mining (June 2015 – Dec. 2015) http://www.goldcorp.com/

Role: FI / CO Team Lead - Migration Corporate Finance to Integra Template Project Scope / Methodology: Vancouver / Toronto / US / Barbados and other international legal entities / ASAP Methodology.

• SAP Project Management / Team Lead mainly focus on:

• Single contact person for project functional milestones: Design (Requirements and Solutions), Testing, Training, and project go / no-go.

Yan LIU Lead / Senior SAP Financials

8 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

• Communicate and coordinate with different level in different teams: o Finance Team: AP / AR / Taxation / Assets / GL / Costing o SAP sustainment: FICO sustainment

• Professional documentation and review for project all phases’ deliverables on both functional (mainly) and technical, and on-demand basis, etc.

• Lead Fit/Gap analysis workshop

o Requirements gathering & analysis with different levels of the organization ranging from VP to business staff; o Solution architect: Migrate all FICO modules from Classic GL to New GL.

• Lead System Configuration / Updates:

o Financial Accounting: legal entity setup, collections, payment, assets accounting, Taxation (country-specific); o SAP FI / Treasury: Bank structure, house banks & bank account setup, and electronic bank statements, bank interface with Wells Fargo, etc.

o Controlling Accounting: Cost Centre Accounting, Internal Order accounting, Profit Centre Accounting;

• Lead Testing phase: testing script design, testing execution & guide in different sections: o Unit Testing, Integration Testing, User Acceptance Testing (UAT) & Regression Testing, track the testing results in HPQC for auditing purpose.

• Lead Training: training material development (FICO & Material Management) via WPB & presentation to the end-users.

• Technical development: design Functional specification by ABAP program / code, to perform functional analysis of programs; de-bug; batch processing procedures; function modules and technical objects. Interface with Concur.

• Transport management: transport schedule, transport strategy, etc.

• Change Management: communication plan, training plan, stakeholder meeting, etc.

• Problem solving, investigation, defects fixing either in transactions or in reports level.

• Support Data Management: Data Conversion & Migration. Dominion Diamond Corporation, Mining (Feb. 2015 – June. 2015) http://www.ddcorp.ca/

Role: Treasury consultant – Treasury Team – BNS Project

• Lead Bank automation ranging from Configuration to go-live.

• Lead SAP FI Bank configuration: bank structure, house banks & bank account setup, and electronic bank statements, bank interface with RBC, etc.

• Lead Electronic Banking and reconciliation processes, communicate and coordinate with Bank & AP departments.

• Support Project Manager communicate with business for other Treasury business development.

• Investigate, communicate and coordinate with business for inquires, and technical team for development such as program, batch processing procedures, etc.

• Documentation review and creation: functional /technical designs and other project-related combined ASAP methodology to achieve a standardized set of deliverables. Dominion Diamond Corporation, Mining (Feb. 2015 – June. 2015) http://www.ddcorp.ca/

Role: CO consultant – Costing Reporting Team – Cost Center Redesign & Cost Allocation Implementation

• Lead throughout the project, communicate with various levels ranging from Chief Accountant, Superintendent to business Staff.

• Lead costing month-end process.

• Lead costing optimization activities.

• Lead the Costing master data redesign, including Cost center / internal order / activity type and other master data redesign and clean up.

• Lead reporting solution.

• Lead training development: training material preparation, and presentation to the costing team. Yan LIU Lead / Senior SAP Financials

9 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

TransCanada Pipelines Limited, Energy (Oct 2014 – Feb. 2015) http://www.transcanada.com/

Role: Treasury consultant – Treasury Team –Banking & Cash Management

• Lead Canada & US post go-live sustainment project.

• Communicate and coordinate across 5 teams with different levels of business: o Finance: Corporate Accounting / Trading / Back Office o SAP: SAP Mexico implementation team / Sustainment Team

• Lead process streamline: treasury and accounting integration.

• Mexico Treasury Testing Management (Unit Testing, Integration Testing, UAT and Regression Testing) to identify if any impact on already go-live legal entities’ business process.

• SAP FI / Treasury: Bank structure, house banks & bank account setup, and electronic bank statements, bank interface with CITI & RBC, etc.

• Lead training: training material development and presentation to Corporate Accounting team

• Support internal & external audit.

• Security redesign.

• Transport Management.

• Technical development: design Functional specification by ABAP program / code, to perform functional analysis of programs; de-bug; batch processing procedures ;function modules and technical objects

• Problem solving, investigate, defects fixing either in transactions or in reports level. TransCanada Pipelines Limited, Energy (Oct. 2014 – Feb. 2015) http://www.transcanada.com/

Role: Treasury consultant – Treasury Team – Corporate Finance Project Project scope: Money Market / Bond / Securities.

• Lead as the Treasury consultant from Blueprint to go-live support.

• Communicate and coordinate across 6 teams with different levels of business: o Finance: Corporate Accounting / Corporate Finance / Middle Office / Back Office o SAP: BW / Security

• Also responsible as a Quality Assurance Manager managing the entire Testing Phase, including test plan/script creation, testing progress tracking scorecard creation, testing progress monitoring against the plan, and HPQC tracking.

• Single contact between Treasury & Corporate Accounting team.

• Lead the training development: prepared / presented the training material, and provided trainings to end-users across teams (Corporate Finance, Corporate Accounting, and Master Data Management Team).

• Support internal & external audit.

TransCanada Pipelines Limited, Energy (Oct. 2014 – Feb. 2015) http://www.transcanada.com/

Role: Treasury consultant – Treasury Team – Interest Rate Desk Project Project scope: Money Market / Foreign Exchange deals.

• Lead as the Treasury consultant throughout the project.

• Communicate and coordinate across 6 teams with different levels of business: o Finance: Corporate Accounting / Trading / Middle Office / Back Office o SAP: FICO / Security

• Also responsible as a Quality Assurance Manager managing the entire Testing Phase, including test plan/script creation, testing progress tracking scorecard creation, testing progress monitoring against the plan, and HPQC tracking.

• Single contact between Treasury & Corporate Accounting team.

• Lead the training development: prepared / presented the training material, and provided trainings to end-users across teams (Trading, Corporate Accounting, and Master Data Management Team). Yan LIU Lead / Senior SAP Financials

10 o f 1 2

Mobile: ( + 1 ) 4 0 3 - 8 7 0 - 9 6 8 3

TransCanada Pipelines Limited, Energy (Aug. 2012 – Oct. 2014) http://www.transcanada.com/

Role: Senior FICO consultant – ART team (Accounting, Risk & Tax) – Integra Project Project Scope: 198 legal entities including Canada / US and other international legal entities.

• Lead as the senior FICO consultant from the configuration to go-live support (hyper care).

• Communicate and coordinate across 13 teams with different levels: o Finance: GL / AR /AP / Taxation / Reporting

o SAP: HR / MM / PS / PM / ABAP / PI / BW / Security

• Mainly focus on GL / AR / Taxation (country-specific) / Reporting, Travel Management configuration / testing, such travel expenses, travel request & approval, and travel planning etc. and integrated with HR.

• A key contact between Finance and other modules such as MM/PS/HR/PM etc.

• Quality Assurance Review.

• BPC Support: reconciliation such as intercompany transactions, bank accounts etc by excel. O.R.G Packaging Co. Ltd., Manufacturing (Dec. 2011 - July.2012) http://www.orgpackaging.com

Role : SAP FI/CO/TR Team Lead – FICO Team – SAP ECC Implementation

• Lead the project Finance portion ranging from Blueprint to Go-live support.

• Project Management:

o Project plan development and project progress tracking. o Manage, interact, and communicate with the project steering committee. o Change Management.

• Lead roadmap implementation:

o Blueprint workshop: requirements gathering & analysis workshop with different levels ranging from CFO to business staff;

o Finance solution architect: a global SAP FI/CO/TR template design to represent best practices and business processes for the subsequent implementing / rolling out SAP in its subsidiaries. o Localization solution:

Integration with Chinese Tax System (Golden Tax System).

Development such as Financial reports and document printing adhering to Chinese regulation & compliance.

o Electronic Bank process : SAP FI Bank structure, house banks & bank account

Contact this candidate