Financial AcquiVision
Custom, Bespoke and Open Source Financial and Management Accounting Software
Custom Business Software, Financial Software and Database Systems. Client
Management, Management Information (MI), Key Performance Indicators (KPIs) and Statistical
Analysis designed for your needs.
Our Software and Database Knowledge and Experience goes as far back as the year
1980. Our Financial and Accountancy Knowledge and Experience goes as far back as
the year 1984.
Business, Accounting and Financial Database Software Design, Consultancy and Management
AcquiVision has been supplying superior Software, Website and Database solutions
since 1994.
Friendly Consultants who will go that extra mile for your business. Our moto
is "Look after your customers and your customers look after you."
We have been in the consulting business since 1994.
Databases we build include Access, SQL Server and MySQL.
We develop software in Visual Basic, Visual C++, .NET, Java, JavaScript, ASP and
VBScript.
Our Software Developers have experience in all types of industry such as Electronics,
Manufacturing, Retail, Accountancy and the Financial Services.
We build software that is scallable from the small single user to the large corporation.
Contact Us
Contact Us if you would like us to build you a software application or help you
develop your own software. You will find that we are priced very competitively.
Experience:
Database Administration
Responsible for the SQL Servers; from day to day administration to building new databases, software systems, stored procedure, stopping / starting services, dts etc. As an example, experience has shown, that when compiling an Access database from the main SQL Server database, it is sometimes quicker to import the tables into Access and then run the queries in Access as opposed to running the queries against the main database. Familiar with Enterprise Manager and Query Analyser.
IT Support
Supporting staff and clients on IT issues has been a significant part of the job. Experience in all operating systems, setting up VPNs, DSNs, firewalls, anti-virus software, Exchange and general networking / office software etc. Has used “eseutil” to repair an Exchange database on an occasion when Exchange had stopped working, when the current log file had been deleted by anti-virus software at the wrong moment. The Server was set up prior to employment.
Uses Active Directory to add users and computers to the network. Keen on monitoring corporate anti-virus systems to make sure the network is always fully protected.
Projects
EDI. Upgraded the EDI (Origo standard messages) system to work within the firewall so that the server could be brought inside. It uses Secure FTP. The old FTP software required all ports above 1024 to be opened in the firewall. Refused to leave those ports open and replaced the FTP software.
Commission Scanning System. The company wanted to scan commission statements into the database. Put together a software system and wrote an application in VB.Net to convert the scanned data into xml so that it could be imported into the database. The system greatly improved the speed of inputting statements.
Management Reports comprising data from the company databases frequently need producing. Wrote queries to pull out the required data.
Website changes are continually needed. Responsibility to modify the website ASP that access the online database, modifying and creating forms and queries etc. Some pages display xml files which are uploaded to the website on a daily basis along with the database.
VB.NET Commission System. Upgraded the commission system software from VB6 to VB.Net. This software processes all new and renewal business and is being rolled out in phases, the first phase being migrating to SQL Server below. The second phase was to replace VB6 source code with VB.Net and Access Reporting with Crystal Reports.
Migrating to SQL Server. Before the upgrade to VB.NET, a requirement was to migrate the databases from Access to SQL Server 2000. This made the database much more stable, removing the need for compact and repairs.
Back Office. Members currently use third party software to enter client details. This new business information is then entered on the Company website by the client. Some software was developed by the company that imported this data, which was exported from the Back Office and sent to the website for confirmation. Upgraded and modified this software such that it pulls the information straight out of the Back Office database and bypasses the website.
Commission Application and database. Before converting to .NET, the main commission software and databases required modifications from time to time.
MDB Database Applications. Every so often, front-end database applications are required. These are either stand-alone or connect to the SQL Server. These MDB applications are quick to apply. However, .NET applications can be just as quick to apply.
|