Al Vachris

Current

AVP - Excel Specialist at Credit_Suisse

Past

MS Excel Developer at Doar Litigation Consultants
Consultant at Farrell-Fritz P.C
Consultant at Vachris Engineering P.C.

Consultant at JP MORGAN CHASE & CO.
Consultant at JP MORGAN
Consultant at THE NEW YORKER MAGAZINE
Consultant at CHASE MANHATTAN BANK
Consultant at SEAGRAMS BEVERAGE COMPANY
Consultant at WONDERPLAY, INC.
Consultant at CREDIT SUISSE
Consultant at JP MORGAN
Programmer at Grumman Data Systems
Engineer - Fortran Programmer at Grumman Aerospace
Instructor - aeronautical engineering at USNPGS

see less...

11 more...

Education

Polytechnic University
Polytechnic University
University of Notre Dame

Chaminade HS

see less...

1 more...

Recommended

4 people have recommended Al

Connections

500+ connections

Industry

Computer Software

Al Vachris’s Summary

I am a Senior Applications developer with a proven track record as a skilled developer of engineering and financial applications. I have worked for aerospace and Wall Street firms.

My extensive problem solving background enables me to understand and relate to the client's requirements and expectations.

I have a unique balance of patience and impatience. The patience to see every task through to its successful completion and the impatience not to settle for a solution that could be improved upon based on new ideas that have resulted for the development process.

As I develop applications, I am always aware of the efforts that are required to complete the various tasks and I strive to create utilities and tools that will automate and simplify these development tasks.

Contact Information
Alfred Vachris
244 Southdown Road
Huntington, NY 11743
631-673-4183
alfred.vachris@gmail.com

Al Vachris’s Specialties:

excel / VBA developer

Al Vachris’s Experience

AVP - Excel Specialist

Credit_Suisse

(Public Company; 10,001 or more employees; Investment Banking industry)

January 2007 — Present (2 years 11 months)
MS Excel Developer

Doar Litigation Consultants

(Privately Held; 51-200 employees; Legal Services industry)

May 2003 — November 2006 (3 years 7 months)

•Created efficient and effective Excel/VBA procedures for the Electronic Discovery of Excel Workbooks. These procedures included a unique capability called Smart-Printing which controls the printing of complex workbooks to suppress blank pages from the printed output.
• Created procedure that generates a structured report that documents the contents of a workbook on a cell be cell basis.
•Designed and developed a VBA code analysis utility that collected the VBA code from multiple Excel projects. The resulting collection of source code is copied into an Excel workbook and structured into subroutines and functions.
•Generated an Excel application that created PowerPoint slides from a workbook containing the results of Jury Survey Questionnaire.
•Provided in house training for Excel including Excel Charting, Excel Data Analysis and a variety of other Excel techniques.
Consultant

Farrell-Fritz P.C

(Privately Held; 201-500 employees; Legal Services industry)

February 2003 — April 2003 (3 months)

Create Word VBA macros for the generation and management of Legal Documents.
Assisted in the transition from Word Perfect macros to Microsoft Word macros.
Consultant

Vachris Engineering P.C.

(Privately Held; 11-50 employees; Civil Engineering industry)

June 2002 — December 2002 (7 months)

Created spreadsheets and VBA macros for various civil engineering calculations.
Developed Excel Utilities to interface with Autocad.
Consultant

JP MORGAN CHASE & CO.

(Public Company; 10,001 or more employees; Banking industry)

January 1999 — January 2002 (3 years 1 month)

•Investment Bank – Technology and Operations – Operational Risk Management Key Performance Indicators (KPI) Project which collects and reports the operational status of the Investment Bank. Replaced high maintenance manual procedures with automated Excel applications. Original process required five people to cover two business areas. Streamlined procedure enables two people to support twenty business areas. Provided project leadership evolving the traditional monthly KPI process into a sophisticated daily KPI process supporting the Chase – JP Morgan merger. Generated applications for collecting, consolidating and reporting KPI’s. Developed a chart building application that creates six hundred charts a day for Web publishing.
•Chase Bank - Retail Banking Systems. Generated various Excel applications supporting the development of a Workforce Management System. Wrote Excel applications to build a database of bank organizations and their employees.
Consultant

JP MORGAN

(Public Company; 10,001 or more employees; Banking industry)

June 1997 — December 1998 (1 year 7 months)

Job responsibilities: Created Excel applications for the Financial Risk Management Group and the Applications Development project.
Consultant

THE NEW YORKER MAGAZINE

(Public Company; 10,001 or more employees; Publishing industry)

January 1997 — June 1997 (6 months)

Job responsibilities: Assisted in the development of Excel/VBA applications to track and report Advertising Sales Projections. Developed a unique worksheet design that presents current sales projections for review, while providing an effective method for collecting and dynamically posting all changes made to these sales projections.
• Significantly enhanced the overall performance of various applications through the use of powerful worksheet function: VLOOKUP, pivot tables, filters, advanced filter and subtotals
Consultant

CHASE MANHATTAN BANK

(Public Company; 10,001 or more employees; Banking industry)

August 1996 — December 1996 (5 months)

Consultant/Retail Banking Systems

Job responsibilities: Generated various Excel applications to support the development of a Workforce Management System.
• Created macros to build hierarchical organization structures from simple “ownership” lists.
• Devised an extremely effective method for analyzing employee job changes by comparing employee files from last year to the current files
• Developed a macro to produce a collection of 50 workbooks that documented all employees by cost center
• Developed a very powerful macro for comparing long lists. On a 486-66 CPU the MATCH function takes more than 4 hours to compare two lists of 16000 rows. My macro completes the same task in less than two minutes.
Consultant

SEAGRAMS BEVERAGE COMPANY

(Public Company; 10,001 or more employees; Wine and Spirits industry)

June 1996 — July 1996 (2 months)

Developed an Excel application to forecast beer distribution. Imported mainframe feed files, generated an internal Excel database, collected information from territorial managers, and returned to the mainframe
Consultant

WONDERPLAY, INC.

(Privately Held; 1-10 employees; Computer Software industry)

May 1996 — July 1996 (3 months)

: Developed Excel applications for sales analysis. Imported mainframe files into Excel, organized the flat file data into structured information, building pivot tables, charts. The VLOOKUP function is effectively used to control locations and dates queries. A single Excel data base tracks sales and profit information for 10 warehouse locations for the last 12 years.
Consultant

CREDIT SUISSE

(Public Company; 10,001 or more employees; Banking industry)

March 1996 — June 1996 (4 months)

Direct support of Treasury trading applications. Worked closely with traders and other Excel consultants to produce immediate upgrades and improvements to production Excel applications
Consultant

JP MORGAN

(Public Company; 10,001 or more employees; Banking industry)

June 1994 — January 1996 (1 year 8 months)

Developed Excel macro applications for the Financial Corporate Risk Management Group
• Designed, developed and delivered an Excel macro system for processing the daily Morgan"4:15" global market risk report. The key feature of this system is a set of data description tables that identify the thousands of data items that go into the report. The translation tables are easily modified, enabling the client to quickly respond to business and market changes which are reflected in the 100+ feed files that are processed by the system - eliminating the need for full time development support.
• Developed crucial methodologies for managing the transition from EXCEL 4.0 to EXCEL 5.0 - management of links - building workbooks from worksheets.
• Developed a system of VBA modules for generating custom charts. The client uses these modules to generate charts for the board of directors
Programmer

Grumman Data Systems

(Public Company; Computer Software industry)

1990 — 1994 (4 years )
Engineer - Fortran Programmer

Grumman Aerospace

(Public Company; 10,001 or more employees; Defense & Space industry)

October 1962 — January 1994 (31 years 4 months)
Instructor - aeronautical engineering

USNPGS

(Government Agency; 51-200 employees; Military industry)

May 1963 — July 1965 (2 years 3 months)

Al Vachris’s Education

Polytechnic University

MS Applied Mathematics , Applied Mathematics , 1967 — 1969
Polytechnic University

MS Astronautics , Astronautics - Rocket Science , 1962 — 1964
University of Notre Dame

BS Math , Mathematics , 1958 — 1962
Chaminade HS

college prep 1954 — 1958

Additional Information

Al Vachris’s Groups:

wash u apap

Notre Dame Alumni Network
Professional Office Developers Association
Data & Text Analytics Professionals (1800+ members)
VizThink
Microsoft Excel Users
Chaminade High School Alumni (Mineola, NY)
Science Fiction readers, writers, and collectors
Excel Developers
Friends of Long Island Sound
Visual Thinking
Professional Engineer Society NSPE
NORTHROP GRUMMAN CONNECTIONS
Web Analytics Wednesday NYC
Visual Analytics
Excel and VBA Users
Vintage Computing & Computers
Excel Power User Group
Excel and the City
Algorithms
Northrop Grumman Linked
National Society of Professional Engineers
LISTNET
Access and VBA
Visual Basic for Applications Experts
Excel And Access users, Novice and Experienced
Polytechnic University Alumni (Brooklyn, Westchester, Long Island campuses)
ExcelKings
Excel enthusiastic
EXCEL(lence in Analysis)
Chaminade High School Graduates
Washington University in St. Louis Alumni & Friends Network in New York
Mindmapping
IMSL Numerical Libraries Family
Excel Trainer
Just Excel!
Fortran Programmers
Excel Enthusiasts
Excel Gurus
Monte Carlo Simulation, Excel and Model Risk
Finance Professionals Network, MAF, ACA, CPA, ICPAS, CFA, Financial Controller / Analyst / Director
Financial Modelling in Excel
NYTIA (New York Technology Industry Association)
BestLinked
MS Excel and VBA macros
Influence Diagrams, Belief/Bayesian Nets, Causality & Bayes Theorem
Excel Spreadsheet Authors
Wall Street Middle Office and VBA
Advanced Spreadsheet Analytics