Data Mining / SQL processing into Excel Reports

Cancelled Posted Aug 5, 2014 Paid on delivery
Cancelled

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.

Excel Linux Microsoft Access MySQL SQL

Project ID: #6280423

About the project

27 proposals Remote project Active Aug 21, 2014

27 freelancers are bidding on average £25/hour for this job

kchg

Hi,sir I am glad to find your project. I am web developer with good HTML and PHP, MySQL skills. Now My ranking is top 8 in freelancer. So I think you may not worry about the project. Please check my portfolio carefull More

£30 GBP / hour
(94 Reviews)
7.1
fhasanbd

A proposal has not yet been provided

£28 GBP / hour
(84 Reviews)
6.1
leomedina01

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

£20 GBP / hour
(63 Reviews)
6.0
pablotorres

La propuesta todavía no ha sido proveída

£30 GBP / hour
(75 Reviews)
5.5
steven6

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.

£35 GBP / hour
(20 Reviews)
5.5
acronymsolutions

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

£30 GBP / hour
(18 Reviews)
4.8
SergeScz

Hello. Here are the answers : I have lot of experience with Relational databases and Data mining. I had worked with MySQL (DB Design, reporting data import / export ), MSSQL (2008 R2 mostly, Data processing, working More

£20 GBP / hour
(4 Reviews)
4.4
miraclesolution

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

£25 GBP / hour
(11 Reviews)
4.2
toxicman

A proposal has not yet been provided

£18 GBP / hour
(17 Reviews)
4.1
anomanpk

Hi, I am very much interested in your project. I am in IT profession for more than seven Years. I have done a lot of projects in different languages and databases. Recently, i developed a bid Financial Applicatio More

£30 GBP / hour
(3 Reviews)
3.5
MasterExcel

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

£18 GBP / hour
(11 Reviews)
3.2
Mufaddalsaifee

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

£18 GBP / hour
(11 Reviews)
3.1
pnjadhav

I have total 13 years of experience in IT which include both software development and web development. I have great experience in managing projects with USA/UK based clients and I manage my work shift timing as per cli More

£30 GBP / hour
(1 Review)
3.0
swarm22

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.

£18 GBP / hour
(4 Reviews)
2.9
vivasaayi

I have previously worked on data mining and so I can hopefully get you the results which you are expecting out of your database. I have good experience in Programming in .Net and Sql Server. I also have worked with More

£24 GBP / hour
(3 Reviews)
2.0
grashmi13

I have 10 years of experience in Java/J2EE enterprise web applications development. We are team of 2 members and second member has 3 years of exp in web application development. We have sound hands on in web applica More

£18 GBP / hour
(0 Reviews)
0.0
julianojhema

Ainda não foi fornecida uma proposta

£30 GBP / hour
(0 Reviews)
0.0
ivantyhoncha

Предложение еще не подано

£30 GBP / hour
(0 Reviews)
0.0
Jethrey

Good day, I am a programmer in an outsourced company w/c focuses in data mining, marketing strategies & campaign executions. Most of the automation i've done is in data mining. Those companies are big pharma in Canada/ More

£18 GBP / hour
(0 Reviews)
0.0
freelancejw

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

£30 GBP / hour
(0 Reviews)
0.0