John A. Weiss

San Francisco, CA ad10l0@r.postjobfree.com http://linkedin.com/in/johnaweiss 415-***-**** Software Designer & Developer

I am a Senior, world-class, Microsoft Certified developer of VB/VBA/SQL. I excel at assessing business requirements and delivering a clean, bug-free user experience.

• 25 years experience developing VBA and SQL applications for leading global companies.

• Founder of a nonprofit engineering mentoring organization.

Skills

• Requirements & Specifications

• User Experience Design

• Advanced VBA

• SQL Developer/DBA

• PHP, Javascript, HTML, CSS

Professional Experience

Founder, Lead Product Engineer, March 2011 – Present The BOOM Mentoring Org, San Francisco, CA

Designed and developed a hardware tech education program for disadvantaged teenagers. VBA Developer, May 2021 – February 2022

MedPro Health Insurance, Fort Wayne, IN (remote)

Developed a company VBA library to serve multiple applications. Optimized performance of a shared workbook with multiple users over a network. Enhanced several applications and services. Managed rollout of bugfixes across thousands of live workbooks. Developed background workbook-save feature for saving very large workbooks over a slow connection. Wrote custom functions to interface with AS400. Excel VBA Programmer, Essbase, Oracle PSQL Developer, JSON Custom Application Developer, March 2016

- March 2017

Apple Computer, Sunnyvale, CA

Developed VBA software to service Apple hardware factories around the world. In collaboration with our business customer in Asia, I implemented custom advanced VBA methods. Developed speed/memory optimizations, custom ribbons, live code updater, an original method to write 1 million+ records in seconds, an original global exception- handling system, and Office.JS code.

Excel VBA Instructor, 2016

Apple Computer, Cupertino, CA

Designed and led an Advanced Excel/VBA class for Apple employees. Taught variable-scoping, defined names, ListObjects, debugging, arrays, collections, Dictionaries, serialization/deserialization, User-Defined Types and enums, events, direct memory access, and error-handling.

Excel VBA Custom Application Developer, July 2010 – 2020 AHRI Federal Health Standards Compliance, Valencia, CA Architected and coded the flagship product to audit regulatory compliance of hospitals. Developed a data-collection platform, analysis system, and database backend, based on MS Excel, Access, and VBA. Managed major releases and updates. Created innovative VBA methods, with emphasis on ease-of-use. Developed automated product- updater. Scrubbed extrenal data. Developed custom Windows Powershell scripts. C# ASP.NET Developer, SQL Server 2005 Developer/DBA, 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 session-persistence, 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.

SQL Server Database Administrator, Database Developer, April 2005 – July 2005 CAST Management Consultants

Transferred data objects and queries from Microsoft Access to SQL Server. • Scripted custom SQL DTS Packages and queries to transfer data from Access to SQL Server. • Converted a manual Access process to an automated SQL Server process. • Gathered specifications on two projects. • Installed SQL Server. • Configured SQL security, SQL Agent jobs, backup, and restore. • Converted Access database into a SQL relational database, and transformed Access denormalized schema into a normalized SQL schema. • 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. • Developed Access reports, queries, and tables. • Developed Excel data-entry forms and macros for automatic rounding and data-validation. • 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: • 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. • 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. • Created DTS packages and ad-hoc inline OLEDB queries to import Excel and other data, wrote data-verification queries, and scripted updates and inserts. • Scripted SQL login rights. Converted SQL logins into Trusted logins.

+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. 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/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, Exchange-CDO, OLEDB, ADO, and Microsoft Script Control. 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 & Training

Power Platform Training, 2020

Microsoft/Cyclotron, San Francisco, CA

Developed a complete Power Platform application, including Power Apps Canvas, Common Data Services, Model- driven App, and Power Automate.

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 of Arts

University of Massachusetts At Amherst

Self-Designed Major: Human Development and Interdisciplinary Music.

Contact this candidate