John A. Weiss Software Designer & Developer MCAD, MCP
[email protected], 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 programming, CDO, MAPI C#, ASP.NET Visual Basic, Excel VBA, VBScript MS Office Light HTML, PHP, Perl, ColdFusion, XML Microsoft Certified
Accomplishments Coordinated RFP Process 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.