Uploaded File
Cathy
catmiller07@comcast.net
954-722-6485
8303 SW 20th Street
North Lauderdale, FL 33068
954-347-2407
Sr. iSeries Programmer/Analyst
32 years experience W2
0
Recommendations
Average rating
265
Profile views
Summary

Over 15 years experience as an Information Systems Specialist focusing on the application of technology to business functions in the areas of consulting, liquor distribution, cable and wireless telephony billing, manufacturing, warehousing and insurance. Strengths include creative problem solving, working independently as well as in groups, and excellent oral and written communication skills.

  • Proficient in RPG ( fixed and free form)
  • CL
  • Strong attention to detail
  • Structured Query Language (SQL)
  • FTP
  • Creative Solutions
  • System Administration
  • Job Control
  • Time Management
  • Excellent oral/written expression
  • Synon/2e
  • DB2

Experience
Lead/Sr
Retail
Apr 2014 - present

Enhancements were done using RPGLE, CL and SQL

  • Troubleshoot and resolve application issues – analyze application data to assess performance and uncover problems.
  • Design and deploy programming solutions to support 4 sites in different regions of the country for such areas as Order Entry, Billing and G/L.
  • Lead team player in a data conversion to SAP project utilizing “Agile” methodology that essentially includes the following:
    • Project preparation-mapping the necessary fields from legacy System 2000 (S2K) files to their equivalents within the SAP ECC (Enterprise Control Component).
    • Creating extraction programs to populate the conversion files. Once these are built they’re converted to CSV format{ compatible with MS Excel } and fed into a validity checker.
    • Analyzing errors and fixing the extract program.
    • Once the data is correct, it’s loaded into SAP. The kind of data I’m working with is a mixture of master and some transaction files (ie. Material Master, Vendor Master, Open PO, Consumption History, Inventory Valuation).
Agile Methodology
Remove Skill
Programmer/Analyst - iSeries
Healthcare
Mar 2014 - Apr 2014
  • Worked part-time at a local healthcare facility outsourcing service.
  • Made modifications to a legacy physician/patient management system using COBOL/400. These changes were made to extend the life of the application while a more modern version was under development.
Cobol
Remove Skill
Programmer/Analyst -AS400
Information Technology
Jan 2008 - Dec 2013

Enhanced and maintaining the company's EAS package, System 2000 (S2K). My duties included:

  • Working with various projects that involved creating enhancement solutions in such areas as inventory, accounts receivable, accounts payable, general ledger, and order entry to fulfill the requirements of a diverse customer base that included business lines such as: pharmaceuticals, commercial cleaning, lighting fixture supply sales and distribution, truck parts distribution, trailer sales and rental, etc.
  • Assisting in user's acceptance of these implemented enhancements.
  • Performed system administration including security, configuration, communications and job control.
No skills were added
Remove Skill
Senior Developer -AS400
Information Technology
Feb 2003 - Dec 2007

Responsible for performing technical support for all corporate sites for both the Sapphire and Base/Disc billing and distribution packages. My duties included:

  • Troubling shooting hard program halts and making program/data changes to rectify these.
  • Creating custom programs using RPGLE , CL and SQL to develop solutions to meet the site’s requirements:
    • Installed modifications to limit user access within a Sales Commission System.
    • Designed and deployed programming changes to a Warehouse Picking tool that allowed the users to pick large orders more efficiently.
    • Participated in the analysis and construction of a major revision to the Depletion Allowance system for the state of California.
  • Providing education to the site personnel concerning software configuration or explain the meaning of the data.

Served as a member of an implementation team that visited the North Central Florida site to install Sapphire Version 4; also visited the Southern California site to make software customizations during a conversion project as the site was expanding their operations to a mega warehouse.

SQL
Remove Skill
Programmer/Analyst
Telecommunications
Mar 1999 - Dec 2002
  • Responsible for being the primary contact for questions relating to the Equipment Inventory module of ICOMS (Integrated Communications Operations Management System).
  • Assessed current Equipment Inventory module for data integrity vulnerabilities and compliance with specifications, and reported findings to management with recommended corrective actions – this resolved problems in the early phase of the conversion project.
  • Collaborated with Systems Engineering personnel while reviewing Program Requirement and Detailed Design Specifications for discrepancies; this assured the accuracy of the system documentation derived from these specs and brought to light feasibility issues which were reported to my manager.
  • Developed enhancements for Dialogic ARU, which streamlined the processing of customer statement balance inquiries and provided greater flexibility for outage calculations.
  • Developed enhancement for the barcode label print facility that enabled labels to be routed to printer queues other than the user default one.
  • Provided telephone support to in-house personnel and customers, which helped to troubleshoot problems and aided their education.
  • Developed enhancement for the Order Entry to calculate service category combinations, which were used in the creation of Work Orders.
  • Development for ICOMS was accomplished using the Cool/2e (formerly Synon/2e) CASE tool and RPGLE.
Compliance
Remove Skill
Senior Programmer/Analyst
Retail
Jul 1997 - Mar 1999
  • Maintained and enhanced the Mozart warehouse management package via custom programming and model management utilities to tailor it for better use by the company.
  • Developed and implemented file transfer applications to both Import orders from an evening data entry service for assimilation into Mozart, and, extract and convert magazine subscription data for export to the Magazine Direct Company. Utilized MS Query to extract data from the AS/400 for import into MS Excel for use by senior management to forecast sales revenue.
  • Customizations to Mozart were accomplished using the Cool/2e (formerly Synon/2e) CASE tool.
Microsoft Excel
Remove Skill
Senior Programmer/Analyst
Insurance
Apr 1996 - Jul 1997
  • Maintained and enhanced the Comp US payroll system Streamlined the generation of Tax forms through the use of Advanced Print Function utilities.
  • Developed and implemented a file transfer application that converted employee/employer tax data into a format compliant with State and Federal electronic filing standards (940, W2, 1099) prior to transmission.
  • Development was done using the Cool/2e (formerly Synon/2e) CASE tool.
No skills were added
Remove Skill
Senior Programmer/Analyst
Banking/Financial
Jul 1994 - Apr 1996
  • Maintained and enhanced the PBIS (Private Bank Info System) that had been converted from legacy RPG to native AS/400 RPG via the SYNON/2e CASE tool.
  • Acted as lead analyst for the PBIS-VISTA interface project: Reviewed system design specification.
  • Laid-out data base schema in the SYNON 2/E model. Managed the workflow of a junior colleague.
  • Served as on-call support technician for the sites where the software was installed – this aided the on-site programmer because someone would be in the office during the hours he worked poised to provide him with necessary source code and objects, or, help him make quick changes.
No skills were added
Remove Skill
Senior Systems/Analyst
Retail
Aug 1993 - Jul 1994

Lead Programmer/Analyst during conversion of legacy RPG II Sales Tax and Transportation systems that utilized internally described sequential files to native AS/400 relational database. Effectively managed and supported the Engineered Standard System Consultant. Acted as liaison to the MIS and Transportation Departments, facilitating efficient flow of communication. Efficiently maintained SYNON model by installing upgrades, applying ptf’s, and removing duplicate access paths.

System Analysis
Remove Skill
System Consultant
Information Technology
Jul 1992 - Aug 1993

Developed Warehouse Planner module, for ULS project, which aided warehouse personnel to put-away stock with similar storage characteristics.Created major executive planning reports: Order Forecast, Critical Stock Exception .

This project was done using Synon/2e.

No skills were added
Remove Skill
Senior Programmer/Analyst
Manufacturing
Aug 1991 - Jun 1992

Converted legacy A/R and Inventory applications from a 43XX mainframe to the AS/400 – these were written COBOL. Effectively trained mainframe staff to use AS/400.

Customized the PRMS Inventory Control Module to fit corporate needs – this was done in RPG.

Cobol
Remove Skill
Senior Programmer/Analyst
Retail
Mar 1990 - Aug 1991

Maintained and enhanced an in-house financial package using COBOL/38. Wishing to standardize all the software in RPG, the company trained me to use the Synon/2e CASE tool. I rebuilt the old COBOL software in RPG via Synon/2e.

Cobol
Remove Skill
Pass and Seymour LeGrand
Manufacturing
Aug 1989 - Mar 1990

Maintained/Enhanced an in-house MRP package that was written using COBOL/38.

No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Management Information Systems
Saint Johns University, 1987 - 1990
Bachelor's in Computer Science
Queens College of the City of New York, 1982 - 1985
Skills
C
2015
8
CL
2015
8
Cobol
2014
8
Agile Methodology
2021
5
iSeries
2013
5
AS/400
1997
4
Microsoft Excel
1999
4
SQL
2007
4
System Administration
2007
4
Compliance
2002
3
RPG
1993
3
Technical Support
2002
3
Documentation
1999
2
Data Conversion
2015
1
DB2
0
1
GSAP
2015
1
HIPAA
0
1
Inventory Control
1991
1
jQuery
1997
1
Linux
0
1
Microsoft Internet Explorer
2015
1
Microsoft Word
0
1
Mozart
1997
1
MS DOS
0
1
OS/400
0
1
PCS
0
1
RPG III
1993
1
RPG/400
0
1
Sales
1993
1
SuSE
0
1
System Analysis
1994
1
System Design
1994
1
Telephony
0
1
Wireless
0
1
FTP
0
1