Oracle

Enterprise Architecture for Fortune 5 Company: Web-application for customers

Demo:
Designed and lead team to build demo for one of the world's largest companies integrating voice, traffic, phone and mobile web-based application. Assisted with sales for final demo which used real-time, in-car, voice-activated traffic information. Was lead on demo project and responsible for programming the voice activated system leveraging VXML tools.

Full system:
Demo went so well that the company selected the demo for a full system. Lead on project interacting with client's web software teams, DB teams, security teams, testing groups, business groups, in-vehicle software teams, marketing groups, voice contractors, design teams, and operations teams. Multiple APIs required and developed to work between various groups at client. For the company creating the system, it required implementing an API service that sat between legacy Java system and new web-application environment.

Performed load testing to support 250,000 concurrent users and architected to scale to support multi-millions of users. Base system setup with load balancing infrastructure.

In addition to being lead on the project, stepped in to build SAML2 system via Shibboleth, did load testing, setup DB encryption capable for encrypting on primary key without significant performance degradation, base system, and hardening of network & system. Extensive encryption vs performance metrics tested and ultimately implemented AES hardware acceleration. Hired additional staff to complete project on time with all deliverables.

Peoplesoft Oracle/MySQL/PHP Integrated Application

Organization using Peoplesoft on Oracle wanted to have an online application which tracked employee assets in a complex way that Peoplesoft did not offer. Existing web server did not offer native OCI calls, just slower generic ODBC modules.

Built a new web server from scratch with oci modules for PHP under Linux (SLES 10), migrated existing Novel/Windows server system to Linux, and re-engineered views and PHP code for real-time data. Got buy-in from HR, Peoplesoft db administrator and completed project with all departments extremely satisfied.

Enterprise Application Security Review and Pen Test

Consultant for a Fortune 500 client looking to purchase a commercial, enterprise-level , web-based system for project developement/management.

Integrating Admissions Databases and Web Databases

2006 Lead DBA and consulting expert for program integrating multiple universities' and colleges’ admissions database with online web-management for coaches managing recruiting. Each college has a different database structure and/or legacy system. Responsible for creating scripts to automate synchronization between admissions databases and web databases. Responsible for creating workflow, documenting, and training to ensure each college’s IT staff can implement smooth EDI processes.

Cache and Intersystems

At Enterprise Medical Facility hired to work with Cache (Mumps, M) on Medical database system to add complex reporting to legacy system. Setup Novell Linux (SLES) system with Drupal and CSP (Cache system pages) with authentication via LDAPS to give easy management of users and grant access to data and reports.

Later also added Oracle API to access Peoplesoft DB to access real-time employment records as part of Web-based system. Worked with Oracle team to setup views for system to maintain good security.

Syndicate content