| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name , MCSE
Street Address Albany Street, Apt. 5D PHONE NUMBER AVAILABLE
New York, NY Street Address -1406 EMAIL AVAILABLE
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
Candidate's Name , MCSE Page Two
PHONE NUMBER AVAILABLE EMAIL AVAILABLE
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.
Candidate's Name , MCSE Page Three
PHONE NUMBER AVAILABLE EMAIL AVAILABLE
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
|
