Management Medical

Alice S. Lee

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

Edison, NJ *8837

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

Cell Phone: 919-***-****

Email: ******@*******.***

OBJECTIVE

Utilize my database management and computer programming experience as an

Application Developer to contribute to the resolution of technical issues

that contradict business objectives.

PROFESSIONAL SUMMARY

IT Professional with extensive experience in applications development,

database analysis and programming in the transportation, healthcare and

utilities industries. Organized contributor who works efficiently and has

a track record of completing projects on schedule. Strong analytical

skills combined with ability to learn new applications quickly contribute

to team versatility and meeting customers' unique and diverse needs.

TECHNICAL SUMMARY

Software-Mainframe:

COBOL, DB2, CICS, Easytrieve, VSAM, Datacom, Indus Passport, Basic

Assembler Language, SAS, MVS/ESA, MVS/JCL, TSO/ISPF-PDF, SQL, DB2

Utilities, QMF, SPUFI, IBM Utilities, Xpediter, Intertest, Fileaid

Abendaid, Endevor, Changeman, Librarian.

Software -Windows/UNIX:

Quadramed Affinity and Quadramed Query Language, Oracle PL/SQL, SQL Plus,

SQL Loader, Toad, C++, Java, MicroFocus COBOL, Business Object, HTML, XML,

Microsoft Office, Visual Basic, Microsoft Visual Studio .NET, SAS, Visio,

PERL, SQL, KSH, CSH, Tcl/Tk,, PuTTY.

Web Development - Apache, HTML, XML, XMLSpy, Frontpage, Photoshop,

Dreamweaver, Flash.

Middleware - Mercator, MQSeries, DB2Connect.

Database - DB2, Datacom, Oracle, Sybase, MS Access, Business Object, MySQL,

Cache.

Network Protocol - SFTP, TCP/IP.

PROFESSIONAL EXPERIENCE

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 .

. 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 input to the application architects for WIC in mainframe for

maintenance techniques and problem resolution; analyzing and documenting

client requirements; designing and implementing application solutions.

. 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

primary 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 database 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.

. Wrote batch conversion programs and performed system

functions using IBM Utilities to create and reformat data

from various vendor systems and loaded to DB2 databases.

. Designed and built an on line 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. Developed applications

using standard methodology and completing a project life cycle, including

program specifications, system and program flows, codes, tests and

debugging.

. 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

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