SAP FICO & BOBI CONSULTANT (Finance Certified)
Amazon.ae
Total years of experience :9 years, 8 Months
CONTRIBUTION - BOBI REPORTING
• Involved in BO projects spanning full life cycle, responsible for requirement gathering, technical design, development and testing.
• Created Attribute view, Analytical and calculated view
• Used SQL script, tables joining, filters for extracting data from different sources like SAP and Back office systems.
• Established the relational connection with the database (SAP & Non SAP systems)
• Created data foundation, business layer and universes on the connection established and published the universe to the repository.
• Created webi reports on the universe and Queries in Query Designer, using various activities such as Variables, Restricted Keyfigures, Calculated Keyfigures, Filters, Exceptions, based on the business requirement.
• Dashboards are based on the data extracted from different databases like SAP and Back office ERP (Non-SAP) systems.
Contribution: (Finance related activities)
• Rollouts for six subsidiaries of Souq.com (GL, AP, AR, AA, Cash & Bank accounting and controlling modules)
• Successfully completed the project of third party interface for payments with HSBC.
• Withholding tax implementation for a company code in Egypt.
• Configured the automatic payment program for multiple company codes and training provided for business users.
• Maintained vendors bank details in vendor master for 8 company codes using LSMW.
• Configuration of multiple cash journals.
• Configuration of house banks, automatic payment program and bank reconciliation accounts.
• Configuration changes in country specific bank field check.
• Department wise auto GL account set created for PO creation (FI - MM integration).
• Country specific settings for VAT and Withholding tax.
• Issues resolving related to VAT, Automatic payment program, Asset accounting, General ledger, AP & AR, Cash journal and Bank accounting.
• Created SHDB recording for developing IBAN upload program with the help of ABAP consultant.
• Extensively involved and exposed to integration issues of FI with SD, MM & HR.
• Coordinating with users for giving acceptable solutions to problems, queries raised by them within predefined time limits based on the priority of the issue.
• Created multiple Z reports by coordination with ABAP consultants. (vendor and customer masters, asset register, VAT printout in local currency, general invoice printout in other than local currency, vendor swift upload program, master data program, assignment change program, intercompany invoice, vendor and customer balance programs, Input vat register etc.).
• Resolving of period end closing related issues and support providing to business users which are located in multiple countries.
• Participated in Streamline project. (Souq to Amazon)
• Created and maintained new number ranges, cost centers, profit centers and internal orders as part of streamline project.
• Master data upload for new company codes using LSMW.
• Actively participated in SD reconciliation including sales order creation, delivery, AWB, PGI and billing processing.
• Cancellation of billing, AWB, receiving text maintenance, date change of invoice document in SD screens.
• Location code creation based on plant for asset master record. Resolving errors related to FI-MM integration.
• Extracting data from multiple tables for providing periodic reports to Auditors and tax consultants.
• House banks creation, configurations of new cash journals, and creation of additional business transactions for existing cash journals.
• Configured intercompany accounts, helping users in retirement and scrapping of assets.
• Blocking of Mass GL accounts, maintaining of open item management for GL accounts.
• Resolved issues in automatic clearing.
• Transporting of configuration changes from Dev server to QAS server using STMS.
• Extracted data from different tables for reporting, as requested by internal auditors and business managers.
Contribution :
• Providing support and training for SAP FI routine tasks of FI-GL, FI-AR & AP, FI-AA, FI-BK and taxation.
• Providing assistance in financial reporting and form development for SAP FI module.
• Requirements gathering for SAP FI reports and forms from end user and collaborating with SAP technical team for Development and Testing.
• Master Data Maintenance for FI-GL, responsible for Creation and Changes of General Ledger accounts and their relevant cost elements in SAP.
• Providing assistance in month and year end closing.
• Master data maintenance for FI-AP & AR responsible for creation and changes of vendor and customer accounts in SAP. Providing support for cost center, profit center, internal orders creation and assignment of cost elements to gl accounts.
• Extensively involved and exposed to integration issues of FI with SD, MM & HR.
• Used ticketing system to solve business users issues.
• Worked with ABAP consultants to develop and test custom programs and reports like vendor and customer ageing reports, Invoice printout, Z reports for revenue and payroll preparations.
• Assistance provided in Payroll preparation. (FI- HR Integration).
• Lock/unlock the payroll control record.
• Assistance provided in asset accounting like depreciation run, acquisition and retirement of assets.
• Issuing resolved in intercompany transactions.
• Worked with technical team to configure auto check printing after payment process.
• Coordinated in configuration of electronic bank statement
• Enhanced and resolve issues relating to payment program.
• Ensure resolving the tickets with in the stipulated timeline.
• Provided end user training.
Contribution :
As team member of FICO implementation, performed tasks as per team lead requirements.
• Interacted with client for requirements gathering and analysis, Reviewed and updated the functional design documents for FI/CO developments
• Meet regularly with client to evaluate and suggest changes in process that will enhance the use of SAP.
• Conducted AS - IS study of the business processes and finalized the To - BE process. Configuring and testing of the TO -BE process.
• Configured Company code, business area, controlling area, chart of accounts, chart of depreciation, fiscal year, posting periods, tolerance groups for employees, customer and vendors.
• Configured Automatic Payment Program and payment terms for vendors.
• 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, Configuration of terms of payments and interest calculation on open items/ balance outstanding.
• Configured tax on sales & purchases.
• Configured asset master groups, chart of depreciation, assignment of GL accounts for asset classes and creation of depreciation key.
• Configured house banks, bank reconciliation and cash journals.
• Configured and maintenance of Foreign currency exchange rates.
• Configured withholding tax.
• Creation/ upload of master data of GL, vendor, customer, assets, cost center, profit center and internal orders.
• Interacted with ABAP team for converting transaction data from legacy systems to SAP R/3 via ABAP programs.
• Used LSMW tool for data conversion and transfer and upload data.
• Worked with ABAP consultants to develop and test custom programs and reports.
• Participated as a team member to integrate FI/CO with other modules like SD, MM & HR.
• Participated in unit testing and integrated testing
• Prepared end user manuals.
• Provided support after go live on routine and month end activities.
• Roll out done for two other sister companies.
• System configuration and testing in the areas of Fi-GL transactions, configuring adjustments accounts for GL, AP & AR.
Key Responsibilities Handled:
• Responsible for Day-to-day transactions
• Knowledge & experience in preparing Bank Guaranties & Letter of Credits (LC).
• Maintenance of petty cash
• Preparing salaries statement and entries in the system
• Vendor invoice verification based on purchase order, delivery note and posting in system.
• Payment to vendors based on payment terms mentioned in purchase order.
• Vendor and customer account reconciliation.
• Invoice generation, preparation of vouchers and posting using tally
• Dealing with suppliers and customers.
• Preparing cheques for suppliers.
• Bank reconciliation.
• Credit limit and credit control for customers.
• Accounts payable and accounts receivable
• Maintaining accounting records.
• Preparing cash and cheque payments.
• Coordinating with team members.
Key Responsibilities Handled:
• Maintaining petty cash and Posting cash journal entries in SAP System.
• Preparing invoices in SAP System
• Co-coordinating with team members.
• Payroll preparation
• Preparing cheques for Suppliers in SAP System
• Accounts payable and accounts receivable
• Maintaining accounting records.
• Dealing with Customers
• Dealing with Hotels
• Preparing cheque payment vouchers, cash payment vouchers, cheque receipt vouchers.
• Online banking.
• Bank reconciliation (Monthly wise, daily wise).
• Preparing and transferring Salaries & Wages through UAE WPS (Wages Protection System) system
• Supported in resolving day-to-day end-user issues pertaining to FI (sub-modules include General Ledger Accounts Payable Accounts Receivable and Asset Accounting)
Key Responsibilities Handled
• Preparing and transferring salaries & wages through UAE WPS (Wages Protection System) system.
• Maintenance of petty cash
• Preparation of Purchase indents, Purchase orders and Quotations
• Dealings with vendors. Response for vendor payment calls.
• Cross verification of supplier invoices with purchase order and delivery note and posting it into system.
• Invoice generation, Preparation of vouchers and posting using E-Promise
• Making payments for sub-contractors and suppliers.
Knowledge & experience in preparing Bank Guaranties & Letter of Credits (LC).
• Preparing cheques payment vouchers, cash payment vouchers, Cheque receipt vouchers.
• Bank reconciliation ( Monthly wise, daily wise)
• Billing for sub-contractors
• Issuing cheques to creditors
• Preparing payment certificates according to the data given by Q.S department and all other departments.
• Other accounting duties.
Key Responsibilities Handled
• Main responsibilities are dealing with customers and suppliers.
• Tracking of customer payments.
• Call for quotations from customers and preparation of purchase orders.
• Invoice posting after verification.
• Accurate maintenance of accounts.
• Reconciliation between company’s data and vendor & customer statement.
• Petty Cash maintenance.
• Day to day transactions.
• Preparing cash payments and cheque payments.
• Preparing invoices
• Preparing cheques for Suppliers
• Involved in preparation of financial statements, month end and year end closings.
• Bank reconciliation
• Maintaining branch accounts.
Key Responsibilities Handled
• Dealt with Account payable & Receivable.
• Reconciliation of Bank Books
• Financial Statements preparation.
• Cash flow management.
• Coordinate with Mutual Funds, DP and PAN card sections.
• M.Com- Finance from Nagarjuna University, Andhra Pradesh, India
• B.Com from Nagarjuna University, Andhra Pradesh, India.