Bikash Bhattarai
Professional Summary:
SAP FICO consultant with around 9years of industry experience including SAP experience in Implementation, roll out, Upgrade, Testing and Supporting of various components
Extensive experience in FI Sub modules: General Ledger (New GL), Accounts Receivables, Accounts Payables, Asset Accounting.
Extensive experience in CO sub modules: Cost Center Accounting (CCA), Internal Orders (IO), Product Costing (CO-PC), Profit Center Accounting (PCA) and Profitability Analysis (COPA).
Experience in New GL Segment Accounting, Leading Ledger and Non-Leading Ledger, and Document Splitting.
Experience on FSCM - Collections, Dispute & Credit management.
Experience working on Master Data Synchronization, Work list, setting up Credit check based on Order types, Dispute case creations in FSCM
Good experience in Integration of Sales &Distribution(SD), Material Management(MM)
In-depth knowledge on SD pricing procedure.
Integrating SAP with External Tax system Vertex.
Expert in data migration and data conversion by using SAP tool LSMW. Experience in developing/executing LSMW.
Extensively worked on IDoc (inbound, outbound), analyzed and Solved IDoc errors.
Experience in Preparing E2E Documentations, User Manuals and conducting end user training.
Hands on experience in Project systems (PS) module which includes Creation of project with WBS elements, Assignment & Release of budget for the projects, Availability control and prepared the commitment & forecasts reports
Experience in testing Milestone billing & Resource related billing(RRB) in PS
Had exposure working on testing projects (Unit Testing, Integration Testing, Regression Testing, Writing Test Scripts and Test cases) with hands on experience on HPQC tool.
Well verse with SAP OSS, in searching Sap notes, and work with Basis/Technical Team in adopting OSS Solutions and SAP Enhancements.
Experience in generating reports using Report Painter in COPA
Hands on experience working on DMEE tree.
Had experience testing Workflows.
Prepared functional specs for identified RICEF objects (ALV Reports, Enhancements and Forms)
Involved in development of Business Blueprint, Fit/Gap analysis.
Have experience working on Interfaces.
Strong communication skills combined with a positive attitude made me a key team player.
Education: Bachelor of Business Administration (BBA) in Finance,Tribhuvan University, Kathmandu, Nepal
Professional Experience:
Client: Duracell Inc, Chicago, IL Jan 2018 - till date
Role:Sr. SAP FICO Consultant
Responsibilities:
Involved with all phases of implementation from conducting workshops, GAP Analysis, business blueprinting, and configured the system for implementation of Cost Center Accounting, Profit center Accounting, Product costing, Profitability Analysis.
S/4 Finance and support ASAP Methodology in all following lifecycles phases - Discover, Prepare, Explore, Realize, Deploy, Run - Prototype
The project involved detailed study of accounting operations, studying the current business process, organization structure finalizing and mapping, configuring of to-be Business process and providing necessary support.
Customizing SAP S/4HANA FICO modules General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets Management (AM), Document Splitting.
Customizing New General Ledger (G/L in SAP Accounting powered by SAP HANA).
Configured and customized Chart of accounts, Company code Global Parameters, Fiscal year Variants, Posting Period Variants, Account Groups, Field Status Groups, and Tolerance Groups
Conceptualized and configured a comprehensive SAP Treasury.
Customized Operating Chart of Accounts, Group Chart of Accounts & Country Chart of Accounts. Maintained the Operating Chart of Accounts by adding new G/L accounts as per the client's requirements.
Designed functional and technical designs for all configurations and interfaces from legacy system to SAP.
Worked on Procure to pay, involved in Purchase requisition, creating purchase orders and verifying the Invoices.
Worked on FI Integration with various modules like FI-MM, FI-SD, FI-PP.
Configured Manual and Electronic Bank Statements (EBS) and worked on EDI/IDOC for processing invoices.
Involved in configuring and demonstrating SAP capabilities to client team by prototyping business scenarios based on business requirements of the client.
Configured Tax Procedure for different condition types (BASB, MWAS, and MWVS) and assigned tax accounts to tax calculation rules.
Created Tax Codes and defined Tax Rates for different account keys (PST, GST, MWS, and VST) which are assigned to different Tax Types.
Configured the settings for outgoing payments including Automatic Payment program, Incoming Payments and Performing system testing in FI-AP/AR Incoming payments, paying vendor invoices.
Configured the house banks, G/L accounts for bank accounts and bank account reconciliation program.
Involved in data conversion from excel data sheet using LSMW functionality.
Configuring for reporting at group/company code levels.
Performed unit testing and integration testing. Provided user training on processes and assistance in developing user documents. Created authorization profiles for end-user
Worked with inbound orders IDOC, mapped from existing outbound invoice.
Client: MasterCard, Winghaven, MO April 2017 – Dec 2017
Role: Sr. SAP FICO Consultant
Responsibilities:
Identified key business processes and gaps and demonstrated To-Be solution using prototype model.
Worked on the overall design strategy for integrating the invoicing and payment process with SAP using third party application, iPayables for invoice entry/approval and SunGard for payment processing. It included the functional design of all the interfaces (Master data, Code Block, Validations etc.) between SAP and iPayables, workflow for blocked invoices (Invoice Verification) in SAP and payment details interface to SunGard.
A similar automated solution was implemented for international entities using a third-party invoice processing application (Basware).
Worked on Chart of Accounts rationalization and transformed legacy general ledger structure to a new Global design.
Created business process flow, business process activity documents and worked with the compliance group on user roles and authorizations.
Worked on functional design documents for various RICEFW objects. This include customized and Report Painter/Writer reports, Master Data Conversions - Vendor master, Cost Centers, Internal Orders and Projects, Purchase Order Conversion and Enhancement in Internal Order budget availability check, functional mapping documents for EDI 810 inbound vendor invoice Idocs which are not processed through the third-party application.
Designed and configured Cash Ledger, using custom enhancement as a non-leading ledger in New GL for reporting.
Worked on DOA for Purchase Orders and designed Workflow for Purchase Orders approvals
Configured New General Ledger, Accounts Payable modules in Finance, in Controlling Created Controlling Area, Versions and set up Cost Centers, Cost Element and Internal Orders.
Worked on the design of web based (SharePoint) Vendor Management tool (Vendor Portal) and its interface to SAP.
Created Business Process Procedures (BPP) documents using RWD uPerform tool based on various business process activities for user training.
Created unit and integration test scenarios using HP Quality Center and successfully conducted UAT.
Worked on the cutover plan and coordinated various cutover activities across different areas.
Client: Johnson Controls, Plymouth, MI Aug 2016 to March 2017
Role: Sr. SAP FICO Consultant
Responsibilities:
Gathered high-level financial information requirements and translated these requirements into an appropriate SAP financial hierarchy (enterprise model). Supported all phases of a project life cycle including analysis, design, development, testing, and deployment of solutions, as well as documentation, and end-user training.
Analyzed the AS-IS system, did a profound GAP analysis and successfully designed and mapped the TO-BE system on SAP at client’s site.
Configured company code, posting period variants, fiscal year variants, field status groups, document number ranges, tolerance groups, and assigning the variants to company code etc.
Configured and customized General Ledger, creation of G/L accounts, screen layout rules, automatic account assignments, financial statement version etc.
Configured New GL functionalities: Document splitting and Non-Leading ledgers to satisfy client’s country specific reporting requirements.
Configured and customized Account Receivable and Accounts Payable modules including creation of Vendor Master Records, account groups, tolerance groups, assigned authorizations for users, account determination and default account assignments.
Integrated AP and AR modules with MM and SD respectively with respect to Account determination for various Clearing and Adjustment Accounts and Automatic Postings
Worked on 1099 vendors reporting, Down payment, check form and EDI outbound and inbound.
Configured Customer Master Data and master groups. Configured Automatic Dunning program for overdue customers by setting up dunning. Defined cash discounts based upon payment terms,
Lockbox Processing for incoming payments, Configuration of terms of payment and interest calculation on open items/ balance outstanding
Configured House Banks, Payment Programs, Automatic Payment Methods, and Alternate Bank Selections for Payments, Checks Management through assigning number ranges for check lots, checks printing and defining void reason codes, Posting Invoices with and without Invoice Verification
Configured the system for Order to Cash and Procure to Pay transactions and revenue recognition.
Prepared the Business Process Procedures (BPP’s) for various transactions in GL, AR, AP sub modules.
Trained end-users on Material Costing, Work-In-Process, Overhead calculation and Production Order Settlement.
Configured Currency and Valuation Profile for multiple currencies and valuations such as legal valuation / group valuation / profit center valuation and attached to controlling area.
Worked with planning aids to transfer plan data from PP to Cost Center accounting.
In CCA, redesigned Periodic Re-posting, Distribution, and Assessment cycles and allocated various costs (percentage, fixed, portion, or variable tracing factors) among different cost centers.
Client: Nepal Investment Bank LTD, Kathmandu, Nepal September 2013 – July 2016
Role: SAP FICO Consultant
Responsibilities:
Full cycle Implementation of SAP General Ledger, Accounts Payable, Accounts Receivable and Controlling Modules.
Involved in Implementing General Ledger Accounting, Fixed Assets (New Asset Management), Cost Center accounting, and Profit Center Accounting.
Created FI: General Ledger Master Data and Finance Organization Structure design.
Involved in preparation of business blueprint, conference room pilot, and functional designs for WRICEF's and configuration rationale in the areas of General ledger accounting, Asset management and Cost center accounting.
Coordinated the configuration, custom development, testing, and defect fixing and conversion activities.
Enterprise Structure - Defining New Companies and Company Codes as per the Organization Structure.
General Ledger Accounting - Company Code Global Parameters, Chart of Accounts, Number Ranges, Foreign Currency Revaluation, Sale and Purchase Tax, Withholding Taxes, Inter Company Postings, Document Types.
New GL - Maintaining Parallel Ledgers and Configuring Real Time FI-CO Integration.
Fixed Assets Management (New Asset Management) - Maintaining Chart of Depreciation and Depreciation Areas for various Accounting principles and currencies, Asset Classes, Account Determination and Screen Layouts. Configuring Depreciation Calculation Methods and Depreciation Keys.
General Controlling - Maintaining and Activating Controlling Area components, Maintaining Versions and Number Ranges.
Cost Center Accounting - Defining Planning Layouts and Profiles, Creating Assessment and Distribution Cycles.
Profit Center - Defining Standard Hierarchy, Dummy Profit Center, Versions, Planning Layouts and Profiles, Creating Assessment and Distribution Cycles.
Project Systems - Creating Project Profiles, WBS Elements and Settlement Profiles. Creating Allocation and Source Structures, Defining Coding Mask and Project Structures for OpexandCapex Projects.
Creating Validation and Substitution rules for PS master data based on Project Profile.
Performing and Validating PS Master Data and Balances data conversion.
Prepared Accounts Receivable ageing reports, CO Planning Reports and Fixed Asset Reports using Report Painter and Report Writer
Used Solution Manager to Store Project documents and for creation of transport requests for customization.
Tested the various BW Finance reports using BEX and BOBJ.
Trained the End Users and Super Users.
Performed Cut-Over and provided Post Go-live warranty support.
Client: Deurali-Janta Pharmaceuticals Private LTD, Kathmandu, Nepal March 2012 – August 2013
Role: SAP FICO Consultant
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 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.
Worked on SAP material valuation in CO-PC.
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.
Client:Nepal Life Insurance Co LTD, Kathmandu, Nepal Dec 2009 to Feb 2012
Role: SAP FICO Consultant
Responsibilities:
All onshore support activities related to FICO. Resolving issues related to Finance and Controlling.
Configuration of FICO relevant components required by client.
Involved in creating the Functional Specification / Estimation document and co-ordinate with the Technical team for the technical requirements.
Responsible for completing all the Unit Testing and the Service calls/Incidents as per SLA.
Worked in FI Sub-Modules which covers General Ledger accounting, Accounts Payable, Accounts Receivable, and Asset Accounting.
Worked in GR/IR clearing, Automatic clearing Issues
Issues related Invoice verification (MIRO)
Failed iDocs Processing
Defining New GL Accounts as per business requirement.
Verification of duplicate Customer & Vendor accounts before creating a new master data.
Month-end / Year-end Closing activities.
Functional testing for any new development in all three server’s development, Quality and finally in production server.
Preparing Root cause analysis document for the repeated issue or incidents as per the business process.
Preparing the end user training manual for each and every business process.
Providing online training for the business users if any new process step inn.
Documenting know error data base for future reference and swift action as a proactive measure.
Conducting monthly review meeting with the business SPOC for any suggestion and improvement in the currently following process as a value addition to the business.
Preparing the monthly MIS report for the incidents received during the month to the Senior Management.
In-house Cash (payments on behalf, intercompany netting)
Reviewing the pending transport request which is not yet moved to production server by giving the justification documents to the senior management on monthly basis.
Providing value addition to the business by analyzing the root cause analysis documents prepared for various incidents received during the month.
Worked on SAP production support tickets logged in support tool Remedy or Solution Manager
Member of the Internal Audit Group / FICO Support Team.
Journal Entry Posting, Parking of documents, Release / Post / Delete the parked documents.
New GL functionalities e.g. Document splitting, parallel accounting, Ledgers etc., Open Item Clearing
Hand on experience in FI Validations and Substitutions
Creation of Customer/Vendor Accounts Groups, Number Ranges, and Customer/ Vendor
Masters Creation in FI and Centrally, Payment Methods, Normal Payment Terms and
Installment Payment Terms, Down payment request, down payments and clearing
Invoice posting, credit memo and reversal of invoice and Credit memo
Customer/Vendor Payment and Clearing
Configuring changes in Automatic Payment Program and Dunning for Vendors/Customers if any