John A. Cartwright
(602) 432 - 6772
109 South Doran
Mesa, Arizona 85204
(602) 432-6772
SUMMARY:
<!--mstheme-->I have twenty-five years experience providing IT business solutions. My experience includes IT management, project management, systems analysis and design, programming and application support and training. In 1987, I was working as the Project Lead with IBM for the MAPICS Advanced Manufacturing and Inventory Management Support Groups in Atlanta. I was fortunate to have the opportunity to train with IBM’s staff in Rochester, MN on the then new AS400. I have since worked as an AS400 / iSeries specialist for a many companies in a variety of industries.
I have a strong technical and programming background but my real strengths lie in my business knowledge, my ability to understand and adapt to new situations and the way I work with people. I am honest and realistic in both my solutions to problems and in reporting to management. I try to bring the most practical and efficient solution to each opportunity without sacrificing quality. <!--msnavigation-->
My Accomplishments Include:
As a Decision Support Analyst for a major Hybrid Medical Electronics Manufacturing company, I worked in conjunction with IT to successfully implement a Custom Requirements Planning, Purchasing, Inventory Control, Shipping and Lot Tracking system. I worked to develop new procedures and controls leading to successfully reducing inventories and costs throughout the Materials organization.
I worked as Project Lead for IBM providing APAR support for over 32,000 worldwide IBM MAPICS Advanced Manufacturing, Inventory Management, Purchasing, and Order Management customers. My responsibilities included support for MAPICS on all platforms (SYS 36/38 and AS400). My primary responsibility was to work with my team to resolve the open APARS and compile the PTF's and documentation sent to each MAPICS customer. I also provided several major design changes for the MRP and Product Costing and Process Manufacturing applications and was at ground zero for the introduction of the AS400. As a result, I was IBM's primary representative at COMMON for the MAPICS applications.
As Project Manager for the Northwest's largest Grocery and Merchandising Company, I designed and oversaw the programming of a Custom Retail-Accounting and Reconciliation application. My areas of responsibility included analysis, design, programming, documentation, software rollout, support and management reporting. This application provided complete next Day Audited Sales Reporting and Reconciliation for checks, bank receipts, money orders, stamps, licenses, and register receipts.
As a consultant to a Major Mutual Funds company in the Northwest, I was responsible for establishing an integrated reporting system and interface for the Third Party Participants and supported many of the Custom Applications for both the Trust and Funds groups. I also was a major player in Y2K programming and testing. My accomplishments were recognized throughout the company and from outside participant fund managers.
As Project Manager for the Nation’s second largest Forest Products Company, I directed the installation and implementation of Anderson’s MacPac Manufacturing application. The nature of the Forest Products Industry required modifying and re-engineering MacPac to meet the needs of the special requirements for the Building Material Group. A 70 percent redesign for Order Maintenance, Distribution, Production Scheduling and Sales was required. In addition, my job required converting existing applications from an IBM 4380 to the AS400. I was the primary analyst and programming lead for the team responsible for defining requirements and programming each division within the Building Material's Division (Lumber, Plywood, Particleboard, MDF, etc.). I helped establishing a unique inventory and product identification system for the various Lumber applications and was responsible for the conversion all of the Building Material Division's MacPac applications to RPGLE. I worked with management and staff at each production facility around the country to identify the unique requirements relating to the type of production involved. I traveled to each plant across the nation assisting in converting old data and training the users to use the new system.
I have worked in the Retail Industry in Retail Accounting, Reconciliation, Credit and PCI (Payment Card Industry) Compliance. The retail applications have included Teller Reconciliation to registers, Sales Reporting, Catalog Sales and Order Processing, Credit Card and validation and processing, and conversion of Credit Card numbers to PCI standards.
I have worked as a consultant to IBM (MAPICS), Fred Meyer (retail), Willamette Industries, Inc. (forest products), Menlo Logistics Company, Computer Guidance Corporation (construction management software), Charming Shoppes, Inc. (retail catalog) and other major iSeries companies. In each of these positions, I was as an analyst, designer and programmer. I also worked as Project Manager for several of these companies.
For the past 15 + years I have been President and a Primary Consultant with Cartwright & Associates, Inc.. I manage sub-contractors and company operations while providing analytical and programming support to both medium and large companies throughout the United States. Although my staff manages our Small Business accounts, I have developed a number of Web Sites for our small business clients.
SYSTEM ENVIRONMENT SUMMARY:
<!--mstheme-->IBM AS400 / iSeries<!--mstheme--> / RPG, ILE, <!--mstheme-->RPGLE, CLLE, SQL, DDS, SDA, DB2, Service Programs, Binder Source, Bound Procedures and Prototypes, Embedded SQL, Built in Functions (Bif’s).
Synon 2E
PCI
Y2K<!--mstheme--> / CGC Construction, <!--mstheme-->MAPICS, MacPac, BPCS, JDA, Lawson, JDE, EDI / EDIFACT, Implementer/Turnover and other change management software. I designed and programmed many custom Manufacturing, Financial, Accounting, Retail, Sales, Distribution, Logistics, and other applications. I have also converted several different systems and applications to the AS400 and upgraded older AS400 code to RPG400 and ILE and instrumental Y2K compliance for several companies.<!--mstheme-->
<!--mstheme-->IBM iSeries, SYS 3, 34, 36, 38, 4300 <!--mstheme--> / iSeries Utilities include: IBM Websphere Development Studio for iSeries, PDM, DBU, RDA, ROBOT, etc. / <!--mstheme-->MAPICS, MacPac, Numerous Accounting and Custom Applications including: CGC Construction, Retail Accounting and Credit, PCI, <!--mstheme-->
<!--mstheme-->HP3000<!--mstheme--> / <!--mstheme-->COBOL, RPG, V3000<!--mstheme--> / <!--mstheme-->MANMAN, MM3000, Custom Applications<!--mstheme-->
PC experience, <!--mstheme-->Languages and Tools<!--mstheme--> / Visual Basic, Microsoft Office products including WORD, ACCESS, EXCEL, MS Project, FrontPage, Outlook, etc. I've worked with most Windows operating systems including 3x, 95, 98, ME, NT, XP, and 2000. <!--mstheme--> / I am proficient with m<!--mstheme--ost PC tools including all MS Office as well as many Web development products, Graphics and Multimedia Tools. I primarily use the PC as a reporting tool and a link to mainframes and should not be considered as a PC Developer. I have, however designed and developed Web applications for a number of small businesses and designed many Access data base solutions.<!--mstheme-->
SUMMARY OF INDUSTRY EXPERIENCE:
Construction / Computer Guidance Construction Management Software / Analyst, Programmer and Support Specialist. Time and Materials A/R, and A/P. Worked directly with customers to resolve programming issues. Worked to rewrite busines logic to use ILE/SQL to work with a Java based user interface.
<!--mstheme-->Distribution and Logistics<!--mstheme--> / <!--mstheme-->Custom Software<!--mstheme--> / Programming, analysis, and support for a multi-client logistics and warehousing company. Support for all EDI transactions and development of new interfaces to various types of systems. Worked with third party software as well as in-house development of EDI applications. <!--mstheme-->
<!--mstheme-->Forest Products<!--mstheme--> / <!--mstheme-->MacPac / Custom Software development<!--mstheme--> / <!--mstheme-->Customized MacPac for a major forest products company. Developed customized plywood production scheduling system. Member of installation and training on-site team. Developed MacPac interface to custom GL software. Integrated custom programs for shipping, freight rating and routing, and EDI to MacPac's Order Processing and Billing.<!--mstheme-->
<!--mstheme-->Manufacturing<!--mstheme--> / <!--mstheme-->MAPICS, BPCS, Custom<!--mstheme--> / <!--mstheme-->Project Manager, IBM MAPICS support lead. Materials group Decision Analyst for a hybrid electronics manufacturing company. Project Manager for implementing Order Processing and Manufacturing Controls systems for a major sports products manufacturing company. IS Manager for a large window tinting and accessories firm. BPCS Support for Honeywell HPG. <!--mstheme-->
<!--mstheme-->Retail<!--mstheme--> / <!--mstheme-->Custom<!--mstheme--> / <!--mstheme-->Project Lead, primary analysts and technical lead for major retail accounting project. Designed and led the programming for integrated Sales Audit and Reconciliation application providing next day audited sales, and reconciling checks, cash, money orders, stamps, credit card receipts to the registers for each of over 100 large retail stores.
Catalog Retail Credit and Order Processing. PCI implementation and programming.<!--mstheme-->
<!--mstheme-->Financial<!--mstheme--> / <!--mstheme-->All general Accounting and GL and Banking and Finance.<!--mstheme--> / I have w<!--mstheme-->orked with various accounting packages and designed complete accounting, Sales, Forecasting, Commissions, Order Processing, and General Ledger Applications
Experience with a major Northwest Financial company working with Trust and Fund Accounting.<!--mstheme-->
<!--mstheme-->Other<!--mstheme--> / <!--mstheme-->Change Control Project Management
Application Design
Web Development
Robot
Data Base (DB2 DDS)<!--mstheme--> / <!--mstheme-->Managed many large multi-million dollar projects and a variety of smaller projects in various companies and industries. I am an experienced application designer and programmer and I have worked as a data base administrator and designer. I have also worked with a variety of Change Control applications and have managed many software rollouts.
Medical Accounting<!--mstheme-->
Cartwright & Associates, Inc. PRESIDENT & CONSULTANT
Mesa, Arizona
Portland, Oregon
Formed in 1990, Cartwright and Associates, Inc. has been providing Project Management, Programming, and Consulting to both very large companies utilizing the IBM iSeries and to smaller companies needing Accounting and Web help. The AS400 / iSeries has been a very large portion of our business. Supporting small businesses in setting up their accounting and helping to develop their Web sites has also been important to us.
My primary job has been to manage the overall business and to provide consulting services to our iSeries customers. I work at the customer’s sites providing Project Support / Management, Programming, Analysis, Design, and product installation. I have also been involved in setting up training for the iSeries Applications, and with Web Development for some of our smaller clients.
WORK HISTORY:
Charming Shops / Crosstown Traders Senior Analyst / Programmer
Tucson. Arizona
June 2006 to December 2007
Crosstown Traders and Arizona Mail Order is a direct marketer of women's apparel, footwear, accessories and specialty gifts headquartered in Tucson, Arizona. Crosstown was acquired by Charming Shoppes, Inc., Pennsylvania, shortly before I began my contract. My first project was to analyze the requirements needed to convert their existing Credit system to the new Charming Shoppes credit system. This included re-writing many existing programs, adding procedures to service programs, modifying the Order Processing programs, documentation and installation of new programs. I thus became the primary consultant for the Credit group. The bulk of my work has been working Credit applications and working with the team to convert the programs to become PCI compliant (tokenization and encryption / decryption of existing and new credit card numbers using custom tokenization code and Protegrety encryption software).
Rural Metro Corporation Senior Analyst / Programmer
Scottsdale, Arizona
June 2005 to November 2005
Designed and maintained applications for Rural’s Medical Accounting. All programming was done using Synon 2E and CLP. My primary responsibility was the support for Ambulance Billing and Invoicing.
Computer Guidance Corporation Senior Analyst / Programmer
Scottsdale, Arizona
July 2003 to June 2005
Analyst and Programmer for Computer Guidance (CGC). CGC is a software company providing the nations leading iSeries Construction software to customers throughout the U.S. and Canada. My responsibilities were to support existing applications and develop new ILE software for new Construction applications. A large part of my work was to rewrite many of the exiting applications to work as the iSeries business logic for CGC’s new web based product. This includes creating new ILE programs using embedded SQL. The new design utilized the latest ILE coding techniques with both free form and formatted RPG. Working with a new technical team at CGC, I develop new service programs and ILE procedures accessing SQL tables. My primary areas of focus were Accounts Receivable, Time and Materials, and Construction Accounting.
Honeywell Hardware Products Group Senior Analyst / Programmer
Tempe, Arizona
June 2001 – June 2002
BPCS Maintenance and Production Support
Honeywell's Hardware Products Group selected BPCS as the primary application for Manufacturing, Order Processing, Accounting, DRP, EDI, and most of the other area's within the group. I managed the support queue and provided production support for all areas within the HPG support team. The primary platform is the AS400 using RPG III, IV, and ILE. My job included technical analysis, programming, support queue management, and 24 hour production support for divisions throughout the world.
Columbia Management Co. Consultant and Programmer / Analyst
Portland, Oregon
February 1998 – March 1999
March 2000 - June 2001
Columbia Management Co. is one of Oregon’s most successful mutual fund investment companies. My responsibilities included analysis of current systems relating to Y2K compliance, support for existing applications, project manager for new or changing applications, and programming using RPG IV and ILE. Major accomplishments include analysis and programming for Columbia’s Y2K compliance project, project manager and analyst for Columbia’s Profile 2.0 application which provides PC useable information to Columbia’s third party fund managers, and programming support as required. My associations included working with management as well as end users. Ongoing projects included major modifications to the Trust Accounting and Fund Operations.
Menlo Logistics Programmer / Analyst / Support
Portland, Oregon
March 1999 – March 2000
Menlo Logistics is full service contract Logistics Company specializing in product transportation, storage, and distribution, for commercial and industrial enterprises. As a consultant with Menlo, I have worked to analyze and program applications on the AS400 using ILE concepts for Menlo’s Order Management System Group. Related activities include interfacing with the EDI, Transportation Management and WEB groups. My assignments have included problem resolution for existing clients, new product development and Analysis for new client interfaces.
Willamette Industries, Inc. Project Manager and Programmer / Analyst
Portland, Oregon
October 1992 – February 1998
Consultant for the Building Materials Group RIM (Revenue Information Management) Project Team. The RIM team was responsible for implementing and adapting Andersen’s MacPac applications and developing new applications to meet the unique and demanding requirements of the forest and lumber products industry.