Back to projects

Oracle APEX

ERP System Expanding and Reengineering

Re-engineering and expanding the ERP system to function as a flexible and maintainable SaaS

ERP System Expanding and Reengineering

Project overview

This professional project involved re-engineering and extending an existing system to function as a robust SaaS solution that meets all cloud business needs, becomes flexible for external integrations, and easily move into other technologies. The re-engineering and extension included:

  1. Redesigning the database based on robust SaaS design principles.
  2. Renaming database objects using best practices in naming conventions.
  3. Optimizing queries by adhering to best practices in query construction.
  4. Separating business logic from the user interface and grouping the logic into organized database packages.
  5. Building a single, centralized notification and error system.
  6. Adding new modules to the system.

Outcome1. Separating logic from UI. 2. maintainability and scalability. 3. multiple tenants. 4. a robust database. 5. improved queries. 6. bundled logic in organized packages. 7. clear error messages. 8.automated tenant addition. 9.Efficient tenant management.

CSSHTMLJasper reportJavaScriptJQueryOracle APEXOracle DatabaseOracle 19cORDSPL/SQLRESTful APIsSQL