Oracle EBS & Apex Entwickler, AWS Systems Architect

1/2019 – offen

As a team of two we set up a new cloud-based (AWS EC2/RDS) waste management and -disposal platform, leveraging Odoo ERP, Python and PostgreSQL.

The platform allows waste originators to request pickup of waste, those requests are either being routed to pre-defined customer-specific waste disposers or to the “optimal” disposer (where “optimal” will be determined by availability, price,…).

Furthermore, the system has been built with the vision of working as operations- and billing platform for waste disposers themselves, integrating IoT-integration (i.e. sensors that raise alerts when containers reach a certain pre-set filling threshold) with automatic Order triggering and as a Waste Exchange.

Functional Responsibilities:

o Setup and parametrization of Odoo (R13, R14, R15), incl. upgrade migrations
o Customizations Design, Testing, UAT preparation, ongoing support

Technical responsibilities:

o Extension of existing data-models for Companies, Users, Partners, Products, Pricelists, CRM, Attachments (Integration with AWS S3) and others
o Extension of the Odoo Tax logic via customization of Fiscal Positions
o Creation and integration of additional data-models for master data: repository of Waste Containers for each location, incl. type, volume, S/N,…, tracking of different billing rules via Projects, relation between locations and waste disposers,…
o Creation and integration of additional data-models for processing of orders, service vouchers (confirmation of actual movements incl. actual quantities), reconciliation lists (collection, preview, and pre-authorization of billable events)
o Creation and integration of additional data-models for IoT devices and -events, incl. automatic order creation upon reaching a pre-defined threshold,
o Integration of extended and new data-models into the Odoo UI
o Creation of program logic to automate business processes via field relations and extensions of Odoo’s write and create methods, but also via scheduled Odoo CRON (ir_cron) jobs
o Making existing and new data-models available via REST endpoints
o Integration with the customer-facing Portal (created in Oracle APEX)

Lead Developer, Geschäftsführer

8/2013 – 4/2022

As a team of two (during phases 3-4) consultants, implementation of the internal facing part of a highly automated waste management system integrated with an Oracle eBusinessSuite (on-site) instance. Other than the system implemented at Interzero, this system comprised the full cycle of customers requesting pickup of waste (“Demand Side”), assignment, scheduling and tiggering of pickup for those requests by freighters (“Supply side”), processing of weight notes, and full invoicing (on both, the Demand- and Supply sides).

Functional responsibilities included the full requirements gathering, creation of design documents, migration, test- and production-support for key- and end-users for all Finance- and Billing-related aspects of the solution.

Technical responsibilities included creation of required Oracle PL/SQL logic, creation and maintenance of the Oracle APEX application underpinning the solution, creation of new and adaptation of existing Oracle BI Publisher and Oracle XML Publisher reports, performance tuning for all Finance- and Billing-related aspects of the solution, including data migration.

Co-implementation of a mobile App (iOS & Android) for freighters to report pickups and drop-offs of their loads (React Native) directly integrating with the new system.

Business Consultant, Consultant, Lead Developer

8/2010 – 7/2013

As part of VeriSign’s divestiture of its Authentication Business to Symantec I got offered, and accepted, a position at Symantec’s Strategic Demand Management Group within IT. In that position, my responsibilities were:

* Smooth transition of Authentication billing activities from VeriSign to Symantec with zero downtime
* Successful transition of billing activities for MessageLabs into Symantec’s core systems (lead functional role)
* Successful – in a functional lead and project management role – at bringing the integration with the Expense System back on-track for our R12 Upgrade project, incl. helping the System Integrator at several levels with the details of the design and its dependencies
* Extensive involvement in Business Requirement documentation and – as applicable – Business Process reengineering
* Recipient of Standing Ovation peer-to-peer Awards (Nov 2011 & May 2013)

* Accepted into Symantec’s “Top Talent” program as individual contributor (Apr 2011)

Consultant, Business Analyst

7/2006 – 8/2010

As Business Systems Analyst and Project Manager in international projects I worked as link between EMEA/APAC Business, the operations teams in the US and our development-team in India (Bangalore).

* Co-located with EMEA business & responsible for EMEA and APAC (Australia); significantly improved the relationship with the IT business partners in Europe and APAC; receiving consistently good customer satisfaction feedback.
* Worked as Project Manager and Business Systems Analyst in international Projects, including requirements analysis, design, specification, piloting, testing, production cutover and ongoing support
* Improved system compliance, processing time & -accuracy, thereby reducing the necessity to corrections (invoices,…) and improved month-end closure cycle time

* classified Outstanding Performer (highest rating) in Mar 2010
* promotion to team lead for all non-US Oracle eBusinessSuite-related activities (excluding HR) in Sep 2008
* classified Distinguished Performer (highest rating) in Mar 2008

Business Analyst, Business Consultant

5/2004 – 6/2006

Tiscali is an Italian ISP and Hosting provider; my role was attached to the German B2B division (now “Nacamar”). I was responsible for:

• Teamlead for the B2C IT development team,
• Analysis of the state of the order processing, provisioning, and billing systems,
• Developing a vision, including the short- and medium-term priorities to achieve it,
• After being promoted manager, my team of up to 9 internal and external resources and I implemented the vision.
• Upon successful completion of the project, Tiscali had wall-to-wall visibility of all order and provisioning activities for all products and a fully integrated order-, provisioning- and billing systems (i.e. no provisioning without Billing being ensured…)

Business Consultant, Consultant, Lead Developer, Software Architecture

9/2000 – 5/2004

Joined Oracle as Associate (junior) Consultant and was quickly promoted to Senior Consultant. Working as both, functional and technical Consultant on several projects in the manufacturing, tourism, and mobile phone operator businesses.

• GIS – Gebühren Info Service, Vienna AT 1 Lead of the Finance implementation team, responsible for analysis and solution design, implementation (supervising developers and developing myself) and testing for all parts of the solution from creating customer invoices in Oracle eBS AR, processing payments, dunning and the entire R2R-flow.

• Frosch Touristik International, München DE Part of the Oracle eBusinessSuite implementation team, responsible for the Quote-to-Cash implementation for the Swiss subsidiary.

Received the Consultant of the Year Award (July 2001) and Employee of the Year Award – Award of Excellence (June 2002).

Consultant, Lead Developer, Software Architecture, Business Consultant