|
HARDWARE:
IBM PC Compatible 286, 386, 486 & Pentium, IBM RS/6000, DEC Microvax,
11/782, 11/780, 8250, 8700, 8800, DECstation 3100, 5000, Alliant FX/8, AT&T
3B2, 3B5, 3B15
OPERATING
SYSTEMS: Windows
Server 2003, Windows XP Pro, 2000,ME,98/95/3.1, Unix System V, AIX, Berkeley Unix, VMS,
DOS
SOFTWARE:
SQL Server 2005 2000 7, FrontPage 2003, Classic ASP, ASP.Net, SQL, T-SQL, SQL Anywhere, VBA, MS Access 2007 2003 2002 2000 97, QODBC, HTML, C, BASIC, MS Word, Excel
CONSULTING
EXPERIENCE:
Home Builder, Mt. Laurel, NJ
Building/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
Pharmacy/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.
IT Company, Mt. Laurel, NJ
Medical - Hospital/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.
Software Company, Wilmington, NC
Insurance/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
Sub-contract support (January 2004 � Present)
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
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
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
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.
Telemarketing Company, West Palm Beach, FL
Telemarketing/Software Consultant (January 2001 � March 2006)
Provide on-going support to the owner, to help build custom queries,
reports and various other Access objects to run his business.
Food Service Industry Company, Clifton, NJ
Food Service/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.
Educational
Systems Company, Mt. Laurel, NJ
Educational/Software Consultant (May 2000 � January 2003)
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.
Telecom
Company, Irvine, CA
Telecommunications/Software Consultant (November 1999 � February 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.
Real
Estate Company, New York, NY
Real Estate/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
Telecommunications/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
Telecommunications/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
Publishing/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
Telecommunications/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 he calculated output using an ActiveX
control. Developed a financial tracking application using Visual C++ with a
FoxPro database.
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 for selects, inserts and updates.
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 written by Dunn
& Bradstreet. 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. Developed an Xwindows application
using C and Xlib routines. 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. Also 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. Supervised two system
administrators.
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. Responsible for trouble-shooting all problems with communications
devices.
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 as a contractor
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
Additional
Courses: Visual C++, Lotus Notes, FastTrack to Sybase, PowerBuilder User�s
Group Conference �98
|
