AddThis Social Bookmark Button
daniel doyle ( Available )
downers grove, il - 60515 usa
Expertise :lawson, sql, javascript
Job Type :
Contract - W2,1099,Corp-to-Corp
Position :Computer and Mathematical

Resume
 
Summary




Senior IT Professional with 20 years industry experience. experience in design, analysis, development and implementation of ERP systems. 14 Years of Lawson Software Implementations, upgrades, development and support work across all major applications : Financial, Supply Chain, Procurement and HR/Payroll. With 7 Years Unix/Windows platform and 7 years of AS/400 platform and associated databases Oracle, SQL Server, DB2.
Worked on dozens of successful projects, application conversions and implementations, customization, application interfaces for most modules, reporting and performance tuning. Industry experience includes services, retail/wholesale, hospital, banking and others.
Project roles include project lead, system architect/technical design, development/coding, technical lead, system Administrator, database Administrator, security Administrator. Often, role includes mentoring staff on Lawson technicals like experience servers, database, security, customization and performance tuning.
Strengths
Lawson ERP Applications, technical expert, excels in finding streamlined solutions to complex issues. Specializing in Lawson interfaces to all platforms. Diverse design and development experience on many system platforms and database systems.
Extensive knowledge of Lawson development utilities for program customization, add-on programs and interfaces. Design and code interfaces to and from financials, supply chain, procurement and human resources. Thorough understanding of application database tables and relations.
Able to mentor in Best Practices for Lawson application design and coding using object-oriented design and implementation of Business Rules methodology/SDLC.
Excellent communication skills with the ability to work well in a team or individual environment. Can work well with technical team and also interface well with application users and managers.


Employment

March, 2009 -  September, 2009
Lawson Technical Consultant

Republic Services Phoenix
Develop multiple interfaces for linking Lawson financials with Ariba purchasing. Create standard Lawson programs to extract Vendor and GL Account data to update Ariba Purchasing and Buyer. vendor master, vendor address, terms code and GL companies, accounts, account units and more. Process vendors en mass and via vendor audit table.
Develop interface for accepting Ariba Purchasing expense journal entry for posting via GLTransrel, allowing for multiple JE types, auto-reversal and run groups. Code Ags call to validate GL Account from Ariba application.
Develop interface for loading Ariba Total Spend from Lawson Invoice History.
Develop interface to accept CenterSuite Time and Expense AP Invoice and expense JE to Lawson, included batch control, reporting and interface to ADP.
Developed custom SQL queries for security team, QA testers and report designers
Mentor in-house programmers on Lawson development methodology. Create technical documentation and perform unit testing.
Environment : Lawson 8 Financials w/LID and Portal on AS/400 5.4/DB2 MS-Office, Telnet, FTP, FTPMGR, ESEND, Aldon, Eclipse, IFS.


June, 2008 -  February, 2009
Lawson Technical Consultant

Parkdale Cotton Charlotte NC
Assist with integrating QAD unix Database with Lawson 8 on iSeries : GL, AR, AP, AC.
Create new interface for PO and receipts. Two-way interface with Datatex Inventory database. PO520 MA530
Create exit pgms for interfacing vendors and credit terms
Export ADP MSSQL database for import into Lawson HR.
Environment : Lawson 8 Financials w/LID and Portal on AS/400 5.3/DB2 Crystal Enterprise/Designer 10.0 ClientAccess, MS-Office, Telnet, FTP, SMS distribution


August, 2007 -  May, 2008
Lawson Technical Consultant

Cost Plus World Mark Oakland , CA
Analyze Lawson AS/400 Portal and Lid performance. Recommend and implement changes
Enhancements to Lawson AP invoice interface to SMS via MA540
Re-engineer SMS to Lawson PO520 interface
Enhancement to Lawson PO entry PO20/PO30 to interface with Lawson Process Flow for capital PO approval
AP10/AP16 Lawson exit pgm for country code and bank account
Design configuration and operation of mirrored Disaster Recovery AS/400
Assist with Lawson Security. Create Excel query for Lawson security tables
Knowledge transfer to in-house Lawson technical personnel
Environment : Lawson 8 Financials w/LID and Portal on AS/400 5.3/DB2 Crystal Enterprise/Designer 10.0 ClientAccess, MS-Office, Telnet, FTP, SMS distribution


March, 2007 -  August, 2007
Lawson Technical Consultant

Mervyns Hayward , CA Cost Plus World Mark Oakland , CA
Assist in reconciliation of FAS Asset manager conversion to Lawson. Develop queries using Crystal, Excel, SQL. Extract and format FAS database. Generate upload files for MS-Addins.

Develop reports for Asset Management, Activity and GL using Crystal and Excel VBA. Create parameter driven, refreshable Excel files for generic queries of Assets AM, Activities AC, Sales Tax TX and GL. Create Crystal X reports for Asset Master listing, Chart of Accounts, etc.
Develop custom SQL for interfacing selected Lawson tables to Oracle 10g custom data warehouse.
Review Lawson 8 iSeries file structure, backup, maintenance procedures with IT operations staff.
Environment : Lawson 8 Financials w/LID and Portal, MS Cobol, Crystal Enterprise/Designer 10.0 Embarcadero, Oracle 10g/PLSQL, MS-Office, Telnet, FTP, FAS fixed asset accounting.


July, 2006 -  March, 2007
Lawson Technical Consultant

The Northern Trust Company Chicago , IL
Develop code and test stored procedures for Lawson custom GL reporting used by select banking customers.
Design and code custom GL40 Journal Entry screen for portal interface.

Create and maintain security classes and user profiles.
Environment : Lawson 8 Financials w/LID and Portal on AIX 5.3/Oracle 9i, Crystal Enterprise/Designer 10.0 Embarcadero, Toad, SQL+, Notes, MS-Office, Telnet, FTP


January, 2006 -  June, 2006
Lawson Technical Consultant

Performance Food Group Richmond , VA The Northern Trust Company Chicago , IL
Environment : Lawson 8 Financials, Procurement, Supply Chain, HR w/LID and Portal on OS/400 5.3/DB2 Crystal Enterprise/Designer 10.0 MS-Office, Telnet, FTP, Lawson APIs, QSH.


September, 2005 -  May, 2006
Lawson Technical Consultant

Martin Resources Kilgore , TX and currently
Lead technical consultant for new Lawson 8 implementation. Support configuration of Lawson security, portal, database, etc. Analyzed disk utilization.
Design, code and implement a custom financial report writer : Accept a list user parameters to generate 1 of 4 report formats using a matrix of filtering, sequencing and grouping. All RPG-ILE, free format, embedded SQL. Provide all documentation and test plan.
Environment : Lawson 8 Financials, Procurement, Supply Chain, HR w/LID and Portal on OS/400 5.3/DB2 Crystal Enterprise/Designer 10.0 Apache/Websphere 5, WinXP, MS-Office.


June, 2005 -  June, 2005
Lawson Technical Consultant

Lions Clubs Oak Brook , IL Martin Resources Kilgore , TX and currently
Temporary Lawson/Oracle administrator for technician on leave. Monitor AIX system, database and application server. Install environment, application and IOS patches. Debug Lawson application errors.
Initialize older RS/6000. Install AIX 5.3L and format all drives.
Reconfigure FastConnect, document procedures for stopping and starting RS/6000 and Lawson servers. Document problems with Lawson custom applications. Interact with Lawson support.
Setup new AIX/Lawson users and printers.
Environment : Lawson 8 Financials, Procurement, Supply Chain w/LID and Portal on AIX 5.3L/Oracle v9, Crystal Webserver 8.0, Apache/Tomcat, Cron, Perl, ksh, Windows2000.


January, 2005 -  January, 2005
Lawson Technical Consultant

York PA Martin Resources Kilgore , TX and currently
Create user requirements, design specifications and test plans for Lawson/Siebel interface and modifications. Meet with users and programmers to complete requirements.
Enhancements to Lawson to Siebel interface. Change custom Siebel report screens, java processing xml data to output html tables. Design new MQSeries function library for new interfaces between Lawson and Siebel. Design new SQL queries and optimize existing queries for on-demand inquiries from Siebel client.
Modify Lawson OE10 order maintenance screen to allow custom Line function codes. Add custom processing to Lawson billing program BL122 Rewrite Lawson Activity management rebuild function to process more efficiently.
Environment : Lawson 8 Financials, Procurement, Supply Chain w/LID on DB2 v7.0, Siebel on Oracle v9, MQSeries v6. Windows 2000/XP, AIX, Microfocus Cobol/Servlet Express 4.0, OS/400 MKS, Websphere Studio, Actuate Pro v6


May, 2003 -  May, 2005
Lawson Technical Consultant

Jackson , TN
Technical Lead for Lawson HR 7 to 8 upgrade.
Created custom Lawson payroll reports for auditor s request using Crystal Reports 9.
Wrote stored procedures for employee merge and renumbering and store POS interfaces for timeclock and personnel actions.
Assisted installation of Lawson 8 environment and applications on new server.
Performed data migration tasks

Utilized Lawson s Design Studio and java scripting to modify and add forms to Lawson s front end interfaces needed for store POS systems- for department and employee changes, for employee work standards and sales commission amounts and related personnel actions.
Design and code Employee s Annual Benefit report. Design and Code MSSQL script to pull selected wage, deduction and benefit data per employee. Design Excel and Crystal Report to print employee personalized report.
Environment : Lawson HR 7 and 8 w/LID and Portal on NT4/5 and MSSQL 7/8. Java Script, Lawson Design Studio, Crystal Reports/Designer 8.5, MSSQL, Admin/Profiler, Win2000, WinNT4AS, Access, Excel.


June, 2004 -  June, 2004
LAWSON TECHNICAL CONSULTANT

Dallas Jackson , TN
Technical support for Lawson 7 to 8 upgrade : Financials, Distribution, Procurement.
Carry forward Lawson 7 program and screen modifications to Lawson 8.
Re-implement interface to Manhattan WH/EDI application.
Convert Lawson Cobol programs to RPG with some customization.
Environment : Lawson Financials 7/8, Manhattan Assoc Supply Chain.


May, 2004 -  May, 2004
Senior . LAWSON CONSULTANT

Green Bay , Wisconsin Jackson , TN
New Lawson payroll report.
Design, code and implement enhanced Wage Report PR270 and LID prompt screen.
Environment : Lawson Financials 7.x on OS/400 V5R1.


February, 2004 -  February, 2004
Senior . LAWSON CONSULTANT

Des Moines Jackson , TN
Provided service level support to Lawson Financials System
Lawson modifications : Added new fields to GL Chart Detail table. Changed GL00 to allow for display and update of new fields. Changed AP20 to allow for custom default for distribution company number.
Lawson interfaces : Modifications to GL190 and Re-worked several custom interfaces to Mainframe GL system.
Environment : Lawson Financials 7.x on OS/400 V5R2.


July, 2003 -  July, 2004
Lawson Technical Consultant

Dallas Jackson , TN
Designed and coded a series of programs for integrating Lawson GL, AM and PO with iTMS Medical Equipment Management database.
Created a series of stored procedures to format and index Lawson GL, AM and PO data referencing equipment data. 1 routine pulled GL Amounts. A second routine pulled Asset Items and associated data elements from PO Header/Item detail, GL Chart and Vendor.
Link MSSQL database with Oracle Database for asset management data warehouse.
Created 20+ Crystal reports, these reports included drill-downs, elaborate statistics, charts and graphs.
Instructed development using Lawson OLE-DB verses ODBC with Lawson Enterprise Reporting.
Created Technical Design. Created a complete test database environment for unit testing.
Environment : Lawson Procurement and Financials 8.0.2 w/LID on Unix AIX/Oracle10 platform. Crystal Designer 8.5/9.0, Crystal Enterprise 8.5, 9.0 Lawson Enterprise Reporting, PL/SQL, MSSQL Administrator, Win2000, WinNT4AS


March, 2003 -  March, 2003
Lawson/Crystal Technical Consultant

Chicago Jackson , TN
Designed and coded a collection of A/R Aging Crystal reports and 1 special G/L transaction reports to consolidate large international customers like Proctor and Gamble.
Developed custom MSSQL views for aging and currency conversion.
All reports designed with optional currency conversion and multiple drill-down levels.
Provided complete functional and technical design documents for each Crystal report and SQL view.
Mentored in-house developer on Crystal Designer and Crystal Enterprise publishing and administration.
Instructed development using Lawson OLE-DB verses ODBC.
Environment : Lawson Financials, Supply Chain, Procurement 8.0.3 w/LID and Portal on NT with separate MSSQL database. MS Cobol, Crystal Designer 8.5/9.0, Crystal Enterprise 8.0/8.5, MSSQL Administrator, Win2000, WinNT4AS.


December, 2002 -  December, 2003
Lawson HR Technical Consultant

BANK/FIRST SERVICES St.Louis
Updated Lawson for 2002 year end and BSI Tax Factory for 2003 processing.
Configured and ran production W2 forms.
Upgraded Lawson to latest release, planned implementation, testing, transferred custom LID and Self Service/Portal modifications.
Created new Lawson QA environment, replicated production database, performed routine housekeeping/cleanup and updated DRP. Worked directory with in-house technicians to provide technical training/mentoring.
Worked with HR Directory and staff to help with Lawson functional issues.

Provided complete project plan for Lawson upgrade and patch applications, database maintenance and other technical Lawson tasks.
Developed report and interface for Payroll J/E to CBS G/L. Ad hoc Crystal Reports and RPG/SQL database updates.
Environment : Lawson/400 7.2., LID/Logan/SEA/MS-plug-ins, OS/400 V5R2, RPG-ILE, COBOL-ILE, SQL/Sequel, CLP, TCP/IP, CA/400 FTP, Telnet, IBM-HTTP, SNADS, Oracle/Toad, Penta, Robot, DBU, W2K, Crystal Reports/Query 9.0, Excel, Word, Lotus Notes


August, 2002 -  August, 2002
Lawson Implementation Consultant

PNI/GANNET Phoenix BANK/FIRST SERVICES St.Louis
Team Lead to convert large Solaris/Oracle Financials and Procurement installation to Lawson s ERP. This business system used for general accounting, materials management and equipment purchasing, advertising billing subscription, subscription billing and paper carrier pay.
Responsible for full implementation life cycle : User requirements thru development and user acceptance.
Assisted with CRP process to define and perform setup for inventory, order entry, billing, purchasing, A/P and sales analysis.

Developed additional user interfaces and business functions using Java servlets, with the Lawson $GL and design studio tool set for the advertising subscriptions needed additional business processes and controls between Purchasing and A/P.
Designed and coded PO, AP and GL interfaces to Unix Sun Solaris/Oracle Systems for advertising, subscriptions and carriers. Automated transaction interfaces using ftp scripts.
Developed automated recoverable interfaces to Lawson AP510 AP520 and GL165 from supporting Solaris/Oracle applications.
Designed and coded Workflow alerts for Procurement Requisition and AP Applications that send SMTP email messages to the alert request table, based on Lawson approver code table, for users to be flagged and take next processing step. Kept history of messages sent, Requisition Approval, Blanket PO Expiration, etc. A Lawson batch job would create PO s for all fully approved requisitions.
Worked directly with Purchasing Manager on understanding screens and reports for conversion, approval process and daily transaction processing. Created custom PO print form using Crystal Reports to include graphics and all relevant detail available in Lawson
Trained current staff on Lawson database and Workbench tools.
Developed dozens of Lawson reports using Crystal Reports/Enterprise Reporting tool, : GL290 replace, Payroll and Voucher check, Purchase order and Requisition.
Implemented Crystal Enterprise server for web-based reporting and automatic report scheduling.
Environment : Lawson 8.0.3 Oracle Financials 8, MS Cobol, LID/Logan/Portal/MS-plug-ins, Unix Solaris 8, Oracle 8, OS/400 V5R1, RPG-ILE, COBOL-ILE, SQL/Sequel, Java Script, Lawson Design studio, CLP, TCP/IP, CA/400 FTP, Telnet, IBM-HTTP, SQL*Plus, Toad, W2K, IIS 5.0, Crystal Enterprise 8.5, W2K Server/IIS5, Crystal Reports/Query 8.5, Excel, Word, Lotus Notes.


March, 2002 -  March, 2002
Lawson Implementation Consultant

Dallas 6 Months BANK/FIRST SERVICES St.Louis
Technical team member to upgrade large, customized Lawson ERP Financials, procurement and Payroll installation for Bennigan s restaurant client.

Primary responsibility was to identify and modify 700+ custom report and interface source programs to access the new Lawson database ; re-applied custom modifications to Lawson 7.2 PR/HR ; write new interface programs. Developed entity-relation diagrams and other documentation to aid in the Lawson upgrade.
Wrote SQL routines to support conversion verification.
Wrote OnDemand/RDARS exit programs for new Lawson Report Writer print file naming change.

Focused primarily on Lawson HR, PR, PA and AM applications but completed work on most other Lawson Financial, Procurement and Supply Chain modules.
For a second ACS client Freeman Company : Assisted in Lawson ERP upgrade/conversion.
Transferred custom modifications from HR and GL screens and reports to Lawson 7 test environment.

Researched and documented hundreds of custom modifications for other programmers.
Designed Crystal Reports to replace customized Lawson GL and PR reports.
Developed and implemented standard security model. Mentored in-house staff on Lawson database and workbench changes.
Environment : Lawson 6.1/7.2, LID/Logan/SEA, Crystal Reports 8.0/8.5, OS/400 V4R4/V4R5, RPG-ILE, COBOL-ILE, MicroFocus Cobol, SQL, TCP/IP, W2K, CA/400 FTP, Telnet, IBM-HTTP, OnDemand, RDARS, Excel, Access, Word


October, 1996 -  October, 2002
Lawson Technical Manager

Chicago 5 Years
Hands-on manager for initial installation of Lawson Financial ERP suite of Financials, HR, Procurement.




Education

College of DuPage , Glen Ellyn , Illinois Associates of Science



Training

IBM Websphere Developer and Administrator certification 2001 IBM Certified RPG programmer 1998 Completed 11 IBM Java/Websphere/DB2 classes 1999 - 2001 Completed all Lawson technical classes v7 1997
Daniel Doyle Page 3


Miscellaneous

Ongoing Manager for complete Lawson implementations, hardware, os, application, upgrades user training and support, enhancements.
Installed and configured initial OS/400 and AIX servers. Configured user profiles, TCP/IP, Client Access Telnet and LPR printers. Installed Lawson Application and patches. Configured Lawson database and security. Developed custom database replication for DB2/400, DB2/NT and DB2/AIX.
Led a team of analysts, programmers and system technicians to convert current GL running on mainframe M and D GEAC and AP running on Novell AccPac. Developed series of programs to convert and import master file and historical data. Designed dozens of programs to cross-foot financial data for verification of conversion. Wrote policies and procedures for user testing and verification of new financial system.
Reverse engineered Lawson server program to design appropriate security model. Created programs to implement customized security. Developed system programs to monitor Lawson sign on requests and other Lawson system jobs. Utilized Unix commands, Cron to setup and initiate monitoring process.
Mentored programmers and users on Lawson database, operations and security. Developed and implemented Best Practices document for System Operations and Application Development.
Performed or supervised all release and version upgrades for all Lawson application servers and middle-tier servers, database servers on OS/400 and AIX and Logan Apache servers on Linux and OS/400
Implemented Lawson Financials 8.0 on AIX for evaluation and testing. Installed and configured DB2/AIX application database, configured multiple Lawson environments and developed database bridge from production DB2/400 server.
In 2001, installed new Lawson 8.0 environment and upgraded Financial, Procurement and HR applications.
Assisted Purchasing manager in configuring Procurement suite. Used Crystal Reports to create custom Vendor Purchase Order form. Responsible for applying all maintenance releases.
Created ADP conversion routines. Utilized Perl Scripts to aid in execution.
Developed secure website with java servlets, JSP s and Applets for security orders application used by all bank officers integrated with Lawson GL and mainframe customer database.
Developed java website for indexing and viewing invoice images with online interface to Lawson AP.
Environment : Lawson 7.2/7.3/8.0 and Websphere 3.5/4.0 with IBM Apache, csh/Perle. Microfocus Cobol, Middle tier ODBC servers running on NT4 and NT2000 servers using both IBM CA ODBC driver and HiT ODBC driver. TCP/IP, DNS, DHCP, HTTP, FTP, SMTP, LPR/LPS, OS/400 UNIX AIX, WIN NT or 2000, IE, Lawson Case/4 GL tool, Lawson LID, Logan, SEA, IBM OnDemand/VisualInfo, ClientAccess Telnet, Hummingbird Telnet or Mocha Telnet.