System Programmer for MS Access to ERPNext Migration

please read carefully so we don’t waste each others time. Here are targeted qualifications for a Business Systems Analyst / Technical Liaison role focused on migrating a legacy MS Access application to ERPNext. Since your programmer will act as the bridge between your business logic and an external customization team, the profile differs from a pure developer. Suggested Job Title Business Systems Analyst – MS Access to ERPNext Migration (or: ERP Migration Specialist / Technical Business Analyst) Core Responsibilities to List 1. Reverse-engineer existing MS Access application logic, workflows, forms, reports, and VBA modules. 2. Document business requirements, data mapping, and gap analysis for external ERPNext developers. 3. Translate manufacturing/sales business processes into structured user stories and functional specs. 4. Validate and test third-party customizations against original MS Access functionality. 5. Coordinate data migration strategy (tables, relationships, historical records). 6. Act as the single point of contact between your operations team and the external ERPNext customization vendor. Required Qualifications Category Specifics MS Access Deep Dive 5+ years with MS Access including linked tables, complex queries, VBA macros, and form/report design. Must be able to read and interpret legacy code without documentation. ERP/ERPNext Exposure Hands-on experience with ERPNext. Must understand core modules: Sales, Inventory, Manufacturing (MRP), Purchasing, and Accounting. Business Analysis Proven track record writing functional requirements, process flow diagrams, and data mapping documents. Experience with BPMN or UML is a plus. Data Migration Experience planning migrations from relational databases (Access/Jet, SQL Server, or PostgreSQL) into ERP systems. Understanding of ETL concepts. Manufacturing/Sales Domain Prior work in a make-to-order or light manufacturing environment with sales workflows, BOMs, routing, and inventory management. Communication Ability to interview non-technical staff and convert tribal knowledge into technical specs that offshore/external developers can execute without ambiguity. Preferred / Nice-to-Have • ERPNext Technical Knowledge: Basic understanding of ERPNext’s Python framework, XML views, and module structure. They don’t need to write custom modules, but must know what is feasible to ask for. • SQL Proficiency: Advanced T-SQL or PostgreSQL skills to extract and sanitize legacy data. • Project Management: Familiarity with Agile/Scrum or ERP implementation methodologies (e.g., phased rollout vs. big-bang). • Accounting/Finance Basics: Understanding of GL, AP, AR, and cost accounting to ensure financial data integrity during migration. Red Flags to Avoid • Pure ERPNext developers who have never touched MS Access (they won’t understand your legacy logic). • Generic “ERP consultants” with no hands-on Access or database experience. • Candidates who cannot explain how they would document a complex VBA-driven workflow for an external developer. Sample Ad Snippet Business Systems Analyst – MS Access to ERPNext Migration We are a [sales/manufacturing] company seeking a technical business analyst to lead the migration of our legacy MS Access application to ERPNext. You will not be writing ERPNext code; instead, you will partner with an external ERPNext development team to ensure our 20+ years of business logic, workflows, and data are accurately translated. What You’ll Do: - Audit our existing MS Access application (tables, queries, VBA, reports) to map current-state business processes. - Write detailed functional specifications and data migration plans for external ERPNext developers. - Validate delivered customizations against legacy functionality and business rules. Must-Have: - Expert-level MS Access (tables, relationships, VBA, complex queries). - Direct experience with ERPNext ERP (Sales, Inventory, Manufacturing modules). - Strong technical writing and requirements documentation skills. - Background in manufacturing/sales operations.