Sap Accounting

BANITA RATH e-mail: **********@*****.***

SAP FICO Consultant Contact No: +1-412-***-****

Overall 9+ years SAP IT experience in requirement gathering, technical analysis, Estimation, design, development & implementation of business applications for Manufacturing, Transportation, Banking, Insurance, Oil & Gas, Utilities, Pharmacy, Hospital, and Finance sectors.

In-depth knowledge and experience in SAP FI CO implementation and Revenue Accounting and Reporting (RAR), Revenue recognition, corporate accounting, S/4 HANA, central finance, cost accounting encompassing several projects, which are full implementation cycles from Blue Printing to Realization and Go Live.

Performed FI Configuration including FI Master Data, GL, A/R, A/P, A/A Treasury and New General Ledger, P2P, SAP S4 HANA, central finance.

Prepared and reviewed multi-state and local sales, use and other miscellaneous tax returns; researched tax compliance issues, and managed external audits. Assisted in month-end closing and perform other related special projects. Performed complex general accounting functions, including preparation of journal entries in accordance with GAAP.

Have hands on experience in cost accounting providing accounting support to various operating groups and manufacturing plants. Strong knowledge of GAAP relevant government regulations internal controls cost accounting methods and cost modelling tools and methods. Demonstrated analytical skills and an ability to interpret complex data in meaningful and relevant ways to accurately identify variances.

Configuration expert of New GL to meet requirements to report multiple accounting methods including US GAAP and IFRS and integration of FI with SD & MM.

Expertise in customization of SAP S4 HANA (1511 FPS02/1610), ERP ECC 6.0 version in FI-COPA modules.

Configuration improvement of Logistics Execution (LE) related to treasury storage types, storage sections, stock placement, removal strategies, route determination and transportation shipments

Responsible, detail oriented with strong technical, analytical, problem solving skills

Performed FI testing (FI-AR, FI-AP, FI-AA & FI-GL).

Excellent analytical, quick learning and problem-solving skills with a desire to work in a team oriented environment.

Worked on SAP ABAP code debugging, LSMWs, Idocs, BAPI, BADI, Function modules & reports & smartforms.

A team player with excellent presentation, communication and interpersonal skills.

Proficient in External Reporting and preparation of Financial Statements with good understanding of GAAP.

Adept in various financial processes including Auditing, Assurance, Accounting processes, Financial statements, Fund Flow Management, Reporting, Consolidation and analysis, Budgeting and Forecasting.

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

Ability to take on challenges and strong determination and can run extra mile to meet deadlines.

Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.

Created Design Documents for the HANA Models, both Functional & Technical specifications to build up the objects and to provide the team to work on.

Worked on Solution Validation specifications & Release Management, Hypercare and Support.

Involved in Setting up essential configurations for SAP ECC accelerations using SAP HANA

Involved in successful migration of SAP BW & ECC objects to SAP HANA.

Good experience in SDLC, Agile & SCRUM methodologies &Life Cycle.

Certified Business Transformation Developer.

Expert in Process & Data modelling and implementing them under both traditional BW as well as SAP HANA environment. Also experienced in data management and master data management related technologies

Worked on Interfaces, Enhancement, and Reports, Data dictionary Objects, debugged Standard programs based on business requirement and worked on performance improvement.

TECHNICAL EXPERTISE:

1. SAP S/4 HANA :

Expertise in customization of SAP S4 HANA (1511 FPS02/1610), ERP ECC 6.0 version in FI-COPA modules.

Responsible, detail oriented with strong technical, analytical, problem solving skills

Performed FI testing (FI-AR, FI-AP, FI-AA & FI-GL).

Worked on setup, integration and maintenance of SAP HANA Cloud Portal Applications & Widgets.

Got hands on expertise in SAP HANA Cloud products & related processes& services

2. SAP-ABAP:

SAP ECC 6.0

Worked extensively on SAP scripts & smart forms

Worked on Report (Interactive and classical)

Implemented ALV reports /LSMWs

Worked on Performance improvement of the objects (improved performance of the programs by40%).

Worked on issues related to BAPI, BADI & IDOC's

PROFESSIONAL EXPERIENCE:

1. Weill Cornell Medicine (Oct ’17- Mar 19)

Project Description: It’s the is the biomedical research unit and medical school of Cornell University, a private Ivy League university. It includes the Administration & Finance, Communications & Development, Patient Care, Research Support, Medical Business Administration, Facilities.

Roles & Responsibilities:

As a project manager Conducted and Coordinated Business Blueprint meetings for understanding client requirements.

Performed requirement gathering, blueprinting, project plans, testing plans, contingency and cutover plans, and post-implementation support

Developed work plans, documentation, managing deadlines and coordination of project team and sub-team activities

Determined required project skill set and work with IT/accounting/finance/client to identify specific resources (both internal and external resource requirements)

Coordinated project activities amongst the functional and technical team members as well as consultants

Coordinated upgrades and related testing activities

Worked on defining and agreeing on deliverables and milestones with stakeholders and communication to senior management

Prioritized projects and communicate to key stakeholders

Configured settings for Company code, posting period variant, assigned document number ranges, tolerance groups for customers, G/L accounts and users

Configured partial payments, exchange rate differences, payment advices, payment proposal/payment schedule, payment run, and payment media.

Worked on Sap S/4 HANA migration from ECC 6.0.

Worked on S/4 HANA migration work through prepare, explore, realize, deploy & run phase of the system.

Customized SAP S/4HANA FICO modules and sub ledgers: New GL & Splitting document, Taxes, Extended Withholding Taxes, Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets Management (AM), Treasury, Pretty Cash, Manual and Electronic Bank Statements (Multi cash), Cash Management and Liquidity Forecast.

Worked on project Execution for SAP Central Finance, SAP Central Finance Landscape Architecture, Basic Setup and Configuration.

Handled Initial Load and Real time Replication, Error Handling, Corporate Finance Processes supported by SAP Central Finance.

Involved in CFIN Run Phase, Validation and Reconciliation, Reporting

Implementation and maintenance of FI-AR, FI-AP master data of customers and vendors with open item processing.

Setup all incoming payments including Lockbox using EDI823, Electronic bank statement (EDI820)

Created origin-destination, house bank, partner profile, port definition, message types and logical message types

Configured payment program to process transaction from banking database.

Worked on implementation of vertex for to calculate the taxes at each tax jurisdiction level (federal, state, county, city, etc) based on zip code.

Upgraded auto clear program to process more open item after lockbox is processed

Configured automatic payment program, which included creation of house banks, company code payment methods, employee tolerances, terms of payment, and reason codes

Understanding the business scenario in the Q/A database and generate issue log to track issues in the following areas

General Ledger/ Chart of Accounts, Grants Management/ Accounts Receivable, Endowment and Other Restricted Funds, Asset Accounting – Equipment and building, Accounts Payable.

Performed the complete procure-to-pay process, including requisitioning, purchase-order management, and invoice verification.

2. Briggs & Stratton, SAP Consultant (April ‘16 – Sept’17)

As a team lead prepared, documented and maintained all documentation and processes for end users.

Conversion of year dependent periods to normal calendar month periods.

In corporate accounting, assisted the Controller in the preparation of the balance sheet, income statement, and cash flow reports. Prepared currency conversions before distributing consolidated results to our parent company in Switzerland.

Established and coordinated a consolidation model for a rolling 12 month forecast, a five year financial plan, and monthly budgets for the CFO.

Analyzed reports with the Accounting Director to confirm compliance with IAS, IFRS, and ICS policies.

Helped implement a new chart of accounts and an improved accounting software system.

Trained all new accountants and created a standard operating procedure for the management accounting department.

Responsible for billing, collections, cash receipts, bank reconciliations, accounts payable. Assist with monthly closing journal entries and account analysis. Review expense reports to assure they conform to company travel policy. Maintain books for self-funded Medical Plan.

Introduced a new invoicing system that reduced month-end turnaround time from 1 week to 1 day

Worked on Tax configuration for condition based tax procedure – TAXINN, VAT, CIN, TAXINN, Tax Procedure, and Tax Conditions. The customers who have already made the relevant changes for VAT 2003 would only have to make the changes accordingly.

Configured VAT (Value added tax) with enquiry, quotation & value addition.

In the VAT configuration worked on Defining Tax Procedure (OBYZ).

Assigning country to calculation procedure (OBBG)

Defining Tax codes for sales & purchases (FTXP)

codes 2 types A code-sales/output, V-purchase/Input tax & creating G/L Acct (FS00) VAT payable

Assigning tax codes to G/L Acct (OB40), after the above steps are configuration completed after TAX CODES are using in INVOICE POSTING.

Defined the tax conditions that are currently Non deductible as VAT Non deductible. This will enable you to address the transition to VAT at a later point of time. This would help in reporting Taxes on Sales/Purchases for the Tax Year 2005.

Worked on configuration done in SD-FI module.

Worked on COPA Profitability Analysis on Costing-based & account-based.

IN COPA worked on actual posting, Information system & planning.

Worked on SAP CO Profitability Analysis (CO-PA) used for the evaluation of Market segments which is classified according to products, customers, and orders.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Integrate all business partners, including designers, treasury, suppliers, manufacturers, and customers.

Collaborate efficiently with suppliers on product development, purchase-order management; invoice processing, and payment management.

Worked on travel and expense management.

Preparation of business blue print deliveries. The task involved identification of data conversions required, interfaces needed.

Worked on Best practices for an SAP RAR in project, from planning to go-live & walk through the configuration steps for Sales and Distribution and legacy-based revenue recognition.

Worked on processing revenue accounting contracts within the Revenue Accounting Engine (RAE), migrate old revenue data into SAP RAR, and generate reports.

Worked on Recognition of revenue percentage of completion from results analysis, Cost recognition and Capitalized cost of contract acquisition.

Worked on Master data mass maintenance and Migration work from Legacy system LSMW.

Collaborative work with the key users in the documentation of “As-is process”.

Performed data validation and account determination for mapping of the processes on to the SAP R/3 system.

Correct current configuration to meet customer requirements for Procure to Pay.(P2P)

Gap analysis with realization of open treasury issues and design of best fit functionalities.

Educating the client on FI and CO Master and transaction data information with Intercompany processing details.

Successful Implementation of FI (GL, AR, AP) and CO settings on the development server and ultimate transportation on to the testing and production servers.

Configured ERP structure and Financial Accounting global settings: key settings being company code, Business area, fiscal year variants, field status variant, open and close posting periods, document types and document number ranges and validations.

Credit management settings: key being credit control area and risk categories.

Configuration of interest calculation.

Configuration of Bank accounting, Asset accounting, Cost and Profit center accounting.

Preparation of LSMW data upload templates, testing and performing data upload. GL balances both cumulative and line item balances including vendor, customer and asset master data were loaded via LSMW technique.

Worked on debugging standard & custom ABAP programs to find out the root cause.

Worked on ALE IDOC, BAPI, Batch input methods for FI data conversion.

Maintenance and creation of vendor master data including the setting up of tolerance limits for employees. Defining and setting payment blocks

Assisted the Vendor Master Team with cleanup and validation of bank details for over 7,000 vendors paid via wire worldwide.

2. Leyland, Cap Gemini, SAP CONSULTANT (Jan’15 – Apr’16)

Project Description: Leyland is 4th largest manufacturer of buses in the world and the 16th largest manufacturer of trucks globally.

Roles & Responsibilities: Handled the project requirements with maximum effort of the completion of the project within specific time line and budget. Created design Documents for the HANA Models, both Functional & technical specifications to build up the objects and to provide the team to work on & worked on solution validation specifications & Release Management, Hypercare and Support.

As an individual contributor worked on the below:

Configured SAP financials (FI/COPA) and SAP Asset management.

Process re-engineering and change management. Worked on gathering business requirements worldwide, which include trips to Asia and Europe to validate the findings. Also responsible for heading up the definition of the client’s business processes, re-engineering said processes and implementing AP (FI-AP, FI-BL & MM-LIV) worldwide. This included the following:

Responsible for facilitating the gathering of requirements specific to treasury Accounts Payable from 34 sites in 20 countries (which included 13 different stand-alone legacy systems).

Profitability Analysis (COPA): Creating Operating Concern, Maintaining Characteristics, Maintaining User-Defined Characteristics.

Worked on Electronic bank statement (EBS) set up, house bank, bank file in specified format, Set up connection between SAP and bank for file transfer mostly secured (sFTP)

COPA: Maintaining Value Fields, Define Characteristic Derivation, Valuation, Assign Value Fields, Valuation Strategies, Set Up Valuation Using Material Cost Estimate, Assign Costing Keys to Material Types.

Worked on facilitating the creation of global business process flows related to Accounts payable; which includes FI-AP and MM-LIV invoice entry, exception handling and the payment program.

Variables for report, forms for report, create reports, Planning Versions, Layouts, Planning Methods, Excel Uploads, COPA master data, Transfer structures, COPA flows.

Configuration of Bank accounting. Responsible for creation of house banks and configuring the Payment Program with the related Bank Accounting Sub module Transactions in order to outsource payment execution to Bank of America for said countries. This included:

Worked on analysis of the current banking structure and interfacing with the Bank responsible for the ‘single source’ data transfer approach. Configured the payment program itself, including up to 6 different payment methods for each country.

Acted as a liaison with BOA to clarify the requirements from both the client and banking sides.

House bank creation including the usage of EDI related fields required for the creation of IDOC in ABAP (which were the means of transmitting the data to the bank via FTP). Creation and usage of bank chains for both Vendors and House Banks. Documented and trained team members on the usage of bank details for 43 different countries to enable the client to pay said vendors via wire.

Experience in SAP integration methodology, utilizing ALE, IDOC, BAPI, RFC and BDC objects.

Maintenance and creation of vendor master data including the setting up of tolerance limits for employees. Defining and setting payment blocks.

Assisted the Vendor Master Team with cleanup and validation of bank details for over 7,000 vendors paid via wire worldwide.

Worked with the Treasury consultant on interfacing the needs of the Treasury department with those of the Accounts Payable Departments worldwide.

Data Conversion for devising and implementing the approach used in loading both AP open items and GL balances into SAP.

Analyzed requirements for processing Intercompany AR & AP transactions. Creation of initial specifications for configuring and implementing Intercompany functionality.

In addition, I was responsible for co-managing the AP portion of the project, which included creating the scope document, the project plan (which included a projecting a go-live date) and the scope document.

Responsible for the Post Go-Live Support of the US region. This includes interfacing with the Accounts Payable and Purchasing departments to implement temporary business processes to manage the transfer of unconverted legacy data into SAP.

3. Valeo, Accenture, SAP Consultant (Mar 2013 – Jan 2015)

Project Description: Valeo is a multinational automotive supplier based in France, providing a wide range of products to auto manufacturers and after-markets. It is a member of the CAC 40 share index.

Roles & Responsibilities:

Customizing and Configuring Chart of Accounts, Account Groups, Assigning Chart of Accounts to Company Codes, Templates for Configuring Recurring Entries in GL Postings, Document Types, Number Ranges, Tolerance Groups, Field Status Groups, Posting Keys, Document Reversals, Invoices and Payments, Defining Account assignment models.

Setting up credit master data of customers. Configured credit management. Set up account assignment for different order types and pricing conditions.

Defined risk categories, processing incoming payments & applying it to account, with types (full, partial or residual).

Maintained accounting clerks and generate account statements and other periodic correspondence. Defined payment terms and interest calculation.

Defined employee and customer tolerance groups Configuration of Bills of Exchange and down payment process. Created primary and secondary cost elements and cost element groups.

Configured Tolerance limits for customers and managed A/R reconciliation account for sub-ledgers for customers.

Imparted User-training on FI-GL, AR and AP processes.

Accountable to the organization for the development and organization of all the matters related to FI (G/L, A/P, A/R, AM) and CO end users, including creation, editing and maintenance of documentation. (R/3 v2.2).

Allocation of quality costs to production cost centers, Period-end closing activities started for production orders, Actual assessment of all cost center costs to profitability analysis (COPA) is run, Analyze costs and revenues for your products, Cost Element planning, Internal Activity planning, Planning Statistical Key Figures, Cost planning using a Template, Overhead allocation using a Costing Sheet, Overhead allocation using a Template, cost estimates

Development of Document Management Plan; including tracking database, policies, procedures and ISO 9000 requirements for the maintenance of training documentation.

Assisting Project Leader in management of internal and external matters related to global SAP implementation.

Accountable for all tasks related to the creation and maintenance of training materials. Also accountable for the delegation and completion of all tasks relating to training materials.

Prepared and coached functional team members in the instruction of SAP material.

Retrieved SAP authorization objects to assist in the development of security profiles.

Revised methodology pertaining to the final phase of end user training program.

Worked on troubleshooting design and performance issues

Setup and monitored collective run jobs for SD module in LO Cockpit

Monitored loads for SD module from R/3 source system

Corrected delta load failure for SD module

•Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains

•Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions

•Involved in frequent client meetings to discuss project status

4. Halliburton Development, Accenture, SAP Consultant (Mar 2011– Mar2013)

Project Description: Halliburton Company is an American multinational corporation, and one of the world's largest oil field services companies, with operations in more than 80 countries

Roles & Responsibilities:

•Provided monthly expense analyses to accounting, marketing, sales, and human resource managers

•Prepared the consolidated financial statements for nine entities

•Reconciled receivable accounts and provided billing information to A/R to support monthly invoicing

•Prepared, distributed, and uploaded payroll entries for over 100 employees

•Financial focal point for a two million dollar business software upgrade

•Maintained a monthly hedge valuation analysis to book market value

•Recorded journal entries and accrued for costs in accordance with GAAP

•Prepared account reconciliations and budget comparisons

•Assisted Chief Accountant with month-end financial close and reporting

•Participated in multi-functional committees and task forces

•Set standard costs for all products and directed the implementation of cost accounting methods and activities

•Oversaw the cost control systems managed and interpreted cost audits and prepared cost accounting reports for presentation to upper management

•Accumulated and applied overhead costs as required by generally accepted accounting principles

•Reported on breakeven points margins and periodic variances by products and work centers

•Investigated cycle counting variances and resolved issues working with the production manager to locate and dispose of obsolete inventory.

5. Caterpillar, Accenture, SAP Consultant (June 2010– Mar 2011)

•Project Description: Caterpillar is the world’s leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. The company principally operates through its three product segments - Construction Industries, Resource Industries and Energy & Transportation - and also provides financing and related services through its Financial Products segment.

•

•Roles & Responsibilities:

•Analysis of business requirements, develop functional specifications for development activities including reports and enhancements.

•Configuration tasks of the Organizational structure of GL, AP, AR, CCA.

•Configured General Ledger settings for Company code, posting period variant, assigned document number ranges, account groups, Account maintenance and interest calculations etc.

•Configured AP module including the Vendor Master Data / Number Ranges, Automatic Payment Program, Recurring Entries, Invoice posting

• Configured AR Module including Customer Master Data, Customer Tolerance Groups, Customer Down Payments, Customer invoice posting and clearing (open item management), Transaction types: Invoice, Credit Memos; AR Reconciliation, Payment Terms, Interest Calculation (Invoice Statement pay), Partial and Residual Payments, Dunning procedures

•Involved in data migration from legacy systems to SAP system using LSMW.

•Developed AR custom report for month end closing to capture every detail of Closed and Open Customer invoices.

•Configured the controlling area, cost elements, Cost centers (CO-CCA), Number ranges, Cost center hierarchy.

•Configured settings for Controlling Area and Operating Concern.

•Created Primary and Secondary Cost elements.

•Maintained Cost Element Attributes, Costing Sheet and maintained accounts for automatic reconciliation posting.

CERTIFICATION:

Certified in Business Transformation through SAP HANA.

Accenture Green Field Training certified in SAP.

ACADEMICS

B. Tech. in Computer Science, College of Engineering and Technology, Bhubaneswar, India

Contact this candidate