About Me
Highly skilled in Oracle SQL, PL/SQL and Jasper reporting. Proficient in SQL databases and project management software JIRA.
... Show MoreSkills
Programming Language
Web Development
Database
Others
Positions
Portfolio Projects
Company
Trendz ERP
Description
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
Skills
PL/SQLTools
ADFSCompany
Trendz HCM
Description
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.
Skills
OracleTools
jasper Studio