Project Manager Software
Resume:
RAYMOND S. KUCHENBROD
Birdsboro, PA *****
Email: *******@*******.***
SUMMARY:
Over Twelve years of experience as an AS/400 Programmer Analyst
with 14 years total experience in the IT field. Experienced in the
AS/400 environment with expertise in Mapics 6.0,
RPGII/III/IV/400/ILE and Free, CL/400, DB2/400, SQL, Windows
95/NT/XP/Vista, Hawkeye, and the full systems development life
cycle. Good background with analytical, and technical processes.
1 EMPLOYMENT:
Apparel Business Systems, Norristown PA (October 2005 - February 2010)
Programmer Analyst
Environment: AS/400 - I Series, XP, RPG II - IV/ILE, RPG400, RPG Free
Visual Basic 6.0, Visual Basic .Net, Visual Basic for Application,
PHP, XML
. Provided technical support for the Off line Order Entry System (Excel
Based)
. Built Custom Communication code with the use of RPG Free/ILE to create
work files which are then used in CL programs which called PHP code to
generate XML files, which were then transmitted via CL and FTP Scripts.
. Made and tested application changes in all levels of RPG and CL
languages
. Designed and tested modern solutions to current Warehousing issues
RPG ILE/Free to create XML Documents
RPG Programs to monitor IFS directories for XML Documents and then
using CL I created FTP scripts transmit them to to third party
server for processing
Created CL Programs that ran the RPG Monitor program at five
minute intervals for data to be transmitted through FTP to a
remote server.
. Researched how to accomplish set objectives that are required in
assigned projects, for RPG and VB & PHP languages
. Developed core knowledge of Visual Basic 6.0 & .Net
. Reinforced already exiting background in problem solving and trouble
shooting techniques
. Built communication software that is being used as a communication
method between an I5 platform to a Windows Server.
Vanguard Systems, Media PA (August 2003 - October 2005)
Technical Analyst/ Developer
Environment: AS/400 - I Series, Windows 98, 2000, XP, 2003, RPG II -
IV/ILE, RPG400,
Visual Basic 6.0, Visual Basic .Net
. Provided technical assistance for IMS/21 (Imaging Software)
. Analyzed known problems in programs in both I-series and PC
environments
. Made and tested application changes in core RPG programs
. Designed, coded and tested New modules to be used
. Researched how to accomplish set objectives that are required in
assigned projects
. Developed core knowledge of Visual Basic 6.0 & .Net
. Reinforced already exiting background in problem solving and trouble
shooting techniques
. Developed a connection program that will pull information from a 5250
client and use that data to call another program
. Developed a way to allow users to be able to change text fields and
messages on visual basic forms
. Built a connection between HTML and client application where data from
the HTML document is pulled into the client application to pull up
images.
VIMCO Inc., King of Prussia, PA (February 2003 - May 2003) (IT function
was outsourced.)
Programmer / AS/400 Operations Manager
Environment: Mapics Version 6.0, RPG-IV, AS/400 - I Series, Windows NT, MS
Office
. Developed a modular RPG-IV/ILE program to generate a cross-reference
between the manufacturing bill of materials and item selling prices,
which was used to gather information such as the gross profit
percentage, and also used to determine where errors in the bill of
materials were present in the Mapics environment.
. Developed an RPG-IV program to enable the use either discount
percentage on the selling price or an increase percentage on buying
cost for a given item to determine new selling price of the item.
. Development and maintained back up schedules for both a Windows NT
network and an AS/400 - I Series.
. Created modular RPG-IV programs to calculate new selling prices of
items with-in the Mapics environment.
. Created both SQL statements and Queries on the AS/400 to gather data to
be exported to an Excel spreadsheet.
. Developed financial spreadsheets and price quotes
Penn Fishing Tackle Mfg. Co., Philadelphia, PA (May 2002- February 2003)
1 AS/400 Programmer Analysts/ Assistant to Operations Manager
Environment: Mapics version 6.0, RPG-IV, RPG-III/400, AS/400 I - Series,
WINDOWS NT, Windows 95, Windows 2000, SQL, Query/400
. Developed A/R and A/P reports that utilized the file structure of the
Mapics environment both RPG/400 and RPG/ILE as well as RLU were used in
this process
. Learned the file and program structure used by Mapics
. Installed Mapics patches and updates when necessary
. Scheduled AS/400 Backups within Mapics
. RPG/ILE and subfiles were utilized to create an inventory entry program
to place data into the Mapics physical inventory system
. Developed views, and work benches for use in the Mapics Browser
. Performed all phases of the system development life cycle, while
adhering to guidelines, standards, policies and procedures.
. Defined user requirements.
. Assisted Operations Manager in maintenance scheduling, and performance
tuning of both AS/400 and NT LAN
. Established a line of communications between myself and executives,
concerning the performance of both the AS/400 and LAN
. Created both SQL statements and Queries on the AS/400 to gather data to
be exported to an Excel spreadsheet.
. Developed multiple RPG-IV/ILE Modules to be used to create a projection
analysis report, that incorporated all aspects of the business
including, Accounts Receivable, Accounts Payable, Manufacturing
Planning, and Manufacturing itself.
. Developed an Interactive RPG-IV program to be used to enter and
maintain the company's fiscal date system, which has been used to
generate all end-of-month reports and both manufacturing planning and
projection analysis reports and spreadsheets.
. Worked with Manufacturing Coordinator to ensure the integrity of
inputted data in the Mapics environment after new enhancements and
patches were installed.
. Researched product enhancements that would be incorporated into either
the Mapics/AS/400 or the Windows NT/2000 environments.
. Researched both GUI enabled RPG packages, and Web Sphere technology to
be implemented by the IT Department to enhance, both user and outside
usage of network and external web applications
. Worked on Microsoft NT and 2000 systems.
. Utilized all MS applications (word processing, spreadsheets, Internet
software, email, database software, Project planner etc.)
. Ordered necessary supplies for daily actives of the IT department
MASCOT SYSTEMS, Green Hills, PA (August 2000 - December 2001)
2 AS/400 Programmer Analysts/ Project Lead
3 Contract Position
Client: Penske Truck Leasing
Environment: HTML, RPG-IV, RPG-III/400, AS/400 - I Series, WINDOWS NT,
Windows 95, Windows 2000, Dream Weaver, SQL, Query/400
. Served on a team to develop a web enabled collection management system.
. Led a team consisting of myself and one other RPG programmer to the
completion of Phase I of a Web enabled Collection Management system,
the used AS/400 for all back ground calculations.
. Updated Credit memos to be able to be written in either English or
French Canadian
. Assisted in the management and development of the above system.
. Performed all phases of the systems development life cycle while
adhering to guidelines, standards, policies and procedures.
. Defined user requirements.
. Built test plans and constructed program logic to go behind a Web
system.
. Developed HTML web screens to be used to gather information concerning
clientele in regards to what is being owed to my client.
. Researched multiple HTML generation software packages to be used within
this project.
. Developed and tested Multiple SQL Statements that were placed within
Java code to extract data from the AS/400.
. Developed batch programs in RPG-IV/ILE, which were used to gather and
update necessary data that Web screens will then show to the user in
the collections.
. Enhanced existing RPG/400 programs in the company's leasing division to
incorporate a resent purchase of another leasing organizations.
. Worked on Microsoft Windows 95 and NT systems.
. Utilized all MS applications (word processing, spreadsheets, internet
software, email, database software, Project planner etc.)
. Developed education portfolio for Hawk-Eye informational system.
. Learned fundamentals of Web Sphere technology running on AS/400 - I
series
WEIDENHAMMER SYSTEMS, Wyomissing, PA (August 1999 - March 2000)
4 AS/400 Programmer
5 Contract Position
1 Environment: HTML, XML, RPG-IV, RPG-III/400, IBM S/36, AS/400, WINDOWS
95/NT
. Researched and implemented an XML project located on the AS/400 which
was transferred via the Internet to the parent company.
. Worked as part of a team on multiple Year 2000 conversions
. Performed all phases of the systems development life cycle programs
while adhering to guidelines, standards, policies and procedures.
. Tested new version of an existing Query Generation software package to
determine both problems and solutions to those problems before client
implemented this package.
. Using SQL, converted data from an existing Mainframe to the file
layouts that exist on the AS/400.
. Worked on Microsoft Windows 95 and NT systems.
. Utilized all MS applications (word processing, spreadsheets, internet
software, email, database software, etc.)
RCM TECHNOLOGIES, Wayne, PA (July 1998 - August 1999)
6 AS/400 Programmer/ Project Manager
7 Contract Position
Environment: AS/400, S/36, RPG-II/III/IV, OS/400, SQL
. Defined user requirements.
. Led a development team of three full time employees and 2 part-time
employees
. Researched and gathered necessary information that was necessary to
complete the assigned workload.
. Performed all phases of the systems development life cycle while
adhering to guidelines, standards, policies and procedures.
. Created an education package to be used by Junior Programmers to help
them understand the principals of developing business applications.
. Mentored two junior programmers that were on this projects team.
. Led a System 36 to AS/400 conversion while implementing year 2000
changes to all code and files that needed to in place.
. Converted system 36 Flat Files to the Structured Layout provided on the
AS/400
. Using SQL and Queries, tested the data integrity after the files had
been converted from the System 36 flat file layout to the structured
layout used on the AS/400
. Converted a custom designed System 36 manufacturing and invoicing
package written in RPG II to the AS/400 converting the Source into
either RPG/400 or RPG-IV.
. Researched and tested multiple software packages to assist in the
conversion of the programs.
. Implemented software that was chosen for the Conversion process.
. Built a Modular RPG-IV program that became standard for all the
necessary date conversion procedures that needed to be performed.
. Ensured accuracy of all financial dollar amounts, including all taxes,
and Interest rates that was to be applied to invoices.
. Worked on Microsoft Windows 95 and NT systems.
. Utilized all MS applications (word processing, spreadsheets, internet
software, email, database software, etc.)
WRIGHT'S KNITWEAR CORPORATION INC. (May 1996 - July 1998)
8 AS/400 Programmer
Environment: AS/400, PCs, TCP/IP, RPG/400, RPG-IV/ILE, SQL
. Served on a team of three that developed financial reports/screens.
. Developed EDI Mappings for Order Processing.
. Maintained Shipping labels that were either generated by purchased
software or from custom applications.
. Developed payroll reports that showed national, state, and local tax
withholdings and other payroll deductions, in a format based on the
Users Input. Either in a Year to Date version, a monthly version, or to
a detailed report.
. Defined user requirements and understood the business cycle of a
manufacturing environment.
. Assisted in the upgrade and modification for new version release of JBA
International software, an AS/400 Manufacturing package. Programmed
custom changes, and tested the new Release.
Helped Integrate the AS/400 to be used as part of the local network.
. Updated existing PCs from Windows 3.1 to Windows 95
. Helped establish the company's network and NT server to be used as a
mail server running Lotus Notes.
. Worked on Microsoft Windows 95 and NT systems.
. Utilized all MS applications (word processing, spreadsheets, internet
software, email, database software, etc.)
. Trained support staff to use programs.
. Utilized math skills to calculate discounts, interest, percentages, and
sales tax.
EAST PENN MANUFACTURING COMPANY INC., Lyons Station, PA (January 1992 -
March 1996)
9 Data Entry Clerk
10 Environment: Windows 3.11, DOS
. Streamlined databases used in the Human Resources Department.
. Worked with Lotus 123, Dbase IV, and Word Perfect.
TECHNICAL SKILLS:
Hardware: AS/400, PCs, IBM S/36
Operating Systems: OS/400, Windows NT, Windows 98/95, Windows 2000,
Windows XP, Windows
Server 2003/2005/2008, SQL Server 2005, Windows Vista
Software: SDA, RLU, SQL, DBU, Hawk-eye, TCP/IP, MS-OFFICE 97, MS-
ACCESS 97, MS-Office
2000, MS Office XP & 2007, Word Perfect, Quatro Pro, Lotus 123, Dream
Weaver,
Fire Works, Elixir Forms Generator, Front Page, Visio, Smart Draw
Languages: RPG/400, RPG-II/III/IV-ILE, HTML, XML, CL, SQL, PHP, VB,
VB.Net, XML, CSS,
HTML
Applications: Y2K, Collection Management Systems, Marketing Systems,
Order Entry, Financial
Systems, Invoicing, Inventory Control Systems, Shipping, WIP Systems,
Repair Systems, warehousing
Systems
1
2
3 EDUCATION:
. Berks Technical Institute (April 1996), Associates Degree in Computer
Science; coursework emphasized AS/400 programming and operations.
. Berks Career and Technology Center (June 1994), Certificate of
Completion in Computer Science
Contact this candidate