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
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
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.2004 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, 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, 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.
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
Crystal Reports Developer
Windows NT 4.0, Crystal report 7, Oracle8i, Toad 6.3
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 Developer
Windows NT 4.0, Crystal report 7/8.5 English/French Version ,Maximo, Citrix, Oracle.
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 reports 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 Clients 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
Responsible for Making the main reports for the FPP Channel Islands system,using Crystal report 6.0 (16 Bits) by using an MS access 2.0 database linking through the ODBC Technology.
Designing the queries, the functions, the parameters, to the testing and
finally the delivery to the team leader.
Expertise of over 200 PCs for year 2000 compliance.
Responsible for making the following MS Access 2.0 year 2000 compliance:
-Switch DB, Fund Switch DB, Verification DB, Management DB databases, Fund DB.
Improving the Year 2000 inventory database system, and solving some bugs.
Converting a process form a Smart File Project (not Year 2000 compliance) to an Ms Excel Macro using VBA.
Backup data using Colorado v 4.70 for DOS.
Making a process to extract information form the FPP system to the IBM Mainframe (Capsule), by creating an ASCII file.
12.1997 03.1998 FREDRICKSON INTERNATIONAL Ltd UK
Software Engineering
Windows 3.1 / 3.11 /95 /NT4, DOS, VB3/4/5, Source Safe,
MsAccess2/7/8, Crystal Reports 4.5/6.
Responsible for running HOTPOINT Warranty System:
Fixing the multiple bugs including the redesign part of the database, upgrading the scripts, to supporting the database and the users).
-Managing the database (access 2.0).
-Debugging and supporting users at a real time (VB3, VB4).
-Making report using crystal report 4.5.
-System testing, debugging, and YR 2000 Upgrade.
Debit card system
-Converting the Debit Card System from VB4 front-End with Oracle
Database, to VB4 front-end with Ms access 2.0 database.
-Supporting users at a real time.
-Making report with access 97.
-System testing, debugging, and YR 2000 Upgrade.
Cable and Wireless
-Making a facility in VB5 to export phone numbers
From oracle database using PLSQL+ 3.3 To a CSV file.
-Solving many bugs in the over night job for the debtor system.
-Debugging, YR 2000 Upgrade,
- Improving the main program of the cable and wiles system (VB5).
-Making report using crystal report 6.
1 Week in 11.1997 British Telecom UK
PC Engineering
Windows 3.11, DOS, and MS Internet Explorer 3.0
Rollout an Internet Explorer / FTP
Set-up the IP Address, supporting the configuration, and the memory problems.
06.1997 11.1997 Range Software Limited UK
Software developer
Ms Access 2/ 7, Ms SQL Server 6.5, VB4, Ms Word7, Ms Excel7,
SourceSafe.
Designed an import module, to migrate data from an external database
(Any type of a database using the ODBC technology or ISAM Technology)
To the house package (CALIBRE).
This package was in access2 database and VB4 (16 Bits) as a front end.
Designed the database, developing the front end, and testing the package until the delivery to the client.
Upgrading Access 2 systems to Access 7 including 16 bit to 32 bit API Conversions.
System testing, debugging, and YR 2000 Upgrade.
Report design and construction including OLE mail merge routines between MS Access 2/7 and MS Word 6/7.
Design and development of a data migration system incorporating ISAM/ODBC technologies.
(Using SQL Server 6.5)
Upgrading access2 systems to VB4 including 16 bit to 32 bit API Conversions.
Developing Crystal reports version 4.5.
06.1996 05.1997 Legal & General UK
Database Administrator
Access 2 /7, Ms Word 7, Excel 7, Dos, Windows3.11/95
Responsible for running, managing, debugging and upgrading a Peps systems
Report design and construction including OLE mail merge routines between
MS Access 7 and MS Word 7
Design of graphs using Ms Excel 7.
System testing and debugging.
05.1996 06.1996 NETTEC UK
Software developer
Windows 95, Dos, VB3/4, and Ms Word7.
Design of a program to customise an Internet menu containing the option
Of automating a configuration through an INI file etc
System testing and debugging.
03.1995 08.1995 Edmund Evans UK
Analyst Programmer
Windows 3.1 / 3.11, Access2, Ms Office 4.3
Designed a Stock Control System (access2 database).
Design of a payment system (access2 database).
Report design including merge documents routines between access2 and Ms Word 6.
Report of wages in access2
Design of a system to monitor the employees performance.
11.1993 08.1994 ENCG Algeria (CDI)
Analyst Programmer
DOS, Windows 3.1, Windows 3.11, Clipper 5.2, and DBASE 3+ , Quattro Pro, Lotus 123, Ms Office 4.3, clipper 5.2, Ms Access 2, Ms excel 5.
Responsible for the Human Resources System:
Automating the Holiday system, and supporting it (system testing and debugging)
Updating Production's control System, and solving some bugs
System testing and debugging)
Programming the Analytic system, (Control of the employees time-sheets, performance, using reports, chart, merge documents using Ms Word 6.
