Aaron Vail Email & Phone Number

Orlando, Florida Area

Mirth: Build connections between various hospital systems to allow patient data to be routed to appropriate departments. Worked with Cloverleaf team to coordinate delivery of messages to various destinations within the Orlando Health network in addition to many outside entities. Replaced 20 year old Fox Pro code to query database and build EDI x12 852 messages.Java: Built standalone console to monitor 4 main Mirth Virtual appliances. Released single application monitor to MIRTH community for public usage.

Mirth: Worked with network team to on-board new clients or convert existing clients to HL7 live feeds via VPN and port assignment. Developed new process for Zotec Partners to store HL7 messages on SQL Server 2008. Lead MIRTH team to implement new process for data extraction to various file types and formats for many clients as part of a Zotec Partners company conversion. Worked with File Management team to ensure client file routing was accomplished. Created over 200 new MIRTH channels for data extract conversion.MySQL/SQL Server 2008: Created new MySQL database to use as part of a major project to store and extract billing data. Worked with SQL Server database team to organize new tables for MIRTH projects.

MIRTH: Used to automate email notification to end user of account expration. Watch Oracle database for activity and respond with various output transactions including html-based email, excel files, csv files, database updates and WSDL connections.iMovie: Produced training videos to educate web application users.HTML5: Built web sites with responsive adaptation for use on all portable devices and desktops.Oracle 11g: Manipulate schema tables for use with existing web application.Toad: Create custom SQL queries for use in state-wide emailing efforts as well as gathering data as requested from upper management including the Governor's Office.PL/SQL: Read, understand, manipulate and create stored procedures, functions and triggers.HL7: Able to understand HL7 (Health Level 7) messages and diagnose issues for end users which is essential for Meaningful Use.HTML, Javascript, Java: Update and create content for State Registry web application.PowerPoint: Create presentations for training for personal presentations and state-wide audiences.Presentations: Perform monthly user group training sessions throughout Indiana to educate the various functionality of web application. Spoke at 2014 Indiana Government IT Digital Summit concerning the MyVaxIndiana web site created to allow anyone given immunizations in Indiana access to their records from the Registry. Presented at the Indiana Community Health Worker Coalition in 2013 to discuss the Children and Hoosier Immunization Registry Program and its benefits. Perform monthly web casts for supported program to state-wide health care professionals.Apple: Tested in-house developed apps with iPhone and iPad for release with MyVaxIndiana.VB .NET: Use Visual Studio 2010 to create standalone application for specialized Oracle quires for use by internal staff only.Help desk: Take phone calls to support web application users.Documentation: Write documentation to accurately describe code and functionality used.

MS Server 2003: Managed 5 servers which include Exchange 2003. Performed routine backup and restore procedures. Active Directory: Managed user accounts and group policies.HTML, Javascrip: Update and create content for company web site.SharePoint: Installed and created internal site for management of company projects and calendars.AutoCAD LT: In charge of company CAD standards. Drafted over 100 files Google SketchUp: Sole employee in charge of all 3D CAD projects some of which were presented in federal courts of law.Helpdesk: Single-point contact for all employees whether in office or out. Issues range from new monitors to assistance with software and computer training. Assist with project in several parts of the world (Brazil, Argentina, Rome, Spain) via remote desktop.Purchasing: In charge of all IT purchasing including hardware and software such as desktops, monitors, servers, network cable, raceways, network switches, racks and rack servers.Asset Management: Tracked all hardware warranties in addition to software licenses.Spiceworks: Installed custom server for IT ticket system and inventory tracking.VB 6: Created custom VB software for Dell Axim X51v handheld device for field data collection and transfer to Excel.Documentation: Write standard operating procedure to detail all functionality of in-house IT department.Other: Re-wired 90% of new building with network cabling. Web based FTP server to allow world-wide clientele to send and receive files too large for emails.

A system analyst with responsibilities to troubleshoot, code, test and implement projects on a large scale using Oracle Forms, PL/SQL, UNIX, COBOL and VB. Projects include updating existing software to reflect laws passed by legislature on an annual basis. Designed and built several software projects from an concept to implementation in a timely manner. Worked with more than 500 tables and 3000 forms.Oracle 9: Database used.PL/SQL: Read, understand, manipulate and create stored procedures, functions and triggers.Oracle Forms: Create and manage several forms for use by staff to calculate tax code.Documentation: Write documentation to accurately describe code and functionality used.Unix: Limited training and access used to manipulate COBOL code.COBOL: Manage multiple procedures

Indianapolis, Indiana Area