APEX Success Stories
Santa Monica College
SkillBuilders completely renovated Santa Monica College’s (SMC) Oracle APEX Application known as “MyEdPlan”.
MyEdPlan is an internet-facing application that allows students to create their educational plan based on SMC enrollment requirements. It is one of the important applications that SMC students use.
MyEdPlan is built entirely using the latest techniques (Apex, HTML5, CSS3, Bootstrap, drag and drop, etc.) and works on the PC and mobile devices.
Due to SkillBuilders extra attention on the user-interface with intuitive operations, the student is now able to create a complex education plan with almost no online nor counselor-based assistance. The system helps the student during the entire process the the creation of their education plan and immediately alerts the student when date/time conflicts occur, non-compatible or non-compliant courses are selected or similar situations occur.
Because of the specific nature of an education plan and the large amount of context information that is needed, using standard design patterns were no longer sufficient. Therefore new UI components were designed and built that are suited for the functions they need to support. Also a completely new color-design was created that suits a modern college as the SMC.
The application is 508 American Disabilities Act compliant, thus the application is not only operable with the mouse, but also operable solely using the keyboard. The application also supports a screen reader.
North Carolina Dept of Labor | Raleigh, NC
SkillBuilders prepared the NC DOL Windows-based server environment for APEX development in preparation for an APEX pilot project. This included
Installation of Oracle Database EE 18.104.22.168, prepped for APEX
Installation / Upgrade to APEX 4.1
Installation and Configuration of GlassFish/APEX-Listener
Apache configuration including url rewrites and proxy server config
Large University | U.S.
SkillBuilders provided APEX developers who were key contributors in the design and development of Stanford’s new Conflict of Interest/Disclosure APEX applications. These complex applications were mandated by the Public Health Service and had a very short time for delivery. During development, and in addition to design and development, the SkillBuilders team provided technical assistance and APEX knowledge transfer to University developers new to APEX. Phase 1 of this project completed UAT and went LIVE on time.
Brown University Facilities Management | Providence, RI
Facilities Management Energy Efficiency Management (BEE)
SkillBuilders designed and developed an APEX-based Energy Efficiency Management system that allows vendors to input estimated energy savings for planned construction and upgrade projects for university buildings. The data is used to calculate Greenhouse Gas reduction and Internal Rate of Return for each project. Management is automatically notified when new projects await approval. Approved projects move through various workflow stages, including comparison of actual savings against original projections.
Facilities Management Reportal
Skillbuilders assisted Brown University in developing an Oracle Application Express (APEX) application to add extensive reporting functionality to its legacy facilities management system. The application leverages APEX’s powerful Interactive Reports, one of the key features of APEX.
Large U.S.-Based Pharmaceutical
Work Package Management Application Development
Skillbuilders helped Boehringer-Ingelheim to add clarity to the planning and control of its chemical compound testing. This was achieved by replacing multiple, complicated spreadsheets with one, easy to use, Oracle APEX application, combining data entry,reporting and visualization.
Training, Mentoring and Code Reviews
After training in-house programming staff on APEX basics, we provide ongoing application reviews and assist with the planning and development of new APEX applications. This also helps keep in-house staff up to speed on the latest APEX features and ensures the customer’s applications are built using APEX best practices.
BAE Systems | Manchester, New Hampshire.
BAE Systems, the world’s second largest defense, security and aerospace company, engaged us to streamline part of their purchasing process. As the lead Oracle Application Express (APEX) resource, Dan leveraged his knowledge of APEX, Oracle, and related web based technologies to help design and build a custom user interface on BAE’s existing Oracle EBS back end. Dan was an integral part of a team effort that took the project from behind to ahead of schedule while total staff was decreased. The project was completed on time and above expectations – a finished product which included additional deliverables.
Hudson Advisors | Dallas, Texas.
SkillBuilders developed a custom single sign-on solution allowing seamless navigation and integration between the customer’s Oracle E-Business applications and custom APEX applications. We also re-configured APEX to better integrate with Oracle EBS, allowing simplified application maintenance and more streamlined VPD policies. This significantly improved the performance of the integrated APEX application.