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 s include:
• Expertise in all aspects of program analysis and 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.
• Analyzed, built and maintained interfaces between Salesforce and proprietary billing and accounting systems
• Analyzed, developed and maintained a system to download and store currency rates from Oanda.com
• 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 Confidential FCC order timeline compliance.
• Analyzed and 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 ), MS InterDev, MS IIS, 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, QuickBooks, Salesforce, SAP, Varicent, Workplace, Workday

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

VBA Developer

Responsibilities:

• Updating pharmaceutical usage dashboards.
• Created macros to automate entries.
• Expertise in RAD Microsoft Access/Excel macro and VBA development.
• Design user interface, reporting tools and supporting documentation.
• Create reporting and data import/export tools

Confidential, Houston, TX

VBA Developer

Responsibilities:

• Created an Excel macro to automate General Journal entries to QuickBooks.
• Design user interface, reporting tools and supporting documentation.
• Created macros to automate entries.

Confidential, New York, NY

VBA Developer

Responsibilities:

• Automated a treatment cost calculator in Excel to create PowerPoint presentation for a pharmaceutical co.

Confidential, New York, NY

VBA Developer

Responsibilities:

• Created a report that pulls data from two different SAP databases

Confidential, New York, NY

VBA Developer

Responsibilities:

• 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.

Confidential, New York, NY

Senior Programmer/ Analyst, (Contract assignment)

Responsibilities:

• Developed CRM program utilizing Access and VBA.

Confidential, New York, NY

Senior Programmer/ Analyst

Responsibilities:

• Windows XP roll out.
• Microsoft Office VBA and SQL trouble shooter.
• Developed web based issues tracking Help Desk application using ASP.NET& Dreamweaver.
• Analyzed and developed an invoicing program utilizing Access and Excel VBA.

Confidential New York, NY

Senior Programmer/ Analyst

Responsibilities:

• Analyzed and 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.
• Analyzed and 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.
• 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.

Confidential, New York, NY

Senior Analyst/ Programmer

Responsibilities:

• Analyzed and 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. PVCS version control.

Confidential, New York, NY

Senior Programmer/ Analyst

Responsibilities:

• Analyzed and 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.

COMPUTER COORDINATOR

Confidential, New York, NY

Responsibilities:

• Analyzed and provided programming, system design, and system analysis, developing database front-ends in FoxPro, VB, SQL and Crystal Reports for automating mailing lists, dues collection/ 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 in dues calculation disputes.