Omair Siddiqui

Develops, enhances, debugs, supports, maintains and tests Visionsoft’s ERP Product TIJARAT. Day to day tasks involved working on Stored Procedures, Functions, Triggers, Ref Cursors, Bulk Data, Dynamic SQL, Shell Scripting & Batch processing, performance tuning of SQL queries, Import/export, Oracle Forms/Reports. Working on Agile Framework.

Developed, tested & implemented Profit Processing System (PPS). Written PL/SQL code for making disbursement batches and profit disbursement in customers account, Funds Allocation for Profit Processing, Marking & Un-Marking of Dormant Accounts while Profit disbursement. Worked on Stored Procedures, Functions, Ref Cursors, Triggers, Shell Scripting, Datapump, tuning sql queries, unit testing of Profit batches, Bulk loading of excel data in oracle database.

Worked as a freelancer for ITL. Developed, tested and implemented Supply Chain & HR Module. Day to day tasks were writing PL/SQL procedures, Functions, Triggers and Dynamic SQL queries.

Developed, unit testing and implemented ERP System for Protech Network. Written stored procedures, Functions, database Triggers, batch Processing, Bulk collect, Dynamic SQL, Shell Scripting, import/export using datapump.

Worked on Oracle forms/reports, written Pl/SQL procedures, Functions and Triggers, Matrix reports, used temporary tables for report Processing, tune existing sql queries, used object & pl/sql libraries for standardisation of product.