I am Sheharyar Shakeel and I am a software engineer working on web
applications in Oracle Apex since September 2019 . I started in tech with internship during university.
Plot Booking & Management System (Dream Garden Accounts)
Installment plans according to client requirement.
Installments cancelation plan.
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
Graphical representation of all assets value according to
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
After complaint cell remarks about speed, violation saves all
data into a database to generate each driver performance