Human Resources Sales
Resume:
Erin L. Neprud
Hudsonville, MI 49426
****.******@*****.***
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