Olivier - Gilad - Développeur BPCS
Ref : 040720S001-
Domicile
52999 RAMAT GAN (Israël)
-
Profil
Chef de projet, Développeur, Architecte (52 ans)
-
StatutFreelance
-
Tarif Journalier MoyenVoir le tarif
-
Function Senior BI Project Manager / Senior BI Consultant
Sector Tyre industryJan 2007 - Jan 2008Project Total Fleet Management - Tyre management reporting system.
Technical Environment Cognos 8 ,Framework manager, Siebel CRM, Oracle DB, Acta
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. -
Function Senior BI Project Manager / Senior BI Consultant
Sector Electronics retail industryProject Business Intelligence Competency CenterJan 2007 - aujourd'huiProject Description and Activity Business Intelligence Competency Center:
Technical Environment Cognos 8 ,Framework manager, Siebel CRM, SAP,SQL SERVER 2000
• 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. -
Function Senior BI Consultant
Project FINANCIAL REPORTINGJan 2007 - Jan 2007Project Description and Activity
Technical Environment Cognos 8 ,Framework manager,baan,Oracle
Enhancing visual report formatting and inter system data navigation to increase analytical abilities, fit business requirement and speed up decision making. -
Function Senior BI Architect
Sector BankingJan 2007 - Jan 2007Financials
Technical Environment Cognos Reportnet ,Framework manager, Cognos Powerplay, Reuters Kondor Plus, SmartStream
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 -
Function Cognos 8 Architect
Sector Power IndustryJan 2006 - Jan 2007Project Performance Management & SOX Compliance Report Implementation
Technical Environment Cognos 8, Framework manager, report studio, analysis studio, Baan IV
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. -
Function Senior BI Project Manager / BI Deployment & Transition Architect
Sector PharmaceuticalJan 2006 - Jan 2006Project Description and Activity
Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay , JD Edwards
• 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 -
Function Senior BI Project Manager
Sector TrainingJan 2006 - Jan 2006Applications
Technical Environment Cognos Reportnet, Framework manager, Cognos Powerplay, Cognos Decisionstream, Shell, UC4, Oracle
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 -
Function Senior BI Consultant for Security and Architecture
Sector BankingJan 2005 - aujourd'huiProject 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 NetworkJan 2005 - Jan 2005Cognos Powerplay, SQL SERVER 2000, DTS
Technical Environment Cognos Reportnet, Framework manager, 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. -
Function Senior BI Architect
Sector Telecom Project Gap AnalysisJan 2004 - Jan 2004Project 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 :
Technical Environment Cognos Impromptu, Cognos Powerplay, Informatica, Oracle Applications
• 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.
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
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 !
IT Transformation & Architecture Manager
- HERBLAY
Chef de projet IT
- SAINT-THIBAULT-DES-VIGNES
Chef de projet GOOGLE APPS SCRIPT & DATA
- LANNION
Chef de projet IT
- MONTREUIL
Chef de projet SI | AMOA
- AIX-EN-PROVENCE
Chef de projet
- DAMMARIE-LES-LYS
Chef de projet
- ROMAINVILLE
Product Owner
- DARVAULT
Expert Cloud et Big Data
- PARIS
Chef de projet IT
- ERMONT