loading

Back to Top

International: Freelancer profile Abdou Okbir from LIEGE, Datawarehouse / Bi consultant | Profiles from freelancers and companies

You are here:  Freelancers  »  Abdou Okbir

 
 

Abdou Okbir, Datawarehouse / Bi consultant from LIEGE

User Abdou Okbir, Datawarehouse / Bi  consultant hasn\'t uploaded an image yet
 
Abdou Okbir
Dipl.-Informatiker
ibex consulting

Datawarehouse / Bi consultant

4000 LIEGEbe
 
 
 

available
Hourly-/Daily rates: 560.00 €/day
Last update: 16.11.2010 12:07
Consulting
Datawarehouse

Attachments
- none -
Language skills
Arabic (first language)English (good)French (first language)

Abilities, knowledge, experiences of Abdou Okbir

More than 17 years of professional experience as consultant, working for industry leaders such as Allianz-AGF, Belgian Post Group, Philip Morris Benelux, Deutsche Bank, Fiat Auto Belgio, The European Commission, Telindus, Imperial Tobacco, Careworks in Dublin, SIGI in Luxembourg, Moët & Chandon in France and IBM/Abn AMRO in Netherlands.
Based on this experience, I’m confident; I can fulfil all the requirements for professional projects. I am a quick learner, with strong analytical and interpersonal skills; I am energetic, self-motivated and hard working
Software: DataStage V8.1, SQL SERVER 2008, SQL Server 2005, SSAS, SSRS, SSIS, Excel 2007, ProClarity, SharePoint MOSS 2007
Database: Oracle 9i, Oracle 10i, SQL SERVER 2008, SQL Server 2005
Tools & Applications:
• IBM DataStage & Quality Stage 8.1
• SQL Server Business Intelligence Development Studio
• Microsoft Visual Studio 2005, Microsoft Visual Studio 2008
• CA Erwin® Data Modeller



References of Abdou Okbir

DataStage Consultant - IBM NETHERLANDS /ABN AMRO Dec 2009 –DEC 2010
The FBN-ABN AMRO Technical Integration Retail project (TIR) comprises around 500 people, including 60 technical’s analysts, testers and developers, coming from all over the world, working to Migrate customer account data (retail) from Fortis Bank to ABN AMRO Bank.

The concept, at first glance, is simple and straightforward; the transfer of customers from Fortis Bank Netherlands to ABN AMRO. The complication is that the FBN customers being transferred have not only a bank account but many other products as well. These products must all be converted and mapped to an equivalent ABN AMRO product.
In terms of migration volumes, 1.7 million customers will have their account and related products migrated, a very complicated task.

I Designed, implemented, tested, and deployed parallel DataStage solutions.
I demonstrated Knowledge of parallel concepts (data collection, data skew, data partitioning, buffers, sorting, aggregation, and data collecting), complex algorithm implementations, and best practices.
Tools:
• Data Stage & Quality Stage 8.1
• HP Software Quality Center
• Toad
• Cascade Version Manager
• Tortoise SVN
Senior BI - ibex consulting (owner) Jul 2009 – NOV 2009
• Migration from SQL SERVER 2005 to SQL SERVER 2008 of Databases, ETL Package and Reports
• Perfection in SharePoint 2007
• Perfection in DataStage & Cognos
BI SENIOR CONSULTANT - IMPERIAL TOBACCO DEC 2008 – MARCH 2009
With numerous sales regions in approximately 130 countries throughout Europe, Imperial Tobacco needed a comprehensive business intelligence solution that could provide more effective business planning and forecasting abilities. Disparate systems and applications made revenue and profit data prone to error and inconsistencies, while limitations on how information was organized and analyzed made it difficult for Imperial tobacco to create accurate business plans and forecasts based on big-picture market trends
Working in reporting services, we created several reports to better present the company information for the top management to track actual results against targeted levels.
• Complete Functional Analysis including Business Requirements Gathering, Formalising Reports based on the Outcomes of interactions with the Clients.
• Building OLAP Cube with Analysis Services (SSAS 2005)
• Producing reports from OLAP(Cube) with Reporting Services (SSRS 2005)
• Intensive use of MDX

ETL ARCHITECT / PROJECT MANAGER - ALLIANZ INSURANCE (AGF) MAY – NOV 2008
http://www.allianz.be
Building data Warehouse for Insurance department
• Managing a development team
• Participate in the full lifecycle of ETL software development - analysis, design, build, documentation and testing.
• Collaborate with analysts, technical leads, business partners and developers
• Organize a series of interviews with the people that run the business and have knowledge of all activities and processes
• Analyzing source systems and creating a mapping to the target database schema
• Defining and implementing the required business transformation rules and logic (ETL development)
• Review conceptual data model, data mappings to ensure adherence to stakeholder and internal team needs
• Defining a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, etc).
• Developing data naming standards
• Ensuring architectural Best Practices
Tools: CA ERwin® Data Modeler, SharePoint

BI MICROSOFT DEVELOPER - SIGI – LUXEMBOURG JAN - MARSH 2008
http://www.sigi.lu
• Implemented business intelligence dashboards using MOSS 2007 Report Center & Excel Services producing different summary results based on user view & role membership.
• Building OLAP cube with Analysis Services (SSAS 2005)
• Creating Calculation
• Producing reports from MS Analysis Services 2005 with Reporting Services (SSRS 2005
• Publishing Reports in SharePoint
DATASTAGE DEVELOPER - MOËT & CHANDON - EPERNAY FRANCE JUL - DEC 2007
http://www.mhis.fr
- Processing the data (coming from SAP R/3) in DataStage server jobs
- Creation and modification of Sequences
- Updating jobs and sequences with new business roles
- Creating a new jobs and sequences
- Validating, running and monitoring jobs using DataStage Director
- Deployment
- Writing script to CREATE table, UPDATE table, ALTER table, ADD columns, DROP or MODIFY columns.
- Writing documentation: describing all change made to jobs and sequences
Tools
- DataStage 7.5
- TOAD 7.5
Database: ORACLE 9i
Environments: Windows / UNIX
REPORTING SERVICES SPECIALIST - TELINDUS MAY - JUNE 2007
http://www.telindus.com/
• Developing reports for Help Desk service(Clarify database) using SQL Server Reporting Services 2005
• Reports use only Stored Procedure, no code inside reports
• Only Dynamic SQL is used by reports, which allow a SQL statement to be created on-the-fly by a user to satisfy, the particular query requirements for that particular situation.
CONSULTANT BUSINESS & DECISION APRIL 2007
Building solution to manage consultants’ Timesheet
• Building data warehouse
• Extracting data from excel files(Timesheet) and fill data warehouse using SSIS 2005
• Building OLAP cube with Analysis services (SSAS 2005)
• Creating KPI
• Developing Reports from OLAP with Reporting Services (SSRS 2005)

BI CONSULTANT - Aquafin MARS 2007
Proof of concept with Microsoft BI technology: to compare with the functionalities of the existing BO platform.
Gathering the business requirements, DB Design, Data modeling, ETL, Reporting
Developing reports using Reporting services 2005
Tools: ProClarity, Excel 2007
REPORTING SERVICES SPECIALIST - BELGIAN POST GROUP SEP - OCT 2006
http://www.post.be/site/en/index.html
• Migration of reports from Excel to reporting services 2005
• Developing reports (Peregrine database) using SQL Server Reporting Services
• Reports use only views and stored procedure, no code inside report
REPORTING SERVICES SPECIALIST - CAREWORKS LTD – DUBLIN JUNE – JULY 2006
http://www.careworks.ie/
• Developing professional reports using SQL Server Reporting Services.
• Authoring reports using the Report Designer. Deploying and publishing reports.
REPORTING SERVICES SPECIALIST - PHILIP MORRIS BENELUX MARCH - Mai 2006
• Developing professional reports using SQL Server Reporting Services.
• Authoring reports using the Report Designer. Deploying and publishing reports.
QUALITY ASSURANCE (QA), TESTING - DEUTSCHE BANK / IBM OCT 2005 – DEC 2005
• Quality Assurance (QA), Testing, Security (ASP Web application)
• DTS (Data Transformation Services)
• Data Warehouse
• Download from AS400 Files to SQL Sarver tables (BCP, DTS)
• Tables, Views, stored procedures ,UDF, Cleanup Database , Shrinking Database
FUNCTIONAL ANALYST - FIAT AUTO BELGIO Jan 2003 - July 2005
• Analyse for reporting system
• Organize a series of interviews with the people that run the business and have knowledge of all activities and processes
• Business requirements analysis
• Gathering business requirements to understand what the customer need and want
ASP.NET, VB.NET, ASP, VB SCRIPT, JAVA SCRIPT - 2002
• IT Consultancy at Fiat Auto Belgium.
• IT .com
CONSULTANT EUROPEAN COMMISSION 2001
• Designed, implemented, deployed and updated the official website for TAIEX (Directorate-General: Enlargement. European Commission) http://taiex.ec.europa.eu/
• Developing web Site : http://ccvista.taiex.be/ using CCVISTA (The CCVista Database has been created to store translations into the languages of candidate countries of EU measures.
CLIPPER 5.2 & VISUAL BASIC DEVELOPER FIAT AUTO BELGIO – GROUP S – ZA 1998 -2000
• Adapting the application to the EURO
• Adapting the application to the year 2000 (Y2K)
VISUAL BASIC, CLIPPER DEVELOPER GDS 1988 – 1998
• Technical Technician in data processing (Hard & Soft)
• Programming Different applications in Clipper and Visual Basic



Temporal and spatial availability of Abdou Okbir

01/02/2011


Other information of Abdou Okbir

datastage
SSIS
SSRS
SSAS
SQL SERVER 2008

 


Powered by Shutterstock

freelancermap footer border
www.freelancermap.de | www.freelancermap.at | www.freelancermap.ch | staffit-dev.freelancermap.de