Closed

Database creation and conversion with billing feed into AS400

We are a transportation fleet management company, specializing in cleaning and maintaining transportation vessels. We currently maintain a database in Access and produce reports out of Access in regard to work and services performed. The process is very manual. From these reports, we manually complete billing report cards (BRC) per the customer's specifications (very detailed Excel spreadsheets detailing services performed and parts used). We then forward these BRC's to the customer for entry into their AS400 system for payment.

Our goals:

1.) build a new database possibly using SQL or use the current Access version

2.) produce reports and bills directly from the database

3.) create the patch from our reporting to the AS400 billing schema

4.) allow for future customization

5.) possibly add a bar code feature to the system to eliminate field paperwork and additional data entry on the front end

Skills: AS400 & iSeries, Database Administration, Intuit QuickBooks, Microsoft Access, SQL

See more: sql data conversion, reporting services sql, parts database access, microsoft excel management, microsoft access parts database, front end reporting, fleet management database, fleet management access database, data entry as400, data conversion sql, conversion services, cleaning services company, billing microsoft, BILLING DATA ENTRY, access parts database, access database services, as400 billing schema, microsoft sql reporting services, microsoft spreadsheets, as400 sql, excel database data entry and management, customer database in excel, fleet management system, create a patch, code with new feature

About the Employer:
( 0 reviews ) United States

Project ID: #4301407

24 freelancers are bidding on average $2464 for this job

fastudiovw

I have 20+ years of experience programming ms-access, .net & sql server At your disposal for any doubt or question, Regards Fabio

$2800 USD in 45 days
(654 Reviews)
7.3
jhaynes75

Professional software developer with over 13 years experience. Please see PM.

$3000 USD in 30 days
(29 Reviews)
6.1
Premshanks

Hi, This is my proposal Step - 1 ---- talk to you in terms of what is the current system & analyse your requirements in details Step 2 - design & create prototype Step 3 - create a draft working version fo More

$1500 USD in 20 days
(205 Reviews)
6.1
norberto108vw

Hi, I would like to help you on this job. Regards, Norberto

$3000 USD in 30 days
(5 Reviews)
4.4
jeanek

Good day. I am a database expert with a UK BSc. Computing degree, and over eight years of professional IT work experience. Please refer to my private message for further information regarding my bid. Thank you. Kind re More

$2000 USD in 45 days
(3 Reviews)
3.4
MarlinSoftware

Hello, I have developed an integrated accounting and stock control system, of which many elements could be used within this project, including barcode printing. It would need to be split into two databases, one to hold More

$2000 USD in 60 days
(2 Reviews)
3.1
oplalchandani

I am an expert in this area wit more that 10 years of experience in critical DB migrations

$3000 USD in 30 days
(2 Reviews)
3.0
Varun1981

Hi Sir, Please allow me to work with you on this project. Please check my personal message for more detailed proposal . Regards Varun sharma

$1500 USD in 25 days
(6 Reviews)
2.8
RedhopIT

Dear, Please check PM

$5000 USD in 40 days
(1 Review)
1.4
kamtrivedi

Hi! There, I have 20+ yrs. experience in Software Development using Microsoft technologies. I can complete this job with your full satisfaction.

$3000 USD in 30 days
(1 Review)
0.2
RAVIVERMA2013

I have 9 + Years of Experience in Handling SQL server databases and 6 + years of expertise in doing the Extract , Transform and Load ( ETL ) the Data using SQL server 2005 and 2008 R2. I am having huge ETL Experience More

$3000 USD in 45 days
(0 Reviews)
0.0
qualifiedcoders

Hi We are interested in your project and read your requirements.We have completed 150+ big projects in last 5 years. Please check private message board for details.

$2450 USD in 18 days
(0 Reviews)
0.0
ajayparkar

Hi , I have a strong Telecom Billing domain exposure with product based on ORACLE DATABASE. WILL HELP YOU ON THE TIMELY AND QUALITY DELIVERY OF THIS PROJECT.

$2000 USD in 60 days
(0 Reviews)
0.0
surendraan

Hi, I would like express my interest to work on this project. I have around 8 years of experience in AS400 database design and programming, have greate exposure in extracting and inserting data from and to AS400. More

$2000 USD in 30 days
(0 Reviews)
0.0
Atechysystems

We have done many migration projects from microsoft tech to I-series. We may need remote access to AS400 server. For details please send me details of the projects. We can start the project instantenously.

$1500 USD in 10 days
(0 Reviews)
0.0
vw8168926vw

every thing in programming is easy to me . Depending on project size ; it may need some time but work is always done in a fast and reliable mode. I have done many project integrating AS400(DB2/400)-as backend-with More

$2900 USD in 5 days
(0 Reviews)
0.0
rmahbub1967

I have developed databases for wide range of industries. I have used, as tools like- Access, SQL, DB2/400.

$2999 USD in 30 days
(0 Reviews)
0.0
JohnStephen

Hi there Matt! My name is Stephen, and I'm a 27-year-old resident of Phoenix, Arizona. I'd love to work with you on this project. Take a look at my private message for a detailed response based on your project requir More

$1875 USD in 35 days
(0 Reviews)
0.0
getveltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$2500 USD in 25 days
(0 Reviews)
0.0
MaanKB

I have 12 years experience with MS Access I am able to do it We can start now

$1800 USD in 10 days
(0 Reviews)
0.0