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.
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