Recommended expert
Stefan Wolff
Project team member
Experience
Jul 2025 - Present
7 monthsProject team member
Environmental service provider
- Implementation and maintenance of an order management system
- RDBMS Oracle 19c
- Oracle Forms/Reports 12c/14c
- Oracle SQL
- XML processing
Jul 2023 - Aug 2024
1 year 2 monthsProject team member
Strabag SE
- Further development of a multilingual quality assurance system for 11 European locations based on Oracle Forms/Reports
- RDBMS Oracle 19c
- Oracle Developer 12c (Forms/Reports)
Dec 2021 - Present
4 years 2 monthsProject team member
Retail (discount store)
- Integration of a new warehouse management software from proLogistik into the existing ERP system
- RDBMS Oracle 19c
- Oracle Forms 12c
- Oracle SQL
- XML processing
- Coaching and consulting in SQL and PL/SQL development
Mar 2015 - Dec 2024
9 years 10 monthsProject team member
Retail (food)
- Further development of the existing PPS system based on Oracle Forms/Reports with approx. 1000 tables and 2500 Forms/Reports modules
- RDBMS Oracle 11g/19c
- Oracle Developer 10g/12c (Forms/Reports)
- Use of FormsApiMaster from ORCL Toolbox Ltd.
- SOAP web service integration in Oracle 11g/19c
- Integration of d.3ecm (d.velop AG), fTRACE GmbH, qualitype GmbH, JSON web service and vPOOL logistics GmbH
- Analytical SQL functions, hierarchical queries and pivoting
- XML processing
- Development of programming guidelines in PL/SQL
Jan 2014 - Feb 2015
1 year 2 monthsProject team member
Robert Bosch GmbH
- Design and implementation of the Management of Cost and Resources module
- RDBMS Oracle 11g
- Oracle Developer 11g (Forms/Reports)
- Oracle Application Server 11g
Jul 2009 - Dec 2013
4 years 6 monthsProject team member
RWE Power AG
- Migration of a production planning system from MS Excel to Oracle Forms
- Data migration as part of a redesign of the lab management application
- Oracle 10g/11g RDBMS
- Oracle Developer 10g (Forms/Reports)
- Use of the FormsApiMaster from ORCL Toolbox Ltd.
- Oracle Application Server 10g
Feb 2009 - Jun 2009
5 monthsProject team member
Lüsch Consulting GmbH
- Migration and further development of a complex Oracle Forms application for a public client
- Quality assurance of RDBMS and Oracle Forms/Reports
- Modularization of the application
- Oracle 10g RDBMS
- Oracle Application Server 10g
- Oracle Developer 10g (Forms/Reports)
Dec 2008 - Jan 2009
2 monthsProject team member
Deutsche Card Services GmbH
- Adjustment of the layout of web-based reports to the style guide of the new parent company
- Oracle 10g RDBMS
- mod_plsql
- HTML and JavaScript
Apr 2008 - Nov 2008
8 monthsProject team member
BASF IT Services
- Integration of two warehouse management systems
- Quality assurance of RDBMS and Oracle Forms/Reports
- Creation of coding standards and modularization of the applications
- Introduction of versioning and rollout management
- Design of interfaces for a crop protection management information system
- Oracle 10g RDBMS
- Oracle Application Server 10g
- Oracle Developer 10g
Jan 2008 - Apr 2008
4 monthsProject team member
MGI METRO Group Information Technology GmbH
- Maintenance of the existing catalog system application, especially the interfaces to external systems (e.g., Sinfos)
- Oracle 9i RDBMS
- Oracle Application Server 10g
- Oracle Developer 10g
Apr 2007 - Dec 2007
9 monthsMember of the project team
Itellium Systems & Services GmbH
- Design and implementation of a projection method for Quelle
- RDBMS Oracle 9i
- Oracle Application Server 10g
- Oracle Developer 10g
- Oracle Virtual Private Database (VPD)
Jan 2007 - Present
19 years 1 monthIT Consultant
Freelance work
- Member of numerous project teams as an external IT consultant
- Focus areas: Oracle Forms/Reports, PL/SQL, XML processing, coaching and consulting
Jan 2007 - Apr 2007
4 monthsMember of the project team
Itellium Systems & Services GmbH
- Design and implementation of installment payment and address formatting modules for special shipping
- RDBMS Oracle 10g
- Oracle Application Server 10g
- Oracle Developer 10g
- Oracle Advanced Queuing (AQ)
- Visual Rules by Innovations Softwaretechnologie GmbH
Jul 2002 - Dec 2006
4 years 6 monthsApplication Developer
EUROPIPE GmbH
- Migration of a complex Oracle Forms/Reports/Graphics application (approx. 1500 tables, 2000 client modules) from the Developer 6i (Client/Server) development environment to Developer 9i/10g (Web)
- Automated migration using the Oracle Forms C-API and the FormsApiMaster from ORCL Toolbox Ltd.
- Conversion from character mode to real mode for mobile devices
- Setup of a Developer 9i development environment on Sun Sparc Solaris 5.9
- Training application developers and supporting the rollout in a 24/7 operation
- Introduction of Oracle WEBUTIL and event-driven publishing
- Replacing Oracle Graphics 6i with Oracle BI-Beans
- Configuration of Oracle Application Server 10g and Oracle Developer Suite 10g
- Changing the character set of the Oracle 9i database to UTF8
- Responsibility for migration strategy, test coordination, and application adaptation
- Design and implementation of automated deployments with minimal downtime
- Implementation of user management for around 700 users and database-supported multilingualism
- Bug fixing and further development of the application
- Establishment of development standards and analysis of software innovations
Oct 1998 - Jul 2002
3 years 10 monthsProject management / Subproject management
EUROPIPE GmbH
- Migration of a complex Oracle Forms/Reports/Graphics application (approx. 1500 tables, 2000 client modules) from CDE (Forms 4.0, Reports 2.0, Graphics 2.0) to Developer 6i (Client/Server)
- Support and maintenance of online archiving
- Technical testing and coordination of functional tests for new Developer releases
- Analysis scripts for quality assurance (Unix shell scripting – AWK/SED)
- Contact person for end users and developers, including at the French branch
- Communication with Oracle Support
May 1998 - Oct 1998
6 monthsProject manager / sub-project manager
Aspect / conTakt AG
- Design and implementation of data transfer in the management information system from various subsystems into an Oracle database using Oracle job routines
- IT environment: Oracle RDBMS 7.3, MS SQL Server, MS Access 7.0
Mar 1998 - Jul 2002
4 years 5 monthsApplication developer
Opitz Consulting GmbH
Skills
It Know-how Profile (Selection)
Software Engineering Methods
- Entity-relationship Modeling (Erm)
Tools
- Oracle Forms 4.0, 4.5, 6i, 9i, 10g, 11g, 12c And 14c
- Oracle Reports 2.0, 2.5, 6i, 9i, 10g, 11g, 12c And 14c
- Oracle Graphics 6i / Oracle Bi-beans
- Oracle Discoverer
- Oracle Browser, Query Builder
- Oracle Case 5.1.8 To Oracle Designer 9i/10gr2
- Oracle Application Express (Html-db)
- Oracle Application Server 10g
- Oracle Sql Developer
- Quest: Toad For Oracle
- Orcl Toolbox Ltd.: Formsapimaster
- Serena: Pvcs Version Manager / Dimensions
- Tortoisesvn
- Atlassian Jira/confluence
- Soapui 5.6.0 / Postman
WEB
- Html
- Javascript
Programming Languages
- Oracle Pl/sql
- Unix Shell Scripting (Especially Awk, Sed)
- C
- Pro*c 8.1.6
Databases
- Oracle Rdbms 7, 8i, 9i, 10g, 11g, 12c And 19c
Operating Systems
- Sun Sparc Solaris Versions 5.8 And 5.9
Languages
German
NativeEnglish
IntermediateEducation
Oct 1991 - Mar 1998
University of Dortmund
Diploma in Business Mathematics · Business mathematics · Dortmund, Germany · Good
Oct 1981 - Jun 1990
Theodor Heuss Gymnasium
Essen, Germany
Oct 1977 - Jun 1981
Adolf Clarenbach Primary School
Heiligenhaus, Germany
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience