Quality Assurance Human Resources
Resume:
Huana Helen Lee
Peoria, IL 61614
*************@*******.***
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