Assistance with Billing System ETL Shell Scripts

• Project ID:

  771605

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

We need your help in improving & maintaining a couple of shell scripts to process billing data (ETL) from a mysql and create PDF reports (invoices). Script is already done and works fine. It just uses 2 tables. Script along with mysql tables need to be installed in our Ubuntu Server 10.04 LTS.

Here's a list of the possible tasks:
1) Install MySQL 5.1
2) Install Java 6
3) Create a mysql database
4) create mysql user/pw
5) install supplied sql schema
6) Populate the tables from an Internet site and/or supplied CSV file.
7) Find a way to automate the script one of the tables can be automatically loaded from an Internet site
8) Add option to specify date parameters to script
9) Automate the process of running the script on the first of each month and only if the tables have been updated
10) Correct errors in script and find ways of improving/optimizing
11) Provide technical support
12) Come up with a way to execute script remotely via a web service
13) Have script write results to a mysql table and do extensive logging of operations done

Please explain your background, skills, and why you think you'd be a good match for this project. Bid may be negotiable depending on final details. Preference will be given if you have and use a Skype account and are generally available.

Skills required:

Linux, MySQL, Shell Script, System Admin