Find Jobs
Hire Freelancers

2-3 hour Task -> SQL Optimization with excel report Output

$30-250 USD

Cancelled
Posted about 5 years ago

$30-250 USD

Paid on delivery
The time spent on this project needs to be 1-2 hours (3 hours max) and 1 day to complete. If you can't complete the task in this time frame please don't bid If you can do this task and reduce in 50% or more the time it takes to run we are interested in paying you for this task and assigning you new tasks! Just run the sp on your local machine and show us the time it took originally and then run it again after optimization and show the time improvements and we will hire you and pay for the job. We are using this SQL optimization project to evaluate and select experts for our other ongoing projects, this optimization itself is MINIMALLY critical and the most important factor here to find qualified SQL experts who can improve eficiency (time) of the stored procedure to run and improve the output format (to excel with filters, headers etc). We can award you the job and create milestone if you can show us this optimization and then release it once we run the job on our aws and confirm the optimization. Output of this stored procedure should be to excel with some minimal formating (filter and freeze top row, font, and highlight some columns like the exemple excel that we attatched), currently we copy/paste results to excel then manually apply filter and other modifications and we want to avoid this. Some details: We have a mobile phone rental service and we need to audit the phone bill every month from the phone company then we need to recalculate the amounts that we will charge our clients. The stored procedure we are putting below is the primary report generators we use calculate amounts to charge our clients. Currently it takes 45 min to load (on a [login to view URL] aws server) and has never been optimized for speed. 1) We're in the hopes that this can be significantly reduced (1/4 the time or less) with proper optimization. 2) we would like the output to go directly to excel with some modifications (filter/freeze top row, change font size, color columns). Example desired excel output attached Download link for Database backup -> [login to view URL] user -> freelancer password -> freelancer01 Example execute the stored procedure for january 2019 and also extract below: EXEC AudFullClaro_Load 1,2019 -- to load the data EXEC AudFullClaro_Extract 1,2019 -- to extract If you
Project ID: 18904345

About the project

2 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
2 freelancers are bidding on average $155 USD for this job
User Avatar
Hello! I am a software engineer, I have worked on many desktop and web development projects. I am an expert in many programming languages such as JAVA , C#, php, DataBase (Mysql , sqlite, sql). i can also work on Database or Schema Designing Development of Database Database Programing ERD Development Data Flow Diagram Class Diagram Normalization (1nf,2nf,3nf). RDBMS: 1) Mysql 2) Oracle 3) MS SQL 4) Sqlite 5) Access Database looking forward to work with you. please contact me for more discussion. i am waiting for your response. reply me soon Thank You!
$155 USD in 3 days
4.7 (6 reviews)
3.6
3.6
User Avatar
Hi, I have imported the db and trying to tune your sql. I will let you know when I succeed. Can you send an introductory message so I can communicate with you when I am done. I tried it on my computer and execution of 2 function took total of 4 min max. I di dnot change anything. is this test cases are real? Regards Fatih.
$155 USD in 3 days
5.0 (3 reviews)
3.3
3.3

About the client

Flag of BRAZIL
RIO DE JANEIRO, Brazil
5.0
38
Payment method verified
Member since Aug 17, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.