MS Access/SQL Server Guru level developer with ERP Experience
Looking for a MVP level MS Access developer to work on an ERP program under current development and active deployment, for a light manufacturer/wholesaler.
We are developing a custom ERP package for a light manufacturer which is growing at a rapid pace.
The package is being deployed in stages, with the Purchases/Sales/Stock module already live.
The system architecture is built around SQL Server 21012 back end (utilizing some 2012 specific features), with all C(R)UD data processing done on the BE exclusively via stored procedures. Users only have read/execute access to relevant schemas.
The database is fairly complex with approximately 170 tables and around 500 stored procedures and 33 views Though many sp are simple crud sp.
The Access Front End has 130 forms and 150 or so pass through queries which are really similar to Views.
MS Access is being used as a FE RAD tool in a highly customized manner. Once the system will be fully developed (probably six months +, we will start migration to ASP.NET although we will probably run in parallel for a while after that).
All forms and sub-forms are sub-classed. There are no linked tables and only ADO or pass through queries are used to connect to the BE. Connection to SQL Server is highly optimized to minimize unnecessary traffic.
We are using role based security which is tied into the program forms. There is a highly detailed and tailorable audit system being used in the SQL Server back end.
The system consists of the following modules:
PURCHASES (PO, Inventory Reception,Billing, Bill Payments,Credit Memos)
SALES (Estimates, Sales Orders,Shipping,Invoicing, Invoice Payments, Credit Memos)
STOCK (Items and Item groups, Lots, UOM etc.)
PAYROLL (Actual payroll calculations are done in Quickbooks, with code to automatically import/export data to Quickbooks via QBXML.
LOANS (Borrowers/Lenders/Loan Receptions/Payments etc.)
ACCT Bank Accounts, Credit Card Accounts, and Credit Card Payments etc. We are ready to integrate a GL (we have the all the stored procedures for it ready, but are holding off with actual deployment)
MANUFACTURING This module is being currently worked on
Developer will be working under my guidance and in conjunction with another Access developer currently working on aspects of the project. I also have a .NET programmer who does daily testing and is developing html help for the system.
Developer will either be able to display guru level mastery of MS Access, or similar level mastery in another front end such as VB.NET/ ASP.NET and expert level skills in MS Access.
Extensive experience with SQL Server and writing Transact-SQL (triggers, sp etc.)
Experience in the past on working on light ERP type packages that had Sales/Purchases and Inventory control is a big plus.
Proven ability to work independently with minimal supervision & the capacity to write clear concise English, to think creatively and take initiative.
Experience with developing large databases.
I require a developer a skill-set in the top 10%. I have interviewed many applicants previously for this position in the earlier development stages and was not satisfied with their skills. Please only apply if you are confident you have the skills required.
Fluent English speakers only, and I mean completely fluent.
No agency contractors please.