VBA Developer

Skills

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.

Description

Overview: We're actively seeking an expert-level individual highly skilled in VBA, C#, and Excel automation, specializing in transitioning from MS 2013 to 365 without business disruption. This role necessitates an exceptional professional with extensive experience in VBA coding, advanced formula development, and a proven track record in independent expert-level work. Additionally, expertise in analyzing and optimizing XML blob storage in databases, familiarity with project management tools like JIRA, and experience with OCR tools are essential.

Responsibilities

• 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 Atlassioan 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.