Experience

AM BANK

• Lebanon
• Banking
• 1 - 100 Employee

• Business Intelligence and data warehouse officer

  • Mar 2016 - Present

  •Create Modeling process between Different data Sources using SAP universe Design Tool•Load the ETL process between different source using SAP data Services•Create BI Report using SAP BI•Create Procedures on Staging Area to ensure correctness of Data•Maintain the Database on Oracle for DWH for the Live and Staging Schemas•Create Web Services from Data Warehouse to be used in Other application•Creating Core-banking Programs on AS400 using RPGL•ETL Expert in SAP data Services•Merging new processes using Automation AnyWhere•Design and build of reporting databases• Manage the DWH model•Integration with DataWarehouse with Other applications•Managing data warehouses and performing ETL with T-SQL and oracle•Conducting technical training sessions and support on Crystal reports, SAP BI• Modeling Data according to Business • Maintain and develop EBA ( vb6 ) front end cashier system•Implementing Data Warehouse Using SAP & Oracle (SAP ETL, Oracle Procedures, Data Mapping, QA , Universes, and BI Reports, and Implementing Users and Security using SAP CMC)•Data Mining through SQL, PL/SQL on Core Banking & Credit Cards Systems•Assuring the Quality of prebuild Oracle procedures and functions of the Data Warehouse according to the business requirements needed•Preparing Backup and Restore plans of the Data Warehouse Project•SAP Business Objects (Universe Design), SAP Data Services, Sap Business Intelligence (Web Intelligence), Dashboards, Crystal Reports, Microsoft SQL Server (SQL Server Management Studio and Business Intelligence development Studio)•ETL tools such as SAP Data service•Generating analysis reports using PL SQL on Tranzware•Generating Analysis reports using SQL on AS400•Managing existing Projects•Preparation, design and execution of on demand reports used for sales targets, performance evaluation, monitoring campaigns, auditing and control.•Assisting in testing phases of a project.•Creating system and business documentation.•Data Modeling Show less

• Junior Business Intelligence and data warehouse officer

  • Jul 2015 - Mar 2016

  1. Creating Analytical Reports ( Revenues, retention, ect ... )2. PL/SQL programming3. Data Modeling4. Creating Universes Using SAP BO5. ETL using SAP Data services6. Automate Monthly reports7. Crystal Reports



NIT – New Information Technology sal

• IT support

  • Nov 2014 - Feb 2015

  training on software use in addition to software and hardware maintenance training on software use in addition to software and hardware maintenance