Olivier - Gilad - Développeur BPCS

Ref : 040720S001
Photo d'Olivier - Gilad, Développeur BPCS
Compétences
SQL
INFORMIX
OLAP
ORACLE SQL
CRM
CODA
LDAP
Expériences professionnelles
  • Function Senior BI Project Manager / Senior BI Consultant

    Sector Tyre industry
    Jan 2007 - Jan 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
    Jan 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
    Jan 2007 - Jan 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
    Jan 2007 - Jan 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
    Jan 2006 - Jan 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
    Jan 2006 - Jan 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
    Jan 2006 - Jan 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
    Jan 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
    Jan 2005 - Jan 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
    Jan 2004 - Jan 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
Études et formations
  • 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

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
Ayoub

Business Analyst

  • VILLIERS-SUR-MARNE
MOA AGILE JIRA CONFLUENCE SQL ORACLE Microsoft Power BI TABLEAU SOFTWARE SAB AT FERMAT
Disponible
CV Chef de projet/ Consultant analyst
Gnama

Chef de projet/ Consultant analyst

  • ATHIS-MONS
SQL PROJECT MANAGEMENT OFFICE EXCEL Microsoft Power BI ACCESS PYTHON
Disponible
CV Product Owner / Scrum Master
Van

Product Owner / Scrum Master

  • ALBON
Slack GITLAB DOCKER SYMFONY JIRA POSTMAN SQL Vue.js UNITY 3D Google Cloud Platform
Disponible
CV PO / Business Analyst AGILE
Rida

PO / Business Analyst AGILE

  • BOIS-COLOMBES
AGILE JIRA SCRUM EXCEL PROJECT MANAGEMENT OFFICE SQL CRM BUSINESS OBJECTS
Disponible
CV Chef de projet PROJECT MANAGEMENT OFFICE
Mackenley

Chef de projet PROJECT MANAGEMENT OFFICE

  • PARIS
PROJECT MANAGEMENT OFFICE SQL AGILE ORACLE
Disponible
CV Développeur JAVA
Asmaa

Développeur JAVA

  • TOULOUSE
JAVA J2EE SQL ORACLE AGILE MYSQL Spring Boot SPRING BATCH Angular SQL SERVER
Disponible
CV Chef de projet digital AGILE
Sonia

Chef de projet digital AGILE

  • ENGHIEN-LES-BAINS
JIRA SQL AGILE SCRUM J2EE
Disponible
CV Chef de projet IT
Arnaud

Chef de projet IT

  • BORDEAUX
AGILE SQL PROJECT MANAGEMENT OFFICE Finance UNIX SAP ORACLE SAP RETAIL GENERIX
Disponible
CV Product Owner AGILE
Samir

Product Owner AGILE

  • MANTES-LA-JOLIE
AGILE JIRA SQL SALESFORCE CONFLUENCE SOQL
Disponible
CV Chef de projet
Adel

Chef de projet

  • ANGERS
AGILE PMO Finance EXCEL POWERPOINT JIRA GRAPHTALK AIA IVALUA BUYER Microsoft Power BI SQL
Disponible