GEORGE KENDALL, MCSE

*** ****** ******, ***. ** 917-***-****

New York, NY 10280-1406 acfop1@r.postjobfree.com

SUMMARY

Senior Programmer/ Analyst, with experience in IT, providing top-notch

analytical and programming skills with expertise in RAD Microsoft

Access/Excel macro and VBA development. Qualifications and accomplishments

include:

. Expertise in all aspects of program development/system development life

cycle.

. Proven track record in rapid application development for Financial,

Banking and High Tech institutions.

. Ability to thrive within fast-paced environments.

. Two years as a supporting Varicent programmer.

KEY ACCOMPLISHMENTS

. Built and maintained interfaces between Salesforce and proprietary

billing and accounting systems

. Built and maintained a system to download and store currency rates from

Oanda.com

. Led in the successful migration of applications from Office 97 (NT) to

Office XP.

. Provided high-volume rapid application development on an ad-hoc basis for

that streamlined procedures, met compliance requirements and enabled

efficient reporting procedures on a company-wide basis.

. Co-developed web pages utilizing HTML, ASP, JavaScript and direct ADO

connections providing Salomon Smith Barney FCC order timeline compliance.

. Developed an automated newspaper ad insertion tracking and billing system

that provided automatic calculation of weekly volume discounts for ads in

newspapers across the Northeast.

TECHNICAL SKILLS

Languages: MS Access/Excel/Outlook, VBA, Visual Basic, Varicent, SQL, ADO,

RDO, ODBC, C/C#/C++, MFC, Active Server Pages (ASP),

VBScript, HTML, XML, JavaScript, Crystal Reports, FoxPro,

Visual FoxPro, PowerShell, Windows Scripting, Assembly, COM

(In & Out of Process), DLLs, OCXs

Tools: MS Visual Studio (.Net/2010/2008/6.0/5.0), Microsoft InterDev,

Microsoft IIS, Macromedia Dreamweaver, Flash, PVCS

Database: Oracle 11g, SQL Server 2008, Access 2010, FoxPro, dBase,

Sybase, ODBC

OS: Microsoft Windows Server 2008, 7, Vista, XP, NT, 3.11, DOS, NT

Applications: MS Office 365, 2010, 2007, XP, 2000, 97, 95, MS Publisher,

PhotoDraw, Business Objects & Crystal Reports, Adobe

Acrobat, Adobe Photoshop, Visio, Great Plains, Salesforce,

SAP, Varicent, Workplace, Workday

PROFESSIONAL EXPERIENCE

Ogilvy, New York, NY March 2014

VBA Developer

Created a report that pulls data from two different SAP databases

IntraLinks, New York, NY Jul 2006 - Feb 2014

Secure Virtual Data Rooms and Communications for Banking and Investing

VBA Developer

GEORGE KENDALL, MCSE Page Two

917-***-**** acfop1@r.postjobfree.com

PROFESSIONAL EXPERIENCE

IntraLinks, (continued)

Built a system to download, process and upload billing information to

SalesForce.com. Utilizing VBA and modifying a SalesForce provided

Excel.xla file to automate. Helped in the integration of Great Plains.

Generated invoice data for $200 million in sales.

Automated currency rate extraction for implementation of Workday

Took Varicent training and assisted in generating Commission statements for

the past two years

. Assisted in implementation of a new approval Matrix for the Requisition

System in Workplace

. Developed a billing system utilizing VBA, Excel, Access and SalesForce.

Billed over $200M.

. Developed a Deferred Revenue Reporting system using VBA, Excel, Access

and Great Plains.

. Developed an Accounts Receivable Open Collections Info system using VBA,

Excel, Outlook and Great Plains.

. Developed a Bookings Forecast system utilizing VBA, Excel and Access.

. Completed the following applications using Excel and Access: AR Aging

Report, Billing QA, Commission Manager, Credit Opportunity Creation,

Credit Request Tracking, DCM Consumption Report, Compare DCM Workbooks,

Deal Stream Reports, Monthly Revenue Analysis, Opp Creation, Varicent,

T&E Report.

. Converted from contract to full-time employment 8/4/08.

The Phoenix Group, New York, NY Feb - Jun 2006

Senior Programmer/ Analyst, (Contract assignment)

. Developed CRM program utilizing Access and VBA.

TD Securities, New York, NY - Hedge Fund Apr 2005 - Jan 2006

Senior Programmer/ Analyst

. Windows XP roll out.

. Microsoft Office VBA and SQL trouble shooter.

. Developed web based issues tracking Help Desk application using

ASP.NET& Dreamweaver.

. Developed an invoicing program utilizing Access and Excel VBA.

HSBC, Global Bank New York, NY Feb 2001 - Mar 2005

Senior Programmer/ Analyst

Development of MS Excel Object Model and Access using VBA and SQL for

Interest Rates Derivatives Risk, Mortgage Backed Securities and Emerging

Markets FX Groups projects.

. Developed an application to process data from several different vendor

systems (i.e. Calypso, MAS, Summit, Treats) into a common format that

populated regulatory reporting templates.

. Automated regulatory reporting systems for interest rate derivatives,

equity and futures, and treasury products.

. Developed reporting front-ends for Global Financial Data Module, a data

warehouse that was under development.

. Created a Proof of Accounts processing system. Monitored the GL for new

accounts, reported the number of transactions, assisted in assigning

Preparers, Reviewers, and Managers, generated monthly worksheets,

summarized and aged the accounts.

. Provided rapid application development of numerous reports for six

different companies.

The reports cover Basket Options, Bond Options, Caps, Credit Risk, Currency

Futures, Currency Swaps, Equity Futures, Equity Swaps, Euro Libors, Euro

Libor Options, Floors, Fixed Income, Forward Rate Agreements, Futures,

Future Options, Government Bond Futures, Index Futures, Index Options,

Interest Rate Bond Futures, Interest Rate Futures, Risk Management, Trading

Credit Risk, Swaps, Swaptions and more.

GEORGE KENDALL, MCSE Page Three

917-***-**** acfop1@r.postjobfree.com

PROFESSIONAL EXPERIENCE

HSBC, Global Bank, (continued)

. Built a variety of applications for personnel in several in-house and

remote site departments.

. Key member of team effort to develop numerous reports using a growing

warehouse of data.

. Automated dozens of ad hoc data gathering and reporting applications with

Excel and Access:

. Led in the migration of applications from Office 97 (NT) to Office XP.

. Documented application processes utilizing Visio.

Salomon Smith Barney, New York, NY Mar - Oct 2000

Senior Analyst/ Programmer

Participated in a high-profile web-based team project melding PC and

mainframe technologies. Worked from detailed program specifications for

entering stock transactions that complied with emerging NASD regulations.

. Designed MTS COM components to interface with other COM components and a

DB2 mainframe. The system was deployed over the corporate intranet with

client-side deployment in VBScript. COM components were built using

Visual Basic 6.0 and SQL to implement connections.

. Co-developed web pages utilizing HTML, ASP, JavaScript and direct ADO

connections.

. Utilized prepared QA test scripts to validate program specifications

which called for validating data entered into the system with data

entered from the exchange floor..

Bozell Worldwide, Inc., New York, NY Jun 1997 - Sep 1999

Senior Programmer/ Analyst

. Developed an automated newspaper ad insertion tracking and billing system

utilizing Excel, Visual Basic for Applications, SQL, PowerBuilder, Data

Architect and Active Server Pages that provided a daily report for use by

traffic and other departments.

. Worked closely with Media Planners in the design and implementation of

spreadsheets that recorded and automatically calculated weekly volume

discounts for ads in more than 200 newspapers across the Northeast.

Helped troubleshoot PowerPoint presentations.

. Created Help Desk Dispatching System, Survey Questionnaire, Employee

Database, and Experience Inventory on corporate Intranet using IIS, ASP,

Jscript and VBScript.

ADDITIONAL RELEVANT EXPERIENCE

COMPUTER COORDINATOR Mar 1988 - Oct 1996

Motion Picture Machine Operators Union, New York, NY

. Provided programming, system design, and system analysis, developing

database front-ends in FoxPro, VB, SQL and Crystal Reports for

automating mailing lists, dues collection/membership processing.

. Created theatre/movie Help Files from Times listing in AOL utilizing

VBA (Word) and parsed for hours of operation.

. Developed Help files for office staff to reference in dues calculation

disputes.

EDUCATION

Electrical Engineering, Austin-Peay State College, Clarksville, TN

University of Kentucky, Lexington, KY

C Programming, Columbia University, New York, NY

MILITARY SERVICE

US Army, 18 months - Purple Heart, Bronze Star, Honorable Discharge

Contact this candidate