iSeries (AS/400) RPG/SQL Software Developer

Adam G. Freitas

Skills:

RPG: II, II ½, III, **0, IV ILE, fixed or free format, Visual Age RPG, COBOL, CL, DDS, DDL, Imbedded and Interactive SQL, triggers, modular design, service programs, stored procedures, and user-defined functions, binding directories, APIs, Query/400, and DB2/400. Experience with Distribution and Retail systems, Strong Experience working with JDA/MMS Merchandising Software and Manhattan Associates PKMS and WMS for i-Series Warehouse Management Software, SEU, RSE, WDSc, RDI, PDM, SDA, RLU, DBU, FEU, ROBOT,Ops/iSeries Navigator, IFS, Word, Excel, Access, PowerPoint, Front Page, Lotus Notes, SharePoint, Client Access, Rumba, Hawkeye, Abstract, MKS Implementer (Application Lifecycle Management), Aldon Change Management Software/Community Manager, Soft Landing's TurnOver--Change Management, Crystal Reports, Visio, Project, TrackIt!, Unit Testing and Scripts, QA and EUA testing and remediation, Seagull Software’s LegaSuite for iSeries. Extensive experience in Financial and Transaction Services, leveraging technical expertise and operations, credit card and ACH check payment processing, EDI processing and EDI ANSI X12 syntax, data mapping using Vector Connexion EDI translator, VAN processing, ISO-9000/9001:2000, PCI DSS and Sarbanes-Oxley Act of 2002 (SOX) implementations/compliance/readiness, ADP payroll -- interfacing/data mapping, Biometric/Kronos Payroll and Time & Attendance Solutions for Windows & iSeries. PERL CGI Scripting (E-Commerce/Website Shopping Carts, local Search Engines, Mail Forms, etc.), HTML, XML, Flash, BugZilla from Mozilla (open source tool for Software Development projects). Experience with MAPICS, BPCS, and Manufacturing. Object-oriented programming and event-driven programming, ERP and SOA processes, client/server applications, FTP, FTPS, SSL, Smalltalk, JAVA, Visual Basic, ASP.NET, .NET, C, C+, C++, C#, HTML, XML, SYNON 2E/COOL 2E CASE ARAD Tool, WDSc, and WebSphere.

Professional Experience:

Integrity Solutions, LLC – Software Development Ledyard, CT 2000 - current

AS/400 RPG ILE / SQL Programmer/Business Analyst/Consultant

Services Provided or Deliverables:

• Improved procedures and programs

• Streamlined operations

• Eliminated redundancies

• Utilized advanced but proven technologies

• Provided detailed but comprehensible documentation

• Established data integrity and security

• Increased productivity and efficiency

Clients/Contract Assignments:

For nearly every contract position

• Developed/Enhanced CLP, RPG III, RPG/ILE programs, Queries on AS/400 iSeries platform.

• Utilized extensive experience with and knowledge of the AS/400 iSeries OS, DBU, FEU, ROBOT, Client Access, Hawkeye, Aldon or TurnOver Change Management software.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

Arthur Murray Dance Studios [Education], Niantic, CT/Glastonbury, CT/etc. 09/08 - current

• Developed customized Visual Basic software system to process claims, schedule appointments, track clients, accounts receivable, and generate various reports to better manage business.

• Removed references from client’s old website to their new website, including client’s new physical address, telephone and fax numbers, etc.

• Implemented search engine optimization to improve the volume or quality of traffic to the client’s web site from search engines via "natural" ("organic" or "algorithmic") search results.

Chefs’ Warehouse/Dairyland USA. [Wholesale/Distribution] Bronx, NY 05/08 – 08/08

• Worked as a Data & Programmer Analyst for ERP JDE EnterpriseOne implementation.

• Cleansed, converted, mapped, & migrated data from AS/400 to JDE EnterpriseOne.

• Developed new Commission Calculator for Sales Force.

• Developed new Physical Inventory/Cycle Count System/Process [multi-warehouse].

• Developed conversion and population programs to support TrackMax [SQL] application.

• Implemented the utilization of the UPS Roadnet Logistics Fleet Management software.

• Resolved AS/400 and JDE-related production issues during transition.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

Welcome Wagon, Inc. [Marketing] Plainview, NY 07/07 – 03/08

• Worked as a BA (Business Analyst) and with other BAs configuring the Kronos applications.

• Created/Maintained programs related to Kronos reports and interfaces between Kronos, J.D. Edwards' OneWorld, WorldSoftware human resources, payroll applications, and ADP/ProBusiness payroll systems).

• Supported and configured Kronos iSeries application and modules (Attendance, Timekeeper, Gatekeeper, Accruals, History, and Shop Floor electronic data collection system).

• Coordinated support and configuration of time clocks with hardware/project teams.

• Configured and provided on-going support for Ethernet-based timekeeping clocks as required.

• Trained and assisted staff in re: to Kronos time clock and application usage and troubleshooting.

• Developed flowcharts, diagrams, and technical documentation for WW Contract Entry Systems (one written in JAVA to support their PinPoint product line and the other in Visual Age RPG to support their Book product line).

• Developed/Modified new Contract Entry applications using Visual Basic.

• Developed SQL Stored Procedures for validating DB/2 data prior to Commission System tables update and User-Defined Functions (UDFs) to return various item values to RPG/ILE programs.

• Fixed and enhanced Electronic Check and Credit Card Processing applications, EDI interfaces and processing, translators, and data mapping, testing before programs moved to Production.

• Automated report distribution via PDF attachments to email recipient addresses.

• Supported and provided training to the Graphics Art Department in the creation of PhotoShop, QuarkExpress, Illustrator, Freehand, Flash, and PDF documents.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

Christmas Tree Shops, Bed, Bath & Beyond [Retail/Distribution] S. Yarmouth, MA 08/06 - 03/07

• Business and Programmer Analyst - assisted w/ ERP, WM, PKMS, & Kronos implementation.

• Developed/Modified RPG/ILE programs to support multi-cdw (company, division, and warehouse) transactions for system-wide software at CTS/BBB (Christmas Tree Shops/Bed, Bath & Beyond).

• Quality Assurance Lead - developed testing requirements/criteria, and document revisions due to changes of approach, coding details, or underlying database structure.

• Automated report distribution via PDF attachments to email recipient addresses.

• Developed “Not Scanned” reports for Assortments, Groups, and Sets. These were once 3 distinct QM query reports that were executed manually, as needed. They were replaced with 1 SQLRPGLE program that was added to ROBOT for an automatic, weekly run.

• Developed new “Set/Components Listing” (CTS IPS132 -> BBB MIR3132) using MIPSET & JDA INV* (INVMST, INVBAL, etc.) replacement data sources. The program was completely re-written in ILE free, retired on the CTS AS/400 in MA and transferred to the BBB AS/400 in NJ.

• Enhanced “Set Maintenance” program - eliminate legacy files, utilize WM files, add CMZ120,130,150,160,170 external calls to retrieve WM data, acquire/update the inventory master JDA file INVMST, and incorporate data area toggle.

• Enhanced “Assortment Maintenance” program - eliminate legacy files, utilize WM files, add CMZ120,130,150,160,170 external calls to retrieve WM data, acquire/update the inventory master JDA file INVMST, and incorporate data area toggle.

• Enhanced “Cube Audit” query – add warehouse field to report. The database file “driving” this was missed during the 1st round of DDS changes - add warehouse field, recompile DDS, reload the database file from saved copy, and load field CAWHSE with "MID".

• Enhanced “Store Damage Polling” process - eliminate legacy files, modify programs SP0071 & SP0170 to incorporate data area toggle.

• Enhanced “Selected Buyer” reports (by Vendor) -- Increase total number of stores limit from 40 to 55. This was a one-shot program and only a temporary fix until legacy disconnect. New program will then take over.

• Developed SQLRPGLE programs to perform Department/Sub-Department Resynchronization.

• Developed “Warehouse Inventory” report (to replace the Store Supplies in DC Impromptu). The report allows for selected/all categories and warehouses.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

Vantage Deluxe World Travel [Travel] Boston, MA 02/06 - 05/06

• Developed RPG ILE programs and display formats to provide functionality and support for almost 90 web page wire frames by populating the website’s presentation layer with existing data from the client’s AS/400 databases.

• Developed and maintained credit card and ACH check payment processing applications, EDI interfaces and processing involving EDI ANSI X12 syntax, translators, and data mapping.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

Canberra Industries, Inc. [Manufacturing] Meriden, CT 12/05 - 02/06

• Enhanced Contract Billing System (purchased/leased equipment and maintenance) via RPG/ILE.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

Constitution Mortgage [Banking/Financial Services] Cheshire, CT 03/02 - 11/05

• Developed new internal risk review and audit protocol for cash collateral management.

• Developed quantitative mortgage models for proper estimating.

• Developed mortgage analytics systems.

• Developed and maintained risk systems/reports for company strategy.

• Developed and maintained a web site that allows full control over mortgage loan processing; data manipulation, report generation, and user administration.

Cooper Crouse-Hinds, Inc. [Manufacturing] S. Windsor, CT 12/01 - 02/02

• Provided migration support of AS/400 database and configured Kronos information to SQL database prior to legacy system retirement.

• All new development was done in RPG IV ILE free-form utilizing embedded SQL, if appropriate. The majority of the applications were written as smaller, single-function compiled units, in a modular approach (i.e. service programs & procedure prototypes),and bound to the programs that needed them, thus eliminating duplicate code and making for easier application maintenance.

White Flower Farm, Inc. [Wholesale/Distribution] Torrington, CT 11/99 – 09/01

• Developed and enhanced AS/400 RPG applications to support Kronos and JD Edwards OneWorld implementation and developed interfaces between the two as well as the ADP Payroll software.

• Responsible for all electronic orders and communications including web, EDI, and B2B interfaces.

Garland Publishing, Hamden, CT • NYC, NY 07/94 – 11/99

Manager of Operations and Information Systems

AS400 RPG/COBOL Programmer/Analyst/Developer

B2B and e-commerce developer (Web and EDI Applications)

Schaffer Foodservice, Waterbury, CT • New Rochelle, NY 08/85 – 06/93

S/34, S/36, S/38 RPG Programmer/Analyst/Developer

Remote Ordering Developer (EDI, MCI/Symbol Handheld Devices and Applications)

Data Processing & A/R Manager

Programming Certifications:

IBM RPG II

IBM RPG III

IBM RPG IV ILE

IBM CL

IBM RPG Programming Concepts and Designs

IBM RPG Programming Fundamentals

University Of Hartford – C Programming

Contact this candidate