End Point Team

Our team, headquartered in New York City, has developed, maintained, and hosted ecommerce and other web solutions since its founding in 1995. We combine web application development, database and hosting expertise with understanding clients' objectives to excel in client satisfaction.

Mark Johnson

Mark Johnson

E-commerce developer and database architect

With End Point Since: 2002
Location: Herndon, Virginia

Mark has been working in web and database management, design, and development since 1998. He has expert knowledge of the Interchange application server, Perl, HTML, JavaScript, advanced SQL, stored procedures, and relational database concepts. His database experience is with Oracle, PostgreSQL, and MySQL, including the successful completion of Oracle University's Database Administration class in 2002. He also has experience with Apache web server installation and configuration, as well as general system administration. Mark has also been a long-standing code contributor to the core Interchange application.

PACA Website Transfer. Ported static site to Interchange and provided data-driven member listing and detail, online membership application and event registration, and customized admin for data and member management.

Postcard Press Promotions. Developed administrative interface and back-end to create, manage, and analyze promotions delivered by any number of means to customers and prospects alike.

Backcountry.com "Bill Me Later" Integration. Created new functionality within Interchange to offer instant credit for qualified buyers.

Chief Systems Engineer for Florist.com from 2003-2005. In charge of managing database, web server, and Interchange application servers.

Senior Systems Architect for Red Hat, Inc. from 2000-2002. Lead member of technical division of Professional Services group; developed (along with other core developers) code base and core functional extensions for Interchange.

Lead Web Developer for Dept. of Health and Human Services from 1998-2000. Developed web applications using Perl and JavaScript with an Oracle database via Win32::ODBC and DBI; administered Microsoft Windows NT network, Oracle database, and IIS web server.

BS, Mathematics, University of Oklahoma, Norman, 1998.

Oracle University Database Administration, 2002.

Mark lives in Herndon, Virginia, with his wife Lori, two sons Joshua and Nolan, dog Pinball, and cats Porter and Sydney. He enjoys college football and basketball, and is a rabid Oklahoma Sooners fan.

Recent Blog Posts By Mark Johnson

Localize $@ in DESTROY

July 26, 2010

I have been conditioned now for many years in Perl to trust the relationship of $@ to its preceding eval. The relationship goes something like this: if you have string or block eval, immediately after ... (Localize $@ in DESTROY cont.)

In Interchange, You Might Need to [try] [goto]. What's the [catch]?

April 19, 2009

Interchange provides tags that allow error trapping and handling within ITL--[try] and [catch]--that can be thought of as analogous to perl's eval {} followed by if ($@) {}. However, as I discovered th... (In Interchange, You Might Need to [try] [goto]. What's the [catch]? cont.)

Announcing Release of PostgreSQL System Impact (PGSI) Log Analyzer

February 14, 2009

The PostgreSQL System Impact (PGSI) log analyzer is now available at http://bucardo.org/wiki/Pgsi. System Impact (SI) is a measure of the overall load a given query imposes on a server. It is expresse... (Announcing Release of PostgreSQL System Impact (PGSI) Log Analyzer cont.)

Parallel Inventory Access using PostgreSQL

December 12, 2008

Inventory management has a number of challenges. One of the more vexing issues with which I've dealt is that of forced serial access. We have a product with X items in inventory. We also have multiple ... (Parallel Inventory Access using PostgreSQL cont.)