VBA Programmer Resume Profile

TECHNICAL SKILLS

Advanced Excel, VBA, SQL, Access, Outlook, Wordpress, HTML, MySql, Php, Javascript, Gravity Forms, Google Spreadsheets, Sharepoint, Statistics/Data Analysis, Dashboards, SAS, cobol.cics, vsam, Jcl .

PROFESSIONAL EXPERIENCE

Confidential

Excel VBA Programmer/Analyst

Reduced over 70 Excel workbook masters to one master workbook to produce the same number of reports by identifying commonalities and patterns that enabled me to construct sets of parameters and use only one automation process thereby dramatically reducing template, code and other maintenance work.
Using the same principles as above, standardized many other reports to reduce over 90 master workbooks to 13 masters, greatly improving efficiency and accuracy.
Designer/developer for the automation of daily and weekly sales report production using Excel VBA with embedded SQL strings for pulling data from SQL Server and Hyperion Essbase.
Conceptualized and developed Quality Assurance Excel/VBA-based procedures that: automatically check report errors that forces aborting automatically check failures to save reports and automatically send failure emails to operators programmers that include links to the failed locations for easy resolution.
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

Excel Programmer/Developer

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

Confidential

Excel VBA Programmer/Developer- Contracting for clients such as CIT Financial, Bergen Regional Medical Center
Using Access VBA with PeopleSoft data, redesigned/rewrote receivables reconciliation application for a large bank
Collected requirements for a hospital patient tracking system, starting from patient registration, patient movements procedures conducted, treatments administered, court appearances and discharge, including statistical and census reports.
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

Business Analyst/Excel VBA Programmer

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

Business Analyst/Excel VBA Programmer

Wrote VBA in Excel to extract material and other information from the Access database to prepare tables of materials with dimensional adjustments for precise cutting instructions, including timber and brake metal reinforces and spacers plus screws and other connectors
Standardized forms and created Excel templates for listing materials, dimensions and building information from architectural and engineering drawings
Developed an Access database of window types and curtain walls aluminum frame materials, glazing, timber and metal accessories and connectors including standardized cutting adjustments for precise assembly and installation.
Created a user interface with ActiveX controls for convenient navigation and execution of code modules.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship