a8dx4l@r.postjobfree.com Frank Gu Irvine, CA ***** Cell: 949-***-****

SUMMARY

• 12 years’ experiences in SAP global implementation and production support. 11 full life cycle implementations and 3 upgrades. Worked in the latest SAP version ECC 6.0.

• Extensive configuration and production support experience in SAP FI/CO, PS, SD, MM, PP, TR, EC-CS, HR, EDI, Security, ABAP, and Workflow.

• FI: Corporate Finance Management, Fund Management, General Ledger, Account Payable, Account Receivable, Fixed Asset, Special Ledger, Bank, Investment Management, Travel Management.

• CO: Cost Center Accounting, Cost Element Accounting, Internal Order, Product Costing, Profit Center Accounting, and Profitability Analysis.

• FSCM: Credit Management, Collection Management, and Dispute Management,

• MM: Purchasing, Inventory Management, Logistic Inventory Management.

• SD: Sales, Shipping and Billing.

• Expertise in Revenue Recognition, document split with over 999 line items, VAT, and plant abroad.

• Developed many SAP interfaces: SAP to Peoplesoft; SAP to American Express, SAP to Real Estate third party software, SAP to insurance software and SAP to Golden VAT system.

• Utilized ABAP query, Report Painter and Report Writer to create different reports.

• Used LSMW to load master data from legacy system to SAP.

• SAP Industry experience: Health Insurance, Retirement Insurance, Semiconductor Manufacture, Logistic Warehouse, Consumer Product , High Tech, Auto Parts Manufacture, and Media.

• SAP global implementation experience in the following countries: US, China, Canada, Germany, Belgium, England, Netherlands, Mexico, and France.

EXPERIENCE

Firestone

Sr. SAP FI/CO consultant August 2010-update

• Performed the gap analysis and created the blue print document. Conducted full implementation for Firestone China. Configured GL, AR, AP, Bank, Fixed Asset, IM, CEA, CCA, IO, PA, PCA, PC and integration with SD, MM, and PP.

• Configured bills of exchange and tested the interface between SAP and the Golden VAT system.

• Created LSMW and custom program for the data conversion. Conducted the data migration from the legacy system to SAP.

• Created training material to train the users.

Cisco

Sr. SAP FI/CO Consultant August 2009 – July 2010

• Involved in defining project scope, gap analysis, architect design for the SAP implementation in China. Configured GL, AR, AP, Bank, SPL, CCA, CEA, IO, PA, PCA, PC, Project System, COPA, and integration between SD to FI and MM to FI .

• Configured VAT and created interface between SAP to the Golden VAT system to print out the special VAT invoice in China.

• Created new query for GL report and deleted the alternative account in all GL accounts in two company codes.

• Created new tax codes for many countries in EU to meet EU’s tax change requirement.

• Transferred the asset from SAP to Oracle and retired all assets in SAP.

• Configured revenue recognition for service.

• Used LSMW to create over hundreds profit centers.

• Created training document in SAP FI/CO and trained the users.

Warner Bros, CA May 2007- July 2009

Senior SAP FI/CO Consultant

• Participated in SAP CRM and SCM implementation in US and were in charge of the cutover for the FI team. Created and solved the Remedy ticket and CR request in FI/CO area. Conducted the unit, regression tests and integration test. Created and monitored the test case, defect ticket and test result in HP Quality Center.

• Configured project system and created WBS, posted amount to WBS and run the settlement

• Collected the Revenue Recognition business requirement and worked with ABAPer to create the Revenue Recognition program. Tested the Revenue Recognition program in all scenarios in SD, FI and COPA. Improved the performance of the Revenue Recognition program. Created the Revenue Recognition report. Set up jobs for the Revenue Recognition program. Provided the production support for the Revenue Recognition program.

• Configured jurisdiction code, input and output tax codes for US. Entered tax rate in different states for the account payable and account receivable.

• Configured new region codes, jurisdiction code and tax rate for the plant in Canada and location in foreign countries.

• Created tax report for sales and purchasing by adding Ship from Plant.

• Tested and fixed FI 999 split program for invoice and goods issue.

• Tested the program to populate the right the location in the documents.

• Created valuation class and account determination between MM and GL for the auto posting.

• Modified and tested the mapping among movement type, document type, and transaction type for populating the correct transaction type in the document.

• Fixed the problems that billing documents could not release the accounting documents.

• Corrected the mapping among profit center, format and customer group and tested program to populate the correct profit center in the documents.

• Created the revenue report for the failed invoice due to the IDOC error, so the accounting department can book GL entry for the month end closing.

• Solved the tax issue in Canada. Assigned the tax codes for non-taxable transactions.

• Updated new tax rate in Canada, and US..

• Worked with SD and MM to configure the inventory transfer between companies.

• Created production BOM, sales BOM and Video BOM in the DEV and QAR for testing. Crated inventory for some materials in DEV and QAR for testing.

• Changed the price for the material and created the cost run for the product costing in the testing.

• Created open GR/IR report with vendor information.

• Created the revenue discount report sorted by customer and condition type.

• Participated in the SAP implementation in Germany, Belgium, Netherlands, France, and British. Activated the Plant Abroad function in SAP and entered the VAT number for the plant abroad. Configured VAT for Germany, Belgium, Netherlands, France, and British.

• Created the substitution for Germany, Belgium, Netherlands, France, and England for the Revenue Recognition.

• Modified the Revenue Recognition program for Belgium, as the materials shipped to Belgium customers came from the Netherlands plant in Germany.

• Identified the missing triangle sale information in the triangle sale invoice and avoided VAT penalties for thousands of Euros.

• Tested and fixed MPM splitter in both FI invoice for gift set and FI document for goods issued.

• Configured product costing and conducted the test.

• Participated in SAP 6.0 upgrades testing.

• Solved the problem that accounting document could not be released from the billing for 999 split program.

• Configured Collection Management in the following areas:

• Defined the company code for Collection Management

• Defined Basic Rules, Collection Rules, Priorities, and Derivation of Priority in Collection Strategies.

• Defined Collection Segments, Collection Profiles, Collection Groups and Assigned Collection Groups to Collections Segments in the Organizational Structure.

• Created Element Type, Attribute Profile, Configured Text IDs, Created Text Profile, Status Profile, Number range Interval for Case, Case Type and Automatic Status Changes in Promise to Pay

• Configured Dispute Management with the following areas:

• Created the Case Record Model, Element Type for the Case Record, and Assigned Logical System to Element Type for SAP Business Object.

• Created Attribute Profile, Values for Attribute Priority, Value for Attribute Escalation Reason, and Assigned Escalation Reasons to Attribute Profile.

• Created Profile for Case Search, and created Function Profile.

• Created Tex Profile and Status Profile.

• Created Number Range Interval for Case.

• Defined Case Types, Created Values for Attribute Category, and Values for Attribute Reason and Root Cause Code.

• Entered Action Profile in Case Type in Correspondence.

• Defined Derivation of Element Types, and Automatic Status Changes.

• Defined the Default Values for Creation of Dispute Case and Edited Settings for the Automatic Write-Off Dispute Cases in the Process Integration with Accounts Receivable.

• Configured Biller Direct in the following area:

• Released Card Payment.

• Define payment Methods.

• Assigned payment Methods for Paying Bills through the Web.

• Assigned Text ID.

• Defined Partial Payment.

• Defined Setting for Payment Cards.

• Created the SAP training document and trained the users.

Jazz Semiconductor, CA May, 2005 – May 2007

Senior SAP FI/CO Analyst

• Was the only person in the company to do the configuration and provided the production support for SAP FI/CO module to the users in US and China.

• Implemented SAP for the subsidiary in China and UK by configuring the company code, General Ledger, Account Receivable, Account Payable, Fixed Asset, Special Ledger, Cost Center Accounting, Cost Element Accounting, Internal Order, Investment Management, Foreign Currency Valuation and Translation, Profitability Analysis, Product Costing and Travel Management. Created the training document and trained the users in China for SAP FI/CO.

• Created the internal order report with the information of original commitment, current commitment, PO, GR, IR, and Actual.

• Created the fiscal year variants for the different plan versions for internal order.

• Created the ABAP report to extract the AP information for the auditor.

• Created statistic key figure and cycle for the allocation.

• Created the ABAP query to extract the fixed asset information. Fixed the incorrect useful lifetime for over hundreds of assets.

• Created the report of balance sheet and income statement for the new company code by using the report painter.

• Created the program to upload the tax rate.

• Configured cost center budget planning and created a demo. Created new cycle for the cost allocation.

• Created many new financial statement reports by using the report painter.

• Created the new sets and modified the report based on the user’s requirement.

• Helped users to carry forward the balance to the new year.

• Trained users in the area of SAP account payable, account receivable, fixed asset, and general ledger.

• Created the expense report for each department to help company to control the cost.

• Created new fixed asset class and new depreciation key to allow the asset shut down.

• Assisted security to provide the correct access to users for SOX.

• Created new cost center groups and new financial reports.

• Created a new company code for the parent company after merging in the area of general ledger, account payable, account receivable, fixed asset, special ledger, cost center accounting, cost element accounting, and internal order.

• Created dimension, versions, ledger, global system setting, task group for the data monitor, methods for inter unit elimination. Product line maintenance, reclassification, document types for reclassification entries, task for reclassification entries, the task for the consolidation of investments, method for consolidation of investments, and assigned document types to combination of actives and accounting techniques in EC-CS.

• Conducted the year end closing by creating CO version for new year, factory calendar for new year, asset year end closing, asset year end change, carrying forward AP, AR, and GL balance, closing previous accounting period and printing out the 1099 MISC form.

• Provided the support to user to solve all kind of problems.

Kyocera International Inc. CA

Senior Application Analyst Oct. 2004 – May, 2005

• Configured business partner, product type, flow type, automatic account assignment, number range, swap rate, and document type for the foreign currency hedging in Corporate Finance Management sub-module.

• Created the scripts and training documents for the Corporate Finance Management by using InfoPak.

• Fixed the imbalance between the GL and fixed asset sub-ledger.

• Configured the foreign currency valuation and translation for the company in Mexico. Set up the variants for the foreign currency valuation and translation. Configured the valuation for the company codes in the United States. Created the training material and conducted the train to the users.

• Created general ledger accounts and primary cost elements for different company codes.

• Created and maintained cost centers and profit centers, cost center group and profit center group.

• Fixed the configuration problem in house bank.

• Created the ABAP specification for the sales commission report.

• Opened the new fiscal year and created the number range in FI. Conducted the balance carried forward for AR, AP, and GL. Closed the previous year for the fixed assets.

• Did the year end closing by creating CO version for new year, factory calendar for new year, asset year end closing, asset year end change, carrying forward AP, AR, and GL balance, closing previous accounting period and printing out the 1099 MISC form.

• Created FS items in EC-CS.

• Configured bank accounts and automatic payment.

• Created the Query for the report. Fixed the problems in the reports created by the report writer and report painter.

• Trained user on the Special Ledger posting.

• Created training material in FI/CO area and trained the users.

• Responsible to support SAP FI, CO area to the user in US and Mexico.

Health Net, CA

Senior System Analyst May, 2003 –Oct. 2004

Configuration

• Configured Company Code, General Ledger, Fund Management, Account Payable, Account Receivable, Fixed Asset, Bank Account, Special Ledger, Cost Center, Cost Element, Internal Order and Profitability Analysis. Created customer, vendor, fixed asset master data. Created Cost Center, Cost Element, Cost Element Groups, Internal Order, Internal Order Groups and PA.

• Conducted integration test from PO requisition to AP payment, fixed assets, inter-company transaction test, and workflow test.

• Configured the inter-company transaction.

• Configured the bank reconciliation.

• Configured the foreign country setting and region code. Created vendors in the foreign countries.

• Configured the withholding tax. Created 1099 report with IRS required format. Developed new validations and substitution.

• Configured Internal Order budget threshold.

• Developed and implemented data extract (AR,AP, FA) strategies relating to sale of companies.

Production support

• Responsible for the development of interface between real estate third party software to SAP.

• Responsible for Fixed Asset ledger reconciliation

• Created the document type for the interface between SAP and American Express.

• Developed a new Asset forecast depreciation report after analyzing the business needs.

• Created several validations and substitutions to meet the user requirements.

• Created the EFT report based on the users requirement.

• Created ABAP query to extract vendor, invoice and payment information.

• Responsible for fixing SAP delivered 1099 program to have it include the amount for the vendor with all withholding tax codes.

• Responsible for changing number to word for the amount on the check.

• Blocked the low value asset classes.

• Did the year end closing by creating CO version for new year, factory calendar for new year, asset year end closing, asset year end change, carrying forward AP, AR, and GL balance, closing previous accounting period and printing out the 1099 MISC form.

• Extracted the AP and PO information for the auditor.

• Responsible for fixing the overlapping and changing phone numbers on the EFT payment advise.

• Responsible for year end close and reconciliation of sub-ledger, such AR, AP and Fixed Asset.

• Added the maximum amount for the low value asset classes.

• Solved production issues in Fixed Asset, Account Receivable, Account Payable, General Ledger, Cost Element Accounting, Cost Center Account and Internal Order.

Sun America, CA

Business Analyst Oct, 2001 – May, 2003

• Responsible for defining the business requirements, analyzing the gap, writing functional specifications, and business process.

• Configured company code, tolerance group for employees and vendors, automatic payment program, house bank and travel management. Created general ledger master records, AP, PO, Commission, and one time vendor master records for over thirty company codes. Imported vendor master data from legacy system to SAP 4.6

• Separated the checks for different check run. Create variants for check printing and EFT. Configured the issue file, paid file and ACH file for EFT.

• Created the ABAP specification for the void check interface, policy disbursement report, 1099 report, and EFT report.

• Responsible for developing the interface between the PeopleSoft and SAP,

• Configured start condition for the parking invoice workflow. Created organization units and assigned users to organization units for the workflow.

• Responsible for the configuration and production support for Travel Management.

• Used ABAP query to create the vendor bank information report, check and EFT issued for the different vendors report, accounts payable spending analysis report, and internal audit policy disbursement report. Created the financial report by using the Report Painter.

• Created HR user master records. Changed the user profile.

• Created cost elements, cost center groups, cost centers, and internal orders.

• Created business process procedure training material for account payable, general ledger, and travel management.

World Kitchen, NY

SAP FI/CO Consultant March, 2001- July, 2001

• Solved the open issues accumulated from 1999 to update. Fixed the configuration problem. Wrote the ABAP specification for Accounts Payable Aging report, Accounts Payable Date Due Forecast, Account Payable Clearing/Payment Aging report, Wire Proposal Report, and Payment for Duplicated invoice Report.

• Changed soft error message into hard error message for the duplicate invoice entry.

• Created payment terms. Configured GR/IR account in FI and invoice verification in MM.

• Configured down payment, cross company transaction, and bank partner profile for EDI.

Sameday.com. CA

Finance Functional Specialist Sep., 2000 – March, 2001

• Upgraded SAP 4.6B to 4.6C. Conducted the integration test from MM to FI and SD to FI/CO.

• Configured Fund Management, Accounts Receivable, Account Payable, General Ledger, Fixed Asset, Cost Element Accounting, Cost Center Accounting, Profit Center Accounting, PA and PC and Internal Order. Created BPP and trained users.

• Configured down payment for the account receivable, created training material, and provided training to end user.

• Created the Profitability Analysis reports for the corporate and different logistics by using report painter.

• Created G/L accounts, assets classes, cost elements, cost centers, cost center groups, profit centers and profit center groups. Assisted accounting department running the assets depreciation, monthly end closing, and yearly allocating the cost, and creating financial statement.

• Modified Financial Statement Version. Provided daily technical support to sales and accounting department.

PPI. CA

SAP FI/CO Lead Jan.,1998-Sep.,2000

• Defined project scope, analyzed gap, designed, configured and tested SAP FI/CO.

• Went through 2 full life cycle of SAP FI/CO implementation.

• Configured the company code, fiscal year variant, lockbox, House Bank, foreign currency exchange rate and valuation, GR/IR clearing account and automatic clearing.

• Created G/L master records and configured cross company code transactions, line item display, and open item processing for G/L.

• Configured terms of payment, incoming and outgoing invoice, incoming and outgoing payment, clearing open items, automatic payment and dunning program for the client.

• Uploaded vendor and customer master records from the legacy system to SAP.

• Configured the Fixed Asset: Chart of depreciation, assets class, depreciation area, fiscal year variant, number range, substitution rule in the fixed asset master records.

• Created cost elements, cost elements group, cost center, cost center group, cycle, internal order, profit center, and profit center hierarchy.

• Successfully tested critical business transactions in the finance module, including vendor and customers invoices and payments, document fast entry, G/L posting, and recurring entry programs.

• Conducted integration test from MM to FI and SD to FI. Created BPP and trained users.

• Maintained Operation concern and assigned it to control area. Created value fields and characteristics and linked value fields with cost element groups and condition types. Completed the automatic account assignment. Created the number rang e for the planning and plan and actual posting. Created the COPA report by using Report Painter and Writer.

• Configured Production Cost in the following areas: Defined percentage overhead, costing sheets, overhead keys, costing types, valuation variants, date control, quantity structure control, goods received valuation for order delivery, results analysis keys and created settlement profile. Activated the valuation area for material ledger and actual costing.

• Created training documents and conducted training.

EDUCATION

MBA, Grambling State University, Louisiana, USA. November 1991.

Bachelor of Science, Electrical Engineering. Shanghai University, China. Feb. 1982.

SAP TRANINING

• AC010 Financial/Management Accounting & Report, AC225 Account Receivable,

• AC 226 Account Payable, ASAP91 SAP implementation,

• AC205 Integrated Financial Closing, AC 305 Assets Accounting,

• AC040 Cost Management and Controlling, AC 405 Overhead Cost Controlling,

• AC 705 Report Painter, AC 710 Report Writer.AC220 Special Ledger

• HR050 Human Resource, AC270 Travel Management

• PERSONAL US citizen

Contact this candidate