Laszlo - Consultant CRYSTAL REPORT
Ref : 080427W001-
78360 MONTESSON
-
Consultant, Consultant fonctionnel (56 ans)
-
Freelance
CURRENTLY SAP BO ARCHITECT AT GE
As an architect I led and drove tasks at the go live phase of a major BO version upgrade and business process redesign for the Emea region. Currently participate in a Global ERP and BI project implementing a global reporting solution.
As a reporting consultant I prepare queries in BEx Query Designer to be used to pull data for several Business Objects tools like Crystal Reports, BO Webi or (XCelsius) Dashboard or Tableau.
March 2010 – July 2011 External consultant at Johnson Controls
As a Crystal Reports, Crystal Enterprise and iScala ERP consultant, I provided consultancy on BO Crystal enterprise and Crystal Reports integrated into the iScala ERP functionality.
• Specification gathering, drafting on ERP functionality plus BO and Crystal reports design and publishing in Crystal Enterprise
• SQL Database design: views queries, DTS packages, Universe design
• BO, Crystal Reports design
• Test and acceptance with the client
• Documentation,
• Crystal Reports 10, 11 (XI), Crystal Enterprise, iScala 2.2, MS SQL Server 2005
August 2009 – December 2009 Alliadis software, France
This was basically a Crystal reports design and imlementation project. Working language: French
Based on user demands I make specs and then create a database needed using views, queries or DTS packages. Then on top of the database I develop Crystal reports, integrated into client applications. Finally I have them tested and accepted by the client.
I create simple and more complex reports using several sub reports and occasionally multiple databases. (I try to consolidate the entire source into one database though if possible)
2009 – July 2009 Euromedic Group International, Hungary
As a Crystal Reports, ERP (iScala) and SQL expert, Business Objects consultant, I designed and deliver financial and logistics solutions to end users in our offices internationally. Managing tasks and projects with resources locally and worldwide, I assure data consistency and efficiency in information management.
February 2008 – December 2008 SunGard UK- France, (contractor)
As a Crystal Reports consultant I provided reporting solutions based on client requirements gathered through interviews. Worked in banking and treasury domain on Avangard Quantum and MS SQL
• Specification gathering, drafting
• Database, Universe design
• Report design
• Test and acceptance with the client
• Documentation
• Tools/systems: Crystal Reports 9, 10, 11 (XI), Business Objects XI Webi R2, MS SQL Server 2005, Avantgard Quantum
March 2007 – January 2008 Laboratories Pierre Fabre – France (contractor)
As a Business Objects, Crystal Reports and ERP consultant provided consultancy and support on existing and new BO, Crystal Reports integrated into the ERP functionality.
• Specification gathering, drafting on ERP functionality plus BO and Crystal reports
• SQL Database design: views queries, DTS packages, Universe design
• BO, Crystal Reports design
• Test and acceptance with the client
• Documentation,
• Crystal Reports 9, 10, 11 (XI), iScala 2.2, MS SQL Server 2005
September 2006 – March 2007 Convergys – Edinburgh, Scotland (contractor)
• Specification and design on Infinys Rating and Billing application
• User, client training
• Reporting with Crystal Reports
• Documentation
• Infinys Rating and Billing, Crystal Reports 9, MS SQL Server 2005, Unix, Oracle 10g
2004 June -2005 July Schneider Electric S.A.- Grenoble (contractor)
Having experience both with Scala/iScala Business Objects and Crystal Reports plus data migration my task was to help the client design a standard corporate reporting solution for their key progress indicators.
• Database design and development
• Reports specifications, design and development
• iScala ERP parameterization, consulting, user support
• iScala 2.1 ERP, Crystal Analysis, Ms SQL Server 2005
2004 April- 2004 May Electrolux, Jaszbereny (contractor)
As a Crystal Reports and iScala consultant my major task is to set up the integration points between the Warehouse management program (in-house built and maintained by the client), iScala ERP logistics modules and SAP financials.
• Drafted specifications for Sales and Logistics reports
• Designed in MS SQL plus programming was performed in Visual Basic
• Crystal Reports specifications, design and development
• User support and training
• iScala 2.1, Ms SQL server, Crystal Reports
2002 September 2004 March Fournier Pharma S.A. France, (employee)
Roll-out projects both in Scala and standard reporting in Crystal Reports. Based in HQ in dijon, France I worked with the local offices. Designed and implemented custom demand Crystal Reports in HQ using scheduled MS SQL DTS packages for data transfer from the local manufacturing plant.
• Implementation projects and proveded in-house implementation support to our users: controllers, accountants and logistics people
• iScala ERP user support, consulting
• Crystal Reports specifications, design and development
• SQL database design
• Cartesis Budget planning support
• iScala SAP Interface support and design/development
• iScala 2.2, MS SQL server 2005, Crystal Reports 9
2001 June 2002 August Conoco Hungary, Budapest
• SAP key user in FI and MM module
• User support
• Interface design , maintenance and support for the SAP interface with the point of sales systems
1996 August 2001 May Scala Business Solutions N.V. (employee)
• iScala ERP implementations, user support, consulting
• Crystal Reports specifications, design and development
• SQL database design
Scala, iScala versions, Pervasive and MS SQL, Crystal Reports consecutive versions
Project history available with recommendations on ********
TRAINING EXPERIENCES
• Crystal reports (Business Objects)
• SAP BW 305, 310 training
• SAP BI 100 (BI4 tools) training
• Business Objects XI WEBI Release 2
• iScala Business Intelligence Server
• iScala Basic financials and Logistics
• Signature Implementation Methodology / iScala Boot camp
SKILLS MATRIX
• Crystal Reports - 10+ years with consecutive versions
• Crystal Enterprise - 2 years
• Business Objects - 4 years with the versions below
o 1 year with version 6
o 2 years with BO XI Webi R2
o 2 years with BO XI R3
o Currently implementing BO 4
o 2 years with Data Services
• iScala ERP - 10 years functional consulting on financial, logistics and consolidation
• xCelsius Dashboard - 3 years
• Tableau software - 1 year
• SAP Design Studio - 3 month
• MS SQL Server - 10+ years with consecutive versions and SQL server 2005 the latest
• SAP BW - 12 month
• BEx Query Designer - 10 month
• Avantgarde Quantum - 1 year
• SAP ERP - 1,5 years as key user FI
• Webmethods - 6 month
• Project management - 3 years
EDUCATION
Technical management - Pannon University, Hungary (Veszpremi Egyetem)
Financials and Logistics - Scala Academy, Budapest, Hungary