Sap Fico/ Rar Consultant Resume
Newark, CA
SUMMARY
- 12+years of experience with SAP products with implementing, customizing, configuring, supporting and testing of FI - GL, AR, AP, AA, NEW GL, CO- CCA, PCA, RAR, COPA, SAP S4 Simple Finance and in MM and SD integration.
- SAP Certified - ‘Solution Consultant: Financials - SEM (Strategic Enterprise Management)’.
- SAP Certified Application Associate - SAP HANA: Passed with 96 % score.
- SAP Certified Technology Associate - SAP HANA: Passed with 93 % score.
- 11+ months full time functional and customization experience in SAP Revenue Accounting & Reporting (RAR) environment and data migration process from existing SAP system to new RAR v 1.2/ 1.3 (REVREC120/ REVREC130) conforming to new IFRS 15 and FASB Revenue recognition rules ASC 606.
- 4 full life cycle implementations, Upgrade, Support and Enhancement projects along.
- Configuration experience on ‘SAP S/4 HANA Simple Finance’ On premise Business edition (SFIN 0) powered by SAP HANA, including configure and execute pre migration & post migration activities in Asset Accounting, General Ledger & New Universal Journal & converting the historical data into ACDOCA table view. Activation of Material Ledger in 1511/ 1610 version, for using MIRO & MIGO. Post migration steps & Historical data management in new HANA views.
- Handled configuration responsibilities for core FICO (FI-GL/AM/AR/AP/AA), Revenue Account Recognition, Funds Management, Joint Venture Accounting, Contract Accounting (FICA), Banking, EBS - Order to cash / Procure to Pay Processes.
- Effective in client interaction to understand business process and identify GAPS & formulating long term and short-term strategic solutions along with developing functional and technical specs per unique client requirements.
- Extensively worked on configuration and testing of FI/CO modules -GL, AR, AP, AA, Joint Venture Accounting, Cost Center Accounting (CO-CCA), Profit Center Accounting (PCA), Product Costing, Internal Orders and Special purpose Ledger.
- Experienced in Funds Management with configuring FM Area, Fund Center, Hierarchy Variant, Fund Type, Fund, Funded Program, Commitment Item, Budget Profile, Budgeting, Account Assignment Derivation, Document Types, Number Ranges and FM Reports.
- Experienced in training end users through Period-End closing activities for the application areas in Finance and Controlling, Fixed Asset accounting, Project systems and Material management.
- Extensively worked on Business Intelligence/Business warehouse team to design revenue and expense reports.
- Experience in Integration of FI/CO with MM, SD, HR & PS modules and in overall business processes such as invoice verification, material valuation, order-to-cash, and procure-to-pay.
- Special emphasis on Data Migration with BDC, LSMW for data uploads for various SAP projects. Knowledge in identifying, testing and documenting of SAP application controls in compliance with Sarbanes Oxley Act (SOX).
- Extensive knowledge in Unit, Integration, Functional, Validation, Regression and User acceptance testing (UAT) with ticket monitoring and reporting with SAP solution manager.
- A highly motivated individual abreast of latest technology, able to accomplish tight deadlines, communicate effectively with technical peers as well as with business users.
- Industry Experience: Healthcare, Information Technology, Oil & Gas, Engineering & Construction, Public Sector, Heavy Industries, Pharmaceuticals, Financial, Investment Banking, Consumer Goods, Utility & Retail.
TECHNICAL SKILLS
Data Warehousing: SAP S/4 HANA 1610 SP18; SAP NetWeaver BI/BW 7.3/7.4
ERP: SAP ECC 6.0/ 7.0; SAP NetWeaver BI/BW 7.3/7.4; SAP S/4 HANA Simple Finance.
Reporting Tools: SAP BO 4.1/ 4.2 Support Pack 2 Tools BO Explorer, WEBi, Crystal Reports on Enterprise, BEx Web application, BEx; SAP Lumira and Predictive Analysis; and MS Excel
SAP SEM: BPS, Balanced Score Card, Risk Management, Management-Cockpit, Value-Driver-Tree.
Software Methodologies: SAP Activate, SAP-ASAP, SDLC Waterfall Model & Agile
PROFESSIONAL EXPERIENCE
Confidential, Newark, CA
SAP FICO/ RAR Consultant
Responsibilities:
- Implemented SAP Revenue Accounting and Reporting (RAR) v 1.2 / 1.3 project conforming to new IFRS 15 & FASB Revenue recognition rules ASC 606 - 5 steps process to ensure better compliance, improved visibility, and lower cost: Step 1: Identify a contract with a customer; Step 2: Identify performance obligations in a contract; Step 3: Determine the transaction prices; Step 4: Allocate the transaction prices; Step 5: Recognize revenue when or as the entity satisfies a performance obligation.
- RAR’s integration with SAP Sales and Distribution; SAP Hybrid Billing & SAP CRM.
- Ongoing Administration and Maintenance of the end-to-end implementation project: Assessment & Preparation (2 months), Pilot (2 months), Implementation (4 months) and Parallel Reporting (2 months); total time frame of 10 months.
- Handling of customer orders/ contracts and invoicesfrom multiple SAP system as part of RAR process.
- Customization of revenue, receivables (customers), deferred revenue and unbilled receivables account which are needed for the representation of the revenue recognition process.
- Tracking revenues which have been recognized but not yet billed (non-billed receivables) and revenue which has been billed but not yet recognized (calculated revenue)
- Project’s functional and configuration of SAP RAR v 1.2 / 1.3 (REVREC120 / REVREC130), as follows:
- Defining RAI, RAI Classes, Interface generation, RAI Class Types, RAI modified as raw, processable and processed.
- Configured BAdIs: FARR BADI CHECK CA, FARR BADI CHECK CRM, FARR BADI CHECK SD (to simulate the operational documents in the integration component to compare records), FARR BADI CHECK SELECTION CA, FARR BADI CHECK SELECTION CRM & FARR BADI CHECK SELECTION SD (to select the operational documents in the integration component).
- Defining Source Document Item Types such as: Invoice item, Order item; Define Sender Components such as SAP FI-CA, SAP-CRM & SAP-SD; Define Reference Types; Define Condition Types for Standalone Selling Price and Right of Return; Assign BRFplus Applications to Revenue Accounting Item Classes (FARR AP SD PROCESS TEMPLATE, FARR AP CRM PROCESS TEMPLATE, FARR AP CA PROCESS TEMPLATE); Maintain BRFplus Structure.
- Configuring BAdIs such as: With status Raw in Rev Acc. (class CL FARR RAI IFCOMP); with status Raw to Processable in Rev Acc. (class CL FARR RAI IFCOMP); for determine Contract ID per Rev. Acc. Item (class CL FARR RAI2 BADI IMPL.).
- Activation of archive information structure for its access and display (FARR CONTR, FARR RAI).
- Configuring Accounting Principle such as US-GAAP, IFRS; Migration Packages and its assignment to Company Code; Assign Company Codes to Accounting Principles US-GAAP, IFRS and Migration Packages.
- Defining Number Ranges for contracts, Performance Obligations (POB) and New Revenue Posting Jobs (Run IDs); Defining Contract Categories and assignment to Contract Number Range.
- Defining Performance Obligation Types and BRFplus functions such as FARR AP SD PROCESS TEMPLATE (for RAI classes’ integration with SD), FARR AP CRM PROCESS TEMPLATE (for RAI classes’ integration with CRM), FARR AP CA PROCESS TEMPLATE (for RAI classes’ integration with FI-CA) & FARR AP PROCESS TEMPLATE (for RAI classes’ integration with any other sender component).
- Defining Condition Types such as Reserved conditions, Condition not requiring allocation;
- Defining Fulfillment Event Types such as: Customer invoice, Goods issued, Proof of delivery, Manual and Consumption.
- Assignment of BRF+ Applications to Revenue Accounting Processes (FARR ACC DETERMINE TEMPLATE, FARR POB STATUS TEMPLATE).
- Configuring BAdIs such as: FARR BADI POB CUST VALIDATION, FARR BADI DERIVE ACCT ASSIGNMT, FARR BADI SET REVIEW WORKLIST, FARR DEFERRAL METHOD S, FARR BADI COMPOUND FULFILLMENT, FARR POSTING ENHANCEMENT A and FARR CHANGE MODE DETERMINATION.
- Define Posting Specifications for General Ledger Transfer: The default document type used is SA, 40as the debit posting key, and50as the credit posting key.
- Assignment of Tax Codes for Non-Taxable Transactions to respective Company code: Configuration of calculation procedure OTXUSX for US, and TAXCA for Canada; The Input Tax code for USA was V0 and Output tax code was O0; for Canada O0 and I0 respectively.
- Configuring BFR+ - FARR ACC DETERMINE TEMPLATE; FARR POB STATUS TEMPLATE.
- Generation of reconciliation reports: Reconciliation between Revenue Accounting Items in Adapter Reuse Layer (T- code FARR CHECK CONS) // Data consistency- Periodic reconciliation of processed revenue accounting items with the performance obligations that were determined (T code: FARR RAI RECON) // Perform reconciliation between FI-GL and Revenue Accounting (Role: SAP SR FARR REV ADMIN).
- Configuration and generation of statutory & management reports such as: Reconciliation Type 1/2/3; Disaggregation of Revenue and Posted Amounts; Contract Balance; Transaction Price Allocated to the Remaining Performance Obligations; Revenue Analysis by Posting Item; Allocated Price; Change of Performance Obligation; Revenue Forecast; Revenue Object Attribute; Revenue Contract; Performance Obligation; Reconciliation Key; various Text reports.
- Administration and Maintenance: Different revenue accounting roles have different authorizations and can therefore perform different tasks. Maintaining roles such as: Revenue Accountant (SAP SR FARR REV ACCOUNTANT A); Revenue Accounting Administrator (SAP SR FARR REV ADMIN A); Revenue Accounting Auditor (SAP SR FARR REV AUDITOR A); Revenue Accounting RFC User (SAP SR FARR REV RFCUSER A).
Confidential, Mountain View, CA
SAP FICO/HANA Consultant
Responsibilities:
- Worked in areas such as: General Ledger {Set of Books and Company, GL accounting, Journal entries, Intercompany transactions, Balance forward, Open and closed periods}, Customer invoicing, Supplier invoicing, Sales orders, Purchase requests, Project management., Resource management, Payable, Receivables, Payment management and HCM (Org. management, Travel and Expense, Personnel management). Deprecation runs, Profit & Loss and Balances carryforwards.
- Migration: Clearing of stuck intercompany invoices, cleansing of data, preparing data sets to migrate into new ERP system.
- Supporting SAP Production system, end-users & Projects: Gathering requirements, Configuration, Maintain, Conversion, Gap-Management, Integration, Analyzing, Training, and implementation.
- Configuration, Support and Enhancements - Company, Classic & New GL, Account Receivable & Payable, Asset Accounting, Travel Management, (FSCM)Treasury, Project System, Internal Order, Cost & Profit Center.
- Created Customer Master Records, Screen Layout, Configuration of Dunning and Payment Terms (as part of AR).
- Created Vendor Master Records, Vendor Down Payments, Defining Check Lots, House Banks, and Configuration of Automatic Payment Program with Cheque Printing (as part of AP).
- Created Chart of Depreciation, Asset Classes, Account determination, Screen layout rules, Number ranges for creation of asset master data (as part of AA).
- Dealt with various aspects of Treasury & Risk Management, Transaction manager, Money market, Foreign exchange, Securities, Credit risk analysis, Cash & Liquidity Management (as part of Treasury Management).
- Designs, implements system solutions as well as writes functional specifications.
- Daily Invoice IDOC monitoring and troubleshot.
- Worked and supported (Account and cost base COPA) in COPA report and checking the logical (SD11) structure & table with directory.
- Updating settings related to integration from SD to FICO, like maintaining VKOA and OBYC also OKB9
- Support Procure to Pay business process - AP configuration in SAP, FI-MM integration for accounting, pricing, taxes & invoices entry, AP payments with workflow & acknowledgments support.
- Experience in design, configuration and support of Interfaces in the corresponding with SD, MM, PI, Tax system Vertex, TIBCO, JPAY, CONCUR, external party and etc.
- Revisited & redesigned the approval workflow process within Treasury business process
- Support issues related to 1099, wires, ACH, checks & SABRIX use tax with IDOC’s, NACHA format, DME formats & forms.
- Helped stabilize & streamline the support processes within the finance module within 60 days’ time of joining the project as lead & helped deliver close to 100 defects as part of 3 monthly releases successfully
- Changes to the POS configuration with respect to financial transactions posting in ECC
- Perform analysis to Record to report, prepare and deliver reports or alternatives for improving across the organization for internal reporting (invoice to payment, lockbox, and cash flow).
- Experience in, design, configuration and support IDOC segments, Partner profile and all other IDOC settings.
- Create new custom program to extract the data from CJI3 and CJI5 for Retail Store expanse Monitoring
- Create a custom program to send daily total posted of settlements to Treasury Team to sync with bank data.
- Customer program to update the jurisdiction code on cost center, customer master, and WBS.
- Broadcasted SAP standard reports, design of new data sources, design of custom reports, design KPIs, design Dashboards.
Confidential, San Jose, CA
SAP FICO Consultant
Responsibilities:
- SAP FICO for ECC 6.0 implementation
- Involved and implemented SIX global life cycle implementations.
- Global Implementation for 30+ countries in Asia, Middle East, South America, Australia, Europe, America etc.
- Carried out GAP analysis and produced Business Blueprint documents that fulfilled the following requirements: Reporting, Interface, Conversion, Enhancement and authorization, as per ASAP methodology for third party integration as well as integration with MM, SD, Retail and HR.
- Designed and configured: New general ledger (Parallel ledgers, Document splitting, New GL assessment/distribution); Profit center accounting; Cost of sales accounting; Tax accounting (US sales/use tax, 1099 reporting), Experience with third party integration such as Avalara and Vertex.
- Handled Accounts Payable (A/P) activities such as: Incoming Invoices; Automatic payment run and bank communications; Interface for outgoing payments; Interface for incoming travel expenses; Account assigned purchase orders; Enhancement of FBL1n using BTE; House Banks, Bank Accounts.
- Handled Fixed Asset (F/A) accounting such as: Asset under construction process using investment management; Internal order settlements; Asset purchases using account assigned purchase orders.
- Electronic Bank Statement for three banks - Automatic integration.
- Designed and Developed Enhancements for display use tax on the GL line item display report by calculating taxes based on ratio (line item amount/ total).
- Develop enchantment to display cost center on the enjoy transactions automatically based on the profit center.
- Develop enhancements to control posting to cost center based on the GL account and cost center category
- Develop match-code to display profit center based on company code.
- Accounts Receivable: Designed and developed Interfaced with Credit orgs.
- Design and Developed LSMW for legacy conversion for the following modules: General Ledger (G/L Accounts, Historical and Open Balances); Profit Center Master Data; Cost Center Master Data; Accounts Payable (Vendor Master, Open Invoices); Accounts Receivable (Customer Master, Open Billing Invoices).
- Provided post-go live support and developing Finance reports.
Confidential, Richmond, VA
SAP NetWeaver BI Consultant
Responsibilities:
- Requirement gathering in Sales & Purchasing for cross functional analysis.
- Data model development & monitoring for various functional requirements for queries & cubes from business content.
- Source data mapping (SAP R3/non-SAPR3) to target data in BI/BW.
- Extraction process using LO cockpit and V-3 updates, configuration of BW objects including generic data sources to extract data.
- Reporting needs study, design/develop flexible queries and pre-calculated reports using BEx features like variables, exceptions and conditions.
- Initial data load and implementation of daily update process chains
- End-user training & support in Go-live process
- Triggering and monitoring the Initial and Delta data loads of daily update process chains.
- ETL - preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using IDOCs, loading data via flat files, scheduling and monitoring data loads.
Confidential, Indianapolis, IN
SAP BW/BI/SEM-BPS Consultant
Responsibilities:
- Translated business warehouse requirements into data analysis and reporting solutions, primarily using SAP Business Intelligence solutions (SAP BW).
- ETL - preparing SAP R/3 for SAP BW and defining the loading strategies, initial & delta.
- Systems Administrator for SAP Solution Manager & Quality Centre 9.2. SEM-BPS / Business Planning Project:
- CRM and SAP BW Integration; Extracted data to BW from CRM data sources; creating Transactional Info cubes for BPS Layouts.
- BPS Layouts - Planning Profile, Planning Area Planning Level, Planning packages & Planning Layouts; Data slices maintenance in Planning Areas.
- Maintenance and Production Support project; continuous monitoring of loads, high-level prioritized tickets and process improvement requests.
- Daily Production runs in Production Support; Proposed RCA’s (Root cause analysis) to the client for the frequent failures; Monitoring of info packages and analyzing the reasons for Environment: SAP 4.6c, ECC 5.0, ECC 6.0, BW 3.0b, BW 3.5, BI 7.0, BW-CRM, SEM-BP