VBA Developer/C# Developer

Responsibilities:

• Expert-Level Transition from MS 2013 to 365: Lead the seamless transition of VBA code modules from MS 2013 to 365 without any business impact. Execute meticulous testing and side-by-side comparison to ensure compatibility and functionality across both environments.

• Independent Expert Work: Perform expert-level work independently, ensuring precision and accuracy throughout the transition process.

• Technical Expertise and Testing: Conduct exhaustive testing and validation of converted code to guarantee functionality parity between MS 2013 and 365 without affecting business operations.

• Analysis of Data Storage Best Practices: Assess and analyze the storage of VBA-generated data in databases as XML blobs. Evaluate the best-fit storage practices, considering XML/JSON formats and their impact on database efficiency.

• Collaboration with Agile Development Tools: Utilize familiarity with tools like JIRA and Confluence for efficient agile development and collaboration with stakeholders.

• Excel Transformation and Publishing – Programmatically transforming and storing excel as PDFs ensuring data integrity, accuracy and formatting in preserved.

• Problem Resolution and Optimization: Identify potential issues proactively, troubleshoot problems independently, and optimize code modules for MS 365 environment.

Key Qualifications:

• Extensive and demonstrable expertise in VBA, C#, OfficeScripts and Excel automation at an expert level.

• Proven track record in expertly transitioning VBA code modules from MS 2013 to 365 without business impact.

• Intermediate experience in SQL Server, capable of working with databases.

• Good understanding of XML and JSON formats and their storage within a database environment.

• Ability to analyze and determine the best-fit storage practices for VBA-generated data stored as XML blobs.

• Familiarity with Atlassian Suite of Products for efficient collaboration and workflow management.

• Experience with OCR tools, such as Azure Document Intelligence Studio, for optimized data extraction.

• Proficiency in independent work, demonstrating a high level of precision and accuracy.

• Strong problem-solving skills and the capability to optimize code modules for MS 365 environment independently.

• Prior experience in Banking operations or a similarly regulated industry is advantageous.

Additional Notes:

• This role demands an expert's focus on transitioning existing VBA code modules from MS 2013 to 365 without any business impact, requiring meticulous testing, and independent expert-level work.

Collaboration with stakeholders for insights and recommendations is essential, although the primary responsibility lies in independent expert-level execution.

Job Type: Contract

Salary: $66,069.95 - $163,210.95 per year

Experience level:

• 10 years
• 11+ years

Schedule:

• 8 hour shift
• Day shift
• Monday to Friday

Experience:

• VBA: 10 years (Required)
• C#: 10 years (Required)
• Microsoft 365: 5 years (Required)

Work Location: Remote