SAP FICO Consultant

High Wycombe

Shemhon has over ten years of experience in Finance. He has over five years of SAP FICO experience and is certified in FI and also studied Product Costing and Profitability Analysis at the SAP training centre. Shemhon has broad experience of finance business processes; he has worked on requirements analysis, process mapping, design and configuration of all major FICO modules such as AP, AR, AA, Bank Accounting, CCA, PCA, IO, Product Costing and Profitability Analysis. He has worked on all stages of SAP project delivery from business blueprint and realisation through to go-live/post go-live support, focusing on exceeding his clients’ expectations. A seasoned professional with strong communication and personal management skills, developed over the years as both a consultant, team lead and solution architect. Experience gained across several industry sectors for both multi-nationals and Small/Medium enterprises He has worked on numerous projects in the retail, manufacturing, electronic and consumer products sectors, and recent employers include IBM, Deloitte, HCL Axon, Heineken, Siemens and CSI.

Key Skills
  • Master Data
  • General Ledger
  • AccounProfitability Analysis
  • Product Costing
  • Asset Accounting
  • Bank Accounting
  • FSCM
  • VIM
  • Open Text
  • Internal Orders

Work Experience

SAP FSCM/FICO Global Design Lead (TAO) IBM

British American Tabacco 3.5 Years

Job Description: FICO/FSCM Global Design Authority/Solution Architect TAO (DG3 to DG5) Implementation and Design of the global FSCM/FICO template through Europe, ASPAC, Americas and African regions Credit Management, design of Credit segments per market and the relevant check rules and steps to facilitate accurate credit blocking and subsequent release of blocked sales orders Credit Limit increase via CLR process or via a new development programme for mass update of the credit limits Collection Management, Collection segment creation and assignment, collection strategies, collection groups and collection profile design. Dispute Management, reason codes and config and design of the process and how to action and create disputes per invoice and the reporting. AR clearing programmes, different programmes created per market requirements for external and rep customers SAP ECC and TM&D interfaces, Inbound and outbound interfaces (multiple) depending on markets. Inbound interface of collection data being sent to SAP and clearing/posting depending on market. Outbound data being sent to TM&D, payments via bank, boleto and any other changes to master data. Also disputes and clearing information for Eastern Europe and African markets. All interfaces via IDOC and PI processs. Dunning procedures and dunning rules set up for some relevant markets, including development of letters Customer Statements functional design across a number of BAT End Markets Creation of invoice layout for postings outside the sales order process SAP VIM design, build and test, with offshore team (open text) Managing the delivery of all the CSD/CVD and functional designs across all the markets and impact assessing all CR’s for FICO and FSCM Working with off shore team and managing the Global and regional teams to organise and effectively deliver all outstanding items on time and the testing of these Dealing with all defects, incidents, change orders to do with FSCM/FICO and managing accordingly Overall in charge of every aspect of design and implementation of FSCM/FICO design and build Worked on Product Costing, bank and asset accounting through WER deployment (DG2 and DG3) Asset accounting configuration which including all relevant configuration of classifying asset classes, the migration of data (master data and transactional data). Creation of Asset classes and relevant account determination, depreciation method and keys Overview of Data Migration activities from FICO and FSCM with data team for all markets, both master and transactional data.

SAP FICO Consultant/Contractor CSI

Swisslog/Renold/Dungs 5 months

Job Description: Working with Sap Delivery team for Swisslog, Renold and Dungs which are clients of CSI. The job entailed new implementation at Renold, UK Rollout for Swisslog and Dungs Implementation of various Finance and Controlling related configuration work GL Account mapping exercise with Legacy system and creation of company code GL accounts from existing global chart of accounts. AP/AR configuration and VAT settings for Swisslog and Dungs Configuration of Bank Accounting process, house bank set up, setting up of the automatic payment run and electronic bank statement reconciliation process for Swisslog Developing Global template to incorporate UK Localisation and legal requirements for the Swisslog and Dungs UK roll out projects. Fixed Asset configuration, setting up the chart of depreciation, depreciation areas, asset classes, account determination, depreciation key and all other related configuration for Swisslog and Dungs Created LSMW for data migration of the Fixed Assets and all related reconciliation of the upload Swisslog Configuration of the intercompany process via EDI. Cross Company Sales via sales order and Stock transfer via purchase order, which would result in Idocs being created and processed also configured the intercompany reconciliation process for Renold Worked on changing the existing product costing solution from changing WIP calculation from Standard to Actual costs for Renold Worked on preparing all the relevant documentation, Blueprinting, Customising and Testing throughout the various projects. Prepared training material and delivered the training sessions for Swisslog and Dungs.

SAP FICO Consultant/Contractor IBM

ESB – Electricity Supply Board (Dublin)3 months

Job Description: Working with Sap Delivery team for ESB, which is a client of IBM. The job entailed clearing a backlog of Support and configuration and any adhoc work. Provided BAU support for current SAP ECC 6.0 implementation, support provided for FICO, PS and MM/SD Managing the SLO process making sure all calls were dealt with in a timely manner and all configuration related calls had to created in Quality Centre and dealt with appropriately Interpreting, scoping and implementing any new business requirements Managed the unit testing, UAT and regression testing for any changes/transports implemented Looked after any workflow issues that arose, if items were not reaching correct user or if users leaving company all workflow items had to be redirected to a substitute Created some new reports using report painter (GRR1) and changing existing reports which needed new columns or new cost element sets added (GS02) Setting up of the foreign currency revaluation process for open items and Bank GL’s as a scheduled job Running workshops on Fixed Assets and gathering business requirements for changing the current asset classes to fit reporting requirements, new asset classes created, existing assets transferred by creating LSMW for tcode ABUMN Configuration of the account determination for the new asset classes Configuration of new company codes with basic functionality and GL posting and reporting

SAP FICO Consultant/Contractor

Airtanker Ltd (RAF Base Brize Norton) 1.5 Years

Job Description: Working with the SAP Delivery team for the client of HCL Axon. The client was Airtanker LTD, which is part of the RAF. Airtanker are building brand new planes for the MOD. The job entailed leading the finance team through the SAP solution and configuring/testing phases and through to Go-Live. Configuration of GL – Worked on all aspects of the GL configuration including setting up of the company codes, chart of accounts, master data uploads, fiscal year variant, VAT codes, number range assignment setting up of field status groups, setting up of entries in table TKA3C and OBYC Material Management automated entries and all other related GL configuration. Configuration of Asset Accounting Module – Defining all the asset classes, depreciation area, integration with the general ledger and all associated automated postings to the relevant GL accounts, creating and assigning depreciation key and upload of existing assets onto SAP via LSMW. And all other asset accounting configuration. Configuration of AP/AR – Helped with the upload of customer and vendor master data via LSMW, creation of Payment method and Payment terms, configured the automatic payment programme and all other related configuration Configuration of Bank Accounting – Creation of Bank Master data, manual and electronic bank statement configuration and all other related configuration Configuration of Cost Centre Accounting and Cost Element Accounting – Setting up of all the cost centre and cost element master data within the system and all other related set up and configuration. Worked on bespoke billing solution, where the MOD had to be billed for the usage of the plane, set up condition types, item proposal and pricing procedure for sales order. Intercomapany Billing set up for automation during billing run. Prepared functional specs for interface with other systems via PI so the invoice was sent electronically to the MOD and there P2P system and messages sent back and forth through PI. Preparation and setting up of the product costing solution Configuration of costing sheet, valuation and costing variants Overheads, activity prices (KP26) and standard cost estimate settings Trained users on how product costing works, how to run the cost estimate plus variance analysis Developing all training materials for users. Ran training session for the users for all sub modules as above, helped create all the documentation and facilitating all training sessions Prepared the functional design and implementation of a complicated billing process. The MOD had to be billed once a month for the usage of the planes either booking time or flying hours. To get the time we had to have a number of interfaces with other software and the invoice would be sent electronically to the MOD via PI After Go-Live provided all the support early life support for the FICO modules, making sure all SLO calls were dealt within time and all configuration was documented and carried out Preparing the design of new depreciation calculation, where the planes have the depreciation calculated via number of flying hours per month rather than straight-line depreciation. Created new Asset Classes, and new depreciation key assigned the assets to the new asset classes via LSMW. The number of flying hours would be entered in tcode A025 for the new depreciation key on a monthly basis.

SAP FICO Senior Consultant

Meggitt (UK company project in USA)8 months

Job Description: Working with Meggitt a client of Deloitte in the US to make changes to the product costing solution to conform to current US CAS requirements. Capturing Business requirements and performance criteria, translating into functional and/or technical specifications for enhancement to the current Product Costing Solution. Understanding of the global template of the product costing solution and the current design. Led the workshops in the USA for CAS Business units to gather all business requirements and document these Did a fit gap analysis between the requirements and the current global template. After workshops prepared a presentation of the findings and possible recommendations and solutions to the problem - Meggitt had final call on which solution to implement. Worked on enhancing the product costing global template design to incorporate the new solution of allocating the variances back to cost objective to mimic an actual costing solution Material Ledger was discussed as a possible solution to the issue in the workshops and possible configuration shown to users Led the team to implement the deloitte solution in the USA for one of the sites in scope which included the standard costing solution and the enhancement.

SAP FICO Consultant

Heineken UK2 Years

Capturing Business requirements and performance criteria, translating into functional and/or technical specifications. Implemented the product costing solution for their Bulmers Plant. This included configuration of costing sheet, valuation and costing variants. For new plants defining overheads, costing sheet and standard cost estimation settings Data Migration using LSMW to take on/off all customer invoices due to change in customer reconciliation accounts this was done using table downloads (BSID) Configuration of new fixed asset classes and new account determination. Transferring a number of assets from one asset class to another using Table downloads (ANLA, ANLB etc) and then uploading using Tcode ABUMN via LSMW recording Uploading new and changes to Cost Centres (KOSTL) and GL Accounts (SKA1, SKB1) using LSMW across a number of landscapes. Configuration of new Company Code, all FI and CO related customizing and set up. Including Global Parameters and assigning Chart of accounts, chart of depreciation fiscal year and posting period variants, number ranges and banking set up including all programme variants for batch jobs. To complete unit and integration testing of work products in line with agreed processes ensuring completion within allocated timescales. Developing training materials and delivering key user training for all new or enhanced application functionality. Working on major ongoing projects such as Heineken Integration, Project SCOA (Standard Chart of Accounts) and CCCS (Common Cost Centre Structure), work involved aligning S&N COA and Cost Centre structure with Heineken Global as well as other business process such as Fixed Asset (Asset Classes & Account Determination). Creating LSMW’s for AR and AP reconciliation account change (Take on and off). Change in hard coding of GL’s and CC’s in programmes. Aligning master data across landscapes via table downloads and LSMW uploads. Working on other smaller ad-hoc projects when needed, such as change in Cost Centre hierarchy preparing LSMW change of 15000 Cost centre changes. Adhoc 3rd line support requests too complicated for 2nd line support such as COPA derivation issues & configuration changes to TKA3C and table T030 entries.

SAP FICO Consultant

Siemens Eng Pakistan12 months

Configuration of all major FI modules including; SAP FI General Ledger, Accounts Payable, Accounts Receivable, Bank Accounting and SAP Asset Accounting including Fixed Assets. Fixed Assets Master Data and Legacy Data Transfer Fixed Assets Organizational Structures and integration with the General Ledger Fixed Assets Valuation, Depreciation and Configuration of the Depreciation Area, Depreciation Key, Asset Classes etc. Legacy Data transfer and Master Data Configuration of all major Controlling Modules Including; Cost Centre Accounting, Profit Centre Accounting, Product Costing, Internal Order Accounting and Profitability Analysis including profitability reporting. Cost Allocations using distribution and assessment cycles Business Key User and End User Training Legacy Data and all Master Data uploads Working closely with ABAP team for preparation of reports Reconciliation work on all the data making sure all figures are accurate and the Legacy system matches SAP. Go Live and Support Ad hoc issues and queries

Financial Analyst/Project Accountant

Dresdner Klienwort 3 months

To assist Finance in setting the budget/forecast globally To act as financial representative for Finance operating cost issues in London To co-ordinate and submit monthly Fixed Asset Reports Globally To liaise with finance globally re cost issues To review and control the mandatory, discretionary and strategic initiative IT project spend To co-ordination and submission of monthly recovery reports for London and globally To continually develop and review budget, actual and variance reporting and transparency To liaise with Front Office and Finance to understand and explain service delivery and cost allocation Ensure monthly review and reconciliations of all balances in London

Financial Analyst/Project Accountant

Credit Suisse2 Years

Manage London Fixed Asset Controller Manage relationships with Asset Controllers from other areas of the firm - New York, Singapore, Switzerland and Global. Assist with specific asset related accounting projects (e.g. Data Centre Accounting, Bulk Purchase, Cost Transparency etc.) Oversee Capital and Depreciation budget for IT assets Ensure all Fixed Asset reporting is inventively designed to allow easily repeatable reporting that is transparent Updating and communication of policy changes Assist in the development of asset reporting on behalf of Infrastructure product owners Perform "bulk retirements" as needed Depreciation monthly projection Check depreciation pools before and after allocation run Depreciation movement reporting Investigate exceptional items and account for entries within projection Review projection vs. actual depreciation Fixed Asset Monthly Reports for Directors and Product Owners Quarterly Depreciation Budget transfers Quarterly Depreciation Forecast Annual Depreciation and Capital Budget Ensure the fixed asset invoices flow through accurately and correct any exceptions Manual Upload of all IDS and Bulk Purchase Deployments into Peoplesoft GL. Responsibility for maintaining Fixed Asset Register Unitization of fixed asset registers Enable legacy organisations to use the same process for capturing fixed assets

Financial Analyst/Project Accountant

Lehman Brothers3 Years

Responsibility for maintaining Fixed Asset Register and preparing monthly journals Statutory accounts preparation for a number of companies both Securitised and Non-Securitised for the external Auditors Preparation of Bad debts and Possession Movement Reports Assisting the Management Accountant in analyzing the various overhead costs in the production of the Management Accounts Preparing a Capital Expenditure report for our Parent Company Daily reconciliation of the Mortgage Assets, monitoring the change in pool values and change in merged funds codes. Thus making sure treasury cashbook postings are accurate Preparing Marketing Allowance Reconciliation & liaising with Marketing Director and MIS Manager Liaising with Lehmans during the SOX process Preparing the Fee income report for internal use Preparing the Overhead servicing analysis report for company Directors Extracting data from Access Database which included linking tables and writing queries using basic SQL in relation to the bad debt model for month end Importing the fixed asset register from Excel to Great Plains using basic Excel macros Responsibility for Redemption Interest postings Responsibility for paying Securitisation Invoices (Trustee Fees, Rating Agency Fees etc) and coding thereof