WILLIAM H. LONG
330-780-7261
BLong@trilonis.com

Summary

Extensive experience in the design, development, implementation, and management of information systems. Also experienced in Microsoft Office SharePoint Server 2007 Intranet administration, architecture, configuration, site development, training, and customization.

Technical skills

Employment History

TriLon Information Services- Stow, OH 2009 - Present

A custom application development company
Owner
Developed and maintained custom applications for a variety of industries including:
The Timken Company - Canton, OH           April 2010 - Present
A manufacturer of bearings, alloy steels and related components and assemblies.

• Developed SharePoint and ASP.NET applications for the corporate intranet and the internet.
• Maintained legacy ASP applications.
• Wrote a web service application to maintain the Corporate Active Directory to contain authentication and authorization information for internet users.
• Wrote SharePoint webparts, controls, and pages.

RTI International Metals - Niles, OH           February 2010 - March 2010
A producer of titanium and specialty metals

• Assisted in SharePoint administration: set up sites, wrote workflows, and designed and developed SharePoint pages.

SEMAA - United States           August 2009 - February 2010
NASA’s Science, Engineering, Mathematics and Aerospace Academy

• upgraded SEMAA’s administrative web site to ASP.NET 2.0.
• Rewrote their performance report forms.
• Wrote an application to fill in Excel performance report templates from a SQL server database using Xpath.
• Added a newsletter archive application.
• Added additional functionality to several other of their administrative applications.

Member Health- Solon, OH October 2006 - April 2009

A Medicare Part D provider
Senior Web Developer
MOSS 2007 Projects

• Worked with intranet management team to define and document intranet requirements
• Implemented corporate intranet with MOSS 2007 Enterprise edition.
• Set up department sites
• Set up security authentication and authorization for departmental sites using Active Directory and SharePoint groups.
• Trained the training department and helped train department site owners to maintain content on those sites.
• Helped department site owners customize departmental site content and pages using webparts, features, and Excel Services.
• Developed custom feature files.
• Developed custom workflows using SharePoint Designer 2007 and Visual Studio 2005.
• Designed and implemented a Grievances Tracking System using SharePoint 2007 lists.
• Developed a CMS Quarterly Report WebPart using SharePoint web services, SharePoint Object Model, and C# to get data from the Grievances SharePoint list with XPathNavigator to output a report to an excel spreadsheet.
• Developed an Access Request System using SharePoint, InfoPath, Form Services, XML, XPath, C#, ASP.NET, SharePoint Web Services, SQL Server and stored procedures.
• Developed an event receiver to alert managers whenever one of their employees sent a request to the help desk requests list using the SharePoint Object Model to interface with Active Directory.
• Developed a custom SharePoint Master page for the marketing department’s defined look and feel using SharePoint Designer and Visual Studio 2005.
• Developed SharePoint Dashboards for each department using SSRS, key performance lists and key performance indicators.
• Developed a CMS Compliance Report using ODBC, XPath, XPathNavigator, and C# to get data from an Excel Spreadsheet and write the report to an Excel Spreadsheet.

Web Based and Client Server Projects

• Designed and developed a Client/Server Contract Tracking System for the Legal Department using C# with a SQL Server database and Transact-SQL stored procedures
• Developed Client side Prior Authorization Reports using SQL Server Reporting Services (SSRS) for the client, C#, SQL Server and Transact-SQL stored procedures.
• Developed a web based Beneficiary Eligibility Query Program using Web Services, JavaScript, AJAX, C#, ASP.Net, SQL Server, and Transact-SQL.
• Developed an application to generate Transact-SQL scripts using SQL Server Management Objects (SMO) .
• Designed and developed a prototype of a front end for the provider database using C#, html and ASP.NET.
• Eligibility and provider database load routines using SSIS and VB.NET

SharePoint 2007 training I received

TriLon Information Services - Stow, OH      August 2000 - October 2006

A custom application development company
Owner
Developed custom applications for a variety of industries including:

• NorthCoast Health Care Management 2006 - A health care management organization
  Designed and coded a web based home care, hospice, and home infusion therapy claims adjudication using C#, ASP.NET, and MS SQL Server.
• Key Bank 2006 - A Bank
  Developed a web based Security Baseline Application for their Corporate Information Security Department using C#, ASP.NET, JavaScript, and MS SQL Server.
• Inspherion2006 - a knowledge research company
  Developed a client/server patent research application using C# .NET, Windows.Forms and Crystal Reports.
• National City Corporation 2005 A Bank Developed a web based Learning Center for the human resources department with C#, ASP.NET, JavaScript, and MS SQL Server.
• OEC Corp. 2002 - 2003 - an equipment supply company
  Developed a web based sales-rep remote order entry system using Visual Basic 6.0.
• J.P. Farley & Co. 2000 - 2001 A Third Party Administrator
  Developed an EDI translator, eligibility load, and exception handling system using Visual Basic 6.0 with an Access database.
• TriLon Information Services 2000 - 2005
  Worked on upgrading my managed health care applications to current technology using Java and J2EE on the Eclipse IDE with MySQL database and phpMyAdmin with Linux operating System. Developed Web site www.trilonis.com using Microsoft FrontPage.

Health Design Plus - Hudson, OH 2000 - 2000

A Medical Managed Care, Third Party Administration (TPA) company.
Director of Information Services

Managed information systems department. Developed EDI and membership load systems.

Jo-Ann Stores - Hudson, OH 1998 - 2000

A fabric and cloth retailer with over 1,000 stores and $1.25 billion in annual sales.
Technical Specialist

Relocated from Sherman Oaks, California to Ohio by Jo-Ann Stores after acquisition of House of Fabrics. Coded in-store receiving system using HOF's system as base.

House of Fabrics - Sherman Oaks, CA 1995 - 1998
Senior Programmer/Analyst

Designed, coded, and implemented in-store back office systems for ordering, receiving, and inventory control along with corporate systems to monitor the in-store systems. Streamlined EDI communications with stores using the new systems. This gave HOF increased control, timeliness, and decreased costs for their reordering process.

Tri-Lon Computer Systems - Big Bear, CA 1982 - 1995

Owner

Developed mission critical information systems for companies in a variety of industries:

• Designed, coded, and maintained an outstanding TPA and PPO managed health care adjudication and administration system.
• Designed and coded a self-insured and self-administered employee health benefits administration system for a major hospital society.
• Designed and coded a catalog system for the computerized ordering of medical supplies
• Re-engineered a medical supply company including Material Requirements Planning, Supply Ordering, Cost of Sales, Inventory Control, Shipping, Production Scheduling, and Financial Systems.
• Developed a truck scheduling system for a vending company.

PacifiCare, Inc - Cypress, CA 1977 - 1982

A California based Health Maintenance Organization.

Director of Information Systems

Managed the information systems for a startup HMO. Designed, coded, and maintained an excellent HMO managed health care system. The information and control gained from the system gave a competitive advantage that contributed to their growth to $12 billion a year.

Big Bear Foursquare Church - Big Bear, CA 1987 - 1992

Pastor

Built a church from one family to 20 families.

Certifications

Microsoft Certified Professional - Visual Basic 6

Designing and Implementing Distributed Applications
Designing and Implementing Desktop Applications

Education

B.A. in Psychology University of California at Riverside 1971
B.A. in Theology L.I.F.E. Bible College 1978