Find Jobs
Hire Freelancers

SQL Optimization with excel report output

$30-250 USD

Zrušeno
Zveřejněno přibližně před 5 roky

$30-250 USD

Zaplaceno při doručení
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
IČ projektu: 18904220

O projektu

7 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
7 freelanceři nabízejí v průměru $150 USD za tuto práci
Avatar uživatele
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$250 USD v 4 dnech
4,9 (27 recenze)
5,9
5,9
Avatar uživatele
Hello, I am Oracle certified professional java programmer and have Bsc.IT. I work as oracle EBS techno functional consultant and used to develop many complex quires, packages so I might able to help you. Please provide more details. Thank you. NOTE : Please provide read only credentials with proper access to database, as it would take time to configure this locally.
$200 USD v 1 dni
5,0 (5 recenze)
3,2
3,2
Avatar uživatele
Hello, I can help you with this project, please send me a message (just to know if it is still open) and I will start working on it inmediately.
$111 USD v 1 dni
5,0 (6 recenze)
2,8
2,8
Avatar uživatele
Hello, I have read the project details you need Optimized SQL with excel report output can do the job please contact me on chat for discussion. thanks
$155 USD v 3 dnech
0,0 (1 recenze)
0,0
0,0

O klientovi

Pochází z BRAZIL
RIO DE JANEIRO, Brazil
5,0
43
Ověřená platební metoda
Členem od srp 17, 2010

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.