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.
- مجال الشركة:
- الإنترنت والتجارة الإلكترونية
- الدور الوظيفي:
-
تكنولوجيا المعلومات