Project Manager Sales Representative

QUYNH-TRAM NGUYEN TRAN

*** ***** **., *****, ** 19341

Home: 610-***-**** Cell: 832-***-**** Email: ************@*****.***

EDUCATION: Bachelor of Business Administration – 2002 Magna Cum Laude

Major: Management Information Systems

University of Houston, Houston, Texas

Career Diploma: Bookkeeping

Pennfoster University, Scranton, PA

AWARDS/

Dean’s List – Spring 1998 through Fall 2000

ACTIVITIES:

French Honor Awards – Spring 1998 and Spring 1999

Mu Iota Sigma – MIS Honor Society – Spring 2002

COMPUTER

SKILLS: Programming: MS Access VBA, VISUAL BASIC 6.0, SQL, VBScript,

Application Software: MS Access 2003, MS Project 2000, MS Visio 2003,

MS Word, MS Excel, MS PowerPoint

Financial Software: PeachTree 2005, Quickbooks Pro 2008

System Analysis and Design: Unified Data Modeling Language (UML 2.0)

Database Back-end Server Used: SQL Server 2000

Multimedia: HTML, CSS, DreamWeaver MX, Adobe Photoshop

7.0, Macromedia Flash 5, Fireworks 4.

Publishing software: Adobe PageMaker 7.0, Adobe Acrobat Professional 6.0.

Operating Systems: Windows 95/98/NT/2000, Unix, Novell

PROFESSIONAL

EXPERIENCES:

Sweeties Art, LLC - Jan 2006 to May 2006

Sales Representative, entrepreneur

Developed marketing list for Sweeties Art, LLC

Made calls to local bakeries to introduce company products

Scheduled and prepared for personal meeting with interested customers to show

products

Designed marketing materials from postcards, catalogs to websites

Communicated with company suppliers for pricing

Communicated with different vendors for company marketing resources

JP Morgan Chase Bank May 2002 to December 2002

Marketing Database Analyst

Derived and organized private banking client data from Siebel system

Created Access reports by client category for marketing manager

Communicated with different managers and associates on collecting spreadsheet data

Generated Excel graphs and Access Reports for marketing purposes

Partners Commercial Real Estate Sept 1997 to December 1997

Realtor Assistant

Made calls to property owners to ask for potential property sales

Communicated with clients who are looking for business facilities to understand their

needs and present them with appropriate location for business facility

Researched property land and facilities for clients

Planned and scheduled meetings with clients

Vanguard – Malvern, PA Feb 2006 - May 2006

Consultant and Application Developer

Gathered user requirements for new financial database application .

Developed use case diagrams in comparison between old and new application.

Developed Access application that intake data from users through advanced forms with

embedded Visual Basic (VBA).

Created dashboard reports with conditional formatting.

Written VBA so application will process intake data and produce appropriate dashboard

reports.

Communicated with end users and managers from beginning to the end of project.

VWR – West Chester, PA October 2005 – October 2006

Access Database Application Developer

Communicated with a Project Manager through project’s SDLC cycle.

Gathered Client’s business requirements.

Created Data Modeling Use Case Diagram mapping the to-be system’s functional

requirements using MS Visio 2003.

Created Database Modeling Diagram to show understanding of client’s data definition

and database relationships using MS Visio 2003.

Developed user friendly application that displays ad hoc reports and multiple views Pie

Chart, project milestones report with dashboard colors following SDLC method.

Developed User Forms with embedded Access VBA.

Created Dashboard reports.

Developed Pie Chart forms with user customized data view options.

Created Ghant Chart Report showing project milestones with dashboard colors.

Incorporated VBA coding into forms to act as switchboard connecting to multiple

categories of forms and reports.

Incorporated SQL Statements and VBA onto form controls in order to display ad hoc

query results formatted as customized report.

Keystone Mercy Healthplan (KMHP) – Philadelphia, PA December 2004 – January 2005

Application Developer

Developed MS Access applications using Visual Basic for Application (VBA)

programming language and SQL for querying language.

Developed Access (VBA) Application that query into Sybase 11 server.

Developed Application that allows concurrent multi-users with sequential customized

(VBA) auto generated Medicaid ID number that saves ample cost and time for Facets

Support and Services Department Data Entry process.

Created VBA Application that creates, maintains and tracks project time for the Data

Analysts of the Operations Department.

o The Application provides each user specific information on his/her completed

projects, open projects, current working projects.

Database Designer

Designed database tables that followed normalization rules that are based on criterion

discussed with management and end users.

Defined tables relationships that ensure data accuracy and consistency.

System Analyst

Gathered information about system request from Business Analyst and end users.

Analyzed potential system requirements using Use Case Data Modeling (UML).

Developed general Use Case Data Modeling Diagrams.

Developed a system proposal documentation.

Created a project plan for the potential system using Microsoft Project 2000.

Centocor, Inc. – Radnor, Pennsylvania May 2004 – July 2004

(Department of Pharmaceutical Development of Centocor Inc – Volunteer Project.)

Access (VBA) Work Tracking Project

Created an Access database with appropriate tables to store information collected about

each project accomplishments that a scientist is working on. There are 4 level of

Projects information stored in these tables.

Created a Switchboard that link to multiple forms with user-friendly interfaces.

Written Access (VBA) codes that enhance the convenience for the scientists on

1. Entering, viewing, deleting their daily activities, main activities, projects.

2. Automatically total their work hours for each level of project information.

3. Producing end of month reports on each project which total the hours from

all the lower level activities of a project.

4. Created user friendly functional forms.

Created tables which follow Database Third normalization rule and Entity Integrity rule.

Defined appropriate table relationships that insure the Database Referential Integrity.

Duke Energy – Houston, Texas July 2003 – July 2003

Excel VBA Developer (Contract)

Modified macro spreadsheets for Duke’s Treasury Department (VBA).

Created continually updated business graphs and reports.

Identified improvements in system macros (VBA).

Prepared system request for programmers to update system macros.

JP Morgan Chase Bank – Houston, Texas May 2002 – December 2002

Private Bank Marketing Database Administrator

Migrated data between Siebel systems using PL/SQL coding.

Created Access database structures (Database designer).

Imported and Exported data between Access and Siebel systems.

Created, modified and updated database in Siebel systems.

Searched and analyzed data from various company departments (ad hoc query).

Communicated with manager and clients on projects’ direction.

Prepared reports using Microsoft Office tools (Word, Excel, Access).

REFERENCES Available upon Request.

Contact this candidate