Strengths:

Highly experienced IT professional with over 20 years of experience business application development on iSeries (aka AS400).

Strong team player who can fulfill any number of different roles such as Business Analyst, Systems Analyst, Lead Developer, QA Tester, or Project Manager depending on the specific project needs.

Equally comfortable working with business users as well as business and IT leadership.

Well versed in the full SDLC in both a traditional waterfall and Agile development methodology environments.

A passion for quality and efficiency and leverage my strong analytical skills to perform defect root cause analysis and removal.

Extensive background in a wide variety of industries and application systems through a 15 year career as an independent consultant/contractor. For that reason, learning new concepts and applications comes with a much shorter learning curve.

Accomplishments:

Contracted with a transportation company to develop a new Automated EDI automatic Order Release system that was able to improve their scorecard with Amazon resulting in an increase to their bottom line of over $4M per year.

Designed and developed security system for user program access and functional rights within each program.

Modified Reinsurance app to deliver reports via Excel and eliminate 100,000 pages of hardcopy reports annually.

Created Reconciliation system to replace 65 reports with a single Excel report for each analyst saving 100 man-hours per month.

Provided consulting service for Fortune 100 & 500 companies for Manufacturing, Distribution, and Financial industries..

Created application interfaces to MAPICS for Order Entry, Invoicing, and Piecework Payroll.

Provided onsite support for small banks & thrifts in Western US for Jack Henry software package distributor.

Developed data extract (ETL) using COBOL/400 to XML text file interfaced to client Quarterly State Tax forms application.

Received Service Recognition Award and bonus for contract Project Lead efforts on Honeywell business acquisition project.

Work Experience:

6/21-2/23

Principal Consultant

iSeries Application Development LLC, The Villages FL

Independent consultant and contract systems developer supporting former employer on an hourly basis. Performing remote business application systems design and development, database design, QA Testing, and general IT consulting services on iSeries (aka AS/400) . Tools included RPG/400, RPG-ILE, RPG-Free, CL-ILE, DB2/400, DDS, SDA, PDM, RDi, DBU, DFU, SQL/400, SEQUEL, ABSTRACT, Hawkeye, Community Manager, and Aldon LMI under Agile methodology..

Contract clients have included:

06/21-pres. Knight Transportation, Phoenix, AZ (Sr. Programmer for Trailer Tracking applications).

5/19-6/21

I-Series Application Developer

Knight Transportation Inc., Phoenix AZ

I supported the A/R, Claims, Rating, EDI, Billing, and National Accounts groups with enhancements and bug fixes for one of the nation’s largest freight carriers. In the course of completing projects, I leveraged RPG/400, RPG-ILE and RPG-Free, CL/400, SEQUEL and interactive SQL, DB2/400, PDM, DDS, SDA, Aldon LMI, ABSTRACT, and Manage Engine.

4/13 to 5/19

Contract Developer

Sunset Software Solutions LLC, The Villages FL

Independent consultant and contract systems developer supporting various clients on a project or hourly basis. Performed onsite and remote business application systems design and development, database design, QA Testing, and general IT consulting services on iSeries (aka AS/400). Tools included RPG/400, RPG-ILE, RPG-Free, CL-ILE, DB2/400, PDM, DDS, SDA, DBU, DFU, SQL/400, Hawkeye, and Aldon CMS.

Contract clients have included:

04/13-5/19 Knight Transportation, Scottsdale, AZ (Sr. Programmer./Analyst for EDI applications).

2/07-7/16

Specialist – IT Application Development

Business Intelligence Group

Nationwide Insurance Company

Excess & Surplus Division, Scottsdale AZ

I supported Finance, Claims, Reinsurance, Regulatory Compliance, and Legal groups with ad hoc reports, data feeds, and small production projects using ASC Sequel and Viewpoint views and reports against their WINS system and month-end summary files for this $3B Excess & Surplus lines subsidiary of Nationwide Insurance. In the course of completing projects, I also leveraged RPG/400, CL/400, Interactive SQL, COBOL/400, DB2/400, PDM, DDS, SDA, Aldon CMS, HEAT Alert Monitor, HP ServiceCenter, Rational Team Concert (RTC), Robot, and Hawkeye.

Learned Business Objects and started using it to create web-based custom views and reports from databases (universes) designed and developed in consort with the DBA.

Performed ETL functions to extract data AS/400 data and format for other applications like BO and Portal Teams.

IT division realigned to Standing Teams and Agile Development methodology in 2012.

9/96 to 2/07

Principal Consultant/President

Application Software Solutions Inc., Tucson AZ

Independent consultant and contract systems developer supporting various clients on a project or hourly basis. Perform onsite and remote project management, business application systems design and development, database design, production support of legacy systems, QA Testing and general IT consulting services on AS/400. Tools include RPG III/400, RPG/IV, COBOL/400, DB2/400, SQL/400 (interactive and embedded), CL/400, ILE, PDM, DDS, SDA, DBU, DFU, Query/400, Robot, Sequel, Hawkeye, TOTAL, Turnover, Aldon’s CMS and Harmonizer.

Contract clients, either direct or sub-contract, have included:

04/06-02/07 Assurant/Reliable Insurance, Scottsdale, AZ (Sr. Programmer/Analyst)

04/05-03/06 ServiceMaster/TruGreen-ChemLawn, Memphis TN (Project Manager & Sr. Prog/Anal)

02/05-04/05 Independent Health, Buffalo NY (Sr. Programmer/Analyst)

03/03-08/04 Discount Tire, Scottsdale AZ (Lead Designer, Project Manager & Sr. Prog/Anal).

01/02-09/02 Intuit, Reno NV (Sr. Programmer/Analyst)

05/99-12/01 National Century Financial Enterprises, Columbus OH – (Lead Designer & Sr.P/A)

04/99-09/99 Pinnacle Technology Resources, Scottsdale AZ (Subcontractor & Sr. Prog/Anal)

11/97-03/99 Honeywell/ Allied Signal, Chandler AZ (Sr. Programmer/Analyst, Project Leader)

09/96-11/97 American Express Travel, Phoenix AZ (Sr. Programmer/Analyst)

1/95 to 8/96

Product Analyst

Avalon Software Inc., Tucson AZ

Worked with customer focus groups as application specialist in Distribution and Financials to develop functional requirements for automotive industry Supply Chain module (EDI Suite) for software vendor in a 4GL/Unix environment.

Wrote Test Plans and Use Cases to insure application programs satisfied user requirements.

Developed logical designs using Sybase CASE data modeling methodology in Deft on Macintosh.

Was responsible for estimating, scheduling and managing projects for customer modifications.

Designed display and report formats using Deft Forms Editor.

Led A/P development team to design and implement application rewrite under Sybase.

Coordinated testing and training with QA, Customer Service and key customers for conversion from Sybase to Oracle O/S.

Wrote SQR reports to satisfy A/P and A/R functional requirements.

Participated in Requirement Definition reviews to insure application functionality for improvement of product marketability.

Participated in re-engineering development process for ISO-9000 standards while improving product quality & cycle time.

Served on core management team to review non-systems internal processes for streamlining processes culture.

5/90 to 12/94

Sr. Systems Analyst/Programmer

Allergan, Irvine CA

Started on 6 month contract-to-hire and converted to FTE after 3 months.

Performed application support on BPCS for Worldwide Manufacturing operations of Fortune 100 pharmaceuticals manufacturer on multiple remote System/36s and AS/400s communicating via RJE and EDI with 3084 Mainframe (for Order Management, Invoicing and General Ledger) utilizing OS/MVS, JCL, TSO, and RJE.

Designed & developed software mods per user requirements on System/36 using RPG II, SEU, OCL, POP and on AS/400 using RPG/400, PDM, SDA, CL, and DBU.

Led team for conversion of hardware, software, and data from System/36 to AS/400 version of BPCS INV & DST modules.

Graduated from Crosby-based Quality Education System (QES) training.

Administered IS QA function to insure QIP for zero defects, conformance to standards, and root cause analysis and removal.

Participated in gathering functional requirements enhancement for K-Mart/WalMart JIT “Quick Response” project to receive POS sales or inventory levels via EDI and automatically generate shipments to replenish store inventories.

Transferred to Surgical Optics division. Performed production support on their CA-PRMS ERP system (O/E, EDI to M/F Invoicing, MRP, MPS, SFC, I/M, and DRP modules) utilizing RPG/400.

Evaluated & implemented laser-based CD-ROM system for report archive & retrieval that interfaced with AS400.

Education & Training:

2013

MicroStrategy

MicroStrategy Web for Professionals (WebPro), Reporters & Analysts (Web RA), and Web Essentials

2007

Infosol

BusinessObjects XI R2 – Universe Design, Basic & Advanced Report Design

2002

PeopleSoft

PeopleTools 8.4 (Essentials & Enterprise) and Foundation (Financials 8.4)

2000

M2I

Extend/2000 Database Expansion & Conversion Tool

1999

M2I

Assist/2000 Year 2000 Remediation Tool

1998

Aldon

Change Management System (CMS)

1997

Soft Landing

Turnover Project and Change Management

1993

Sterling Software

Basic EDI, Team EDI, Gentran/400, EDI Implementation, EDI Audit & Control

1993

Allergan

Crosby Quality Education System

1992

Allergan

Joint Application Design (JAD) Facilitator training

1992

Information Mapping

Effective Reports, Proposals & Memos

1992

D. Appleton

Activity & Data Modeling (IDEF)

1991

Pansophic

AS/400 CA-PRMS Cost Accounting

1991

IBM

AS/400 Facilities, Data Base Design & Concepts, CL Programming,

AS/400 System Administration & Control, RPG Interactive Programming

1991

SSA-MISI

AS/400 BPCS Application Product Training (INV, MRP, MPS, SFC, CAP, FOR)

1990

SSA

System/36 BPCS Concepts and Application systems

Contact this candidate