Lead developer responsible for leading all development activities at MedAire, managing MedAire database SQL Server infrastructure as well as guiding other developers in the technologies that MedAire uses. Development activities at MedAire are based upon Microsoft technologies, to include C# 4.5, SQL Server Reporting Services (SSRS), Microsoft SQL 2012 TSQL, Microsoft Team Foundation Server TFS, ASP.NET MVC, Web Services, as well as custom tools including Avaya CMS telephony system, the International SOS Case Management System (NewCase - inflight medical service cases) and Great Plains Dynamics 2016 (previously 10.0).Projects at MedAire included:Invoiced Sales - project takes sales and invoice data from Great Plains Dynamics and presets it in a manner suitable for both Finance and Sales personnel, using an SSRS reporting environment. Project makes was primarily developed in Microsoft SSRS, Microsoft TSQL and some C#.Reporting - led project to replace the existing reporting platform used by NewCase (Case Management System) with a data mart specifically designed for reporting. As part of this project I designed the database structure, redeveloped all the existing reports - reducing the number man days spent per month on reporting as well as increasing their accuracy. This project was all done in Microsoft SSRS, Microsoft SQL Server 2008/2012 and Microsoft TSQL.Avaya CMS Reporting - this project pulls data from an external Informix database, using a custom developed C# application which is stored in Microsoft SQL Server 2008 with custom SSRS reporting.

As a member of the IT staff, I was the primary architect and programmer for the SoftPro 2.x Integration Project. SoftPro is a commercial Escrow processing software package, which has been designed to be extensible to end user customers. As the primary architect and programmer, I designed and programmed various methods to extract data from SoftPro in order to update existing Title Guaranty developed systems (running both UNIX and Windows), updating existing orders in SoftPro, as well as programmatically creating new orders in SoftPro. This required working with technologies such as: Windows Workflow Foundation (WF), Windows Communications Foundation (WCF) and Web Services. Systems which were integrated included:• Document Management System (DMS) – when a user printed a document from SoftPro, a copy was automatically loaded into DMS.• Contact Management – when a contact was updated in the corporate Contact Management System, open orders were scanned, and order contacts updated as well.In addition, whenever a user saved an order, SoftPro sends a message to a previously defined WCF endpoint. The end point that I developed ran a Windows Workflow Foundation (WF) 3.51 workflow to update open orders, as well as interface with the corporate DMS, Title and other internal systems.The project also included an extensive error handling, error reporting and order auditing process. The project was programmed in Visual C# 3.51. This was a long term (3 year) project, which successfully went live in July 2011.

As a contact programmer, I designed and developed a Windows Mobile 6.0 application designed to capture transaction and account information from a hotel guest debit card. The application was a multi-step Windows Mobile form application, written in C#.NET 3.51, once transaction data, including items, quantity, and tips where captured and sales tax calculated, the application captured account information using an attached RFID scanner, an electronic signature, then transmitted the data via a Windows Communication Foundation (WCF) service to a BizTalk backend for approval.

As a contract staff member (Manpower Professional employee), I provided programming support for the Core Systems Replacement Project (CSRP); a multi-year project to replace HMSA’s existing claims processing system with the QNXT system (3.2 and 3.4). All development activities were completed using Microsoft VisualBasic.NET (1.1 and 2.0), Microsoft SQL Server 2000 and SQL Server 2005. Applications included: • Hawaiian Healthcare Information Network (HHIN) – developed a nightly extract to pull claims data from the QNXT database to feed the HHIN database. Originally developed using Microsoft SQL 2000 DTS, the application was later ported to VisualBasic.NET 2.0 in order to take advantage of web services and in order to process a greater volume of claims.• Argus Drug Processing System – developed multiple portions of the HMSA Argus Drug Processing System, including: a module to read Argus supplied data files and prepare them for further processing by BizTalk/QConnect; a module to price and adjudicate Argus drug claims (outside normal QNXT processing), a module to calculate member accumulator values and transmit them to Argus, as well as several modules to read and process Argus supplied balancing information. All development activities were done using Microsoft VisualBasic.NET 2.0 and Microsoft SQL Server 2005 (T-SQL).These applications required a through working knowledge of the QNXT database, how it stores, processes and adjudicates claims as well as understanding the relationship of providers to members for various private business products.

As a member of the IT staff, I provided programming support for various enterprise and business oriented web applications, using Microsoft ASP.NET, Visual Basic.NET, Visual C++, and Microsoft SQL Server 2000. These applications included:• Employee Staff Directory – internal website to manage staff contact information (application also fed other applications).• Employee Comments and Responses – internal website for processing employee comments and leadership responses.• Strategic Planning and Enhancement Group (SPEG) – external website for the group to publish its mandates, directions and events.• Procurement, Travel and Business Expenses (PTBE) – internal procurement system website for employees to request business and travel reimbursement as well as request supplies.• Risk Management – internal site to track school Policy and Procedures, their expiration and required update dates, as well as publish them to the schools external website.• Core Asset Valuations – internal site for calculating revenue for school owned residential properties (used primarily reporting to school Trustees).Additionally as a member of the development team I designed and configured the architecture for all programming department development activities, including providing specifications on hardware and software (Visual Studio 2003, Visual SourceSafe, SQL Server 2000 and Microsoft SiteServer).

As a contract employee, I provided programming support for Axean-Pacific and its customers, as well as providing training support to Axean clients. Major efforts at Axean-Pacific included:• Provided support on Microsoft Visual Basic 6.0, Microsoft SQL Server 7.0 Administration, and Microsoft Visual Interdev 6.0 for HelpHawaii.com as an instructor.• Developed a prototype application for the U.S. Coast Guard in C++, designed to run on the Palm Pilot, for use in assisting the U.S. Coast Guard to track boarding and inspecting of incoming ships to the Honolulu harbor.

As a member of the development team, I worked on developing a routing system for telephone switches. As part of this development activity, I developed an in-memory database, designed to store upwards of 300MB of data in memory, a COM/MTS based engine for routing telephone calls (using MSMQ). In addition, I developed a testing application for the team using MFC with XML based test scripts. All development was done using Microsoft Visual C++ 4.0, MFC, Active Template Library (ATL) and the Standard Template Library (STL).

Database Administrator and Data Architect• Microsoft 6.5 SQL Server Database Administrator and Architect - Responsible for the design and implementation of the database that runs the American Express Last Minute Travel web site.Web Programmer/Programmer Analyst• Web Programmer – Responsible for maintaining the American Express Travel web site, maintaining tools used for the Last Minute Travel Web site (developed in Visual Basic 4.0). Participated in porting web sites from Unix/HTML system to the Windows/ASP environment.

Designed and developed a reservation system for their national reservation system, using Microsoft SQL Server 4.21a, Microsoft Visual C++ 4.0, and Microsoft Visual Basic 4.0. Worked with one other developer to design, build and implement the system in 90 days. Also responsible for managing SuperShuttle’s internal network, database servers, remote servers (San Francisco, Dallas, Denver, Sacramento) and Local Area Network (Windows NT based).