My website is a big data analytics tool, scanning over 100 Million lines of data for every query.
Now I want you to refine my search by adding further SQL commands.
The search is written in Python and based on Elastic Search.
The website is built on Symfony.
THE JOB IN DETAIL:
1. add premade navigation bar and link content
at page bottom, fixed, z-index above all website content link content of search bar
2. add pagination
10 search results per page. Enough pages to show all results. “<” and “>” jump two pages.
3. revise search process
Country Selection
If a country is selected, only show search results of shipments which list that country in
the column “Country”. If USA is selected, show all search results.
words from multiple columns
When searching for multiple words, like for example: “the north face” + “tent”, show all search results that have all words in the columns “Consignee Name”, “Shipper Name” and “Product Desc”. Allow the words to be found in different columns. In the example above “the north face” could be found in “Consignee Name”, and “tent” in “Product Desc”.
4. revise website
delete previous search field. Scale down the height of the top navigation’s background to just underlay the links.
Hello!
I am a python developer.
I looked at your project and it seems interesting.
I have all necessary skills required for this project.
Ping me to discuss in detail.
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience .
Relevant Skills and Experience
1) Sql Server 2005/2008/2012
2) MYSQL, MS Access
3) Oracle (PL/SQL),
4) SSIS, SSRS , SSAS and Power BI
5) Data analytics using R-Programming and SAS
Proposed Milestones
$61 AUD - Complete database design and development