EMANO Development GmbH • Chemnitz / Schrobenhausen, Germany
June 2021 – Present · Full-time · 5 yrs
- Regulation Management System (Automotive/EMEA): Enterprise APEX 24.x platform; PL/SQL packages (PCK_RI_COCKPIT2, PKG_REGULATION_REPORT), Oracle Text across 40,000+ records, mass-update wizards, milestone comparison — 60% report time reduction
- Heritage Management System (European institution): Multi-module APEX with RBAC, Jasper Reports, real-time dashboards, and data modelling for cultural asset workflows
- E-Signature Platform (DocuSign/AKV): Production ORDS REST endpoints; OAuth 2.0, SSO/LDAP/MFA, authorization flows, and webhook callbacks for real-time document lifecycle
- Retail Automation (EDEKA): Oracle EBS/ERP-integrated APEX app; Interactive Reports & Grids, workflow management, Oracle Forms to APEX 24.x migration with PL/SQL refactoring
- Jira REST API: PCK_CIP_JIRA package for automated ticket creation, clone, and COCOA workflow sync; eliminated manual coordination overhead
- Advanced PL/SQL: Packages, triggers, materialised views; 40% performance gain via SQL Tuning, Explain Plan, index optimisation; full application security hardening
- Modern API Integrations: Groq AI chatbot (Llama 3.3 70B), YouTube Data API, weather REST, SOAP/WSDL — all within Oracle APEX
- GitHub DevOps: DBMS_CLOUD_REPO pipeline (PCK_GITHUB_BACKUP, PCK_BACKUP_LOGGER) — automated nightly push of DB objects and APEX exports