samir bader
Head Of Unit - Business Intelligence and Software Development at Al Mawarid Bank- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Arabic -
-
English -
Topline Score
Bio
Credentials
-
BS in Computer Sceince
Lebanese American University -
Oracle ( Admin, install and upgrade accelerator )
Oracle -
Oracle Database 12c: Backup and Recovery Workshop NEW
Oracle -
Oracle Database 12c: Managing Multitenant Architecture NEW
Oracle
Experience
-
Al Mawarid Bank
-
Lebanon
-
Banking
-
1 - 100 Employee
-
Head Of Unit - Business Intelligence and Software Development
-
Nov 2019 - Present
1. Lead Data warehouse, Business IntelligenceResponsibilities and Duties a. Create Modeling process between Different data Sources using SAP universe Design Tool, Differentiating the incremental and historical load with best approaches, plus using best schema in Modeling ( Star vs snowflake vs Galaxy schema ) in each integration project.b. Lead the ETL process between different source using SAP data Services , SSIS using the Best Approachesc. Create BI Report using SAP BI d. Creating Dashboard for business Users e. Create Procedures on Staging Area to ensure correctness of Dataf. Maintain the Database on Oracle for DWH for the Live and Staging Schemasg. Create Web Services from Data Warehouse to be used in Other applicationh. Major Projects :- DWH integration to Bank System : AML , CoreBanking, Credit Card,KYC- Automation of all Reportsi. Coach the Team on Weekly basis.j. Assign Tasks and adjust tasks to the timelinesk. Meet with PM team and assign Tasks accordingly to the Team2. Lead the Software Development Team Responsibilities and Duties i. Creating Programs using ASP.NET , C# , Javascript , JQUERY , WEBAPI , SOAP , REST and ASP.NET MVCii. Creating Core-banking Programs on AS400 using RPGLEiii. Creating Mobile Applications using Hybrid and Native Tools ( Java and Xmarine )iv. Creating Web Services Layer in order to intergarate to various system using C# WebAPIv. MAJOR PROJECTs- Digital Currency- KYC online Form- CRM for Bank- Customer Delivery Mobile Application - INTRANET Portal- Online Banking 3. Lead the Robotic process automation integration process Responsibilities and Duties- Merging new processes using Automation AnyWhere- Create best approach when creating new robot process- Handling all integration to all System with Best Approach
-
-
Business intelligence & Data WareHouse architect
-
Jan 2017 - Present
1. Lead Datawarehouse, Business Intelligence and Lead data warehouse technical team2. ETL Expert in SAP data Services and SSIS3. Design and build of dashboard 4 .Design and build of reporting databases5. Design and build of reporting databases6. Manage the DWH model7. Verify developments Standard8. Handle all Integration with DataWarehouse with Other applications9.Managing data warehouses and performing ETL with T-SQL and oracle10. Data modeling through developing SQL stored procedures, functions, and views (Attribute, Analytic, Calculation views) using T-SQL and SQL. As well as developing reports using Crystal Reports Designer, and Dashboards & KPIs using Microsoft Power BI, SAP Lumira, and SAP Analytics Cloud. 11. Conducting technical training sessions and support on Crystal reports, Microsoft Power BI, SAP Lumira, T-SQL.12. Modeling Data according to Business Needs ( star vs snowflake ) ( universe and Information Design Tool )Solution Architect1. Lead satellite application ( .Net , vb … ect )2. Lead satellite technical team3. Create integration with Equation using C# ( WEBAPI and MVC ) 4. Maintain and develop online banking solution5. Maintain and develop intranet solution6. Maintain and develop EBA ( vb6 ) front end cashier system7. Create out of box solution and application that integrates from core banking Equation.
-
-
Solution Architect
-
May 2014 - Present
-
-
Senior Business intelligence & Data WareHouse Engineer
-
Mar 2016 - Dec 2016
1. Datawarehouse and database analysis,design and modeling.2. Implementing Data Warehouse Using SAP & Oracle (SAP ETL and Oracle Procedures, Data Mapping, QA of Historical Data, Universes, and BI Reports, and Implementing Users and Security using SAP CMC)3. Data Mining through SQL, PL/SQL on Core Banking and Credit Cards Systems4. Assuring the Quality of prebuild Oracle procedures and functions of the Data Warehouse according to the business requirements needed5. Preparing Backup and Restore plans of the Data Warehouse Project (Oracle Database, Universes, and Reports)6. 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)7. ETL tools such as SAP Data service8. Reporting such as SAP BusinessObjects,Crystal Report,SSRS,...
-
-
Senior Software Developer
-
May 2014 - Mar 2016
1. Generating analysis reports using PL SQL on ITC System.( Tranzware)2. Creating .Net solution Based ( C#, Vb.net . Jquery ) - Creating Web Services REST and SOAP3. Web Based Applications Solutions for Financial Figures4. Generating Analysis reports using SQL on Equation ( AS400)5. Generation analysis reports using AS400 ( Equation).6. Managing Credit Card System using Tranzware7. Using ETL SAP8. Managing Credit Card System using Tranzware9. Business Analysis for Data warehouse project10. Using SAP interfaces to create reports11. Project coordination 12. Managing existing and new Projects13. Preparation, design and execution of on demand reports used for sales targets, performance evaluation, monitoring campaigns, auditing and control.14. Leading/Assisting in testing phases of a project.15. Creating system and business documentation.16. Data Modeling17. Creating In House application Using .Net18. As400 Programming19. EBA ( VB6 Corebanking Front-end application )
-
-
-
Netiks International
-
Lebanon
-
Software Development
-
1 - 100 Employee
-
Senior Web Developer
-
Jun 2011 - May 2014
1. Web Developer Using .Net Framework in both languages VB.net and C#. 2. Web Developer Using MVC 3. Web Application using Mobile JQuery with MVC44. Mobile application Using PhoneGap technology5. Web Developer Using Microsoft Entity Framework as DAL 6. Using JQUERY ,JavaScript and creating AJAX requests.7. Using WCF Services. 8. Creating Internet banking solutions.9. Web Developer using DotNetNuke for Content Managed Websites. 10. Creating Modules for DNN. 11. Creating Queries on SQL server. 12. Using ADO.net, PetaPoco for Data access layer. 13. Web Developer using Microsoft Web API 14. Web Developer using Microsoft SiganlR 15. Skinning Websites and using grid system for Responsive websites. 16. Good knowledge in UX, 17. Understanding the Business of CRM and developing customizations. 18. Creating Software Requirement specifications documents for projects 19. Creating the most suitable solution for maximizing the performance of the websites by reducing HTTP responses and bundling the code. 20. Optimizing SEO solutions. Major Website Developed1. www.creditbank.com 2. www.medsecurities.com 3. www.saudimed.com 4. www.ibl.com.lb5. http://invest.ibl.com.lb/ 6. www.businessLobby.net 7. www.arope.com 8. www.afc.com.lb9. www.excillisfinance.com10. www.holdco.co11. www.netiks.com12. www.4barchitects.com13. www.bankmed.com.lb
-
-
-
-
Web Developer
-
Feb 2010 - Jan 2011
Web Developer using DotNetNuke Framework for Content Managed Websites
-
-
Education
-
Lebanese American University
Bachelor's Degree, Computer Science