Ahmed Lashin, Business Intelligencre Consultant

Ahmed Lashin

Business Intelligencre Consultant

GBM Qatar

Location
Qatar - Doha
Education
Bachelor's degree, Communications and Electronics
Experience
19 years, 11 months

Share My Profile

Block User


Work Experience

Total years of experience :19 years, 11 months

Business Intelligencre Consultant at GBM Qatar
  • Qatar - Doha
  • My current job since January 2009

## Projects Accomplished :
1. Qatar National Bank QNB Doha, Qatar
2. Al- Habtoor Motors Dubai, UAE
3. Supreme Education Council (SEC). Doha, Qatar
• Qatar National Education Data System QNEDS
•Qatar Office For Registration, Licensing & Accreditation QORLA.
•International Tests.

## Roles and Responsibilities :
o Analyzed Data and understand the Metadata of the current systems to refine the central logical data model.
o Take part in Data Mart design advisory committee and implement the Physical Data mart using logical design.
o Assisted with finding reporting and BI user requirements acting as Business Analyst
o Build and maintain complicated Dashboards and Reports based on the client requirements that integrate data coming from different data sources like Databases or even LDAP.
o Enable a Multilingual Reporting environment in Cognos so that we can get English and Arabic reports.
o Migrated Discoverer reports into the Cognos environment for multiple business areas.
o Installed and configure IBM Cognos v8, v10 on different environment like Windows, AIX.
o Administrated Cognos environment and solve any problems in the different environments.
o Configured Cognos to work with LDAP and Websphere Application Server and WebSphere Portal.
o Implemented Security in Cognos environment using different Security models in Cognos.
o Planned Cognos backup strategy for all environments.
o Build and maintain ETL jobs used to populate different Data Mart tables Using IBM DataStage.
o Developed ETL jobs used to load data from ERP systems like Kerridge-Autoline system using ODBC using Microsoft SQL Server Integration Services SSIS.

## Technology and methodologies used:
IBM Cognos BI v8.3, v8.4, v8.4.1, v10. IBM Cognos BI v 8.4, Cognos Virtual View Manager. IBM DataStage v8.0, v8.1, Microsoft SQL Server Integration Services SSIS. Oracle 10g Discoverer. Oracle 10g, 11g DB. Microsoft SQL Server 2005.

Senior Business Intelligence Developer, Tech Lead at ITWorx
  • Egypt
  • July 2007 to January 2009

1. Standish SPS
 Project Description:
New platform to enhance the Structured Products Group (SPG) analysis efficiencies and capabilities by lowering the time spent manually collecting and managing detailed ABS data while increasing the time spent performing higher “value added” securities analysis, modeling, surveillance and recommendations.
 Contribution:
o Develop SSIS packages to collect data from different data sources and load it to the application database.
 Technology and methodologies used:
Microsoft SQL Server 2005, ASP.Net, SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS)

2. Standish SSIS Conversion
 Project Description:
New ETL solution to replace the current multiple environments by a new central database and also to replace old DTS packages by new SSIS packages.
 Contribution:
 Develop SSIS Packages that replace the old DTS packages.
 Build new central database.

 Technology and methodologies used:
SQL Server 2005 and SQL Server Integration Services (SSIS)

3. United Technologies Corporation (UTC) - Supplier Scorecard
 Project Description:
Supply Chain Management tool providing internal and external visibility to supplier metrics, analyzing suppliers’ data, and generating ratings through predefined formulas and KPIs, with an option of viewing ratings in tabular or chart format
 Contribution:
 Design new Data Warehouse that will accommodate data.
 Build ETL solution that move the data from application database to the newly created data warehouse.
 Build SSAS Cube that will be used for analysis.
 Technology and methodologies used:
SQL Server 2005, ASP.NET, SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS)

Information Engineer at EDS
  • Egypt
  • August 2004 to June 2007

1. ABN AMRO \ ACBS
 Project Description:
ACBS - Advanced Commercial Banking System - is the loan and deal application used by ABN Amro bank to manage loans and deals transactions. The Application is implemented in US, UK, NL & Singapore.
 Contribution:
o Supporting the DataMart ( Business Intelligence module in the ACBS application.
o Supporting the new Business Objects Universe and reports in the ACBS Datamart Module.
o Creating new Business Objects reports for the new ACBS portfolios and migrating some of the existing reports to work also under the new portfolios.
o Providing Functional and Technical support for the ACBS application users in the different sites.
o Supporting ACBS activities ( EOD, Interfaces .. ) for all sites involved.
 Technology and methodologies used:
ACBS Application, Business Objects, Oracle 9i database, IBM DB2 database, AS400 servers, IBM MQ-Broker, Data Warehousing and Business Intelligence architecture design concepts and techniques and ETL concepts.

2. ABN AMRO \ ATLAS
 Project Description:
ABN-AMRO Transferable Legal Agreements System - ATLAS production support and development work using web application and BO reporting is planned to be done by EDS EgSC Best Shore.

 Contribution:
o Design a new customized reporting database for the Atlas environment.
o Design the ETL scenario used to transfer data from the Atlas database to the new reporting database.
o Design the new Business Object universe following the client specs, term sheet and the required change requests.
o Design new Business Objects reports to work under the new universe.
o Sybase database administration activities.
 Technology and methodologies used:
Sybase RDBMS, Database Development concepts and techniques, Power Designer, Business Objects, Data Warehousing and Business Intelligence architecture design concepts and techniques and ETL concepts.

Education

Bachelor's degree, Communications and Electronics
  • at Zagazig University - Faculty Of Engineering
  • October 2003

Graduation Project: Digital Electrometer Network [ DEN ] Graduation Project Grade: Excellent ( 192 / 200 ) - DEN is considered as the new generation of the digital power consumption meters. - That project was sponsored by El-Sewidy Electrometer company (part of El-Sewidy Group). --------------------------------- IEEE Student Member (3 years member in Jan. 2003) The IEEE Zagazig Student Branch Chairman 2003. - Organize and Participate in the “ESBM” 2001,2002,2003. - Member in Organization committee of Student Branches Congress “SBC 2002” for IEEE Egypt Section. - Won the Exemplary Student Branch Contest in the “SBC 2002”. - ZSB was one of the best student branches in the Egypt section through 2001:2003.

Specialties & Skills

Business Analytics
Data Warehouse Architecture
Business Intelligence
Business Intelligence design concepts and techniques.
Data Warehousing & ETL design concepts and techniques.
SQL Server 2000, 2005 databases
SQL Server Integration Services
SQL Server Analysis Services
SQL Server Reporting Services
Business Objects XIR2, 6.5 & 5.1.5
Oracle 9i, Oracle 10g databases
.Net technologies ( C#, ASP.Net, ADO.Net )
Cognos 8 BI

Languages

English
Expert
Arabic
Expert