EDWARD R. GALIMI

 


SUMMARY:

 


With a complete knowledge of the Excel Object Model, I have provided my clients with varied solutions using Excel, PowerPoint, Outlook, Access and Word on the front end, Sybase, Oracle, SQL Server, MYSQL and Access on the backend through the use of ADO/DAO (Asynchronous and Synchronous).  Many projects have included the use of Document Object Model scraping with the use of VBA and Accessing the API’s of market data providers such as Bloomberg or other web based providers using XML and JSON.  Many of my clients have enjoyed the benefit of automating many of the Microsoft Office products simultaneously and working together to provide complete solutions.  I have also provided my clients with RTD based solutions in Excel using VBA, Javascript, VB Script (both Web and Outlook), CSS, FSO (File System Object), .BAT, Shell and ASP.NET.

 

SKILLS:

 


Microsoft Excel/Access/Outlook/PowerPoint Object Models/VBA, ADO (Oracle, Sybase, SQL Server, Access, Asynchronous/Synchronous), SQL (Oracle, Sybase, SQL Server, Access), DOM (Document Object Model, Asynchronous/Synchronous), Bloomberg API, XML, Visual Basic 6, ASP.Net, Web Services, SOAP

 

EDUCATION:     

 


BS from St. John’s University, May-92, Computer Science

 

PROFESSIONAL EXPERIENCE: 

 

Incorporated and working as independent consultant since 1996

 

Website Developer

 

·         Development of sites (PonyBettor.com, JobHos.us, HelpExcel.com) using VB/ASP.NET, MYSQL, SQL Server, JavaScript, PHP and CSS

 

HARMONIC, San Jose, CA                                                                   MARCH ’10 – PRESENT

VBA/Salesforce.com DEVELOPER

·         Development of Excel based application to analyze data from Salesforce.com using Salesforce Office Toolkit Library, VBA and ADO

 

EXPERIAN, Orange County, CA                                                                       MARCH ‘10

VBA Trainer

·         Advanced VBA training with a focus on the Excel and Outlook Object Models

 

 

MERRILL LYNCH, Houston, TX                                            OCTOBER’10 – DECEMBER’10

VBA DEVELOPER

·         Development of Curve Engine for Merrill Lynch Commodities, which covers Natural Gas, Oil, Emissions and Power using Excel, VBA, ADO, XML, RTD, File System Object, Shell (.bat file calls) and VB.NET

·         General Excel/VBA support for all Commodities desks

 

 

U.S. FOODSERVICE, Rosemont, IL                                                   JUNE’10 – OCTOBER’10

SOFTWARE DEVELOPER

 

·         Development of Excel based tool used by 200+ clients to analyze category data with connection to Oracle using Oracle client, ADO & VBA

·         Automation of procedures using Excel VBA

 

 

FERRAZZI GREENLIGHT, Santa Monica, CA                                 APRIL’10 – MAY’10

SOFTWARE DEVELOPER

 

·         Development of Excel/Access based application titled Currency Connector, designed to assist Ferrazzi employees and clients in finding crucial commonalities in their clients profiles using VB.NET, VBA and ADO.

·         Review of work can be viewed at http://Ferrazzi.HelpExcel.com

 

 

MORETRENCH, Gladstone, NJ                                                                  FEB’10 – MARCH’10

VBA DEVELOPER

 

·         Recommended by recruiter on LinkedIn.com

·         Corrected bugs in existing, standalone Excel VBA application

·         Work can be reviewed at www.Moretrench.HelpExcel.com 

 

NIELSEN, Stamford, CT                                                                             OCT’09 – FEB’10

VBA DEVELOPER

 

·         Recommended by manager on LinkedIn.com

·         Created Excel based application to move/format data between sheets based on selection criteria using the Excel Object Model, VBA, Events, Right Click Events, Combo boxes, and Double click events

·         Created advanced formulas, user defined functions and formulaic arrays for Playtex and Energizer data analysis

·         Created Access database to house the bulk of the data for Excel, using ADO as the mechanism for communication between Excel and Access

·         Work can be reviewed at Playtex.HelpExcel.com

 

THE HORBART GROUP, Gladstone, NJ                                                   JUL’09 – SEP’09

INTERACTIVE PRODUCER/CREATIVE

 

·         Recommended by manager and peer on LinkedIn.com

·         Automated creation of PowerPoint slides from SurveyMonkey.com using Access and PowerPoint/Access VBA, ADO and DOM

·         Transitioned company to Salesforce.com for CRM and Portal foundation, migrating company from Excel based usage of contacts

·         Used Salesforce.com API to interface with Excel and Outlook

·         Designed Excel/Access based application to monitor hypertension awareness using VBA and ADO

·         Consulted with clients on database/application design

·         Work can be reviewed at Hobart.HelpExcel.com and Olivia.HelpExcel.com

 

ST. JOSEPH HOSPITAL, Newport Beach, CA                                         APR’09 – JUL’09

EXCEL VBA DEVELOPER

     

·         Recommended by manager on LinkedIn.com

·         Created Excel workflow spreadsheet using VBA

·         Extensive event handling and conditions

 

COMMERZBANK, New York, NY                                                               OCT’08 - APR’09

EXCEL VBA DEVELOPER

 

·         Recommended by peer on LinkedIn.com‑

·         Trading support for Equity, Options and SWAPS desk

·         Development of Excel VBA applications for traders and middle office (use of ADO and DOM)

·         Building/Maintenance/Execution of Excel daily reports focusing on daily profit/loss (use of VBA, Excel Object Model, Access Object Model, Outlook Object Model, ADO and DOM)

 

NIELSEN, Stamford, CT                                                                             SEP ’08 – OCT 08’

EXCEL VBA DEVELOPER

 

·         Recommended by manager on LinkedIn.com

·         Designed VBA driven charting tool for Nielsen’s client, Schick

·         Migrated Excel 2003 spreadsheets to Excel 2007 – refactoring of VBA code and ensured/corrected functionality

 

 

PIMCO, Newport Beach, CA                                                                            JUL’08 - SEP’08

EXCEL VBA PROGRAMMER

 

·         Automated Excel based hourly report for CEO, Bill Gross to monitor the MBS markets (use of VBA, Excel Object Model, Access Object Model, ADO and DOM)

·         Automated Home Price Appreciation spreadsheets using ADO, DOM and XML through Excel VBA

·         Trained summer MBA interns on Excel VBA

 

BREVERAGE MARKETING, New York, NY                                                     NOV’07 - JUL’08

PROJECT MANAGER

 

·         Created front end spreadsheet to link data via ADO to Access database for proprietary beverage market data

·         Hired two consultants to enhance Excel/Access product design

·         Use of Access/Excel Object Model, VBA and ADO

·         Use of Captivate for training purposes

·         Work can be reviewed at BM.HelpExcel.com

 

RAMIUS CAPITAL, New York, NY                                                            DEC’06 - NOV’07

EXCEL VBA PROGRAMMER

 

·         Recommended by manager and peer on LinkedIn.com

·         Enhanced real time, Excel based profit and loss application through use of ADO, SQL Server,  Access & Bloomberg API – this application is used daily by senior management

·         Created Excel front end applications for Traders with heavy Bloomberg API and ADO functionality

·         Enhanced Warrant Arbitrage, Convertible Bonds & Options traders spreadsheets with use of VBA, ADO (SQL Server) & Bloomberg API

·         Created company wide, data driven XLA containing common tools used by Accounting, Traders & IT

·         Design of generic ad-hoc Excel based tools for traders

·         Provided training for Warrant Arbitrage traders on Excel VBA

·         Use of RoboHelp to incorporate help files into Excel applications

 

COX, Phoenix, AZ                                                                                        NOV’06 – FEB’07

ACCESS VBA PROGRAMMER

 

·         Created Access 2003 database using VBA to import 15K plus Excel workbooks into tables

·         Created user based Reports and Forms to segment and aggregate the data

 

SEMPRA ENERGY, Stamford, CT                                                                     OCT’06 - DEC’06

VBA PROGRAMMER

 

·         Migrated/Testing/Rebuilding of Microsoft Excel 2000 code into Microsoft Excel 2003

·         Migrated 10,000+ Microsoft Excel 2000 spreadsheets to Microsoft Excel 2003 (team), ensuring full functionality (Pivot Tables, Queries, VBA, ADO, Bloomberg API)

·         Maintained Access database to track spreadsheet progress

 

UBS, New York, NY                                                                                           JUN’06 - OCT’06

VBA PROGRAMMER

 

·         Enhanced existing Profit & Loss spreadsheet for Prime Brokerage clients to account for Microsoft Excel RTD (Real Time Data) component

·         Created test Real Time Data service for testing of above component using C#

·         Coded Outlook forms VBScript solution to ensure integrity between CRM (Saleslogix) & Outlook Contacts

·         Coded Microsoft Excel front end solution to create PowerPoint projects

·         Use of WISE packaging software

·         Added components to VB6, VB.NET & C# Trade Entry applications

 

FANNIE MAE, Washington, DC                                                                        APR’06 - JUN’06

VBA PROGRAMMER

 

·         Recommended by manager on LinkedIn.com

·         Developed ADO (Oracle) interface that retrieved and sent amortization data to an Oracle server

·         Created custom SQL for data retrieving and sending

·         Automation of procedures using Excel VBA

 

MERRILL LYNCH, New York, NY                                                              DEC’04 – FEB’06

VBA PROGRAMMER

 

·         Maintain/create Excel VBA code for revenue projection file which is viewed by upper management

·         Created PDF tie in using Adobe Object Model to revenue projection file

·         Use of ADO & SQL/Stored Procedures to retrieve data from Oracle

·         Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically

·         Creation/Aesthetic design of user forms in VBE

 

JP MORGAN CHASE & CO., New York, NY                                                     JUN’04 - DEC’04

VBA PROGRAMMER

 

·         Automated metrics gathering for Credit Derivatives Operate group using Excel, VBA, ADO and SQL

·         Designed Excel application which monitors the sensitivities of books that are created on a nightly basis and alerts Operate team of any problems.  Use of VBA, ADO connection to multiple Sybase Databases and SQL

·         Designed interactive Excel application to gather and display report and threshold run times.  Use of VBA, Calendar control OCX, ADO with connection to Sybase Database and SQL

·         Designed interactive Excel based XLA to grab data from Intranet Web Query and build weekly call statistics.  Use of VBA, Web Queries, Forms and advanced array formulas generated in VBA

·         Handled numerous SQL based requests for front and middle office personnel.  Calls were logged in Lotus Notes call tracking system.

·         Supported Credit Derivatives front and middle office

·         Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically

 

TRADING SCREEN, New York, NY                                                           APR’04 - MAY’04

VBA PROGRAMMER

 

·         Recommended by peer on LinkedIn.com

·         Created advanced filter functionality using Excel VBA for the firm’s largest client, Millennium Partners.  Use of VBA and JIRA for call tracking purposes

·         Identified and repaired numerous issues on in-house TradeExcel product

·         Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically

 

WESTERN ASSET, Pasadena, CA                                                             JUL’03 - MAR’04

VBA PROGRAMMER

 

·         Hired to Fixed Income Analytics Excel based sheet crashing due to numerous Bloomberg DDE embedded functions.  Switched the DDE function calls to Bloomberg API based calls using Excel VBA which stopped the crashing and improved performance enormously.

·         Implemented upgrades to Excel spreadsheet set forth by Fixed Income Analytics team

·         Developed and maintained Excel application for Analytics team using VBA, Excel, Access, DAO, ADO, SQL Server and SQL

·         Migrated data from Access to SQL Server and used ADO technology for connectivity to SQL Server

·         Used Bloomberg API extensively to reduce DDE calls directly from Excel

·         Created individual Excel applications using VBA for Western Asset clients

·         Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically

 

IDT, Newark, NJ                                                                                                APR’03 - JUL’03

VBA PROGRAMMER

 

·         Created Excel application using VBA, Excel and Outlook object model to parse data files from 300 different vendors into standard format used by IDT.  Use of VBA, DAO and Access

·         Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically

 

MORGAN STANLEY SMITH BARNEY, New York, NY                        JAN’01 - APR’03

VBA PROGRAMMER

 

·         Created customizable Excel applications for Equity Research Analysts/Associates using VBA, Excel, Word and Outlook object models

·         Provided support to eProducts and Equity Research Analysts/Associates for proprietary publication system (Spry)

·         Performed QA testing for new Spry application wraps

·         Advanced use of Pivot Tables both on spreadsheet and created/adjusted programmatically

 

BANK OF TOKYO-MITSUBISHI, Jersey City, NJ                               SEP’00 - DEC’00

DESKTOP SUPPORT

 

·         Provided trading floor support for market data applications, (i.e., Reuters, Bloomberg, Bridge, Telerate) Microsoft Office, Hardware and Printers

 

CABLEVISION, Westbury, NY                                                                    JAN’00 - AUG’00

CONSULTANT

 

·         Gauged feasibility of PC population’s ability to run Office 2000, upgraded hardware as necessary and performed rollout of Office 2000.

·         Proactively searched call logging system (Heat) for outstanding issues and sought resolutions for clients

·         Provided network support in a Novell 4.x environment

·         Provided support to Windows 95 clients on Microsoft Office

·         Hardware/Printer configurations/setups

·         Performed extensive call logging/reporting (Heat) to facilitate continuity for clients

 

BROOKLYN COLLEGE, Brooklyn, NY                                                         NOV’99 - DEC’99

CONSULTANT

 

·         Provided technical support to clients for Windows 95/98, Microsoft Office 95/97, Y2K updates and Internet Explorer 4 – 5.x

·         Actively logged and retrieved calls using McAfee Helpdesk.  Entered detailed information to ensure continuity for clients.

 

COMPAQ, Queens, NY                                                                                  MAY’99 - JUL’99

INTEGRATION SPECIALIST

 

·         Configured network, email, printers and Internet Explorer for Department of Corrections desktop PC’s.

·         Created step by step documentation on how to configure network, email, printers and Internet Explorer.

·         Surveyed PC’s to determine current hardware/software status.

·         Maintained organization of paperwork for surveying of PC’s.

 

SELIGMAN INVESTMENT, New York, NY                                                 JUN’98 - MAY’99

HELPDESK ANALYST

 

·         Recommended by peer on LinkedIn.com

·         Created customizable Excel 97 applications using VBA for clients at request

·         Created logical categorization structure in SQL Support Magic (Helpdesk call tracking system)

·         Automated reports for management with the use of Crystal Reports and SQL

·         Provided technical support to 500+ clients on Microsoft Office 4.3 – 97, Windows NT Workstation 4.0, Windows 95, Windows 3.11

·         Administered Novell 3.x – 4.x network (changed passwords, assigned rights, cleared print queues, etc.,)

·         Trained new and existing employees on the use of SQL Support Magic

 

ALLIANCE BERNSTEIN, New York, NY                                                MAY’97 - MAY’98

HELPDESK SUPERVISOR

 

·         Implemented mini-knowledgebase into Helpdesks call logging system (Vantive) using standard problem/resolution model

·         Coordinated with business heads and implemented service level agreements

·         Created custom reports using SQL and Access to query Vantive database

·         Primary contact for the support of the Executive Administration department

·         Acted as primary liaison between Helpdesk and other departments

·         Performed project planning for upgrade of Vantive

 

GOLDMAN SACH, New York, NY                                                             DEC’96 - MAR’97

TECHNICAL RESOURCE COORDINATOR

 

·         Supported Investment Banking Division and Goldman Sachs partners on the Microsoft Office products.

·         Logged detailed accounts of interaction with clients in homegrown Access database used by the Helpdesk

 

BNY MELLON, New York, NY                                                                      JUL’96 - JAN’97

INSTALLATION SPECIALIST

 

·         Traveled nationally installing proprietary electronic funds transfer software.  Installation included multiple network/operating systems.

·         Trained banks clients on use of the proprietary electronic funds transfer software

·         Proactively updated documentation

·         Kept detailed account/performed research of application errors

 

SOCIETE GENERALE, New York, NY                                                       APR’94 - JUL’96

HELPDESK MANAGER

 

·         Recommended by manager on LinkedIn.com

·         Formed Helpdesk, evaluated and purchased Support Magic as Helpdesk tracking system, hired person in analyst position, created/automated/provided daily reports to Senior Management and provided support in the areas of Microsoft Office, Windows 3.1, VAX, relocation and asset tracking management to 700+ users nationwide.

·         Created/implemented service level agreements with business heads of each department

·         Implemented user questionnaire on Helpdesk effectiveness

·         Implemented/documented call procedures

·         Built mini-knowledgebase from Support Magic data using Magic Tree and Standard problem/resolution module packaged with Support Magic

·         Provided technical support to Senior Management

 

 

MORGAN STANLEY SMITH BARNEY, New York, NY                        APR’93 - APR’94

HELPDESK ANALYST

 

·         Implemented customer satisfaction survey

·         Supported 1200+ clients and traders on the Microsoft Office, Windows 3.1, proprietary and UNIX operating systems.

 

 

DEUTSCHE BANK, New York, NY                                                               DEC’88 - APR’93

RELATIONSHIP MANAGER

 

·         Provided support to clients (including senior management) on Windows 3.1, DOS, Lotus 123, WordPerfect, Word and Excel, upgrades (memory, system, printers) and relocation.

·         Assisted in relocation of entire 280 Park Avenue operation after fire