Sébastien Roux

Reporting Application Expert, Pierre Fabre SA

Paris - France

More than 6 years of experience in implementing business intelligence applications - scorecard, budget, planning, reporting.

LANGUAGES
------------------
French
Mother tongue

English
Written, spoken and read fluently
Participate to technical forums
2004-2005 Worked on many projects in Europe (Belgium, Ireland, Netherlands).
2000 Institutional TOEFL (590/670)
1997 Practice of 4 month in English school – Churchill House in Ramsgate (England).
Certifications: SEFIC Threshold Level and LCCI English for commerce.

Spanish
Written, spoken and rode fluently
2001 Exchange semester at ITESM in Mexico (International Bachelor degree).
1992-1997 Stay of 5 years in La Paz (Bolivia). Attended courses in the French-Bolivian school « Alcides d’Orbigny ».

1986-1990 Stay of 4 years in Lima (Peru). Attended courses in the French-Peruvian school of Lima.

Portuguese
Beginner (2 years)

INFORMATION TECHNOLOGIES SKILLS
--------------------------------------------------------
[* first experience/trained, ** current practice, *** expert]

OLAP
• Hyperion Essbase v.5 to v.9 ***
o API/Spreadsheet Toolkit, MaxL and ESSCMD administration shells, calc scripts, administration/tuning ***
o Essbase Administration Services ***
• Essbase Integration Services *
• MS OLAP/Analysis Services *

RDMS
• ORACLE **
• SQL Server 2000 **
• First experience with IBM DB2, MySQL, SQLITE, PostgreSQL, JAVA DB

Front End / Reporting tools
• Hyperion Analyzer/Web Analysis v.6 to v.9 – deployment, development and administration, training. ***
• Excel Add-In/VBA and Essbase API – analysis, deployment, development and administration of reporting and analysis applications ***
• Arcplan dynaSight – deployment and development of reports for data analysis and for interface administration. **
• OutlookSoft Everest – development of input/output reports *
• Business Objects (trained) *

Budget/Planning
• Hyperion Planning (trained) *

OS
• Windows NT4/2000/2003 environment **
• Unix (AIX), Linux – shell scripting (bash, ksh, PERL, UNIX commands) *

Desktop
• MS-Office - strong knowledge with Excel/VBA/Essbase API ***, OpenOffice **

Web
IIS *, Apache *, Frontpage **, Dreamweaver **, Flex *

Multimedia
Fireworks **, Flash **, Swish **, Paint Shop Pro & Animation Shop **

Languages / misc.
HTML/CSS **, SQL **, PL/SQL*, MDX **, VB/VBA **, PERL **, JAVASCRIPT *, JAVA * (Eclipse)
Virtualization: Virtual Server 2005, Virtual PC 2004, VMWARE

Schools attended

ESCEM (Cursus anglophone)

ITEM - Tec de Monterrey Campus - Estado (International Bachelor)

Lycée Notre Dame de La Merci (Prépa HEC)

Since 2008: Pierre Fabre SA

	Reporting Application Expert
	- Manage, maintain and develop group's analytical reporting tools. - Manage of functional and technical projects (CMMI Lvl 2). - Technical survey on Essbase.
	Sector: Health and pharmaceutical

2004 - 2007 : Partake Consulting France

	senior consultant
	Partake Consulting France (n°49, avenue Hoche – 75008 Paris). Long term contract, as senior consultant. • Developed and deployed applications and analysis scorecards for activity driving. • Gave administrator and end-users trainings on Arcplan dynaSight, Hyperion Essbase and Hyperion Analyzer. • Audited applications and systems. • Pre-production validations and end-user support during deployment or post-production phases. • Many consulting missions in international context (Belgium, Ireland, Netherlands). • BOLLORE SDV DAT - Hyperion Essbase, Arcplan dynaSight. Development of a reporting portal. Analysis, technical expertise, dev team management. • CSI - Hyperion Analytic Services 9.2, Web Analysis • NATIXIS – Hyperion Essbase, Arcplan dynaSight, Oracle: long term support mission for cost management department as IT organisator/business technologist – maintenance and development of budget control tools. • SHURGARD EUROPE ESC – Hyperion Essbase, MS Excel/VBA: developed budget input and analysis application for management reporting. Drove analysis and development planning/validation together with group controller. • RABOBANK International – Hyperion Essbase, Arcplan dynaSight, MS SQL Server: implemented cross sales analysis application. Developed and implemented a dynaSight application to generate formatted Excel workbooks. • SHURGARD EUROPE ESC – Hyperion Essbase, MS Excel/VBA: implemented an application for forecast and 5 year plan input and analysis in record time (10 days)! – working together with the group controller. Realized project analysis, deployed Essbase server and built the cube, deployed Essbase Excel add-in (7 countries), loaded and validated historical data, developed Excel-VBA workbook (budget tool), end-users support. • LEGRAND – OutlookSoft Everest, MS SQL Server/MS OLAP, MS Excel/VBA: worked on a financial reporting application. Developed input/output reports and cross-checks controls for data validation. • BOLLORE SDV DAT – Hyperion Essbase, Arcplan dynaSight: developed a budget application. • MPI – Audited and optimized Hyperion Essbase server and applications. • RABOBANK INTERNATIONAL – Hyperion Essbase, Arcplan dynaSight, MS SQL Server: developed a specific application for RAROC ration analysis (Risk Adjusted Return on Capital). • RABOBANK INTERNATIONAL – Hyperion Essbase, API, MS Excel/VBA: redeveloped a reporting application used by international agencies. Added a monthly book generator – ready to send – system.
	Sector: Telecom - Internet Products and Services

2002 - 2003 : Micropole-Univers

	consultant
	Micropole-Univers (n°100, rue La Fayette – 75010 Paris). Long term contract working as an IT consultant on Hyperion technologies such as Essbase and Analyzer. • Developed and maintained reporting applications. • Deployed and migrated reporting systems and budget solutions. • Organized information (KW). • Gave Hyperion Essbase and Hyperion Analyzer trainings to internal and external users and customers. • BOLLORE DAT – Hyperion Essbase: server migration. Optimised calc scripts, tested and implemented parallel calculation, set advanced cache settings. Further VBA developments. • NESTLE – Essbase: server migration from UNIX server to MS Windows server. • BOSTIK FINDLEY – Analyzer 5 and 6.2: migrated, developed and deployed groups of reports for information systems department. Administrated applications on Analyzer and Essbase. Trained end-users. • BOLLORE DAT – Essbase, Excel/VBA/API: budget elaboration and subsidiary reporting. Further developments on MS Excel/VBA. • VALEO – Hyperion Essbase, MS Excel/VBA/API: development on existing reporting applications.
	Sector: Telecom - Internet Products and Services

Hobbies

INTERESTS AND HOBBIES
Sport
Practice of Tae Kwon Do (5 years), mountain bike, roller/street-hockey.
Traveling and trekking.

Hobbies
Interested by graphics and web site development. Interest for Open Source software development

To access Sébastien Roux's full profile
Registrer on Viadeo free

I am already a member of Viadeo