John A. Weiss

Software Designer & Developer

MCAD, MCP

johnaweiss@gmail.com, 818-919-0824

 

 
 

 

Skills

Solution Development:

•  needs-assessment
• analysis and specifications
• programming
• documentation
• user-training
• Product research and RFP process

Technical Skills:

•  Windows/Mac
• Advanced T-SQL Queries, MS SQL Server Admin, MySql
• Exchange Server and Outlook programming, CDO, MAPI
• C#, ASP.NET
• Visual Basic, Excel VBA, VBScript
• MS Office
• Light HTML, PHP, Perl, ColdFusion, XML
• Microsoft Certified

Accomplishments

•  Coordinated RFP Processes.
• Built C# ASP.NET data-collection wizard
• Extensive advanced T-SQL programming for Wall Street clients. Installed and configured MS SQL Server.
• 15+ years advanced Excel/VBA programming, including Fortune 50 clients. Built complete custom applications, including financial reporting, live stock-market data, custom pivot-tables, and database integration. Rolled out to international users, in-production for years.
• Programmed PHP and ColdFusion pages
• Developed ASP/VBScript emulation of Crystal Reports, including parameters and subreports.
• Programmed synchronous Exchange Server event sinks, using ExOLEDB, VB.NET, Exchange SDK, and ADODB.
• Developed VBA utility to transfer contacts between Exchange Server 2000 and MS SQL.
• Debugged and reprogrammed existing VBA applications.
• Developed a custom language-translation plugin for MS Outlook in Visual Basic.
• Implemented batch WAV-MP3 converter in Visual Basic.
• Designed, wrote, and produced glossy bound reports.
• Configured Macintosh network server.
• Programmed UNIX awk! and lex to consolidate UNIX, PC, and Macintosh databases.

Clients

Note Overlapping dates indicate simultaneous contracts; gaps indicate non-computer assignments.

CRM Product Evaluator, May 2009 - June 2009

College Planning Experts, Valencia, CA

C# ASP.NET Developer, SQL Server 2005 Developer, February 2008 – May 2008

Copia Creative/Applied Materials Inc., Worldwide, Santa Monica, CA

SQL Server Database Administrator, Database Developer, April 2005 – July 2005

CAST Management Consultants

Excel/VBA Programmer, SQL Database Developer, DBA, September 2004 – December 2004

Infospring LLC, Diamond Bar, CA

Pivot Table Programmer, Database Developer, March 2004 – May 2004

DDB-LA, Venice, CA

Database Developer, Programmer, December 2003 - Present

Ramp^Rate Inc, Santa Monica, CA

Programmer of PHP/MySql Dynamic Web-Page, November 2003

WFMU Radio Station, Jersey City, NJ

Programmer of ColdFusion Website, October 2003

Breakthrough Technologies, Jersey City, NJ

Programmer of ASP/VB Script Reporting System, January 2003 – April 2003

Wyckoff Medical Center, Brooklyn, NY

Exchange Server/VB.NET Programmer, October – November 2002

Logicom, Inc., New York, NY

Analyst/Developer of Data-Collection & Reporting System, February 1996 - August 1996, November 2001 – July 2002

Merck & Co., Inc., Whitehouse Station, NJ

Developer of Excel/VBA, SQL Server, and IIS Scheduling System, August 2001- December 2001

Tiger Information Systems, New York NY

Programmer of Data Systems, November 1996 - 2002

W.P. Stewart and Logicom, Inc., New York, NY

Developer of Exchange Server 2000/SQL 7.0 Data Transfer Utility, April 2001 - August 2001

S.F. Digital/New York Press Newspaper, New York, NY

Developer of Visual Basic 6.0 Internet Download Component, May 2001

Mode 11, New York, NY

Developer of Access/VBA Credit Approval System, April 2001

Bankia Norway, Norway

Developer of Visual Basic 6.0, MS Office COM Add-in & IIS/COM+ Server, January 2001 – April 2001

TextVoice, New York, NY

Visual Basic 6.0 Audio Utility Programmer, December 2000

Breakthrough Technologies

Analyst/Programmer/Database Developer, January 1997 - May 1997, August 1997 - July 1998

Morgan Stanley/Dean Witter, New York, NY

Analyst/Programmer, February 1997 - April 1997

Marketing Strategies and Planning, New York, NY

Visual Basic Programmer & Corporate Purchasing Team Member, May 1994 - February 1996

Citibank N.A., Long Island City, NY

Analyst/Prototyper, September 1996 - November 1996

Q - M Consulting Group, New York, NY

Macintosh Network Manager, 1987

LandUse, Inc., Hadley, MA

UNIX Data Base Programmer, Administrative Assistant, 1986

The La Jolla Civic/University Symphony & Chorus, La Jolla, CA

Education

Microsoft Certification Preparation, 2006

Integrated Digital Technology, Pasadena, CA

Preparation in .NET, C#, XML, and SQL Server.

Bachelor's Degree, 1993

University of Massachusetts At Amherst

Self-Designed Major Human Development and Interdisciplinary Music.