Lawson ERP Consultant, Data integration and conversion
Resume:
Douglas E. Buss
Montrose, Co. 81403
E-Mail ****@******.***
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