Sr Software Engineer
Al Rajhi Bank
Total years of experience :15 years, 4 Months
Al Rajhi is one of the biggest Islamic Bank in the world, providing Islamic personal, auto and home financial banking services and corporate banking investment solutions in Saudi Arabia. Major engagements with Al Rajhi include: -
• Engaged in the implementation (Installation & Configuration) of OBIEE 12c Server Client Architecture from the Scratch with Oracle Database on the RedHat Linux.
• Engage to Connect OBIEE with Teradata and Cloudera Hadoop.
• Administration, maintenance and deployment of OBIEE from one environment to Others.
• Business Interaction to get the requirements, provide the solution and build the solution on OBIEE on behalf of the BRD.
• Engage in all the Development of OBIEE regarding the Repository and Analytics Web.
• Engage in security implementation (Both OBIEE Default Security & External Table Security) for all the module implementation in OBIEE.
PROJECT HIGHLIGHTS:
Pakistan (PK) - Oracle TimesTen In Memory DB Implementation for UBL
Successfully Implemented as a Lead the Pakistan UBL project which is based on Oracle TimesTen In Memory Database. UBL currently using Qlikview for our core banking processes now they are moving on Oracle and due to huge records or for max efficiency they want to implement Oracle TimesTen In Memory database for our core banking processes. I am responsible for all the development from Scratch to Live like to Create Linux based server, Oracle DB installation, OBIEE Installation and Oracle TimesTen In Memory Database Installation and Configuration also Integrate it with the OBIEE. After that create a model in the RPD and then create all the 40 Qlikview reports on OBIEE with the same security and restrictions.
AbbuSys - BI Apps 11.1.1.x.x and BI Mobile App Designer Implementation
Implemented the BI Apps 111181 and 111192 (ODI & OBIEE) successfully, configure all business rules, load the test data for Financial, HR and Procurement into warehouse, create some custom reports and also implement BI Mobile Designer App in my own company for one of the clients in future.
River Island (UK) - BI Apps 7.9.6.x Implementation
Successfully Implement BI Apps module HR & Payroll, Finance and Procurement with EBS as a lead in River Island. Created the Linux and windows based BI client server architecture, performed up gradation of OBIEE from 111170 to 11117143, make and build the model of Time and Labor in BIApps 7.9.6.4, Configure the security with respect to the Application Role on object level and Data Level. Successfully implement the security integration of EBS to OBIEE with single sign on.
Christies (UK) - OBIEE 11.1.1.x Implementation (Onshore)
Lead the OBIEE Implementation in Christies. Involved in Data Modelling, Configured OBIEE 11g machines upgraded the Christies custom model and merged it with vanilla one in OBIEE 11g. Responsible for all new developments and changing’s regarding Administration Tool (Repository), Web development (Dashboards and Reports), Security related OBIEE 11g also the RPD and Web Catalog Migrations.
Pakistan (PK) - OBIEE Implementation for UBL
Lead the OBIEE Implementation in UBL. Successfully created a Linux based BI Client server architecture (Installation & Configuration of Oracle Database and OBIEE 11.1.1.7) in UBL. Migrated UBL discoverer RPD to OBIEE, Made the complete Business Models with respect to the standard OBIEE practices as per client business requirements. Developed 40 professional discoverer Reports with proper OBIEE functionality, create users and groups, applied the security and privileges with respect to users and groups. Also implement the SSL on OBIEE.
Asia Capital PLC(Srilanka) - OBIEE Solution
Worked as a Senior OBIEE Developer and successfully implemented OBIEE 11g on their current Back Office System of Asia Capital (Investment Banking) Srilanka.
Christies (UK) - Client Comments & Campaign Management
Worked with a Senior Consultant, the purpose of the Client Comments project is designed to enable the Team Managers to consider the progress of their Team, employees and life cycle of any Client Comments.
BMW (Germany) - Showcase
Implemented BMW QuickWin Project with a Senior Consultant. The main idea for the project is to make repository presentation layer consistent in terms of user perspective without affecting any of the existing reports, increasing the ETL performance, reduce number of facts and align business model mapping. Responsibilities include, however not limited to, gathering requirements from clients, making effective design, having knowledge transfer among team members and making sure all the requirements are completed accurately and timely.
The Company for Cooperative Insurance in Riyadh offering various insurance products commensurate with the needs of the community of individuals and companies in accordance with the cooperative concept that is Islamic-ally accepted. Major engagements with Tawuniya includes: -
• Engage in ETL (Informatica) and Dimensional Model review and enhancement suggestions for new Oracle Based Enterprise Data warehouse implementation.
• Engage in OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, dimensional modelling using Star schema in Data warehouse life cycle.
• Configured DAC to manage ETL process for OBIA Analytics.
• Administration and maintenance of OBIEE, OBI Applications, DAC and Informatica.
• Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle and others.
• Creating and Deploying SSRS Reports and report models on the report manager for user accessibility.
• Developing & deploying cubes using SQL Server Analysis Services involving multidimensional data.
• Share Point configuration, Design SSAS cube-based Dashboard and Reports also link the Report Manager Reports to SharePoint and control the security for the Users and Managers
• Scheduling jobs with SQL Server Agent.
• Development and maintenance of MS BI Data warehouse and reporting system.
• Collaborated with end-users and responsible for all the development and documentations.
MCIT ( Masters In Computer Science & IT )
I have worked and completed the course ISMS 27001 as an internee in PSO (Pakistan State Oil) also taken some session on SAP.