Senior System Analyst, Supply Chain - University of Maryland Medical System

This is a remote position, with the expectation of attending monthly or quarterly meetings onsite in Linthicum, MD.

The University of Maryland Medical System (UMMS) is an academic private health system, focused on delivering compassionate, high quality care and putting discovery and innovation into practice at the bedside. Partnering with the University of Maryland School of Medicine, University of Maryland School of Nursing and University of Maryland, Baltimore who educate the state's future health care professionals, UMMS is an integrated network of care, delivering 25 percent of all hospital care in urban, suburban and rural communities across the state of Maryland. UMMS puts academic medicine within reach through primary and specialty care delivered at 11 hospitals, including the flagship University of Maryland Medical Center, the System's anchor institution in downtown Baltimore, as well as through a network of University of Maryland Urgent Care centers and more than 150 other locations in 13 counties. For more information, visit www.umms.org.

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.

Education and Experience

• Bachelor’s Degree in Business Administration, Finance, Accounting or related field.
• Minimum of five (5) years of experience in a related area (e.g., IS, Supply Chain/Materials Management, Accounts Payable, etc.).
• Experience with Information Systems and Supply Chain/Materials Management is preferred.

Knowledge, Skills and Abilities

• Expertise in MS Access, Excel, and Word.
• Basic knowledge of SQL server and File Transfer Protocol.
• Experience with Crystal Reports or Report Writer preferred.
• Comprehensive knowledge of ERP related systems or Material Management applications.
• Knowledge of standard office computer systems
• Knowledge of standard office desktop client software such as Microsoft Office
• Must have excellent Problem Solving and Analytical Thinking skills.
• Must demonstrate flexibility.

Working Conditions

• Weekend, shift work, holiday, on-call, and may be require work beyond normal tour of duty to complete projects, meet deadlines, or respond to emergencies.
• Work is performed in various environments within UMMS. These environments include, but are not limited to the following: a standard office environment, Data Center/closets environment, or Healthcare environment.
• Periodic traveling out of town with overnight stays to obtain required training, education, or certification may be required.
• Work may include regular travel to and from the various affiliated institutions within the Medical System.
• Work may be required in a Healthcare facility which the observance of “Universal Precautions” is mandated. Universal Precautions involves the wearing of protective clothing/equipment and the observance of safe work practice.
• Work is high demand and fast paced.

• Monitor and troubleshoot EDI transactions to resolve errors promptly.
• Provide support in mapping, testing, and onboarding new EDI partners or vendors.