SkillBuilders Welcome  |  Log in

SkillBuilders: Oracle Database Specialists

John Watson

Dave Anderson

Geoff Wiland

Mick Hosegood

Bob Benoit

Oracle Consultants Available

Customer Success Stories

August 2016

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.

January 2015

Stanford University

Since 2011, SkillBuilders development team has been a key asset and extension to Stanford's Oracle APEX projects. Our personnel provided systems analysis, development and provided a source of ongoing application review and best practices. Projects include Conflict of Interest, SERA, and FASA. In addition to application development, SkillBuilders has also provided on-site instructor-led APEX training to Stanford University developers.

Stanford University School of Medicine

In 2012 and 2013, Skillbuilders provided an Oracle APEX solution (analysis, design and development) for the Stanford School of Medicine, Information Resources & Technology Data Center.

The center runs a server hosting service for non-IRT School of Medicine departmental servers. Prior to SkillBuilders solution, the administration of the information and processes needed to support the full life-cycle of the servers was highly manual employing spreadsheets, email records, wiki notes and help-desk tickets. Skillbuilders Oracle APEX solution consolidated the information into a single repository providing the ability to track all processes from initial customer inquiry, through server and software installation, configuration, human resource planning, warranty, maintenance and service charge allocation.

Brown University Administration

Since 2008, SkillBuilders has trained Brown University developers and Oracle Administrators in new skills vital to the Universities success. This includes Oracle Database performance tuning, new features, RMAN, Enterprise Manager / Grid Control and Grid Infrastructure. For developers SkillBuilders has provided education in Java Programming, Servlets, JSP, XML, Ruby on Rails and more.

Brown University Facilities Management

In 2008, SkillBuilders began the design and development of an Oracle APEX-based Energy Efficiency Management Tracking and Workflow application. This internet-facing APEX application (called "Brown Energy Efficiency", or "BEE") allows vendors to input estimated energy savings for planned construction and upgrade projects for university buildings. The data is then 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. Today, "BEE" remains a mission critical application for Engineers, Project Managers and vendors at Brown's Facilities Management division.

In November of 2008, SkillBuilders was an instrumental partner in the deployment of this APEX application. The technology at the time included Oracle APEX 3.2, Oracle 9i, Oracle Application Server (OAS / iAS), Apache FOP. Since, SkillBuilders remains the sole Univertiry partner for BEE application enhancements and upgrades.

In 2011, Skillbuilders assisted Brown University in developing an Oracle Application Express 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.

SkillBuilders also provides ongoing data center support such as Server Migrations and Database Tuning.

Soraa

SkillBuilders designed and installed active standby using Oracle Database Standard Edition, which supports Soraa production line. SkillBuilders also provides Oracle licenses, in this case saving Soraa tens of thousands (perhaps hundreds) by advising customer Standard Edition would meet customer requirements.

We also implemented RMAN backups, Alert/Incident monitoring and general database tuning. We remain on-call for support issues.

Federal Bureau of Investigation (FBI)

On-site (Washington, DC) Oracle APEX training for experienced team of developers. Customer testimonial:

"We had a great APEX class with Tyson Jouglet. He was very knowledgeable and provided an informative class that was interesting for the students. We are grateful for his patience with our technical hurdles and appreciate that you had a back-up plan ready to go if needed. Thank you for your very professional services and we will certainly keep you in mind for any future training needs"

North Carolina Department of Labor

In 2012, SkillBuilders provided the Department of Labor in North Carolina state government with a turnkey APEX configuration, i.e. everything they needed to start deploying internal and internet-facing APEX applications. This included database installation and patching, APEX and APEX listener configuration, Java container (Glassfish) installation and configuration and assistance with firewall updates.

SkillBuilders continues to provide Oracle Database, APEX and infrastructure support; patches, upgrades and troubleshooting.

Acxiom

SkillBuilders provides ongoing Oracle Database advanced administration training. This includes Oracle Data Guard, Administration and Performance Tuning training. One student, who provided a perfect 5.0 score in his post-course evaluation, exclaimed, "I really enjoyed John as my instructor. He was extremely professional, personal, and deeply concerned about us understanding the concepts of in this course."

Oracle Corporation

SkillBuilders teaches 12c Database new features to Oracle Corporation employees. We developed a custom course and have delivered it 12 times and counting! We also teach other subjects such as Oracle Database Performance Tuning and Data Guard Administration.

Boehringer Ingelheim

In addition to training BI developers Oracle database, SQL and APEX development, SkillBuilders provides on-going application design reviews, planning and development assistance. This greatly increases adherence to APEX best practices.

SkillBuilders also integrated Oracle BI Publisher with BI APEX applications.

Waters

When Waters Corp software customers needed a tool to manage ASM disks, non-ASM disk, RMAN backups, imports/exports, monitor and send alerts, manage database users (e.g. password management), SkillBuilders developed an integrated Oracle APEX solution. The "Waters Database Manager", or WDM, also provides other general management functions such as job scheduling and reporting.

GE Capital

GE Capital calls on SkillBuilders for highly reviewed Oracle APEX and UNIX training. For example, one UNIX course taught to 15 GE Capital technicians by expert Mick Hosegood scored an average of 4.85 (out of 5). One student commented,

"I thought the instructor was excellent. Mick Hosegood did a very good job. The course content and materials were also well done!"