Post Job Free

Resume

Sign in

Lawson ERP Consultant, Data integration and conversion

Location:
Colorado
Posted:
November 03, 2017

Contact this candidate

Resume:

Douglas E. Buss

*** **** **** ****

Montrose, Co. 81403

970-***-****

E-Mail ac2389@r.postjobfree.com

EXPERIENCE:

August 2009 – Present

Consultant – Bridgestone, Cleveland Ohio, Chicago Illinois and Nashville Tennessee

Roles include: Development, Architecture, Design, Technical Leadership and Project Management

Current projects:

1)Functional and Technical design and development of a new Bank BAI file integration and reconciliation application using Lawson’s Cash Book application

Recent projects included

2) Interfaced SAP/MDG applications with Lawson using SAP Java server programs and Lawson java based APIs.

SAP will originate master data such as Vendors and the Vendors will be set up in Lawson with calls to AP10, AP16, etc…

3)Developed standardized AR cash application uploads into Lawson

Technical lead of a JDA and supporting systems upgrade

Design of a supporting development and production Oracle infrastructure

Plan, organize, monitor as well as participate in the migration/conversion of over 1000 unix scripts, sql scripts from HP/UX Oracle 9 to IBM/AIX Oracle 11

Integrated a third party workflow application with Lawson AP

Design and development of interfaces between the external solution and Lawson systems

oExtract of Lawson system reference data that is sent to the provider

oInterface EE, AP and MA invoices into Lawson

oExtract of Lawson transaction data that is sent to the provider

Interfaced employee commission and bonus compensation to Dayforce

Design and development of interfaces between in house systems, SAP and Dayforce

Real estate management systems integration with Lawson

Design and development of interfaces between a third party lease management system

oLawson AR, AP and GL

oInterfaces are two way between the third party system and Lawson

Organization Re-org

Designed, and developed conversion processes to merge two companies together

oFinancial and Supply chain applications

POS and Credit Card Processing

Developed interfaces to Third party Credit Card processors

Developed interfaces from Third party CC processors into Lawson AR

Supply Chain Projects (Order to Cash – OTC)

Interfaced Lawson Taxation with SABRIX

Interfaced Lawson with SAP (GL and Billing)

Interfaced Lawson with JDA PMM (PO and Receipts)

Implemented new invoice interfaces (including ERS)

Revamped PO, Invoicing, Receipt processing

Upgraded Lawson 8.0.3 applications to 9.0.1

Updated/Enhanced custom 4GL programs and user exits

Updated/Enhanced shell scripts and Oracle/SQL scripts

Application suites involved GL, IF, AC, AM, AP, PO, MA, RQ, IC, CB, AR

Implemented Process Flow – Custom flows or enhancements to Canned flows supplied by Lawson

Continued production support of recently upgraded applications

Applied CTPS and MSPs

Lawson Advanced Technology Products: Oracle PL/SQL, Unix scripting, Oracle/SQL, Lawson 4GL, JAVA

Roles include: Developer, Designer, Business analyst, and Technical lead There is a strong technical bias in the roles I perform. However, I work closely with the business community in ensuring their needs are met, and technical solutions are in line with their future direction.

March 2008 – May 2009

Consultant – Schneider National, Green Bay Wisconsin

Performed a Lawson to Oracle EBS (Ebusiness Suite) conversion and a Lawson Payroll to ADP conversion

Acting as a technical lead, designed and developed conversions and interfaces between Lawson and Oracle EBS

Acting as a technical lead, designed and developed conversions and interfaces between Lawson, Oracle EBS and ADP

Developed and implemented Oracle event alerts (back dated, current and future dated transactions)

Developed changes to Lawson AP interface programs that will allow batch updates (Feature not available with vanilla Lawson)

Application suites involved AP, CB, AR, HR, ESS, BN and PR

Tool sets: Oracle PL/SQL, Unix scripting, Oracle/SQL, Oracle ODI, Lawson 4GL

March 2008 – April 2009

Consultant – Wegmans, Rochester, New York

Converted over 100 Informix/SQL programs to Oracle SQL

Migrated Lawson environment and HR/PR applications from 8.0.3.x to Lawson LSF 9.x

Lawson Advanced Technology Products: Oracle PL/SQL, Unix scripting, Oracle/SQL, Lawson 4GL

February 2007 – December 2007

Consultant – McDonalds Corporation, Oakbrook, Illinois

Performed a Lawson 9.0 applications and 9.0 technology upgrade:

Developed customized enhancements to the Lawson HR/PR application suite

Developed data conversion and validation processes that aided the 9.0 upgrade, including LDAP user ID loads and maintenance

Developed customized enhancements to the Lawson ESS application

Integrated ACH into Manual Payments

Lawson Advanced Technology Products: Lawson 4GL, Microfocus Cobol, Unix scripting, Java Script, Perl, C, Oracle/SQL, PL/SQL

August 2005 – February 2007

Consultant – Schneider National, Green Bay, Wisconsin

Provided technical leadership on the following projects:

Implemented Realtime7 Point of Sale software and integrated POS data with Lawson back office applications (AP, PO, IC, PR, HR, GL)

Integrated MQSeries into Lawson 4GL (Microfocus Cobol) programs– MQ queues were used to send and receive data with external applications (replaces the need to buy Lawson Business Integration products)

Implemented custom Lawson applications

Developed custom purges of HR, PR, AR, and AP data, and archived selected data to Oracle 9i databases

Day to day production support of Lawson applications

Lawson Advanced Technology Products: Lawson 4GL, Microfocus Cobol, Unix scripting, Java Script, Perl, C, Oracle/SQL, PL/SQL

June 2004 Thru August 2005

Consultant – Schneider National, Green Bay, Wisconsin

Converted Lawson application suites (PR/HR/BN/PA/ESS/PO/BL/GL/AP/AR/IC/IA/MM and others) from 8.0.2 to 8.1 (Lawson 9.0)

Technical Lead – Managed the tasks of 5 technical and several business resources

Conversion technical design, development and test

Developed custom PL/SQL conversion processes

Handles large volumes of data, critical time constraints, unique business requirements (500 GB of data converted and validated in 8 hours)

Lawson application enhancements/modification design and development

Lawson Advanced Technology Products: Lawson 4GL, Microfocus Cobol, Unix scripting, Java Script, Perl, C, Oracle/SQL, PL/SQL

Other 2005 Projects

Consultant - McDonalds Corporation, Oakbrook, Illinois

Consultant - Wilsons Leather, Minneapolis, Minnesota

Consultant - Wegmans, Rochester, New York

Developed custom PL/SQL applications

Lawson application enhancements/modification design and development

Integrated Intelligent Search applications into Lawson applications

(Microfocus Cobol, Oracle 9i, SQL/Plus, PL/SQL, IBM/AIX, HP/UX, Lawson 8.x HR and PR, CorrectAddress).

January 2003 Thru November 2003

Consultant – Johnson & Johnson, New Brunswick, New Jersey

Converted Lawson HR/PR application suite from 7.2.4 to 8.0.3.

Conversion technical design, development and test

Developed custom SQL conversion processes

Consolidate and reengineer data based on 8.0.3 requirements

Handles large volumes of data, critical time constraints, unique business requirements

Consultant – Johnson & Johnson, New Brunswick, New Jersey - Continued

8.0.3 Lawson application enhancements/modification design and development

Incorporated into the native Lawson application functionality that is required by J&J, ie. (gross up, adjustments, etc…)

General Ledger Enhancement

Designed and developed a Payroll and General Ledger reporting database and queries

(Lawson HR/PR/BEN/4GL, Microfocus Cobol, Oracle 9i, SQL/Plus, PL/SQL, TOAD, HP/UNIX.

October 1998 – December 2002

Consultant - McDonalds, Chicago, Illinois

Converted Lawson HR/PR application suite from 7.1.2 to 8.0.2.

Responsibilities included:

Software product research, Systems design and Data Analysis

Reengineered current and historical data

Maximize 8.x functionality

Minimize and simplify McDonalds custom enhancements/modifications

8.0.2 Lawson application enhancements/modification design and development

Common derivation routines between Lawson and IPS front end

Ensure data quality by deriving 20+ critical data elements

Minimally invasive modifications that provide for ease of maintenance and future flexibility

Develop functionality that is required by McDonalds that is not supported by the native software product, ie. (gross up, adjustments, check replacement, accounting, etc…)

Handles large volumes of data, critical time constraints, unique business requirements

Conversion technical design, development and test

Developed a solution that met McDonalds time, quality and data restructuring requirements

Developed a data extract process that allowed the five member test team to conduct a full scale two month parallel test. This allowed for every data and business logic component to be fully exercised.

Developed enhancements to Lawson applications

Responsibilities included: technical design, data analysis, program design and development, test,

conversion and implementation. (Lawson HR/PR/BEN/4GL, Microfocus Cobol, Oracle Pro-Cobol, Oracle, PL/SQL, IBM/AIX/UNIX TOOLS).

Excel spreadsheet interface to the Lawson application

Process large quantities of data

Easy and familiar data entry tool

Used in day to day operations and large scales projects, ie. Restructure and year end processes

W2 sub application

Maintenance and trouble free programs that extracts and provides Lawson data to McDonalds custom W2 system

Day to Day Production support

Queries, data fixes, problem analysis, continuation of enhancements and modifications,

Test data extract, Employee merge application (merge one to many employees to new employee), ACH from Manual Check process

June 1998 – September, 1998

Consultant to Ernst & Young/Sprint, Kansas City, Kansas

Designed and developed an application that integrates external interfaces/EDI into the Peoplesoft AP application. Responsibilities include: technical design, data mapping, table design, program design and development, test and conversion. (Peoplesoft AP, Peopletools, COBOL, DB2, TSO and utilities).

February 1998 – June 1998

Consultant to Penn Traffic Corporation, Syracuse, New York

Implemented Lawson HR/Payroll and Financial applications. Deliverables included: design and development of interfaces and application enhancements for the AR and AP application systems, development of financial reports and design and development of HR/Payroll data conversion processes and programs. Mentoring/training project personnel. (IBM AIX, Windows NT, INFORMIX, CRYSTAL Reports, ESSBASE, Microfocus COBOL, Lawson Universe/Utilities and Data Junction)

September 1997 – January 1998 - Consultant to Computer Sciences Corporation, Richmond Virginia

Performed the conversion and implementation of the Lawson H.R./Payroll application suite (version 7.0.4). Deliverables included: managing a programming staff of five, infrastructure design, interface/report design and construction, training the application staff, planning the test(s) and implementation, coordination of multiple teams, quality assurance, data conversion and extracts, and SAP A/P and G/L interfaces design and construction. (HP/UX, Oracle, Microfocus Cobol, Lawson Universe/Utilities, Data Junction)

March 1996 – August 1997 CLAREMONT TECHNOLOGY GROUP, Bellevue, Washington

Projects

May 1997 – August 1997 The Regence Group, Seattle, Washington

Responsibilities:

Performed the conversion of a legacy H.R./Payroll application to the Lawson H.R./Payroll

Application suite. Deliverables include: data mapping, conversion routines, test and

implementation. (Unix, Oracle, Access, Data Junction, Monarch, Lawson Universe/Utilities, Micro-

Focus Cobol)

Jan. 1997 - April 1997 - Weyerhaeuser Building Material Division, Federal Way, Washington

Responsibilities:

Analysis of Weyerhaeuser Building Materials Division’s Warehouse Management and Financial functional areas as part of an overall custom software development project. Deliverables included: External Design, Business and Process objects, Use Cases and Logical Data Model(S-Designer, M/S Access).

Claremont Technology Group Continued:

March 1996 - December 1996 - Merix Corporation, Forest Grove, Oregon and Loveland, Colorado

Responsibilities:

Managed and performed tasks that were required for the successful migration and implementation of a custom developed Multi-tier Client/Server Manufacturing and Shop Floor tracking system. Deliverables included:

Developed a data translation map from the systems being converted to the new application’s Data Architecture

Developed, tested and implemented programs and processes to transform, create and migrate data(Oracle PL/SQL, Powerbuilder, COBOL, SQL and Oracle Database Utilities, AskPlus, HP3000/MPE, VAX/VMS, HP/UX, Windows/95, Windows/NT)

Developed conversion methodology and plans

Participated as a member of the client project team, partial activities included: developed training requirements and alternatives, identified and developed new business processes, assessed and recommended client specific infrastructure enhancements, assisted in developing the project team and project tasks, promoted and demonstrated the new application to the client

Coordinated the implementation and testing of the new technical infrastructure

Managed the implementation.

November 1994 - March 1996 Consultant to PHH Vehicle Management Services, Hunt Valley, MD

Managed multiple projects in support of an enterprise support strategy. Responsibilities include:

Management of project personnel

Development and management of the project budget

Development, organization and training of a client/server operations function

Defined, developed and implemented processes and enabling technologies required for production control, configuration management, software change management and software distribution.

Consolidated multiple test environments and developed effective test approaches

Enhanced reporting and decision support technology

Re-engineered and tuned application systems

Improved the process used to forecast computer resource utilization.

Served as the liaison between the Information Services organization and the provider of computing resources. Responsibilities included:

Forecasting resource utilization

Strategic planning of mainframe, client/server and network technical architectures

Managing Service Level Agreements and the cost of computing resources.

August 1994 - November 1994 Consultant to First Data Corporation, Omaha, Nebraska

Supported credit card processing application software integration and implementation at a client location. Pre and post-implementation activities included:

Coordinating software releases and requirements

Integrating application with client’s and other vendors(VISA) applications

Customization of the packaged application code (DB2, CICS, COBOL II, TSO/ISPF, ROSCOE, MVS/ESA)

Implementation

January 1994 - August 1994 Consultant to MCI Software Engineering, Colorado Springs, Colorado

Developed application software in support of MCI’s Virtual Network product and international expansion, utilizing DB2, ADABAS, COBOL II, CICS, ADABAS/SQL, NATURAL.,TSO/ISPF Deliverables included:

Developed system requirements and system design

Developed a data map and migration methodology

Constructed code and conducted unit and system testing

Implementation.

March 1993 - November 1993 Consultant to IBM (ISSC). Niwot, Colorado

Delivered technical services to an outsourcing provider, deliverables included:

Upgraded and implemented ten OEM software products (Legent/Goal).

Implemented 13 reconfigured and updated VM/VSE/ESA processing environments

Designed and implemented the automated operations for multiple VM/VSE/ESA processing environments.

June 1990 - January 1993 Coors Brewing Company, Golden, Colorado

TECHNICAL ARCHITECT, SYSTEMS PROGRAMMER

Developed as a team, the Information Technology Strategic plan that incorporated the Technical Architecture, Application Architecture and Data Architecture. Deliverables included:

Outlined strategic and tactical projects

Developed business benefits and costs analysis

Performed Scenarios and Alternatives analysis

Managed and performed technical activities required to support

Multiple processing environments(VM, VSE, MVS, DEC VMS and UNIX)

Multiple databases (ADABAS, SQL/DS, DB2, and ORACLE)

EDUCATION

A.S., Computer Science, Southeast Community College, Lincoln, Nebraska

Business Major, Minor - Computer Science with emphasis in International Business, Regis University, Denver, Colorado



Contact this candidate