Andrew
Stotzer
Ø
Andy@Stotzer.com
Ø
Download a Word Document
Certified Windows Development Professional with over seventeen years of experience in project management, system analysis and design, development, installation and support. Certified in Visual Basic by Microsoft Corporation.
Purchased a MSDN Universal subscription to continue to learn the new features available for VB and ASP in the new .NET architecture, in an effort to maintain a skill set that is current with Client-Server and Web development technologies.
Major strengths include:
Ø
Visual Basic
Certification Ø
OOD/OOP Ø
Structured
& Aesthetic Design
Ø
Project
Management Ø
System Analysis
& Design Ø
Oral &
Written Communication
EDUCATION:
1982 Ohio
State
University
Columbus
,
OH
BS, Business Administration/Computer
Information Science
EXPERIENCE:
1999 - 2002 PROFESSIONAL COMPUTER CONSULTANTS, INC.
SR. CONSULTANT Client:Cinergy Energy Merchant Business Unit
¨
Facilitated a Developer's Forum presentation in
¨ Developed & supported a 'Toolkit' webpage designed to manage software development standards, procedures, and tools. Created an ASP Code Generator wizard that automatically generates webpage code, including HTML, VBScript, JavaScript, and encrypted database connectivity.
¨ Developed & supported a multi-project Security System which models user’s job roles and tasks. This allows Tasks to be assigned to Roles, and Roles to be assigned to Users.
¨ Developed & supported a Project Management and Tracking website which also allows developers to enter status and time reporting. Also wrote a VB DCOM ActiveX server to generate users Excel timesheets and mail them to data entry personnel, and developed a client-server VB app to scrape and paste work time into a mainframe time reporting system.
¨ Developed & supported a Power & Transmission commodity Trade Management System, written in Visual Basic 6, which is used to buy & sell Power and Transmission Services.
¨ Developed & supported a Commodities Billing System, written in Visual Basic 6, which is used to track, process, and report billing information.
The following technologies were
used in the development of the above systems:
Ø
VB 6.0 Ø
SQL Server 2000
& Oracle 8i Ø
Windows NT/2000/XP Ø
RDO & ADO
Ø
Visual Interdev 6.0 Ø
ASP/VB Script/JavaScript Ø
MS Office Objects Ø
COM / DCOM
Ø
OO Design &
Development Ø
Macromedia Flash
& Fireworks
1998 - 1999 CONSULTANT
SR. SOFTWARE ANALYST/ENGINEER Client:Chiquita
Brands International
¨
Lead Software developer of an international, multi-million
dollar foreign exchange, commodity, and equity trade monitoring system. This system was designed to manage and track million
dollar trade transactions for this 800 company, international
organization. Features include
user-level security, email and an interface to Bank of America payment systems.
The following technologies were
used in the development of the above systems:
Ø
VB 5 (32bit) Ø
Password
Encryption Ø
Windows 95 Ø
Windows NT 4.0
Ø
RDO Ø
MAPI Ø
SQLServer 6.5 Ø
OO Design & Development
1998 – 2000 STOTZER SOFTWARE, INC.
¨ Started Stotzer Software, Inc. to market a Code Server development tool that was created for storing code, files, and web shortcuts in a code library database. Using Replication and Synchronization technology, the ‘Visual Code Server’ allows developers and consultants, who work in multiple locations (like: work; home; or client sites), to keep all of their code, and other data, up to date.
The following
technologies were used in the development of the above program and web site:
Ø
VB 6.0, JavaScript, HTML Ø
FrontPage 2000 Ø
MS
Access Replication
1997 - 1998 CONSULTANT
SR. SOFTWARE
ANALYST/ENGINEER Client:Sarcom Engineering
¨
Sr. Software Analyst/Engineer involved in development and
deployment of a replicable construction bidding, tracking, and management system.
Responsibilities included testing and bug fixes; creating an OLE Automation
Archive Server; adding web ftp downloading capabilities; and writing a custom
setup program to walk users through the complicated client and server
installation process.
The following technologies were
used in the development of the above systems:
Ø
VB 5 (32bit) Ø
OLE Automation Servers Ø
Windows 95
Ø
DAO Ø
MS Access Ø
Web Objects
1997 - 1997 CONSULTANT
SR. SOFTWARE ANALYST/ENGINEER Client:Component Software
International, Inc.
¨
Software Engineer, involved in design and development of
five Remote OLE Automation Servers for backend processing in a Health Care
Industry project. These five reusable
components were developed using VB 5.0 for the Remote Automation Server
components, with late binding to allow plug-and-play of the separate
components.
The following technologies were
used in the development of the above systems:
Ø
VB 5/4
(16/32bit) Ø
Remote OLE Automation Ø
Windows 95 Ø
Windows NT 4.0
Ø
RDO, DAO Ø
Reusable
Components Ø
SQLServer 6.0 Ø
Class Objects
1996 – 1997 CONSULTANT
SR. SOFTWARE CONSULTANT Client:Zaring Home
Builders, Inc.
¨ Developed a ‘Home Sales’ Wizard to assist Sales People in Selling Homes built by a local Home Builder. This system walks the user through all the steps, from picking the home site and house options, to adding contract addendum and pricing. The program used Remote Access Services (RAS) to dial into the Division Office and email contracts, database, document updates and new self-installing .exes’.
¨ Full cycle development and installation of a Data Replication System to maintain Corporate, Division, and Laptop Databases. This system was developed using VB 4.0, Access 7, Windows 95 and MAPI.
¨ Full cycle development and installation of a Contract Mail program, to manage incoming and outgoing emails at all District Offices. This system watched email messages, and loaded incoming emails into the Division or Corporate.
The following technologies were
used in the development of the above systems:
Ø
VB 4.0 Ø
RDO, DAO Ø
Windows 95 Ø
Remote Access Services(RAS)
Ø
MAPI / RAS Ø
SQLServer
6.5 Ø
ODBC Jet Engine Ø
MS Access 7.0
1994 - 1996 CONSULTANT
SR. SOFTWARE CONSULTANT
Client:General
Electric Credit Card Services
¨
Performed
Technical Interviews covering Visual Basic; SQL; SYBASE; SQL Server and MS
Access.
¨
Participated in
the development of a ‘Customer Workstation’ project; designed as a front-end to
a mainframe CICS system. This system
automated customer credit card account maintenance.
¨
Developed &
supported an Account Maintenance System in VB to automate the maintenance of
accounts on a mainframe system. This
system was designed to read a Sybase table containing thousands of accounts and
an associated ‘script’ name, and processes the script (instructions) to update
the mainframe’s front-end CICS screens.
This system was designed to allow multiple instances of it to run on the
same PC, each updating a separate emulator session.
¨
Participated in
the design, development and installation of a ‘rule based’, intelligent
Customer Retention project, designed to aid users in retaining customers who
wish to close their credit card accounts.
The following technologies were used in
the development of the above systems:
Ø
VB 3.0 &
4.0 Ø
ODBC API Ø
UNIX
Ø
SYBASE 10 Ø
SYBASE Stored Procedures Ø
Windows 3.x & 95
Ø
HLLAPI DLL
calls Ø
Emulators: IBM 3270, Extra, and Rumba Ø
MS Access 2.0
1993 - 1994 REUBEN H. DONNELLEY (
PROJECT MANAGER
Performed project management,
development and maintenance functions on a Novell network supporting Sales
Reporting; Advertising Spec Tracking; Sales Lead Assignments and ad hoc reporting.
The following technologies were
used in the development of the above systems:
Ø
Visual Basic Ø
Gupta SQLWindows
Ø
COBOL/VSAM Ø
SYBASE
1988 - 1991 NISSAN MOTOR ACCEPTANCE CORPORATION
PROGRAMMER ANALYST
Provided maintenance on an IBM 3090 for
Retail, Leasing and Collection Systems.
Developed client-server based Clipper and
Microfocus Cobol data entry and tracking systems
1985 - 1988 AVCO FINANCIAL SERVICES
PROGRAMMER ANALYST
Responsible for design, analysis, and
programming of accounting and credit insurance systems on an IBM 3090 Mainframe
using JCL, Cobol, CICS, VSAM, and IDMS.
REFERENCES: Available upon request.