James Allman / JA Technology Solutions LLC
Microsoft and Windows platform development
From C# and .NET application development to Excel and VBA automation, Access databases, SQL Server, and banking integrations — I build and maintain the Microsoft-based tools that business operations and finance departments depend on.
What I Build on Microsoft Platforms
- C#, .NET, and Visual Basic application development
- Microsoft Access database development, optimization, and migration planning
- SQL Server development — queries, stored procedures, schema design, performance tuning
- Excel and VBA automation for reporting, data processing, and business workflows
- Banking integrations — NACHA Positive Pay, ACH automation, bank reconciliation
- Payment gateway integration (Stripe, Authorize.net)
- QuickBooks automation via QB IIF — journal entries, invoices, vendor records, and chart of accounts
- Integration between Microsoft platforms and IBM i, Linux, and cloud systems
Finance and Accounting
Finance departments are often the heaviest users of Microsoft tools. I help with Excel workbooks that have become mission-critical, VBA automation that needs to be more reliable, Access databases that have outgrown their environment, and the banking integrations that connect accounting systems to financial institutions.
For organizations using QuickBooks, I build automated data feeds using QB IIF (Intuit Interchange Format) — journal entries, invoices, bills, vendor records, customer records, and chart of accounts updates. These connect QuickBooks to ERP systems, point of sale platforms, and other operational data sources that generate financial transactions. Even large enterprises often have a QuickBooks installation somewhere that needs to be integrated with the broader financial workflow.
Cross-Platform Integration
Microsoft tools frequently need to exchange data with IBM i systems, Linux-based platforms, and cloud services. Access databases that pull from DB2 for i, Excel automation that generates reports from multiple sources, .NET applications that interface with legacy systems through JDBC, ODBC, or ADO.NET — I work across all of these platforms and understand how they connect.
Free Finance & Windows Dev Tools
Finance teams and Windows developers working with banking files, QuickBooks automation, or SQL Server can use these free browser-based tools for the everyday tasks that come up alongside Excel, Access, and .NET work.
- QuickBooks Explorer — inspect QuickBooks IIF exports for account validation and import prep
- BAI2 File Explorer — parse bank reconciliation statements into readable columns
- NACHA/ACH File Explorer — inspect ACH batch files received from or sent to the bank
- Positive Pay Generator — generate positive pay files from a check register
- SQL Formatter — clean up T-SQL queries into consistently indented SQL
- Connection String Builder — assemble OLEDB, ADO.NET, ODBC, and JDBC connection strings
- Data Profiler — explore Access or Excel data before migrating it to SQL Server
- Regex Tester & Builder — test regular expressions for VBA and .NET
Related Capabilities
Custom Development · Database Development · Reporting & Analytics · System Integration
Further Reading
Microsoft Access, Excel, and VBA — the tools finance teams depend on and when they need professional support.
When Your Spreadsheet Should Have Been a Database — when Excel workbooks need to become professional applications.