İptal Edildi

We are Paying for this project - its not a "free" request - Task to Select capable developers for long term support -> SQL Optimization with excel report output

We have posted this job previously and recruited one qualified professional. We're now looking for a 2nd to keep two on the project.

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 optimize our stored procedure to run in one half to one quarter the time it currently takes and are able to output to excel with the minor reporting modifications below please submit your bid for the number of hours you took to do the work and we will create the milestone and free it upon confirmation that it is working as required. After this we will post for you our jobs for long term development.

We are using this SQL optimization project to evaluate and select experts for our other ongoing projects, this optimization itself is MINIMALLY critical (we use it 1 time a month and waiting 50 min is not a problem) and the most important factor here to find qualified SQL experts who can improve eficiency (time ) the stored procedure takes 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 50 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/2 to 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 CobFullClaro_Load 1,2019 -- to load the data

EXEC CobFullClaro_Extract 1,2019 -- to extract

Beceriler: Veri Tabanı Yönetimi, Veritabanı Programlama, Excel Macros, Excel VBA, Microsoft SQL Server

Daha fazlasını gör: import excel sheet sql data base, access convert report excel vba, 2005 crystal report excel, database design problems and solutions, common errors in database design, sql developer, database table design best practices, a consequence of bad design in dbms, good database design principles, example of a very poorly implemented database, bad database design examples, vba macro generate report excel word, steps develop d2k report excel output, vba code generate report excel, excel programming sql, php report excel sheet, design report excel 10g, php report excel, workshop profitability efficiency report excel, microsoft excel heidi sql database

İşveren Hakkında:
( 35 değerlendirme ) RIO DE JANEIRO, Brazil

Proje NO: #18917115

Bu iş için 7 freelancer ortalamada $193 teklif veriyor

schoudhary1553

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. Daha Fazla

$250 USD in 3 gün içinde
(23 Değerlendirme)
5.7
supergana

Hi - I spent a couple of hours on this and these are the things i did. I timeboxed my effort to 2 hours. - Downloaded and extracted your database into my local instance (worked fine) - Ran the stored proc CobFullCla Daha Fazla

$98 USD in 3 gün içinde
(11 Değerlendirme)
3.9
DevDataAnalyst

I am a highly skilled professional in Sql server and delivering ETL and BI solutions to leading organizations in the world. I have excellent querying skill and performance tuning. Get back to me in case you need furthe Daha Fazla

$222 USD in 3 gün içinde
(1 Yorum)
1.8
nataliaomelchenk

Hi. I am a full time developer and have high skills in web develop by PHP & MySQL. So I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll provide best service.

$155 USD in 3 gün içinde
(1 Yorum)
0.8
jinankthakker

Hi there I have gone through your job description in detail and trust me, I am proficiently able to work on your this optimization task. I am having more than 7 years of experience in Web development with SQL, D Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
vw1415275vw

The main issue with performance is the underlying tables. Are you open to adding columns and indexes? On my entry-level server I executed one block of code from the original CobFullClaro_Load stored procedure and abo Daha Fazla

$222 USD in 3 gün içinde
(0 Değerlendirme)
0.0
CitachiTech

Hi, How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data Daha Fazla

$250 USD in 3 gün içinde
(0 Değerlendirme)
0.0