AS400 RPGILE Software Developer

Joe McDonald

Support includes client and server development on the IBM i using

RPG IV ILE and DB2 SQL.

Linkedin http://www.linkedin.com/pub/joe-mcdonald/24/387/624 Contact: 713-***-**** **@**-*********.***

SUMMARY OF EXPERIENCE

Experience in the area of Information Technology as a Developer, Designer, Analyst, and Leader.

Involved in all phases of project life cycle from Systems Analysis, Design & Development through Testing and Implementation.

Expertise in business analysis, offer outstanding talents in project planning & tracking, maintaining customer relationship, resource planning and team building

Extensive experience in Test Planning, Test cases Preparation and Execution, Bug tracking and status reporting.

Lead collaboration with business analysts, and users to understand requirements and to facilitate UAT and effective implementation of requirements.

Participate in requirements and design review meetings

Understand the client systems and processes and aid in preparation of system maintenance and technical document and involve in knowledge transition and mentoring team IBM i RPGILE

Software Developer on the i5/OS using RPG IV ILE. Methodologies include specializing in the relational data base design and full program life cycle development for various business models. Modular design approach includes using ILE service programs and Binding by reference.

IBM DB2 / MS SQL Server 2005

Develop and deploy DB2 SQL back-end procedures and functions on the iSeries. Create vb.NET and T-SQL procedures to work as a front-end applicant for the Series using OLE and .net iSeries providers. DB2/400 Data Base Administrator

Worked independently as a system data base administrator using the change management tool TurnOver. Responsibility include providing solution for the program development department with DB2/400 related issues pertaining to Journaling, COMMIT, ROLLBACK, audit trail, DDM, Trigger, Data Dictionary, LF/PF, Normalization and join files.

Web Developer and e-Commerces Strategist

In addition to IBM i5/OS software development I have extensive experience working as a web developer and e-commerce strategist for small business in the Houston demographic area. The web programming involves using open source tools such as PHP5, MySQL and Apache. All projects include - obtain and set up user domain and if required deploy SSL certificate. Database design, application design, site architecture design, CSS, Javascript, XML and HTML programming to meet client validation requirements. All developed web sites include comprehensive graphical site statistics. The special area embedded into the existing website design allows the client to view collected data in tabulated and graphics form about the visitor's that roam the site.

Visual Basic 6.0

Technology support includes front end web-enable and web-aware components to accept information uploaded to the AS/400. Incorporate extensive use of Encapsulation of API calls, Active-X controls and ADO 2.6. Additional VB 6.0 support includes VBA tools to develop programs and modules to interface with MS components such as Word applications and Outlook Mail.

SKILLS AND TOOLS

Language/skills implemented

RPG IV ILE, embedded-SQL, CL, Query 400, ILE Service/Module, T-SQL, VB6, JDBC, Java, PHP Data Base Management / Tools

DB2 SQL, MySql, SQL Server 2005-2009, Access

Program and Change Management Tools and EDI

WDSC, RDi, Data Studio, Access Client Solutions (ACS) Client Access, Hawkeye, eSend, ROBOT, DBU, NetBeans 7.1, Eclipse, Turnover and Aldon

ERP

Accounting Plus, PRISM, MAPICS/Infor

SAMPLE PROJECT SUMMARY

Bank of America Plano, Texas 12/2016 - Present

Role: i5/OS RPG IV ILE Software Developer

Industry: Financial and Banking

Software development supporting backend service applications using services programs, stored procedures and functions developed as both RPGILE and SQL based applications for .net web services for Countrywide mortgage & loans. Additional support involves EDI and FTP feed applications for various business partners working remotely with offshore team. Oceanic Time Warner Cable Oahu, Hawaii 7/2015 - 12/2016 Role: i5/OS RPG IV ILE Software Developer

Industry: Mass Media - Internet, publishing, film, telecommunications and television Time Warner Cable is a second largest cable/telecommunication provider. They use TWC billing system on AS400 for customer billing. As a RPGILE software developer, responsibilities include:

- Participate in business requirements meetings and analyze the requirements and gain good knowledge of the application from both technical and business perspectives.

- Prepare technical specifications documents and mapping documents to help development

- Participate in test planning meetings and arrive at test strategy to create test cases and scenarios from requirements. Involve in the development of the detailed test plan and test cases for system testing, - -

- Integration testing and regression testing.

- Co-ordinate with users to create test cases for UAT.

- Executed test cases/scenarios, documented results and generated reports.

- Analyze and troubleshoot the defects to isolate the likely cause of the problem

- Develop programs using RPG Free, Embedded SQL and CLLE

- Develop reports using WRKQRY or write SQL queries to verify the data Hewlett Packard Houston, Texas 2/2015 – 7/2015

Role: i5/OS RPG IV ILE Software Developer

Industry: Manufacturing.

Provide the following support for HP’s VISTA, FTP Feeds and Interlocks on the IBM iSeries platform using RPGILE and DB2/400 Vista Separation Program

VISTA

• Research sFTP, FTP, ODBC and mapping on each VISTA asset.

• Feed Analysis for the Interlock asset feed/data requirements

• Implement sFTP and FTP scripts with modifications to RPGLE & CLLE source as required to support separation. Interlocking Asset

• Research Interlocking assets split strategy

• Identify and deploy source modification as required for each Interlocking asset Base Utilities and assets used

• Robot IBM-based job scheduler.

• HP WebTools SFTP Webtools utility used to research data feeds on HP Service Bus (HPSB)

• Turnover IBM-based Program Management Tool

• Abstract IBM-based Program Analyst Tool

• HP ALM (Application Life Cycle Management)

• WDSC

Goodman Manufacturing Houston, Texas 7/2007 – 2/2015 Role: i5/OS RPG IV ILE PHP Software Developer and 24/7 On Call Support Industry: Manufacturing.

PHP Cloud Base Development

Developed Cloud based applications based on the RESTful architecture using PHP, HTML5 and Java. The process involved developing PHP applications to handle GET, PUT and POST request using cURL resources. The applications provide update process between COUPA purchase order / invoice system and MAPICS residing on IBM i, AS400. PHP, XML and JDBC was used to complete the update request on the AS400 database.

SQL Server 2005 Development

Develop procedures to communicate between SQL Server and iSeries DB2 tables. This process involved posting and reporting manufacturing orders generated from MAPICS and transferred to the SQL Server for logging. Currently working on web base inquiry for order status residing on the SQL Server. RPGILE CLLE SQL

Provide custom RPGILE development for ERP manufacturing package Infor XA (MAPICS). Developed the following packages to integrate to Infor XA using RPGILE, CLLE and embedded SQL:

- Defective Parts per Million (DPPM)

- Vendor Return

- Fab Schedule

- Weight Scale processing w/barcode support via T.L. ASHFORD JM SOLUTIONS, INC. Houston, Texas 2/2000 - Present Role: Owner and IBM i RPG IV ILE PHP Software Developer Industry: Software Development.

Client: McGuyer Home Builder. Houston, Texas 6/2005 – 7/2007 Project: JDBC Java connection between MS SQL Server and i5/OS Resolve and deploy database connectivity issues with the iSeries and MS SQL server using Java and JDBC. The process involved selectively reading the DB2 database using Java and JDBC and establishing JDBC connection with SQL Server. Client: Community Educational Television, Inc Houston, Texas 3/99- Present Project: Telethon Batch Transaction Manager (TBTM) Benefit: The front end component of the project allowed company to realize a 10% lower cost maintenance on data entry procedures by mapping existing data stored on the AS/400. Data integrity and duplication was also eliminated. Responsible for providing a solution for the development and deployment of a front-end Telethon Batch Transaction Manager (TBTM). The scope of the project included several development tools – PHP, Visual Basic, RPG ILE, Message Handling API’s, SQL and CL. VB programs were designed and created to accept transaction entries using VB and MS Access tables. Data integrity was ensured by accessing DB2/400 using ODBC and SQL/data control implementation. Client FleetPride, Inc. Houston, Texas 10/2002 – 6/2005 Project: Price Control

Benefit: The design of the Price Control system provides for future prices to be loaded prior to the effective date and automatic application of those prices when they become effective. In addition, provides for PO review process on non- match purchase orders and the ability to update cost and/or generate vendor claims. Responsible for design and programming of the company’s new Price Control system. The upgrade is to allow for the timely and automated application of vendor price changes to the inventory and part files. In Addition, allow for the system to maintain the vendors cost for parts for the purpose of purchasing so that process of matching vendor invoices to purchases orders can be automated and reliable. Client: Small Business Houston, Texas 7/2000 - Present Project: e-Commerce, Dynamic and Static Web Development. Role: Web Developer and e-Commerce Strategist

Industry: Web Site Software Development.

In addition to IBM i5/OS software development I have extensive experience working as a web developer and e- commerce strategist for small business in the Houston demographic area. The web programming involves using open source tools such as PHP5, MySQL and Apache.

Client: Vitelco Telcom St. Thomas, U.S.V.I. 2/00 – 12/00 Project: Point of Sales TFS/ICMS

Role: AS/400 RPG IV ILE Developer/ Independent Consultant Industry: Utility -Telephone Communication (St. Thomas USVI) Benefit: The POS conversion allow the company to be independent of the old software by providing a front end module integrated to the new ICMS package. In addition, customer satisfaction increased by providing customers additional account information. AS/400 RPG IV program and data base development working independently on ICMS telecommunication. Support consist of providing a solution for migrating the current TFS Point-of-Sales component to the ICMS package on the AS/400. In addition to providing a solution to the POS, additional modules integrated include Cash Entry post, End of Day procedure and Automated Account Transfer Facility. BAKER HUGHES Houston, Texas 8/98 – 2/00

Project: Prism Support

Role: AS/400 RPG IV ILE Developer

Industry: Oil/Gas Manufacturing (Houston, TX)

Benefit: Provide company support with technical documentation standards and in-house custom modifications MS Project was used to identify related activities directed towards the scope of the projects.Several reports and enhanced functionality led to increased production by 10% and provided the user a more reliable and stable platform - leading to increased user and customer satisfaction. Modify existing code to support on-going interfaces. Maintain and develop core system programming and technical documentation standards. Interface modifications between company and client using RPG IV ILE & Prism and JDE extract/mapping of A/R, A/P files to interface transmission for MQSeries. SYSCO Houston, Texas 3/97 - 3/98

Project: Data Base Administrator

Role: Data Base Administrator DB2/400

Industry: Food Service/Distributor (Houston, TX)

Benefit: The DMU utilities provide data base administrator and tech-support to make informative and analytic decision based on the statistic information. Several time consuming task have been automated which contributed to faster and a more reliable deployment. Provide technical support and development as a Database Administrator for major corporate project initiatives on the AS400 platform using Turnover. Maintain and enforce the Change Control methodologies to provide a consistent and secure transition from development to production

IBM GLOBAL SERVICES Houston, Texas 7/94 - 3/97

Project: ICMS Integrated Customer Management System Role: AS/400 RPG IV ILE Project Management / Technical Lead Industry: Utility -Telephone Communication (Houston, TX – New Zealand) Benefit: The new modules allows increased functionality by supporting API system information and Prototyped calls in RPG ILE for IBM’s ICMS Telcom software package. Responsible for the full life cycle application development methodology and production support processes. Provide senior level support in the form of project management/ leader, analysis, design and implementation of software solutions for IBM telephone cost management system –ICMS. Cellular -Telephone Cost Management (Wireless Module- GSM) - Technical Programmer Participate with IBM New Zealand development team to create a Cellular Telephone Cost Management System supporting Type-1 and Type-2 Cellular Networks to integrate with IBM ICMS package version 3.0. Call Sort Billing - Project Leader / Technical Programmer Provide solution, documentation and programming for ICMS 3.3 Account Code Sort Billing statement module. Results provide user flexibility to generate custom pre-sorted monthly statement of accounts related to account code department and location.

Installment & Leasing - Project Leader / Technical Programmer Led system analysts, developers and technical support team for creating the Installment and Leasing component to integrate with the existing IBM/TFS System. Package will be incorporated IBM new release version 3.1 of TFS for North America.

Soft Code Literal Module - Technical Programmer

Provide program support and analysis for the introduction of the Soft Code Literal component related to Franchise, Regional and Division ID.

EQUIFAX Houston, Texas 5/82 - 7/94

Project: Automated Transfer Facility System (ATFS) Role: System 38, AS/400 RPG /Project Leader / Technical Programmer Industry: Financial –Collection / Credit Cards

Benefit: The successful completion of the AMEX project awarded client a $14 million annual contract with American Express. Daily technical support allowed company to stay ahead of its competition, ranking company as the third collection agency in the industry. The process enhanced data integrity, control and provide better user support for clients assigned to company related to the transfer of financial business transaction between company and client. Designed and programmed the communication software to interface with the specification provided by AMEX for the above GFT application protocol on the AS/400 using RPG IV and ILE. Responsible for the design and programming of the communication interface package to electronically transfer transaction, bi- directional, for selected vendors such as AT&T, Citicorp, American Express and Chemical Bank. Install the RMS BT/Tymnent Menu System that provides a common interface for company and Associates National Bank via PC. The process allows company to receive new placements, payments and updates and send updates/payments electronically or by tape.

EDUCATION

University of Houston 1975 – 1977 Houston, TX (open )

Computer Science & Mathematics

Studied Cobol, Assembly and Fortran programming, Computer Architecture

Houston Community College 1974 -1975 Houston, TX

Web Developer and e-Commerce Strategist

Technology support includes client and server development PHP 5, mySQL, Apache and VB 6

In addition to IBM i5/OS software development I have extensive experience working as a web developer and e-commerce strategist for small business in the Houston demographic area. The web programming involves using open source tools such as PHP5, MySQL and Apache. All projects include - obtain and set up user domain and if required deploy SSL certificate. Database design, application design, site architecture design, CSS, Javascript and HTML programming to meet client validation requirements. All developed web sites include comprehensive graphical site statistics. The special area embedded into the existing website design allows the client to view collected data in tabulated and graphics form about the visitor's that roam the site. Web Technologies:

PHP 4/5 MySQL SQL HTML / XML JavaScript CSS FreeBSD BPFTP Server Apache Web Server Argo mail server Subversion Version Control Source Safe Microsoft Access Simple DNS Web based e-mail

(ArgoSoft and UebiMiau!)

Web Applications:

Zend Studio Eclipse Homesite Microsoft Visio Microsoft Project Adobe Photoshop JM Solutions, Inc. 5/2000 - Present

Role: Web Developer and e-Commerce Strategist

Industry: Web Site Software Development.

iPhone PHP Web App Designed exclusively for iPhone. Visit this website, http://www.lrtj.com/, as advertised on Roule & Ryan 104.1 KRBE on your iPhone to receive the latest news for all freeway traffic jams in the Houston area. View live cam and incidents reports 24/7 harvest from Houston Transtar - one of the nation’s best internet destinations for providing travelers with the most useful and up-to-date information on road and traffic conditions. You can also use the live cam report to view current weather conditions as it happens. Treo 650 PDA Website http://www.jm-solutions.com/PDA/Treo/index.php Developed a traffic report website, "Live Report Traffic Jam" exclusively for the Treo 650/700. The project will allow a web enable PDA device such as the Treo to receive the latest news for all freeway traffic jams in the Houston area. Web users will be able to view live cam and incidents reports 24 hours a day. The development project required the deployment of PHP5, mySQL, HTML, CSS, Apache Server, Adobe Photoshop and Javascript. Best Vanilla http://www.bestvanilla.com/catalog/

An online shop e-commerce solution for selling Watkins products. The project includes handing credit card transactions and provides and administration tool backend to allow product and catalog maintenance. The development project required the maintenance of open source oscommerce and deployment of PHP5, mySQL, HTML, CSS, Apache Server, Adobe Photoshop and Javascript. Southern Conference On African American Studies, Inc. http://www.scaasi.org/Introduction/introduction.php This web site helps require the objective of Texas Southern University to bring together persons from across the State of Texas who were interested in interpreting and preserving African American history and culture. The site includes a PHP5 developed search engine and a backend utility maintenance procedure to allow user maintenance for ongoing events, publications and white papers announcements. The development project required the deployment of PHP5, mySQL, HTML, CSS, Apache Server, Adobe Photoshop and Java script. Ameritec Maritime Consultants http://www.ameritec.us/Introduction/introduction.php Static Web site for consultant describing vendor services for the Shipping Industry with over twenty-five years of maritime experience. The extensive technical knowledge and expertise gained during this time coupled with a strong commitment to meet and exceed our customers needs, is the reason for our success. Griot Calenda http://www.griotcalendar.org/Introduction/introduction.php The Griot Calendar is a calendar sales brochure that represents persons and activities related to specific dates in African American History. The information is such as one would find in a souvenir booklet/program. The site uses mySQL to allow interactive day by day historical information of main events derived from the calendar database. Keyboarding and Word Processing http://www.keyboarding1.org/keyboarding/Introduction/introduction.php Dynamic and self maintain website developed for the Keyboarding department at Pershing Middle school. The website includes an administrator area that allows user input to create and maintain lesson plans. JobCrawler (shareware product) http://www.jm-solutions.com/JobCrawler/Introduction/index.php An automated job search facility developed in Visual Basic 6. The product allows web scraping of the popular job boards such as Monster and Dice. The design allows the user to visit selected sites and purge the information into one centralized location. The user has the capability to audit, track, manage and save real job opportunities posted on the web.

Contact this candidate