Business Analyst/Excel VBA Programmer Resume Rutherford, NJ - Hire IT People

SUMMARY

Over 15 years experience with Advanced Excel, macros/VBA, automation, SQL, Access, Outlook, GUI development

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, East Rutherford, NJ

Excel VBA Programmer/Analyst

Responsibilities:

Customizes a VB - based bill of materials software
Conducts user to discuss existing methods and processes and propose revisions
Analyzes the dozens of window models, their infinite combinations for high-rise buildings
Drafts new/enhanced report templates
Design and write customization code as necessary
Create new/enhance existing user interface for friendly, accurate and efficient automation
Authors user guides and operation manuals

Confidential, Englewood Cliffs, NJ

Excel VBA Programmer/Analyst

Responsibilities:

Designer/developer for the automation of daily and weekly sales report production using Excel VBA with embedded SQL strings for pulling data
Conceptualized, developed and installed “drivers” - that controlled sets of parameters fed to common sets of report templates to standardize reporting by dimension and measures

Confidential, New York City, NY

Excel Programmer/Developer

Responsibilities:

Designed, coded, and implemented a GUI-driven Excel/VBA based healthcare enrollment application for a major advertising/marketing firm.

Confidential, Maywood, NJ

Excel VBA Programmer/Developer

Responsibilities:

Using Access VBA with PeopleSoft data, redesigned/rewrote receivables reconciliation application for a large bank
Designed and developed a system using MS Access/Excel pulling data from SQL Server, complete with user interface and forms; tables, fields, relationships, using VBA and SQL for maintenance and the generation of reports.

Confidential, Clifton, NJ

Business Analyst/Excel VBA Programmer

Responsibilities:

Designed and developed business reports for senior management and other levels
Developed an Excel VBA-based software for project time-lines and product pricing
Tracked product and customer performance using OLAP, advanced Excel & VBA
Developed dashboards for margins, sales, forecasts and inventory
Coordinated with the finance department in reconciling financial reports.
Developed a VBA-based software that generates Item Fact Sheets from Excel line lists
Developed and maintained an Access database for product pricing
Coordinated with seven Product Managers for product pricing and new product launches.

Confidential, Rutherford, NJ

Business Analyst/Excel VBA Programmer

Responsibilities:

Standardized forms and created Excel templates for listing materials, dimensions and building information from architectural and engineering drawings
Created a user interface with ActiveX controls for convenient navigation and execution of code modules.