Cancelled

AWS expert / web app developer to create a REST-enabled database and integrate a basic helpdesk app

Summary: I need an AWS expert / web application developer to build an AWS-hosted database with a REST API. It should enable secure access to the database via specific Android apps on the data upload side and an Excel viewer on the reporting side (N.B. you are not expected to build the Android apps nor the Excel viewer). In addition, you should build or integrate a basic web app with a simple UI for "helpdesk" staff to access and manually change the Android user-generated data in the database.

Context: For an NGO in Bangladesh, I am managing a project for which we are creating two Android apps, which dispersed field staff will use to sync sales reports and activities back to a central database. The NGO's managers will be able to access this information through an Excel viewer, as well as receiving alert emails, so that they know what is happening in the field.

More details of the tasks involved:

1. Discuss with me if the following sequence makes sense on AWS, and suggest & explain any changes which you feel will improve or simplify the project. Then, subject to any agreed changes:

2. Open a free-tier Elastic Beanstalk application using my account, with a database and an object-oriented web application framework. (I will create an ID for you to access my AWS account). Alternatively, if you feel there are good reasons to do so, open “micro” instances of EC2 and RDS, and set it all up manually.

3. Create tables in a new database called "xyz_dev", matching example tables that I will have provided to you. Then create a REST service for the “xyz_dev” database, using an existing framework that supports the creation of REST APIs.

4. Deploy standard web-application security and stability/recovery measures (e.g. automated backups & snapshots, load balancing, password policies, encryption keys, firewall, etc. I have zero expertise so we will need to discuss this topic, and I will rely on you to suggest and implement a sensible solution.)

5. Help to trouble-shoot a few SQL scripts. I will write the SQL scripts, but my SQL skills are "rusty" so I may need support for specific issues. Some scripts will create reporting tables (e.g. sales per region per week, number of beneficiaries reached, etc.), and other scripts will verify if specific alert conditions have been triggered (e.g. list field workers who have recorded zero activity during the previous day).

6. Configure SES to send emails to various email addresses when these reports are created and these alerts are triggered. (e.g. notify the relevant manager if one of his/her field workers has recorded zero activity during the previous day; or notify the whole management team when the main reporting tables have been updated, once a week.)

7. Help to trouble-shoot VBA and REST-connection issues for an Excel viewer tool for the managers, which I will have created. (The tool will have drop-down lists, it will pull relevant information from the reporting tables in the database into a hidden worksheet, and it will then manipulate and display this information in appropriate summary tables & graphs.)

8. Create (or integrate an existing open-source) web app which:

o Allows Helpdesk staff to view & change user details, add new products to the database, edit transactions, etc.

o Allows users to change their own passwords, view & change their own transaction data, etc.

o Allows Helpdesk staff to track issues in a Helpdesk issue-tracking app.

9. Work with the Android developer to integrate the syncing of the Android apps to and from the database.

10. Create an updated “xyz_test” version of all of this every two weeks, so that it can be tested by the NGO's internal pilot team, while we continue working on new features & fixing bugs on “xyz_dev”.

11. Towards the end of the project, create a “xyz_prod” production version of this (probably as a "small" instance, not a "micro" any more), so that we can pilot and deploy the system across the organization.

.

Skills: Amazon Web Services, PHP, SQL, Visual Basic for Apps, Web Security

See more: rest enabled, version android, makes good manager need, organization skills, web side create free, web service developer, web security developer, web php developer, web developer ngo, web developer features list, web developer bangladesh, web developer apps, web account manager, vba load, vba access developer, ui reporting, tracking tasks excel, tool php developer, system manager application android, summary web developer, subject need web developer, sql developer open source, skills improve, shoot management, set email android

About the Employer:
( 3 reviews ) Dhaka, Bangladesh

Project ID: #5443114

13 freelancers are bidding on average $904 for this job

zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(160 Reviews)
7.0
Hariomtechnology

Hello, We are one of the best programming team on freelancer. We have more than 95+ Client Reviews (Feedbacks). Please check our profile here: http://www.freelancer.com/u/Hariomtechnology.html. Please see some More

$1237 USD in 15 days
(63 Reviews)
6.8
sveralex

A proposal has not yet been provided

$1300 USD in 30 days
(48 Reviews)
5.6
mmadi

Hi, we will be happy to do that for you. Examples of work: http://www.travelfox.com/ http://www.sdcweb.org/ http://www.dcdouglas.com/ we ready to work with you,kindly waiting for your response.Thank you More

$515 USD in 10 days
(20 Reviews)
5.2
re4ct0r

Let's start .

$2061 USD in 10 days
(7 Reviews)
5.1
gkws

Hello Sir/ Mam, Thanks for posting the project on Freelancer, this project exactly matches with our technical strengths. We have more than 30 plus retail and agency clients and have successfully completed over 100 More

$721 USD in 20 days
(3 Reviews)
3.8
xerobug

hi: i'm an expert in aws as well as web development. I can design and develop an AWS-hosted database with a REST API

$555 USD in 10 days
(3 Reviews)
2.6
allenav

Hello, I'm Senior Software developer and designer. I've over 7 years of experience in analysis, design and development of various websites & web applications.I've worked extensively in PHP, MySQL, Joomla, Wordpre More

$902 USD in 17 days
(2 Reviews)
0.9
nix143

Greetings from Denver, CO! My name is Phil Hendren and I have 10 years experience working in mission critical web apps and website infrastructure. Currently I am employed full time as a Linux Admin for a web operations More

$1111 USD in 10 days
(1 Review)
0.8
webdonejob

If you think I am capable let us talk each other in detail there some of the experience in other area like as PPT2Falsh product it is SDK you can find more about it in this link http://www.conaito.com/ppt2flash_ueberbl More

$700 USD in 14 days
(0 Reviews)
0.0
poojasjt

Hi, I have been working with AWS since 2011, 1. The service is great. 2. The rates are going to kill you. 3. Amazon services are built on top of ec2 virtual servers, and the running cost for 6 months == One t More

$888 USD in 10 days
(0 Reviews)
0.0
rightfreelancer7

I am a professional software engineer with 9+ years of experience. I am very talented programmer with the following skills c, c++ , java , UNIX, Linux,SSH, PHP, Jsp , Js , advanced js like jquery, extjs, AWS etc. My More

$526 USD in 10 days
(0 Reviews)
0.0
ankushkilam

I am an AWS Certified Associate Solution Architect. Certificate Number : AWS-ASA-2*** I am working as an AWS Cloud Consultant providing consulting solutions to clients on AWS, dealing with almost every AWS service m More

$722 USD in 10 days
(0 Reviews)
0.0