
Ravdeep Bhasin
- SAP FICO/ RAR Consultant
- Newark, CA
- Member Since Mar 23, 2023
Ravdeep Bhasin
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 1511 /1610) 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.
· Experience in Record to Report (R2R) analysis: Procure to Pay (P2P), Buy to Pay (B2P), Invoice to Pay (I2P), Order to Cash (O2C) & Collect to Cash (C2C) involving modules such as S&D, MM, SCM, CRM & others.
· 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.
BUSINESS SYSTEMS: |
||
|
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 |
VISA STATUS: |
· U.S. Citizen
CURRENT EXPERIENCE: SAP FICO/ RAR |
Smart Strategies, Inc., Newark, CA Dec. 2016 to Oct. 2017
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 invoices from 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, 40 as the debit posting key, and 50 as 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.
· Data Migration:
· We migrate OPEN contracts from S&D (Operational Application) to RAR; We migrate Order Items, Invoice Items, Fulfillment Items, also attributes (SSP & Allocation Price);
· We close the last Posting Period prior to the Transfer Date in legacy system as well as set Closed the Posting Period in RAR;
· Initial load migration T code is FARR_RAI_PROC_LOAD; for normal document processing the T code is FARR_RAI_PROC;
· If feasible, we do migration from Company Code to Company Code, unless legacy Company code date is of large volume/ complex scenarios, then we go for Migration Packages;
· Migration by Packages (Migrate one package and set Company code to Production, Customizing: Revenue Accounting Revenue Accounting Contracts; Define Migration Packages) > Then we change from Production to Migration and load second Migration Package under T code FARR_RAI_PROC_LOAD. This is how we do step by step migration;
· If we have ‘Operational Processes’ such as order items, invoice items, fulfillment items and attributes (SSP & Allocation prices) in legacy system and as well as ‘Revenue Accounting processes’. In this scenario, you must first load data that is relevant to operations from the legacy system to SAP SD. You can then load operational data from SAP SD to SAP RAR and Revenue Recognition data from the legacy system to SAP RAR;
· Testing: We test the operational load before migration as well as the initial load with a complete set in a test server. Then we migrate to production server. If a migration package has errors, we delete that data using T code FARR_IL_CLEANUP and rerun the load;
· Reconciliation of Loaded Data: Reconcile the balances of the loaded contracts with the balances of the general ledger accounts of deferred revenue (contract liability) and unbilled receivables (contract assets). The aggregated negative differences for each contract of recognized revenue minus the invoiced amount, must be equal to the balance of the corresponding deferred revenue accounts in FI-GL. Likewise, the aggregated positive differences for each contract of recognized revenue minus the invoiced amount, must be equal to the balance of the corresponding unbilled receivables accounts in FI-GL.
· Administration and Maintenance:
· User maintenance; Role maintenance: SAP_SR_FARR_REV_ACCOUNTANT_A; SAP_SR_ FARR_REV_ADMIN_A; SAP_SR_FARR_REV_AUDITOR_A; SAP_SR_FARR_REV_MANAGER _1; SAP_SR_FARR_REV_RFCUSER_A;
· Field extensions of data base tables: in revenue accounting item processing (Extension structure INCL_EEW_FARR_ARL); in revenue accounting contracts (Extension structure INCL_EEW_FARR_POB; for reporting purposes (Extension structure INCL_EEW_FARR_REP); on contract (header) level (Extension structure INCL_EEW_FARR_CONTRACT);
· Application log to report issues during processing; RAI Classes Monitoring; Parallel Processing Monitor; Revenue Posting Job Monitor (Web Dynpro application monitoring; Standard Job Monitoring (Reconciliation Contracts GL & Reconciliation Contracts GL Accounts).
|
PREVIOUS EXPERIENCE: SAP FICO/ HANA CONSULTANT |
Vendavo, Inc., Mountain View, CA December, 2015 to Nov. 2016
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).
· Worked on various Record to Report (R2R) processes such as Procure to Pay (P2P), Buy to Pay (B2P), Invoice to Pay (I2P), Order to Cash (O2C) & Collect to Cash (C2C) involving S&D (Company to Customer): Create an Inquiry (VA22), Create a Quotation (VA21), Receive a Purchase Order from the Customer, Create a Sales Order/ Sales Document (VA01), Issue the P.O. of the requested material, Issue materials against the Sales Order/ Document to the customer (Out bound delivery) [VL01N), Issue of an Invoice/ Billing to the customer(Create a Billing Document VF01),Incoming payment from the customer (F-28), Posting to Accounts ( G/L) (Edit G/L account centrally).
On MM (Company to vendor) side: Request for quotation from a vendor (create an Inquiry (VA22); Create a Quotation (VA21); Receive a Purchase Order from the Customer, Create a Purchase Order on the vendor (ME21N), Release a PO (ME29N), Goods received against PO (MIGO),Enter Incoming invoice (MIRO); Park invoice(MIR7), Payment to vendor ( F-53), Posting to Accounts (G/L) (Edit G/L account centrally).
· Designs, implements system solutions as well as writes functional specifications.
· Daily Invoice IDOC monitoring and troubleshot.
· Conceptual knowledge of OO ABAP (Polymorphism; Encapsulation; Inheritance)
· 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.
|
PREVIOUS EXPERIENCE: SAP FICO CONSULTANT |
Cisco Systems, Inc., San Jose, CA (via Smart Strategies, Inc.)
Nov. 2011 to Nov. 2015
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.
PREVIOUS EXPERIENCE: SAP NetWeaver BI/BW |
Capital One Financial Corporation, Richmond, VA January 2008 to October 2011
Role: 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.
PREVIOUS EXPERIENCE: SAP BW/BI/SEM-BPS |
Eli-Lilly, Indianapolis, IN June 2005 to December 2007
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.
<span style=