MS Access/MS Excel Developer Resume

SUMMARY

To contribute to robust business solutions and test environments using .NET/MS Access (version 2.0 - 2016)/VBA/SQL Server/SSIS/SSRS/Oracle/VB6
Rich experience working with clients/end-users to design, create, test, document and implement custom MS Reporting Services, VBA, VB6, SAP Business One SDK, MS Access, Excel, databases, user manuals and web sites
Experience with design requirements, systems analysis, MS Office automation, UAT scripts and implementation, VBScript, VBA, SQL Server, Access ADP/MSDE, database conversion (Access 2.0-Access 2016). .NET, SSIS
Experience with compensation, commissions and incentive data, workflow and reports, data reconciliation
Extensive experience with data merge, scrub, cleanse and migration to and from disparate data sources
Rich experience creating complex work flow applications referencing disparate data sources
OOAD
Extensive experience with complex logic, business rules and Windows forms

PROFESSIONAL EXPERIENCE

Confidential

MS Access/MS Excel Developer

Responsibilities:

Create complex MS Access database to store and update MBOM and EBOM data for the design and manufacturing of sub-orbital space ships
Support and modify multiple MS Access databases for storing and updating FAA-required documentation for sub-orbital spaceship and mothership

Confidential

MS Excel/MS PowerPoint Developer

Responsibilities:

Created complex formatting process to integrate existing MS Excel workbook into PowerPoint
Extensive VBA coding for PowerPoint and Excel DOM
Project was completed early and under budget

Confidential

MS Access Developer

Responsibilities:

Create manual ETL processes (MS Access and MS Excel) for translating 40,000 Covidien product licensing data for Confidential SAP upload for 34 countries
Extensive data scrub, cleanse, merge and migration
Create ad hoc reports for senior management

Confidential

MS Access Developer

Responsibilities:

Created complex MS Access databases to track campaign activities for non-profit fund-raising projects
Complex business rules, mail merge and reporting