Project -1, Project Title: Migration of QBill Application from forms Application to ADF, Client Name: Qualitynet, Role: Full Stack Developer., Technologies: ADF 12c, XML Publisher, Duration: 2019-03 to 2019-12, Description: QBill is an in-house developed application which covers sales, inventory, CRM modules. It was developed in Oracle forms and reports. Now we are migrating to web based technology ADF., Responsibilities:, 1. Converted Forms logic to PL/Sql Stored procedures., 2. Created RESTful API Services using ADF 12c, 3. Manual and Automated Tests using POSTMAN, 4. Designed dynamic and multi-browser compatible pages using ADF Faces., 5. Used SVN for source control., 6. Worked with JIRA, which is managing project requirements and tasks. Used GitHub as a version control., 7. Utilized Agile Methodologies (Scrum) to manage full life-cycle development of the project.in JIRA. Project -2, Project Title: Supplier contract management, Client Name: Qualitynet, Role: Developer., Technologies: ADF, Oracle BI, Workflow Builder, Duration: 2018-09 to 2019-01, Description: At present supplier contracts are handled manually by respective department and there was lot of confusion about expiry, archiving and logging the information. Now we prepared new system to create supplier contracts in system with all required information and provide reports, expiry notifications and archiving facility to users., Responsibilities:, 1. Requirement gathered from all stakeholders and logged in the URD, 2. Developed Supplier setup screen and other lookup tables., 3. Developed Supplier Contract screen., 4. Developed new report using oracle BI for analysis., 5. Developed new Expiry notifications. Project -3, Project Title: VAT Implementation in QBill, Client Name: Qualitynet, Role: Developer., Technologies: Oracle Forms and Reports., Duration: 2017-11 to 2018-08, Description: All GCC Countries planned to implement VAT, and in this project we analyzed effect of VAT on our business with KPMG and got approved VAT assessment and accordingly changed the entire QBill System which was our in-house developed application., Responsibilities:, 1. Collecting the process flow of all screens in QBill and prepared Use cases and sent to KPMG., 2. Reviewed VAT assessments sent by KPMG and prepared the URD to mention which forms to be modified in QBill., 3. Prepared Technical documents and impact of changes to the current screen., 4. Created new tables for VAT setups., 5. Modified all the base tables and transaction table which will be affected by VAT columns., 6. Modified services and customers screen to add VAT Codes., 7. Modified Proposal, preorder, corporate orders screen to accommodate VAT., 8. Modified Residential orders to add VAT., 9. Modified Sales invoice screen to add VAT., 10. Modified Service renewal screen to calculate VAT., 11. Changed all reports to Add VAT columns., 12. Modified the Journal Integration to include VAT. Project -4, Project Title: Purchasing System., Client Name: Aamal Holding Company., Role: Developer., Technologies: Oracle Apps R12, Oracle Forms and Reports 10g, Xml Publisher., Duration: 2016-05 to 2017-01, Description: Aamal Holding Co. is a renowned and trusted enterprise operating in Kuwait since 2002. With utmost devotion, rigorous work approaches and an enthusiastic team, our company has managed to earn a reputation of excellence and reliability in this region., Responsibilities:, 1. Developed new form for purchase requisition and interfaced to standard requisition using interface tables., 2. Developed custom purchase requisition summary form to enquire the requisition status., 3. Developed Approval screen for requisition by taking the setup from oracle HRMS., 4. Developed Receiving Screen., 5. Developed several document and analytical reports to support the system. Project -5, Project Title: Diet care System., Client Name: Diet care., Role: Developer., Technologies: Oracle Apps R12, Oracle Forms And Reports 10g , Xml Publisher., Duration: 2015-11 to 2016-04, Description: Established in 2005, Diet Care is among the first companies in Kuwait committed to helping people manage their weight, overall health and wellbeing. With its passionate team of experts and its internationally accredited dietitians, Diet Care is now the leading provider of health and nutritional food and weight management programs, catering to thousands of clients on a daily basis and operating in more than 70 community and commercial outlets across Kuwait by providing healthy and delicious ready-to-meals., Responsibilities:, 1. Developed new customer Registration and maintenance form in Dietcare system using standard APIs, 2. Developed Membership Booking form which will handle Customer membership booking, payments, meal deliveries, Transfers and Refunds., 3. Developed most of the forms to maintain lookup tables., 4. Developed meal selection forms., 5. Developed several document and analytical reports to support the system. Project -6, Project Title: Implementation of Oracle R12 Finance Modules., Client Name: Al Hasawi Refrigerator and Water Cooler Factories., Role: Techno Functional Consultant., Technologies: Oracle Apps R12, Oracle Forms and Reports 10g, Xml Publisher and OAF., Duration: 2014-03 to 2015-04, Description: Al hasawi Group was successfully pioneered in 1962 as an industrial company in Kuwait City, Kuwait. Forthcoming the generations of growth and success the company diversified its operations into a full-fledged refrigeration and retail corporation. The aim of project is to gain the credibility in the market by extending the support to customer and continuously improving the product., Responsibilities:, 1. This is Implementation Project in the modules (AP, AR, CM, FA, GL)., 2. Developed Inbound and Outbound Interfaces for AP,AR and GL, 3. Involved in customizing Reports .rdf and XML Publisher., 4. Customized forms using CUSTOM.pll., 5. Involved and Supported in Functional setups in AP, AR GL, 6. Customizing DFF as per client requirement., 7. Customizing report Formatting and assigning Value Sets, 8. Prepared Opening Balance conversions AP, AR., 9. Creation of document sequencing for each module., 10. Creating Conversions for Suppliers, Customers., Reports:, 1. Developed Custom Document voucher reports for AP Invoice, AP Payment, AR Transaction, AR Receipt and GL Document Report., 2. Developed Customer Statement Report., 3. Customized Account Contra Analysis Report., 4. Customized Oracle Standard Reports., Interfaces:, 5. Developed Accounts Payable Open Interface to Upload the Invoice data from Legacy Systems to AP Interface Tables., 6. Developed Complex Interface from Payroll (In-house) to AP and Gl., 7. Developed Interface from Legacy systems to AR., 8. Developed Interface from Legacy Systems to GL (Cash Sales)., 9. Developed Supplier and Customer Conversion., 10. Developed GL Daily Interface., 11. Developed Auto mail alerts of rejection data in interface to end users to take necessary action., Forms:, Customized the Forms Using CUSTOM.pll to provide the option to print all document reports from Menu with single click., OAF:, Customized Supplier creation form and Customer Creation form make some fields mandatory and Assigned Default values. Project -7, Project Title: Customer Relationship Management., Client Name: Al Hasawi Refrigerator and Water Cooler Factories., Role: Developer., Technologies: Oracle Jdeveloper 12c and ADF, Oracle Forms and Reports and Oracle Database 11g., Duration: 2013-09 to 2014-03, Responsibilities:, Created Agent module primarily comprises customer search, adding complaint, Token Number generation and Follow up with customers and graphical dashboard developed by HTML5, CSS, and JAVA in Jdeveloper Framework., Created the Dispatcher module which includes the Monitoring the call Trends, forwarding calls to particular departments , Follow up with customers , Agent Performance Analysis and generating customer feedback by provided questioner by ORACLE ,HTML5,CSS,JAVA in Jdeveloper Framework ., Involved in creation of Maintenance forms like site inspection, Job card Creation, Invoice and Replacements., Provided UI for Agent, Dispatcher, Call Center manager and Top management both graphical and pivot tabular representation for quicker analysis., Played key role in WebLogic server Installation, Configuration and Deployment of Application., Created customer Sales data by objects like views, stored procedure, functions, packages and triggers., Enforced data integrity by applying constraints to achieve quality of the data in the database., Implemented Sequences to generate Unique IDs for every individual., Involved in modifying exciting procedure, functions and packages according to business needs., Wrote complex queries using joins and sub queries to retrieve data from database., Improving performance using performance tuning conspectus. Project -7, Project Title: Human Resources Management System., Client Name: Al hasawi Industrial Group., Role: Forms and Reports Developer, Duration: 2013-01 to 2013-09, Description: Alhasawi Group was successfully pioneered in 1962 as an industrial company in Kuwait City, Kuwait. Forthcoming the generations of growth and success the company diversified its operations into a full-fledged refrigeration and retail corporation and also Official brand partners for SEARS and ACE Hardware. Alhasawi Group is having more than 1200 employees base., Responsibilities:, Involved in creation of modules like Employee Registration and Employee Tracking., Created Payroll and Asset management modules., Created the leave application form, return application and Rejoin Application forms., Provided access of HRMS to all department managers and HR Department., Implemented Oracle Look and Feel first time in our In-house projects., Created automated Attendance Management system using Sql Server which includes fetching data from finger print machines to Sql servers and from SQL server to Oracle Database using JDBC., Created analytical reports to the end users., Implemented Kuwait labor law for salary calculation, Leave Payments., Created the Evaluation and provided access to all department managers to do evaluation to their sub-ordinates., Created Auto mails regarding Attendance, Passport Expiry, Residency expiry, Vehicle license expiry and EOS Details to particular department on daily basis., Automated the ministry reports related to Contract renewal and salary details of employees., Preparation of the technical documents.