Resume

Sign in

Analyst Microsoft Office

Location:
Oak Park, Illinois, United States
Posted:
May 19, 2017

Contact this candidate

Mark Ifkovits

**** *. ****, **** **, Schiller Park, IL 60176

Cell: (847)-***-****

ac0d8d@r.postjobfree.com

Summary

Experience in all phases of the AS400-ISERIES. Programmer adept at application development, testing and optimization. Excels at RPGLE and RPG free-format application development, including coordinating ground-up planning, programming and implementation.

Technical Expertise

Requirements analysis and design phases of program creation

Design and creating RPG III, RPG IV, RPGLE free-format using modules, binding directories and service programs, CLLE and DDS source code

Created RPG III, RPG IV and RPGLE free-format programs with embedded SQL code for selecting and manipulating groups of data, counting and performing calculations

Using ALDON software development system

Using Microsoft SharePoint application

Using embedded SQL and STRSQL for testing and data management

Have used Microsoft Excel and Word many times throughout my carrier

Accomplishments

Lots of experience rewriting and designing old code to bring up to modern standards using RPGLE free-format code, embedded SQL, binding directories, modules and service programs at The Warranty Group, Nippon Express USA and Ceannate Corporation..

Converted BPCS system for Suncast Corporation to the year 2000 by subtracting 28 years from the database and changing all programs to display the correct year at the reporting and screen level. Saved the client upwards close to a million dollars by not having to convert to version 6 of BPCS by also making changes to BPCS to handle Suncast unique functions.

Maintained Inventory management, accounts payable, accounts receivable and order entry systems within BPCS for Suncast Corporation.

Helped create RPG III and RPGLE code generator RAPID GEN to create RPG programs from simple data modeling menu driven questions for IT consulting firm Rapis Corporation.

Created FTP (File Transfer Protocol) batch application to move encrypted files between The Warranty Group’s AS400’s-ISERIES.

Created AS400-ISERIES user entry control system to keep track of user’s access to AS400-ISERIES for The Warranty Group.

Created RPGLE, CLLE and DDS source maintenance application for GMI Software, Inc. to track and control the assignment and maintenance of all source code.

Created futures transactions inquiry system for GMI Software, Inc. so the company’s client futures brokers could easily view their future trades.

Experience

Senior programmer/analyst March 2017 to May 2017

North American Corp. – Glenview, IL

North American Corporation is a highly successful, privately held company offering nearly a century of expertise in supply and distribution solutions.

Helped modify and make fixes to previous written programs.

All new coding using RPGLE, free-format code, CLLE code, and embedded SQL programs.

Used Microsoft Office Word and Excel to E-Mail and display files, program results and reports to users within the company.

Created AS400-ISERIES user entry control system to keep track of user’s access to AS400-ISERIES

Often performed continued maintenance and changes to RPG, RPGLE and CLLE programs written by others.

Designed and created RPGLE print programs to display results from month end runs of clients warranty data.

Senior programmer/analyst January 2017 to March 2017

Corus360 – Norcross, GA

IT AS400 Consulting firm working as one of many contract programmers at North American Inc. in Glenview Illinois under an open contract as a Senior AS400/ISERIES RPGLE Programmer/Analyst consultant.

Helped modify and make fixes to previous written programs.

All coding using RPGLE, free-format code, CLLE code, and embedded SQL programs.

Senior programmer/analyst August 2016 to October 2016

Solution Partners Inc. – Naperville, IL

IT AS400 Consulting firm working as a senior programmer/analyst at Newly Weds Foods Inc. which specializes in making seasonings, marinades, glazes, sauces, batters, breadings, binders, and fillers for the food processing and foodservice industries in some 70 countries worldwide.

I worked in the MIS department fixing bugs and making modifications to old RPGLE and RPG imbedded SQL programs.

Helped clean up and rewrite programs written many years ago by many programmers.

All new coding using RPGLE, free-format code, CLLE code, and embedded SQL programs.

Senior programmer/analyst October 2015 to August 2016

Ceannate Corporation – Rolling Meadows, IL

Ceannate Corp. provides complete revenue cycle management for education entities (colleges/universities, Guaranty Agencies, lenders/services, government entities, etc.).

I worked in the i3 Group which provides a channel for schools to strengthen and sustain the relationship with the student.

Helped clean up and rewrite i3 Group data processing programs written many years ago by many programmers.

All coding using RPGLE free-format code, CLLE code, embedded SQL, binding directories, modules and service programs.

Senior programmer/analyst April 2015 to October 2015

Infinity Consulting Solutions - Chicago, IL

IT AS400 Consulting firm working as one of many contract programmers at Dearborn National Insurance under an open contract with no defined end date and very unsecure time frame.

Working at Dearborn National as a contract RPGLE free-format Programmer Analyst.

Maintaining dental insurance system using free-format RPGLE code with modules and binding directories using API’s and built in functions.

All new coding using RPGLE, free-format code, CLLE code, and embedded SQL programs.

Senior programmer/analyst September 2014 to April 2015

Nippon Express USA - Chicago, IL

Nippon Express is a worldwide leader in logistics services including motor freight transport and forwarding, marine transport and freight forwarding, airfreight forwarding and other air cargo transport and forwarding services, household goods moving services, and railway forwarding.

My future at NIPPON was limited because of the package replacing my work maintaining and improving their home grown system.

Hired to help prepare NIPPON brokerage system files and programs for move to brokerage package bought by NIPPON to replace their home grown system.

Senior programmer/analyst February 2014 to August 2014

Fortitude Systems - Chicago, IL

IT AS400 Consulting firm

Working at NIPPON Express USA as a RPGLE Programmer Analyst maintaining their home grown brokerage system until NIPPON hired me to prepare their system for move to purchased brokerage package.

Senior programmer/analyst October 1998 to September 2013

The Warranty Group - Chicago, IL

The Warranty Group is a leading single source provider for underwriting, administration and marketing for service contracts and related services. The Warranty Group has over 1800 employees and presence in 33 countries. We handled warranties for Automotive, Electronics, Appliance and Home.

Worked there 15 years until they started process of eliminating their IT department by outsourcing the work.

Designed and created product warranty systems using RPGLE programs, embedded SQL code and CLLE programs to format incoming warranty data from clients and then to allow users to perform monthly processing of warranty data.

Created FTP batch application using CLLE code to transfer files containing results from month end runs to other AS400’s-ISERIES within company for display in people soft and on demand systems.

Used Microsoft SharePoint to document progress of my work on all my projects worked on for the company and all projects were documented in SharePoint.

Used Microsoft Office Word and Excel to E-Mail and display files, program results and reports to users within the company.

Created AS400-ISERIES user entry control system to keep track of user’s access to AS400-ISERIES

Often performed continued maintenance and changes to RPG and CLLE programs written by others.

Designed and created RPGLE print programs to display results from month end runs of clients warranty data.

Senior programmer/analyst July 1996 to October 1998

Suncast Corporation - Batavia, IL

Suncast Corporation is a leading Plastic Manufacturer 7 days a week 24 hours a day manufacturing and distributor of plastic products.

Left company to advance my knowledge in the programming field beyond the

old BPCS system.

Designed and created RPGLE and CLLE program maintenance and inquiry systems for accounts payable, accounts receivable, order entry and inventory maintenance departments.

Redesigned and programmed changes to companies BPCS system in RPGLE, CLLE and DDS code so BPCS performed unique to Suncast.

Modified BPCS system and all RPG and CLP programs to handle the year 2000 date problems saving the company upwards to a million dollars by not converting and using consultants.

Senior programmer/analyst February 1992 to July 1996

GMI Software, Inc. - Chicago, IL

GMI Software is a software company that processes clearing and accounting for exchange traded derivatives, futures and options for brokerage firms.

Design and created futures inquiry system for brokerage firms to view trades using RPGLE, CLLE, DDS and embedded SQL code.

Created RPGLE, CLLE and DDS source maintenance application to track and control the assignment and maintenance of all source code.

Senior programmer/analyst August 1991 to February 1992

Chicago Truck Drivers Union - Chicago, IL

Chicago Truck Drivers Union is a union representing truck drivers and warehouse workers.

Programmed and implemented accounts receivable system for union dues and health and welfare systems using RPG and CLP code.

Design and created RPG and CLP code maintenance and inquiry programs for various systems in the company.

Programmer/Analyst/Consultant April 1988 to August 1991

Computer Business Management, Inc. - Glendale Heights, IL

Computer Business Management, Inc. is an IT consulting company.

In-house development of manufacturing and order entry systems using RPG and CLP code.

Worked at Baxter Travenol Inc. in Deerfield Illinois as a consultant programmer/analyst on RPG health and medical and manufacturing business applications.

Worked at Navistar Inc. in Melrose Park Illinois as a RPG and CLP programmer analyst on their company system.

Programmer August 1987 to April 1988

Merit Insurance - Chicago, IL

Insurance company providing home and car insurance.

Responsible for maintenance of RPG financial and data entry applications.

Computer Operator January 1985 to August 1987

Gary Wheaton Bank - Wheaton, IL

Responsible for receiving bank data through communication lines and printing reports on an IBM mainframe during third shift.

Education

Daytona Beach Community College - Daytona Beach, FL

Associate of Science: Computer Science

Graduated June 1982



Contact this candidate