Jamal - Développeur CRYSTAL REPORT

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
• 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.