Huana Helen Lee

*** * *********** ***.

Peoria, IL 61614

270-***-****

270-***-****

acc0f8@r.postjobfree.com

CAREER SUMMARY

Twenty years of IT experience supporting health care industry, warehouse

operations, order management, finance, human resources, and marketing in

retail, manufacturing, insurance. Had seventeen years of analytical,

programming and quality assurance experience in AS/400 - RPG ILE, AFP,

Subfiles, COBOL, DB2, and CL. Had three years in mainframe - COBOL, VSAM,

IDMS, and JCL. Took Visual Basic and C# classes in Illinois Central College

in 2011 and 2012.

CANDIDATE SKILLS

Hardware: System i (AS400), IBM Mainframe, NCR Mainframe

Operating Systems: OS/400, Client Access, TSO/ISPF, UNIX, Windows,

DOS

DOS

Languages: RPG/RPG ILE, SQLRPG, Subfiles, COBOL II, JCL,

Control Language, FORTRAN, UPG, SQL, PL/SQL,

Visual Basic, C#, Pascal, HTML5, JavaScript, CSS, XML,

Visual Basic for Applications (VBA) for Excel

Software: Microsoft Office, HMS (Patient Accounting,

Clinical Care and HR package), Infinium

(Financial and HR package), Aldon (Production Control

package), Vertex (Sales Tax package), Turnover

(Production Control package), Occupation Health

Manager

Databases: DB2, IDMS, VSAM, Oracle, Access

BUSINESS EXPERIENCE

Healthcare Management Systems, Inc., Nashville, TN

Conversion Analyst

March 2003 to August, 2013

. Analyzed client's patient accounting, abstract, HR/Payroll legacy systems

and converted those data into HMS Patient Accounting, Abstract and

HR/Payroll systems or vice versa when clients left HMS for other software

company.

. Supported EDI between HMS and other healthcare vendors.

. Enhanced existing HMS Financial or HR/Payroll Systems using RPGLE, RPG

SQL in a System i environment.

. Developed customized database and wrote interactive display screens for

customers to display their old legacy data after they were live on HMS

system.

The Longaberger Company, Newark, OH

Programmer/Analysis

March 1998 to May 2002

. Enhanced and maintained integrated Warehouse, Order Entry, Inventory

Control, Shipping and Accounting System in AS/400 environment.

. Developed Drug Screen table in OHM, set up drug data upload, prepared

user training documents, and performed user training for HR department

using Oracle Database.

. Developed and maintained in-house applications and supported daily

operation for HR and Payroll Department using RPG ILE or RPG in an AS/400

environment and trained users in applications.

. Performed new release upgrade for Infinium HR/Finance System and Vertex

Sales Tax System in an AS/400 environment.

. Developed/enhanced applications to support EDI between businesses unites

and 3rd party vendors such as CIGNA, General American, AON, ADP, and

Scudder using RPG ILE in an AS/400 environment.

Value City Department Stores, Inc., Columbus, OH

Programmer/Analyst

September 1996 to March 1998

. Designed and coded new Hanging programs for new scanning machines using

RPG and AFP.

. Developed and enhanced applications in Merchandise Management systems

using RPG or COBOL in an AS/400 environment.

. Supported and trouble shot various production systems' problems for Value

City Department Stores' warehouse/distribution centers.

Compuware, Columbus, OH

Professional Staff

May 1995 to September 1996

. Worked on Y2K conversion project for ONLACS Credit Services System using

COBOL JCL in an IBM Mainframe environment.

. Worked on Y2K conversion project for Bureau of Worker Compensation using

COBOL II and UPG in an NCR Mainframe environment.

Express Division of the Limited Inc., Columbus, OH

Programmer

October 1993 to May 1995

. Performed analysis, file and report design, coded and tested for batch

programs using COBOL and JCL in an IBM Mainframe environment.

. Supported Purchase Order, Merchandise Control, Vendor Analysis, and

Special Order systems daily using COBOL and JCL in an IBM Mainframe

environment.

CERTIFICATION

Introduction to Oracle - SQL & PL/SQL, ID: SR1415895

EDUCATION

Bachelor of Science in Management Information Science, University of

Illinois at Chicago, IL

Bachelor of Arts in Language Education, National Taiwan College of

Education -- Taiwan

Contact this candidate