Job description

Project Overview: We are seeking a skilled Windows-based programmer to develop a solution that automates the creation of Projects within our on-premise Microsoft Dynamics GP environment. The source data resides in a separate SQL Server database, and the integration may be implemented either through direct SQL-based methods or via a standalone VB.NET desktop application running on Windows. This is a short term contract of 1-2 weeks. Objectives: • Extract and transform project data from an external SQL Server database • Insert validated records into Dynamics GP’s Project Accounting tables • Ensure compatibility with GP’s schema, business logic, and referential integrity • Provide a user-friendly interface or script-based utility for repeatable execution • Include logging, error handling, and rollback capabilities Scope of Work: 1. Environment & Data Analysis • Review external SQL Server schema and identify relevant project fields • Map fields to GP’s Project Accounting tables (e.g., , ) • Confirm GP version and database structure 2. Integration Development • Option A: SQL Server–based integration using stored procedures • Option B: Windows desktop application in VB.NET with SQL connectivity 3. Validation & Business Rules • Ensure required fields (Project ID, Customer ID, Start/End Dates) are present • Prevent duplicates and enforce GP constraints • Include audit logging and error reporting 4. Testing & Deployment • Test in a non-production GP environment • Provide deployment instructions and rollback strategy • Document configuration steps and usage Required Skills: • Deep understanding of Microsoft Dynamics GP database schema (on-premise) • Strong proficiency in SQL Server (T-SQL, stored procedures, SSMS) • Experience with VB.NET for Windows desktop applications • Familiarity with GP’s Project Accounting module • Knowledge of Windows Server environments and GP security models Deliverables: • Fully functional integration tool (SQL-based or VB.NET) • Source code and technical documentation • Deployment and rollback instructions • Optional: Test cases or sample data sets Environment Details: • Microsoft Dynamics GP (on-premise) • SQL Server 2012 • Windows Server 2012 • Active Directory authentication (if applicable) Timeline: Estimated duration: 1–2 weeks, depending on scope and chosen implementation method. Job Type: Contract Pay: $48.44 - $58.33 per hour Expected hours: 40 per week Work Location: Remote

Requirements