JEFF N. RAKOWSKI

**** ***** *****

Woodridge, Illinois 60517

630-***-****

ac6p2f@r.postjobfree.com

https://www.linkedin.com/in/jeff-rakowski-433171169/

SUMMARY

A highly skilled and accomplished EDI Programmer of 27 + years with expertise in JD Edwards, SAP and other software programs. Works well under pressure with an attention for detail. A conscientious team player who leverages highly effective communication and organizational skills to foster collaboration with coworkers and all levels of management. A highly organized and dedicated professional with an exceptional positive attitude who thrives on working in a challenging environment.

TECHNICAL SKILLS

EDI, BizManager, Open Text EDI Mapper 4.0, JD Edwards, SAP, Harbinger Software, Trusted Link Software, Forecast X 5.0, Cobol, MS Access 97

EXPERIENCE

M. BLOCK & SONS, INC. Bedford Park, IL

EDI Programmer/Analyst 2003-2018

Initial setup of EDI partners, maps and information using the software BizManager 4.0.2 patch 2

Developed mapping of orders (850 and 875), ASN (856) and invoices (810 and 880) and other transaction sets for versions 4010 - 5010 of Open Text EDI Mapper software 4.0

Used Access 97 to pull EDI data and place in selected tables in JD Edwards (JDE) 9.0

On a daily basis, brought orders in, sent out ASN’s, invoices and functional acknowledgments in a timely fashion and other numerous activities of the EDI system.

BAKE-LINE PRODUCTS, INC. Des Plaines, IL. (Subsidiary of Keebler)

BAKE-LINE GROUP, LLC Oakbrook Terrace, IL

EDI Programmer & IS Manager 1990-2003

Managed computer department for 2 years.

Initial setup of the EDI system using Harbinger software, which included all the trading partner setup, mapping of orders (875 and 850) and invoices (880 and 810).

On a daily basis, brought orders through the Harbinger software which led to the SAP mainframe and sent invoices and functional acknowledgments out in a timely fashion.

Upgraded the EDI system to different versions (Y2K).

Maintained and updated trading partner data, along with being in contact with customers of EDI.

Lead the SAP implementation team, converting data from the NCR system to SAP.

Wrote queries in SAP to link specific tables to collect data which would be exported to Excel spreadsheet.

Wrote four separate databases that were used for sales reporting and forecasting, which were used as outside modules from the SAP mainframe system.

A.Sales-Budget Database used for in-house sales reporting in many forms for different time periods.

B.Forecasting Database used to determine how much packaging should be ordered; also used by bakeries to schedule production.

C.Business Review Database used by sales to present to customers.

D.P/L Database used to show the profitably or loss of current products being produced.

Created and maintained many reports, queries, forms, tables, and macros consisting of data for over 2,200 customers and 4,900 items.

Developed a centralized sales reporting system for easy access to reports.

Developed many ad-hoc reports, which could be exported to excel for sales in minutes.

Forecasted over 2100 items over a 12-period time frame using Forecast X 5.0(forecasting software).

Created a Forecast Database that was used to generate accuracy reports with history and forecast data in a 4-4-5 time-frame format.

Wrote and edited Cobol programs for an NCR mainframe system.

EDUCATION

DEPAUL UNIVERSITY, Chicago, Illinois

Bachelor of Science

Major: Computer Science – Information Systems

MORAINE VALLEY COMMUNITY COLLEGE, Palos Hills, Illinois

Associates of Science

Contact this candidate