Objective:
Technical Experience Keywords: LANSA, IBM System i (iSeries, AS/400),
JD Edwards(JDE, WorldSoftware, OneWorld), ERP software package, RPG

Professional Experience: (LANSA 15 years, AS/400 15 years)

2009 – current LANSA and AS/400 Expert

Confidential, New York

• Upgraded LANSA system from V10 to V11.5 on both AS/400 and windows
• Working on site in a global supply chain driven distribution company IT department
• Support LANSA-based ERP(Garnet) system running on AS/400

(include modules Sales order, Purchase, Inventory, Shipping, Billing, AP,AR,GL) using latest version Visual LANSA IDE V11 SP5

• Involved support some ASP.NET applications, gained knowledge on:
  C#, Visual Studio 2005/2008, SQL Server 2005, Oracle 11g

Windows Mobile (barcode scanner program for inventory management)

2005 – 2008 Sr. LANSA Programmer/Analyst

Confidential, (Buffalo, NY)

• Support and enhance LANSA web quoting system integrated with WINS(COBOL based insurance software package running on AS/400)
• Hands on web development skills (RDML, Lansa for the WEB, HTML, JavaScript, CSS, SQL, QUERY/400, FTP, …)
• Design and develop using Visual Lansa/Web windows development environment IDE(V11.3)

2003 – 2005 Independent Contractor / LANSA consultant

Confidential, (Pittsburgh, PA) [9 m]

• Design and develope “Operations Strategy Approach Worksheet” using LANSA for the WEB for company senior level managers and president.
• Design and develop customer prospect web interface

Confidential, (Chicago Downtown, IL) [4 m]

• Add and make custom LANSA program changes to fit the user’s needs
• Data warehouse projects using LANSA/AD, Essbase

Confidential, (Lincoln, NE) [9 m]

• Add and make custom program changes to fit the user’s needs,

The current running modules (LANSA ERP Framework / Garnet) running on AS/400 was developed and implemented by LANSA Inc

• Design and develop the solutions for transmitting Purchase Orders electronically (include automation for Scrap Orders) from KMM to its mother company - Kawasaki Heavy Industries Ltd (KHI) in Japan Transmition is conducting on AS/400 between USA and Japan
• Migrating Customs system from original COBOL and RPG to LANSA

Confidential, (Denver, CO) [2 m]

• Learn and add/change custom functions for an ERP package system

(DMS - DAIRY MANAGEMENT SYSTEM written in LANSA/AD)
which is going live on Oct 2003 in Dean Foods Company
Confidential, (Atlantic City, NJ) [2 m]

• Developed LANSA web page for this US property, casualty and workers\' compensation insurance company (telecommunicate work remotely)
• This web interface is for First Report of Injury form insurance claim filer

1999 – 2003 Consultant ,Confidential,

• For nearly 4 years working as a consulting team member on product implementations and retainer projects performing limited day-to-day specific tasks required to successfully implement LANSA products
• Heavily involved in e-business (B2B and B2C) projects for 3 years including big ERP package projects. Hands on web development skills (RDML, Lansa for the WEB, HTML, JavaScript, Visual Lansa, AS/400 …)

Consulting and programming service for various customers: [some listed below]
* Confidential, U.S.A. (KMM)
Part of Development team of Manufacturing and Distribution modules on AS/400 using LANSA/AD (based on LANSA ERP Framework / Garnet)
* Confidential,
Rewrote a mainframe(COBOL) system application to LANSA using LANSA/AD
* Confidential,
Developed and tested on-line banking on AS/400 using LANSA for the Web
* Confidential,
Developed and tested front end to Kronos Time/Attendance application using LANSA for the Web
* Confidential,
Developed and tested LANSA for the Web based Customer self-service Inventory Management application
* Confidential,
Developed and tested B2BWeb-app on AS/400 using LANSA for the Web
* Confidential,
Inventory Inquiry web interface (use LANSA multi-sites solution)
* Confidential,
Member registration web management (based on LANSA Commerce Edition)
* Confidential,
Developed and tested B2B Web-app on AS/400 using LANSA for the Web

1998 – 1999 AS/400 Tech Support Consultant
Confidential, (USA)

• Working as an AS/400 tech support consultant in Chicago
• Tech support and Help Desk (AS/400 and Window NT)

1996 –1998 JDE Consultant
Confidential, (Beijing office, China)

• 2.5 years experience in JD Edwards implementation (integrated ERP package running on AS/400) & JDEs new version product OneWorlds
• provide pre-sale and post-sale service for clients and end users as an application functional consultant

1993 – 1996 Programmer Analyst - LANSA Developer
Confidential, (Beijing, China)
- ERP package vendor, LANSA partner in China

• 4 years experience in full cycle application software development on AS/400 using CASE tool(LANSA) and programming language: RPG, SQL/400, COBOL, Visual Basic, C, Powerbuilder …
• being one of the key member in the development team for awards winning product package CASE/ERP written completely in LANSA
• had been working on some large projects as a team Leader, tasks include business analysis, designing, coding, testing and implementation.

1992 – 1993 Practical Training project after B.S. college

• develop financial accounting software using Foxpro (PC network)

Education:
M.S. in Information Systems Management