Orlando Building Energy Benchmarking - Oracle APEX Edition

Technologies Used

Oracle APEX, PL/SQL, JavaScript, Leaflet, HTML, CSS, APEX AJAX Callbacks, Dynamic Actions

I developed a custom plugin for the Leaflet map that responds to Energy Star ratings by dynamically adjusting the size and color of the circles based on the value of the data. The plugin utilizes the page designer's SQL source, native refresh, and other Oracle APEX features.

Description of Project

A redesigned and enhanced version of the Green Works Orlando Building Energy Benchmarking program, built as part of my Oracle APEX portfolio. This project tracks and analyzes the energy and water usage of Orlando's largest buildings.

• Created a custom plugin that dynamically changes the size and color of map points on a Leaflet map, featuring an AJAX callback with native refresh and data updates from the SQL source in the page designer.
• Improved decision-making capabilities by integrating faceted searches, dynamic actions, and interactive reports, allowing users to filter and explore data effortlessly.
• Integrated Leaflet maps and APEX components such as graphs and grids to deliver comprehensive visual data insights.
• Focused on creating a user-friendly interface with custom CSS and JavaScript, ensuring a smooth, interactive experience tailored for energy data analysis.
• Developed a responsive design for optimal usability across devices, ensuring accessibility for all users.

Green Works Orlando Building Energy Benchmarking

Technologies Used

JavaScript, Leaflet, HTML, CSS

Description of Project

A program focused on tracking the energy and water output of Orlando's largest buildings.

"Green City" Designation: Contributed to Orlando's designation as a "Green City" and the awarding of related grants.

• Enhances decision-making capabilities significantly by extensively utilizing JavaScript to filter JSON data.
• Utilized leaflet maps, along with various graphs and grids, to facilitate data dissemination, enabling clients to gain a clear understanding of energy conservation participation.
• Developed a user-friendly interface that allows clients to easily access and analyze data.
• Implemented a responsive design that allows the website to be viewed on any device.
• Followed City of Orlando guidelines closely, ensuring consistency and continuity by customizing Leaflet popup styles with CSS.

California Federal Court System Project (2004-2012)

Developed and maintained a robust web application for the five districts of the California Federal Court System, ensuring efficient data management and seamless user experience.

Technologies Used

• Backend: SQL database for data collection, storage, and management.
• Frontend: ASP for dynamic content generation, with HTML updates triggered by database changes.
• Performance: Created a fast, static website ensuring high performance and reliability.

Role & Responsibilities

• Led the development team in designing and implementing the database structure and backend logic.
• Coordinated with stakeholders to gather requirements and ensure the system met all operational needs.
• Optimized the application for speed and efficiency, resulting in a highly responsive and reliable system.

Challenges & Solutions

• Data Management: Ensured secure and efficient handling of sensitive court data.
• Performance Optimization: Overcame challenges related to dynamic content by leveraging static HTML updates for faster load times.

Impact

This system provided a blazing-fast and stable platform for users, combining the benefits of dynamic data.

Software Development Businesses

WPDD, Inc./Advance Business Intelligence, Inc.

Services and Solutions 2000-2005

WPDD, Inc./Advanced Business Intelligence, Inc. - Co-Owner of a Company that provided full service business intelligence and website solutions. From a small e-commerce application to large scale, legacy integration projects, my company provided customized solutions.

Project Portfolio

AT&T

• Project: Cold Fusion Software Development
• Scope: Developed software to query data associated with AT&T Wireless, including sales and location information.

Marriott Senior Living Services

• Project: Custom PowerPoint Presentation System
• Scope: Created a system enabling salespeople to generate customized PowerPoint presentations for doctors. Salespeople could log in, select the specific senior living location, and customize presentations for their targeted doctors, enhancing their pitch efficiency.

Unisys

• Project: B2B Business Solution
• Scope: Developed a tailored e-commerce platform for direct sales. The solution included customized shopping carts and shopping systems that catered to the specific needs of individual customers.

Federal Court System

• Project: Content Management System
• Scope: Created a robust content management system with an SQL backend and HTML frontend. Opted for static HTML pages to reduce server load and improve performance, with dynamic updates triggered by database changes.