• Job Description

  Req#: JPC - 10176251

  Hello,

  Hope you are doing well.

  Please find below job description and let me know your availability.

  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.

  Thanks & Regards

  Godha

  Desk: 614 495 9222 – Ext: 315/ Mobile : 570 252 1290

  E-mail: Godhadevi.k@usgrpinc.com

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice