DANIEL E. GUSTAVSEN
91 Flyatt Road, Shamong, NJ 08088
[Send email using form at bottom]
http://www.gsystemscorp.com

 
HARDWARE:  IBM PC Compatible 286, 386, 486 & Pentium

OPERATING SYSTEMS:  Windows Server 2000/2003, Windows XP/2000/98/95/3.1

SOFTWARE: SQL Server 2005 20007, T-SQL, SQL, FrontPage 2003, JavaScript, Classic
ASP, ASP.Net, VBA, MS Access 2007 2003 2002 2000 97, QODBC, HTML, BASIC, MS Word,
MS Excel


CONSULTING EXPERIENCE:

Software Company, Somers Point, NJ
ASP/Software Consultant (December 2007 – Present)
Integrate VPASP shopping cart into multiple websites involving advanced use of
CSS.

Leasing Company, Mt. Laurel, NJ
ASP/Excel Consultant (August 2007 – Present)
Enhance and modify and Excel application with extensive VBA that is sent to
clients as a sales tool. Maintain and enhance 5 classic ASP websites.

Limousine Company, Delran, NJ
Access/ASP Software Consultant (March 2007 – Present)
Build new reservation system in Access 2007. Build in Drag/Drop on reservation
page for ease of rescheduling of vehicles. Migrate data from old system. Add
secure page to company website for customers to request reservations in ASP.

Publishing/Telecommunications Company, Parsippany, NJ
Access/SQL Server Software Consultant (January 2007 – Present)
Clean and modify reports in Access 2003 application. Build process to generate
reports to Excel in Access. Migrate SQL 2000 database to SQL 2005.

Home Builder, Mt. Laurel, NJ
Access/SQL Server Software Consultant (July 2006 – Present)
Build sales system in Access database with similar functionality to ACT. Add
enhancements to work order and purchase order processing area of Access system.

Pharmaceutical Inventory Company, Burlington, NJ
Access/Software Consultant (April 2005 – Present)
Design and develop an Access 2000 application to import external drug
information data from major drug companies. Before loading the data into the
corporate drug database, the user has available many tools in the application to
manipulate the data for a desired load manipulation.

Hospital, Philadelphia, PA
ASP/Access Software Consultant (January 2005 – Present)
Convert Access applications into ASP intranet pages with call to data in SQL
Server. Upgrade Access97 mdb’s to Access 2000. Add additional functionality to
Access reports that read from the corporate Unicare database. Develop a leads
database and client application with Access and SQL Server for the Renfrew Center
telemarketing group. Provide a series of reports for the management to analyze
the data. Clean-up Sales Logix SQL Server contact database for the Renfrew
Center. Generate lists of contacts with addresses based on various criteria
provided by the staff for them to examine.

Telecom Company, Westlake Village, CA
Access Software Consultant (January 2001 – Present)
Build commission reporting system in Access 2007. Run monthly billing/revenue
process.

Telemarketing Company, West Palm Beach, FL
Access Software Consultant (January 2001 – Present)
Provide on-going support to the owner, to help build custom queries, reports and
various other Access objects to run his business.

Software Company, Wilmington, NC
Access/ASP Software Consultant (June 2000 – Present)
Design and develop Access2000 reports, VBA, and queries for mailings and
management against an Adaptive Server Anywhere 6.0 database. Built and currently
maintaining a web based insurance quote application developed in FrontPage 2003
with extensive ASP. This application is connected to an access database to
capture quote information. All bound quotes are turned into insurance policies by
the insurance company client.

Networking Company, Beverly Hills, CA
Access Sub-contract support (January 2004 – June 2006)
	Designed and developed an inventory management system in Access for a jewelry
broker in CA.

Developed an ASP based scorecard for a High Schools website in CA.

Designed and developed Access 2003 database for E! Entertainment, to compare
advertising data in two different corporate databases. Most of the application
consists of complex SQL and reporting. Cleaned up and deduped a GoldMine database
for a Real Estate company.

Consulting Company, Tabernacle, NJ
Access Software Sub-Contractor (February 2006 – July 2006)
Build Excel Import/Export from Access database to Excel files for a home
builder. Add enhancements to work order and purchase order processing area of
Access system.

Telecom Company, Huntington Beach, CA 
Access/ASP Telecommunications/Software Consultant (April 1998 – April 2006)
Design and develop a commission reporting database in MS Access97 using VBA for
processing, manipulation and management of sales people and assignment of custom
rates to accounts. Responsible for migration of customer traffic from
MCI-WorldCom to  Sprint. Advise WNC in their selection of a new billing company
and transition of the billing data to this new company. Design and develop a
provisioning module in Access/VBA for customer service staff.  Design and develop
a mail merge process for collections, which is driven by aging data. Design and
develop company website (Outsourced graphics) using FrontPage 2000 and ASP for
Access database connectivity. The database portion of the website is restricted
access to sales agents of the company only. Migrate customer base from Sprint to
Qwest Communications. Migrate customers to new billing platform. Designed and
developed a billing application in Access 2003 that allows this client to bill
the VOIP international traffic to their customers.

IT Company, Waterford, MI
Access Software Sub-Contractor (November 2005 – April 2006)
Design and develop an Access 2000 and SQL Server 2000 application enhancements
for various clients. Write import and scrub process for leads from outside
source. Develop process to read a text report and import the appropriate data
into a SQL table.

Food Service Industry Company, Clifton, NJ
Access/SQL Server Software Consultant (January 2001 – November 2005)
Designed and developed Access database objects (Forms, Queries, Reports, and VBA
code) in Access 97 as a client application. Create server portion of the
application in SQL Server 2000, building tables, views, stored procedures, DTS’s
and views. This database is currently housing 70 million sales records. On a
daily basis the application supports 20 users. On a quarterly basis the
application generates manufacturer rebate calculations based upon sales data from
restaurants. Integrate ComTech accounting software into the system mentioned
above to process payment checks to customers. Migrate Access 97 client to Access
2000. Built an interface from SQL Server 2000 to QuickBooks via stored procedure
using QODBC driver to add checks.

Telecom Company, Irvine, CA
Access/SQL Server Software Consultant (November 1999 – Feb 2003)
Design and develop all applications needed to support the business. Applications
consist of: Sales order entry application in Access 97/2000 for contracted sales
offices to enter orders. Design and develop order processing systems. The order
processing systems were built with Access 2000 and SQL Server with stored
procedures. The order processing applications will import orders sent from the
sales offices. Once the orders have been verified by data coming in from 3rd
party verification, an export would be run out to ASCII files and sent to the
carrier.

Educational Systems Company, Mt. Laurel, NJ
Access/SQL Server Software Consultant (May 2000 – Jan 2002)
Design and develop reporting and letter processing extensions to the existing
application in Access 97/2000. Converted application to Access 2000, and migrated
all Access tables to MS SQL Server 2000.

Real Estate Company, New York, NY
Access Software Consultant (January 2000 – June 2002)
Design and develop ledger database objects (Forms, Queries, Reports, and VBA
code) in Access 2000.

Telecom Company, Orlando, FL
Access/SQL Server Software Consultant (October 1999 – January 2001)
Design and develop a custom call record re-rating application in Access 97 which
would re-generate the call records at the new price specified by the user, and
generate invoice along with summary reports of usage by country. Make
enhancements to an existing Access 97 billing application with data stored in SQL
Server 6.5.

Telecom Company, Cincinnati, OH
Access/SQL Server Software Consultant (October 1999 – December 2000)
Design and develop collections application in Access 97 to interface to SQL
Server 7.0 tables from Cost Guard billing system. Based upon aged billings, the
application would generate 30, 60, and 90 day late letters to be mailed to
customers. Built a commissions payment system for the finance department written
in Access 97. All tables are in SQL Server 7.0. In order to speed the application
a host of stored procedures were written to first summarize the data. This system
would be run on a monthly basis and would process through over 20 million
records. Both of these applications required extensive use of VBA and Embedded
SQL.

Publishing Company, Cherry Hill, NJ
Access Software Consultant (October 2000)
Design and develop a data migration utility to take exported ASCII data from an
editorial database and import into an Access 97 database. Most of the application
consisted of VBA.

Telecom Company, City of Industry, CA
Access Software Consultant (July 1999 – January 2000)
Responsible for migration to a new telecommunications billing platform,
providing system requirements, functional specifications, and business solutions
for billing, provisioning, commissions and collections.

 Software Consultant (October 1993 - October 1994) 
Converted Fortran chemical reactor program to VC++ 6.0. Integrated the
application into MS Windows and graphed the calculated output using an ActiveX
control.

EMPLOYMENT:

OHANA SYSTEMS, Kennett Sq., PA
Senior Programmer Analyst (June 1997 to June 1999) 
Developed an adjudication system for a major insurance company, using
PowerBuilder 6.0 and 5.0.03 with Sybase XI as the backend database. Developed
stored procedures in SQLAnywhere and Sybase. Implemented and integrated HOW and
PFC business objects into the application and developed overloaded functions
within NVO’s.  Provided guidance to junior PowerBuilder programmers.

THE FURST GROUP, Shamong, NJ
Senior Programmer (January 1996 to June 1997) 
Designed and developed database objects and stored procedures in Sybase XI for a
new leads management system.  Supported and enhanced the Furst Group’s Sales
Management System written in FoxPro 2.5 (DOS). Provided project leadership and
direction to a software developer and help desk support to the Sales Management
System managers. Worked as a team member to develop a sales system prototype in
Delphi 2.0.

SAKS FIFTH AVENUE, Lawrenceville, NJ
Senior Programmer Analyst (November 1995 to December 1995) 
Enhanced and maintained PowerBuilder portion of a SmartStream application.
Developed a PowerBuilder prototype to demonstrate the feasibility of replacing
the SmartStream application with PowerBuilder. 

DATAPRO Information Services/McGraw Hill, Delran, NJ
Business Systems Analyst (January 1991 to November 1995) 
Designed, developed and tested a Client/Server magazine viewer application,
using PowerBuilder V4.0. Worked in a lead role to develop, maintain and support
Datapro's telemarketing system on an IBM RS/6000, using a 4GL language and C
routines. Developed a large suite of Kshell and Cshell programs for user access
and administration of the RS/6000. Integrated WordPerfect into Datapro's
telemarketing system with custom routines to automatically generate custom price
quotes, letters and invoices for customers. Analyzed, designed and developed a
financial, earned revenue forecasting model, using FoxPro 2.5.

DIGITAL EQUIPMENT CORPORATION, Manalapan and Mt. Laurel, NJ
Software Specialist (April 1987 to January 1991) 
Maintained, enhanced and supported DEC’s BX.25 layered communications package.
Developed BX.25 application software, written in C language, to allow
communication through a packet switched network at the session and packet levels.
Provided technical support to customers of this software. Modified and adapted
BX.25 user interface software, written in C and VMS DCL code, to operate in a
Unix System V environment. Modified BX.25 kernel software. Provided technical
sales support to sales team and customers for networking and systems solutions
involving Ultrix RISC workstations. Used various communications packages, such as
TCP/IP on VMS and UNIX, Datakit and ISN.

AT&T BELL LABORATORIES, Holmdel, NJ
System Administrator (November 1985 to April 1987) 
Organized computer lab for the Advanced Decision Support System group with two
FX/8 parallel processing Unix systems. Developed hardware specifications and made
evaluations, proposals and contracts for services and support. Created an
Ethernet network between the two systems for ease of data transfer and system
administration. Developed software to automate administration functions.

RCA, Sommerville, NJ
System Administrator (October 1984 to November 1985) 
Managed a VAX/VMS 11/782 system. Planned, implemented and upgraded system
software and hardware. Maintained DECnet links between home office and foreign
facilities.


L.J. GONZER ASSOCIATES, Red Bank, NJ
Senior Computer Graphics Designer (May 1983 to October 1984) 
Under the IBM MVS-TSO system, developed Clists and command files for AT&T Bell
Laboratories. Graphically created PC components from manufacturer data sheets,
printed wiring boards consisting of 2 through 12 layers, and wire wrap images.

EDUCATION:
Brookdale Community College, Lincroft, NJ A.A.S. Computer Science 1982
Major: Computer Science