Feng (Fanny) Li

acsfp8@r.postjobfree.com

808-***-****

OBJECTIVES Seeking a software developer position utilizing 17 years of expertise in object oriented programming and analytical skills based upon customer demands.

SUMMARY

Experience with Oracle, PowerBuilder, PVCS, MS Office, Crystal Report, Sybase, MS SQL, ETL/Data Warehouse, JavaScript, JSP, WebLogic, HTML, CSS, XML, C++

Excellent organizational and communication skills.

Fluent in English and Chinese (Mandarin and Cantonese dialects).

EXPERIENCE

Information Technology Specialist IV June 2004 – Present

Department of Taxation, State of Hawaii Hawaii, HI

Provide immediate solutions to all existing applications in ITPS (ITIMS Tax Processing System), a 3 tiers

client-server Windows based program built with Power Builder, C and COBOL, which connects to Oracle. Key expert engineer in charge of ITIMS Collection System running on Windows and UNIX.

Compliance with the annual TLC (Tax Law Change) for program changes. Gather interface, business and reporting requirements from users on regular basis. Generate technical documentation for system maintenance and future enhancement. Perform unit and regression tests for quality assurance and system consistency.

Design and modify application objects in PowerBuilder 11.5, develop SQL scripts, stored procedures and relational database objects in Oracle 11.2. Utilize PVCS as version control and Project In Box as project management tool to log ITPS incidents, assign to developers, record solutions and keep tracks of all modified objects. Create test plans to reflect and verify the accuracy of system changes. Compile and promote code in development and system test environments. Optimized performance of Crystal Reports by reviewing business and technical specifications, analyzing database structure, and tuning up stored procedures in Oracle 11.2 SQL * PLUS.

Responsible for a 24 hours On-Call technical support. Handled emergency assistance for quick solutions. Respond to users' questions and act as advisor or coach to new or junior personnel.

Enhanced an Audit Data Warehouse project as a lead technical analyst in a team of 5. Designed data models (schema, mappings and processes) using Pervasive ETL product Data Integrator 9. Trained users how to create inquiries and reports through Business Intelligent tools.

Guided webmaster to develop Internet and Intranet portal by utilizing HTML, JavaScript, CSS and RSS

news feed technology.

Program Analyst Jan. 1998 – Feb. 2004

ADP/Power Securities System New York, NY

Participated in the conversion of a client-server application from PowerBuilder to a web-based program using J2EE and Web Logic 6.1(ASP model). This software was designed to help small to medium size brokerage firms settle and clear securities transactions.

Primary responsibilities included web page design, JSP coding (menu, browse, add, edit pages, data entry pages, report function with groups and computed fields etc.), and making sure interfaces were user-friendly.

Created relational database (tables, indexes, stored procedures and triggers etc.) to enforce business rules and referential integrity.

Responsible for user acceptance testing to ensure data integrity and multi-user consistency.

Maintained the client-server application built by Power Builder 6.5 and 8.0 accessing Sybase 11.9.2 and MS SQL Server 2000.

Part of 24 hours on-call rotation support team to answer clients' questions and resolve technical issues.

Application Developer Sept. 1997 – Dec. 1997

Results Management Inc. New York, NY

Developed a client-server application using PowerBuilder, Sybase and MS SQL Server 6.0.

Created tables, data windows, reports, stored procedures and triggers to fulfill business requirements.

Participated in software testing to ensure multi-user accessibility and user-friendly interfaces.

Modified and enhanced existing system applications upon client requests.

College Assistant 1995 – 1997

Bernard Baruch College New York, NY

Tutored students in mathematics assessment tests and various courses.

Helped students improve their problem solving skills by creating simulated exams.

EDUCATION AND CERTIFICATIONS

Bernard Baruch College, New York

1994 – 1998

Bachelor of Business Administration in Computer Information System.

Dean’s list 1995 – 1998.

Honor student in Phi Eta Sigma Honor Society 1995 – 1998.

Overall GPA: 3.75/4.0 Major GPA: 3.9/4.0

PowerTier J2EE Training Certificate, New York 2001

Contact this candidate