Description

You will lead the technical transition of VBA code modules from MS 2013 to Office 365 while maintaining business continuity.

This role is remote.

Responsibilities

• Migrate VBA code from MS 2013 to 365 through meticulous testing and side-by-side functional comparisons.
• Analyze and optimize VBA-generated data storage, evaluating XML vs JSON formats for database efficiency.
• Programmatically transform and store Excel files as PDFs while ensuring data integrity and formatting preservation.
• Troubleshoot and optimize existing code modules specifically for the MS 365 environment.
• Manage development tasks and stakeholder collaboration using JIRA and Confluence.

Required Skills

• Expert-level VBA coding and advanced Excel formula development.
• Proficiency in C# and Excel automation.
• Experience managing and optimizing XML blob storage in databases.
• Working knowledge of XML/JSON formats.
• Experience with SQL Server.
• Familiarity with JIRA and Confluence for agile development.
• Experience with OCR tools.

Preferred Skills

• Proven track record of transitioning legacy MS Office environments to Office 365 without business disruption.

Key Skills

Education

Any Gradute