Project Accounts Payable

Chi-lin Lee

Rockville, Maryland

301-***-**** (H)

240-***-**** (C)

abm53n@r.postjobfree.com

Career Objective

A responsible position within a technical environment where my

acquired PeopleSoft functional

and technical skills can be utilized and further developed.

Technical Skills

PeopleSoft : PeopleSoft Financials 7.5/8.1/8.4/8.9 (GL, Expense,

Account Payable, Purchasing, Requisition,

Project costing, Treasury), PeopleSoft HRMS 8.9,

PeopleTools, Application Designer,

PeopleCodes, Application Engine,

SQRs, Integration Brokers, Crystal Reports, PS

Query

Programming Languages: C/C++, COBOL, Pascal, Perl, Unix Shell Scripts

Databases: Sybase, Oracle, Microsoft Access, Sybase Transact SQL,

Sybase stored procedures,

Sybase Open Client/Open Server Library, Triggers,

Oracle PL/SQL, SQLPlus

Operating Systems: UNIX (Sun SPARC/Solaris, IBM RS6000/ AIX, AT&T

3B2), VAX/VMS,

Unisys A Series, IBM MVS, Windows 2000

/XP/NT, MS DOS

Change Management Tools : Harvest, Quest/STAT

Work Experience

FREDDIE MAC (Federal Home Loan Mortgage Corporation)

11/1997 - Present

Senior Technical Analyst

Act as a senior developer/analyst in the PeopleSoft Development Team.

Provide technical support for

various PeopleSoft projects.

( Participated in the HR Market Pricing project. Updated Financials

interfaces to use non-grade based employee

Information to derive approval hierarchy for expense and

requisition modules.

( Designed and developed Accounts payable ACH implementation. Modified

payment file generation programs to fit CCD layout, created new

pages to allow bank information entry, created interface between AP and

Treasury ACH Gateway. Developed interface to retrieve bank's ABA

number from Treasury.

( Developed a journal copy application engine program to allow copying

journals between different Ledger

groups.

( Supported accounts payable 1099 processing, applied 1099 patches on

yearly basis. Developed validation

queries and methodology to verify the processes and data.

( Provided support for bank reconciliation process. Developed

programs to load data file from bank and

programs to generate reports.

( Researched and developed methodology to secure the protected privacy

information in Accounts Payable

Using PeopleSoft Query Security, Roles/Permission List,

( Designed and developed interface programs to load vouchers from

other application to Accounts payable.

Utilized SQRs, Application Engines, Shell Scripts, WebMethods, etc.

( Participated in PeopleSoft Financial 8.9 Upgrade project for PS

Supply Chain. Supported upgrade on Accounts

Payable, eRequision, purchasing and eExpense modules. Reapplied

Freddie customization on PS delivered

objects.

( Provided production support, including enhancement, new functionally

development, hot line fixes

for all PeopleSoft Financial Modules (GL, Expense, Account Payable,

Purchasing, eRequisition, Project

Costing).

( Participated in PeopleSoft Financial 8.4 Upgrade project. Supported

upgrade on SQRs, PeopleCode,

Application Engine, journal interfaces for General Ledger module.

( Designed and implemented PeopleSoft Treasury module (PeopleSoft

8.1). Interfaced with a Sybase

system - Asset Trading and Liability Application System. Interface

implemented with Sybase stored

procedures, Oracle Gateway, SQRs, PeopleCode on-line enhancements,

Application Engine, batch

processing with process scheduler.

( Participated in the PeopleSoft 7.5 General Ledger implementation

project. Worked with interfaces

designing and implementation of journal loading process. The journal

entry files generated by

different corporate data sources system were loaded into PeopleSoft

General Ledger module

on a monthly basis. Responsible for developing and automating the

process with SQRs, Unix

shell scripts and Autosys (Unix scheduling package).

( Responsible for enhancement of a fee amortization system that

amortized fees incurred through

the mortgage securitization process. This supports the corporate

accounting valuation analysis

group monthly reporting and forecasting efforts. The system was

developed with C, Sybase stored

procedures, Sybase CT Library and Unix shell scripts.

( Participated in a Corporate Accounting PARIS system which calculated

the principle, interest,

amortization and reconciliation for non-mortgage-backed financial

instruments. System was

developed using Java, Visual Cafe and Sybase stored procedures.

( Provided production support for project accounting system.

Retrieved data from PeopleSoft

HR for projects time and cost. Assisted data conversion into

Project Costing module.

CompuTech

04/1997 - 11/1997

Client site : Federal Communication Commission

Senior Programmer/Analyst

( Responsible for maintaining a financial tracking system that

monitored and processed application

and regulatory fees for the Federal Communication Commission.

( Designed and developed programs for processing airwaves auction

payments. Back-end process

was written with Sybase stored procedures, Unix Shell Scripts, C

and Sybase Open client/CT-

Library. Front-end GUI was designed and developed with Power

Builder.

( Maintained a nightly load process which accepted and processed the

payment data files that were

transmitted from Mellon Bank on a daily basis. After validation,

these data were loaded into

Sybase database. Programs were written with C, Open client/ DB-

Library, Shell Scripts,

Transact-SQL and Stored Procedures.

( Participated in an electronic credit card payment project,

programming with HTML, Perl, Sybase

Web Sql, and C.

American Nurses Association

08/1995 - 04/1997

Programmer/Analyst II

( Responsible for planning and designing a membership due billing data

modeling using entity-

relationship diagram and normalization techniques. Interfaced

directly with users to define

business rules, requirements, and priorities.

( Participated in every phase of a life-cycle process in a grant

management project: preparation

of functional requirements and specifications, evaluation the

software vendor solutions,

procurement process, customization and installation, development of

user procedures, users

training, software maintenance and support.

( Designed, developed and implemented software systems including: a

Free-Literature Entry System

for customer care center, an SNA dues payment module for the

accounting department. Programs

were developed using Microsoft Access, Access Basic.

( Maintained a membership database system, created new data dictionary

items using UniData nested

relational database model and UniQuery.

Mitech Inc.

11/1994 - 08/1995

Client Site : Patent and Trademark Office

Software Engineer

( Designed and implemented new programs for PALM (Patent Application

Locator and Monitoring)

system using COBOL, DMSII Database Interface, and Work flow

language.

( Retrieved and updated data records in DMS database using ERGO (A SQL-

like extended database

retrieval language).

( Maintained a Cash Receipt and Deposit Account System. Trouble-shot

on-line transaction programs.

Created new entry screens using screen magic.

( Involved in every phase of the software development cycle,

including: interfaced with users to gather

specifications, designing, implementation, testing, and getting

approval.

From August 1990 to October 1994, I stayed at home and raised my family.

Georgetown University Medical Center Library

04/1989 - 07/1990

Programmer/Analyst

( Designed and implemented a medical facts database system using

Sybase.

( Designed and implemented a full text article retrieval system using

C, UNIX, shell script and sparrow

(a communication script language).

( Converted a PC version drug-interaction program to a UNIX/C version,

modified the screen display

function using Terminal Control package. Administered and

maintained a DNA sequencing package

on VAX/VMS(DCL).

Massachusetts Technological Laboratory, Inc

10/1988 - 04/1989

Programmer

( Maintained a contractor property management system for department of

labor. Programmed in

IBM/MVS/TSO, JCL and COBOL.

( Performed analysis and studies related to continued improvement of

automated procedures for

property acquisition, property disposal, property tracking, etc.

Created system charts and

documentation. Produced monthly reports and distributed to

contractors

Education

M.S. Computer Science, University of Kentucky.

M.S. Pharmaceutics, University of Iowa.

B.S. Pharmacy, Taipei Medical College.

Contact this candidate