We provide IT Staff Augmentation Services!

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

Hire Now