Summary
Overview
Work History
Education
Skills
Certification
Personal Details
Timeline
Generic

Tahir Malik

Oracle EBS Technical Consultant
Jeddah

Summary

I have 10+ years of experience as Oracle EBS Technical Consultant with diverse clients that includes Textiles, Real Estate, Telecom, Education & Training, Electricity Distribution, Rent A Car. My core expertise includes;

• SCM Modules – P2P, O2C, Purchasing, Inventory, Order Management, Oracle Financials – Account Payables, Account Receivable, General Ledger, Discrete Manufacturing – BOM & WIP
• Excellent experience in Custom solutions design and design and developed various Custom ERP solutions for the clients.
• Experience in OAF Page development, extension and personalization
• Highly skilled in writing complex PLSQL programs
• Excellent Experience in Forms 10g, 11g, Reports
• Good Experience in Oracle APEX
• Excellent knowledge Fusion OTBI development
• Excellent knowledge of integrated API Inbound and Outbound interfaces
• Hands on experience in developing RICE components using SQL, PL/SQL, Oracle Reports (RDF), XML Publisher (RTF), Oracle Forms, SQL Loader & Workflow, Procedures, Functions, Views, Materialized Views, Triggers

Overview

11
11
years of professional experience
1
1
Certification

Work History

Oracle Apps Technical Consultant

Computer And System Engineering Ltd
Jeddah
08.2022 - Current

I’m currently working in CSE Consultancy Company - KSA. Here I’m working on Financials, Supply Chain, Inventory, Order Management, Fixed Assets, and Customized process Integrated with Oracle EBS.

Support & Enhancements:

• Automatization of Custom process and Standard by using various API's.

• Development of XML Reports in R-12 E-Business Suite.

• Project of ZATCA integration and designing a custom solution.

• Forms Personalization and Customization of D2K & OAF forms

• Create Multiple Excel Sheet Report in Oracle, Oracle Workflow Customization.

• Functional & Technical Support to, Financial, P2P & O2C Life Cycles of ERP.

• Corporate Performance Reports & Complex Graphs Developments in ERP.

• Monitoring of System Critical Processes.

• Customization of Rent a Car Process

• Material Overhead system by interfacing AP invoices, Development of RICE components.

Skills: Oracle Report Builder · Analytical Skills · Manage Complex Projects · Oracle SCM · Oracle Order Management · Troubleshooting · Oracle Application Express · Oracle SQL Developer · Oracle Applications · Oracle Forms · PL/SQL · Oracle workflows

Sr. Oracle ERP Developer

Sapphire Textile Mills Ltd. (Home Textiles)
Lahore
02.2020 - 08.2022

Support & Enhancements:

• Design and Development a complete Custom solutions and integrate with EBS

• Automatization of Custom process and Standard by using API's.

• Development of XML Reports in R-12 E-Business Suite.

• Forms Personalization , Forms Customization of D2K.

• Oracle Workflow Customization.

• Functional & Technical Support to, Financial, P2P & O2C Life Cycles.

• Monitoring of System Critical Processes.

• Customization of Rent a Car Process

• Material Overhead system by interfacing AP invoices,

• Development of RICE components.Support & Enhancements

• Design and Development a complete Custom solutions and integrate with EBS

Skills: Oracle Report Builder · Analytical Skills · Manage Complex Projects · Oracle SCM · Oracle Order Management · Troubleshooting · Oracle Application Express · Oracle SQL Developer · Oracle Applications · Oracle Forms · PL/SQL · Oracle workflows

Executive IT-ERP

Zong CMPak Ltd
Islamabad
08.2019 - 01.2020

• Provided Technical Support for ERP release 12.2.4

• Worked on Oracle Application Framework (OAF) page development

• Worked on custom reports of Finance and Supply chain modules

• Worked on Custom forms for managing landed costs

Oracle EBS Developer

Sapphire Textile Mills Limited.
Lahore
06.2015 - 08.2019

• Developed Reports, Interfaces, Conversions and Extensions (RICE) Components.

• Expertise and implementation experience in Oracle ERP – SCM, P2P, ODM, Inventory (INV), Bills of Material (BOM), Work in Process (WIP)

• Creation of data fixes, store procedures, functions, Views, Packages, triggers and interfaces using SQL and PL/SQL, RICE Components

• Development of Business Reports and Forms using Oracle developer

• Analysis and design customized Reports and Forms and integrate in Oracle Apps as per user requirement o Development of custom processes using Workflow Builder

• Debugging and performance tuning

• Forms Personalization

• Designed custom modules, such as Work Order, Export Documentation, Inventory automation. o Analysis and design customized Reports and Forms and registering in Oracle Apps as per user requirement

• Control

Sr. Oracle Developer

Vision Plus Technologies
Lahore
01.2013 - 06.2015

1. SITARA Petroleum Service (PVT) Ltd

• Attend requirements gathering sessions with end users

• Identify business gaps and inconsistencies and accordingly develop action plans.

• Developed SQL, PL/SQL, Oracle Reports, Oracle Forms

• Support business functions and develop business cases.

• Develop new business model or recommend enhancements to meet customer

Demands.

• Technical Design documents, build artifacts, Unit Test plan, and Installation guide, and suggest the best practice methods for a quality deliverable.

• Attend requirements gathering sessions with end users

• Identify business gaps and inconsistencies and accordingly develop action plans.

• Developed SQL, PL/SQL, Oracle Reports, Oracle Forms

• Support business functions and develop business cases.

• Develop new business model or recommend enhancements to meet customer demands.

• Technical Design documents, build artifacts, Unit Test plan, and Installation guide, and suggest the best practice methods for a quality deliverable.

Education

Bachelor of Science - Software Engineering

Allama Iqbal Open University
Islamabad, Pakistan
01.2013

Skills

  • Oracle Forms, Oracle Reports, Oracle Workflow, XML Publisher (BI Publisher), SQL, PLSQL, RICE Components
  • Oracle Apex
  • Database: Oracle 10g/11g/12c
  • Effectively Used SQL & PL/SQL features like Creating Table, Indexes Triggers Sequences, Cursors and Ref Cursors for performance and validation purposes
  • Working on Automatization and auto program by using API's for SCM,Inventory, AP, AR, Manufacturing etc
  • Created Materialized views for performance Tuning
    Used advanced PL/SQL features like Collections,
    Bulk Binding and Dynamic SQL Worked technical lead for the offshore team
    Developed Packages for Custom Objects using SQL PL/SQL
    Used PL/SQL advances features like Bulk Collect Bulk Binding, and Dynamic SQL Worked as a technical lead for the offshore team
  • Developed Packages for Custom Objects using SQL, PL/SQL

Certification

· Oracle SAP ABAP

· Oracle APEX Cloud Developer Professional (1Z0-770)

Personal Details

Nationality: Pakistan

Passport No: NA1012122 

Passport Expiry: 19-05-2027

Father Name: Sher Muhammad

Marital Status: Married

Driving License: Yes

Timeline

Oracle Apps Technical Consultant

Computer And System Engineering Ltd
08.2022 - Current

Sr. Oracle ERP Developer

Sapphire Textile Mills Ltd. (Home Textiles)
02.2020 - 08.2022

Executive IT-ERP

Zong CMPak Ltd
08.2019 - 01.2020

Oracle EBS Developer

Sapphire Textile Mills Limited.
06.2015 - 08.2019

Sr. Oracle Developer

Vision Plus Technologies
01.2013 - 06.2015

Bachelor of Science - Software Engineering

Allama Iqbal Open University
Tahir MalikOracle EBS Technical Consultant