Lorraine Jin Wang, CPA, CGA
********@*******.***
Profile
CPA, CGA of Canada and FCCA of the UK
* ***** ********** ** *** FICO consultant in different industries
Successful design, configuration, testing, conversion, training, support and bug-fix of 2 full life cycle implementations in SAP FICO (GL, A/P, A/R, AA, CCA, IO, CO-PA and CO-PC)
Comprehensive knowledge in merger and acquisition accounting in regards to consolidated financial statements preparation
Good working knowledge in SAP SD
Strong skills in financial reporting, project analysis, budget planning, financial analysis, cost accounting, business analysis and management support
Work experience with large corporations including Deloitte & Touche LLP, Bechtel Inc. and General Motors
Excellent computer skills in MS Excel and Access and good SQL skill in writing queries
Strong team player, highly motivated and excellent organizational and analytical skills Technical
Extensive experience in configuration and testing of FICO modules - GL, AR, AP, Fixed Assets, Cost Center Accounting (CO-CCA), Internal Orders and Profitability Analysis (CO-PA), Product costing (CO-PC) and Special Purpose Ledger
Integration of FI with MM and SD with Procure to Pay and Order to Cash cycles
Reporting tools like Report Painter, Report Writer
Through understanding of a customized SAP system from business process, cross functional and integration view points
In-depth knowledge in configuration, implementation, ASAP methodology, system design and development and gathering user requirements
Experience in Blueprint, Configuration, User Acceptance and Integration Testing, Training, Documentation and Production support
Special emphasis on Data Migration specifications with BDC, Legacy System Migration Workbench
(LSMW) for data uploads for various SAP Projects
Active member in conducting the team meetings, customer feedback meetings Work Experience
SAP FICO Consultant
Client: A Capgemini project – CHEP Logistics Limited in Shanghai Oct 2016 – Nov 2016 Project Task: Rollout of Chart of Accounts; preparation for implementation of New General Ledger
Identify business requirement, discuss requirement details with client and understand the business process for solution design
Design business blueprints based on the business requirement analysis, identify gaps between local office and head office in Australia and co-ordinate with head office to find timely solution
Review system design, analyse and prioritize workload and meet assigned deadlines
Review local COA and map to global COA, validation of global COA GL accounts, prepare SAP UAT scenario list
Review COA implementation plan and UAT test scope and test scripts
Implement configuration testing and user acceptance testing regarding COA rollout
Coordinate with SD and MM modules for SAP configuration and integration
Streamline of business process by documentation of COA rollout
Conduct knowledge transfer and end user training SAP FICO Consultant
Client: North Locomotive and Rolling Stock Industry Corp of China Jan 2014 – Nov 2015 Environment: SAP ECC 6.0 FI-GL, FI-AP, FI-AR, FI-AA, CO-CCA, CO-IO, CO-PCA, CO-PA
Identify FICO business requirement, discuss requirement detail with clients and understand the business process for solution design
Design business blueprints based on the business requirement analysis, identify gaps in the FICO area and provide timely solutions
Review system design, analyse the jobs needed to be written or revised, analyse and prioritize workload and meet assigned deadlines
Design, implement and configure various components of SAP FICO
Implement SAP FICO configuration testing and user acceptance testing
Coordinate with SD and MM modules from a functional perspective for SAP configuration and integration and ensure implementation of SAP best practices
Streamline of business process by documentation of the SAP FICO configuration
Assist with month end and year end FICO system closing
Conduct knowledge transfer and end user training
Conduct daily FICO technical support, provide guidance on the use of systems and troubleshoot issues
SAP FICO Consultant
Client: North East Grid Corp of China Oct 2012 – Sept 2013 Environment: SAP ECC 6.0 FI-GL, FI-AP, FI-AR, FI-AA, CO-CCA, CO-IO, CO-PCA, CO-PA
Discuss with the key users to study and understand the existing business procedures and document the “As-is processes”
Design business blueprints based on the business requirement analysis, identify gaps in the FICO area and provide timely solutions
Map the processes onto the SAP system and also prepare the “To-be processed” document
Configure the FI and CO settings and test the settings on the development server and transport the settings onto the testing server for user testing and confirmation, and transport into the production server after user confirmation
Create reports on AR and AP by giving functional specifications to the ABAP team for development
Data upload by using ABAP designed BDC programs, account assignment modules & LSMW
Document the processes using standard templates
Conduct knowledge transfer and end user training, conduct daily technical support Senior Financial Analyst
Deloitte & Touche LLP Toronto Jan 2006 – June 2012
Prepare accounts analysis for financial statements, analyse financial statements and interpret financial performance measuring and financial position
Analyse and evaluate financial performance and financial results, make recommendations to assist senior management in decision making
Interact with the firm CFO and partners on budgetary and meeting issues, prepare budget plan, variance analysis and forecasting for the firm to ensure the budget is complete and accurate
Plan, co-ordinate and implement big inter-firm integration projects with Deloitte IT department and head office in New York and execute User Acceptance Testing on interface projects
Implement process improvement by developing numerous analysis models to examine company’s projected short-term and long-term growth based on key indicators, sales projections, cash flow analysis, assets, liabilities, and credit risks
Identify, develop and interpret the firm’s financial policies and procedures and recommend modifications to improve internal control and risk management
Co-ordinate with billing partners to ensure timely billing to clients and ensure proper revenue recognition every period
Coordinate with Deloitte head office in New York and offices across Canada on financial planning relating to inter-office projects and reconcile inter-office billing statement Education
CGA of Ontario 2010
SAP FI/CO and SD Consultant training 2010
Bachelor Degree of Accounting China