System Consultant Independent

Cathy A. Miller

Contact:

ado75a@r.postjobfree.com

phone #s 954-***-****(m)

941-***-****(h)

linkedin.com/in/cathy-miller-1a60392b

Summary

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

Skills

ILE RPG (fixed and free form( which includes the ALL Free version ), DB2 SQL, CL, FTP, web service implementation via IBM Integrated Web Services (IWS) server and YAJL, and SYSTOOLS DB2 HTTP utilities, time management, some System Administration, knowledge of MS SQL Server Management Studio and PL SQL, knowledge of COBOL, SYNON/2e., and HTML, PHP.

Experience

On-going Part-Time Consulting Positions

06/20 – Pres. Otterbase, Inc., Nashville TN

consulting client: SVP Worldwide, La Vergne, TN

All development was done using AS400/IBM I RPGLE

Develop restful web services and file transfer applications using IBM IWS ( Integrated Web Services tool), and open source utilities YAJL and HTTP API for the B2B project.

Develop report files that are downloaded to PC clients as spreadsheets.

11/20 – Pres. consulting client: Alpha Mills, Schuylkill Haven, PA

All development was done using AS400/IBM I RPGLE

Enhance/Maintain in-house warehouse management software such as that which is used by RF bar-code scanners and other tasks as needed.

Prior Part-Time Consulting Positions

07/20 – 01/21 Susquehanna Information Systems, under contract to, Computer Management and Marketing Associates, Inc., Bethlehem, PA

consulting client: ASGCO Manufacturing, Allentown, PA

Provide support to Cloudforia consulting group as they implement Salesforce – J. D. Edwards integration:

installed digital server certificates.

installed WebSphere Application Server and J. D. Edwards(JDE) Service Enablement web services (for JDE World).

Installed an IWS web server, configured it with SSL/TLS security and developed web services that provided additional functionality needed by Salesforce.

Assisted integration effort through identifying files and uploading data extracts from JDE needed by the Salesforce team.

07/20 – 11/20 Susquehanna Information Systems, Wyomissing, PA

consulting client: Bridon-Bekaert Ropes Group, Wilkes Barre, PA

Developed SOAP and RESTful web services as part of an integration project between their in-house ERP system and SAP.

Installed/renewed digital certificates in use by servers and the Java JVM.

03/14-04/14 TekPartners Inc.

consulting client: Sheridan Healthcare Coral Springs, FL

Programmer/Analyst - iSeries

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.

Prior Full-Time Positions

Susquehanna Information Systems, Inc, Wyomissing, PA

03/19-4/20 Sub-Contractor with Weidenhammer

Consulting Client: Rentokil N.A.

All development was done using AS400/IBM i RPGLE

Inside Sales Project: Build web services and supporting programs that generates transactions that becomes the basis for new customer entries, sales work orders and schedules. The web services consume JSON input via YAJL utilities that parses/flattens it in order that the data may be formatted for insertion into native data base files on the Power System.

Develop web service trigger programs that utilized YAJL to build JSON data structures and SYSTOOLS DB2 function, HTTPPOSTCLOBVERBOSE, to invoke RESTful Google Cloud APIs that consumed the JSON in order to replicate data changes to a central cloud repository.

Helped with a data migration project that involved enhancing a CGI RPGLE program to submit reports into batch via clicking a button, I added to the web page, and causing the web page to display a message notifying the user to expect them.

Successfully completed a highly visible project that involved migration from a multi-carrier cellular text messaging program interface to the TWILIO messaging service. The new SMS transmission program sends messages to TWILIO using native RPGLE and open source HTTPAPI utilities.

Performed general programming tasks such as developing/modifying interactive and batch programs that perform data validations, convert Query/400 queries into SQL programs for inclusion onto menu options or CL job streams, add f-keys to screens or create batch processes.

07/17—02/19 KOgent Systems, Inc., New Paltz, NY

Consulting Clients:

2/18 – 02/19 Chromalox Inc ., Pittsburgh, PA

Built RESTFul web services to extract data from a J.D. Edwards World data base for consumption by programs running on the web. These restful web services were created using SQL and RPGLE in concert with YAJL and DB2 SYSTOOL HTTP utilities (such as HTTPPOSTCLOBVERBOSE, HTTPGETCLOB, etc.).

Designed and built a UDF (User Defined function) to calculate an item’s unit price; this was done to centralize and standardize the manner of its calculation across the system.

10/18 – 11/18 Commsoft, Rensselaer, NY

All development was done using AS400/IBM I RPGLE

Develop software to convert MS Dynamics data for import into a NetSuite GL system. Data was converted to csv format and transmitted to NetSuite via FTP.

Create a “work with” application that allowed users to inquire, update, add or delete NetSuite GL cross reference file data.

07/17-02/18 DST Inc., Foothill Ranch, CA

Assisted in the modification of software to work with expanded data fields for one DST’s largest clients. This followed-up an automated enhancement that was made using a custom version of the X-Analysis tool by Fresche Legacy.

Built RESTFul web services to extract information from the Turboprise data base for the company’s new web site project. These objects were constructed using RPGLE with embedded SQL queries and the open source framework YAJL, that was modified by Scott Klement for use on IBM I.

Created SOAP webservices using the open source tools SOAPUI and HTTPAPI. Through SOAPUI, I was able to test the URI WSDL and get insight into the structure of the XML request document; with that information I was able to configure the webservice to transfer data in XML format to the receiving system.

04/16-07/17 Insight Global, Inc.

Tampa, FL 33507

Client: Bealls Inc, Bradenton, FL

Sr. Systems Analyst -- iSeries

Enhancements were done using RPGLE, CL and SQL

Analyzed in-house distribution/fulfillment system using X-Analysis to discover impact of file changes; diagrammed findings using VISIO and then created detailed design and functional specifications for project deliverable s.

Delivered software solutions according to detailed specifications and documented test results.

Enhanced existing customer email application to transmit status emails as an XML document to Salesforce via IBM’s WebSphere MQ.

Developed test plans for QA to guide them through environment setup and software use.

04/14-08/15 KOgent Systems, Inc.

New Paltz, NY 12561

Cient: National DCP, LLC (Dunkin Donuts), Bellingham, MA

Sr. Consultant : SME Team-Lead/Sr. Consultant – iSeries

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 that were converted to .CSV format for upload into SAP.

1/08-12/13 Vormittag Associates Inc., Miami Lakes, FL

Programmer/Analyst -AS400

Enhancements were done using RPGLE, CL and SQL.

Enhanced and maintaining the company's ERP 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.

2/03-12/07 Southern Wine and Spirts of America, Miramar, FL

Senior Developer –AS400

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

3/99-12/02 CONVERGYS CORPORATION, Sunrise, FL

Computer Analyst -AS400

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.

7/97-3/99 THE MARK GROUP, Boca Raton, FL

Senior Programmer/Analyst

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.

4/96-7/97 GULF ATLANTIC MGMT/SANZ HOLDING CO., Fort Lauderdale, FL

Senior Programmer/Analyst

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.

7/94-4/96 CHASE MANHATTAN PRIVATE BANK, Miami, FL

Senior Programmer/Analyst

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.

8/93 - 7/94 SOUTHEAST FROZEN FOODS, North Miami, FL

Senior Systems/Analyst

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.

7/92 - 8/93 COMPUTER MANAGEMENT SCIENCES, INC., Jacksonville, FL

System Consultant

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.

8/91 - 6/92 EQUITABLE BAG COMPANY, INC., Long Island City, New York

Senior Programmer/Analyst

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.

3/90 - 8/91 Fairchild Publications, New York, New York –Senior Programmer/Analyst 8/89 - 3/90 Pass and Seymour Le Grand, Long Island, New York –Independent Consultant

Education

06/1990 Saint John’s University, Jamaica-New York - MBA Management Information Systems 09/1985 Queens College of the City of New York - B.Sc. Computer Science

Contact this candidate