OBJECTIVE:

• I am seeking an iSeries software engineer (developer/programmer) position using RPG/Free and RPG - ILE, embedded SQL and SQL stored procedures, and service programs.

PROFESSIONAL EXPERIENCE:

ISeries Analyst/Developer

Confidential, Spotsylvania County, Virginia

Responsibilities:

• Wrote several SQL procedures to assist on file analysis.
• Created documentation for several suites of previously un-documented programs dealing with nightly and yearly uploads to external systems.

iSeries Developer

Confidential, Staffing Belle Vernon, Pennsylvania

Responsibilities:

• These programs were written in RPG/Free with embedded SQL.
• Designed and wrote programs to modify the CL source code programmatically for the menu programs discovered above that will apply the in-house security program to the necessary menu options. This was a gigantic time saver as it automatically changed 287 programs with minimal developer input.
• These programs were written in RPG/Free. Several used SQL for the complete I/O.
• Created RPGLE and RPG/Free programs using embedded SQL for custom reports in the Credit department.
• Worked with the users to fine tune these report to the unique needs of the Credit department.
• Created RPGLE programs for custom reports in the Billing and Sales departments.
• Created RPGLE and RPG/Free programs for custom reports in the Accounting and Tax departments.
• Worked with the users to develop e-file delivery of petroleum tax and user fee reports to various state’s departments of revenue and taxation.
• Performed maintenance modifications to RPGLE programs for various business units.
• Sub-procedures were used on occasion.
• New subroutines were written in RPG/Free when practical.
• Performed maintenance modifications to RPG36 and OCL36 procedures for various business units.
• Planned the ‘decommissioning’ of the iSeries at Guttman Oil scheduled for September 2017.
• The strategy was to lock down the system to prevent users running jobs that change business data while allowing reports and queries to run.
• Wrote the timeline and procedures documentation for the decommissioning.

iSeries Software Engineer

Confidential, Richmond, Virginia

Responsibilities:

• Created and modified RPGLE procedures, service programs and SQL stored procedures for several projects in the Estes Freight Tracking and Bill of Lading system and in the Pickup and Delivery Scheduling system.
• All change management was handled using Turnover to promote programs, files and etc. from development to testing, quality assurance testing then to production.
• Wrote and modified documentation at all levels of development and at the final phase before hand over to the division.
• Worked in Estes IT “Quick Turnaround Team” (projects of 30 days or less).
• This was the Estes variation on AGILE.
• We used some of the Agile techniques such as: small, discrete program projects that interlocked with others; testing as part of development; adapting to changing requirements; daily, but brief, meetings. However; Estes did not implement the full AGILE methodology.
• Worked in Estes IT project development team.
• A more formal ‘waterfall’ approach to SDLC.
• Again with the Estes approach. Example: Developers did the testing all the way to level 3 and usually level 4.
• Worked in Estes IT Application Support section.
• Working with the users to resolve program issues.
• Responding to Help Desk tickets opened by users.

iSeries Developer

Confidential, Simi Valley, California

Responsibilities:

• Created and modified RPGLE programs, procedures and SQL stored procedures for several projects in BOA’s mortgage division.
• Used Turnover to promote programs, files and etc. from development to testing.
• Wrote and modified High Level Documentation (HLD) and Low Level Documentation (LLD) during the design phase of the “Datagram” project.
• Full blown Waterfall SDLC.
• Designed and coded the program from specs that I may have helped the Business Analyst write.
• Coded the program and tested at level 1.
• Handed it over to QA for level 2 testing:
• Clarified any confusion QA may have had about how the program was intended to work.
• Fixed any actual bugs in the program.
• Threw the program over the fence to QA for level 3 and 4 testing and would not see it until it was time to install it.

Programmer/Analyst II

Confidential, Vienna, Virginia

Responsibilities:

• Designed and created custom programs to report and update the JD Edwards A7.3 enterprise software and database.
• Designed and created a suite of programs to automate the nightly saves and the monthly full system saves across the three partitions on the platform. This was in essence a “mini” BRMS.
• Power handling programs to manage the UPS and system shutdown for all three partitions. This included email notification. This may have been my first program written in RPG/Free.
• Upgraded the operating system from i5/OS V5R3 to V5R4.
• Upgraded the operating system from i5/OS V5R4 to V6R1.
• Oversaw the i5 hardware upgrade from a Model to a Model .
• Implemented, in conjunction with our IBM business partner, the partitioning of the new i5 into three LPARS.

iSeries Programmer/Operator

Confidential, Arlington, Virginia

Responsibilities:

• Developed programs in RPG and RPG-ILE for our in-house add-ons to the Lawson software package, called PHA.
• Wrote SQL, RPG-ILE and CL to quickly change data to meet US Department of Labor (DoL) upload requirements.
• Created a set of error checking programs written in SQL for the DoL upload.
• Upgraded the operating system from i5/OS V5R1 to V5R3M5.
• Oversaw the i5 hardware upgrade from a Model to a Model .
• Installed and configured the new Ultrium3 tape drive in the i5.
• Completed the Oracle 8i Database Administration class offered by the TTT program at George Mason University, Fairfax, Virginia, completed June 2002.
• Designed a database and wrote SQL for a web site called HyCue.Com. This web site was geared to the job search market and was expected to be operational early in 2004, but never made it there due to failure of funding.
• Worked as a self-employed “Geek on Call” without, of course, using the Trademarked name.

AS/400 programmer Analyst II

Confidential, IncFalls Church, Virginia

Responsibilities:

• Designed, coded and maintained programs in a multi AS/400 environment.
• Developed, with the Eligibility department, programs to reformat client files and map fields to the standard MHS layout.
• Developed programs in RPG-ILE, COBOL and SQL.
• All programming was managed using the Mortice-Kern Implementer package.

AS/400 Programmer and POS Programming/Support

Confidential, Vienna, Virginia

Responsibilities:

• Developed a suite of programs written in RPG400 to collect daily sales data from the Point-of-Sale (POS) system and produce management reports and summaries. This set of programs also collected payroll data and created files for use by the JD Edwards software package.
• Installed and maintained Micros 2700 and Micros 2800 POS networks in the restaurants.
• Developed programs on the POS system using the proprietary programming language in ReMACS.

System Specialist, IS-5 and IS

Confidential, Washington, DC

Responsibilities:

• Wrote RPG programs to produce reports using Island Pacific files.
• Modified Island Pacific programs and screens to meet user needs.
• Wrote CL programs to automate operations.
• Participated with increasing levels of responsibility in numerous migrations to newer models of the AS/400 and in installing hardware on the AS/400's. This started with our move from the System 38 to an AS/400.
• Installed and upgraded the operating system on the AS/400s.
• Performed saves, restores and IPLs. Configured printers and workstations.
• Installed, configured and upgraded hardware and software on the AS/400.
• Maintained the AS/400 loading PTF's and running system clean-up procedures (a constant job in those days).
• Planned and executed installation of 4680 Point-of-Sale networks at new stores and additional terminals at existing stores.
• Resolved software problems on the 4680 Store Controllers in person and through IBM Remote Operator.