Trendz ERP is used by one of the major garment production company, headquartered at Jordan. The technology used is Oracle ADF. It helps to execute, analyse and optimize various business/manufacturing transactions. The application handles the processing of all the activities of the company with a wide support of different modules.
Worked in following modules as PL SQL developer and also developed Jasper reports.
 Order Data Management
 Product Data Management
 Manufacturing Management
 Warehouse Management
 Advanced Shipping
 Finance

Trendz HCM is an angular application which helps to manage the human resource of our client. In Trendz HCM, I had worked in Person, Job assignments and full and final settlement modules.
Technologies Used : Oracle SQL/PLSQL, Tibco Jaspersoft Studio
Roles and Responsibilities :
 Hands on experience in ORACLE DATABASE 11g.
 Solid Experience for implementing DB Scripts, PL SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
 Used bulk collections for better performance and easy retrieval of data by reducing context switching between SQL and PL SQL engines.
 Created various DML and DDL statements using SQL queries.
 Handled errors using Exception handling extensively for the ease of debugging and displaying the error
messages in the application.
 Involved in requirement gathering, analysis, design, development and support.
 Understanding and Collecting requirements from Business user side and tried to convert that business need to
technical queries.
 Extracted data from XML file and generated reports.
 Responsible for Report Development and Design using Tibco Jasper Studio.
 Client support.
 Optimize application code on the basis of requirements from the Line – Of – Business.