Database Programming Jobs

75 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $1,500 - Posted
We are looking for an experienced SQL reporting developer for an initial 1-2 month project with ongoing requests as needed. 1. Create custom SQL Query to pull Quickbooks Data from the following locations in QBs with specific date selection available for all data: a. Balance Sheet b. General Ledger (GL) Balances c. A/R Aging Summary Report d. Profit and Loss Statement Example: SQL Query to extract receivables amount on 1st day of the month from the GL Account “1200 – Accounts Receivable”. Also be able to extract “Ending Total Receivables” amount from the “A/R Aging Summary Report” as of the last day of the month. Import both queries into the Business intelligence software program (BrightGauge) we use for reporting, and be able to use both #’s to create a calculation for the final value to display as a gauge. 2. SQL Query will be input into the BrightGauge (BG) software program, which already has an established and working Datasource connection to our QB’s file, to build a Dataset. The Dataset’s should display field’s for the different data (such as balance, account type, date, etc) from the items listed in 1a – 1d.
Skills: database programming report writing SQL Programming
Fixed-Price - Expert ($$$) - Est. Budget: $300 - Posted
I have data stored in an Excel spreadsheet. This data is collected every night by scraping some rental web sites. This information like rental history, features of the property being rented, total booking days, total revenue collected needs to be displayed on a brower based interface. The user should be able to enter some data like (give me this information for say 3BR rentals) and the information needs to be updated to show information only for 3BR properties for example. Ideally, I would like to store this date in a SQL database. So i would like to get some database expertize as well.
Skills: database programming Java User interface design
Fixed-Price - Intermediate ($$) - Est. Budget: $8,000 - Posted
I am embarking on a new project and hope to be able to find a contractor which is confident enough of working together with me on this project. I need to build a CRM cum POS Solutions for the local F&B Market in Singapore. For reference please take a look at this website http://revelsystems.com.sg/ http://www.raptorpos.com/hospitality/ https://www.lavu.com/ The contractor submitting proposal for this job, needs to be someone familiar with the F&B market, And also very familiar with how the Point of Sales works. what is X report, what is Z report, what is gross sales, what it net sales, what is net profit. Needs to have done something similar before and have enough resources for the job. needs to know what a POS in a restaurant needs to have, for example, spilt bills, merge table, table management, reservation, etc... You need to do up everything from scratch explore into communications between the devices etc. and also work on documentation and products guide, user guide etc. I am looking at release to market by end of Q3 of 2016 which is September. Draft out a detailed workflow on how the equipment communicate with one another and also explore into working with both Android and IOS devices. and also not to forget, provide remote support. Also i would like to highlight that this project if it does get started, it will be on going, meaning i would require you to have resources to continue the project on monthly basis as in resolving bugs adding enhancement working on special requirement from customers. integration with other vendors and malls FTP uploading of Sales Data requirement The F&B Solutions i am working towards needs to be a smart solutions for the F&B Industry, enabling them to save on manpower and up the productivity The POS Frontend needs to works with IOS Ipad and also any receipt printers available on the market. http://www.starmicronics.co.th/products-list.php?gid=5 http://www.starmicronics.co.th/products-list.php?gid=6 http://www.epson.com.sg/epson_singapore/retail_solutions/printers/receipt_printing.page The brief scope of this project, is. in a restaurant whereby manpower is little, everyone needs to be informed of the orders and what to do, our products is to help them to be efficient and productivity. Scope, A customer walk into this restaurant with our technology. the waiter goes up to him with an Ipad. we called this the waiter e-menu. Takes down his order and once done immediately the orders goes to the Kitchen. showing the orders that is placed. on both the printer and also the kitchen KDS ( Kitchen Display Solutions) ( Ipad Pro or Android ) and if there is drinks the drinks order will appear on the Drinks KDS We also must cater for amendments of orders, be it increase or decrease or cancellation after the initial order is done. Once the food is done, on the Kitchen, the chef press on the screen done button. the waiter on the front restaurant carrying a Smart Watch ( IOS or Android) will be notified and he will know from the screen that what is the food ready and to which table it is to be sent to. so he will then proceed to the kitchen to take the food and send it to the table. There is another scenario to this. Customer walk into the Restaurant, there is only one service crew and he is tied down. he show the customer to the table, Take out the Customer E-menu Ipad, punch in a security code, and then punch in the table number of that table and pass the ipad to the customer, customer then will proceed to explore the menu and place the order themselves, once done they can view their cart as in what they ordered and what is the final pricing they will be expected to pay. if they are ok with the order, they press on the send order and the orders will be sent to the respective KDS and printers. On the backend, reporting and administration must be solid. Reports in charts for sales figure etc. also module for COG ( Cost of Goods ) down to the ingredient level. and i would need the reports and all details sync to a cloud server so that managers and bosses will have accurate report at any point of time using their mobile phone etc. There is still a lot more to write out, but i will save that when i found someone that is confident on embarking on this project together with me. thanks.
Skills: database programming Android App Development ASP.NET CRM