Contact
informatikberatung Renner
Dipl. Inform. Frank Renner
Lange Straße 172 a
44581 Castrop-Rauxel
Deutschland
Member of the developer association
www.die4dwerkstatt.de
CV
| 1974 - 1983 |
Gymnasium Essen Nord-Ost, Essen
Qualification: Abitur |
| 10.1984 - 11.1990 |
Universität Dortmund
Qualification: Diplom-Informatiker |
| 12.1987 - 06.1989 |
Student assistant as a database programmer at
Kamp Computersysteme, Oberhausen |
| 11.1990 - 01.1991 |
Community service at
Jugendburg Gemen, Borken-Gemen |
| 02.1991 - 10.1991 |
Computer scientist at
Muelheimer Radiologie Institut, Muelheim a.d. Ruhr |
| 11.1991 - 05.1993 |
Computer scientist and project manager in the department for med. physics and computer science at
Entwicklungs- und Forschungszentrum fuer MikroTherapie (EFMT), Bochum |
| 05.1993 - 12.1994 |
Computer scientist and project manager at
Gesellschaft fuer Innovation und Technologietransfer mbH (GBM), Bochum |
| 12.1994 - 06.1995 |
Computer scientist and project manager at
System Analysen in der Medizin GmbH (SAM), Bochum |
| 05.1993 - 06.1995 |
Cooperation of EFMT, GBM und SAM |
| since 1991 |
Informatics consultant as avocational business |
| since 06.1995 |
Full business informatics consulting and software development, currently 2 employees |
| 11.2001 |
Examination for instructor qualification at IHK |
Qualifications
Skills / Methods / Tools:
- 4th Dimension (4D) V1.0 bis Version V12
- MySQL
- Access
- Filemaker
Programming Languages:
Skript-/Markuplanguages:
- AppleScript
- Javascript
- HTML
- CSS
- XML
- XHTML
- Visual Basic
RAD Environments:
- 4th Dimension (4D)
- XCode
- Metrowerks Codewarrior
Products and Standards:
- Apple Macintosh
- Databases
- iPhone Development
- SVG
- Development of Plugins and Components
- Database Publishing
- ERP Systems
- PDF Workflow Systems
- Image- and Document Archives
- CRM, Office Communication Solutions
- System Integration
- Standard Products
- Webdesign
- Webservices/SOAP
- On Demand Printing
- Controlling-Tools
- Onlineshops
- Document Management
- osCommerce Adaptions
- Plugins for InDesign, Photoshop, QuarkXPress
- Acrobat
Languages:
- Englisch (business fluent)
Various:
- Youth leader license, mass sports trainer license,
- boating certificates
Projects:
| Project: | Website with database connection for bidding on salvaged aircrafts |
| Period of time: | 12.2010 |
| Branch/Client: | Aviation surveying and adjusting business |
| Description: |
- Creation of website and database according to client specifications
- User module for placing bids on salvaged aircrafts
- Administration module for entering offers of salvaged aircrafts
- Upload feature for a describing PDF and a thumbnail image
- Installation and operation of database and website at the web provider Strato AG
- Simple user access rights for the administration module with the providers tools
|
| Technologies: | PHP, Javascript, MySQL, HTML, CSS |
| Involved HRs: | 1 Programmer |
| Project: | Complex budget planning with budget controlling and a graphical budget tree tool |
| Period of time: | 01.2008 bis 10.2010, service ongoing |
| Branch/Client: | Marketing company for swiss cheese in Munich |
| Description: |
- Conception and implementation of a complex budget planning tool
- Graphical representation of budget dependencies with in a budget tree with SVG
- Management of budgets with multiple sources
- Top-down planning and bottom-up monitoring of budgets
- Pivot table tool for the evaluation of similar budgets, even on different budget levels
- Complex budget utilisation planning tool with multiple break levels
- Budget monitoring by colorations of the budget graph
- Budget monitoring in the utilisation planning module by list evaluation, pivot tables and coloring of records
- Export and praparation for MS Excel by miscellaneous Apple Scripts
- Devlopment of a testing concept and extensive testing with close to reality test cases and multiple bug fixing levels
- Comrehensive documentation of the new functions with application examples
|
| Technologies: | 4th Dimension (4D), AppleScript, SVG |
| Involved HRs: | 1 Programmer |
| Project: | Advancement of the database solution for fund management |
| Period of time: | Since 01.2009 |
| Branch/Client: | Financial services consortium in Munich |
| Description: |
- New functions for joining many funds companies into a newly founded stock corporation
- Generation of a new Client/Server-Version of the software for managing the stock corporation
- Integration of the new functionalities into the versions of the earlier companies of the consortium
- Complex algorithm for the display of stocks of shares at certain reference dates
- Administration of notifieable stocks of shares for the share register with reference date display
- Migration and optimization of the database solution to 4D V12
- Read-Only views and revision of user access rights
- Development of a simple multi-client capability
|
| Technologies: | 4th Dimension (4D) |
| Involved HRs: | 2 Programmers |
| Project: | Quality management for mineral springs and breweries |
| Period of time: | Since 07.2008 |
| Branch/Client: | Software company in Cologne |
| Description: |
- SOAP interface to Amball Business Software
- Migration of graphical production plans from 4D Draw to SVG by the help of hmSVG
- Integration of a generic list module for unified display of record lists and adaption to existing GUI elements
- Migration planning for the migration from 4D 2004 to 4D V11
|
| Technologies: | 4th Dimension (4D), Windows, SVG, SOAP |
| Involved HRs: | 1 Programmer supported by personal contirbution of the client |
| Project: | AppleScripts and 4D single user applikations for extensive file operations |
| Period of time: | 08.2009 - 12.2009 |
| Branch/Client: | Music industry company in Cologne |
| Description: |
- Mirroring of folders and files with renaming and multiple other options
- AppleScripts for automation of manual copy tasks on soundtracks of the ProTools software
- Tuning of AppleScripts
- Replacement of unperformant AppleScripts by re-engineering with 4D for performance reasons
|
| Technologies: | Applescript, 4th Dimension (4D) |
| Involved HRs: | 2 Programmers |
| Project: | Order management and workflow system for prepress |
| Period of time: | since 11.1999 ongoing |
| Branch/Client: | Full Service Prepress company with two subsidiaries in Warburg and Bielefeld |
| Description: |
- Progressive development, service and maintenance of an existing order management system with a total of about 35 users
- Service of the import-/export interface for centralised accounting
- Integration of MS Office for generation of delivery notes via AppleScript
- Web interface for external order tracking by clients
- Publication of all client relevant order data over internet
- Access rights management and access restrictions for clients and executing printingand production companies
- Scaleable web design for different client user interfaces
- Separation of internal production system and web server with distributed data management
- Workflow tracking with bar code readers at certain production stages and "live" representation of the production progress on internet
- Design and coordination of the integration of RealTimeProof Partner by using Webservices/SOAP
|
| Technologies: | 4th Dimension (4D), MacOS, HTML, CSS, Javascript, AppleScript, MS Office, SOAP, RealTimeProof Partner |
| Involved HRs: | 2 Programmers |
| Project: | Development of a database application for fund management |
| Period of time: | 04.2004 - 12.2008, service ongoing |
| Branch/Client: | Financial services company in the Munich area |
| Description: |
- Design and development of a database application for 5 cooperating companies with more than 30 workstations
- Management of investment objects
- Management of shares
- Address and contact management (subscribers, brokers)
- Accounting for fund and investment objects
- Payout calculation
- Provision accounting
- Handling of distribution agreements for brokers with dynamic and optionally retroactive provision adjustment
- Document management and archiving, management of mailings
- Resubmission management
- Ranking lists and statistical evaluations
- Documentation
- Service and maintenance of the software
|
| Technologies: | 4th Dimension (4D), 4D Write, 4D View, 4D Open, AppleScript |
| Involved HRs: | 2 Programmers |
| Project: | Development of an ERP system as a standard solution |
| Period of time: | 05.2006 - 11.2008 |
| Branch/Client: | Software company in Monheim (Duesseldorf area) |
| Description: |
- Team development with up to 7 other developers
- Complete storage warehouse management module with storage locations, serialnumbers, hierarchical storage units and barcode handling
- Generic handler for record listings
- Generic handler for 1:nand n:m-subrecord listings in entry forms
- Automatic converting and inserting of string into ressources for multilingualism
- Proforma invoices module, credit notes module and service order module. Usage of interfaces provided by other developers
|
| Technologies: | 4th Dimension (4D) |
| Involved HRs: | 7 Programmers, 3 Testers/Documentation writers |
| Project: | Office communication solution for advocats and notaries |
| Period of time: | 06.2008 bis 07.2008 |
| Branch/Client: | Software company in Leidersbach near Frankfurt |
| Description: |
- Ad hoc bugfixing and preparation of an update distribution version for an existing software
|
| Technologies: | 4th Dimension (4D), MacOS, Windows |
| Involved HRs: | 1 Programmer supported by personal contribution of the client |
| Project: | Budget administration and field staff information system |
| Period of time: | 06.1996 - 01.2008, support, service and minor progressive developments ongoing |
| Branch/Client: | Marketing company in Munich |
| Description: |
- Development of the system according to the customers requirement specification
- Administration of incomingand outgoing advertising budgets
- Web interface for submitting visiting protocols of field workers with activitiesand financial planning
- Administration of the advertising articles storehouse
- Data export to MS Excel and further processing with different Visual Basicand AppleScripts for various reports
- Occasional progressive development, customer care, computer installation, network administration and user training on location in Munich since 1999.11
|
| Technologies: | 4th Dimension (4D), MS Excel, Visual Basic, AppleScript, HTML |
| Involved HRs: | 1-2 Programmers |
| Project: | Database system for automated typesetting of danger warnings on product packagings |
| Period of time: | 09.2004 - 11.2004 |
| Branch/Client: | Printing company in Hagen |
| Description: |
- Supervision of an apprentice to become an IT Specialist
- Design of the system with 4th Dimension (4D)
- Migration of the 4D database to Filemaker to support unicode and save license costs
- Migration from QuarkXPress to Adobe InDesign
|
| Technologies: | 4th Dimension (4D), Filemaker, Adobe InDesign, Webservices/SOAP, AppleScript, QuarkXPress |
| Involved HRs: | 2 Programmers |
| Project: | Web based database system for on demand printing |
| Period of time: | 06.2004 - 09.2004 |
| Branch/Client: | Software developer in Dortmund |
| Description: |
- Conception and implementation of the web user interface
- Support and training of the developer
- Implementation of an interface for exchanging data between Adobe Acrobat and the 4D database system based on web services (SOAP) and Adobe-Javascript.
- Inter process communication design.
- Automated generation of previews and final print data as PDF files for business cards and letterheads from the 4D database.
|
| Technologies: | 4th Dimension (4D), Adobe Acrobat, Javascript, Webservices/SOAP, HTML, CSS |
| Involved HRs: | 2 Programmers |
| Project: | |
| Period of time: | 11.2003 - 01.2004 |
| Branch/Client: | Production- and marketing company of organic chocolate in Herford/Castrop-Rauxel |
| Description: |
|
| Technologies: | HTML, JavaScript, PHP, mySQL, Photoshop, osCommerce |
| Involved HRs: | 1 Programmer, 1 DTP Graphics Designer |
| Project: | Redesign of website with database integration |
| Period of time: | 05.2003 - 09.2003, support and service ongoing |
| Branch/Client: | Business consulting company in Essen |
| Description: |
- Redesign of existing website
- Cropping of background images and menu items
- Conception and design of user interface with folder tabs
- Implementation with HTML, Javascript and PHP
- Design, implementation and integration of a mySQL database structure
- Interfacing of an existing MS Access database with the new mySQL database by using Visual Basic with ODBC
- Management of access rights for the system
- Transmission function for sending seminar offers of the company from the internal MS Access database to the mySQL database and integration of the seminar offers with the user interface of the website
- Various extensions of the website and database according to client specifications
- Migration from statical menus to dynamic hierarchical popup menus with Javascript
- Test and validation with different operating systems (MacOS, Windows, Linux) and web browsers (Internet Explorer, Netscape, Opera, Safari)
|
| Technologies: | HTML, JavaScript, Access, Visual Basic, PHP, mySQL, Windows XP |
| Involved HRs: | 2 Programmers, 1 DTP Graphics Designer |
| Project: | Redesign of website with integrated customer information system |
| Period of time: | 05.2003 - 09.2003, Support und Service ongoing |
| Branch/Client: | Office service company in Essen |
| Description: |
- Redesign of existing website
- Cropping of background images and menu items
- Elimination of Active Server Pages for porting to UNIX system
- Implementation with HTML, Javascript and PHP
- Reprogramming of integrated Flash animation
- Design and implementation of a customer information system (Phone list, appointment list, service list and accounting list) with PHP and mySQL
- Complex user and access management for the information system
- Integration with the user interface of the website
- Several extensions of website and information system according to client requests
- Conversion from static submenus to popup menus with Javascript
- Test and validation with different operating systems (MacOS, Windows, Linux) and web browsers (Internet Explorer, Netscape, Opera, Safari)
|
| Technologies: | HTML, JavaScript, PHP, mySQL, Flash, ASP, Windows XP |
| Involved HRs: | 2 Programmers, 1 DTP Graphics Designer |
| Project: | Information- and archiving system for picture agencies |
| Period of time: | 08.2000 - 05.2003 |
| Branch/Client: | Picture agencies, photographers, image archives, software company in Bochum |
| Description: |
- Progressive development, service and maintenance of an existing software for picture agencies
- Automatic royalty accounting for photographers of picture agencies
- Hierarchical keyword indexing of images
- Web browser interface for image catalogue and image ordering via internet with automatic order generation ("shop system for images"). Web display and usage of hierarchical keyword indexes for quick image localisation
|
| Technologies: | 4th Dimension (4D), MacOS, Windows, HTML, Javascript, QPix, all current web browsers |
| Involved HRs: | 1-2 Programmers |
| Project: | Commissioning-, project controlling-, construction site documentation- and helpdesk system |
| Period of time: | 01.2001 - 05.2003 |
| Branch/Client: | |
| Description: |
- Extension of an existing software to the inhouse information system of the company
- Data import from the previous database system (DBase/Delphi)
- Case dependant administration of incoming orders and instruction of subcontractors via web browser interface
- PDF form generation and display in web browser
- Web based import of PDF form data with included digital photos of the construction sites into the database (construction site protocols) for construction site documentation
- Construction site documentation
- Web browser user interfaces for controlling by subcontractors and customers
- Evaluation functions for the accounting of service contracts
- Monitoring, signalling and automatic forwarding of troubletickets
- Controlling and qualitative evaluation on observation of service deadlines
- Service and maintenance of the software
- User briefing and training
- Interface to KHK accounting software
- Web shop system for satellite communication systems, peripherals and spare parts based on mySQL, PHP, IIS and osCommerce
- Localisation for English and Italian language
- Data maintenance and system administration
|
| Technologies: | 4th Dimension (4D), Win 2000, Adobe Acrobat-Javascript, HTML, Javascript, mySQL, PHP, IIS, osCommerce |
| Involved HRs: | Up to 4 programmers |
| Project: | Office communication solution for pyrotechnicians |
| Period of time: | 11.2000 - 04.2001 |
| Branch/Client: | Pyrotechnical company in Recklinghausen |
| Description: |
- Progressive development of our office communication software for pyrotechnicians
- Adjustments for public authority approvals, appointments and forms
|
| Technologies: | 4th Dimension (4D), Windows |
| Involved HRs: | 1 Programmer |
| Project: | Database publishing system for tool catalogues |
| Period of time: | 01.1999 - 04.2001 |
| Branch/Client: | Industrial buying association in Wuppertal |
| Description: |
- Development of database publishing solutions
- Extension of the system to a product for the members of the association
- 4D Plugin in C for copy protection with "dongle"
|
| Technologies: | 4th Dimension (4D), MacOS, Windows, InBetween, QuarkXPress, Metrowerks Codewarrior, C |
| Involved HRs: | 2 Programmers, 1 DTP Graphics Designer, supported by personal contribution of the client |
| Project: | Archiving system for medical image data |
| Period of time: | 07.1998 - 07.2000 |
| Branch/Client: | Medical practice association in Essen |
| Description: |
- Conception and development of an archiving system for radiological image data
- Porting of a DICOM source code (OFFIS Toolkit of Kuratorium OFFIS, Oldenburg) to a 4D Plugin for MacOS with Metrowerks Codewarrior in C/C++
- Support and adjustments
|
| Technologies: | 4th Dimension (4D), MacOS, Metrowerks Codewarrior, C, C++, OFFIS Toolkit |
| Involved HRs: | 2 Programmers |
| Project: | Database Publishing System for hotel- and restaurant guides |
| Period of time: | 03.1998 - 09.1998 |
| Branch/Client: | Publishing house in Dortmund |
| Description: |
- Conception and development of the system
- Editorial system for internal and external editors
- Import of externally edited data
- Export for QuarkXPress with XPress markup tags
- System introduction and user training
- Used for publication of "ARAL Schlemmer Atlas 1999" and "ARAL Schlummer Atlas 1999" hoteland restaurant guides
|
| Technologies: | 4th Dimension (4D), Windows, MacOS, QuarkXPress |
| Involved HRs: | 2-3 Programmers |
| Project: | Radiology Information System |
| Period of time: | 1991 - 1999 |
| Branch/Client: | Radiolgical practice in Muelheim a. d. Ruhr |
| Description: |
- Conception and development of the system
- Waiting room administration and assignment of treatment rooms and modalities
- Condition report generation and accounting
- Implementation of a DATEV accounting interface
- Integration with different imaging modalities (MR, CT)
- Image integration with condition reports
- Support and adjustments
|
| Technologies: | 4th Dimension (4D), MacOS, Metrowerks Codewarrior, C, C++, Solaris, HELIOS Ethershare |
| Involved HRs: | 1-2 Programmers |