Responsibilities
Plot Booking & Management System (Dream Garden Accounts)
Installment plans according to client requirement.
Plots Booking
Booking details
Booking cancellation.
Installments cancelation plan.
Plots GRN
Short Installments of clients.
Installment receipts etc.
Asset Monitor Module
Keep track of all existing and new purchased assets.
Manage warehouse where all assets are registered.
Generate report using oracle report builder tool.
Generate alerts about assets when such an item needs to be
repaired or when the warranty is going to expire of that
particular item.
Graphical representation of all assets value according to
departments.
Generate bar code for each item so that on scanning we detail
about every item.
Apply depreciation formula on each item in the warehouse.
Keep track of all assets when an item is returned and when an
item is purchased.
Make an oracle apex form for registered asset requisition.
On month closing generate report how many items are sold and
how many are remaining in warehouse.
Tracking Monitor Module
Call Rest API to fetch real-time data of moving buses
Schedule oracle job for automatic Rest API call using PL/SQL
procedure and save Rest API response in the database.
Decode JSON to filter required data from Rest API data.
Save all records where the driver crossed the predefined speed
limit which is 110 km/h
Generate report according to all over speed violations using
oracle report builder tool.
Forward report to complaint cell to take action against particular
drivers.
After complaint cell remarks about speed, violation saves all
data into a database to generate each driver performance
report.