Apps & BI Consultant
DOHA BANK
Total years of experience :17 years, 0 Months
Projects:
•Qatar, Kuwait and UAE central Banks reporting projects.
•Data warehouse development and implementation projects.
•SAP BO reporting and ETL development projects.
•Back Office systems development and reporting using oracle development suite.
Responsibilities:
•Reports development in Web Intelligence, Desktop Intelligence and oracle reports.
•Designing and manage ETL for central Bank, management and business users financial reporting requirements.
•Data warehouse planning and designing.
•Conducting multiple level business users training. Enabling them to full fill there adhoc reporting needs in timely manner.
•Management of all vendor based projects related to central Bank Reporting.
Projects:
• Oracle Business Intelligence Support.
• Oracle R12 Inventory, Purchasing (Reports Development)
• Freight Management System & Payroll System (Forms & Reports Development)
Responsibilities:
• Support Ongoing business quires related to dash boards and business intelligence.
• Develop new forms & reports as per functional and business specification.
• Up-gradation of existing customized forms/reports using Oracle & SAP development tools.
• Customization in E Business Suite.
Projects:
• Oracle utility Customer care & billing (Reports development)
• Oracle R12 Inventory implementation (Reports development & Form customization)
Responsibilities:
• Develop and upgrade forms & reports using oracle reports and crystal report.
• Ad hoc querying and report development for Oracle Customer care and billing.
• Sales forecast and consumption consolidated reporting for higher Management.
• Deploy & Configure customized Forms/reports in Oracle ERP Application.
• Maintenance of personalization & Customization in oracle Inventory.
• Identify open interface tables & APIs to upload data in standard object’s tables
• Design and configure control files to upload legacy system (Item, Flex Filed, Item balances) data in oracle database through SQL*Loader.
• Technical support to resolve day to day problems and issues.
Develop new forms & reports for miracle worker.
Consolidated report development for management.
Packages for GL, Recovery and month end consolidation.
Migration PL/SQL Stored procedures, functions and scripts that transform data with old structure to new structure.
Migration Pre & Post Data validation scripts.
Develop utility interface to integrate Miracle worker with Oracle Financials.
•Designed and developed Surveillance System of Lahore Stock Exchange (G) Limited.
•Backend Programming using PL/SQL, for development of Stored Procedures, Packages, Database Triggers.
•Troubleshooting and resolving issues in various aspects of the trading modules like inter-exchange, Off-Market and cross-market transactions etc.
•Responsible for Reports development of Lahore Stock System.
•Involved in coding of data extraction and loading from text, excel or zip format as per technical specifications
•Working with automation of Microsoft Office with Oracle Forms (Word, Excel and Outlook).
•Timely response to in-house queries and troubleshoots system issues in timely manner.
OCA
Scholorship received for Bachelor`s Degree on bases of Competition test.
6 months certification in multimedia. (Flash,photoshop)