Olivier - Gilad - Développeur BPCS

Ref : 040720S001
Photo d'Olivier - Gilad, Développeur BPCS
Compétences
SQL
INFORMIX
OLAP
ORACLE SQL
CLARIFY
BPCS
COGNOS
CRM
CODA
LDAP
Expériences professionnelles

  • Function Senior BI Project Manager / Senior BI Consultant

    Sector Tyre industry
    octobre 2007 - janvier 2008

    Project Total Fleet Management - Tyre management reporting system.
    Project Description and Activity Enhancement of the Tyre management reporting system :
    • Gap analysis between existing reporting system and business requirements.
    • Assessment of the workload for the implementation of change requests.
    • Follow-up of the project workload and deliverables.
    • Training and Coaching of the ETL consultants for the integration of changes requests into the ETL process.
    • Restructuring of the metadata infrastructure into classical multilayer star schemas levels.
    • Coordination between the report owner and the report writer to decrease the number of reports (merge existing reports).
    • Definition of standards for the definition of new reports
    • Setting up of an external multi-lingual ad-hoc application to manage the reporting interface.
    • Definition of a customized business oriented user guide.
    • Coordination with the DBA, Network and Infrastructure department to resolve report performance issues.

    Technical Environment Cognos 8 ,Framework manager, Siebel CRM, Oracle DB, Acta

  • Function Senior BI Project Manager / Senior BI Consultant

    Sector Electronics retail industryProject Business Intelligence Competency Center
    octobre 2007 - aujourd'hui

    Project Description and Activity Business Intelligence Competency Center:
    • Assessing Business Process and Data Solution responsible in strategic choice of BI tools and architecture
    • Provision of methodological and technical consulting for BICC set up
    • Coordination of project actors (IT responsible and business owner) for the definition of the project scope and project feasibility.
    • Project planning and management of decisional lifecycle implementation process (time schedule, bottleneck, deliverables etc…)
    • Upgrade of the target architecture and Translation of business requirements into a technical architecture design.
    • Coaching of the modelers for the enhancement of existing metadata models and the integration of new modules.
    • Coaching and support of the report writers for complex graphs and dashboards creation.
    • Drafting step-by-step user guide report for end users.

    Technical Environment Cognos 8 ,Framework manager, Siebel CRM, SAP,SQL SERVER 2000

  • Function Senior BI Consultant

    Project FINANCIAL REPORTING
    septembre 2007 - octobre 2007

    Project Description and Activity
    Enhancing visual report formatting and inter system data navigation to increase analytical abilities, fit business requirement and speed up decision making.

    Technical Environment Cognos 8 ,Framework manager,baan,Oracle

  • Function Senior BI Architect

    Sector Banking
    mars 2007 - juillet 2007

    Financials
    Project Description and Activity
    • Audit of the decisional process and all ongoing BI projects.
    • Analysis on implementation methodology lacks.
    • Proposition of improvement solutions and Definition of the target architecture.
    • Coordination between projects actors and coaching of the internal staff about strategic move and technical solutions for BI’s ROI

    Technical Environment Cognos Reportnet ,Framework manager, Cognos Powerplay, Reuters Kondor Plus, SmartStream

  • Function Cognos 8 Architect

    Sector Power Industry
    novembre 2006 - février 2007

    Project Performance Management & SOX Compliance Report Implementation
    Project Description and Activity
    • Definition of the Metadata extension for Sales, Purchasing, Inventory, Production and Human Resources modules.
    • Based on Business requirements, proposition of operational changes in the source systems (ex: BOM Explosion)
    • Design of reports, olaps and dashboards to fulfill SOX compliance requirements.
    • Training and Coaching of the internal staff for the implementation of the changes.
    • Design of the security system.

    Technical Environment Cognos 8, Framework manager, report studio, analysis studio, Baan IV

  • Function Senior BI Project Manager / BI Deployment & Transition Architect

    Sector Pharmaceutical
    juillet 2006 - septembre 2006

    Project Description and Activity
    • Definition of the strategy for the BI Deployment
    • Design of the BI Deployment & Transition Architecture
    • Assessment of the workload.
    • Definition of the project deliverables and project risks

    Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay , JD Edwards

  • Function Senior BI Project Manager

    Sector Training
    janvier 2006 - juin 2006

    Applications
    Project Description and Activity
    Data Warehouse infrastructure migration :
    • Design of a Data Warehouse and a BI infrastructure.
    • Automation of the Data Warehouse lifecycle development.
    • Definition of standards for the BI maintenance.
    • Coordination of the project actors and coaching of the infrastructure teams for the Data Warehouse maintenance plan, ongoing support and future evolutions

    Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay, Cognos Decisionstream, Shell, UC4, Oracle

  • Function Senior BI Consultant for Security and Architecture

    Sector Banking
    novembre 2005 - aujourd'hui

    Project Data Warehouse implementation
    Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay, Acxess Manager
    Project Description and Activity
    • Setting up of a common LDAP security module for Cognos Powerplay and Reportnet using Sun Java System Directory Server.
    • Proposition of different servers architecture deployment solutions for web tier, data tier and application tier, based on Cognos series 7 and Reportnet applications.

  • Function Senior BI Architect / Project Manager

    Sector Wireless Network
    mars 2005 - septembre 2005

    Cognos Powerplay, SQL SERVER 2000, DTS
    Project Description and Activity
    • Collection of business requirements for invoice, purchase, inventory and operation modules.
    • Definition of the project scope and assessment of the workload.
    • Definition of the project deliverables.
    • Definition and Follow-up of the Data Warehouse project plan.
    • Design of the technical architecture on SQL Server database.
    • Design of the ETL process and definition of standards for the development of the ETL process.
    • Training and Coaching of the internal staff for the development of the ETL process using Microsoft DTS tool.
    • Design of the Meta data model with Cognos Framework Manager tool.
    • Creation of the Cubes with Cognos Transformer.
    • Definition of the security strategy and implementation of the security layer with Sun Java System Directory Server.
    • Deployment cubes and Meta data for reporting through Reportnet Portal.

    Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay, SQL SERVER 2000, DTS

  • Function Senior BI Architect

    Sector Telecom Project Gap Analysis
    juillet 2004 - août 2004

    Project Description and Activity The purpose of this project consisted in finding gaps in data-flow between the legacy system and new ERP applications by elaborating report comparison between and across both systems :
    • Gathering comparison requirements from legacy Data Mart and creating Meta Data for ERP modules.
    • Designing technical architecture on Oracle database.
    • Defining ETL process for the programmer and coaching.
    • Meta data modeling with Cognos Impromptu.
    • Report comparison creation between applications.

    Technical Environment Cognos Impromptu, Cognos Powerplay, Informatica, Oracle Applications
Autres compétences


Languages :
French
English

1 Experience Summary
• Project Management / coaching and Trainer expertise
- Large experiences within Team Technical Leading, Coordination between
projects actors and Coaching.
- Management of a BICC during 3 years for ECI TELECOM.
- Trainer expertise

• Technical expertise :
Over 10 years of extensive Data Warehouse and Business Intelligence experience implementing as senior technical architect:
- Set up of Business Intelligence Competency Centers
- Migration Projects ( Cognos 7 -> Cognos 8 )
- Full lifecycle Datawarehouse/Data Mart projects
- High level competences in architecture, design
- Large expertise in technical integration and security aspects ( SSO, profile
definition, authorization)
- Expertise in Meta Data modeling
- Large expertise within Cognos tools, Oracle and Microsoft Databases .

• Source system expertise :
Olivier has operated within different functional areas: order management, Sales &Marketing, CRM, inventory, procurement, accounting, financial services, quality assurance and infrastructure management over a large scale of source system as SAP , Oracle Application , Siebel , BPCS, Baan, SmartStream Financials, Reuters Kondor Plus and JD Edwards

• Business expertise :
Olivier is able to understand the business dynamics and translating business performance management needs into specific performance indicators and supporting technical solutions.

• Proven experience by project achievements :
- Successfully implemented dimensional lifecycle projects by project
management, business requirement definition, technical architecture design and
deployment for CERAGON and FRUTAROM, involving Ralph Kimball
methodology, Cognos Reportnet, Powerplay Web, DTS and SQL Server
technologies.

- Successfully implemented gap analysis project for ECI TELECOM.
- Design of a high level business intelligence architecture and security
architecture for Société Générale Bank & Trust.

- Successfully implemented meta data models and multidimensional cubes for
more than 14 customers

2 Technical Skills
Programming Languages
T/SQL
Oracle PL/SQL
SQL
UNIX script
Development Tools
Cognos Impromptu (Version 5,6,7)
Cognos Powerplay (Version 5.2,6,7)
Cognos Transformer (Version 5.2,6,7)
Cognos Access manager (Version 6,7)
Cognos ReportNet (Version 1.0 , 1.1)
Business Intelligence Cognos 8 (Version 8.1,8.2)
Cognos Framework manager (Version 1.0,1.1,8.1,8.2)
Microsoft DTS
SQL Navigator
TOAD
Toptier data navigation
ERWin
Source System
SAP
SIEBEL CRM
Oracle Application
BPCS
Baan
SmartStream Financials
Reuters Kondor Plus
JD Edwards
Database
SQL Server 2000
Oracle 8i Enterprise Edition
Oracle 9i
DB/400
Informix
Sybase
Functional Area
Datawarehouse Modeling
Method / Technique
Data Modeling
Operating Systems
MS Windows OS
Sun Solaris 2.X

D'autres freelances
Chef de projet SQL

Ces profils pourraient vous intéresser !
CV Business Analyst
Thomas

Business Analyst

  • PARIS
SQL Gestion des risques JIRA Réglementation RGPD AGILE
Bientôt disponible
CV Chef de projet
Olivia

Chef de projet

  • ASNIÈRES-SUR-SEINE
AGILE SALESFORCE POWERPOINT Gestion multi-projets SQL
Disponible
CV Chef de projet PYTHON
Madjid

Chef de projet PYTHON

  • PARIS
PYTHON JAVASCRIPT SQL DJANGO AGILE CHATBOT FIGMA
Disponible
CV Chef de projet Data
Salma

Chef de projet Data

  • PARIS
Alteryx R SQL JIRA AGILE DATA
Disponible
CV Chef de projet AGILE
Ayman

Chef de projet AGILE

  • SEVRAN
ARIS DESIGN Gestion multi-projets AGILE SQL SCRUM SAFE UML SQUASH MS PROJECT
Disponible
CV Chef de projet AGILE
Siham

Chef de projet AGILE

  • VILLIERS-SUR-MARNE
AGILE JIRA SQL
Disponible
CV Chef de projet
Irene

Chef de projet

  • TINQUEUX
SQL AGILE ORACLE Microsoft Power BI
Disponible
CV Business Analyst
Alexandre

Business Analyst

  • PARIS
JIRA AGILE SCRUM SQL
Disponible
CV Responsable d'applications
Hamza

Responsable d'applications

  • SAVIGNY-SUR-ORGE
ORACLE SQL AGILE UNIX
Disponible
CV Product Manager AGILE
Adiola

Product Manager AGILE

  • LYON
AGILE JIRA MOA SCRUM CONFLUENCE SAFE KANBAN SQL JAVA
Disponible