Professional experience (most as a contractor - except Business Objects and ENCG)
12.2016 – 05-2017 B-Braun Senior Crystal Report Designer with SQL server
• Sql server and Crystal report XI
• Responsible for the design of clinical, stock and schedule management Kpi .
• Trouble shooting and training
03.2016 – 05-2017 NLMK - Belgium Senior Crystal Report Designer with Oracle
• Oracle 10i,Crystal report 2013, PL SQL
• Responsible for the redesign of high level management reports such as otif/rotif and Kpi.
01.2012 – 04-2017Novartis - Switzerland Senior Crystal Report Designer with SAP BW,
Business Objects XiR4.0
• SAP BW, Crystal report 2011/2013, BOXI R4
• Responsible for the redesign of the sales, financial and target report with constant change due to the continius business change.
10.2010 – 12.2010 UBS - Switzerland Senior Crystal Report Designer
• SQL Server 2008, Crystal report 2008
• Responsible for the redesign of various client reports based on business requirements.
• Providing quick solutions for easy maintenance.
07.2010 – 09.2010 Helveta - UK Senior Crystal Report Designer
• SQL development, Crystal report XI R2, SQL Server 2005
• Troubleshooting, finding quick solutions, supporting the team and provide reliable delivery.
• Implemented a translation solution for the reporting solution.
• Created functions/Store procedures and Views in SQL server.
• Tuned reports and store procedure.
• Created KML reports to enable the end user to see forest compartments status using Google earth.
11.2008 – 03.2010 Swiss life - Switzerland Senior Crystal Report Designer
• Simcorp Dimension, Crystal report XIR2, SQL server 2005, Store-procedure, views, Oracle, PL SQL
• Responsible for the Client, Performance and Management reports development.
• Configuration of reports, Simcorp Data Extract and Oracle view development.
• Successfully delivered 90 reports including the client reporting without the client report module.
09.2008 – 09.2008 ACANE UK/Luxembourg Senior Crystal Report Designer
• Crystal report XI R2, Oracle, PL SQL
• Responsible to analyses the conversion of Oracle reports 6i to Crystal report XI R2
07.2007 – 07.2008 Cazenove Capital Management/JP Morgan UK
Senior Crystal Report
• Crystal report 10 /XI, Oracle, PL SQL, Simcorp Dimension
• Responsible for developing complex financial reporting, trouble shooting and bugs fixing.
Developed Oracle views, reports for senior management.
01.2007 – 06.2007 Regus UK Business intelligent analyst
• BO XIR2, Crystal Enterprise 10, Crystal report 10/11, SQL Server
• Responsible for developing complex reports, trouble shooting and bugs fixing.
• Responsible for training junior developers and support the crystal reports development across the company for the UK region.
• Provided informal training in crystal reports and suggested crystal enterprise 10 solutions.
• Optimize complex crystal reports and created SQL Server Store procedure.
09.2006 – 12.2006 Lombard / RBS UK Reporting Consultant
• BO XIR1, Crystal Enterprise 9/10, Crystal report 10/11, SQL, Oracle, Office 2000, Windows XP/ Server 2000/2003, DB2, SQL server 2000, Olap,PL SQL, Business objects universe, business views
• In charge for the reporting solution and accomplished the following tasks:
• Installation, configuration and migration of the Crystal enterprise 9, 10 and BO Xi
• In charge of the reports development, Cubes, SQL server 2000,Business views, Business universe ect
• I have followed the life circle of this project.
• Responsible for the development, configuration and security.
1 Day in 05.2005 DelaRue UK Crystal Enterprise 9 Consultant
• Crystal enterprise 9 , crystal report 9
• Crystal enterprise configuration after servers 2000 upgrade
1 Day in 05.2005 Himerys UK
Crystal Enterprise 10 Consultancy
• Crystal enterprise 10, Crystal report10
• Bug Fixing, configuration of crystal enterprise 10 and Citrix server
1 Day in 06.2005 Customer One UK Crystal Enterprise 10 Consultant
• Crystal enterprise 10, Crystal report10
• Migration from Crystal enterprise10 into Business Enterprise XI
2 Days in 12.2004 SolsisLtd UK Crystal Enterprise 9 Consultant
• Crystal enterprise 9, Crystal report 9
• Migration From Seagate Info 7.5 into Crystal enterprise 9
03.2003 – 08.2004 Business Objects - France (CDI) Trainer / Consultant
• All versions of Crystal report and enterprise (Server), SQL, Oracle,toad , PL SQL, Office, windows.
• Training clients, BO pre-sales, consultants and trainers on a full time basis on crystal report,
• crystal enterprise, Crystal analysis,
• Web for Crystal, have provided standard and personalised training in French and English.
11.2002 – 02.2003 T-Mobile UK Crystal report/Crystal enterprise Consultant
• Crystal enterprise 8, Crystal report 8.X, IIS, Windows NT 4, Oracle, Toad, PL SQL.
• Responsible for developing the reporting solution in term of web reporting.
• Responsible for developing all Statistics reporting based on the sales systems.
• Responsible for developing the financial reporting based on great plans system.
04.2002 – 05.2002 Digital Wellbeing Ltd UK Senior BI Consultant
• Windows NT 4.0, Crystal report 7, Oracle8i, Toad 6.3, Abap, PL SQL
• Responsible to find an architecture solution with regards to link crystal report to multi oracle DBs.
• Responsible to create views and developing reports to monitor the business sales and build reconciliation reports between different databases.
• Responsible to train permanent staff in using Crystal report, Seagate Info and Toad.
• Designed VBA script to do some data manipulation and checks.
11.2001 – 11.2001 Coca-Cola Enterprises Ltd UK Crystal Reports Develop
• Windows NT 4.0, Crystal report 7/8.5 English/French Version ,Maximo, Citrix, Oracle, PL SQL.
• Responsible for developing reports in Version 8.5 and retrieve data from Maximo System in providing financial reports for the management team and the statistic area.
• Fixed some issue in complex reports already used by the business.
• Developed view views in Oracle and converted report form French into English and from Version 7.5 into 8.5.
10.2001 – 10.2001 Unison UK Crystal Reports Developer
• Windows NT 4.0, Crystal report 8,Royal Blue, SQL Server
• Responsible for developing reports in Version 8 linking to the Royal Blue 5.2 logging call system to provide statistics and management reports.
• Provided documentation and training to the permanent staff.
09.2001 – 09.2001 Kelly Services LTD UK Crystal Reports Developer
• Windows NT 4.0, Crystal report 8.5
• Responsible for developing reports in Version 8.5 and providing training.
07.2001 – 07.2001 Scottish Widows UK Crystal Reports Developer
• Windows NT 4.0, Crystal report 6/7, Btrieve , Informix 7.20.
• Responsible for developing KPI reports for the purpose of monitoring equity movements and developing report‘s specifications.
10.1999 – 06.2001 ON Digital (ITV DIGITAL) UK Crystal Reports Developer/ Seagate Info administrator
• Windows NT 4.0/98/95, Crystal report 7/8, Seagate Info 7/7.5,Ms access 97,Ms Excel 97, VB6, and Oracle 8.
• Responsible for solving problems in Seagate info Security.
• Responsible for developing all the reports relating to the Sunrise login call system.
• Responsible for developing internal and external reports.
• Oracle database version 8 through ODBC version 7.3.
• Responsible to design all the ONnet Client’s Reports (Internet Email over the TV box).
• Administer users accounts.
11.1999 Part Time TELOS UK Ms access 97 and Visual Basic Developer
• Visual Basic 6
• Developed a search engine as an ActiveX to be available from the Internet explorer or an exe file.
09.1999 – 09.1999 CLS Bank UK Crystal Reports, Ms access 97, Visual Basic Developer
• Windows NT 4.0, Crystal report 7, Seagate Info 7.
• Developed an access database to maintain a data dictionary.
• As well as a visual basic program to download data from a site to another using FTP Technology.
• A Seagate info server scheduled this program to send data to the other Server
• to export the mentioned data to an SQL database 7.0.
• I configured both Seagate Info Servers and made a logical routine to
• Run the reports, as soon as events appeared.
• One of the Seagate info Servers was available just through the Windows Terminals.
02.1999 – 08.1999 Uunet UK Crystal Reports Developer
• Windows 95/NT 4.0, Crystal report 5/6/7, Crystal Info 6 , Seagate info 7.
• Responsible for solving logical bugs, making existing reports working, creating new reports and views in SQL Server 6.5.
• Responsible for installing, configuring and making the reports accessible through the Intranet.
• Responsible for administrating the users and scheduling the reports.
12.1998 – 12.1998 Bull Information Ltd UK Crystal Reports Developer
• Windows 3.11/NT 4.0, CINFO 6.0 (Crystal Reports Server).
• Duties : Solving faulted Reports, and Crystal Info configuration.
• Making New reports based on specs.
• The Queries was used for the data transaction based on a SQL Server 6.0 database through ODBC.
10.1998 – 11.1998 Impress Solution Ltd UK VB and Access Developer
• Windows 95 / 98, VB4/5, Access 97, Crystal Reports 4.5/6.
• Finishing and improving the development of an access 97 accounting package,
• For an insurance company. Improved the database design (Tables)
• Designed the complicated reports and Improved report packages.
• Responsible for Making the Lake House Software, (a contract management package)
• Designed the database in access 97, the front-end in VB5 , and the reports in crystal report V6.
• I was responsible for providing MS access and MS VB technical support.
04.1998 – 08.1998 Lloyd's TSB Bank UK Analyst programmer
• Windows 3.1 / 3.11/95 /NT4,VB3/4.MsAccess 2/7/8,Crystal report 4.5/6
• Resp...