Nancy Nan, CPA

***** ******** **. *******, ** *7024 713-***-**** (mobile)

acencl@r.postjobfree.com

OBJECTIVE A challenging fulltime position in ERP systems functional

implementation and support.

HIGHLIGHT 7 years experiences in Enterprise Resource Planning (ERP) systems

implementation and support

3 years experiences in SAP ECC 6.0 functional implementation and

support.

4 years experiences in Oracle EBS R12. X functional implementation

and support.

9 years experiences in financial accounting/reporting with CPA

license qualifications.

Expertise in support and configurations of various SAP ECC 6.0 FI/CO

modules including GL, AR, AP, AA, Banking, Tax, Consolidation, TV,

Treasury, CO, COPA, CO-PCA, IM etc.

Expertise in support and configurations of various Oracle E-Business

Suite R12 modules, including GL, FA, PA, AP, INV, PO, SLA, CM, AR

etc.

Highly fluent with SQL and in-depth knowledge of SAP ECC and Oracle

EBS tables and data structures.

Extremely self-motivated with substantial SAP ECC and Oracle EBS

functional trouble shooting capabilities.

WORK Senior SAP FICO Analyst August 2011 - Present

EXPERIENCE The Brock Group, Houston, TX

SAP ECC 6.0 Implementation and Support

Analyze business process and requirement of SAP ECC 6.0 ERP

implementation project. Perform system requirement gathering and gap

analysis. Develop business process design and model and define systems

strategies as well as solutions in Blueprint Phase for various

business cycles including Order to Cash, Procure-to-Pay, Asset and

Equipment Management, Monitor and Report Financials as well as Human

Capital Management.

Perform and lead the realization phase for all FI/CO functionalities.

Take the full responsibilities and key role as the ONLY resource to

configure and customize GL, AR, AP, AA, Banking, Tax, Consolidation,

TV (Travel Expenses), Treasury, CO, COPA, CO-PCA, CO-CCA, RA(Result

Analysis) etc. Review and validate customizations for baseline and

final configurations. Accomplish significant cost-saving by reducing

the 3rd party functional consulting hours from 200 hours/week to 20

hours/week within 2 months.

Take the full responsibilities and key role as the ONLY resource to

design and create FI/CO master data structures as well as manage and

set up all FI/CO master data.

Draft, revise and finalize over 100 functional and technical

specifications for enhancements of FI/CO functionalities. Communicate

with development team, validate and test enhancements.

Perform intensive trouble-shooting, research and provide resolutions

for all FI/CO functionalities. Review, validate, test and apply

solutions, such as SAP notes etc. Create and monitor Service Request

with SAP Support as needed.

Lead financial data conversion for multiple project roll-outs. Take

the full responsibilities and key role as the ONLY resource to build

LSMW and load data files for GL COA and account balances, AA Asset

master and balances, AR balances, AP balances, MM inventory balances

and vendor master, SD customer master, TV travel expense vendor master

etc.

Develop, validate and optimize complex queries, reports and data files

using Report Painter, Writer and SQL to facilitate various businesses

need.

Design and perform regression testing including unit testing,

integration testing (INT) and user acceptance testing (UAT) during the

implementation process. Lead and support user trainings for all FI/CO

functionalities for project roll-outs.

Provide over 12 months of on-site and hands-on support to users for

FI/CO modules. Trouble shooting and resolve encountered issues.

Design, implement and manage the SLA standards and procedures for post

go-live user support. Conduct continuously remote user support,

trainings and communications as level 1, 2 and 3 support. Manage, lead

and delegate off-shore support team for FI/CO user requests and

tickets.

Provide in-depth insight for ECC integrations from FI/CO perspective.

Perform account determination customization for other modules such as

SD, MM, HCM, PS, PM etc. Work with Security team to build, validate

and test FI/CO and other related security roles. Administrate and

monitor ECC workflows.

Oracle EBS Implementation Project Transition May 2011 - August

Lead 2011

Oil States International, Houston, TX

Implement Oracle application functional solutions for EBS R12

installations and rollouts. Lead and perform configurations and set

up of Oracle EBS R12 all core modules, including Oracle General

Ledger and Sub-ledger Accounting (GL and SLA), Order Management (OM),

Purchasing (PO), Inventory (INV), Accounts Receivable (AR), Accounts

Payable (AP), Process Manufacturing (OPM), Cost Management (CST) etc.

Design and perform regression testing including unit testing,

integration testing (INT) and user acceptance testing (UAT) during

the implementation process.

Perform intensive trouble-shooting, research as well as provide

resolutions for all modules (GL, SLA, OM, INV, PO, AR, AP, CST,

etc.). Review, validate, test and apply solutions, such as patches,

data fixes etc. Create and monitor Service Request with Oracle

Support (Met-Link) as needed. Utilize Oracle Diagnostics, trace and

other tools to gather necessary information. Monitor applications and

transactions as precautious on daily basis.

Design, implement and manage the SLA standards and procedures for

post go-live user support. Conduct continuously user support,

trainings and communications.

Develop, validate and optimize complex queries, reports and data

files using PL/SQL to facilitate various business need.

Senior Oracle Applications Functional Analyst Jan. 2008 - April

US Concrete Inc. Houston, TX (Headquarter) 2011

Oracle R12 Implementation Project

Analyze business process and requirement Oracle R12. ERP

implementation projects. Perform system requirement gathering and gap

analysis. Develop business process design and model. Define systems

strategies, including reports, interfaces, conversions and

extensions, for various business cycles such as, Acquire to Dispose,

Account-to-Close (Record to Report), Procure-to-Pay,

Project-to-Close, Lead-to-Contract (Order to Cash) etc.

Implement Oracle application functional solutions for EBS R12

installations and rollout. Configure and set up Oracle EBS R12 all

core modules, including Oracle General Ledger and Sub-ledger

Accounting (GL and SLA), Accounts Payable (AP), Fixed Assets (FA),

Project Accounting (PA), Inventory (INV), Purchasing (PO), Cost

Management (CST), Cash Management (CM), Accounts Receivable (AR),

I-Expense, I-Procurement etc.

Significant hands on experience with PA Costing and Billing. Lead

Project Accounting (Costing and Billing) implementation team.

Configure key areas in Project Costing, Project Billing, auto

Accounting, business flow setups. Define Project related setup

options, Project calendar, Project Period. Setup Project types,

Project Templates, Tasks, workflows and profiles. Set up Project rate

Schedule for Labor and Non-Labor preferences to facilitate the

resources to enter their cost against the Project and Task number.

Customize project accounting suite for reporting activities.

Configure accounting Rules for Auto accounting and creating Lookup

sets. Configure Project Capitalization process and interfere to Fixed

Asset module.

Design and perform regression testing including unit testing,

integration testing (INT) and user acceptance testing (UAT) during

the implementation process.

Lead and perform over 400 hours of in-depth class-room user training

sessions at various sites across US. Provide over 10 months of

on-site and hands-on support to users for all core modules. Trouble

shooting and resolve encountered issues.

Oracle Applications Support

Take the full responsibilities and key role as the ONLY functional

analyst for entire Oracle applications with over 750 users, 12 core

modules and 5 instances. Accomplish significant cost-saving by

reducing the 3rd party functional support hours from 240 hours/week

to zero within 2 months.

Perform intensive trouble-shooting, research as well as provide

resolutions for all modules (GL, SLA, FA, PA, AP, INV, PO, CST, CM,

AR, I-Expense etc.). Review, validate, test and apply solutions, such

as patches, data fixes etc. Create and monitor Service Request with

Oracle Support (Met-Link) as needed. Utilize Oracle Diagnostics,

trace and other tools to gather necessary information. Monitor

applications and transactions as precautious on daily basis.

Lead and manage special projects related to Oracle applications.

Design, collaborate, and document EBS functional and technical

specifications for various special projects such as acquisitions, new

operating unit configurations for all modules, Chapter 11 filing,

bankruptcy emergence, bank conversions and automatic banking

transactions implementation etc. Design, create, test and implement

numerous SQL scripts as well as configurations related to all core

modules such as AP, CM, GL, FA, INV, PO, PA etc. to achieve special

goals.

Develop, validate and optimize over 500 complex queries, reports and

data files using PL/SQL and Toad to facilitate various business need.

Publish the queries and reports through Oracle Discoverer and EBS

customized schema. Develop and modify various RTF files for XML

report templates.

Conduct continuously user support, trainings and communications.

Create and perform over 100 hours of substantial follow-up trainings

at various sites all over US.

Manage upgrades projects. Perform patch and functional analysis for

multiple upgrades (12.0.4, 12.0.6 and 12.1.3). Lead the upgrade

testing cycles. Conduct trouble shooting and provide solutions during

the upgrading/testing process. Teamwork with developers to complete

development objects and manage 3rd party development resources.

Enhance, improve and optimize EBS effectiveness and efficiency

continuously by changing configurations, processes automations etc.

Maintain and modify EBS system securities and controls for SOX

compliance. Create and modify customized responsibilities, menus,

functions request sets etc. Administrate Oracle application

workflows.

Senior Accountant May 2006 - Jan. 2008

US Concrete Inc. Dallas, TX (South Central

Region)

Performed general ledger month-end close. Prepared, evaluated,

reviewed and corrected monthly, quarterly and annual financial

statements as well as supplement and footnote information. Analyzed

the financial statements and presented to management. Brought

management's attentions to various issues that affected cash flows,

internal controls, financial results etc.

Oversaw various sub-ledgers, including AP, AR, payroll etc.

Reviewed, analyzed and reconciled accounts and transactions.

Maintained and examined financial schedules and records to ensure

transactions were properly recorded. Made timely corrections on

identified issues. Assisted financial and tax audits.

Managed fixed assets procedure, policy and process. Preformed bank

reconciliations for all bank accounts including deposit accounts,

disbursement accounts, payroll accounts etc. Managed and compiled

inventory financial data and information. Conducted periodically

physical inventory verifications. Maintained Sarbanes-Oxley

compliance.

Team-worked with non-financial managers to prepare, evaluate, review

and modify annual financial budgets. Generated financial forecast

and financial projections. Compiled managerial accounting

information, including scorecards, benchmark etc.

Staff Accountant May. 2005 - May.

Well Group Inc. Arlington, TX 2006

Prepared standard journal entries and allocations. Performed

accounts reconciliations and corrections which involved intense

analysis and investigation on un-reconciled items. Recorded AP and

AR transactions in general ledger. Maintained accounting schedules.

Worked closely with customers and vendors to research the

reconciliation items and resolve the disputes.

Presented monthly financial results to management. Prepared the

variances analysis. Explained the financial information to

non-financial managers. Identified opportunities to improve

business processes and reported the findings to management.

Senior Consultant/Project Manager Feb. 2000 - Jun.

Asia Base A/S, Shanghai, China and Copenhagen, 2004

Denmark

Worked closely with over 15 European clients to provide China entry

and development consulting services customized to individual

clients' requirements.

Managed over 30 projects for European clients to provide tailored

market research.

EDUCATION Master of Professional University of Texas at Aug. 2006

Accounting Arlington

GPA 3.83, Graduate Dean's List.

M.A. in English Linguistics and Fudan University, China Jun. 2004

Literature

B.A. in English Literature Yunnan University, China Jul.

2001

Top 1% GPA with honors. Minor in Business Administration.

PROFESSIONAL Certified Public Account, State of Texas

LICENSE & US Permanent Resident (Green Card), no need for sponsorship

AVAILABILITY

Contact this candidate