Find Jobs
Hire Freelancers

SQL code to allocate trade awards between traders

$30-250 USD

Ukończony
Opublikowano ponad 5 lat temu

$30-250 USD

Płatne przy odbiorze
I work for an electricity trading company. We make lots of trades each hour of each day. Multiple traders submit bids and offers into the database. The central electricity organization then awards these bids and offers in aggregate. So using the pricing with our bids and offers, we need a way to allocate these aggregated awards to the trades that cleared. Complicating matters is that sometimes the awards do not always match what would make sense based on our bids and offers pricing. So we need a way to allocate these non-standard awards. We have a PostgreSQL database. The attached files give the table structures and a document with further background and the non-standard scenario examples. There are also some excel files with actual data.
Identyfikator projektu: 18344413

Informację o projekcie

9 ofert
Zdalny projekt
Aktywny 5 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
Hello, Thank you for describing the task in great detail as well as providing table structures, data and logic. I am a veteran (25+ years) database developer with real industry experience in Oracle (v6 thru v12c), PostGres (v7.x thru v9.x), MySQL (v4.x thru 8.x) and SQL Server (v7 thru v17). Over these years, I have authored several thousands of lines of SQL and procedural SQL. Long story short, after reviewing all the attached files it looks like you need an efficient stored procedure. I will be able to turn this around very quickly for you. Please do mention your PG version - just so that I do end up using features not available in your version. I look forward to hearing from you. Best Regards Kashi
$150 USD w 7 dni
5,0 (11 opinii)
4,7
4,7
9 freelancerzy składają oferty o średniej wysokości $209 USD dla tej pracy
Awatar Użytkownika
Hello, Hope you are doing well. I can help with you in your project SQL code to allocate trade awards between traders. I can assure you the quality job. I have good experience in Database Programming, PostgreSQL, SQL. We have worked on several similar projects before! We have worked on 425+ Projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. Thanks,
$250 USD w 3 dni
5,0 (10 opinii)
5,4
5,4
Awatar Użytkownika
SQL code to allocate trade awards between traders I am an expert web programmer with 7+ years’ experience in latest web development technologies. please send me message to discuss more
$155 USD w 3 dni
5,0 (13 opinii)
5,2
5,2
Awatar Użytkownika
Hi, Greeting for the day. I can deliver you this project with the best premium design of your choice in the mention time. Let's Discuss. I am expert in doing in database tasks, as I have experience of 4 years in MySql development and NoSql databases and ERP level projects, so I know how to handle complex database tasks. I would like to do your job at lowest rate as I am new to upwork and wanted to do this job only for stars. It would be my first job, I will only expecting rating from you. I can do this job in just 1-2 days or as soon as possible. I will be thankful to you, if you award this job to me. Will looking forward to work with you. As a gift I will give you any choice of premium template from theme forest for free. Your choice template I will use in site with no purchasing required.
$30 USD w 7 dni
5,0 (7 opinii)
3,8
3,8
Awatar Użytkownika
Hi how are you ? I hope you are well, I am very interested in your project, I consider myself the right person since I have more than two years of experience in postgresql I have developed databases with more than 50 tables, with the necessary relationships, indexes, sequences, stored procedures , views, triggers, validations, both here on this platform and in my country, you can test my experience and my knowledge, I have enough time to carry out your project, any questions you have you can ask I am always attentive and I answer all the messages.
$200 USD w 10 dni
4,6 (5 opinii)
3,2
3,2
Awatar Użytkownika
Hi, I have several years of experience with SQL work and would be happy to help you with your project. I am very excited about this opportunity and feel that I would be an excellent fit. As always I provide top quality work to ensure my clients are very satisfied with the results. Please contact me if you would like to discuss further. Thank you and I look forward to hearing from you. William Wenger
$250 USD w 5 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga UNITED STATES
Tampa, United States
5,0
5
Zweryfikowana metoda płatności
Członek od mar 9, 2018

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.