JOHN T BELL
***** **** ****** ***** **** Phone: 253-***-****
Puyallup, Washington 98375 Email: abhuuk@r.postjobfree.com
SUMMARY
Technology Consulting Analyst with an extensive background in freight
transportation/logistics and transportation management/fleet management
systems, in addition to broad experience managing and building innovative
products and solutions on the IBM AS400 platform, is seeking contract
opportunities for software or professional services.
. Award-winning track record managing complex life cycles and delivering
high-quality software solutions
. Industry package expertise on TMW: TL2000, TruckMate, (Innovative)
IES; AgiliTrans LTL/400; ICS LogiMax; Qualcomm; PeopleNet; XATA; ALK
PC*Miler; Rand-McNally MileMaker; Maptuit
. Certified technical skills on IBM Power Systems (IBM i/iSeries/AS400
and IBM p/RS6000) platforms; DB2, Sybase, Oracle, SQL, MySQL; RPG III,
RPG IV, RPG ILE, RPG Free, SQLRPGLE, CL, CLLE, CMD, XML, Java, C, PHP,
JavaScript, CSS and HTML languages; DDS, Subfiles, Journaling, Triggers;
WDSC, Navigator, PDM, Query, SDA, RLU, Hawkeye and Sequel utilities; IFS,
Sockets, TCP/IP, HTTP, SOA, Web Services, Apache (Web Server), WebSphere,
Zend Core, J2EE, JUNIT, Java Toolkit; Gentran and TrustedLink EDI
PROFESSIONAL EXPERIENCE
iTransformations Incorporated, Puyallup, Washington: 12/2007 - Present
Transportation Business Consultant, Fleet Communications Client: 09/2010 -
02/2011
Provided business analysis on customer service requests to architect client
solutions, and performed process analysis that streamlined and standardized
software integration across individual product lines.
. Generated detailed requirements and statement of work documents to
facilitate customer service requests.
. Created a standard web service interface for integration of CSA Driver
Hours with third-party vendor software.
IBM i: DB2, SQL, RPG ILE, CLLE, XML, Java, HTTP, SOA, Web Services, Service
Programs
Consultant, Freight Transport Client: 01/2010 - 07/2010
Teamed with client process owners and IT group to develop process workflows
for capturing key performance metrics; created dashboards to support data
visualization of real-time fleet utilization via mobile communications.
. Dashboards replaced fleet mobile-polling and data collection, projecting
a yearly savings of 1200+ man hours
IBM i: DB2, SQL, MySQL, RPG Free, CLLE, PHP, CMD, JavaScript, CSS, Zend
Core
Consultant, Roesler & Associates SPARC Project: 03/2008 - 01/2010
Served as the Technical Project Manager on twelve-person team that
addressed corporate process improvement initiatives at a freight
transport/3PL client. Assisted in the collection of business needs and
modeling of system workflows; generated detailed data analysis and
technical reviews of all databases and applications.
. Data analysis revealed lost opportunity costs of $320,000 per year, over
a five-year historical period
. Applied process analysis to architectural integrity issues for resolving
the corporate profitability data model
IBM i: DB2, SQL, RPG IV, RPG ILE, CL, CLLE
Identified opportunities for improving intermodal freight and 3PL business
processes; developed an order distribution interface for dedicated
logistics/3PL, as well as freight workflow solutions for fuel tax, driver
layovers, fleet mobile communications, tariffs/rating, Interliner eCommerce
and CRM. Integrated workflow solutions into the TMS ERP package, along
with best practice features for mileage/routing management and alert
notifications. Generated business requirement and system design documents
for remote software development.
. Restructured fleet mobile communications messaging workflow reduced
monthly invoicing by over $18,000
. Enhanced operations workflow translated into record order counts in
successive months after implementation
IBM i: DB2, SQL, IFS, RPG ILE, RPG Free, SQLRPGLE, CLLE, CMD, DDS, PHP,
Triggers,
TCP/IP, HTTP, SOA, Web Services, Apache, Stored Procedures, Service
Programs
Consultant, Freight Distribution Client: 12/2007 - 03/2008
Integrated clients' TMS ERP and WMS packages for streamlining workflow to
back-office accounting functions.
IBM i: DB2, RPG IV, CL, DDS
Qualcomm Incorporated, Portland, Oregon: 12/2003 - 12/2007
Senior Software Engineer/Project Manager, Enterprise Services Division
Participated on strategic planning teams as transportation business
analyst; translated requirements into functional specification and design
documents for fleet management eBusiness applications. Collaborated on
development of estimated time-of-arrival and out-of-route fleet-tracking
applications, incorporating B2B integration. Aligned with business partner
on development of hosted web-portal service applications for a FMS trailer-
tracking product; responsible for development and testing on back-end
processing of web-page functionality, as well as facilitating data
integration with leading TMS ERP packages.
. Teamed with customers to deliver key business requirements for
development of value-added service offerings
iSeries: DB2, SQL, RPG ILE, DDS, SQLRPGLE, CLLE, CMD, XML, Java, TCP/IP,
HTTP, SOA, Web Services, WebSphere, Service Programs, Apache, J2EE, JUNIT,
IBM Java Toolkit, Stored Procedures
Performed life cycle development of a FMS fleet-tracking arrival/departure
product, including seamless integration with commercial mileage/routing
engines and leading TMS ERP packages. Managed the product roadmap,
performed product demonstrations and authored documentation manuals.
. Initiated project for customer data refinement that improved
arrival/departure product accuracy by 30%
. Awarded a Gold Star on "Hall-of-Fame", in recognition of contributions to
arrival/departure project
iSeries: DB2, RPG ILE, CLLE, CMD, XML, DDS, HTTP, SOA, Web Services
__________________________________________________________________
TransSoft Corporation, Tacoma, Washington: 11/1996 - 12/2003
Principal
Developed and marketed fleet management solutions for mobile automation of
mission-critical freight transport processes, including on-time delivery,
hours-of-service and driving logs. Performed sales functions and managed
implementation projects; teamed with senior management to tailor training
programs and TMS integration levels. Led client consulting projects to
evaluate operations, analyze workflows and improve TMS business processes.
. Eliminated customer's fleet mobile-polling for determining on-time load
status, resulting in an average monthly savings of 18 man-hours per fleet
manager
. Improved client operations productivity by 2% with "Safe & Legal
Dispatch" application for DOT compliance
AS400: DB2, RPG IV, RPG ILE, CL, CLLE, CMD, DDS, Subfiles, Journaling,
Triggers, Service Programs
__________________________________________________________________
Qualcomm Incorporated, San Diego, California: 09/1992 - 11/1996
Applications Software Engineering Manager, Wireless Business Solutions
Division
Managed development of truckload freight optimization products in
conjunction with business partners, as well as QA and UAT processes, and
customer implementations with a team of three direct reports. Authored
assessment guides to evaluate prospect readiness, developed TMS integration
and analyzed historical data for business models.
. Adapted new technology into client's operations, decreasing deadhead
mileage by an average of 4 percent
. Awarded "Software Employee of the Year" for 1993 and 1994, in recognition
of outstanding customer service
AS400: DB2, RPG III, RPG IV, C, DDS, Sockets, Journaling, TCP/IP; RS6000:
Sybase, C, TCP/IP
__________________________________________________________________
Additional positions with increasing levels of responsibility are available
upon request.
EDUCATION/CERTIFICATION
BS in Computer Information Systems, Eastern Washington University
Six Sigma Green Belt Master Certificate Program, Villanova University
IBM Software Specialist Certification - RPG ILE Developer
Project Management Professional Certificate Program
TMW (Innovative) IES ERP Trainer Certification