Project Manager Sql Server

EDWARD RALPH GALIMI

SKILLS

Microsoft Excel/Office Object Model/VBA, ADO (Oracle, Sybase, SQL Server & Access),

Bloomberg API, XML, Visual Basic 6

EXPERIENCE

Incorporated and working as independent consultant since 1997

10/2008 – 4/2009 Dresdner Kleinwort/Commerzbank

Trading support for Equity and Options desk

7/2008 – 9/2008 PIMCO

Excel VBA Programmer

Automated Excel based hourly report for CEO, Bill Gross

Automated Home Price Appreciation spreadsheets

11/2007 – 7/2008 BMC Strategic Associates

Project Manager

Created front end spreadsheet to link data via ADO to Access database for primary client

Hired two consultants to enhance Excel/Access product design

12/2006 – 11/2007 Ramius Capital Group

VBA Programmer

Enhanced real time, Excel based profit and loss application through use of ADO, SQL Server,

Access & Bloomberg API

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

10/2006 – 12/2006 Sempra Energy

VBA Programmer

Converted 10,000+ Microsoft Excel 2000 spreadsheets to Microsoft Excel 2003 (team)

Maintained Access database to track spreadsheets

06/2006 – 10/2006 UBS

VBA Programmer

Enhanced existing Profit & Loss spreadsheet for Prime Brokerage clients to account for Microsoft

Excel RTD (Real Time Data) component

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

04/2006 – 06/2006 Fannie Mae

VBA Programmer

Developed ADO (Oracle) interface that retrieves and sends amortization data to an Oracle server

Created custom SQL for data retrieving and sending

Automation of procedures using Excel VBA

12/2004 – 02/2006 Merrill Lynch

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 userforms in VBE

06/2004 – 12/2004 JP Morgan Chase

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

04/2004 – 05/2004 TradingScreen.com

VBA Programmer

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

07/2003 – 03/2004 Western Asset Management

VBA Programmer

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 SQLServer and used ADO technology for connectivity to SQLServer

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

04/2003 – 07/2003 IDT

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

01/2001 – 04/2003 Salomon Smith Barney

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

Page 2 of 5

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

08/2001 – 09/2001 Supreme Evaluations

VBA Programmer

Automated special education forms in Microsoft Word with use of VBA

Provided printer and network support

Provided general Office XP and proprietary application support

09/2000 – 12/2000 The Bank of Tokyo

Desktop Support

Provided trading floor support for market data applications, (i.e., Reuters, Bloomberg, Bridge,

Telerate) Microsoft Office, Hardware and Printers

04/2000 – 08/2000 Cablevision

Gauged feasibility of PC population’s ability to run Office 2000, upgraded hardware as necessary

and performed rollout of Office 2000.

04/2000 – 10/2000 Citibank

Entrust Administrator

Enabled Entrust security certificates to Citibank clients

01/2000 – 01/2000 Cablevision

Technical Support

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

11/1999 – 12/1999 Brooklyn College

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.

05/1999 – 07/1999 Compaq

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.

Page 3 of 5

06/1998 – 05/1999 J &W Seligman Corp.

Helpdesk Analyst

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

05/1997 – 05/1998 Alliance Capital

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

01/1997 – 03/1997 Goldman Sachs

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

07/1996 – 01/1997 The Bank of New York

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

04/1994 – 07/1996 Société Générale

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

Page 4 of 5

04/1993 – 04/1994 Salomon Brothers

Implemented customer satisfaction survey

Supported 1200+ clients and traders on the Microsoft Office, Windows 3.1, proprietary and UNIX

operating systems.

12/1988 – 04/1993 Bankers Trust

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

EDUCATION

St. Johns University, BS, May-92, Computer Science

Worked full time days while going to school at night full time

Page 5 of 5

Contact this candidate