Supply Chain/Human Resources/Payroll/Finance

Rowland Menka

**** ******* ****, **** *******, MN 55347 l Phone # 952-***-****, Cell # 952-***-**** l Email ac0mll@r.postjobfree.com

Experience and skills summary:

I have 27 years of diversified experience in Information Technology specifically in the Healthcare, Banking, Manufacturing and Financial industries. Out of these, 22 years are with Lawson in the following Lawson suites: HCM-Human Resources/Payroll/Benefits, Materials Management/Supply Chain/Requisitions Center/Purchase Order, Inventory Control, and Finance i.e. General Ledger and Accts Payable/Accts Receivable.

Worked with all of Lawson web deployable tools Ming.le, Portal, SEA and XML. Experience in LSF9, LSF10, Lawson Security, Lawson Process Flow, Websphere 6.x – 8.5.x. Have supported Lawson systems running the recommended databases that are part of a Lawson implementation i.e. ORACLE 8-12c, DB2 8-10.x, TDS 6.x and SQLServer 2000-2012 as well as developed/administered on the Lawson supported platforms AIX, Linux and Microsoft Windows.

Demonstrated the ability to manage multiple projects requiring technical and leadership skills which were incorporated within basic Project Management Methodologies to designing, developing and supporting software applications.

Main focus is to deliver software solutions that are robust without need for frequent modifications hence establishing customer confidence in their enterprise software system.

Upgrades:

oHave worked on many upgrades (7:08 to 7.23), (7.2.3 to 7.2.8), (7.28 to 8.01), (8.01 to 9.0), (9.0 to 9.0.1) and (9.0.1 to 10.0).

oRan the upgrades to move data over to the new versions and retrofitted custom programs and/or tables that might have been affected due to table and/or index key changes in the new version.

oCompleted analysis and requirements definition and code development/retrofits in preparation for a 10.0.x upgrade.

Technical experience/Key Skills:

Programming: Microfocus Cobol, UNIX shell scripting, Perl, JavaScript, PL/SQL, XML/HTML, Crystal Reports. Considerable experience trouble shooting Lawson applications and UNIX admin issues. Written many extracts/imports to Healthcare Benefit providers, Banks, Talent Management firms e.g. SuccessFactors and onboarding vendors e.g. Peopleclick.

JAVA and Visual Studio .NET - training only.

Tools: Lawson Case Tools, Lawson Portal, Lawson Design Studio, Lawson Process Flow,

Lawson Business Intelligence, Lawson Mobile Supply Chain, Lawson 9.0/10.0 Security,

IBM WebSphere, Kronos, Handheld administration for Mobile Supply Chain.

Currently developing in Infor MSP 10.0.7/ESP 10.0.9.

Operating Systems: UNIX-AIX, HP, Sun Solaris, Windows-XP/NT/2008(including VMware),

Databases: Oracle 11g/10g/9i/8i, DB2, Access

Implementations/Conversions:

oImplemented Lawson’s MSCM Point Of Use system that uses Lawson items to create cases for patients admitted and scheduled for surgery through EPIC’s ADT HL7 segments that flow into Lawson via Cloverleaf.

oWritten many conversion programs to facilitate loading data using standard Lawson load programs vis a vis creating extracts from Lawson to interface into other systems.

oDeveloped numerous programs to cleanse data in anticipation of Lawson upgrades.

Custom Development/Support:

oHave developed Process Flow applications and of particular note was a Lawson Process Flow system that synchronizes name changes via Personnel Actions in H.R. with Lawson’s LDAP platform. The Lawson Security Administration application reflects these updated names without the need for manual intervention since they have already been updated in Lawson’s LDAP via the Process Flow application.

oUsed Design Studio to customize Lawson screens to fit user’s business needs as it relates to the placement of fields on the Lawson screens.

oWrote programs to create extracts for Benefit Plan/Health Insurance companies using Cloverleaf as the medium to send these files to the vendors. Used Perl and UNIX scripts to render these files in the format expected by the vendor.

oDeveloped numerous batch and on-line programs using Case/4GL tools and MicroFocus Cobol to satisfy customer needs e.g. developed custom version of PR35 Time Entry screen to set focus to particular key fields, sum up and display hours and wages differently and change the look of the folders.

oHave also made minor modifications to ESS/MSS portal apps via HTML and JavaScript to change the look of some of the portal pages.

oSuccessfully customized Cessna’s Lawson Order Entry system particularly OE30 to facilitate their business ordering functions which didn’t quite fit the standard Lawson OE30.

oExperienced in Lawson Database Administration and have created numerous custom tables and indexes to suit business needs that Lawson didn’t.

oOn a rotational 24 hour on call support for all Lawson applications as well as performing Lawson System Administration functions to limit disk usage as well as prevent java memory leaks by using IBM WebSphere to monitor memory usage.

oConstantly review IOS logs, MSCM logs latm and ladb logs when tickets come in for issues created by users to help resolve these tickets.

oUsed Toad and SQLPLUS to view data that is causing errors in the Lawson applications to help determine a fix for the issue.

oHave successfully implemented numerous patches to keep current with Lawson application and ESP versions in addition to facilitating the installation of year end patches for W2s and 1099s.

Professional Experience:

Independent Contractor Central Maine Healthcare/Infor May 2017

Implementing MSCM version 10 Cloud suite for Central Main Healthcare.

Independent Contractor at Mayo Clinic June 2016 to April 2017

Coordinating converting Mayo’s FTP processes in and out of Lawson to SFTP as part of a 9.0.1 to 10.0.7 upgrade of Lawson. Developing custom code in the Infor 10 Requisitions and Purchase Order suites to produce Requisition Acknowledgement files to be sent to customers/vendors. Helped customize the Login portal page in Infor 10 to match Mayo’s custom Login screen that was used in the Lawson 9.0 system.

Independent Contractor at HealthPartners January 2015 to June 2016.

Working on merging the Lawson H.R./Payroll, Benefits, Materials Management and Finance systems of HealthPartners and Park Nicollet after a merger of both companies. This includes an upgrade to Lawson System Foundation version 10.0.6.

Sr. Systems Analyst, Park Nicollet, Minneapolis, MN October 2000 to December 2014.

Park Nicollet is one of the leading health care providers amongst Minnesota’s healthcare providers.

Technical role:

My main focus is to provide excellent support to our customers at the hospitals and clinics as they use the Lawson system in their day to day operations.

Successfully implemented a Lawson MSCM Surgery Case system that started as a beta project and culminated into a live system over the course of 3 years working with Lawson. The system creates cases for patients entered into the Epic system for upcoming surgery using Lawson items and bills patients accordingly for usage. This information is fed back into Epic for billing purposes.

Resolved issues customers had using Lawson’s Requisitions Center or Materials Supply Chain Management/Handhelds suite as they created purchase orders through the approval, receiving, matching and invoice payment processes. Very knowledgeable about the Purchase Oder tables and their relationships to General Ledger, Inventory Control and Accounts Payable.

Successfully developed a Lawson Process Flow on boarding system to synchronize name changes made in HR11 – Lawson’s employee on boarding screen by daily updating Lawson’s Security LDAP system with that information.

Troubleshoot issues with handhelds and data transfer to the MSCM system utilized by the Procurement group.

Responsible for installing CTPS that are deemed necessary for our customers including year end patches for Payroll and Finance.

Designed and developed numerous programs that send information to our vendors e.g. Benefit files for Open Enrollment, Freight Charge files to a vendor for analysis to minimize the freight cost of items procured by the Materials department.

Other modifications involve interfacing data back into Lawson from our vendors that host applications for us e.g. Peopleclick which is used by aspiring applicants to the Park Nicollet workforce.

Customization of Lawson programs copied and renamed to satisfy specific demands by customers that the canned programs did not provide have also been done.

I worked with Moore-Wallace /NEPS to integrate their Laser Check processing software with Lawson’s Payroll system creating positive pay and ACHs that are transmitted electronically over the internet to our bank.

Minor Kronos administrative experience in configuring electronic time clocks and in monitoring our Kronos servers to prevent performance issues.

On call rotation and resolving problem tickets using HP service manager.

Lawson Systems Administrator Backup, Park Nicollet, Minneapolis, MN October 2000 to December 2014.

Served as back up to our Lawson Systems Administrator, recycling IBM Websphere servers, Lawson’s LDAP http web servers, monitoring UNIX disk usage, Lawson system ios and ladb logs and also IBM Websphere logs to help prevent memory leaks.

Ran upgrades from Lawson 8.x to 9.x. and installed patches.

Installed Lawson Materials Supply Chain Mgt/Point of use 9.x/10.x versions.

Sr. Software Consultant, Analysts International Corporation, Minneapolis, MN January 1995 to October 2000.

Analysts International is a consulting firm that was a gain partner to Lawson now Infor.

Technical role:

Successfully designed and implemented extensive customizations for Lawson’s clients that needed specific functions in their Lawson system that the canned system did not provide. The most challenging of all was being part of the Cessna project which involved basically rewriting most of the Order Entry system to suit Cessna’s needs. The system's fundamental purpose was to help CESSNA keep track of airplane parts that were received into or sent out of its warehouses and also assign the responsibility of maintenance and charges to appropriate parties.

Consulted at Lawson Software’s Center of Excellence for Analysts International Corporation helping clients resolve critical payroll down scenarios. Was also heavily involved in helping clients overcome technical issues as they processed their daily business functions utilizing the Lawson suite of products. Taught clients how to use Lawson’s CASE tools and Microsoft COBOL’s debugger/animate utility to solve these issues. Helped direct clients with their conceptual modeling/analysis when customizing Lawson code was essential to the client.

Software consultant, DRT Systems International, Chicago, IL March 1994 to December 1994.

DRT Systems was an independently operated business unit of Deloitte Consulting that provided systems development and integration in the U.S. and Canada.

My roles:

Technical role:

Was part of a consulting team at the Bradford Exchange, a Collectibles/Antiques Exchange that maintained the first release of a Marketing system converted from COBOL to Natural/Adabas. The system was heavily tied into Sales Tracking, Consumer Response and Inventory Control.

Also added new functionality to their Sales Tracking system by allowing customers to view at a glance, summarized information pertaining to all their Marketing activities e.g. total revenues per month, per product etc. vis-a-vis promotions of a product.

Was responsible for linking all mainframe databases to a Visual Basic application at the PC level. This was done by transferring data from the mainframe to the PC via NATURAL CONNECTION as the file transfer protocol. The data was then manipulated with enhanced graphics to provide the customer with live data on PC's under a Local Area Network.

Systems Analyst, William Mercer, Deerfield, IL January 1993 to December 1994.

Mercer a Marsh McLennan company is a global leader for trusted HR and related financial advice, products and services.

Technical role:

Responsible for interfacing 2 accounting systems that allocated resources and billed clients of Mercer's Human Resources and Benefits packages. NATURAL/ADABAS and SUPERNATURAL were the main development tools.

Independent Consultant, Coopers&Lybrand, Waste Management, Oakbrook, IL January 1992 to December 1993.

Waste Managament is a leading hauler of permanent waste removal and recycling services.

Technical role:

Consulted at Waste Management of North America. Was involved in the design and implementation of the client’s National Accounting Billing system. A top down structured approach was used to extract data across a variety of ADABAS tables. The data was then used to generate billing reports via NATURAL. Played a very important role in determining the most efficient access method to the tables and wrote the detailed specs as well as the programs.

Systems Analyst, Inland Steel, Chicago, IL February 1990 to December 1991.

Inland Steel is a steel manufacturing company.

Technical role:

As a Systems Analyst with Inland Steel, developed and enhanced COBOL and NATURAL/ADABAS applications for an Inventory Tracking System. The system tracked orders for steel from heavy industry and ensured that these orders were met on a timely basis.

Consultant, First National Bank, Seymour, TX, August 1987 to August 1989.

First National Bank is a Federal Savings Institution and is a member of the Baylor Bancshares group of banks headquartered in Seymour, Texas.

Technical role:

As a Consultant with First National Bank in Seymour, Texas, I was responsible for automating the manual process of posting Trust Accounts into a micro-computer environment. The computerized system produced on-line help for viewing assets and generated financial statements on request.

Education:

M.Sc. - Computer Science -1989, Baylor University, Texas.

B.B.A – Computer Science - 1987, Hardin-Simmons University, Texas.

Activities.

Weightlifting, jogging and auto crossing.

References.

Will be furnished upon request.

Salary.

Negotiable.

Contact this candidate