Experience

Omega IT Solutions

• United Arab Emirates
• Information Technology & Services
• 1 - 100 Employee

• CEO

  • Mar 2010 - Present



Barclays

• United Kingdom
• Financial Services
• 700 & Above Employee

• Analytics Consultant

  • Jul 2013 - Jul 2019



Sophos

• United Kingdom
• Software Development
• 700 & Above Employee

• BI Consultant

  • Jan 2013 - Jun 2013



Lloyds Banking Group

• United Kingdom
• Financial Services
• 700 & Above Employee

• Data Warehouse/ETL Consultant

  • Jun 2012 - Dec 2012



Commercial Bank

• Qatar
• Banking
• 700 & Above Employee

• Senior MIS Analyst

  • Jun 2010 - Jun 2012

  - Enhanced current financial data mart in SQL Server 2005 by creating extra dimensions from core banking system (Equation) using SQL Server integration services (SSIS). - Created and automated monthly regulatory reports for central bank from Cognos. - Produced financial reports for internal use and for central banks. - Designed and Implemented Fund Transfer Pricing (FTP) module in the data warehouse. - Enhanced the performance of ETL tools, reduced the download time from 3 hours to 2 minutes. - Extracted data from core banking system (Equation). - Design and build Cards Data mart by extracting information from PRIME into Data Warehouse using SSIS as ETL tool. - Implemented customer profitability module in the data mart. - Administration and maintenance of the Cognos server, data warehouse server and ETL process. Show less



Whistlebrook

• BI Consultant

  • Feb 2010 - Jun 2010

  I was mainly involved in the cognos upgrade project and manage to successfully upgraded/migrated cognos 8.2 environment for more than 1000 users to 8.4. - Implementation of the security model in the framework manager packages - Optimisation of reports performance either by changing the packages or by rewriting the reports - Upgrade reports from Cognos 8.2 to 8.4 environment - Managed a team of 4 developers to successfully complete the upgrade project - Provide training to junior developers for Report Studio and Framework Manager. Show less



Haltermann Carless

• Germany
• Chemical Manufacturing
• 100 - 200 Employee

• Application and System Support Engineer

  • Jan 2006 - Nov 2009

  Petrochem Carless is a leading refinery in the UK. I have worked as a key member of ERP implementation team. The role involved - Built a dimensional data warehouse using Star schema in SQL Server 2005 using SQL Server Integration Services (SSIS) as an ETL tool. - Extract, Transform and Load data using Microsoft ETL tool (SSIS) from BPCS/AS400 to SQL 2005. - Integrate the TSQL stored procedures inside the SSIS tool to automate backend monitoring tasks in SQL 2005 using SSIS tool. Using property expressions in SSIS to dynamically connect multiple servers at runtime (to run backend jobs). - Successfully migrated all the Business Object Universes into Cognos 8 packages. - Converted all Business Object reports to Cognos reports using Report Studio and Query Studio. - Built on demand Cognos reports to meet business requirements. - Helped in troubleshooting and resolving issues with Cognos Reports and Packages. - Daily checkups and maintenance of the Data warehouse. - Successfully built OLAP cubes in SSAS 2005 and Transformer 8.3, for business analysts. - Upgraded Cognos 8.1 to 8.3. - Wrote stored procedures, functions and created views in oracle and SQL Server 2005 using PL/SQL and T-SQL for reporting and web based interfaces - Upgraded SQL Server 2000 database to SQL Server 2005 - Migrated Sharepoint 2003 portal to Microsoft Office Sharepoint 2007 Portal. - Implemented new ERP system using Tropos as a back end database. - Created web based Quality Specification system in on .NET platform using C#, ASP.net, JavaScript, HTML and SQL Server 2005. - Created new month end stock reconciliation routine for the refinery. - Created a new costing system, in Oracle and Excel. - Created web based applications for the Tropos Web client. Show less



Farmers Boy

• System Administrator

  • 2005 - 2006