Computer Consultant Resume
Jersey City New, JerseY
OBJECTIVE
- I am looking for a senior level position utilizing my knowledge of the AS/400 iSeries and my eighteen years as an RPG programming specialist.
TECHNICAL SKILLS
Programming languages: RPG (Free, ILE, IV, and III), Embedded SQL, CL
Databases: DB2/400
Operating Systems: i5/OS, Windows
Applications: JDA MMS, Microsoft Office, Client Access, Websphere, MMAIL, Jasper Reports, MQ Messaging
Other: Subfiles, SQL, Sequel, Query/400, IFS, FTP, SDA, SEU, RLU, DFU, DBU, Hawkeye, Aldon, HTML
PROFESSIONAL EXPERIENCE
Confidential, JERSEY CITY, New Jersey
Computer Consultant
Responsibilities:
- Made changes to the Depository Movement Display File and ILE program that would allow the user to enter both a “from” and “to” settlement currency code. This modification would capture two different currency codes in the case where the settlement currencies were not the same.
- Increased the length of the Bloomberg Trade Feed, download file by 5500 characters and modified seven dependent ILE programs to propagate the additional information properly and without error into the company’s fixed income software product called Impact.
- Modified four screens and ILE programs to prevent the processing of records with securities that have tasks pending. When this condition was met, the programs would display an error message on the screen.
Confidential, HOWELL, New Jersey
IT Developer
Responsibilities:
- Worked in the IT department of small startup company to automate the management of field services and property preservation from the point of default through disposition.
- Designed and developed an email database that would hold all the clients email addresses and allow easy maintenance of this database through an RPG ILE subfile program.
- Created a service program in RPG ILE so that other programs can bind with it and access the email database.
- Enhanced an existing program by binding my email service program and allowing the user to select multiple email addresses to send the comments automatically by this program using MMAIL.
- Created daily reports for different company departments and developed a process of distributing these reports automatically to various people using MMAIL. Some reports were formatted into a Portable Document Format (PDF) file using Jasper Reports while others were formatted into a Comma Separated Value (CSV) file using embedded SQL and writing the records directly into the Integrated File System (IFS).
Confidential, King of Prussia, Pennsylvania
Principal Software Engineer Consultant
Responsibilities:
- Designed the programming changes to an existing custom JDA program that allows multiple payment tenders to display on a shipping pack slip. The new program now accommodates up to five different payment types.
- Analyzed the system requirements and approved the creation of a dozen customer data feeds that are used to display information on the website and report the sales of the merchandise.
- Interacted with a highly experienced team of Programmers, Designers, Architects, and Database Professionals.
Confidential, Somerset, New Jersey
Systems Analyst
Responsibilities:
- Developed an automatic replenishment process in RPG ILE to evaluate the current on hand balances of selected product items in comparison to their respective ‘order up to level’ and generate a warehouse to store transfer using JDA MMS base processes.
- Developed an automatic batch process in RPG ILE that extracts store sales data from the POS Transaction Detail File (CSHDET) and populates a multi record logical file that is FTPed to ACNielsen for evaluation.
- Developed an automatic batch process in RPG ILE to retrieve FTP credit files from the company’s reclamation business partner and validate the quantities and amounts of this file with the JDA transfer files so that an accurate and timely discount could be applied to our vendor’s invoice for credit of damaged items.
Confidential, Cherry Hill, New Jersey
Senior AS/400 Programmer/Analyst
Responsibilities:
- Developed a menu security process in RPG ILE that would allow access to the company’s menus depending on the user profile security classification.
- Developed a nightly batch process in RPG ILE that would extract all CBA transactions during that day and capture the data in a history file to be used for query reporting.
- Created file maintenance programs to facilitate the management of records in various company files.
Confidential, Dayton, New Jersey
Programmer/Analyst
Responsibilities:
- Developed a zone inquiry function in RPG ILE for the conveyor system that allows the user to view the current number of pieces in the conveyor locations (zones), what pieces are scheduled to go into those zones, and the estimated time of arrival.
- Developed a new pick ticket maintenance program in RPG ILE that allows the user to delete one or more styles on a pick ticket instead of deleting the whole pick ticket and creating another one with the desired styles
- Developed a inquiry program in RPGLE that allows a user to scan a packed carton and the program will suggest the best location to place the carton depending on its purchase order, pick ticket, or the pallet number.
Confidential, princeton, New Jersey
Computer Consultant
Responsibilities:
- Developed conversion programs and extract files that would separate records from a very large flat file and place them in the newly created extract files depending on the structure code and call type of each record.
- Developed an entry subfile that would allow the user to enter a service request on the screen.
Confidential, Philadelphia, PENNSYLVANIA
Computer Consultant
Responsibilities:
- Created new files and programs to replace the existing ones in the Company’s in - house manufacturing system. The major areas of support includes Order Entry, Sales Approval, Production Control, Bill of Material, and Report Distribution. The programs were controlled in a manner that prevented fatal error messages, which plagued the old system. All development work was done in an ILE environment.
Confidential, New Jersey
Computer Consultant
Responsibilities:
- Analyzed the company’s Data3 software package for Year 2000 (Y2K) compliance. Made Y2K corrections to the Sales Forecast and the Invoice Extracts and wrote test plans for testing these changes. Created upload programs which interfaced with the Bill of Material and Routing databases of the JDEdwards (JDE) software package
- Set up the JDE and Data3 Software package in an AS/400 test environment and tested several modules of the interface for Y2K compliance.
Confidential, Bridgewater, New Jersey
Computer Consultant
Responsibilities:
- Analyzed the company’s custom files and programs and changed all the date fields from six bytes to eight bytes so that the Island Pacific software package is Year 2000 compliant. Other field length changes included: store, region, district, and record type.
Confidential, Philadelphia, Pennsylvania
Computer Consultant
Responsibilities:
- Developed an RPGIV program that interfaced the AS/400 with the existing IBM mainframe. The AS/400 replaced the old mainframe loan system with a newer, year 2000 compliant system called the Advanced Commercial Banking System (ACBS). The RPG program created flat files that were sent to the mainframe for processing month end balances.
Confidential, NORRISTOWN, PENNSYLVANIA
Computer Consultant
Responsibilities:
- Developed a Retirement Deposit Fund (RDF) module and incorporated it into the existing software package. This was a new development project designed for the Military market and it consisted of a menu with several options that included a policy inquiry subfile, an interest maintenance subfile, and a monthly interest accrual report.
Confidential, LAWRENCEVILLE, NEW JERSEY
Programmer/Analyst
Responsibilities:
- Made custom modifications to the JDA Merchandise Management System (MMS) in the areas of Store Use Entry, Purchase Order Receipts, and Transfer Receipts
- Developed a LIFO reporting process for the Finance Department that is used for tracking inventory value at the end of each quarter during the fiscal year.
- Created a report program that would compare SKU’s of the JDA System in one AS/400 with the Warehouse Distribution System in another AS/400.
Confidential, POMONA, NEW JERSEY
Programmer/Analyst
Responsibilities:
- Converted the existing Manufacturing Variance Process to use a new database design
- Developed a subfile program that allowed a user to control the Finished Goods Inventory database.
Confidential, HIGHTSTOWN, NEW JERSEY
Programmer/Analyst
Responsibilities:
- Worked directly with clients to customize their software package by creating interactive screens and menus using SDA that executed the proper CL programs and generated the desired reports.
- Set up EDI trading partners and created message classes using EXTOL EDI software package.