Senior VBA Developer Resume New York, NY - Hire IT People

SUMMARY:

Microsoft Office expert, specializing in Access and Excel system development using VBA. Extensive knowledge in building applications with Access and analyzing data with Excel. Special focus on integrating Access and Excel applications. Strong data manipulation and analytical skills as well as the ability to problem solve and troubleshoot bugs/errors. Proven track record of reducing resources and saving time. Proactively document all problems and solutions with current as well as newly developed processes. Areas of expertise also include:
VBA Microsoft Office RAD
Excel SQL Server 2008, 2012SDLC
Access Microsoft Visio Agile
SQL Microsoft Project Business Analysis
SSRS Windows 2000 - 8 Project Management
Crystal Reports Windows Server Data Analysis
SharePointReporting

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior VBA Developer

Responsibilities:

Develop new waterfall models for client deliverables using VBA in Excel including writing code for various waterfall calculation methodologies.
Maintain and enhance existing Excel models, use OLEDB connection to Investran database to update data, refresh investors, export reports for client use and add approved legal disclaimers all using VBA.
Partner with different groups as the go to VBA resource for Alternative Investment Services division.
Assist other teams to modernize numerous processes: tracking foreign exchange rates, reporting detailed financial information for investors and encryption algorithm to mask sensitive data.
Develop an Access database for the Technology Request Prioritization report which links to SharePoint and emails a formatted Excel file to business teams.
Analyze data from waterfall calculations and develop automated reports using SSRS and Crystal Reports.
Develop applications utilizing the Agile Project Management methodology and lead project as Scrum Master.
Optimize SQL Server database to reduce size and speed up processing of waterfall models by 90% creating numerous stored procedures and indexes using Transact SQL (T-SQL).
Instrumental with transition to strategic waterfall solution built on .NET framework by managing outside vendor and all internal technology teams involved.
Update all infrastructure components with new builds from vendor including web and app servers, IIS, SQL server and virtual testing cloud environment.
Manage change control process involving more than a dozen teams to coordinate and deploy change requests and liaise with the business to conduct Production Validation Testing (PVT).

Confidential, New York, NY

VBA Developer/Business Analyst

Responsibilities:

Performed all areas of the SDLC including gathered requirements and analyzed data, designed system specifications for new applications, developed the applications in Access and Excel using VBA and implemented them into the production environment, performed user acceptance testing (UAT) and maintained all existing workbooks and databases.
Developed new features and functionalities in Access & Excel to develop and automated procedures for manual processes.
Fixed bugs and errors, troubleshot and maintained previously developed databases/spreadsheets.
Designed and implemented an Access database which created a report of past due premiums, using the Excel Object Model to export the data and format into a customized layout.
Created Excel workbook to track annual budget and improved current process so data could be pulled automatically from internal accounting system. Import went from 4 hours to < 1 minute.
Revamped entire Sch P database process which was manually intensive. Automated entire database using Access.
Developed database in Access to pull claims data from SQL Server and integrated with Excel to provide easy and quick display of data with customized formatting.
Acted as liaison between Finance and IT.

Confidential, New York, NY

VBA Developer

Responsibilities:

Automated the reporting of Internal Audit metrics using VBA in Excel and Access; metrics used in presentation to the Board to determine the direction of the organization for IT in 2008 and 2009.
Developed reporting for risk management and SOX related issues for senior management using Access, Excel, VBA, Crystal Reports XI and SharePoint.
Automated data integrity reports and data backup from SharePoint, using Access, Excel and VBA saving 4 hours every day. Developed individualized reports sent to business users with respective data integrity issues and graph to track issues.
Automated Sybase Expired Password Report by pulling data into Access and using VBA to produce individualized reports that are emailed to the business users through Outlook.
Created Toxic Combination tool in Access and Excel using VBA to report SOX applications that have control deficiencies in key risk areas.
Developed data snapshot tool in Access and Excel to capture data for quarterly 302 and end of year 404 SOX s. Process used to take 12 hours and now takes 30 minutes.

We provide IT Staff Augmentation Services!

Senior Vba Developer Resume

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship