Lewis C. Lorenz

Using FileMaker Pro database and other technologies to optimize repetitive administrative tasks to make organizations more efficient and profitable.

Lewis C. Lorenz is an attorney, husband, and father.

Experience

Attorney / Owner
Lewis C. Lorenz, Attorney at Law
June 1993 – Present, Tulsa, Oklahoma.

Bankruptcy, Criminal Defense, Estate Planning & Probate, Family Law. Designed, implemented, and maintains software solutions for law office case management, tickler, accounting, and form and document automation for all areas of practice.

Software Engineer / FileMaker Pro Developer
Lorenz Companies
January 1985 – Present, Tulsa, Oklahoma.

Development of stand-alone, server-based, and web enabled FileMaker Pro database solutions, and Internet domain site design and hosting using Apache, MySQL, PHP, HTML, CSS, and JavaScript.

Clients and products include:

U.S. Department of Interior, Office of Hearings and Appeals. Designed and implemented a national database application to help the Administrative Law Judges within the D.O.I. Office of Hearings and Appeals manage the probates of Native Americans. The application allowed all Indian agencies and tribes who report to these A.L.J.s to contribute and manage probate data through an Internet browser interface.

Muscogee Creek Nation Indian Health Service, Claremore and Okmulgee, Oklahoma. The I.H.S. required an American Diabetes Association compliant diabetes care application to help manage the huge prevalence of diabetes among the Native American population. A custom stand-alone FileMaker Pro solution was engineered to achieve this goal.

Native American agencies and tribes, United States. As the sources of probate information for the Office of Hearings and Appeals of the Department of the Interior, these clients needed an application to conveniently track and report this information to their Administrative Law Judge. A custom stand-alone FileMaker Pro solution was engineered to achieve this goal.

Judge Advocate General (JAG) Officer
United States Army Reserve, Judge Advocate General Corps.
November 1989 – March 1998, Tulsa, Oklahoma.

29th and 35th JAG Detachments, Team 7, Tulsa, Oklahoma; 2nd JAG Detachment, New Orleans, Louisiana; 122nd ARCOM, North Little Rock, Arkansas.
Provided legal counseling and document services, defenses in Article 15 proceedings, and legal advice to command staff.

Attorney
Richard Reeh and Associates
July 1988 – June 1993, Tulsa, Oklahoma

Primary area of practice was criminal defense and related case matter services. Designed and maintained office/case database management system, including form and document automation. Combined technologies to the law office.

Laborer
Baucom Concrete Construction
June 1982 – September 1983, Broken Arrow, Oklahoma

Laborer helping to construct tilt-wall concrete buildings.

Radio Broadcaster
KWOE, KCLI, KEBC, and KSEO
July 1976 – September 1981, Clinton, Oklahoma and Oklahoma City, Oklahoma

Disc jockey, news reader, and advertising production at KWOE in Clinton, Oklahoma (’76 – ’78).
News director and disc jockey at KCLI in Clinton, Oklahoma (’78).
News reporter and evening news reader at KEBC in Oklahoma City, Oklahoma (’78 – ’79).
Disc jockey, news reader, and advertising production at KSEO in Durant, Oklahoma (’79 – ’81).