Excel-VBA Developer Resume

SUMMARY

Highly experienced and skilled Excel VBA Developer with around 10 years of an extensive record of successful system design and implementation. Adept at working independently or as part of a team.
Strong computer skills S Expert use of MS Office Suite S Custom database development S Excellent skills in VB development S Outstanding expertise in all Microsoft Office applicationsSuperior interpersonal skills
Exceptional problem solving and analytical skills
Excellent oral and written communication skills
Proven background translating cell formulas in Excel into VBA code.
Created Macros for Business Development.
Automating, modifying, and optimizing reports in Excel Access.
Experience in the development of financial applications using Excel and Access.
Experience in redesigning, maintaining and supporting existing applications and tools especially in Microsoft Excel Access 2007 / 2010.
Experience in Advanced Excel and its features like Pivot Tables, Charts, Functions, etc. S Experience in migration of databases to MS Access utilizing tables, queries, forms, reports, macros, and modules.
Experience in SQL statements, stored procedures using SQL server 2005/2008.
Used MS Excel/Access VBA SQL to send system generated e - mails, manage and report embedded Excel documents.

PROFESSIONAL EXPERIENCE

Excel-VBA Developer

Confidential

Responsibilities:

Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
Extensive experience implementing software user interface improvements based on client needs.
Extensively use Excel functions in development, focusing on read/write integration to databases.
Prepared visible columns and formulas; imported data from Salesforce and exported data for metrics.
Exported information from report generated by accrual database to accrual upload in Salesforce.
Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Business Intelligence Analyst; Support/VBA Developer

Confidential

Responsibilities:

Aided in development and management of Access database solutions using SQL Server, including macros and reports.
Helped migrating legacy spreadsheets from front-office technology to valuation framework.
Good experience in the implementation of all phases of Software Development Life Cycle SDLC from requirements gathering through implementation.
Prepared program level and user level documentation.
Assisted in creation of internal applications for marketing and customer relations departments, including financial reporting tools and reports.
Analyzed and tested systems. Provided on-site support and training for new users.
Use Rapid Application Development (RAD) Programming techniques to develop and execute applications and manage end-to-end tactical solutions to meet business challenges.
Developed user manuals, training guides and other materials for end user training and worked with e-learning developer to create educational courses for online learning.
Remediated slow Excel Macro tools by converting them into Object Oriented Programs and removing slow loop code and replacing it with arrays to range allocations.
Planned, developed, implemented and administered for the acquisition, storage and retrieval of data for a variety of databases that support the programmatic and administrative functions of this system.
Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data. Analyzed and defined data requirements, specifications and procedures; planned for and anticipated changes in data capacity requirements, and evaluated new technologies and architectures.
Worked with the Health & Safety department manager on the design and implementation of a database driven web portal for monthly check-up reporting, using VB.net and ASP.net.

Excel-VBA Developer

Confidential

Responsibilities:

Built MS Access Database for Market Research.
Complete Access Database - Restructure - Troubleshoot -VBA - and SQL (Structured Query Language) Code - Build Custom Forms and Reports.
Relational Database table structure includes one-to-many, one-to-one, and many-to- many relationships with implementation of junction tables.
Database includes over 30 employees with various security levels.
Main structure features include: Project Entry, Time Charging, and Advanced Reporting (Custom Outputs using Access Database Reports as well as Object Orientated Application Outputs to Excel and PowerPoint for Charts and Presentations.)
VBA Modules include complex Functions to loop thru form controls, VBA code working in conjunction with SQL Statements to manipulate data.
Dynamic Advanced Filtering, which incorporated using UNION queries, for searching and reporting which include multiple field(s) (combo box, textbox, checkbox, listbox) as well as "wildcard" - partial entry field(s) - used to search description or Project name field(s).

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship