Alice S. Lee Home

Phone: 732-***-****

**** ****** **** ****. **** Phone:

919-***-****

Edison, NJ 08837 Email:

acqzh1@r.postjobfree.com

OBJECTIVE

Seeking a technical position in a challenging work environment to provide

effective knowledge and technical skills for successful completion of

organizational objectives.

PROFESSIONAL SUMMARY

. 12+ years of experience in Mainframe environment in developing, testing

and support of various applications using COBOL, DB2, JCL, VSAM, CICS,

Easytrieve.

. 5 years experience in Quadramed Affinity build on CACHE database

. 1 year experience in Meditech NPR, Report Designer

. 2 years experience in Mercator 5.0

. 1 year experience in Oracle Financial using PL/SQL, SQL Plus, Toad,

Developer 2000

. 3 year experience in SAS on Mainframe and PC

. 4 years experience in Unix environment

TECHNICAL SUMMARY

Software - Windows/UNIX:

Meditech NPR and Report Designer, Quadramed Affinity Query Language, Oracle

PL/SQL, SQL Plus, SQL Loader, Toad, C++, HTML, XML, Microsoft Office,

Visual Basic, Microsoft Visual Studio .NET, SAS, Visio, PERL, SQL, KSH,

CSH, Tcl/Tk, PuTTY.

Software - Mainframe:

COBOL, DB2, CICS, Easytrieve, VSAM, Indus Passport, SAS, MVS/ESA, MVS/JCL,

TSO/ISPF-PDF, SQL, DB2 Utilities, QMF, SPUFI, IBM Utilities, Xpediter,

Intertest, Fileaid Abendaid, Endevor, Changeman, Librarian.

Database - DB2, Oracle, Sybase, MS Access, MySQL, Cache.

PROFESSIONAL EXPERIENCE

HENRY ELLIOTT & COMPANY, INC., Wellesley, MA

3/2012 - 4/2014

Healthcare IT Analyst, Consultant at CarePoint Health, Hoboken, NJ

Custom report writer for Quadramed Affinity and Meditech. Duties include

research, analysis and creation and development of adhoc reports and data

extraction requested by the hospital user communities and outside vendors

to meet complex business needs to assist in day to day operations.

TECHNISOURCE INC, Irvine, CA

4/2010 - 5/2010

Healthcare IT analyst, Consultant at Hoag Hospital in Newport Beach, CA

Query Writer using Quadramed Affinity query language for the implementation

of the new hospital system.

NC DEPARTMENT OF HEALTH & HUMAN SERVICES, Raleigh, NC

2003 - 2010

Business and Technology Application Analyst

Public Health Project technical team member assisting in the maintenance

and enhancement of various health services information systems including

Medical Management and the WIC federal program.

. Provided technical support for installation, testing, and implementation

of software releases and program development for the medical applications

management system using Quadramed Affinity System.

. Created and maintained user security, menus, report batches, exports and

downloads.

. Managed and automated projects involving Quadramed Affinity application

utilizing Visual Basic, Microsoft Access, VBA, SQL, TCL, KSH, CSH, SFTP,

TCP/IP, Sybase and Cache in the UNIX and Windows platform.

. Developed ad-hoc reports using the Quadramed Affinity Query/Reporting

tools for the medical clients.

. Provided technical support for WIC federal program; developed and

maintained mainframe on-line and batch applications using DB2, COBOL,

CICS, VSAM, Easytrieve, SAS, Endevor and JCL in an OS/390 environment.

PROGRESS ENERGY, Raleigh, NC

1998 - 2003

Senior IT Analyst

Partnered with clients to determine technical needs in support of business

objectives. Developed systems to support corporate accounting, government

regulatory and work management requirements for wide range of departments.

. Developed and maintained interfaces utilizing Mercator

middleware to transform data and replicate business process

from PeopleSoft HR/Oracle Financials to Indus Passport work

management and supply chain system.

. Provided technical support for Oracle financial applications

(G/L, PA) and utilizing Oracle development tools including

Developer 2000, SQL Plus, PL/SQL, SQL Loader, Toad and Unix

shell scripts.

. Provided technical support for various new and existing

mainframe systems which includes developing and maintaining

applications using COBOL, DB2, VSAM, CICS, DATACOM, SAS and

IBM utilities.

. Contributed to data warehouse projects on DB2 and Oracle to

create and support all codes for loading of data and built

underlying objects required to optimize SQL generated by

Business Objects or MS Access.

UNIVERSITY OF NORTH CAROLINA HOSPITALS, Chapel Hill, NC

1997 - 1998

Data Base Analyst

Implemented and supported DB2 databases and multiple application

development projects.

. Performed DB2/DBA duties including creating and modifying

database storage structures and objects using Platinum

utilities; allocating system storage and planning future

storage requirement; controlling and monitoring user access

to database; backing up and recovering, and monitoring and

optimizing database performance.

. Provided 24 x 7 DBA on-call support.

. Provided database modeling, design, implementation and

performance tuning for both object and relational databases

used within the IS communities.

. Developed batch conversion programs using COBOL and IBM

Utilities to create and reformat data from various vendor

systems and loaded to DB2 databases.

. Developed batch programs using COBOL to extract the medical

data from HL7 messages and store in DB2 tables.

. Developed an online CPT/HCPCS tracking application using

DB2/CICS which allowed medical staffs to view, edit and

validate medical billing code.

UNITED PARCEL SERVICE, Mahwah, NJ

1994 - 1997

Senior Programmer

Participated in the development of the Delivery Information System, a

mission critical project that provided millions of customer's instant

access to the data pertaining to their shipments.

. Performed multiple-tasks in application development projects on both PC

and mainframe. Responsible for maintaining and enhancing Business

Development Reporting Systems using COBOL II, VSAM, DB2 and Easytrieve in

mainframe batch environment.

( Actively involved in ad hoc requests for corporate, sales and

marketing users requiring data collection from various platforms

including mainframe, VAX, client server and PC. Special reports produced

by using Easytrieve on the mainframe, using Microsoft Access to collect

data from Oracle database and wrote Unix scripts to extract information

in a HP-UNIX client server environment.

EDUCATION

Middlesex County College, Edison, NJ

Certificate in Health Information Coding, completed 12/2012.

Rutgers University, New Brunswick, NJ

Certificate in MCSD for .NET (Microsoft Certified Solutions Developer)

completed 3/2011.

Wake Technical Community College, Raleigh, NC

Certificate in Database Programming and working on various Certificate

Programs in computer programming

The Chubb Institute, Jersey City, NJ

Diploma in Computer Programming, G.P.A. 92

Pace University, New York, NY

Completed courses towards Management Information Systems Degree

Contact this candidate