Peter Thorn
Software Developer
Experience
Software Developer
City Education Office
- enhancements for the City Education Office in warehouse and inventory management
- revision of the picking lists including printing of images
- implementation of the output of reservation slips
- creation of a delivery routing plan
- representing schools as storage locations to track which school has which equipment at any time
Software Developer / Database Developer
ILSE Software GmbH & Co. KG
- extensive performance improvements for the ILSE Warehouse Manager after hosting the database in a data center
- analysis of the impact of moving the SQL Server from a local network to a remote data center
- review and optimization of indexes, especially on foreign key tables
- conversion of SELECT queries from
*to explicit field lists - detailed optimization of complex SQL queries
- removal of the 3-tier architecture for bulk data in favor of direct insert SQL statements
- avoidance of large object lists each with its own database access routine in favor of working with recordsets
- improved overall system performance to the extent that the client decided against replacing the system
Software Developer
ILSE Software GmbH & Co. KG
- adaptation of the ILSE Warehouse Manager to the specific requirements of the pharmaceutical industry
- implementation of extended documentation requirements directly in the software
- ensuring traceability and compliant processes for pharmaceutical clients
Software Developer / Project Manager
ILSE Software GmbH & Co. KG
- resumption and further development of the warehouse management and food-related features of the ILSE Warehouse Manager for an organic food manufacturer
- adaptation to the specific requirements of the organic food sector, especially in traceability, batch management, and best-before dates
- continuation of the existing architecture and database extensions while maintaining update capability
Software Developer
ILSE Software GmbH & Co. KG
- extension of the ILSE Warehouse Manager for an industrial company to generate export documents
- implementation of support for multiple currencies (Euro, US Dollar)
- generation of extensive export documents based on existing inventory and transaction data
- implementation of very detailed data import processes
- implementation of calculations for commission payments
- execution of all extensions in a way that preserves the update capability of the standard software through comprehensive configuration
Software Developer / Project Manager
ILSE Software GmbH & Co. KG
- Extended the ILSE Warehouse Manager into a merchandise management solution with features for quotes, orders, purchase orders, incoming invoices, outgoing invoices, and dunning
- Added industry-specific requirements for the food industry (best-before date, batch management, supplier control, returnable packaging management, etc.)
- Performed development and database extensions
- Managed a team of two other developers
Subproject Lead / Software Developer
ILSE Software GmbH & Co. KG
- Developed a production control system for a paint finishing company based on the later ILSE Warehouse Manager technology
- Mapped goods receipts, goods issues, stock levels, and recipe management
- Implemented a solution for creating and managing production orders
- Integrated a central controller (Siemens S7) to pass individual components of an order
- Sent parameters like mixing speed and temperature to the production
- Received feedback of production results (quantity, measurement values) into the system
- Handled all phases of the project life cycle: effort estimation, requirements specification, implementation, coordination with customers and involved companies, on-site testing (four-week assignment in Switzerland), acceptance, and subsequent maintenance
- Used MS Access as the initial database, later migrated to MS SQL Server
- Communicated with the S7 via WinCC to read and write variables
- Built this software as the basis for the ILSE Warehouse Manager
Owner / Managing Director / Software Developer
ILSE Software GmbH & Co. KG
- Took over an existing company with solutions for industrial scale integration and tire storage software under the former company implements GmbH
- Product responsibility and focus on the solutions:
- ILSE Wheel Manager
- ILSE Warehouse Manager
- Further developed the standard software in VB6 and VB.net
- Implemented database logic with MS SQL Server, from simple queries to extensive stored procedures and functions
- Used List & Label for report design and analysis
- Used SQLite to develop software on mobile devices (e.g. scanners)
- Managed sales and maintained intensive, ongoing customer contact
- Captured customer requirements, designed solutions, and coordinated concepts with customers
- Created concepts, also for internal enhancements
- Focused on self-explanatory user interfaces
- Designed a database with about 50 tables in the ILSE Warehouse Manager, consistent structure, and used GUIDs as record IDs
- Defined and consistently used a unified naming convention for tables, fields, and internal admin fields (creation date, user, last change)
- Moved extensive logic into stored procedures and functions for reuse, including by mobile devices
- Optimized performance through clean database design and appropriate indexes
- Supported a customer base, mainly small and medium-sized businesses
- Supported reference customers such as Framatome (using the Warehouse Manager at two sites) and two food manufacturers
- Implemented customer-specific customizations while preserving the standard software's updatability
Software Developer
Lidl Stiftung & Co. KG
- Developed a planning system for the Lidl Stiftung to consolidate the individual business units
- Strong focus on a high-quality, user-friendly graphical user interface (GUI)
- Implemented all read-only database procedures as Oracle packages
- Developed .NET components and database logic in Oracle PL/SQL (version 10)
- Debugged the packages with Oracle Raptor and used SQL Plus
- Technologies: VB.net 2003, VB.net 2005, Oracle 10, PL/SQL, Oracle Raptor, SQL Plus
Software Developer
Billhöfer Maschinenfabrik
- Took over and completed an ERP system after the original vendor went bankrupt
- Analyzed and fixed bugs in a large application with 586 forms and around 300 database tables, without existing documentation
- Extended the software with new modules in close coordination with the customer
- Created requirement specifications and technical documentation
- Partially redeveloped components and optimized existing modules
- Technologies: VB 6.0, VB.net, ADO, ADO.net, MS SQL Server 7/2000, caseStudio (Charonware), Document!X (innovasis)
Software Architect / Software Developer
Marketing Agency (> 500 employees)
- Responsible for the architecture and implementation of a strategic CRM project (textile database) for a marketing agency with over 500 employees
- Objective: Provide key metrics for textile retailers to compare with other retailers and analyze customer buying behavior to improve forecasts
- Integrated data from various source systems into a central textile database
- Set up a database with around 500,000 customers and about 3,000,000 line item records
- Created analyses and reports using Crystal Reports 8.5
- Developed a system for automated customer import, including error logs, detection of faulty records, and creation of import logs (replacing manual imports)
- Project team size of 3-5 members
- Used a class model based on a 3-tier architecture: the GUI only knows business objects, which encapsulate database access
- Reusable business objects across different frontends (e.g., VB applications, ASP.NET)
- Simplified maintenance and handover to internal/external developers through a consistent class structure
- Technologies: VB.NET, MS SQL Server 2000, CaseStudio 2.0 (CASE tool), Visio (class diagrams), Crystal Reports
Software Developer / Project Manager
Own development (freelance)
- Developed a time tracking software that is successfully used in several companies
- Project management and coordination throughout the entire development period
- Designed and implemented user interfaces
- Database design and implementation
- Strong focus on clean class design as a basis for a 3-tier architecture
- Implemented the application to run as a 3-tier system (clear separation of GUI, business logic, and data access)
- Used a class model that enables reuse of business objects in different applications (e.g., VB clients and ASP.NET)
- Simplified maintenance and handover to other developers through a consistent class structure
- Technologies: Delphi 6.0, Interbase 6.0.1, Star-Designer, Interbase-Expert (IB-Expert)
Software Developer
Dresdner Bank AG
- Worked on the BUS 2.0 project (Advisor Support System) at Dresdner Bank AG
- Maintained and enhanced the existing BUS system in the lending area
- Developed new workflows and business services
- Extracted data to create reconciliations between the Siebel system and host systems
- Performed error analysis and bug fixing in production operation
- Created technical designs to implement new requirements
- Participated in creating the master plan for further development in the loans area
- Worked on the Basel II project focusing on technical design, analysis, and workflow design
- Extensive scripting tasks with eScript and Siebel VB
- Technologies: Siebel 6.3, Siebel Tools, MS Access 97
Software Developer
Siemens AG
- Evaluated different installation options for Siebel version 99.5
- Connected Siebel as an OLE server to Visual Basic programs
- Installed and configured various Siebel clients (Thin Client, Remote Client, tools)
- Technologies: Siebel 99.5 Server, Siebel Tools, VB 6.0
Software Developer
Nürnberger Insurance Group
- Designed, implemented, and tested new modules for visualizing insurance data
- Used a 3-tier architecture separating GUI, business objects, and data access
- Integrated business objects as OCX components
- Generated type libraries with Rational Rose 98
- Used UML for class and interface design
- Responsibilities: design, implementation, class and interface design, documentation
- Technologies: VB 6.0 Enterprise, Oracle 8.0, Rational Rose 98, Windows NT 4.0, Farpoint Spread 3.0
Software Developer
ADIG Luxemburg S.A.
- Contributed to a fund administration system for ADIG Luxemburg S.A.
- Designed and implemented change requests from business departments
- Implemented new and modified features in live operations
- Technologies: Clipper 5.2e, Novell, Windows NT 4.0
Software Developer
Deutsche Bundesbank
- Developed a subproject (Bid Workstation) for the Deutsche Bundesbank's automated bidding system
- Designed, implemented, tested, and documented the Bid Workstation that manages bids from commercial banks
- Implemented as an MDI application using an object-oriented extension of Visual Basic (framework)
- Used a 3-tier architecture (GUI, business logic, data access)
- Used UML for technical documentation and class design
- Used S-Designer for database design
- Tasks: design, class design, table design, implementation, testing, documentation
- Team size: 7 members
- Technologies: Windows NT 4.0 Workstation (client), Windows NT Server, Oracle 8.0.5, Rational Rose 97, Star-Designer 5.1, VB 5.0 Enterprise, Farpoint Spread 3.0
Software Developer
Siemens AG
- Modeled classes and built tools for integrating VB code into the marketing software SAM (Siebel Automation Marketing)
- Developed various VB classes for use in SAM
- Developed a tool to read data from CD and import it into an Oracle database
- Tasks: design, implementation, testing, documentation
- Technologies: Siebel Automation Marketing (SAM), Oracle, MS Access 97, VB 5.0, PL/SQL, Excel VBA
Programmer
Various Companies
- Worked as an employed programmer at various companies
- Started working with Clipper 5.01 in 1992
- Contributed to a wide range of software projects across different industries
- Regularly responsible for requirements specification and documentation
- Developed and maintained applications, mainly in Clipper and related technologies
Industries Experience
See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.
Experienced in Information Technology (31 years), Manufacturing (21.5 years), Transportation (19.5 years), Food and Beverage (8.5 years), Banking and Finance (3 years), and Pharmaceutical (1 year).
Business Areas Experience
The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.
Experienced in Information Technology (34 years), Product Development (26 years), Project Management (24.5 years), Sales (19.5 years), Operations (10.5 years), and Finance (1.5 years).
Skills
Professional Focus And Activities
- It Experience Since 1989
- Analysis
- Design
- Data Modeling
- Software Development
- Implementation
- Testing
- Documentation
- User Training
Focus / Special Skills
- Graphical User Interfaces
- Database Setup Including Optimization
- Programming
- Extensive Sql Knowledge
- Requirements And Specifications Creation
- Project Management
Operating Systems
- All Versions Of Windows
- Novell
Programming Languages
- Vb.net
- Vb6
- C#
- Java (Basic)
- Access-vba
- Siebel Vb
- Siebel Escript
- Clipper
Development Tools
- Sevcontrols
- Spread 3.0
- Truedbgrid
- Sqlite
- Componentone Enterprise Studio
- Git (Version Control)
- Sourcesafe (Older Version Control)
Databases
- Ms Sql Server (Since 2000)
- Ms Access
- Dbase
- Oracle
- Firebird
- Mysql
Methods
- Ooa
- Ood
- Uml
- Database Design (Derived From Class Design)
Tools
- Rational Rose
- Ms Project
- Mind Mapping Tools
Standard Software
- Ms Office
- Textmaker
Industries
- Logistics
- Mechanical Engineering
- Retail
- Insurance
- Banking
- Fund Companies.
Languages
Education
IT Clerk
Profile
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Peter based?
What languages does Peter speak?
How many years of experience does Peter have?
What roles would Peter be best suited for?
What is Peter's latest experience?
What companies has Peter worked for in recent years?
Which industries is Peter most experienced in?
Which business areas is Peter most experienced in?
Which industries has Peter worked in recently?
Which business areas has Peter worked in recently?
What is Peter's education?
What is the availability of Peter?
What is the rate of Peter?
How to hire Peter?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Software Developer
Nearby freelancers
Professionals working in or nearby Erlangen, Germany