Categories : All, Media and Entertainment
The purpose of this application is to help the client to track revenues at each of his casino centre located in geographically diverse areas. The application is a centralized system for calculating revenue generated through each activity in the casinos.
Client already possessed a domain with Google. He developed using Google App Engine and to be authentication to hosting and report generation, throughout the system. The application users are as demanded a Google-centric application to be hosted on Google Cloud SQL. From user Google technologies are used successfully below:
Admin: The Admin type of user’s will create role and assign access to each role. They will manage and keep an eye on the activities carried out throughout the system.
Input provider: Input providers are basically those users who have the authority to track the revenues at each casino centre. Users can choose the centre for which they wish to add information and proceed to fill in details in the required fields. Each field is programmed (assigned calculations) to yield a right output.
Report viewers: This group of users can only view the reports based on the data provided by the input providers. The system also allows choosing from a varied report types.
The application is comprehensive as it stores the details about every property (casino centre) and games played in each casino. The games are well defined, categorized and calculations are applied to each category. The category has a revenue type and each revenue type has a different formula for calculation. The application is made scalable which means Admin can add more games to a particular centre, categorize them and can also activate and deactivate the games in the centre. The non-functioning games are deactivated for a particular day or record.
The system by default allows input entry to be done only for last three days and then auto-locks the database for entries for days earlier than three from present.
The application allows auto-report generation as well and while generating report the data is used from the application while the actual report generation is performed through Google Drive.
|Operating System & Server Management||Red Hat Linux, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance|
|Development Tools & Environments||JSP Servlet, Google Apps Script, Google App Engine, Google Cloud SQL, Google Spreadsheet, Google Drive API, Apache POI, AJAX, HTML, CSS etc.|
|Database||MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Scheduler for Backups|
The site offered a centralized access to multiple users. Developed using robust architecture the system allowed personalization to the users. Customizable viewing options were designed to enhance the user experience. Access control and other security measures were applied. The entire application was reliant on varied Google technologies and was built according to the latest standards.
The web application was developed keeping in mind the SEO activities for the site. For timely delivery of the solution, Google App Engine was used. The system made use of Google POI for reading excels files as well as Google spreadsheet and Google Drive was used for reporting purpose. Web usability guidelines were strictly followed during development and the interface was made easily navigable through judicious use of HTML and CSS controls. The site was developed and fully functional within a span of 1 month.