• Successfully completed implementations for Sara Lee, McDonalds, Northshore University Health Care,. Siemans.
• Experienced in implementations, custom development, interfaces, upgrades and technical production support using Case/4GL tools, Microfocus Cobol,SQLPLUS PL-SQL,and Lawson utilities. Lawson versions 6.1 thru 9.0 Unix platform. 10 years Lawson experience.
• Developer /Consultant for software company
• Team lead for design, implementation and maintenance of complex order entry and distribution systems for nuclear drug manufacturer.
• Experienced in leading usr groups, gathering requirements, writing specifications, loading and manipulating databases, testing and design analysis.

Technical Skills:

Technologies used:
Lawson Systems 7.0,8.1,9.0, including Financials,Invoice matching,Purchasing and Payrroll.
Lawson database reorgs, Oracle file maintenance and loads.
BACG/Armature Purchasing and Warehouse systems
Lawson EDI, Lawson RSS, Process Flow

Programming languages:

SQL, SQLPLUS, ISQL, COBOL, MICROFOCUS COBOL, Lawson 4GL, CICS, FTP, Austosys, Microsoft Excel ,Process flow

DBMS: Oracle, Informix, NT, DB2 UDB, VSAM

Certifications:
HR/Payroll
Oracle 7
CICS

Work Experience:

Confidential
Consultant

Confidential
February,2009 to October 2 2009

Designed, coded an online system consisting of eight programs to process non-invoiced journals using Lawson general ledget and account payable data. System processes approximately 2.5 million journals a month. This system was written in Lawson 4GL.
Created , loaded and maintained six Lawson/Oracle tables. Wrote scripts to extract data from Lawson database for use by other financial systems. Loaded data into Lawson/Oracle tables.

Confidential
Consultant
December 2006 to December 31 2008
Confidential

Wrote numerous programs for conversion of McDonalds Canadian employees to Lawson payroll. This included tax reporting, employee stock reporting, credit union, charities, government bonds, garnishment and insurance interfaces. These programs transmitted employee data to insurance carriers including Cigna, Blue Cross, Metlife,etc. Wrote a program to report on labor statistics, hours worked by specific criteria. Created a program to monitor employees in Massachusetts who elected not to carry insurance required by state. Wrote interfaces based on various deduction codes, including one time deductions. These programs used paymaster, paydeductn, onetmded, paemployee,emdepend, paempos and employee tables. Create programs to report compensation, hours and dollars for department heads. These interfaces were written using Lawson 4GL, Microfocus Cobol and SQLPLUS. A large number of one time programs were written to provide HR/PR users with data not accessible through Lawson screens. In addition, converted weekly payroll run cycles and run dates for 55,000 employees. This project necessitated an additional payroll run and complex overtime calculations. Assisted on upgrade to Lawson 9.0.3. Wrote programs to report on open enrollment , tax requirements, garnishment reporting, hmo medical and dental programs, minimum salary reporting for managers. These efforts involved both analysis and programming and extensive user contact. Also have converted data and loaded records to Lawson/Oracle
Tables. (gltransrel,employee,apvenloc,apvenmast,etc).

Confidential
Senior Programmer Analyst
April 2004 to December 2006

Wrote several Lawson cobol programs for materials management , a process flow application for purchasing to notify hospital personnel of status of purchase orders placed by purchasing department, installed 15 EdI trading partners using Lawson's edi system. These partners were drug distributors and drug manufacturers. Wrote interfaces for
accounts p ayable system.
Maintained security system (Logan) for RSS ( Requisition Self Service) and portal system. Worked extensively with users on design,modifications, new applications,and day to day activities for Accounts Payable, Inventory Control and Purchasing systems.

December 2002, January 2004
Lawson 8.0.2 release

Confidential
Senior System Analyst
December 2002, January 2004
Lawson 8.0.2 release

Participated in the conversion and installation of over 40 separate companies into General Ledger system Wrote programs to interface these companies into gltransrel table. These programs balanced all debits and credits before loading into gltransrel.Wrote extracts for General Ledger,Budget systems and Accounts Payable to return data to financial systems of
subsidiary companies and Hyperion/Essbase. Designed and wrote interfaces to feed into General Ledger system from both US based and international companies. Designed and wrote a portal program for offshore facilities to download General Ledger information. Designed and wrote interface to feed GL transactions to SAP manufacturing system. Worked extensively with user groups locally and offshore to convert data to Lawson formats.. Created extracts from the AP vendor master (apvenmast and apvenloc tables).

Confidential, Consultant February 1999 - September 2001
Senior Consultant
Client - Confidential, Albuquerque, NM

• Installed Lawson Payroll /HR/FINANCIAL packages.
• Designed and wrote specifications and reports for time card system interface to Lawson, vacation and pension processing, including 401K extracts and transfer to CIGNA and Union pension plans for execution by other programmers.
• Designed, wrote specifications, programmed, scripted and wrote operations documentation to send payroll and personnel data to organizations outside of company, Credit Union for bank deposits, Cigna for 401K, alcohol certification, State taxes, state quarterly reporting, Federal withholding and locations within company for applications such as labor statistics, bonus calculations based on previous years W2 plus additional criteria.
• Designed and wrote specifications, programs and scripts to interface retail accounting system (stores) and warehouse system invoices into Lawson accounts payable system.
• Performed Database management in conjunction with Lawson personnel to correct and back out erroneous data.
  Successfully manipulated Accounts Payable data to invalidate over 9,000 duplicate invoices resulting from a retail accounting re-sequencing error.
• Designed and wrote several online programs within Lawson system for the purpose of: viewing data by varying prospectives; verifying and reconciling data with warehouse systems; and transferring accepted and
  rejected invoices to retail accounting system.
• Reconciled variances between Lawson Accounts Payable and General Ledger systems, Asset Management and Bank Reconciliation.
• Created Lawson inquiry programs, SQL extracts of data to feed NT bill back and retail accounting Systems. Created tables, extracted data, created scripts to transfer data from Unix to NT and eventually back to Unix and Informix database.
  Created nightly job stream to reconcile and verify data.
• Interfaced from Microsoft SQL server to Wincms category management database using NT system.
• Handled database management and analysis for conversion of mainframe data to Unix/Lawson Environment for payroll system.

Confidential, Consultant January 1998 -February 1999
Consultant
Austin, TX

• Consultant responsible for writing interfaces to Lawson payroll and benefits package using SQL, SQLPLUS, COBOL, Oracle database in Unix environment in corporate headquarters for Walgreen\'s, Inc. and McDonald\'s, Inc.
• Projects consisted of calculating Life and Health insurance, tax reporting and premiums for employees and dependants. Creating reports of terminated employees for stock option termination, dependent change
  information, and Garnishment information. Tax reporting downloads for State taxes. COBRA eligibility, and Employee beneficiary change reporting and notification.

Confidential
Senior Programmer Analyst March 1996 -January 1998
Lisle, IL

• Designed and wrote specifications for Purchasing/Edi system for BACG in Leeds, England which were incorporated and sold in package.
• Designed System specifications and testing for a new release of client/server product.
• Consultant performing analysis, programming, installations, loads, interfaces and testing at the following sites for BACG:

Confidential, Prairie, MN

• Installed BACG corporate maintenance and purchasing system using CA gateway, Oracle 7.0. for Proof of Concept test.
• Defined, mapped and loaded data from legacy system into Oracle database making database operational,
• Created eight copies of same database to allow conversion, development, systems testing, heavy user testing, writing batch scripts to run jobs, maintaining incident reports, writing SQL programs using Oracle\'s SQLPLUS and Computer. Associates ISQL and QBF.
• Installed PC configuration files and Ingres 4gl interface on all user PC\'s.
• Performed DBA functions to shorten run times, import and export databases, backups and reloads. .
• Conducted all technical meetings between user staff and BACG personnel.
• Assisted in user training.

Confidential, Indianapolis, IN

• Performed installation of purchasing and warehouse packages, including complex temporary item master system to keep new system current while converting to new system.

Confidential, Birmingham, AL

• Customized Mainframe warehousing system MVS package

Confidential, Salt Lake City, UT

• Modified and enhanced purchasing package that interfaced from BACG/Unix system to another vendors MVS warehousing package and store ordering system. File extracts in EDI format Database: Informix CA OPEN ROAD (4 GL).
  

Confidential, Moline,Il

• Created complex batch script to automate nightly processing.

Confidential, Senior Programmer Analyst July 1990 - March 1996
Arlington Heights, IL

• Designed and supported existing and new order entry, licensing, credit card, distribution and sales/marketing system. Activities included emphasis on Business reengineering, analysis and feasibility study, system design and developing interfaces to package systems running in a client server UNIX environment.
• Redesigned order fulfillment systems from Assembler to COBOL, using CICS command level and VSAM structures. Interfaced from mainframe order entry and marketing systems to Oracle.
• Expanded and redesigned Order entry/sales reporting/distribution/accounts receivable and marketing to accommodate the acquisition of MediPhysics and U.S Biochemical.
• Designed, programmed, and installed a system to comply with licensing requirements of the Canadian Atomic Energy Commission.
• Enhanced regulatory system required by U.S. Nuclear Regulatory Commission.

Confidential, Senior Programmer Analyst September 1989 - June 1990
Chicago, IL

• Designed, wrote and installed an on-line and batch sales/forecasting/tracking system. Created a specialized subsystem to manage inventory for trade shows occurring at various times and numerous locations
  throughout the country.
• Worked with a small team to install EDI system to process Sears catalog orders.
• Development in COBOL and Vware on a Prime computer.

Confidential, Senior Programmer Analyst June 1984 - September 1989
Glenview, IL

• Programmed new applications and managed existing systems using COBOL, CICS command level and DB2 in an OS environment.
• Maintained and enhanced Arthur Andersen\'s CSOPS order fulfillment system.
• Designed and installed a sub system for McCormick Dodge Accounts Payable system.
• Installed EDI trading system for college bookstore network.

Confidential, Senior Programmer Analyst/Programmer Analyst June 1981-June 1984
SKOKIE, IL

• Created design specifications and user manuals. Enhanced and expanded the distributed systems for the control of warehousing operations and manufacturing processes.
• Played a major role in the installation of General Electric\'s fourth generation software MIMS (Mitrol Industrial Manufacturing Systems).
• Enhanced the system\'s data entry and on-line update facilities for shop floor information by upgrading and correcting Cobol applications running on IBM 8100\'s under DPPX with DSX, DTMS, and DCS.