Deep understanding of VBA (not .Net) in visual studio
Excellent communication and deep technical experience expected; think a higher level of consultant that can engage with both technical teams and senior stakeholders
I need someone with strong SQL Server and MS Access development skills.
"Go-getter" - entrepreneurial spirit that can quickly pick up on requirements and execute on the task at hand with minimal oversight/hand holding.
Old system keep current
Front end is Access/ Back end is al SQL Server (700 tables). ADO connection.
System 1 to Process a Settlement (settle year end claim (who owes what party $)) - ASO Self funded case. (50 tables structured logically)
System 2 -Bars being replace with Oracle ORMB. Went live 2 years ago and are not continuing to enhance the functionality.16 significant enhancements that need to be updated through 2022.
SQL Server:
· Deep understanding of relational databases
· Able to design tables / views / procedures
· Strong experience with modeling within a relational database
· Strong knowledge and experience working with different types of table joins, UDFs, date handling
· Understanding of complex queries
· MS Access
· Deep understanding of VBA (not .Net) in visual studio, customized ribbons leveraging XML, and dedicated system tables
· Deep understanding of leveraging ADO ( Active Data Objects)
· Experience creating Forms, Queries, Reports
SQL Developer