The Senior Systems Analyst will demonstrate and maintain a complete understanding of the Lawson Material Management applications. Identify ways to fully utilize Lawson with other systems to meet the needs of Materials Management and Accounts Payable. Analyze business needs to improve processes and develop efficiencies. Develop scripts for interfaces between Lawson and other systems. Deep understanding of Lawson Vendor, Item, EDI setup and maintenance. Develop test scripts and test system upgrades and patches.

Principal Responsibilities and Tasks

The following statements are intended to describe the general nature and level of work being performed by people assigned to this classification. These are not to be construed as an exhaustive list of all job duties performed by personnel so classified.

1. Lawson System
   • Monitor and research system capabilities for ongoing improvement/enhancement possibilities to the AP/MM Departments.
   • Meet with proper parties to develop tools to meet their needs.
   • Review and update MM & Procure-to-Pay Work-flows to best support the needs of the Department.
   • Monitor interaction of related systems (AP and MM) to determine most efficient use.
   • Utilizes FTP server.
   • Understands and assists with Electronic Data Interface (EDI) issues, setups and testing. Contact and work with vendors and GHX.
   • Review all jobs associated with EDI are completed.
   • Track and reports EDI errors; support AP with EDI issues.
   • Maintains the Vendor Master files. Creates & revises inventory PAR locations, as required.
   • Maintains miscellaneous files/tables in Lawson.
2. Interfaces, & Processing Scripts.
   • Develop interfaces between various systems; monitor and maintain interfaces appropriately.
   • Evaluates, test, implements system upgrades, enhancements, and updates in Lawson test environment.
   • Write/develop and maintain interfaces and processing scripts as necessary to automate file exchanges. Interfaces and scripts need to have fail safe control points, failure notifications and data error identification.
   • Write/develop automate scripts for job processing activities.
   • Write code to run jobs and exchange data on various UPHS servers, write code to schedule jobs directly from servers.
3. Reports
   • Creates, maintains and revises Supply Chain Solutions performance dashboard
   • Develop and create new reports to analyze data.
   • Assist with the archiving of reports and data.
   • Develop reports to monitor and ensure accuracy of data coming in and out of Lawson (including EDI transmissions).
4. Other
   • Download reports and format them as requested.
   • Develop queries in SQL, MS Access or Oracle on as-as needed basis to support the operational needs of Materials Management/AP.
   • Develop forms, reports or macros in MS Access on as-needed basis to support the operational needs of Materials Managements/AP.
   • Develop and schedule FTP commands on as-needed basis to support the operational needs of Materials Management/AP.