We provide IT Staff Augmentation Services!

Excel/vba Developer Resume

3.00/5 (Submit Your Rating)

Mahwah, NJ

Hire Now

SUMMARY:

  • An experienced and skilled Access/Excel/VBA/SQL programmer with the ability to provide sound technical solutions for businesses and individuals.
  • Microsoft Access/Excel, VBA, T - SQL
  • Microsoft Office utilities (Word, PowerPoint, Outlook, etc.)
  • Microsoft SharePoint
  • Microsoft PowerApps
  • Microsoft Flow
  • Microsoft SQL Server
  • Microsoft Visual Basic .Net

PROFESSIONAL EXPERIENCE:

Confidential, Mahwah, NJ

Excel/VBA Developer

Responsibilities:

  • Wrote VBA code to import insurance data from worksheets into SQL Server database
  • Wrote VBA code to copy data from one workbook to another
  • Created Access front ends with linked SQL Server tables
  • Created Tables, Views and Stored Procedures in SQL Server
  • Provided technical support to coworkers

Confidential, East Rutherford, NJ

Excel/VBA Developer

Responsibilities:

  • Wrote VBA code to implement updates on 30 + workbooks simultaneously
  • Wrote VBA code to merge worksheets from separate workbooks
  • Created PowerApps forms linked to SharePoint backend
  • Created involved workflows for PowerApps in Flow
  • Supported end users via phone and email

Confidential, Wayne, NJ

Access/VBA Developer

Responsibilities:

  • Created and modified daily supply chain reports in Access 2010
  • Wrote VBA code within Access to import daily csv file into company database
  • Created and modified SQL queries in IBM Showcase 8.1
  • Wrote VBA code in Excel to format vendor files
  • Automated monthly financial reports in Excel VBA
  • Extracted and transformed data in JD Edwards system to load into SAP via Access

Confidential

Senior Technical Specialist

Responsibilities:

  • Maintained and updated financial database in Access 2013/VBA
  • Automated company’s invoice generation system in Access/VBA/SharePoint
  • Created database that generated dynamic graphs in Access 2013
  • Developed reports and queries in Cognos 8
  • Wrote complex queries in MySQL Workbench 6.2
  • Used Macros, VBA, formulas in Excel 2013

Confidential, Wayne, NJ

Programmer/Analyst

Responsibilities:

  • Manipulated Pharmaceutical data in Access 2002
  • Wrote several applications in VB.net
  • Built and maintained a complex user interface for client database in Access 2002
  • Wrote robust VBA modules in Excel to convert spreadsheets to PDFs
  • Provided help desk support to co-workers when needed
  • Imported and analyzed survey data in SPSS 18.0ompany migrate from old DOS-based program to new state of the art billing software
  • Wrote complex SQL queries for company’s new software
  • Wrote code/developed front end interfaces in proprietary language
  • Used proprietary software to build an import/export process for company’s database
  • Developed conversion databases in Microsoft Access for medical billing software
  • Parsed fixed width and delimited text files for said medical billing software using VBA

Confidential, Armonk, NY

Programmer/Analyst

Responsibilities:

  • Wrote and modified SQL Server stored procedures, triggers, and cursors
  • Developed and modified robust VBA modules for complex financial software
  • Developed intricate queries in T-SQL and Access for importing/exporting large amounts of data to and from Excel spreadsheets
  • Worked with ADO to connect Access front end to SQL Server back end
  • Created custom databases to extract data from financial software

Confidential, Blauvelt, NY

Database Developer

Responsibilities:

  • Developed and maintained intricate relational databases in Microsoft Access 97/2000
  • Constructed complex queries using both Access and SQL
  • Used VBA code and Macros used to automate many database processes
  • Helped develop a back end SQL Server 7.0 database for technical support front-end software
  • Developed inventory databases using Microsoft Access 2000 and barcode scanning software
  • Produced comprehensive weekly/monthly reports from databases in Access
  • Created pivot tables and charts in conjunction with weekly/monthly reports

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship