Migrate Excel client services database into SQL database

Closed

We have excel based databases used to track and manage the services provided to our clients, these have grown to a point they are impractical/unmanageable in Excel.

We would like to have these migrated into a more advanced solution, SQL or similar based with extensive custom reporting and interfaces for data entry and manipulation.

Once developed to a fully functional application that caters to all our requirements we are keen to develop a web based interface for our clients to have greater visibility and where appropriate self manage their services.

Our business model is along the lines of on sale and management of phone/internet services to large companies.

A single client may have from 100 - 3000 individual services active at any time, these services will each be linked to an individual user(employee), users are spread across varying business units and locations within our clients business.

Each service has a monthly charge that will need to be tracked and billed to the cost centre of the associated employee, the charges can vary from month to month and have additions or credits required in varying circumstances. The system developed will need to be able to generate detailed invoicing and reporting on charges.

The system should integrate with user request forms such as New requests(follow an allocation process flow and create new record once established), Cancellations, Faults, change to service requests. etc. It will be desirable to have the system auto generate emails as required in process flows.

Multi-Tenancy design framework required for multi client support. The long term goal is to provide this solution to clients as SAAS

Our focus is to find a very experienced individual or team that can confidently and competently handle this project

Requirements:

- High Availability for rapid development

- Significant Experience in systemising business processes

- Clear English communication

- Comprehension of business practices and processes

- Comprehension of medium complexity in business to business invoicing and crediting

- Ability to provide creative input to improve the automation and function of the solution

Preferred Experience:

- Accounting, Book keeping or financial systems experience

- SAAS development

- Enterprise level database solutions

- General business administration and management (Business Logic)

- Lightswitch and/or Code on Time

At this moment we are reviewing development in LightSwitch, Code on Time, or similar for there ability to allow us to make tweaks in house as required to expedite development and quickly add new reports / functionality in house as required. We are thinking of this as a stage 1 user interface, proof of concept tool, not sure if it will be our long term solution so still open to alternative development paths but experience with these tools is a benefit.

The selected FreeLancer will be provided with a stage 1 project to prove there ability to deliver what we are looking for, the full project will only be awarded if we are happy with the initial solution provided.

We are looking to make a start on this over the Christmas break, availability to start immediately and work on this fulltime through to completion will be preferred. Long term development support is also desirable.

Payment arrangement by negotiation, we would prefer the best than the cheapest. Preference is for agreed cost for delivery of functional solution by stages.

Skills: Accounting, Database Administration, Excel, SQL, User Interface / IA

See more: where to find work as a freelancer, where to find web design clients, where to find freelancer work, where to find clients for web design, where to find a new employee, where to find a freelancer, what to charge as a freelancer, what is time complexity in c, what is time complexity, what is ia, what is cost flow, what is client services, what is business services accounting, what is an ia, what is a long term goal, what ia freelancer, what are data entry forms, what are databases and what are they used for, we provide accounting services, web rapid application development, web development enterprise, web development charges, web design freelancer database, web database development tools, web application development rapid

Project ID: #5269136

34 freelancers are bidding on average $6226 for this job

leadconcept

Kindly ignore the bid amount & time-line, it is just a placeholder, as we still need to analyze your requirements more in depth & discuss with you. -------- Dear Sir, I have read your Project Description and under More

$5154 USD in 60 days
(23 Reviews)
7.8
itgurussoftware

Hello, We would like to confirm our interest in this opportunity. We have developed several end-to-end web apps for our clients in US and Europe, and can share references with our proposal. We've delivered severa More

$6701 USD in 45 days
(60 Reviews)
7.7
hits

You have written: At this moment we are reviewing development in LightSwitch, Code on Time, or similar for there ability to allow us to make tweaks in house as required to expedite development and quickly add new repor More

$5263 USD in 50 days
(198 Reviews)
7.4
RBird

Custom sites, All programming languages and database types. Sites include administrative back end systems. Would love to help you, contact me so we can move forward.

$5263 USD in 20 days
(3 Reviews)
5.4
shanki161

Hi Sir, Good Day We are a team of 4 people(5+years experienced) all working for Tata Consultancy Services. We have been working with Moody's client and developed a similar application for them.We would be waitin More

$5555 USD in 30 days
(24 Reviews)
5.1
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$6111 USD in 30 days
(29 Reviews)
5.1
elboukharimu

Aucune proposition n'a encore été fournie.

$5000 USD in 60 days
(20 Reviews)
5.0
qualifiedcoders

Hi We have read your Requirements and would like to discuss further as we have strong hands in web,desktop & mobile application development & completed over 150 projects in last 5 years. We work in all databases inc More

$5154 USD in 30 days
(2 Reviews)
4.9
feninsoftech

Hi, I have 9 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expe More

$5555 USD in 30 days
(14 Reviews)
5.0
srinichal

I am an expert in delivering custom softwares and tools willing to discuss further about the project specifications

$5263 USD in 30 days
(7 Reviews)
4.9
mrroberto

hi, i can help you. i have all needed experience for do this job with 100% satisfaction from you. if you interested, contact me.

$6315 USD in 28 days
(10 Reviews)
4.5
pablotorres

A proposal has not yet been provided

$5000 USD in 30 days
(20 Reviews)
4.4
shahidbabar

Hi I must say at the start that i am realy excited when i read this project. This type of work really suites me as i had been involved in real complex sql server databases. Currently i am working remotely for an USA c More

$5555 USD in 30 days
(14 Reviews)
4.1
digidreamstech

Dear NPDB, Its Ram from Digital Dreams Technology, India. I have gone through your project requirements for .NET based application development. I am ready to work on this project. We have already developed many More

$5555 USD in 100 days
(4 Reviews)
4.0
ktmfreelancer

Hello there,i can create a SQL database to manage your excel data.I do specialize in wordpress(CMS)/PHP/XHTML/CSS/AJAX/Javascript/ MYSQL/CSS/CSS2/CSS3. My portfolio: - http://www.ktmfreelancer.com I can be availabl More

$5154 USD in 30 days
(6 Reviews)
3.8
jacekphp

Hello, I have familarized with your requirements and decided to place a bid. I am confident we are able to make your application work perfectly from both: technical and aestetic point of view. We have a huge experi More

$15789 USD in 60 days
(1 Review)
3.6
rajafaizan

i am a software engineer and i am professional in my field so that i can do this job perfectly. My skills are that, Microsoft office, adobe Photoshop, website design, logo design, software and hardware understanding ca More

$6172 USD in 25 days
(4 Reviews)
2.6
AliSafder

I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) ,PHP, WordPress, SharePoint, VBA, C, C++ a More

$5000 USD in 30 days
(3 Reviews)
1.9
honeydreams

hi, I am a full time freelancer and specialize in building complex app. From my experience its not advisable to build large business structure as your with automated tools like you suggest . I have worked with l More

$5555 USD in 60 days
(2 Reviews)
1.9
Mohsen6558

Hello we can use SQL Server for windows app or if you need use data on web we can use MySQL ready to start.

$5555 USD in 30 days
(1 Review)
1.1