• Working as a team member of Glencore’s Business Analytics Team (Data Warehousing Team)
• Understanding the Business requirements with business analysts/users and creating the proof of concept to evaluate technology as to fit business need.
• Involved in preparing system d

• Working as a team member of Glencore’s Business Analytics Team (Data Warehousing Team)
• Understanding the Business requirements with business analysts/users and creating the proof of concept to evaluate technology as to fit business need.
• Involved in preparing system design documents for the new systems and Involved in database design for the new systems in DWH (new data marts)
• Involved in developing ETL process to migrate table data from Oracle into Sybase IQ (using Load Table … Client File concepts)
• Developed PL/SQL Packages for sending/receiving report extract data for regulatory authorities/clients
• Involved in database design for the system based on the business and regulatory requirements (new data marts)
• Involved in writing Unix shell scripts for the ETL process and schedules using Active Batch scheduling tool
• Involved in reports development using SAP Web Intelligence; also involved in Universe design/maintenance
• Developed new Webi reports in BO based on SAP BW (BEx) queries using BICS connection
• Contributed to Deski to Webi Migration project and its successful completion till analysis phase to Go-live
• Developed application forms using Oracle Forms 10g.
• Developed Dashboards and Reports in QlikView tool using Excel extract files and QVD files for Compliance Team.

eGRC system offers multiple role-based solutions which are seamlessly integrated. Departments across the financial organization are able to work from one common risk taxonomy, focused on business objectives and with a common language for internal audit, risk, and compliance. Additiona

eGRC system offers multiple role-based solutions which are seamlessly integrated. Departments across the financial organization are able to work from one common risk taxonomy, focused on business objectives and with a common language for internal audit, risk, and compliance. Additionally, the BWise platform makes it easier for companies to identify, understand, measure and manage key organizational risks on a holistic level.

Responsibilities - Involved in requirement gathering from Audit, Risk, Compliance and Internal Control

Departments of the Bank

- Involved in complete study of Bank’s eGRC system and prepared customized reporting templates for different departments.

- Involved in System Analysis, Design/development for the reporting module

- Involved in Designing database (datamart) - tables, views and procedures development for the reporting module (datamart) using Oracle PL/SQL

- Involved in BO Universe Design for the whole reporting module

- Involved in Web Intelligence Reports (around 60 new reports) and also co-ordinated with all 4 departments business users throughout UAT cycle till Go-Live

Responsibilities - Understanding the Business requirements with business analysts/users and creating the proof of concept to evaluate technologyas to fit business need.

- Involved in system designand architecture, process and data flow diagrams

Responsibilities - Understanding the Business requirements with business analysts/users and creating the proof of concept to evaluate technologyas to fit business need.

- Involved in system designand architecture, process and data flow diagrams

- Written high level and low level design documents (FSD, USD) and end user guides

- Involved in database design for the system based on the business and regulatory requirements

- Developed user interfaces using Oracle Forms for salary file upload, files transmission monitoring, error files display, etc. and developed reports using Oracle Reports tool.

- Developed database components (packages, procedures) for the whole system

- Developed WinSCP (FTP) scripts for auto transmission/receivefiles from Central Bank site.

- Developed user report interfaces using Oracle forms to call other SAP BO (webi) MIS reports using OpenDoc methods

Other Tasks - Involved in reports development using Webi and Deski; also involved in Universe design/maintenance

- Developed Webi reports for Doha Bank’s Risk/Compliance Teams

- Developed ETL batch jobs to automate the Salary files transmission for WPS system

Description The purpose of this project is to migrate/upgrade Bank’s Business Intelligence Reporting platform from Business Objects XI version to latest SAP Business Intelligence 4.1 Platform.

Role BI Consultant

Description The purpose of this project is to migrate/upgrade Bank’s Business Intelligence Reporting platform from Business Objects XI version to latest SAP Business Intelligence 4.1 Platform.

Role BI Consultant

Responsibilities - Involved in preparing hardware/software requirements for BI 4.1 platform

- Involved in BI 4.1 server installation and configuration (File Store, FTP, Arabic language configuration, etc.)

- Migrated all existing Universes, Web Intelligence and Desktop Intelligence reports into BI 4.1 using Upgrade Management tool

- Configured Desktop Compatibility Pack (DCP) in BI 4.1 to access old Desktop Intelligence reports

- Involved in reports development using Web Intelligence and Desktop Intelligence; also involved in Universe design/maintenance

- Involved inpreparing user manuals for Business Users on BI 4.1 Platform