Erp Manager/programmer Resume
Portsmouth, NH
Professional Skills:
Substantial experience in IT including all aspects of SDLC, Change Management, data flow diagrams, functional and design specifications, system architecture, disaster avoidance, testing, batch and on-line, closed-loop controls, security, and documentation.
Demonstrated expertise in ERP; Manufacturing; Distribution; CRM; Supply-Chain; EDI; Accounting; Sales and Forecasting; Data Warehousing; and interfacing outside systems.
Experienced design and coder emphasizing ease-of-use, maintainability, detail and testing.
Technical Skills:
- RPG through RPG ILE, some RPG Free, CLP, SQL, Lotus script, some COBOL and JCL.
- Minor mods in Delphi, PLC, java, C++, HTML, web-sites, PHP, Visual Basic, and AS/SET.
- DB2, journaling, FTP, TCP-IP, VPN, RF data collection, TLAshford bar coding, Extol, Elite, Crystal Reports, FAX/400, ROBOT, ShowCase, MKS Implementer, Turnover, and Hawkeye.
- Lotus Notes/Domino administration, Lotus script programming, some Linux, CITRIX.
- Windows, EXCEL, WORD, MS Project, MS/Access, QualEDI, Track-IT, and Monarch.
- BPCS, MAPICS, DMAS, Data3, Hyperion, Software 2000, Lawson, MOMS,
Accomplishments:
Coded replacement of EDI 846 transaction through GXS/iNovis to web-based upload to save $7000/mo; coded real-time generation of manuf product availability; implemented Order Tracking using bar codes and RF-devices to get location of customer’s order and predict receipt date; coded UPS Manifest system removed errors costing $5000 per month; re-writing a Payroll system uncovered fraud; coded A/R interface bank deposits; design/coded contract orders with variable frequencies; managed/coded conversions without disruption; and EDI systems for 810, 850, 856, etc. with improved diagnostics.
Supervised programmers, consultants, network engineers, operators; responsible and hands-on with computer equipment/operations (CPUs, printers, commun lines, and phone systems; upgrades to hardware and operating systems); and reconfig of communications networks.
Hardware:
- IBM Systems (esp. AS/400 or iSeries), PC, MAC, LAN, routers, MQSeries, firewalls, printers and phone systems. Capacity/Performance Planning and Configurations.
- Data Center design, relocation, wiring, upgrades, back-ups, and disaster recovery.
Work Experience
Confidential Rochester, NH
DP Manager/Programmer2011-2012- Automated QualEDI, order allocations, invt’y, day-end, etc. to improve accuracy and speed.
- Upgrade of RPG2-RPG IV on legacy systems to RPG-ILE and SQL on Power7.
- Increased security-level from 20 to 30, implemented joblogs, journaling, and back-ups.
- Managed Microsoft Windows SBS Server authority, back-ups, connectivity, etc.
- Barcoding, RF scanners, printers trouble-shooting for demanding drop-ship environment.
- Interface with web-site powered by Magento, UPS WorldShip, etc.
- Improve accuracy of physical inventory software/procedures and eliminate down-time.
- Upgrade AS/400 to Power7 and installed several release-levels of operating system PTF’s.
- Modified over 100 programs to transform business from Re-Sellers to Drop-Ship.
Confidential Portsmouth, NH
ERP Manager/Programmer2005-2011- Coded improvements for auditor compliance with Sarbanes-Oxley (SOX), audit security changes, MKS change management, in a BPCS RPG IV environment (some RPG-ILE).
- Enhance BPCS software with modifications outside the package’s code. Interfaced EDI to receive orders from distribution. Interface with Logility forecasting and Global financials.
- Handled all user problems and made program fixes so they never happened again.
- Design/coded Material Test Reports loaded from customer’s FTP servers to our web-site.
- Coded AS/400 Elite software to interact with programs to send e-mails if there are exceptions, or attach an AS/400 report to an e-mail for on-the-road users.
- Reduced downtime and user delays via programming and message handling.
- Trained ShowCase and Crystal Reports to users so they can do their own research.
Confidential. Burlington, VT
DP Manager/Programmer 1997-2005- Design/coded over 100 programs for invt’y control mod of BPCS at box-level while maintaining the integrity of Lot Control and ease of searches for shipments in RPG/400.
- Use of PLC’s, robotics, automated conveyor/scale/printer to load inventory weights for each box and printing bar codes with the variable information.
- Install, configure, manage and administer Lotus Notes/Domino server, e-mail messaging systems and their corresponding software and hardware. Provide technical support for end users. Support efforts for remote users. Manage migration to newer Lotus Notes versions.
- Coded several hardware and data conversions when acquiring other companies.
- Managed conversion of Novell to Linux to Windows Servers.
- Initiated and interfaced CITRIX to reduce communication issues and improve speed.
- Led 5-plants to use cycle-counting to replace physical inventory and improve accuracy.
- Coded FAX/400 send e-mails of exceptions and fax customer/supplier order confirmations.
- Trained IQ query report-writer to users so they can do their own research.
- Coded help desk function in Lotus script improved problem-resolution 75% faster.
- Installed ROBOT and implemented the automation of over 100 reports and daily functions.
- Moved data center from Delaware to Massachusetts to Vermont.
Confidential Bear, DE
DP Manager/Programmer 1993-1997- BPCS ERP modifications/enhancements to over 18 modules using RPG III.
- Installed PC-networks for engineering at 3 locations.
- Coded Monarch to convert AS/400 reports into EXCEL to make usable for calculations.
- Upgraded new releases of OS/400, new AS/400 models, etc.
- Constructed test environment and wrote Change Management system.
Education
- BA - Economics/Political Science
