Data Mining / SQL processing into Excel Reports
£18-36 GBP / hour
Must be able to travel to/spend time in London
WHAT WE WANT
We currently have four sources of customer sales usage data in .csv files and SQL Databases (Sybase and MYSQL) that requires extraction/import to one centralised marketing campaign database.
We envisage that this will be done by regular running of SQL scripts to export to .csv which will be imported into Excel and displayed in Mysql pivot tables / graphs.
To implement this, we will require someone who is well versed in data mining, including automated import and processing of data and who is able to set up various reporting structures.
What we need from you:
Import/extract data from various different sources (MYSQL, .csv and Sybase) into Excel and displayed in a single database for use on campaigns.
Create a Reporting Database in Excel from the extracted data displayed in pivot tables/graphs.
Ensure that the data is customer related so that we can easily ascertain customer ‘types’ to be included in targeted campaigns.
Create a campaign dashboard: a simple Access system that will integrate with MYSQL or Sybase db (for Sales Tracking and Reporting)
Basic screens and forms for an Access client running on Windows 7
Basic Linux scripting to ensure automated processing of data initiated by a web hit or a cron job.
Automate imports of .csv files and data processing into graphs and pivot tables.
Work in conjunction with a programmer who knows PHP to do event processing from http hits.
Write a simple algorithm to insert data into a relational database.
General reporting :
• Baseline
• General Sales: By dealer, product type, order type
• Dealer activity
• Campaign indication
• Weekly/monthly
REQUIRED SKILL SET
Hard skills:
SQL: MYSQL; Sybase ASA; Importing and exporting .csv files; Data processing with SQL (including complex joins)
Excel, including VBA scripting, automation, graphs and pivot tables
Access – simple form design, integration into Sybase and MYSQL
Linux: Simple cron jobs; File copying
PHP (can be provided internally): Simple web hits to row creation; Initiation of scripts
Soft skills:
Fluent in English
Deadline-driven with excellent timekeeping
Self-managing
Good at presenting numbers
A good grasp of knowledge capture – to produce well designed, technical documentation that will mean something in 12 months’ time.
WHEN APPLYING FOR THIS CONTRACT PLEASE ANSWER THE FOLLOWING:
How much experience do you have with SQL? Which Databases and what level of complexity?
PARAMETERS AND EXPECTATIONS
1. Results
We are able to run targeted marketing campaigns from a relational database.
2. Terms of service
Please provide an hourly rate quote for this contract
An objective of 20-30 hours per month for the initial extraction and test campaign.
3. Delivery time
To be discussed and determined at interview and broken down into estimated time blocks against natural tasks within the original project.
4. Expected communication
Working with our data must take place on site at the offices in Shoreditch (London, Liverpool Street tube/rail)
Working off site will require a regular status report (Agile 'stand-up style) by skype stating: How much time was spent on the project the previous dy and what was accomplished; what is intended for that day; whether the contractor is blocked on anything.
Weekly status meetings on progress - either by conference call with screen sharing or on site.
5. Payment and milestones
Timesheets should be submitted weekly for sign-off together with documented evidence of completed work.
Invoice to be submitted monthly.
6. Testing
We will agree tests as part of the specific deliverables
CREATING LONG-TERM CONTRACTOR RELATIONSHIPS
Our company has an ethos of developing long-term relationships with contractors with whom we have enjoyed working and who deliver on deadline and to spec. Successful completion of this project and the subsequent testing would see you getting regular work for our new venture.
Project ID: #6280423
About the project
27 freelancers are bidding on average £25/hour for this job
Hi sir, My name is Leonardo Medina, and I´m from Brazil. I have lots of experience in PHP. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web D More
Hi, I have done a similar assignment before and would anticipate this would take me little to complete. Please send me a message if interested. Thank you.
Hi, I have gone through your requirements ,I am a DBA at CMMI-5 Level company since August 2008.I am working on Microsoft Access, MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Intere More
I have +10 years of experience of mysql database, built very complex sites like accounting, membership sites.. I also have worked with importing/exporting csv files to database. please let me know anything if you h More
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high More
Hi, I have 3+ years experience in Macro writing and Excel, if you want to see my work i can show you my ongoing automation of excel for project management. Kindly allocate this project to me i will assure you it More
I am a data scientist/quantitative developer with over 5 years of experience doing analysis. My interest and expertise in using R and Database Development.
What you are requesting is ETL (Extract, Transform, and Load) process as well as Reporting function. I am currently doing ETL project for my full time company and have necessary skills to complete this task. As added More