|
Education
California
State Polytechnic University, Pomona
-
MSBA, Major: Information Systems Auditing (2001) (GBA: 3.88)
-
Awarded a Scholarship from the International Center (2000-2001)
-
Selected for membership in Beta Gamma
Sigma (on May 6, 2000)
Middle-South
University of Finance & Economics
Wuhan, China
B.A.,
major: International Finance, minor: Accounting (1998)
|
|
Work Experience
Independent
Contractor – IT Consultant (Part-Time, 09/03 – Present)
Independent Projects: (ASP/MySQL)
Consult
Inc. dba Personal Consultants
Walnut, CA
Computer
Programmer / Application Developer (Full-Time, 05/01 – Present)
-
Develop a program to translate print file into meaningful
data to MySQL database. Write a web site to allow displaying / editing /
generating & emailing PDF letters.
-
Create a web program for timecard punch in/out and payroll
reports.
-
Develop a production scheduling/tracking/material
allocation/barcode scanning system. Material Resource Planning (MRP) and
monitoring reports. Sales analysis and commission reports.
-
Add a custom feature in SBT VP accounting system to
calculate monthly interest.
-
Write a program (FoxPro) to calculate inventory demands
-
Develop a system (in VB & FoxPro) to extract data from
MAS90 and provide additional marketing information and reports
-
Install, map and customize EDI-Jump program to bridge the
EDI system and the accounting system (ACCPAC / SBT Pro Series)
-
Develop an Online Shopping Store, including a self-developed
shopping cart and a program for remote auto-connection with the back-end
accounting system (ASP, Individual Work)): http://www.mtnproducts.com/
-
Photoshop 6.0 Training for a client
-
Develop a Text file reformation Program and a Label
generation program written in ASP and MS Visual FoxPro 6.0 (Individual
Work)
-
Program an Online Timesheet management system (ASP,
Individual Work)
-
Develop
an Online Loan Management Application Project, including customer/
loan/payment/salesperson/commission/report management features and dynamic
graphical charts (ASP / MySQL database / Individual Work)
California
State Polytechnic University, Pomona
Webmaster
(individual work) for Paul Sommers in the Lily Center. (PT, 11/00-09/01)
-
Apply ASP, HTML, MS Access DB, SQL, VB/Javescript,
Dreamweaver, Frontpage 2000, Photoshop 6.0, Flash 5.0, IIS 5.0, ODBC www.cisdept.csupomona.edu/psommers/new-site
Technical
Assistant for Dr. Anwar Salimi in the Accounting Dept. (PT, 09/00-06/01)
-
Create MS Word/Excel Spreadsheets;
Assist WebCT file manipulation
-
Design Internet Survey forms (using EZSurvey software--CGI)
on Unix
-
Apply PeopleSoft Financials in the class: study PS,
configure PS program, create queries, & write instructions for
students
Student
Consultant for ITAC—Idea Lab on Multimedia Projects (Photoshop/Flash/DW)
PowerPoint
Presentation Designer for the orientation of IGE program (June 00)
Clerical Assistant for the Center
for Advanced Computer Technology(07/00-09/00)
Hua Zhong Information Technology
Inc.
Wuhan,
China
Assistant Manager in Foreign Affairs Office (1997--1999)
|
Skills
-
Operating Systems: Windows 95/98/NT/2000/XP
-
Database: MS Access, Oracle8i, MySQL, SQL Server 7
-
Web Design – FrontPage 2000,
Dreamweaver, Photoshop, ImageReady,
Flash,
HomeSite, TextPad, Raosoft EZSurvey
-
Programming – ASP.NET, VB.Net, SQL, HTML, CSS, ASP, VB / Java
Script, Visual Basic, Java, Visual FoxPro
-
Presentation & Reporting: MS Word,
Excel,
PowerPoint, Publisher, Illustrator
-
Systems Design — Rational Rose C++, Erwin
-
IT Auditing: MS Excel / Access,
IDEA,
Cisco Secure Scanner
Languages: English, Chinese (Mandarin)
|