Find Jobs
Hire Freelancers

QUICK 2 hour Task to qualify freelancers for our other tasks -> MS SQL Optimization with excel report Output

$30-250 USD

취소됨
게시됨 약 5년 전

$30-250 USD

제출할때 지불됩니다
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 Currently one of our MS SQL stored Procedures EXEC CobFullClaro_load 1,2019 takes about 50min to complete. If you can reduce this to one half or one quarter the time please contact us as we are using this task as a filter to hire professionals to make fixes and improvements to this and other stored procedures on an ongoing basis. This task in itsself is MINIMALLY critical and ONCE AGAIN SERVES TO FILTER AND FIND PROFESSIONAL TO HIRE ON LONG TERM! We can award you the job and create milestone if you can show us this optimization (print of before after time to run on your machine) and then release milestone once we run the job on our aws server and confirm the optimization. Output of this stored procedure should be to excel with some 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. If you have pivot table/graph experience this helps very much! 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 (does not have desired pivot charts/tables/graphs) Download link for MS SQL 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 Cheers and good luck Marcio
프로젝트 ID: 18906676

프로젝트 정보

4 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
4 이 프로젝트에 프리랜서들의 평균 입찰은 $199 USD입니다.
사용자 아바타
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 4일에
4.9 (23 건의 리뷰)
5.7
5.7
사용자 아바타
I am a financial expert and guru in Excel with over 35 years of experience across different industries. I have the skills to upload databases from SQL server into Excel and generate financial reports and charts. I have extensive knowledge and expertise in advanced formulas, Pivot Tables and Visual Basic Application, including dynamic dashboards, screen layouts (user-forms) and drop-down boxes. Furthermore, I have extensive experience in accounting, bookkeeping and other financial services, so can provide you with the result that incorporates all of the complex business elements in an easy-to-use and logical manner that is optimised for speed.
$250 USD 1일에
4.3 (6 건의 리뷰)
5.3
5.3
사용자 아바타
Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters and Ph.d. programs. 1. Academic writing 2. Article/content/blog writing 3. Product description writing 4. Transcription writing 5. Logo designing 6. Autocad 7. Audio recording/voice recording 8. Picture illustration 9. SQL 10. Web Development and designing 11. Book designing We are honored with a group of experienced online scholarly scholars who have capability in English dialect, alongside assorted subject information of Finance, Marketing, Accounting, Management, Statistics, Human Resources, and Information Technology oour expert writers promise to convey brilliant quality in a manner that you need at most dependable valuing alongside a few different profits and administrations
$222 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (BRAZIL)
RIO DE JANEIRO, Brazil
5.0
35
결제 수단 확인
8월 17, 2010부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.