Erin L. Neprud

**** ****** **. ***. ***

Hudsonville, MI 49426

616-***-****

acb84t@r.postjobfree.com

PROFESSIONAL SUMMARY:

Multi-faceted, computer programmer and business analyst with over 20 years

experience in AS/400 environments, with experience working in pharmacy,

medical equipment, and manufacturing companies. Skilled in relational data

bases, RPG, CLP and SAP ABAP programming, as well as Excel and most of the

office suite programs. Willing to learn new technology and work with

legacy systems.

EMPLOYMENT HISTORY:

Stryker Kalamazoo MI ( through Select Resources) October 2012-

August 2013

Senior Quality System Coordinator

* Analyze Master Data for completeness and accuracy. Develop a system

to combine data from different global systems to report what

information still needs to be added by the divisions. Worked as

lead tester for the upgrades to the OLAP cube and underlying tables.

Document processes. Write VBA macros to allow someone else to

easily update the data completion reports.

Major Projects:

* Medical Device Excise Tax system. Helped develop, test, and

document then new MDET tax system for Stryker. This project

helped save the company about 40% of the tax owed by identifying

and reporting only the items that are considered Medical Devices

by the FDA.

Languages: VBA for Excel

Software: Encompass OLAP Cube, Microsoft Office 2007 and Excel

2010

Thresholds, Inc. Grand Rapids MI August 2010-

October 2012

Administrative Assistant (Support Staff)

* Filing, typing, data entry, create Excel and CMHC reports,

Receptionist for Lake Drive Office, Handle outgoing, incoming and

interoffice mail, coping, keeping office equipment supplied (with

paper, toner ect.) and fixing minor jams and problems for the office

staff.

Major Projects:

* Streamlined document creation using mail merge and writing reports

in AGS. This includes modifying and writing new reports off the

main database on a Unix system. Requested new fields and updated

the system so that work documents and excel reports could be run

off the main system rather than being retyped by hand.

Hardware: Unix and PCs, Copiers, Fax machines, Pitney Bowes

Mail machine.

Languages: Netsmart CMHC AGS report writer for the Unix system

Software: Netsmart CMHC, Windows, and Microsoft Office 2003

Manpower, Inc, Grand Rapids, MI December 2009-

August 2010

Office Assistant (Onsite at Thresholds)

* Filing, typing, running reports, coping, other duties as assigned.

* Worked for Thresholds as an office secretary, supporting Community

Placement, Respite services and general work for my supervisor.

SAF-HOLLAND, Inc. Holland, MI May 2007-November

2008

Business Analyst/ABAP Programmer

* Support On time delivery reporting, Payroll, HR, Sales reporting,

Bar coding for printers.

* Working with the following modules SAP SD, SAP HR, SAP MM, and SAP

FI.

* Major Projects:

* Modified a User Exit to capture delivery information in real time

for use in the Total Customer Satisfaction Report.

* For a Michigan tax audit requiring 4 years of historical sales

data, the Dart application in SAP was used to retrieve historical

information. Then Custom code in ABAP was written to combine

these files and information from the SAP FI module. The files

were then imported into Excel and combined using VBA to create

flat files in an acceptable format that could be given to the

state.

* Create initial Bar Coded Labels for Brazil office on Zebra

Printers.

* Helped with Unicode Conversion for SAP.

Hardware: Servers running SAP. Printers: Sato, Zebra, OKI

dot matrix, Avery Denison emulating zebra

Languages: SAP, Printer specific languages in SAP, VB for excel

Software: SAP 5.0, Windows, and Microsoft Office

Eagle Ottawa LLC, Grand Haven, MI June 1995-November

2006

Business Analyst/Programmer

* Support Sales Reporting, Cashbook, Positive Pay, Payroll (ADP),

Human Resources, and Data Collections. Help with Quotes, Accounting,

and Labor reporting as needed.

* Major Projects:

* Helped design and write a system to report Actual Sales vs.

Planned and Forecasted Sales for Accounting. This involved Data

warehousing from BPCS files on the iSeries midrange computer and

formatting and displaying data through use of Visual Basic

programming in Excel. This could then be accessed worldwide

through Citrix.

* Helped implement a positive pay system. This involved creating a

file to send to the bank each day with check number and amounts.

The bank then only cashes check that we actually wrote. This

prevents loss through fraud.

* Implemented packages to interact with banks and wrote in house

documentation specific to our company. These systems were

Cashbook out of Ireland for wire transfers and a Positive Pay

system using the internet to send information to our bank for

check number and amount verification.

* Assisted in implementation of Client Server BPCS CEA package. CEA

is the configurable enterprise accounting package. Wrote

translation tables and programs to convert data in BPCS 4.03 from

the current chart of accounts to a new global chart of accounts in

BPCS CEA 6.1. Tested and implemented currency conversion for CEA.

* Lead analyst on project to design, create and implement a Salary

Time and Attendance data collection system. This data together

with Grand Haven and Iowa facility time and attendance data was

converted to send to ADP payroll processing rather than run

through BPCS payroll. Processed payroll details were brought back

to the AS/400 for use in cost management and profitability

reporting and a program created to load data into BPCS G/L system.

* Helped design and implement a Voice call in line to report Tardy,

Sick, Vacation and other days off through integration of a PC

package and AS/400 database.

Hardware: IBM iSeries - RISC 530, PCs, and Data collection

terminals

Languages: RPG400, OS/400 Command Language, ASSET, and RPG ILE

Software: PCAL, BPCS 4.03, BPCS 6.1, Hawkeye, DBU, Windows 95,

and Microsoft Office

Northeast Petroleum a division of Cargill, Beverly, MA

Feb. 1995- June 1995

Senior Business Analyst

* Support Supply Applications on the AS/400 and support user IBM

AS/400 queries.

* Major Projects: Implement, train, and trouble shoot CMA Telex/Fax

System on the AS/400.

Hardware: AS/400

Languages: RPGIII, OS/400 Common Language, and SYNON

Software: CMA Telex/Fax System, Hawkeye, DBU, Rumba, and Lotus

Suite

Insta-Care Pharmacy Services (currently PCA), Woburn, MA

May 1993-Feb. 1995

Information Systems Consultant

* Supported all applications residing on the AS/400. Provided

customer technical systems support both in-house and at remote

office sites.

* Major Projects: Analyzed, designed, coded, and implemented a new

Medi-Span and Formulary System for the company. Managed a contract

programmer working on this project. Represented I.S. on the

Formulary Committee. Designed and programmed major enhancements to

the Prior Approval checking system for Order Entry. Completed

various real time order entry enhancements, including new edit

checks and changes to the Rx labels. Maintained and enhanced

Accounts Receivable reports and billing programs. Designed,

programmed and implemented a new security system for menu option

security.

* For the project to combine 3 environments, one aspect of this was

combining prescriptions from three areas of the country. We had 2

ways to do this. One would take 15 hours and the other only 5. I

thought we needed the extra checking taking 15 hours. My boss said,

if he could be convinced anyone could be hurt by using the faster

solution, he would let us do the extra checking taking 15 hours.

That night an example was created in which a patient could be given

the wrong prescription and kill him. The longer conversion was

programmed and completed. There may not have been a problem with

the faster solution but if there was it could have cost the company

in lawsuits and reputation.

Hardware: AS/400, IBM PC

Languages: RPGIII, OS/400 Command Language, LANSA (RMDL)

Software: Hawkeye, DBU, AmiPro, Windows for DOS

Atwood & Morrill Co. Inc., Salem, MA

November 1991-May 1993

Senior Programmer Analyst

* Supported all IBM Sys/38 and AS/400 systems. Provided both hardware

and software support for the company. Supported PCs and their

connections to the AS/400. Provided technical support for the

migration from the Sys/38 to an AS/400.

* Major Projects: System Migration from IBM Sys/38 to AS/400. Used

Advance Function Printing to create overlays to print data on forms

residing on the AS/400. Created a system to backup PCs weekly to

the AS/400 using PC support and DOS. Designed, programmed and

implemented a Heat number tracking system to interact with

Receiving. Modified Bill of Lading and Packing List Programs.

Enhanced and maintained Marketing reports and inquiries. Maintained

Purchasing and Requisitions systems including faxing notes directly

from a terminal.

Hardware: IBM Sys/38, AS/400, IBM PC

Languages: RPGIII, AS/400 Command Language, DOS

Software: Data 3, Abstract/Probe, Peek, DBU

Modicon Inc. (currently AEG Schneider Automation), North Andover, MA July

1988-Nov. 1991

Programmer / Programmer Analyst / Technical Programmer

* Designed, maintained, and enhanced payroll, human resources,

vehicle tracking and central materials systems. Worked with users

to analyze current systems, and designed and implemented system

changes. Supported user questions and problems as needed.

* Major Projects: Designed and programmed vehicle tracking changes

needed to meet IRS requirements. Programmed changes to the

interactive Maintenance program in ULTIMICS and wrote reports for

the cycle count system. Analyzed implementations of changes and

enhancements to human resources benefits system. Designed and

programmed changes to allow two FICA rates for payroll. Installed

new release of OS/400 and installed new disk drives.

Hardware: IBM Sys/38, AS/400, PCs

Languages: RPGIII, OS/400 Command Language, COBOL

Eaton Financial Corporation, Framingham, MA July

1986-July 1988

Junior Programmer / Programmer

* Wrote reports, designed and maintained menus, tested and maintained

credit applications system. Trouble shot software and hardware

problems with both the local and remote offices. Traveled to remote

offices for training.

Hardware: IBM Sys/38

Languages: RPGIII, IBM Sys/38 Command Language

EDUCATION:

Michigan Technological University, Houghton, MI

Graduated November 1985 with a Bachelor of Science in Computer

Science and Math minor.

HARDWARE/SOFTWARE:

IBM iSeries, RPG400, ABAP for SAP, CLP, PC, Windows 95, MS-DOS, Excel

and VBA in Excel. Unix, AGS.

Contact this candidate