Remote: SCMAC Excel-to-App Modernization Analyst

TOPSYSIT; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

TOPSYSIT is seeking an experienced Application Systems Analyst / Programmer to modernize the Microsoft Excel-based SCMAC into a user-friendly application. The role focuses on understanding the current SCMAC, evaluating platforms, and creating a robust plan to convert and validate the tool for safe, cross-device use.

You will work with mitigation staff to ensure accurate results, preserve existing business rules, and deliver a production-ready solution with proper documentation and beta testing.

Qualifications

• Strong experience in application development / systems analysis.
• Hands-on experience converting Excel-based tools into applications.
• Strong understanding of Excel formulas, calculations, automation.
• Experience evaluating software platforms.
• Experience with modernization from spreadsheets.
• Data validation and error handling experience.
• Secure, maintainable, adaptable solutions.
• Excellent documentation and stakeholder collaboration.
• Experience with beta testing / UAT and production validation.
• Translate business functionality into an application.

Responsibilities

• Assess and understand the existing Excel-based SCMAC and its functionality.
• Evaluate and compare alternative applications/tools that could replace or improve the current Excel solution.
• Develop a selection matrix and recommend the most appropriate application/platform.
• Convert/adapt the existing SCMAC into the selected application.
• Preserve the existing formulas, calculations, business rules, and outputs.
• Implement a solution that is user-friendly, accurate, adaptable, automated, and robust.
• Build real-time validation/error handling to identify missing or incorrect data.
• Ensure calculations are protected/locked so external users cannot modify internal formulas.
• Support accessibility across computer, phone, and iPad.
• Beta test the new application using project data provided by the client.
• Work closely with business/mitigation staff to validate functionality and expected results.
• Provide written and verbal documentation, evaluation, recommendation, and beta-test results.
• Deliver the final production-ready version of the SCMAC.

Skills

App development

Systems analysis

Excel conversion

Data validation

Documentation

Stakeholder comms

UI design

Tools

Excel

Job description

TOPSYSIT is seeking an experienced Application Systems Analyst / Programmer to modernize the Microsoft Excel-based SCMAC into a user-friendly application. The role focuses on understanding the current SCMAC, evaluating platforms, and creating a robust plan to convert and validate the tool for safe, cross-device use.

You will work with mitigation staff to ensure accurate results, preserve existing business rules, and deliver a production-ready solution with proper documentation and beta testing.