Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Job Title: Expert VBA/C# Developer - MS Office Transformation Specialist Location: Remote Duration: 6+ Months Must: Transitioning from MS 2013 to 365 Job Description: Job Title: Expert VBA/C# Developer - MS Office Transformation Specialist 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: 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 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. 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.