(714) 671-4048
PROFESSIONAL GOALS: To develop useful and innovative applications
through the creative use of current computer technology.
PROFESSIONAL EXPERIENCE:
1/07-7/07 Mercury Insurance
DEVELOPER CONSULTANT
Using Microsoft Access 2003 and 97, as well as Microsoft SQL Server 2000, upgrading legacy Access applications for compatibility with new, soon to be installed data structure. Using T-SQL, Access SQL Visual Basic for Applications (VBA), and Data Transformation Services (DTS), developing and debugging the import of data from multiple DB2 databases and other data sources into SQL Server and Access databases.
6/06, 3/07 Aimco
DEVELOPER CONSULTANT
Consolidated real estate contract data for apartment investment and management company imported from multiple Excel spreadsheets into a single Microsoft Access 2003 database. Developed custom tools for inputting, searching and generating reports. Returned in March ’07 to develop additional reports and enhancements.
9/04-1/07
DEVELOPER CONSULTANT
Developed management system for large
4/02-Ongoing PsychSites.Com
DEVELOPER CONSULTANT
Using Microsoft Visual Interdev, Microsoft
Access 2000, Cascading Style Sheets (CSS), and ActiveX Data
Objects (ADO), upgraded static Web directory of
5/03-1/05 Research Pharmaceutical Services,
Inc. (formerly Research Scientists, Inc.)
SOFTWARE
DEVELOPER
Using Microsoft SQL Server 2000, T-SQL, ColdFusion, Microsoft Access 2000, Excel, Visual Basic, and VBA, developed software tools for storing, analyzing and documenting data required by the Federal Drug Administration on behalf of pharmaceutical companies conducting drug studies. Wrote and executed test scripts for the formal validation, per FDA standards, of software used in drug studies.
12/02-4/05
DEVELOPER CONSULTANT
Using Microsoft SQL Server 2000, T-SQL and Visual Basic 6.0, developed full-featured retail store management system, including invoicing, POS transactions, back-orders, inventory, purchase orders, and discounts. Imported data from legacy DOS Paradox database system using DTS.
1/02-12/02
DEVELOPER
CONSULTANT
On an emergency basis (prior programmer had unexpectedly left the project one week before deadline), completed Microsoft Access-based system for evaluating applications to the Getty Leadership Institute. Created complex statistical reports, an interface for entering parameters and launching each of the reports, and Visual Basic for Applications programs for recreating each report in Microsoft Excel.
9/01-5/03 Research
Scientists, Inc.
DEVELOPER CONSULTANT
Designed, installed and implemented reporting system for testing of new medication with experimental subjects using Microsoft Access 2000 as a front end to a Microsoft SQL Server 2000 database. Developed numerous reports with the assistance of an RSI employee under my supervision. Created user interface and Visual Basic code for generating unique sequence of reports for selected experimental subjects depending upon each individual subject’s course of treatment.
7/00-10/01 ProcessClaims.Com
DEVELOPER
Built and upgraded web pages, stored procedures,
reports and other online applications for business-to-business e-commerce web
site serving the automobile insurance industry. Responsible for the creation and maintenance
of numerous interactive on-line reports and their user interface, coding in T-SQL,
HTML, CSS, VBScript, XML and Javascript. Used Microsoft SQL Server 2000, Microsoft
Access 2000, Microsoft Visual Basic 6.0, Microsoft Visual InterDev, ActiveX
Data Objects, Microsoft Transaction Server, MSXML.
4/00-Ongoing Institute
for Health Maintenance
DEVELOPER
CONSULTANT
Design,
installation and periodic upgrade of custom Patient Management System for
weight loss clinic using Microsoft Access 2000 to record and analyze data regarding patients’
progress and course of treatment, their referring physicians and medical
histories, the induction of new and former patients, and inquiries from
potential new patients.
4/99-5/00 BuyBidWin.Com, Inc.
PROGRAMMER
Created Active Server Pages, stored
procedures, reports and other desktop and corporate intranet tools for the
management and analysis of product, sales, operations, marketing and customer
relations information for large e-commerce web site using Microsoft SQL
Server 2000, T-SQL, Microsoft Access 2000, Microsoft Visual Basic
6.0, Seagate Crystal Reports, Microsoft Visual InterDev, Cascading Style Sheets
(CSS), ActiveX Data Objects
and ODBC.
3/99-4/99 Blue Cross of
DATABASE DEVELOPER
CONSULTANT
Consolidated a multitude of Excel spreadsheets and Access database tables into a single, consistent, searchable, easily accessible centralized database with distributed user interface for the purpose of tracking the efforts of Blue Cross (Wellpoint) business groups to prepare for the year 2000 and to correct any existing or potential Y2K-related computer problems.
11/98-3/99 Christensen, Miller, Fink, Jacobs,
Glaser, Weil & Shapiro, L.L.P.
DATABASE
DEVELOPER CONSULTANT
Developed Access 95 database system enabling attorneys to enter data regarding the cases to which they are assigned and the tasks related to each of those cases, and for management then to analyze such data in terms of workflow distribution and utilization of resources.
9/98-Ongoing
DATABASE
DEVELOPER CONSULTANT
Developing Access 95 database system to
gather, maintain and analyze government required statistics regarding
attendance at the
3/97 – 2/99 Lighthouse Group (formerly IS Group)
INFORMATION
SPECIALIST
Collaborated with a team of programmers using Visual Basic for Applications, ActiveX
controls and DAO in the design, implementation and documentation of Microsoft Access 95 and 2000 custom
database applications for clients including BMW; Nutro; Haight, Brown &
Bonesteel and KPMG. In addition, created
a number of applications for in-house use, including a database for managing
job applications, a system for administering on-line examinations, and a
Customer Support Management System that features automatic generation of email
messages to coordinate the efforts of customer support representatives located
in several cities across the
12/97-2/01 Dale, Braden & Hinchcliffe
DATABASE
DEVELOPER CONSULTANT
Using Microsoft Access 95 and Visual Basic for Applications, created Case Management Database System, and have periodically upgraded it, for use by four offices of large law firm for maintaining contact, history, court and other data pertaining to the firm’s cases and clients. Includes a dynamic, customizable reporting system that allows end users to easily design new reports. System utilizes ODBC to access a variety of data sources including Juris and FoxPro, as well as native Access data.
7/96 – 5/97 Geffner
& Bush
DATABASE
DEVELOPER/TRAINER CONSULTANT
Using Access and Visual Basic,
developed information and document management system for show business law firm
for tracking complex transactions between motion picture production companies
and labor unions. Training personnel, on
an ongoing basis, in the use of Access
for creating and maintaining legal databases.
OTHER SKILLS AND ACCOMPLISHMENTS:
Knowledgeable in SQL, Visual BASIC, and VBA programming languages.
Original programs and articles published in March '90 and July '91
issues of PCM, nationally distributed computer magazine. Guest lecturer on Microsoft Access for “Computers in the Legal Environment” at UCLA
extension.
Degrees/Certifications: MCP, Microsoft Accredited Access Developer, 6/97, 10/98
B.A.,
References
upon request