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

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:
- Redesigning the database based on robust SaaS design principles.
- Renaming database objects using best practices in naming conventions.
- Optimizing queries by adhering to best practices in query construction.
- Separating business logic from the user interface and grouping the logic into organized database packages.
- Building a single, centralized notification and error system.
- 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