Manager - Systems Application
Gulf Bank Kuwait
Total years of experience :22 years, 5 Months
• Dealing with the SAP BO vendors for the organization.
• Managing the project implementation of Business Objects Enterprise Xi 3.1 bank-wide
• Re-designing tables in Data warehouse to gain space and to make querying more efficient
• Handling bank-wide DWH related BO reports upgrade from BO 5.1.8 to BO Xi 3.1
• Creating ETL jobs for Data Warehouse using Business Objects Data Designer with automated alerts for failed jobs
• Setting of job naming conventions for SAP BO Data Services and in Data Warehouse
• Configurations of Scheduling and Publications in BOE to reduce workload and manual processes.
• Advising ISS regarding the BOE application security.
• Advising ISS in setting up the AD integration with BOE.
Accomplishments:
• Served as an In charge of:
o Project of retrofitting business unit’s requirement into DWH
o Business Objects Universe & Reports Design
o Business Objects Data Services (ETL) Job Design
• Instrumental in upgrading the SAP Business Objects Data Services from version Xi 3.1 to xi 3.2 and assisted DCO to set up DR and BCP
• Played a key role in the system maintenance and support in a production environment as required by the DCO
• Distinction of supporting the PCI-DSS project by handling the data warehousing aspect of the project.
• Successfully streamlined:
o Processes for marketing division
o Manual processes
• Efficiently streamlined reporting processes in Marketing Division which was:
o Initially scattered and partly reported through Manual Excel and MS-Access Queries which took 2 days to get the basic data and then 10 days to create the reports
o Automated this in DW and reduced the reporting time from 10 days to 2 days, wherein the 2 days is just for refreshing the 60+ reports by the user
• Designed and developed various reports using Business Objects via universes and free hand queries.
• Designed, developed and maintained the back up procedure for the Business Objects in need of recovery
• Prepared and maintained daily MIS in business objects setup; this helped in eliminating the manual task of individual SQL query execution
• Used batch files and VB code to create schedulers for regular refresh, printing and saving of these reports at various locations bank-wide
Accomplishments:
• Efficiently provided regular BO user training to the senior management and the bank’s various business units
• Successfully streamlined Finance Division’s process’s thereby reducing the delivery time of reports
• Pivotal in converting the bank’s GL reports to Islamic Banking standards on the bank’s conversion to Islamic Banking and changing of the whole GL structure
• Distinction of single handedly implementing the project of online upload submission of regulatory reports as per regulatory specifications
• Served as a point of contact between the regulatory and the bank for any technical reporting issues or development
• Instrumental in installing, troubleshooting, upgrading and maintaining
o Business Objects for production environment
o Business Objects Xi R2 for DRS and BCP environment and for the regular BCP & DR bank-wide tests
• Streamlined manual processes related to the Finance Division’s MIS Reporting Unit which used to initially take 3 hours to input 1 day data for one report
o Automated that one report to take 5 minutes, thus cutting the time by 2 hours and 55 minutes
• Dealt with the SAP BO vendors in the organization
MAXIMO is an integrated software package that helps in convenient, automated asset management activates. This project helps to analyze costs, asset status, manage inventory and labor resources and plan maintenance and service activities. Some of the modules are Inventory, Issues and Transfers, Invoice, Purchase Orders, Work Orders etc. I am involved in the customization of the application by the modification of Java code, JSP’s, DB Configurations etc according to the client's requirements and also for developing added functionality like the reporting modules etc. I am also involved in the creation of various triggers, procedures for SQL Server as well as Oracle databases. Oracle as well SQL Server database tuning was also done by me for various clients. Frequent analyzing and creation of plans, analyzing table to compute statistics are also done by me. Also, creation of DB Links between two databases for comparison purposes, have been done by me. I have been involved in database cloning and backup and restoring of oracle databases. I am also involved in integrations between applications, one being MAXIMO and the other usually being accounting applications.
The objective of this project was to design a portal for the mortgage company, Ameriquest in the US, so that the time from when the user requests the loan to the time when he/she acquires it is reduced from two months to one month. The module that I was involved in was Vendor Integration Platform (VIP). This module is a bridge, which is used to connect the application with the various vendors. The ASAP application sends messages to the ESB in the MISMO format, which is picked up by VIP and send in the vendor’s required format to the various vendors. I was involved in interacting with the clients in the US for this work. I was also involved in the installation and configuration of Weblogic server, version 7.0, 8.1.0 and 8.1.2, creation of database dumps, the restoring of the SQL databases, the overall responsibility of editing of Log4J’s internal format messages to the required format and also in the code support of this module. I was also involved in the migration of data and schema of SQL Server to Oracle database for this module along with the code to support this migration of databases. I was also effectively put in charge of the encryption and decryption of sensitive fields of the Log4J log files using the DES and RSA algorithm. I was also involved in administrating the Solaris servers to mount the required slices, tailing and deletion of logs, adding of users and automounting of slices. I also installed the Solaris OS using the Web Start installation method. Editing of files using the vi editor to modify as required was also one of my many tasks being done on the Solaris machines.
ProjectX is a project management system. It deals with managing the numerous projects that a company has, along with their modules and tasks. This application also has an internal requirement, change requests, client issues and defects module which makes the project much easier to manage. The various modules are Definition, Planning, Execution, Tracking, Resources, Reports, Timesheets, Documents and Contacts. The modules done by me wereReport Module, Timesheet Module, Gantt Module, Security Module. The Report module deals with the generation of reports for a particular project and even across all the projects. It consisted of variance reports and starting date reports, task assignment reports and so on. It also consisted of various graphs like Time Series graphs, Pie Chart graphs etc being developed. The Timesheet module consists of reporting according to the timesheets entered by the persons. It also provides an interface for the users to enter their timesheets. The Gantt Module helps to do planning. The Gantt is the most complex part as it helps us to do the re-planning of the project on the fly and makes it very easy. The security module takes care of the security of the application and the user privileges. GroupX2 helps manage contacts, calendars, tasks, customer requests, messages, conference room reservations, etc.It is all about increasing productivity in the office.The various modules were Calendar, Tasks, Messages, Contacts, Files & Documents, & Misc.The module done by me was Contact Module.This module dealt with managing the contacts of every user, adding a new contact, viewing the contacts according to the contact type, deleting contacts and also importing and exporting of contacts.This module provided the facility to import from various other applications like Outlook Express, Microsoft Outlook, Act and Netscape.The contacts were imported and exported in the CSV format, which is the universally accepted format.
This is for furthering our knowledge to better assist in our job roles.
This was to help understanding the concepts of Islamic Banking to better assist report developments.
This course was taken by the authorised Business Objects Vendor in Kuwait.
