Alan Millar Email & Phone Number

Portland, Or, Us

North Plains, Oregon, United States

Portland, Oregon Area

• Supported SAP ECC and related applications. ◦ Implemented Winshuttle Studio and Foundation. Built Winshuttle update scripts to automate SAP master data and sales order entry/maintenance. Built web request forms with workflow for customers and materials in Winshuttle Foundation. ◦ Designed and built master data quality monitoring. SAP Data Services/BODS ETL and Information Steward data quality reporting, covering SAP plus other applications. Implemented 340 data quality rules covering 1 million+ records; led cleanup process which improved data quality from 85% to 94%. ◦ Built master data conversions to SAP ECC using Data Services ETL; converted 500k+ records for successful go-live. ◦ Wrote and maintained 40+ custom interfaces between SAP, internal applications and external service providers via Linux shell and Perl scripts.• Project manager for information systems implementation at 2 new manufacturing plants. Analyzed plant needs, coordinated team on implementation of IT infrastructure, applications and policies. Successful implementation on schedule.

Portland, Oregon Area

• Supported Lawson/Infor S3 ERP.• Designed and built interfaces to in-house applications and external vendors.• Built automation using Unix shell scripts, Perl, and Lawson ProcessFlow, for testing and system maintenance. Modified/enhanced Lawson code.• Team leader for two major Lawson upgrades. Managed testing process, modifications, and cut-over.• Built custom SQL database conversion scripts for Lawson upgrades and migration from Informix DB to IBM DB2. Reduced migration down-time from 4 days to 2.

Portland, Oregon Area

• Supported Lawson/Infor S3 ERP. • Designed and built interfaces to in-house applications and external vendors. • Built automation using Unix shell scripts, Perl, and Lawson ProcessFlow. • Implemented Lawson upgrades and patches.

Portland, Oregon Area

• Unix system administrator for HP/UX, Linux, and Sequent Dynix systems supporting Lawson ERP and Data Warehouse applications.• Managed and optimized IBM DB2 and Informix databases on HP/UX.• Unix shell and Perl script automation. • Storage management on HP EVA SAN disk array, LVM RAID, JBOD, LTO tape. • Planned and implemented HP/UX OS and hardware upgrades. • Built and tested dual data-center architecture for disaster recovery using HPUX VPARs. • Project planner for Internet & WAN changes. • Planning and enterprise architecture design for Unix, VMWare ESX, Windows disaster recovery, tape backup systems, SAN.

Portland, Oregon Area

• Network manager for 90-site frame-relay WAN with Cisco routers. TCP/IP and IBM SNA protocols. ISDN, T1/T3, telecommunications vendor management.• IP address management, DNS, DHCP.• Managed network bandwidth and usage using SNMP and open-source monitoring tools on Linux including MRTG and BigBrother.