ramsden edv-beratunglogo

SAP CONNECTION TO WEB SHOP
This project modified the existing web shop to provide connectivity to the newly introduced SAP systems. Web services were used to fetch data from SAP and to place new orders.
Team size: 2.
My role: design and implementation of the web application

FAIR MANAGEMENT SYSTEM
This web application is used by subsidiaries to register their business contacts for visits to fairs sponsored by my client. Their travel and accommodation wishes are recorded and passed on to existing CRM and hotel reservation systems. Web services were used to increase the usability of the site – for example, immediate look-up of customer information using a matchcode or customer number.
The application was written using Java 5 and Websphere RAD 6.1. Backend databases DB/2 and MS SQL server. I made use of JSP, Tiles, HTML, Javascript, AJAX, web services, MooTools javascript framework. Tivoli Access Manager is used to secure the application.
Team size: 2.
My role: design and implementation of the web application.

WEBGENERATOR CLIENT
This stand-alone Java application is used by subsidiaries and business-partners to download brochure materials (mostly PDF documents) to their PCs. An update feature synchronises their local cache with current documents on a web server. A search engine allows the documents to be searched. The documents can be opened in an integrated browser. The document downloading is handled by a web application which logs each download to keep a record of who has fetched which document. The web application also handles the detection and downloading of program updates.
The application was later used to distribute technical documentation to service personnel who do not have direct access to the company network. The application was written using Java 5 and SWT. The communication is based on HTTPS and the authentication on the server is managed by the Tivoli Access Manager. XML is used for configuration. The search engine is Lucene.
The development was done using Eclipse 3.5. Install4J was used for packaging and deployment. WebSphere 5 and DB/2 were used for the web application.
Team size: 2. My role: design and implementation.

WEBGENERATOR
This Eclipse RCP (Rich Client Platform) application is used to create web sites from documents arranged in the file system. The need arose in the technical service department to arrange all their documentation in an easy-to-use format. Around 100 service personnel no longer carry paper documentation in their vans and have all the information on their notebooks. The author arranges the documentation (PDF, PPT, TXT, XLS etc.) in folders in
his file system. The WebGenerator analyses the contents, identifies changes and creates a web site – one page for each folder. The pages can be given a title, a sub-title and a navigation name. The contents of each page can be edited and extra text added. This information is kept even when the web site is re-generated. Finally, a search index can be generated and the project deployed to a webdav-enabled directory, a web server directory (see WebGen Client project) or to a CD.
The clients use webdav to synchronise their local copy. The web site can be started directly in a browser or via a Tomcat server. The Eclipse RCP 3.5 was used as the basis for the project. Various plugins handled the different features. LIUS (based on Lucene) was used to index the different document types. XML and XSLT were used to record the project structure and content and to generate a HTML web site. Tomcat v5 was used for the search server on the clients.
Team size: 2.
My role: design and implementation of the core application and the supervision of a student who implemented some of the RCP and Tomcat components.

SHAREPOINT PORTAL
Introduction of the Microsoft SharePoint Portal. The portal is used mainly to display links to all the authorised applications available to a user. A number of web parts display the list of links, a works calendar, canteen menu of the day, IP information for VPN users etc. A stand-alone authorisation tool manages the application and user information using data from Active Directory, Lotus Notes and other sources. The development environment was Visual Studio 2003 and the application and web parts were written using C# and .Net 1.1. MSSQL, ODBC and DB2 were used.
This project was recently upgraded to MOSS 2007 and Visual Studio 2008 was used.
Team size: 2.
My role: design and implementation of a number of the web parts

BOOKMARKS
This service provides SharePoint users with the facility to manage a private page of links dynamically, Using drag and drop, they can move columns, groups and individual links around the page. Changes are sent asynchronously to a server where the information is stored.
The server side is a web service written in C# for .Net 2.0 and runs on IIS. The data is stored in MSSQL. AjaxPro is used for the .Net integration. JavaScript and MooTools are used on the client side.
Team size: 1.
My role: design and implementation application.

INFORMATION SYSTEM
The Information System integrates many different areas which were previously accessed using 3270 terminals into one browser-based application. The system is highly configurable so that users can rearrange or hide information depending on their needs.
WebSphere was used as the web server platform. The servlets were written in Java 4. XML and XSLT were used for data storage and transformation. HTML and CSS used. DB/2 and Oracle were data sources. JUnit was used for quality assurance. Ant used for build and deployment.
Team size 6-10.
My role: Framework design and implementation.

WEB SHOP
This web application allows registered customers to find and order spare-parts for their machines. Rudimentary B2B interface implemented.
WebSphere was used as the web server platform. The servlets were written in Java and used JSP technology. DB/2 and CICS used. XML for B2B interface.
Team size: 5-7.
My role: design and implementation of the core web application.

CATIA BACKGROUND PROCESS
A process was needed to ensure that parts changed in a Catia system were kept synchronised with their data in the company’s PPS and vice-versa. The application was written using IBM C++ for AIX and made use of the Open Class libraries. DB/2 used to keep a record of all activity.
Team size: 4.
My role: Design and implementation of the communication process and of graphical monitoring tools.

GUI FRONT-END FOR STORES CONTROL SYSTEM
This application provides a GUI front-end a stores controls system running on a Stratus. It is based on a series of masks which display data and receive input. The application was originally written for OS/2 using IBM C++ and the Open Class library. In 1999 it was converted to run under Windows NT. Sockets were used for communication with the Stratus.
2006: A prototype based on the Eclipse RCP was recently created as the C++ compiler is no longer supported and we anticipate problems when Windows Vista is introduced.
Team size: 3.
My role: framework design and implementation.

PREVIOUS PROJECTS
Previous projects were mainly in the area of Computer-Integrated-Manufacturing (CIM). These usually involved interfacing a machine or robot to a computer and passing data to and from a central processing system.
Technologies used: C, C++, OS/2, RS232, APPC, DB/2