EXECUTIVE SUMMARY:

• Advanced Microsoft Excel Visual Basic for Applications (VBA) macros programmer:
• Solution creation, enhancement, remediation and suggestion.
• Consistent delivery of high quality, thorough, well - tested, error-free and supportable solutions.
• Work well individually and as part of dispersed teams.
• Comfortable with deadlines and in changing situations.
• Seasoned analyst, project manager and communicator.
• Can assume a variety of responsibility.
• Masterful with complexity and advanced programming techniques, acquired over many years.
• Other skills in C, JavaScript, HTML, Unix-Linux-Apache Shell, DOS, Windows 95 through Windows 10, Office 97 through Office 365.

PROFESSIONAL EXPERIENCE:

Confidential, Rego Park, NY

Responsibilities:

• Automated validation, completion, linking and protection of required worksheets that rolled-up into dynamically generated dashboard.
• Imported, parsed and routed customer credit history from Moody’s.
• Ignored line-item data when variety of factors were present, per policy.
• Automated recovery from a variety of user-created workbook, worksheet and cell error conditions.
• Improved speed 20% by pausing automatic workbook processing and screen updating.
• Increased support performance 20% by logging user-activity in hidden worksheet.
• Reduced testing and issue resolution time 15% with debugging routines.
• Heavy use of vlookup, offset, match, index, indirect, average, min, max, if, iferror, sum, sumif, arrays, strings, dates, copying and pasting formulas and values, named ranges, sorting, tables, subroutines and recursive functions.

Confidential, Miami, FL

Responsibilities:

• Developed facilities in Excel VBA that converted Microsoft Project files to Microsoft Excel to produce table-based project status with date forecasts and line-item issues for escalation, color-coded and suitably formatted for emailing. Routines were also developed to update Project files from Excel spreadsheets, reducing manual MS Project modifications by 50%.
• Converted verbal project steps into formal project plan.
• Fine-tuned project plan for each theater of operation, resulting in milestone accuracy dates with 95% confidence.

Confidential, Miami, Florida

Responsibilities:

• employee turnover, guest satisfaction, overall expense, each overlaid with net income components and external benchmark data.
• Grading routines color-code the results, allowing for department-based scoring thresholds.
• Excel-based interfaces developed to download and process hundreds of thousands records from multiple sources, such as JD Edwards.
• Distribution workbook contained hundreds of click-able charts, drill-down views, context sensitive help.
• Developed and kept involved core participant group of HR executives.
• Facilitated development of formal specifications using multiple techniques such as focus-group, anonymous voting, and structured discussion.
• Negotiated meeting times, development and production milestones, provided personalized support and rapid response to queries.
• Worked with IT to own, source and normalize the data where possible.
• Documented all project aspects such as meetings, procedures, VBA code, diagrams, history.
• System added new dimensions of efficiency to HR by providing useful information which was not available before.
• Excel VBA program created to maintain a consolidated dashboard with hyperlinks to key files of all projects on a hard-drive. Program reduced time-to-find routine project information by 80% and assured that project contacts were synchronized.
• Project files scanned for included contact workbooks, budget-cost tracking workbooks, PowerPoint presentation files and status report Word documents.
• All budget-cost tracking workbooks were opened, and budget-expense totals were copied in.
• All contact workbooks were opened, formatted to a common standard and all entries were fed to an internet API to correct the address and zip code per USPS requirements. Corresponding entries in the Outlook address book were created or updated. New entries entered directly into Outlook were copied to the appropriate contact workbook.
• Excel VBA-based program to manage multiple projects with high budget and transaction volume.
• Management of budget and payments as transactions against internal vendor accounts, organized by section, subject or department worksheets, broken down into component estimates and replaced by agreed-to amounts, with tracking for potential new costs, committed portions, paid amounts, and calculated over-under amounts.
• Line-item hyperlinks throughout workbook to contracts, invoices, related tasks in MS Project, and other helpful documents.
• Dynamically generated dashboard with hyperlinks to reports and details. Automated worksheet and report formatting.
• Reports to research vendor history of cost projection changes, paid amounts and forecasts, approaching over-budget. Selectable scope reports of time-based cash expenditure history and forecast.
• Utilities to import and reconcile transactions with corporate systems.
• Resulting system enabled multi-project financial administration through tools to warn, research, rectify and report.
• Primarily using Excel VBA, analyzed and updated monthly process to distribute e-mail, resolving bounced-message issues to improve delivery rates by 250 percent, along with integrating an e-mail service that reduced distribution times by 95 percent.
• Developed VBA modules to repair 25 percent of e-mail address typing errors and translate message content into specially-chosen spam-minimized HTML tags.
• Based in Excel VBA, implemented programs to gather electronic expenditures and summarize and compare vendor payments at various time intervals, identifying savings of more than $100,000 per year.
• Re-configured sites for North American offices, analyzing existing web content and developing new site in HTML and JavaScript to improve ease of use. Programmed multi-dimensional analytics reports in Excel VBA.
• Managed construction, build-outs and occupation of seven facilities, including a $20-million-dollar customer contact center, an $8-million-dollar call center, and other office expansions, relocations and remediation projects.