Muhammad Usman Farooq .

Oracle Certified Professional (OCP) working on challenging and decision-making role in the field of Software Development as Oracle Application Developer. I’m eager to turn my talent for developing business requirements into actionable growth strategies. As a sharp leaner and hardworking team member I can make meaningful contribution to the growth of the company and can be a part of the technical innovation. Projects  ERP o Enterprise supply chain ERP for secondary sales of medicine in Pakistan o ERP Dashboards o ERP Mobile Integrations  Hospital Management System o Upgradation of existing hospital management system  Oracle Cloud Analytics for Sales and Production o ERP Secondary sales analytics/ trends o ERP Supply chain dashboards o Production analytics Key Responsibilities and Developments • Development of ERP application as Oracle Database and Apex Developer. It’s an ERP solution for centralized supply chain managing companies based on Oracle EBS Standards. • Development of custom ERP flow so that Companies can track their products from auto purchase orders to product sales with multiple purchase companies/suppliers and application usage location wise. • Development of database structure according to customer requirements with current schema. On database, writing packages and procedures to control the business flow. • Development of server side procedures in Oracle PL/SQL hitched with oracle apex applications. Also custom procedures for master/bulk data loading from legacy systems. • Development of forms and reports on new requirements. • Developed new application module Accounts & Fix asset and Human Resource Management System. It is the complete Accounts and HRMS integration with current ERP solution. • Development of Web API services with oracle apex and cloud deployments. • API’s Integration with Oracle Fusion and R12.2. • Development of custom modules for every client after requirement gathering and analysis. • Configuration of Apache Tomcat Server & JSPER Reports utility with Oracle APEX and migration of all legacy JSPER reports. • Deployment of Applications and reports to server. • Development of JSPER Reports and HTML reports on APEX application and development of user rights management at object level for APEX page attributes. • Developed application module (Desktop Integration) for ERP (Legacy system with Oracle ADF) users to communicate with web application from desktop applications like Microsoft Excel. From where users can upload data in bulk to application with application custom authentication (Oracle ADF Desktop Integration). • Developed server virtual directories for ERP users to interact with server utilities through ERP application. • Developed oracle custom application workflows and ERD’s of Database entities. • Developing ERP reports and deploying to live servers using Jasper Reporting tool. • WebLogic server management and deployments of Java based application on clustered servers. • Working with modern build pipelines and also familiar with common tools such as Git (code versioning tool), development environments and development life cycles etc. • Development of Oracle Cloud Analytical dashboards for clients. o Sales analytics and trends for secondary sales o Supply chain management dashboards o Production analytics and predictions