Programming Resume Abitest

John A. Weiss Software Designer & Developer MCAD, MCP [email protected], 818-919-0824

Skills Complete solutions from needs-assessment through specifications, programming, documentation, and usertraining Windows NT/2000/XP, SQL Server, Exchange Server, CDO, C#, XML, Visual Basic/VBA/VBScript, MS Office ADO, HTML, PHP, MySql, Perl.

Consulting Experience

Note Overlapping dates indicate simultaneous contracts; gaps indicate non-computer assignments. CRM Product Evaluator, May 2009 - June 2009 College Planning Experts, Valencia, CA Compared and evaluated approximately 20 CRM products, across about 75 feature points, and recommended the most professional and effective products, based on this client's business needs. I assessed and prioritized the client's business needs, developed an RFP, and coordinated product demonstrations and discussions. Products included SalesForce, InfusionSoft, ACT, Microsoft Dynamics, Sales Nexus, SugarCRM, and more. C# ASP.NET Developer, SQL Server 2005 Developer, February 2008 – May 2008 Copia Creative/Applied Materials Inc., Worldwide, Santa Monica, CA Designed and developed an asp.net intranet data-collection wizard, intended for worldwide usage. Features included sessionpersistence, custom-built combobox controls which provided more robust functionality than standard controls, field and page validations, color and font consistency, and SQL stored procedures. Tasks included migrating data between SQL 2005 and SQL 2000 databases. Microsoft MCSD Certification Program, Full Time Student, 2006 Integrated Digital Technology, Pasadena, CA Attended courses for MCSD preparation in full range of topics, including C# programming, SQL Server development and administration, and XML web-services. Residential Computer Tech Support, 2005 - present Residential Clients, Los Angeles Vicinity Provided home-based technical support for several clients. Tasks included virus removal, software installation, complete security, replacing faulty disk drives, upgrading operating systems, corrupt and deleted file-recovery, and tutoring in computer skills. SQL Server Database Administrator, Database Developer, April 2005 – July 2005 CAST Management Consultants (1) Transferred data objects and queries from Microsoft Access to SQL Server. (2) Scripted custom SQL DTS Packages and queries to transfer data from Access to SQL Server. (3) Converted a manual Access process to an automated SQL Server process. (4) Gathered specifications on two projects. (5) Installed SQL Server. (6) Configured SQL security, SQL Agent jobs,

backup, and restore. (7) Converted Access database into a SQL relational database, and transformed Access denormalized schema into a normalized SQL schema. (8) Scripted Access macros to auto-generate multiple Excel workbooks loaded with SQL Server data, convert Field datatypes, and extract data from Excel books into Access. (9) Developed Access reports, queries, and tables. (10) Developed Excel data-entry forms and macros for automatic rounding and data-validation. (11) Developed complex sequential SQL queries and stored procedures to generate statistics, and developed Excel pivot tables to report the results. Excel/VBA Programmer, SQL Database Developer, DBA, September 2004 – December 2004 Infospring LLC, Diamond Bar, CA Programmed Macola, SQL Server, Excel/VBA, and Access (1) Developed an Excel application, integrating SQL Server and Access. Wrote multi-step complex stored procedures, including in-memory table-type variable. Programmed extensive Pivot Table manipulation, including a unique editable Pivot Table. (2) Developed an ADP-to-SQL interface in Excel. Emulated Excel 2003’s ListObject with VBA in Excel XP, built on-sheet data-validation, and exported to an ASCII data file. (3) Created DTS packages and ad-hoc inline OLEDB queries to import Excel and other data, wrote data-verification queries, and scripted updates and inserts. (4) Scripted SQL login rights. Converted SQL logins into Trusted logins. Pivot Table Programmer, Database Developer, March 2004 – May 2004 DDB-LA, Venice, CA (1) Programmed an automated a feature-rich Excel Pivot Table reporting system. Completed, in 3 days, a project which had previously taken 3 workers 3 weeks to produce. Expanded the Pivot Table functionality to provide presentation capabilities not possible with standard Excel Pivot Tables, such as Subgrouping within DataItems. (2) Designed a custom Pivot Table object class to facilitate plug-and-play code-reuse of the expanded feature-set. (3) Programmed an online help system, based on "Clippy", the Microsoft Assistant. Database Developer, Programmer, December 2003 - Present Ramp^Rate Inc, Santa Monica, CA (1) Designed and programmed a Windows Service in Visual Basic to send email-alerts via SMTP and execute database commands on a daily schedule. (2) Designed and developed an Access database including custom queries, forms, macros, and Visual Basic modules, to maintain contract information. (3) Built database-driven Excel spreadsheets and custom VBA spreadsheet functions to report statistics. Programmer of PHP/MySql Dynamic Web-Page, November 2003 WFMU Radio Station, Jersey City, NJ Programmed a MySql-driven PHP page, to enable the client to easily update the contents of the webpage by editing the backend data-tables. Installed and configured MySql and PHP. Designed and built database. Programmer of ColdFusion Website, October 2003 Breakthrough Technologies, Jersey City, NJ Coded ColdFusion on a website with a SQL Server backend. Programmer of ASP/VB Script Reporting System, January 2003 – April 2003 Wyckoff Medical Center, Brooklyn, NY Designed and developed a flexible data-driven website, replacing Crystal Reports. Installed and configured IIS and SQL Server. Designed and built the SQL Server back-end which drives the site. Developed reuseable VB Script ASP code, to easily accommodate additional future reports. Developed CSS to format the reports. Exchange Server/VB.NET Programmer, October – November 2002 Logicom, Inc., New York, NY Programmed synchronous WebStore event sinks using ExOLEDB, VB.NET, Exchange SDK, and ADODB. Developed custom code which captured new OnSyncSave events and copied the new email message to a public folder. Programmed and registered a custom Object Oriented ActiveX DLL with inheritance and WSS file-urls, configured Exchange Server, and registered my custom Windows COM+ components to run out-of-process.

Analyst/Developer of Automated Data-Collection & Reporting System, November 2001 – July 2002 Merck & Co., Inc., Whitehouse Station, NJ Gathered specification, designed, developed, tested, and documented an automated data-entry and reporting system with Excel VBA and Visual Basic. The system is currently in use in approximately 15 countries in Asia Pacific. Implemented complete product-cycle through two international product rollouts. Developer of Excel/VBA, SQL Server, and IIS Scheduling System, August 2001- December 2001 Tiger Information Systems, New York NY Designed and developed several Excel/VBA systems to process, report, and restructure internet web-data, SQL Server data, and Excel data, to facilitate workforce scheduling and analysis. Programmer of Data Systems, November 1996 - 2002 W.P. Stewart and Logicom, Inc., New York, NY Analyzed, designed, and coded an Excel-VBA financial reporting and editing interface and engine integrated with MS-SQL database. Developed SQL 7.0 database, stored procedures, tables, views, and security. Realized statistical models in highly optimized T-SQL system. Performance surpassed the installed base by a factor of 60. Installed SQL Server 7.0 and 6.5, Windows NT and Windows 2000 operating systems. Scripted BCP, Visual Basic, ADO, DAO, OLE, and ODBC. Configured NT and Windows 2000 RAS networking. 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 Designed and programmed heterogeneous Data Transfer utility between Exchange Server 2000 WebStore and SQL 7.0 to migrate mail contacts and messages from a legacy mail system, using Transact-SQL, Excel-VBA, Access 2000, ExchangeCDO, OLEDB, ADO, and Microsoft Script Control. Developer of Visual Basic 6.0 Internet Download Component, May 2001 Mode 11, New York, NY Designed and programmed VB component slave to C master program, to download and programmatically decompress files from an internet server. Component responds to and sends Windows Messages via the Windows 32 bit API. Developer of Access/VBA Credit Approval System, April 2001 Bankia Norway, Norway Developed Access ‘97 VBA procedures, Access forms and subforms for data-editing, data-file import and export, and manual processing of credit card applications. Developer of Visual Basic 6.0, MS Office COM Add-in & IIS/COM+ Server, January 2001 – April 2001 TextVoice, New York, NY Designed and developed Internet and LAN COM+ Client/Server and MS Outlook COM Add-in, based on Lernout & Hauspie Translation engine. Constructed Visual Basic 6.0 DLL’s and configured secure IIS COM+. Currently under development. Visual Basic 6.0 Audio Utility Programmer, December 2000 Breakthrough Technologies Implemented asynchronous WAV-MP3 conversion process in a system integrating Nirvis Systems CDJ, SQL Server, and Blade audio. Analyst/Programmer/Database Developer, August 1997 - July 1998 Morgan Stanley/Dean Witter, New York, NY (1) Proposed, designed, coded, and trained users on an Excel-VBA data entry tool incorporating advanced on-sheet controls, validation code, and safe user-executed data-loading. Wrote detailed system documentation, inline documentation, and online help system. (2) Overhauled Access 2.0/VBA application featuring data-bound controls. (3) Developed Perl-driven HTML web form. (4) Researched and proposed enterprise-wide, cross-application, cross-platform business-process management system. (5) Designed, wrote, and produced glossy bound reports featuring Excel charts and pivot tables.

Analyst/Programmer, January 1997 - May 1997 Morgan Stanley/Dean Witter, New York, NY Overhauled real-time trading application in Excel-VBA, DDE, and OLE on NT. System displays real-time market data, and is used daily by entire trading floor. Analyst/Programmer, February 1997 - April 1997 Marketing Strategies and Planning, New York, NY Constructed system using Excel-VBA, MS Access, T-SQL, and Crystal Reports Professional for automated data download, scrubbing, conversion, and loading. Designed and programmed user interface for enterprise application. Analyst/Programmer, February 1996 - August 1996 Merck & Co., Inc., Whitehouse Station, NJ Proposed and constructed Excel-VBA add-in comprising 3,000 lines of code and logic-driven on-sheet GUI. Software was integral to Merck's worldwide Financial Reengineering, was designed for use by over 20 companies worldwide reporting to Merck, and yields 47% memory savings, 53% speed improvement, improved stability, reliability, and flexibility over previous system. Visual Basic Programmer & Corporate Purchasing Team Member, May 1994 - February 1996 Citibank N.A., Long Island City, NY Proposed and developed software in Excel-VBA for Global Purchasing totaling approx. $150 million. Software saved Citibank est. $50,000 in the first year, and accelerated process from approx. two months to two days. Worked closely with project managers, streamlined project schedule, and overhauled coordination details. Over 40 projects ranged from regional medical services to global mail services to global copier equipment, from $150,000 to $30 million. Analyst/Prototyper, September 1996 - November 1996 Q - M Consulting Group, New York, NY Prototyped financial reporting solution using Excel-VBA and ODBC. Macintosh Network Manager, 1987 LandUse, Inc., Hadley, MA Configured Macintosh network server, organized Server volumes, and produced glossy bound government proposals with Quark Express. UNIX Data Base Programmer, Administrative Assistant, 1986 The La Jolla Civic/University Symphony & Chorus, La Jolla, CA Programmed UNIX awk! and lex to consolidate UNIX, PC, and Macintosh databases. Handled conversion of data from mainframe tape reels, disk, and network sources.

Education Microsoft MCSD Certification Preparation, 2006 Integrated Digital Technology, Pasadena, CA Attended courses for MCSD preparation in full range of topics, including C# programming, SQL Server development and administration, and XML web-services. Bachelor's Degree, 1993 University of Massachusetts At Amherst Self-Designed Major Human Development and Interdisciplinary Music.