JAY WEISS, MBA, CIPP/US, PMP

www.LinkedIn.com/in/Jay-Weiss

Rego Park, NY – 11374

*** – 632 – 8469 adkol6@r.postjobfree.com

TARGET: MS OFFICE ENGINEER VISUAL BASIC FOR APPLICATIONS CONSULTING & ADVISORY SERVICES ENTERPRISE CLIENT ENGAGEMENTS TECHNOLOGY STRATEGY IT OPERATIONS MANAGEMENT Utilized Advanced Skills to Assist Global Processes Trusted IT Advisor Results-oriented, analytical and process-focused Project Manager and Office Excel Programmer (dual) with 20+ years of experience in reducing IT operational risks in support of digital transformation and improving overall quality, to deliver customer satisfaction. Possess a track record in revamping and revitalizing processes, systems, and functions. IMMEDIATE VALUE OFFERED

C

ORE

C

OMPETENCIES

- Experienced Project Manager

- Strong Analytical Skills

- Specifications, Coding, Testing of

World-Class Office 365 Applications

using best practices

- Strategic Project Planning & Analysis

- Training & Development

- Regulatory Compliance

- Client Service Management

- Cross-Functional Management &

Team Leadership

- Continuous Process Improvements

- Enterprise Technology Management

- Consultative Solutions

- Field Engineering

- Microsoft Excel SME

INTERPERSONAL COMPETENCIES

- Stakeholder Relationship Building

- Participation on Agile/Scrum Teams

As a VBA expert of Microsoft Corporation (Premier Field Engineer), supported Fortune (100) clients such as Barclays, CitiBank Technologies, and AXA Equitable Life on a range of projects and subject matters including trading floor applications based in Excel and VBA

Engage senior staff members to capture insights into business problems, while identifying complex discrepancies and generating unique solutions to maximize system functionality or optimize business capabilities

World-Class expertise in Microsoft Office 365, Excel, and Visual Basic for Applications, along with resolving issues during migration or programming and implementing new Office 365 application functionality, supported by in-depth industry knowledge & experience

Leverage technology to optimize functions, processes, and systems, along with managing various projects & initiatives on-time, with precision, and in alignment with business requirements

Earned a stellar reputation at Royal Caribbean Cruises for leading the design and build-out of several call centers and other facilities, while ensuring functionality and overseeing multi-year projects from concept-to-completion

Adapt seamlessly to various business environments, models, and functions, while leveraging advanced technical insights to support organization objectives TECHNOLOGY SKILLS

Microsoft Office 365 Applications and Visual

Basic for Applications (VBA) including Excel,

Access, Word & PowerPoint

- Triage, Advanced Requirements Gathering, and

Individual Needs Customizations

- Programming & Testing (Debugging),

Deployment & Support

- Excel Workbook programming using formulas

and VBA, including Excel Data Model, Power

Query & Power Pivot, Interfacing with 3rd party

applications, Dax, Relationships, Pivot Tables &

Charts, Slicers & Timelines, Tables, Named

Ranges, Vlookup, Index & Match

- Outlook

- Visio

Microsoft Office 365

Expert Level

- Windows 95 – Windows 10

Some experience in:

- Visual Studio .Net (Add-In Development for

Office 365 Applications)

- SharePoint Online

- Report Server

- Power BI

- PowerShell

- SQL Server

- Analysis Server

- OneNote, OneDrive, Teams

Other Microsoft Technoloies

WORK EXPERIENCE

NATIONAL HOME WATCH ASSOCIATION OCT 2020 – DEC 2020 RESOLVE MULTIUSER ISSUES IN MICROSOFT 365 ACCESS – REMOTE Errors were occurring when opening Access database from OneDrive or SharePoint (SP). NHWA had opened tickets with Microsoft and spent many calls without resolution.

The solution was reached by taking steps in both Access and SP:

• Replaced Access’s tool “Move data to SharePoint” as runtime errors such as “this dataset is not updateable" occurred.

• Removed Autonumber from each Access table and replaced with a system-values table and Visual Basic code. Recreated incorrectly converted tables in SP Lists. Used SQL statements in Access to simulate the relationships not supported in SP. Added multi-user record locking and solved data set not being updateable by updating form properties.

• Fully tested, documented, and demonstrated the working system. Solution was accepted by the client. MICROSOFT CORPORATION – TRIMAX AMERICAS 2019 – 2020 OFFICE 365 PRO PLUS PFE / EXCEL – VBA PROGRAMMER SPECIALIST– REMOTE Executed a multi-faceted role within an all-encompassing position, leveraging company technology and processes to achieve deliverables and resolve complex issues, while supporting Fortune (100) organizations to correct Office 365 migration issues, along with improving functionality by revamping systems, processes, and technical operations.

Successfully resolved issues including latency, Add-in usage, Windows crashes, hangs, resulting from incompatibility with prior versions of Office, both 32-bit vs. 64-bit

Successfully resolved issues while simultaneously migrating to Windows 10, both 32-bit and 64-bit

Learned and utilized new technologies such as PowerShell, OneNote, and OneDrive, efficient searching of the Microsoft Knowledge Base, to effectively resolve (100%) customer issues

- Assisted top-tier MS customers in Office

365 Pro Plus applications

- Met with top IT personnel, while

advising on and troubleshooting multi-

continent issues

- Assessed customer VBA code,

approach, and style, while documenting

site visits and offering recommendations

PROJECT MANAGER AND VBA PROGRAMMER THE WEISS CONSULTING GROUP – MIAMI, FL 2015 – 2019

Troubleshot website issues regarding URL, page resizes and scrolls, clicks, browser, OS, connection, language, date / time, city, region, zip, country, and ISP

Facilitated refinement of product market demographics, developing Shopify e-Commerce store solution using HTML-5, JavaScript, CSS, Liquid, and jQuery

Engaged in formula-based dynamic insertion of SEO (meta keywords, meta descriptions, tags for Facebook, Twitter, and Search engines, micro data, and JSON (schema.org) and visitor-sitemap)

Delivered minimized on-going maintenance & improvements via programming best practices to overcome platform limitations, while achieving high-ranking in search engines, along with creating test plans and software documentation

Brought a new product (NDA) to market by developing web-based software to illustrate aspects in 3D for the patent, trademark, and copyright applications

- Developed Office 365 VBA migration

checklists, crafting Office 365 VBA add-

in development and testing procedures

- Crafted website analytics multi-platform

solution to overcome short-comings of

Google, Yandex, and Shopify Analytics

- Performed dynamic styling using CSS-

3, JavaScript, and jQuery to obtain

desired presentation for desktop and

mobile

- Programmed solution using HTML,

JavaScript, ThreeJS, jQuery, and WebGL

SENIOR VBA PROGRAMMER ANALYST / CONSULTANT TD BANK – FT. LAUDERDALE, FL 2016

Built application for branch loan officers including (30) worksheets and a dashboard to drive efficiency and effectiveness, along with integrating customer data from Moody’s and partnering across multiple functions

Translated specifications and user-input into (6K) lines of codes & formulas to manage, format, and ensure integrity of (30) visible and hidden worksheets with robust workbook auto recovery feature

- Designed Excel-VBA-based loan-

approval system for branch loan officers

- Cultivated VBA activity logging and

debugging to reduce support efforts by

(20%) and increase overall

accountability

MARKETING MANAGER, NEW PRODUCT DEVELOPMENT AMERICAN EXPRESS, GLOBAL BUSINESS TRAVEL 2014 – 2015

Involved in all facets of risk management, operations, and information technology, along with supporting release of products on a world-wide basis

- Operated as a main contributor for

managing initiatives at American Express

Developed the legal team and cross-functional personnel to secure product approval and roll-out new products across multiple countries

Fine-tuned plan, resulting in milestone accuracy dates with 95% confidence Global Business Travel to acquire launch

approval for new products

PROJECT MANAGER / PROGRAM MANAGER SILVER AIRWAYS – FT. LAUDERDALE, FL 2013

Crafted cross-functional aspects of the Silver Airways’ Pilot Hiring and Retention Program; planned implementation of the Disaster Recovery Program

- Prepared C-level status reports by

gathering and summarizing data

PROJECT MANAGER / PROGRAM MANAGER ROYAL CARIBBEAN CRUISES, LTD. 2003 – 2013 TEAM LEADER ROYAL CARIBBEAN CRUISES, LTD. – MIAMI, FL 1997 – 2001

Administered construction, build-outs, and occupation of several facility projects, including a ($20M) customer contact center (LEED Gold), an ($8M) call center, and office expansions, relocations, and remediation projects

Identified cost-reduction opportunities to enable winning LEED Gold, resulted in a ($250K) government rebate and ($100K) in reduced costs per year

Responsible for emergency planning in support of shore-based facilities, while collaborating with the FBI, DEA, police & fire departments to create emergency planning procedures

Suggested initial business-appropriate functional procedures for ship- board internet by visiting hotel chains as well as interviewing management and operational personnel as well as reviewing completed products

- Crafted and delivered technical

infrastructure for passenger internet on

RCL fleet of ships

- Integrated an e-mail service to reduce

distribution times by (95%), along with

developing Excel VBA modules to repair

(25%) of email address errors

- Designed solution for shipboard

internet-café venue “Royal Caribbean

Online”

PROJECT MANAGER, WORLD FUEL SERVICES CORPORATION TEKSYSTEMS – MIAMI, FL 2002 – 2003

Managed the development and occupation of new world headquarters facility

Created (20) Excel Workbooks with VBA custom macro programming to analyze expenses and the MS Project timeline, resulting in reduced costs, process time reductions, and higher overall quality

Conceptualized stringent invoice submittal and cash disbursement policies, and vendor process requirements to reduce vendor costs, support the project timeline, and improve overall quality

- Controlled master program of ($7M)

build-out and relocation of operations

and personnel, including the

establishment of the project budget and

finances

ADDITIONAL WORK HISTORY

SENIOR PROGRAMMER AND TEAM LEADER, RESTAURANT SYSTEMS BURGER KING CORPORATION – MIAMI, FL 1989 – 1997 SENIOR R&D PROGRAMMER DATAACCESS WORLDWIDE – MIAMI, FL 1984 – 1989 EDUCATION QUALIFICATIONS & CERTIFICATIONS

MASTER OF BUSINESS ADMINISTRATION (MBA) FINANCE ST. THOMAS UNIVERSITY – MIAMI, FLORIDA 1995

BACHELOR OF ARTS (BA) MATHEMATICS & COMPUTER SCIENCE EMORY UNIVERSITY – ATLANTA, GEORGIA 1984 CERTIFIED INFORMATION PRIVACY PROFESSIONAL/UNITED STATES (CIPP/US) PRIVATE PILOT PADI RESCUE DIVER CERTIFIED PROJECT MANAGEMENT PROFESSIONAL (PMP) (2002 – 2005)

Contact this candidate