MS Access/MS Excel Developer Resume

OBJECTIVE

To contribute to robust business solutions and test environments using .NET/MS Access (version 2.0 - 2016)/VBA/SQL Server/SSIS/SSRS/Oracle/VB6/VBA/MS Excel

SUMMARY

Rich experience working with clients/end-users to design, create, test, support, identify, document and implement custom MS Reporting Services, VBA, VB6, SAP Business One SDK, MS Access, Excel, 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, support and enhancement (Access 2.0-Access 365)
Extensive experience managing/DBA for MS Access databases including dependencies, split files and file location, ODBC connections, speed optimization, sunsetting, reconciling, and merging multiple MS Access database used by disparate teams across an organization, complex debugging and errors, ensuring data integrity, and creating UAT scripts for changes
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 workflow applications referencing disparate data sources
Best practices for OOAD, TDD and SOLID principles
Extensive experience with complex logic, business rules and Windows forms

PROFESSIONAL EXPERIENCE

Confidential

MS Access/MS Excel Developer

Responsibilities:

Support and enhance MS Access workflow application for legacy aircraft data transformation into SCEPTRE
Oracle, SQL and Azure backend support and enhancement
Ad hoc Excel reporting

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 spaceships
Acted as DBA for FAA-audited MS Access databases used by advanced design, maintenance, and documentation teams, including managing upgrades to Office 365, upsizing to SQL server, and responding to end-user and developer issues
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/MS Excel Developer

Responsibilities:

Create, update, support complex MS Access/MS Excel applications for Confidential nationwide
Create complex pricing Excel workbooks
Create manual ETL processes (MS Access and MS Excel) for translating 40,000 Covidien product licensing data for Medtronic SAP upload for 34 countries
Extensive data scrub, cleanse, merge and migration
Work as MS Access DBA to ensure data integrity, optimization, and file placements for multiple Covidien MS Access databases used in tracking medical devices, including overseeing all MS Access upgrades and writing UAT scripts for integrating multiple Covidien databases into existing Medtronic MS Access databases and enterprise software
Create ad hoc reports for senior management