SAP FICO

ARSHAD RAZAK

SAP FI-CO CONSULTANT

Phone: 773-***-**** Email:****.*****@*****.***

Professional Summary

More than 8 years of experience in implementing SAP with an emphasis on FI/CO modules this includes 2 full life cycle implementations with hands on experience in support and up-gradation projects.

Excellent Financial Accounting expertise in configuring General Ledger Accounting (FI-G/L), Special Purpose Ledger(SPL) Accounts Payable (FI-AP), Accounts Receivable (FI-AR) and Asset Accounting (FI-AA), New General Ledger especially in highly complex business environment.

Hands on experience in all phases of a Project Life Cycle Including Analysis, Design, Development, Testing, and Deployment of Solutions, as well as Documentation, and End-User Training.

Experience in SAP Treasury - TR: Cash Management, Treasury Management, CML Loans and Market Risk Management, Money Market, Foreign Exchange, Derivatives and Securities.

Expertise in different aspects of a business relating to FI-GL Transactions, Inter Company Transactions, House Banks, DME, Payment Terms, Cash Discounts, Automatic Payment Programs, Incoming payments, Partial and Residual payments, Defined check Lots and Void reason codes, Clearing Inter-company Vendor/Customer Open Items, Reconciliation Accounts, Document Split, Lock Box (BAI2), Dunning, and Assessment & Distribution Cycles..

Hands on experience in up gradation from 4.7 to ECC 6.0. Expert in data migration from Classic GL to New GL

Ability to work as a SAP techno-functional consultant with sound knowledge in ABAP Queries and Reporting Tools: Report Painter and Report Writer, User-exit programming and LSMW.

Possess extensive knowledge in configuring sample document, Recurring entries, Automatic Account Determinations, Customer and Vendor down payment, Revenue Recognition, Foreign Currencies valuation, Input/output Tax and Withholding Tax, Interest calculation, Automatic clearing (Customer, vendor,GL), Company code global parameters.

In Tax accounting, creation of Input and output tax General Ledger accounts, setting up different tax codes in various countries and assigning them to GL accounts. Resolving user queries in Tax posting journal entries.

Extensive experience with SAP interfaces in the FI and CO areas that include bolt-on products such as Vertex/ Taxware/Sabrix tax and Payware for credit card managements.

Finance integration expert in the area of Vendor Invoice Management, Travel Expenses and project controlling.

Controlling expertise includes Cost element accounting (CO-CEA), Cost center accounting (CO-CCA), Statistical key figures (SKF), Profit center accounting (CO-PCA), Internal orders (I/O) and Budgeting, Profitability Analysis (CO-PA), Product Costing (CO-PC).

Hands on experience in configuring e-invoicing in SAP and prepared training materials for end users.

Manage testing resources, test case sequencing, gathering of required test data files and other test coordination activities.

Business requirement collection, Industry Solutions (IS), ERP project analysis, process design, blue print, GAP analysis, Q & A database, design, upgrade, Reports, conversions, Interfaces, enhancements, Go-Live and Support and train user staff.

Can lead others by enabling them to achieve and develop while successfully delivering within the project environment.

Demonstrated ability to work both in independent and team-oriented environments with well-developed organizational skills, excellent communication and interpersonal skills with problem solving ability.

Ability to take on challenges and strong determination towards meeting deadlines.

Technical & Software skills

ERP

SAP R/3 Version 4.7, ECC 6.0

SAP

Financial: General Ledger, Accounts Payable, Accounts Receivable, Asset Management, Lockbox, Sales and Distribution, Material Management, Automatic payment program, Customer and vendor down payment, Dunning, Revenue Recognition, Foreign Currencies valuation, Input/output Tax and Withholding Tax, and Month End Close.

Controlling: Cost Element/Cost Center Accounting, Profit Center Accounting, and Internal order, Profitability Analysis, Product Costing.

Integration: FI/CO integration with SD & MM module, HR & AP integration.

Technical: LSMW, ECATTS, Report Writer, Implementation: ASAP Methodology.

Application

MS Word, MS Access, PowerPoint, Excel

Platforms

Dos, Microsoft Windows 95/98, 2000/XP, Vista, Windows 7.0/8.0

Testing

HPQC, QTP

Professional Experience:

L’Oréal USA, NY Feb 2015 – Sep 2015

SAP FI Consultant SAP ECC 6.0, Production and Support

For more than a century, L’Oréal has devoted itself solely to one business: beauty. It is a business rich in meaning, as it enables all individuals to express their personalities, gain self-confidence and open up to others.

Configured Ariba e-invoicing solution and integrated to Readsoft in SAP Process director.

Responsible to understand the company’s business process and gather the test requirements with the process owners.

Involved in testing of overall business process of P2P & integration.

Involved in the gathering the initial requirements from the end users and coordinated with the offshore team.

Analyzed Product Requirements, Business and System Requirements and also Participated in the inspection (walk through).

Trained key users to upload invoices through PDF, EDI and web portal in Bill Manager.

For each vendor ensure that master data is updated with Fiscal ID, bank account details, alternative payee and partner function.

Tested Outbound and Inbound Idocs. Involved in end-to-end testing of all inbound and outbound processes.

Trained end users how to use work cycle to communicate work flow massages, approving work flow and updating workflow status.

Tested the functionality of Incoming and Outgoing Payments. Automatic vendor/customer payments, payments proposal creation and validate the result.

Have provided on call support executed the Test Cases Manually and reported the defects to Developers.

Created and documented test plans and Generated test scripts and test data for functional and regression testing, Unit testing & UAT.

Charles River Laboratories Inc, MA Oct 2014 – Jan 2015

SAP FICO Consultant SAP ECC 6.0, Implementation and Support

Charles River Laboratories, Inc. is an American corporation specializing in a variety of pre-clinical and clinical laboratory services for the pharmaceutical, medical device and biotechnology industries.

Responsibilities:

Activated New G/L, leading ledger and parallel ledger for the possibility of parallel accounting according to the US GAAP.

Maintained accounting for various types of Special G/L accounts.

Defined Costing sheets for calculating Over head (percentage based over head calculation).

Extensively worked on Costing run to cost, mark and release multiple materials at same times.

Created Internal Orders for different order types, Planning profile, Settlement Profile, Settlement Rules and month end settlements to various cost and profit centers.

Helped in configuring necessary changes to reconcile PCA to COPA for P&L accounts including modification of COPA user exits, and creation of new field status groups.

Designed and developed contribution margin reports in CO-PA based on a combination of characteristics using Report Painter and Report Writer.

Used FSCM to employ tools to analyze credit worthiness and establish policies. Enabled customer access to invoices, account status and payment information over the internet.

Configured Standard Cost estimates in Cost object controlling for the orders with Quantity Structure and Configure for WIP Calculations and variance calculations, maintained settlement

Maintained Lockbox configuration for automatic incoming payments, Cash Management, Planning levels in Treasury and EDI & Month End Closings.

Provided support for Configuration, Implementation and Testing of the customer master records and incoming payments, Banking & Intercompany transactions.

Provided End -User training and prepared Documentation for the end-users.

W.W. Grainger, IL April 2013 – Aug 2014

SAP FICO Consultant SAP ECC 6.0, Implementation and Support

W. W. Grainger Inc. is industrial supply company founded in 1927 in Chicago. Grainger's catalog includes such offerings as motors, lighting, material handling, fasteners, plumbing, tools, and safety supplies.

Responsibilities:

Worked in Production Support in Finance (FI), Controlling (CO) & Asset Accounting (AA) and responsible for resolving all IT issues relating to FI, AP, AR, PCA, CCA, CO-PA and CO-PC.

Created unit and integration testing with users, documented baseline approved test scenarios to be in compliance for J-SOX, evaluate User Exits for Inter-company and Export shipments and overall ITSS Finance development/applications/enhancements for new merger.

Documented blue-prints for new company code and configured the system for implementation of CO-CCA, CO-PCA, CO-PA, CO-PC; responsible updating for Finance Work plan for new company code.

Made changes to reconcile PCA to COPA for P&L accounts; also includes modification of COPA user exits and creation of new field status groups. Involved in yearend closing operations for FI, CO and AA; also responsible for opening and closing for MM and FI monthly periods for postings.

Worked with Customer Logistics Team and gathered requirements for applying Routines and Sub-routines during sales order creation for Credit checks for different customer risk categories and Pricing Conditions.

Presented Order to Cash/Procure to Pay business scenario in highlighting FI integration with SD and MM

Coordinate and document global and regional SAP Cutover requirements and cross-team dependencies across.

In GL, responsible for setting up of Chart of Accounts, creation of general ledger accounts, setting up of inter-company relationship and creating inter-company accounts

Working with end users to explain Average Costing, Intercompany Transactions, Payment Medium Workbench (PMW), Special ledger functionality and itemize differences between the old functionality and new functionality.

Involved in Migration of data from Classic GL to New GL through different phases of migration cockpit.

Interaction with user and client to understand there requirement and concern over existing system to identify system improvement points.

Creation of Asset Classes, Asset Number Ranges, Account Determination, and related settings.

Configured new Asset Classes as per user request, resolved month end and year end issues for Asset Accounting, balance carry forward for FI- AA reconciliation, supplied transactional data from SAP tables for Asset Audit, Period Rules creation in different company codes and resolved Asset Issues.

Designed, configured, and tested Cash Management and Transaction Mgr (FX, Money Market, Securities and Derivatives Instruments), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic Bank Statement, Lockbox.

Experience in creating business transaction type and an item type to handle VAT. Configuration for Withholding Taxes 1099 Federal and State Tax reporting and 1042 Foreign Vendor/ Non-Employee Reporting.

Configuration for Withholding Taxes 1099 Federal and State Tax reporting and 1042 Foreign Vendor/ Non-Employee Reporting.

Configured Rules for the Vertex Tax Decision Maker (TDM) to handle Customer Tax Exceptions, Product Tax Exceptions and Jurisdiction Exceptions.

Assisted Tax department in customization of Vertex Sales Tax Returns (STR) towards auditor and IRS requirements.

Worked closely with MM consultants for integration of FI-MM using MIRO (invoice verification) and MIGO (goods receipt).

Configured SD Condition records in COPA by creating access sequence, tables, condition types and mapping of these value fields to SD condition types and assigned pricing procedure in COPA.

Xcel Energy, Minneapolis, MN May11’ – Feb’13

SAP FICO Consultant SAP – ECC 6.0, Full Life Cycle Implementation

Xcel Energy Inc. is a utility holding company based in Minneapolis, Minnesota, serving more than 3.3 million electric customers and 1.8 million natural gas and oil customers.

Responsibilities:

Worked on all the phases of implementation from development of Business Blueprint, As-Is study, To-Be analysis, GAP analysis, Post Implementation support, End User training (Job-Aid) and (Modified design after feedback from users to suit their requirements) GO LIVE.

Designed and blueprinted a specialized In-House Cash (IHC) solution for centralized payments and inter-company settlement.

Established repeatable detailed cutover plans and drove governance through multiple SAP implementations including all Supply Chain, Finance/Costing, Recruit to Retire, SRM, and numerous SAP modules.

Configured Company codes, Chart of accounts, Fiscal year variant, Tolerance limits, financial statement version, G/L accounts for company codes, business area, functional area, currency type, AR, AP, EDI, Banking, Workflow variant and screen layouts.

Using DART to periodically extract and retain tax relevant data from active SAP applications.

Responsible for configuration & settings of ERS to reduce errors relating to Invoice Verification and to eliminate price & quantity variances.

Worked on 1099 vendors reporting, Down payment, check form and EDI outbound and inbound

Maintained various criteria’s in the Evaluated Receipt Settlement program - Transaction Criteria, Invoice Criteria & Test Mode.

Provided production support for all the issues involved in AP, AR, G/L, Treasury - Liquidity Forecast & Cash Management, Disputes, Collections, Month End Closing, Special G/L & ERS. Reported weekly on support ticket numbers and solution turnover time.

Created contribution margin and user defined profitability reports using reporting tools like Report Writer & Report Painter and conducted ABAP queries as and when needed and trained users for the same. Also worked on LSMW for data migration.

Configured House bank, Bank determination and set tolerances limits, scheduled Automatic Payment Program for payments to vendors and others, created check lots and online cashed checks. Configured Lockbox settings for incoming payments as per the BAI2 format and cash management including cash concentration, wire transfer settings and ACH payments.

Defined Controlling areas within the company, assigned number ranges to controlling area, maintained versions, maintained Budget Profile, Planning Profile and Planning Versions in controlling, created various Cost center and Profit center hierarchies, CO object assignments, Substitution and Validations.

Configured Primary & Secondary Cost Elements, created Cost Element Groups and Assigned Number ranges to groups, configured Automatic and Manual cost element creation.

Configured CCA through creation of Cost Centers, Activity Types, Cost Center Categories, Statistical Key Figures, Assessments & Distributions cycles and Allocations for periodic reposting, Planned and Actual activity price calculations.

Configured EC-PCA by creating Profit centers, Standard hierarchies, assigned revenue elements, to profit center, planning profile and planning layouts.

Defined Internal Order for different order types, maintained Settlement profile and Settlement structure. Configured Budgeting and Planning for internal orders. Defined settlement profile, settlement structure, settlement rules and cost elements for internal order settlements.

Defined Activity Types and Statistical Key Figures for calculation of over heads and maintained number range for different operations being performed.

Modified the copied template operating concern to accommodate client requirements with new characteristics and value fields. Defined derivation structures and rules for customer characteristics.

Configured Operating concern attributes and the COPA Settlement Structure with the settlement rules to populate the values in the value fields in COPA.

Defined costing sheets for calculating Over head (percentage based over head calculation).

Configured Material Cost Estimate with Quantity Structure, costing variant, cost component structure with structures like BOM and Routing for costing the product provided by PP.

Extensively worked on Costing run to cost, mark and release multiple materials at same times.

Configured production order as a cost object to collect actual costs, plan costs and determine WIP at the end of every period, variance calculation after the order technically completed.

Customized Period end closing functions including overhead costing, interest calculation and result analysis and settlement procedures.

Assigned value fields to condition types in MM and SD, performed integration of FI/CO with SD, MM & PP, account assignments and used COPA to report profitability by customer, product, and market.

Micron, Boise, ID Jan’10– Apr’11

SAP FICO Consultant SAP ECC 6.0, Full Life Cycle Implementation

Micron is one of the world's leading semiconductor (DRAM, NAND and NOR Flash memory products) companies.

Responsibilities:

Analyzed the existing legacy system; gathered functional requirements through user meetings, gap analysis, and participation in process improvement teams; produced the functional requirements document.

Designing business processes and identified areas to streamline processes in multiple functional areas. The scope of the work and responsibilities involved relating to SAP – Finance (FI) and controlling (CO) modules.

Configured the settings of Enterprise Structure, Company code global setting Account Groups, Retained Earnings Accounts, Field Status Variant, Tolerance Groups and Posting Period Variant and set up financial statement variant..

Experienced in activating of New G/L and Leading Ledger with creation of Segments and assigning Scenarios and Customer Fields in the Parallel Ledgers, Document splitting, parallel accounting, parallel currency, Real Time FICO integration.

Designed and configured a foreign payments strategy executed by the parent company on behalf of its subsidiaries using SAP In-House Cash (IHC) module.

Configured Automatic Payment Program for checks, and outgoing payments in Accounts

Configured Lockbox setup defined control parameters for BAI2 file import, for handling incoming payments from customers and also worked on Special GL transactions like Down Payments.

Configured Dunning, Interest calculation, foreign currency valuation.

Involved in yearend closing book and helped to resolved inconsistency in closing and opening book.

Configured chart of Depreciation, depreciation areas and depreciation key.

Preparation and presentation of extensive financial analysis for the annual planning and budgeting exercise for the bank along with variance analysis for the same.

Excellent in working with posting validations, substitution rules, forms, interfaces (ALE & EDI), user-exits, and reporting tools

Involved in the Configuration of Controlling areas, Company code assignment to Controlling Areas, creation and assigning of number ranges for Controlling Areas, Version maintenance for controlling areas and statistical key figure (SKF)

In Cost Element Accounting created Primary and Secondary Cost Elements, created Cost Element Groups, maintain Cost Element Attributes and performed unit and system testing.

In Cost Center Accounting (CCA) maintained Cost Center Hierarchies, cost element groups, cost centers. Developed for cycles, segments cost center distributions and assessment.

In Profit Center Accounting (PCA) maintained the basic setting, created hierarchy, dummy profit centers, Profit center master data, profit center groups etc. and extracted reports using PCA.

In Internal Orders (CO-IO) configured various internal order types, Defined settlement profile, settlement structure, settlement rules and cost elements for internal order settlements. Configured Budgeting and Planning for internal orders, set up tolerances for budget cost and also Configured settlements distribution cycles for actual cost distribution.

Created BPP (Business process procedure)’s for end users and conducted end user training.

Used LSMW for master data transfers, created reports using report painter.

Provided Post-Go-Live support to users, helped users in solving their problems in live environment, and reconfigured settings wherever desired by users.

Smart Modular Technologies, CA Dec’08– Dec’09

SAP FI Consultant SAP ECC 6.0, Support Project

Smart Modular Technologies is a manufacturer of standard and custom computer memory modules, ATA, Linear Flash and Compact Flash cards, DC-DC Converter products and is a producer of wireless communications devices and wire line communication sub-systems.

Responsibilities:

Responsible for Testing and troubleshooting that the live production sites encountered.

Creation of User Scenarios for UAT, which defined what action users can take and what result are expected and to test whether the desired results are achieved.

Testing of functional issues before fixing them and moving to production.

Analyzed to various business process of different functional modules like FI, SD and MM.

Tested various sub modules of FI: Accounts payable (FI-AP), Accounts receivables (FI-AR), GL.

In Asset accounting, supported fixed assets team. Changes in the configuration of depreciation areas and loading of additional assets into SAP system.

Resolved issues regarding the foreign currency valuation by configuring the conversion ratios for parallel currencies.

Involved in detailed testing of Invoice verification. .

Worked directly with the end users, conducted various presentations and provided solutions to meet client specifications.

In FI perform financial verification on inter/intra company transactions.

Defined the process of credit management to set the credit limit for customer group.

Automated GR/IR process of clearing the accounts which has the assignment of goods receipts to the corresponding invoice receipts used in the purchase order number.

Trained users at various levels for document entry with concepts like Reversal documents, hold documents, parking documents, reference documents, editing and document entry screen.

MAS Holdings, Colombo, Sri Lanka May 2007 – Dec 2008

SAP FICO Consultant SAP ECC 4.7, Implementation and Support

MAS holding known as one of the largest retail industry in south Asia and using the best technology in both manufacturing and information systems to set the bar in global industry standard in enterprise resource plan.

Responsibilities:

Conducted As-Is study interacting with the core team members and developed a To-Be process to suit the company’s objectives using ASAP methodology. Involved in Business Blueprint Phase and worked on field mapping to study the GAP Analysis.

Configured General Ledger Accounts (GL), Vendors and Customers master records, Incoming payment, partial and residual payment, and outgoing payment. Created vendor/customer groups.

Configured Tax on Sales & Purchase ( Input & output tax), Additional Tax, Sales Tax, Withholding Tax, Tax code, Tax procedure, Jurisdiction structure and Jurisdiction code.

Configured foreign currency valuation and also set up the Exchange gain and Exchange loss accounts for automatic posting.

Customized Bank accounting, bank master data, house banks and GL accounts in different currencies for each bank account and sound knowledge of Electronic Bank Statement (EBS) and manual bank statement.

Worked extensively on the following - Master data, POS interfaces, Procurement and requirement planning, Merchandise logistics, Assortment planning, SAP Retail store logistics.

Configured Lockbox with BAI2 format, house banks and bank accounts for Lockbox processing.

Integration of FI with MM and SD-Complete knowledge of the workflow from the creation of sales order to delivery and billing in the Sales & Distribution module that involves the Order-to-Cash end to end process as well as expertise in configuration of account determination in FI from MM and SD transactions.

Define Dunning Program configuration, Running/Editing Dunning proposals, printing Dunning Notices, created own correspondence and correspondence type’s to meet business requirements, Interest Calculation program configuration/running interest calculation program.

Setup Automatic Payment Program, payment methods, ranking order for House Banks for company codes in Accounts Payable.

In Cost Center Accounting (CO-CCA) created the cost centers, cost center group and maintained the Standard hierarchy, assigned cost centers to cost elements. Configured Activities, Statistical Key Figures (SKF).

Developed cycles and segments for cost center distributions and assessment to allocate cost to cost objects.

Created different reports using report painter.

Education:

Bachelor’s degree in Finance from University of Colombo, Sri Lanka. 2008

Contact this candidate