Muhammad Shakir Ali

Experience

• 

  Parazelsus Pakistan (Private) Limited

  Dec 2012 - Aug 2021

  Responsible for reporting of receivables on daily basis using Apex application.Follow up receivables of 14 branchesResponsible for issuance of debit notes to the Principals and getting them acknowledged and settled against discounts allocated to customers, promotional goods, expired stocks, payroll, etc.To liaise with Principals in order to settle queries related to debit notes issued.Responsible for management of customer accounts and portfolio management based on customers current and past performance.Maintain Branch Rent schedules.Responsible for monitoring of receivables and movement of cash of 14 branches across Pakistan.Prepare Bank reconciliation statement every month.Prepare Prepayment Schedule every month.Maintains accounting ledgers by posting monthly account transactions.Correspondence with Bank to inform and resolve issues.Verify & Record Petty cash vouchers in GL Show less Maintain Bank position.Maintain Van Rent & Fuel schedules.Maintain monthly expenses Accrual sheet.Maintain paid to Principals sheet monthly daily basis. Reconcile sub ledger balances with General Ledger. Prepare bank payment Vouchers, receipt vouchers, journal vouchers.Responsible for preparation and compilation of Insurance Claims and subsequent follow-up of claims from Insurance Company.Prepare Bank reconciliation statement every monthPosting to sub ledger and General LedgerReconcile sub ledger balances with General Ledger Prepare bank payment Vouchers, receipt vouchers, journal vouchers. Show less

  • M.I.S Officer (Oracle Apex Developer)

    Oct 2016 - Aug 2021

  • Accounts Receivable Officer

    Jan 2015 - Sept 2016

  • Accounts Payable Officer

    Dec 2012 - Dec 2014
• 

  Paracha Textile Mills Ltd.

  Sept 2021 - Jan 2022

  Oracle APEX Developer

  Oracle SQL, PL/SQL, and Developer Oracle Application Express (APEX).Prepare reports in Oracle report builder 6i & 10g.Develop HRMS System Leave management Overtime management etc. Maintain Distribution motive system (secondary sales).Manage Getpass, warehouse processing , sales forecasting and inventory planning. Develop Oracle Apex custom reports and forms.

• 

  Jaffer Business Systems (Private) Limited

  Jan 2022 - Jun 2022

  Apex Consultant

  Oracle Application Express (APEX) application support as per business requirements.Web Services (REST APIs) for Mobile ApplicationCreated Procedures, Functions, Packages, Trigger, DB Schedule.As per Business requirement route mapping on geofencing for order bookers.

• 

  Parazelsus Pakistan (Private) Limited

  Jun 2022 - Jul 2023

  Oracle Consultant

  Oracle Application Express (APEX) application support as per business requirements.Web Services (REST APIs) for Mobile Application.Created Procedures, Functions, Packages, Trigger, DB Schedule.As per Business requirement route mapping on geofencing for order bookers.

• 

  Muller & Phipps Pakistan (Private) Limited

  Jul 2023 - Jul 2024

  Oracle Apex Developer

  Designing and developing commercial grade web applications using Oracle APEX. Ability to deliver modern elegant web applications using a combination of APEX and JavaScript.Built an application PSP (Patient Support Program) for Novartis,which sales medicine on discount as per patient plan, including inventory management and integration with other system.Including development and supporting role in othen appliction Ncare , MPCC, MPL logistic, MNP location traceability application.Oracle SQL / Oracle PL/SQL programming experienceProblem Solving: Ability to analyse and resolve complex infrastructure resource and application deployment issues.Experience in managing web page layouts with APEX templates and themes. Show less

• 

  Jaffer Business Systems (Private) Limited

  Aug 2024 - now

  Oracle Apex Developer

  PSO (Pakistan State Oil) Logistics projectAutomated Value Chain Planning & Management System.Bank Al-Habib Limited (Oracle Application Express) request process.● Guard Management● Travel Management● Stationery Management