Minisoft Technologies LLC
Job Title: Senior VBA Developer
Location: Tampa, FL (Hybrid)--local
Duration: 6+ months
Interview: Phone/ Skype-2Rounds
Visa: USC, H4-EAD
LinkedIn Must have
Experience: 10+
Job Description: Role Overview Were seeking a handon Senior VBA Developer with deep TSQL expertise and the ability to read and write MS Access 2003/VBA. Youll reverseengineer and stabilize the legacy SnapShot application, design and build modern SQLcentric data flows, and implement integrations that connect the current Access front end (onprem) + SQL Server back end ERP with the Infor system. The nearterm focus is delivering the first integration, followed by a broader modernization program (S4 migration to follow).
REQUIRED SKILLS What Youll Do Reverseengineer, read, and author MS Access 2003/VBA code; untangle ~100k lines of legacy logic to document workflows and stabilize critical functions. Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into SnapShot) to support modernized processing. Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); automate validation and reconciliation. Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem. Maintain onprem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity. Establish coding standards, version control, and technical documentation for legacy and modern components; implement unit/integration test harnesses. Partner with business (estimators, dealers) to map legacy rules to modern data structures; convert tribal knowledge into testable specifications. Prepare for the S4 migration (start-to-finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets. Drive secure handling of ERP data (authentication, rolebased access, auditing), and plan for multiyear onprem operation before any cloud move.
Thanks & Regards, Jennifer |Sr Technical Recruiter Minisoft Technologies LLC 832-301-9876|
jennifer@minisofttech.com
Job Description: Role Overview Were seeking a handon Senior VBA Developer with deep TSQL expertise and the ability to read and write MS Access 2003/VBA. Youll reverseengineer and stabilize the legacy SnapShot application, design and build modern SQLcentric data flows, and implement integrations that connect the current Access front end (onprem) + SQL Server back end ERP with the Infor system. The nearterm focus is delivering the first integration, followed by a broader modernization program (S4 migration to follow).
REQUIRED SKILLS What Youll Do Reverseengineer, read, and author MS Access 2003/VBA code; untangle ~100k lines of legacy logic to document workflows and stabilize critical functions. Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into SnapShot) to support modernized processing. Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); automate validation and reconciliation. Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem. Maintain onprem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity. Establish coding standards, version control, and technical documentation for legacy and modern components; implement unit/integration test harnesses. Partner with business (estimators, dealers) to map legacy rules to modern data structures; convert tribal knowledge into testable specifications. Prepare for the S4 migration (start-to-finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets. Drive secure handling of ERP data (authentication, rolebased access, auditing), and plan for multiyear onprem operation before any cloud move.
Thanks & Regards, Jennifer |Sr Technical Recruiter Minisoft Technologies LLC 832-301-9876|
jennifer@minisofttech.com