Skip to Main Content
ACE Program
ACE Directory
Become an ACE
ACE Sign In
ACE
Full Name
Roger Troller
Full Name
ACE Director
Top Level Details
Job Role
Senior consultant
Company
FINNOVA AG BANKWARE
Country
Switzerland
Top Expertise
Procedural Language for SQL (PL/SQL)
Focus Area
Database
About Roger
Since 1990, Roger Troller has been working with the ORACLE database. During the first years he was developing applications using SQL*Forms 2.3 and SQL*Forms 3.0 as well as SQL ReportWriter, RPF and RPT on a Siemens BS2000 host system for Migros Genossenschaft Zürich. After 3 years (1993) he moved to Basel and started working for Manor AG. The focus was now the migration of the company own merchandise management system from SQL*Forms 3.0 (hostbased) to ORACLE Forms 4.5 (client/server). The responsibility of Roger was to assist the developers in this process, to set up standards and guidelines for the development and the development process and to build a library (PL/SQL) to be used by all developers. Another 4 years later (1997) Roger started working for Trivadis as a Consultant for ORACLE based software development. Since then he worked for many customers in different fields (transportation, commerce, pharma, banking, government, insurance). From 1998 to 2016 Roger was trainer for SQL and PL/SQL within the Trivadis Training organisation. He acted as the lead trainer for advanced SQL training and as a trainer for advanced PL/SQL programming. Starting 2013 he initiated a new training on SQL Developer where he also acts as the lead trainer. Furthermore he was trainer for the new features ORACLE 12c training held by trivadis during 2013 and he initiated and realized the SQL & PL/SQL experts seminar held by Trivadis. Roger Troller participated in the beta test program for ORACLE 12c where he was responsible for the new SQL and PL/SQL features within the Trivadis test team. Roger was first author of the Trivadis SQL & PL/SQL Coding Guidelines, SQL-Advanced training and also the SQL Developer Training held by Trivadis. In 2016 Roger moved to finnova ag a company located in Lenzburg, Switzerland that builds software for financial institutes. There he is member of the database performance and modelling team. Roger participated at Oracle 23c beta test program.
Expertises
Procedural Language for SQL (PL/SQL)
Structured Query Language (SQL)
Performance
Database 19c
Database Development
Edition Based Redefinition
JSON
Data Integration
Home Page
http://www.finnova.com
Oracle Community
https://community.oracle.com/tech/developers/profile/Roger%20Troller
Links
Latest Contributions
#SELECTION#
#ICON_HTML#
Oracle Tech Talk
Feb 19, 2026 - Presenting - video/webinar - Meetup
Oracle Database (EE)
Oracle PL/SQL
JSON
SQL
#ACTIONS#
1 - 1