resume

CYNTHIA WANG G. P.O. BOX 30562 Bethesda, MD20824 email:csw_roche@yahoo.com

OBJECTIVE

Highly motivated and innovative PeopleSoft Technical Analyst / Developer with solid technical and business system background seeks a career opportunity. Broad range of knowledge in different platforms and operating systems. A troubleshooter with excellent analytical skills - a strong implementer.

TECHNICAL SUMMARY

PeopleSoft: HRMS 8 SP1, FINANCIALS 8.4, PeopleTools 8.18, PeopleCode, SQR/SQL, PS Query, Data Mover
Web Development: HTML, XHTML, XML/XSLT (SGML , DHTML), CSS, JavaScript
Object Oriented Programming: Java, Servlets, Java Database Connectivity (JDBC), JavaBeans, Swing, JSP, JDK 1.3.1
Databases: Oracle 8i, Oracle 7.3, SQLDBA, SQL*Plus, SQL, PL/SQL, SQLTALK, MS SQL Server 2000, SQL Analyzer, Enterprise Manager (DTS), MS Access
Communication: SQL*Net, XcelleNet, PCAnywhere, PCPLUS, ReachOut
Microcomputers: FOXPRO, MICROFOCUS COBOL II, DBASE III PLUS, Windows 95/98/NT/2000/XP, MS Word, MS Excel
Mainframe: DOS/VSE JCL, OS/MVS, COBOL, CICS, VSAM, ICCF, VM/CMS, NATURAL/ADABAS
Misc: Unix / telnet, Lotus Notes, JDK 1.3.1, MS-FTP, SQR RUNNER , STAT
Environments: IBM AIX/6000 IBM 3081-K, 4381-12, 3083 IBM 486, 586 , ES7000

BUSINESS EXPERIENCE

DC Public Schools, IT Specialist (12/02 - present)
Washington DC

Support the implementation of PeopleSoft HRMS 8.1 (Payroll and T&L ) and Financial Systems 8.4 (Purchasing, A/P, G/L). Tree maintenance, workflow setup, Requesters / Approvers setup, training Database preparation, Query development, daily operation support, etc. Participated in the development and implementation of User Preferences for the Purchasing Function. This included accumulating and loading 500 Business Managers and setting up access rights.
Maintain and audit the development / production of the PS Security Administration. Set up permissions, roles, and users. Query tree and tree security setup. Develop and maintain security related SQR reports.
Analyzing, designing and developing customized/interface/reports using people tools, PS Query, SQR, PeopleCode, etc.
Coordinating the work of other in-house specialists and outside contractors.
Troubleshooting all systems supported and assisting customers (500 requesters / approvers and 400 timekeepers / time approvers) and other support personnel on projects related to PS systems.
Designing, testing, implementing, maintaining, and administering databases/applications on Microsoft SQL Server.

Manor Care Inc. (Acquired by Home Health Care in 1998)
Senior Programmer Analyst (10/90 - 12/96)
Silver Spring, Maryland

Supported PeopleSoft Human Resources system (a client/server application). Functioned as an Application Database Administrator. Responsible for all aspects of system works including design, trouble shooting, and direct end user support.

Updated PeopleSoft Human Resources System from version 4.0 to 5.0
Participated in the design of a six million dollars payroll project that converted the legacy Payroll system to PeopleSoft payroll system.
Benchmarked study of the payroll processes on different IBM power PCs.

Supported legacy Cyborg Payroll and Human Resources system. Supported with project planning, project definition, requirement definitions, analysis testing, systems documentation and user training on small and intermediate size development and enhancement projects. Provided solutions for complex business problems

Managed the rollout of Field Data Entry system to 260 subsidiaries nationwide.
Designed & implemented a direct deposit subsystem which was developed on IBM VSAM/CICS/ESA platform in conjunction with FOXPRO databases on IBM PC, taking advantage of remote processing and microcomputer up/download software such as XcelleNet, PROCOMM PLUS to download data from mainframe system and transmit to banks.
Implemented a Front-end subsystem to control employee time cards transmissions by XcelleNet from 260 subsidiaries to headquarters.

Genlyte / Lightolier Inc.,
Senior Programmer Analyst (2/89 - 10/90)
Secaucus, New Jersey

Responsible for the Accounts Receivable system of a $ 500 million dollar company including three companies and four divisions. Managed all aspects of systems including conversion, implementation, user training, maintenance and enhancement.

Managed the technical transfer of the system from a separate data center in Union, NJ.
Converted a $200 million dollar division from another Accounts Receivable system to the ASI system. Project was completed on time and within budget and resulted in a reduction of the outstanding receivable and the elimination on one clerical position.
Headed the project to upgrade the system to a new release. Defined schedule, conducted weekly user meeting, converted successfully on schedule.
Defined control procedures for MIS and accounting to ensure system integrity and reconciliation with other systems.
Improved the performance and efficiency of the system including: tuning VSAM files for better on line performance, reducing the daily batch cycle time by 30%, decreasing file space by 20%.
Developed computer operations documentation; worked with operations to improve production control procedures.

Programmer Analyst (8/87 - 1 /89)
Participated in the modification and implementation of the American Software Inc. Customer Order Processing System

Full responsibility for customer master subsystem.
Tailored in-house programs to the new system.
Customized the package purchased from American Software.

EDUCATION

The Chubb Institute Reston, Virginia 2002
Web Development & Business Programming Diploma
Projects included:

Designed and implemented a full-featured e-commerce web site utilizing JDBC, Java, JavaScript and XML/XSL;

Utilized (client side) JavaScript and (server side) JSP and Java Servlets for e-commerce application;
Provided process for customer feedback via e-mail, utilizing JavaScript;
Linked website to Oracle database, updated product information, assigned customer identification numbers and checked order status;
Modified and created object-oriented Java programs utilizing Java functions, structures and classes, debugging techniques and exception handling;

Created dynamic and interactive web pages with CSS, JavaScript, and XML classes;
Migrated MS Access database to Oracle 8i database, exported, modified, and queried tables.
Created GUI programs using JFC.

University of North Texas Denton, Texas 1987
MBA in Business Computer Information System

University of Chinese Culture Taipei, Taiwan
Bachelor of Arts in English

PeopleSoft University Training

TOOLS I 8.4 Jan. 2003
TOOLS II 8.4 Jan. 2003
SQR 8.4 March 2003
PeopleCode 8.4 May 2003
WorkFlow 8.4 November 2003

PeopleSoft Webcasts Training