Joey Bernsen Email and Phone Number

• Created the corporate web presence using Google App Engine for Python, including public and internal sites with versions for both web and mobile devices. The sites included both simple and complex forms and an AJAX-based sales reporting dashboard for the internal site.• Designed and implemented the corporate cloud presence using Google Drive, including file storage structure, Google Docs, Google Sheets, Google Forms (with automation) and Google Scripts.• Designed and implemented the corporate database using MySQL.• Managed the corporate email system using Google Apps.

• Served as the Business Analyst for the Trading and Analytics groups. I assisted these departments in identifying I.T. needs, translating requirements into specification documents, expediting and statusing IT processes in support of the needs of the departments.• Worked with the Trading group to design data mining and modeling needs for the Model-Based Trading. Implemented source control for the various user tools and scripts. Selected the vendor, implemented the platform, created documentation and training materials, taught training classes.

• Rewrote vendor data load scripts. The scripts included processes for both loading, and extracting information from, a reengineered data model deployed in all worldwide operation sites.• Provided SQL scripts for mining the databases to identify invalid data as prescribed by business rules. • Created a web-based cross-reference application used to map the current database model to the new model being implemented.• Developed a QC tool that compares data from an original upstream data model to the newly deployed data model; site-by-site; world-wide.

• Wrote a multitude of PL/SQL packages to integrate external data from various vendors and overseas offices. Scrubbed, validated and loaded vendor rates and partner operations details using Oracle SQLLoader, Microsoft Excel and Microsoft Access.• Was responsible for all web/database design and maintenance for systems in use across the Americas and Asia. The existing systems were designed and implemented by a third party. Created tables (including indexes, constraints and triggers), views, materialized views, packages, procedures, functions and dbLinks required to provide updates, maintenance and new development using Oracle 9i, Oracle 9i AS Technologies, Java, HTML and JavaScript. • Completely reengineered the corporate Intranet to take greater advantage of the available web technologies. Created an intricate set of packages, procedures, functions and object types to serve as the Intranet web application back-end. Created several objects in the process of designing the system, including tables (including indexes, constraints and triggers), views, materialized views, and dbLinks. On the UI side, much focus was placed on using JavaScript and DHTML for greater page dynamism and improvement of the user experience.

• Developed the corporate Work Authorization Application using the Oracle 8i database, jDeveloper, Oracle Developer and the MOD PLSQL package. Built the entire new application that is used for launching all projects, including setting up the project in Oracle Applications and installing the legacy engineering database for each project.• Created a methodology for loading legacy data (Universe) into the newly created Oracle database in order to access engineering data using web applications. Used SQLLoader to import the data to temporary tables, which was then loaded to the appropriate Oracle tables using triggers that executed extensive validation procedures.• Created a web-based Field Change Order (FCO) system that connects to both Oracle and UniVerse data in order to manage cost changes in the field. The system was designed using Microsoft Front Page for the user interface templates/prototypes, DHTML and JavaScript for dynamic web forms, UltraEdit for the PL/SQL and MOD PLSQL code, Toad for creating the database objects and Oracle 9iAS for testing and deployment.• Created a corporate Training System and a Project Action Item System using the Oracle 8i database, jDeveloper, Oracle Developer and the MOD PLSQL package. This system was used by employees to register for the various classes offered by the company. The system was designed using Microsoft Front Page for the user interface templates/prototypes, DHTML and JavaScript for dynamic web forms, UltraEdit for the PL/SQL and MOD PLSQL packages and procedures, Toad for creating the database tables and views and Oracle 9iAS for testing and deployment.• Developed the corporate Lessons Learned database (Knowledge Base) using UniVerse and used work-flow driven processes to create the web-based user interface. The system includes extensive use of automated emailing to completely manage the project approval process.