Nicolas OURY

Head of Business Performance Management department
Business Intelligence, Financial Consolidation, Budgeting & Planning
• Founder and current Head of the Business Unit
• Resource Manager (>10 people)
• Responsible for more than 50 projects in Corporate Performance Management
• Budgeting & Forecasting and e-Business Applications
• Financial and budgeting manager of the Business Unit and related projects
• Responsible for Marketing & Technical Strategy development
• Implementation of Best Practices in BPM

OrgExpo, Geneva
2006 Datawarehousing in Event Management, HR, Finance
• Role: Audit, Business Requirements, Architecture Design
• Environment: Oracle RDBMS, Cognos ReportNet, Oracle Warehouse Builder, Java

(confidential), Switzerland
2006 Sales Activity Datawarehousing
• Role: Audit on a DW project developed by tier
• Environment: Oracle RDBMS, PL/SQL, Cognos Series 8

Serono International, Geneva - Madrid
2006 Spain & Portugal Sales Analysis
• Role: Project Management, Business Requirements, Architecture Design, Implementation
• Allocation of Corporate Target to Sales Reps
• Individual Sales Reps Performance Measurement
• Keywords: Data Ventilation, Individual Performance Measurement, Complex data-flows
• Environment: Oracle RDBMS, Informatica PowerCenter, Informatica PowerAnalyzer, Hyperion Essbase, Java

5aSec, Geneva
2005-2006 Daily sales activity of more than 1'000 shops spread in 25 countries
• Role: Project Management, Business Requirements, Architecture Design
• Project presented as Oracle Day 2006
• Environment: Oracle RDBMS, Oracle Discoverer, Oracle Warehouse Builder, Java

Serono International, Geneva
2004-2006 Corporate Business Intelligence Platform on company results on a day-to-day basis
Budgeting & BI Platform based on Oracle Financials 11i, Hyperion Entreprise & Hyperion Planning
• Sales, R&D OpEx, Free Cash Flow, Balanced Scorecards, Gross Margin, Accounting Balances…
• Role: Project Direction, Architecture Design, Functional Analysis
• Keywords: WW Project, Top-management solution
• Users: All employees from Executive Management Board to Business Analysts
• First WW single definition and source for sales and financial measurement (e.g. WW Daily Sales)
• Reference for company annual report
• Environment: Oracle 9i, Oracle Applications 11i, Informatica PowerCenter, Informatica PowerAnalyzer, Hyperion Essbase, Temtec Executive Viewer, Java

Serono International, Boston - Geneva
2002-2003 Consolidation of various heterogeneous data sources to define the exact panel of drugs sales in North America
• Roles: Project Management, Architecture Design (2 years project)
• Keywords: 1’500 man-days, project lead for Boston, more than 50 data sources
• Time-to-Analysis reduced from 5 weeks to 1 week for each month
• Allows Sales Reps to know each doctor's prescription strategy, including competitors drugs
• Environment: Oracle RDBMS, Hyperion Essbase, Informatica PowerCenter, Informatica PowerAnalyzer, Java

Serono International, Geneva
2004 From a Spent Analysis to a Spent-Provisioning-Budgeted Day-to-day Project Costing Follow-up
Costing Analysis from Division level to Costing line
• Role: Project Management, Functional Analysis, Architecture Design
• Keywords: Oracle Financials Cross module analysis on project costing
• Environment: Oracle RDBMS, Informatica PowerCenter, Cognos Suite

Serono International, Geneva - Madrid
2003 South America Sales Analysis
• Roles: Project Management, Architecture Design, Functional Analysis, Implementation
• Reconciliation of heterogeneous data sources
• Environment: Oracle Financials 11i, Informatica PowerCenter, Hyperion Entreprise, Odyssey, ASP

STMicroelectronics, France
1999-2000 Production Control Application
• Roles: Project Management, Design, Implementation
• Keywords: 700 users, availability 24h/24, 7d/7, 365d/year
• Privileged interlocutor between Production & IT departments
• Originally dedicated to Production Control, I initiated and created a module allowing the
• Application to perform and advise on Production Process Optimization
• Environment: Visual Basic, Oracle, PL/SQL

STMicroelectronics, France
1998 Intranet Document Management
• Roles: Project Management, Design, Implementation
• Estimated time-saving of 1 hour per day per engineer
• Environment: Java, Verity

Arcad Software, France
1997 Maintenance Application on AS/400
• Design & Implementation of the first graphical software allowing to generate technical documentation on AS/400
• Software presented at « Systèmes & Applications '98 » (FR-Paris, La Défense)
• Environment : Visual Basic, Advanced VBA on Visio and MS Word