Sap Fico Rar Analyst Resume
Redmond Wa Sap Fico Rar Analyst Redmond, WA
SUMMARY
- Experience of over 8 years as a functional consultant in SAP Financial Accounting (FI) and Controlling (CO) modules including Full life cycle implementations with Upgrades, Testing, Production Support projects and Enhancements.
- Have an in depth understanding of the Business Processes related to SAP Finance, Controlling and their Integration with MM, PP and SD Modules and worked on various versions of SAP ERP like SAP ECC 6.0, SAP ECC 5.0 and SAP R/3 Enterprise 4.7.
- Experience in 3 full life cycle implementations with ASAP methodology and involved in different phases of life cycle implementation like AS - IS study, FIT-GAP analysis, TO-BE process, Troubleshooting, Production Support and End-user training.
- Extensive work experience in SAP RAR, Product costing, Material ledger, Vertex, New GL, Treasury, FICA.
- Strong experience to review and analyze client’s business requirements and existing business process.
- Expertise in providing functional assistance in the development of RICEFW objects (Reports, Interfaces, Conversions, Enhancements, Forms and Workflows).
- Strong experience with SAP table structures.
- Extensive knowledge in FI-MM, FI-SD, CO Interface Scenarios.
- Worked on BI 7.0/BW 7.4 (Business warehouse) for reporting and analytics.
- Worked on SAP FSCM (Dispute management, collections management).
- Extensive experience in Lockbox configuration and processing, automatic payment program and dunning.
- Expertise in GL, AR, AP, Fixed assets, COPA, Revenue recognition and banking.
- Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, roll up, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Also, used variety of techniques to boost the performance of BEx Query.
- Work experience handling on shore and offshore team as well lead experience for controlling Finance team.
- Experience working as tester in UAT, SIT, integration testing using HPQC (HP Quality Center) & Mercury.
- Experience with report development tool like Report Painter/ Report Writer and user exit programming.
PROFESSIONAL EXPERIENCE
Confidential, Redmond, WA
SAP FICO RAR Analyst
Environment: SAP ECC 6.0
Responsibilities:
- Developed detailed functional specifications, enhancements and modifications documentation.
- Worked on Non-SAP Systems MSL for Order quotes and MS Sales for Microsoft revenue reporting purpose.
- Configuration of Performance Obligation Fields and Account Assignments for Manual Performance Obligations.
- Maintain BRF+ Structure & Decision Tables Revenue Accounting contracts.
- Maintain Revenue Accounting Item Classes and Generated Interfaces for Revenue Accounting Item Classes.
- Management of Revenue Accounting Items and Source Document Item Types & Sender Components.
- Worked with SD Analyst on Condition Types for Standalone Selling Price and maintained Right of Return.
- Configured BRF+ Applications to Revenue Accounting Item Classes.
- Maintained BRF+ Setting, BRF Mapping table according to Business rules and business process.
- Configuration for Sales and Distribution and legacy-based revenue recognition.
- Configured BRF Logic based on business requirement according to upstream and downstream.
- Worked on RAR 1.2 to 1.3 upgrade.
- Developed custom program for reporting purpose to track down the revenue based on contract level.
- Processed RAIs and created contracts for the orders which are flowing from upstream systems.
- Configured RAIs and GL to Revenue accounts to reporting purpose.
- Developed custom FX Gain/Loss report for both Method 1 & Method 2 contracts.
- Worked on upgradation of RAR 1.2 to 1.3.
- Maintain BRF+ Structure & Decision Tables Revenue Accounting contracts
- Maintained Number Ranges for Contracts & Performance Obligations
- Configured Fulfilment Event Types according to Orders.
- Worked on Method 1 and Method 2 Deferral Methods on Performance Obligations
- Posting with Custom Fields for Line Itemsand created Contract Accounting
- Involved in preparation of End User Training Documentation and provided trainings to End users.
- Supported users during UAT testing.
- Worked with EDI interfaces, IDOC processing, creating of IDOCs, BDC sessions, batch input sessions, batch job creation and scheduling, variant setup for jobs.
- Trained users on daily routines and month end closing procedures.
Confidential, San Jose, CA
SAP FICO Treasury
Environment: SAP ECC 6.0, Treasury Wires, Statements, Accounts Payable
Responsibilities:
- Developed detailed functional specifications, enhancements and modifications documentation.
- Worked on Non-SAP systems Web methods and Broad ridge to identify the IDOCs delivery and connection with the banks.
- Provided upgrade fixes in all areas of configuration in the application areas FI-GL, FI-AP, FI-AR, Treasury and Banking.
- Configuring treasury groupings, bank statement processing, risk management, cash management posting rules, exchange rates, planning.
- Worked on FI-AP/AR Customer Configuring and Customizing Vendor/Customer master data, Account groups, ERS based invoices, Logistics Invoice verification (LIV), terms of payment, tolerance groups, payment configuration, dunning, interest calculation and check management.
- Configured Chart of accounts, account groups, fiscal year variant, posting period variant, field status groups, posting keys, automatic account determination, financial statement versions, number ranges and document types.
- Worked on Accounts Payable (Procure to pay) and Accounts receivable module (Order to Cash) with the concentration on FSCM and Treasury.
- Configured global settings for Electronic bank statements (EBS) in Multi Cash Format, defined Account Symbols, posting rules, created and assigned business transactions for manual bank statements.
- Worked on PDR and CDR Statements.
- Configured OKB9, OBYC, VKOA, and OA90 for different account determinations.
- Involved in customization of additional billing functionality like down payment, billing plans, configuration for the dunning, incoming payments, incoming payments like residuals, partial payments, payment differences like underpayment/overpayment, reason codes
- Configured and maintained House Banks under Treasury module with multiple Bank Accounts, alternate bank selections for Payments, assigned check lots and defined void reason codes, configured Automatic Payment Program for outgoing payments and Electronic Bank Statements.
- Worked on banking interfaces and different interfaces involving EDI and IDOC functionality and worked with process codes, partner profiles, etc.
- Worked on Non-SAP Application like Bloomberg, BMG, Broad ridge and Concur.
- Configured AR Scenarios: Customer master maintenance, tolerances, over-under payments, cash discounts, Incoming payment (full payment/partial payment/residual payment), dunning procedures, and Age-Wise AR reports.
- Worked on daily payments F111 for different banks based on business scenario.
- Processed IDOCs and validated those with the banks testing team.
- Worked on house banks, bank accounts, reason codes, check lots and lockbox for payments.
- Worked on Funds transfer between Different banks.
- Worked on Intercompany and Intra company payments.
- Validated list of PDR/CDR Accounts and accounting documents.
Confidential, St. Louis, MO
SAP FICO Consultant
Environment: SAP ECC 6.0, SAP GL, AP, AR, Vertex, Accounts Payable
Responsibilities:
- Responsible for gathering business requirements, conducting workshops with the business users.
- Designed the functional specifications for the business requirements for Reports, Interfaces, Conversions, Enhancements, Forms and workflows (RICEFW).
- Worked on Material ledger and product costing related activities.
- Worked on FI-AP/AR Customer Configuring and Customizing Vendor/Customer master data, Account groups, ERS based invoices, Logistics Invoice verification (LIV), terms of payment, tolerance groups, payment configuration, dunning, interest calculation and check management.
- Worked on COPA Module to flow values from SD during delivery (COGS).
- Configured Automatic Payment Program for Outgoing Payments in Accounts Payable (AR).
- Configured OKB9, OBYC, VKOA, and OA90 for different account determinations.
- Configured Chart of accounts, account groups, fiscal year variant, posting period variant, field status groups, posting keys, automatic account determination, financial statement versions, number ranges and document types.
- Configured SAP financials (FI/CO) and SAP Asset management.
- Implemented New GL and Co-ordinated the testing activities for the areas of FI-GL, accounts payable, accounts receivable transactions.
- Configured partial, full, residual payments, Open Item Clearing in Accounts Payable.
- Worked on determine benefits and costs to the company of process changes such as OSS notes, SAP system upgrades.
- Configured and customized Account Receivable (AR) and Accounts Payable (AP) modules including pre-requisites to create vendor master Records, customer master records, tolerance groups, account determination and default account assignments.
- Involved extensively in the enhancement of Reporting Process; Wrote functional specifications for all the CO reports, and worked with BI Team to design and develop the customized reports as per the business requirements.
- Worked on data migrating customer & vendor master data from legacy system in to SAP through LSMW.
- Configured dunning program, dunning levels and dunning areas for each company at company code level and Worked with ABAPers to create dunning forms for dunning procedures.
- Designed functional specification for lockbox interface and configured relevant settings in SAP for lockbox processing.
- Configured global settings for Electronic bank statements (EBS) in Multi Cash Format, defined Account Symbols, posting rules, created and assigned business transactions for manual bank statements.
- Solid experience in Vertex with Tax rules implementation and performed end to end testing scenarios during migration activity of Vertex application.
- Coordinated the integration efforts of FICO with SD, MM and PP teams based on functional requirements.
- Used Pivot and Vlookup for data migration activities.
- Worked on banking interfaces and different interfaces involving EDI and IDOC functionality and worked with process codes, partner profiles, etc.
- Involved in preparation of End User Training Documentation and provided trainings to End users.
- Supported users during UAT testing.
Confidential, Wilmington, DE
SAP FICO Consultant
Environment: SAP ECC 6.0, SAP GL, AP, AR, ABAP.
Responsibilities:
- Involved with all phases of implementation from development of Business blueprint, conducting workshops, GAP Analysis, and configured the system for implementation of FI.
- Worked on segment reporting, ledger groups and document splitting in New GL module.
- The project involved detailed study of the entire accounting operations, studying the current business process, organization structure finalizing and mapping & configuring of to be Business process and providing necessary support.
- Created Chart of Accounts, Asset Classes, Master Data, Valuation, Asset types, Allocations of number ranges and transfers of legacy data in Asset Management Module.
- Configured AR-customer transactions, credit management, payment terms, Cash application, Lockbox processing, Cash receipts.
- Worked on data conversion, custom development QA and security team in implementation for prevention of LSMW program changes.
- Configured Automatic Payment Program (APP) for payments to vendors, created check lots, voided checks for payment blockage, and reissue of destroyed checks.
- Worked on Inter-company setup, trading partners, intercompany vendors and customers, F110 payments from paying company and sending company.
- Created Chart of Accounts, Asset Classes, Master Data and transfers of legacy data in Asset Management Module
- Involved in configuration of Asset classes, account determination, document Number ranges, assign G/L accounts, Depreciation areas, testing Asset Master Records, depreciation, business transactions, postings, reposts and so on Includes Inter Company Asset Transfer, Complete Transfer of Assets from Legacy System to SAP.
- Configured House banks, EBS (Electronic Bank Statement), G/L accounts for each bank account and Reconciliation accounts for vendors, customers and assets.
- Maintained Lockbox Configuration, Electronic Bank Statement (EBS), cash management in treasury.
- Defined and maintained the Validation and Substitution rules at header, line item and document levels in FI application area.
- Worked on MS-Excel (VLOOKUP, Pivot) data conversion activities.
- Developed design, configuration, and user documents in Solution Manager.
- Provide assistance to SOX compliance team in auditing the change control policies.
- Worked with EDI interfaces, IDOC processing, creating of IDOCs, BDC sessions, batch input sessions, batch job creation and scheduling, variant setup for jobs.
- Trained users on daily routines and month end closing procedures.
Confidential, Voorhees, NJ
SAP FICA Consultant
Environment: IS-Utilities, HP Quality Center, ABAP.
Responsibilities:
- Configured SAP Contract Accounts Receivable and Payable from end to end.
- Created billing rate categories and rate types, define billing rates, prices and discounts. Process an individual bill.
- Worked on dunning history of a contract account and create an installment plan. Displayed financial information about a customer account.
- Post receivable items, payments using a payment lot, and payments at cash desk. Post a return.
- Ticket resolution and answering how-to questions
- Responsible for detailed problem determination of issues escalated from Level-1.
- Problem determination includes re-creating the issues, determining the point of failure by stepping through the ABAP Code and identifying the problem resolution.
- If the resolution is a major development or configuration fix, provide the necessary change detail to Level 3.
- Worked on SAP FSCM (dispute and collections management) module.
- To have the deepest level of application or product understanding.
- Configured Automatic Payment Processing (F110) for Outgoing Payments, Vendor and Inter-company Payment using In-House Cash, Payment using Direct Debit, Commission and Royalties payments, Check, ACH and Wire payments, Interface with bank through EDI, Employee Down Payments, Vendor Down Payments, Partial Payments and Credit Notes.
- Able to understand both the standard application features (i.e. out of the box functionality) as well as the detailed components of the customized features.
- Responsible for making changes, migrating them, completing the ticket and communicating the change to the level 2 support person, who can then resolve and close the call.
- Worked on the internal projects in which the costs are settled to Cost Centers (Expense Projects) & costs are settled to AUC and to Fixed Assets (Capital Projects)
- Created LSMW’S for revaluation of assets and transferring of accounts payable from one company code to another as a part of Fresh start accounting
- Configured house banks, bank accounts, reason codes, check lots and lockboxes for payments.
Confidential, Moonachie, NJ
SAP FICO Consultant
Environment: SAP ECC 6.0, ASAP, New GL, SAP GL, AP, AR, AA.
Responsibilities:
- Designed the business processes using ASAP implementation methodology, collected and analyzed user’s business requirements, identified and defined areas for improvements, configured, troubleshoot and supported the system users.
- Extensively participated in client discussions in blue printing phase.
- Designed functional specifications, configuration documents, training and user manuals based on the business scenarios.
- Written functional Specs for RICEF objects (Reports, Interface, Conversion, Enhancement and Forms) as per the Business Requirements.
- Thorough understanding of overall business processes such as Order to Cash (OTC) and Procure to Pay (P2P).
- Maintained Lockbox Configuration, Electronic Bank Statement (EBS), cash management in treasury.
- Defined Exchange rates, configured currency valuation, automatic posting for foreign currency valuation and determined realized & unrealized gain.
- Created tolerance limits for employees, invoices and customers.
- Configured for vendors subject to withholding tax, interest calculations on item \ balance interest calculation, number ranges for forms, interest on arrears, account balance calculation on account balances / line items.
- Designed dunning procedures, running/ editing dunning proposal and printing dunning notices based on customer segmentation.
- Configured Country Specific chart of Depreciation and maintained depreciation areas that are relevant to the country specific requirements.
- Created Asset classes, Account Determinations, Screen Layouts and Number ranges.
- Configured various Deprecation Keys according to the business requirements.
- Experience in Logistic Invoice Verification (LIV) like understanding the end-to-end workflow.
- Customized settings for Controlling (CO) area and assigning company code to controlling area, worked on number ranges.
- Created Standard hierarchy using Cost Center Accounting (CCA), Cost centers, assigned cost centers to cost elements, configured Activities and Statistical Key Figures, developed Assessment, Distribution, Periodic reposting cycles and segments.
- Configured and customized the basic settings for Profit Center Accounting (PCA). Maintained profit centers hierarchy, assignments, CO-Objects to Profit Centers, distribution and assessment of costs.
- Generated reports using Report Painter and Report Writer. Performed Documentation for end users and provided end user training.
Confidential, Oakland, CA
SAP FICO Consultant
Environment: ECC 6.0, SAP BI, HP Quality Center.
Responsibilities:
- Configuration and creation of house banks, bank accounts and assignment of these accounts to a check lot. Configured automatic payment program for out-going payments in AP, payment terms, over-due interest calculations, cash discounts and automatic clearing of line items.
- Configured Product cost using Production Planning cost collector.
- Assigned Number Ranges for Documents, Vendors and Customers, reconciliation Accounts for Vendors and Customers.
- Extensively worked on cost estimate updates, costing run in Product Costing, implemented Cost Estimate with Quantity Structure and Configured Costing Variants for Base Planning Object, standard cost estimate and current cost estimate.
- Defined Costing Type, Valuation Variant, Date Control, Quantity Structure Control, and Transfer Strategy for the costing variants in Product Costing.
- Designed & Developed custom BI DataSource, Info Source, Extractor, InfoCube and ODS to fulfill user requirements.
- Extracted and loaded data from SAP R/3 into BI InfoCube using DataSource.
- Designed and configured Lockbox BAI2 format for Receivables through Bank of America at different locations with a hit rate of 92 % overall. Used the Mercury testing tools to test the processes in Financials.