...and find the answers to your data questions!
On a scale from “Some experience” to “I could train a team in this skill”
The central structure for processing APCD submissions, the CDM incorporates an efficient yet thorough system of processes for performing data intake, transforming for usage in several applications, and eventually loading the data into the warehouse. Data Integrator is used extensively, performing many ETL roles, and Oracle 11g is the primary warehousing system. Incorporates mapping, process management, security, REST capabilities, and much more.
SQL/PHP Dynamic Server
A large employee database, created on a hosted server leveraging MySQL. This schema details how the tables are structured. A demonstration of a live table with CRUD functionality and SQL-specific features may be found here, along with several technique explanations. All interactions are controlled through user permissions and carefully-parsed language to prevent SQL injection. Table structuring is all done through PHP using phpGrid for simplicity and performance reasons.
Java Contacts Manager
Created as an interview project, this program demonstrates effective encapsulation, input sanitization, and a persistent database on the backend. Only standard Java components were used, and the UI was programmed exclusively through Swing. The database CSV is synchronized with an ArrayList<Contact> object for clean maintenance and simple constructors. Search functions allow parsing for either name or phone number. Edits to the Contact information in the JTable are sanitized to remove any commas to prevent database corruption. Any CSV file with two values per row can be opened and edited using this tool. Click this link for a demo; this contacts.dat file can be used as the database file.
Sebago Trails Paddling Co.
Clean, easy-to-navigate modern website for a local kayak rental company. Goals were to provide essential contact info quickly and encourage mobile browsing through responsive design. Leveraged Drupal core, added SQL-based inventory backend for future growth of company. Also created social elements, such as personalized kayaking blogs for customers, to encourage greater involvement. Responsive design to tap mobile market as well – the site looks great and works at all display resolutions.
House of Lights – Website
A complete redesign of the e-commerce site for this local specialty lighting retailer. This project involved creating a new landing page which would drive traffic to browse the online selection, creating new art assets from scratch in Adobe Illustrator and Photoshop for nearly every visible portion of the site, and synchronizing the feel of the front and static pages with the catalog, also hosted on the same site. Provided creative direction to a small team of programmers, and took the new layout from sketch to reality.
House of Lights – IT Redesign
Designed an entirely new structure for incorporating CMS and other business needs into a cloud system for simplified maintenance, portability, and lifetime cost control. Leveraged XenApp with a NetScaler Gateway and Citrix Receiver to distribute all required applications to an array of Windows XP desktops, Windows 8.1 tablets, iPads, iPhones, and Android devices. Also specified a cloud storage system which provides backup for all business data (primarily CMS, emails, and documents), and a local NAS through QNAP for centralized storage of local-distribution files and data, such as video and audio. Project required coordination between several different third-party contractors and extensive customization of local and remote code.
Meet Brandon Perry
This portfolio website was created with extensive custom HTML, CSS, and jQuery functions. WordPress was leveraged for expandability and page management/metric tracking, along with user roles being easily administered. Sixteen columns approach throughout for responsive design – try pulling it up on your phone!
I’ve been fortunate enough to be working with the fantastically talented team at Onpoint Health Data as a Systems Analyst, providing great opportunities and challenges on a daily basis. We handle data from a massive array of payers throughout the country, processing all formats and securing transmission, ETL processes, storage, and full analytic packages. We also act in consulting roles for state and APCD systems, and actively engage our communities to increase awareness regarding the many health care concerns today.
I live in Maine, a wonderful state of extremes in temperature, gas prices, and politics; it also happens to have some of the most beautiful areas in the US, such as Acadia National Park, for delightful diversions.