Design Data Entry
Resume:
Robert R. Boerner
AstroComp, Inc.
Elkton, MD 21921
Contact Information: Voice: 609-***-**** Email: **********@***.***
Qualifications Summary Profile
Senior executive level consultant with over thirty years of applications and system design and development experience for US and UK based companies. Clients have ranged from small entrepreneurs to Fortune 100 companies in manufacturing, distribution, publishing and service-related industries. Modernization and legacy system conversions. Bachelor of Science Degree in Mechanical Engineering from Drexel University, Philadelphia, Pennsylvania.
Professional Experience Summary
Complete understanding of all major applications areas. System upgrading, change control and legacy system improvements, project management and new system integration.
Database Design and Construction Knowledge and understanding of:
* Major database products and functionality relating to both Mainframe and PC-based systems.
* Database design tools for enterprise modeling and relational database construction. This includes
One-to-many, many-to-one and many-to-many concepts, also issues relating to referential integrity and
Cascading functionality.
* Issues relating to database integrity and validation concepts.
* Data input systems for Mainframe and PC-based systems using data entry software products, CICS and
Scanning hardware and software (OCR/ICR) and digital pen technology. Mobile applications using all devices.
* Legacy, restart and backup database issues.
* Large scale data repository databases and indexes including SGML/XML standard and non-standard based
systems.
* ERP software selection and implementation activities.
* SQL databases
* ETL systems and processes. Extract, Transform, Load
* EDI Data Streams
Process Flow Analysis and Application Development
* Design and development of small and large systems requiring process flow and object-oriented application
design construction. This includes large warehouse management concepts, inventory movement and
tracking and distribution-related activities.
* Design and development of small and large online systems.
* Design and interfacing Mobile applications with large scale systems.
Information and Data Retrieval Systems
Knowledge and understanding of:
* Data retrieval functions relating to both relational and custom designed search-oriented databases.
* MS/Access query and Boolean logic concepts.
* Custom design of Mainframe-based search databases.
* Mainframe VSAM files. KSDS, ESDS both with alternate indexing.
* CD-ROM-based searching systems and data generation.
* Automated indexing techniques, keyword generation and insertion and facet phrase generation.
Publishing Systems
Knowledge and understanding of:
* Design and complete system integration and knowledge of large and small publishing systems using both
Mainframe and PC-based platforms. This includes SGML/XML, custom data feeds and large tagged
databases.
* Large database publishing activities and control issues. Cover to cover publishing, large-scale directories,
and scientific text publishing.
* Complex text mark-up construction and validation concepts.
* Font construction and implementation.
* Design of imaging and non-paper electronic-related publishing systems. This includes issues relating to
CD-ROM publishing.
* Adobe Acrobat PDF file generation and file control issues along with internal document tagging and
Indexing. PDF smart field construction of interactive documents.
* Planet Press Suite components. Process flow and PDF generation. This includes document creation and presentation.
Programming
* Mainframe JCL – MVS – VSE – All Mainframe editors
* Report Writers – Crystal Reports SAP - Easytrieve Plus CA
* Assembler, PL/I, Cobol. Mainframe platforms.
* CICS complete understanding of all components.
* Word, Excel, Access.
* Adobe Acrobat – Smart Forms and Java – Interactive forms
* Planet Press – Design, Image, Watch and Fax (major)
* PrintNet (minor)
* Postal Sorting Software
* All bar coding processing
Work History
AstroComp, Inc – Philadelphia and New Jersey 1986 - Present
My Company for Contract work
Applications: Direct Marketing, Direct Mail, Laser printing, Database Publishing,
* Planet Press – Design, Image, Watch and Fax (major)
Cenlar, FSB -- Ewing, NJ 2015 - 2018
Applications: Publishing, databases, information retrieval, application development.
Loan processing
Solution Architect
Worked with various teams in all areas of application development and
programming. Teams used Planet Press software.
Balford Farms – Philadelphia, PA & New Jersey 1990 - 2015
Applications: Payroll, warehouse management, invoicing, distribution, inventory.
ERP selection and Implementation.
Senior Consultant/Developer
Developed and constructed all major online systems.
PDF generation of intelligent forms. ERP software selection and ETL projects. Applications: Planet Press system documentation and integration. Database Publishing.
BIOSIS -- Philadelphia, PA 1985 – 1995
Applications: Publishing, databases, information retrieval, application development.
Director of IT - Managed 55+ staff in all areas of application development and
programming.
Summary & Notes April 2019
The following applies to my experience using IBM Assembler and COBOL programming for both batch and online systems.
Knowledge of ALL major IT systems.
Accounting, database, information retrieval systems, batch reporting, warehouse and inventory, manufacturing systems, delivery systems, marketing and direct mail systems, address correction and NCOA processing.
Knowledge of both macro and command CICS systems.
Last major project was the design and coding of product delivery system for Starbucks using mainframe and iPad controlling over 250 Starbucks stores in three states.
Over 30 years’ experience using IBM Assembler Language and Cobol.
Gathering and compiling information for assembler development
Analyzing project and presenting time estimate
Coding, testing, fixing, and implementing complex programs
Evaluating business needs and developing systems and program designs accordingly
Developing and submitting project plans to project manager
Testing, revising, and documenting changes in software applications
Planning and performing technical analysis on projects
Performing unit testing and system testing as required
Designed new programs and enhanced existing programs
Modified programs using logic and programming skills
Documented specification of programs code
Wrote program using a sequence of assembler instructions
Solved technical problems related to programs
Followed programming standards and procedures while executing tasks
Executed assembler-code according to clients' specifications
Worked with Assembler (standard) and Assembler H
Wrote programs for both Batch and CICS.
Knowledge of all assembler instruction.
Created MACROS for assembler language.
Consulted for many companies requiring special knowledge to correct problems
Balford Farms – Distribution Company – Revenue 400 Million - 1990 - 2015
All systems developed using Mainframe Systems
Programming: Assembler code, PL/I code, COBOL code
All mainframe data types.
Managed a team of 3 staff. Over twenty years.
Designed systems for:
All accounting systems. General Ledger, Invoicing. Journal entries, payroll.
Warehouse management.
Product construction and database management.
Product guides email and printed
Order entry systems for 25 users
Daily systems for control of deliveries.
Bar code product labels for tracking.
Purchasing system controlling over 400 vendors.
Pricing systems controlling 2,500 products.
Designed and developed Mobil (iPad) systems for delivery control for Starbucks
Researched ERP systems to replace the mainframe. in 2015
Contact this candidate