Oracle Ebs Developer

Covering Letter

Dear Hiring Manager,

I am down to your Organization to express my interest in the Oracle EBS Developer position. With a total of 9 years of experience in Oracle E-Business Suite development, including 6 years of relevant experience and 3 years working with bespoke applications, I am confident in my ability to contribute effectively to your team. My expertise includes designing, developing, and implementing solutions within Oracle EBS environments, as well as customizing and integrating bespoke applications to meet specific business needs. I am excited about the opportunity to bring my skills and knowledge to your Organization and help drive its success.

Thank you for considering my application. I look forward to the possibility of discussing how my background, skills, and enthusiasms can benefit your team.

Sincerely,

Yours Truly

Zahoor Ahmad

Oracle EBS Developer

ZAHOOR AHMAD

Oracle EBS Developer

Contact : +973-********, +92-308*******

E-mail : **********@*****.***, Skype: career.zahoorahmad

LinkedIn: https://www.linkedin.com/in/zahoorahmadpage

Origin Country : Pakistan, Current Address : East Riffa, Bahrain

Career Snapshot:

oOracle EBS Developer R12

6 Years

oSystem Analyst (Custom Applications)

2 Years

oSoftware Engineer (Oracle D2K Suite )

1 Year

Total Experience :

9 Years

Objective

I am seeking a challenging senior position within the organization where I can contribute by value-added services.

In this role, I aim to apply my skills and knowledge to deliver efficient and effective solutions in new implementations.

Hands on Tools

oWorkflow Builder

oJDeveloper for OAF

oSQL / PL-SQL

oOracle Forms 6i, 10g, and 11g

oOracle Reports 6i, 10g, and 11g

oOracle Discoverer

oOracle XML BI Publisher

oToad for PL-SQL

oOracle Web ADI

oOracle Apex

oPutty

oNotepad ++

oApproval Management Engine(AME)

oOracle Database 10,11g,12c

Technical Skills

Oracle E-Business Suite R12

Oracle EBS-R12 analysis, design, development, maintenance, testing, support, personalization, configuration.

Oracle AP, AR, GL, FA, CM, HRMS, Payroll, SCM with RICEW Components.

Oracle Application Framework (OAF), Forms 6i, 10g, 11g development, customization & extension.

Oracle Workflow Builder / AME / Alerts, Notifications scheduled or event based.

Oracle XML Publisher reports bursting email with all output formats, Oracle Discoverer report.

Oracle EBS APIs, staging & open interface tables, data loading scripts & standard schema understanding.

Oracle dynamic AOL lookups for EBS.

Oracle Web ADI’s used for desktop/SOA Web Services.

Good documentation skills to prepare deliverable using AIM methodology.

Excellent communication, interpersonal and Analytical and problem-solving skills

PL-SQL & Data Modeling Proficiency

Expertise in PL-SQL stored procedures, functions, triggers, views, synonyms and packages, collections, joins, sub queries, analytical & aggregation functions custom business logic, data validation rules & process automation

Ability to analysis PL/SQL code for database performance, including indexing, query optimization & normalization.

Experience in designing relational database schemas, database normalization using tools like SQL Developer, Toad.

Understanding of database administration tasks such as backup and recovery, user management, and database security.

Familiarity with Oracle development tools such as SQL Developer, Toad, SQL data loader, and SQL*Plus. Importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL LOADER, UTL_FILE, Oracle APIs etc.

Proficiency in version control systems like Git for managing code changes and collaboration within development teams.

Experience in integrating Oracle databases with other systems using technologies like Oracle Data Integrator.

Ability to diagnose and resolve database-related issues, including errors and data inconsistencies.

Strong grip on database designs and development processes. Design ERD, DFD diagrams by using Visio, Ervin.

Bahrain Petroleum Company

Oracle EBS Developer R12

Jan-2020 to Onward

Professional Experience

Personalization & Setups

Oracle Modules AP, AR, GL, FA, CM, HRMS, Payroll, SCM

Concurrent programs, Request sets, forms menus and Personalization, by downloading the LDT files

Expertise in System Administrator responsibility to create users, responsibilities, Values Sets and Request sets.

Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables.

Communication with Oracle Support in different runtime complications & bugs.

Strong grip on P2P & O2C for Oracle EBS r12.

OA Framework

Development of AR-CE bank reconciliation OAF page.

Development of AR activity status page with due date alarming visual attribute.

Employee Bank Account Letter submission page for payroll process required by HR.

XML-BI Publisher Reports

Oracle Time & Labor, overtime, HRMS, AR, GL analytical xml reports development.

Bursting email report program for employee overtime & approval, deduction alert, salary slip, retirement date alert.

Bursting email report program AR invoices develop for vendor.

Bursting email report program for new Purchase Order entry, receiving of goods alert.

Workflow / AME

Customized various transactions in Account Receivables like Invoice, Receipts, Credit Memos and Debit Memos etc. Customizations of Requisition Approval, PO Approval & Auto Create Workflows.

Designed and developed custom USER APPROVAL WORKFLOW to meet the client application’s user creation and maintenance according to the business requirement.

APIs & Import Programs

Implemented AP Invoice import through Payables Open Interface Import Program.

Used SQL*Loader Upload Budget by Open Interface to load the data from legacy systems to the GL_Budget_Interface.

Involved in Customer Conversions to load Customer details into HZ tables by creating staging tables and performing validations and finally loading them in to base tables using TCA APIs.

Developed an outbound interface for open Payable Invoices, Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts, etc. from legacy system to Payables.

Worked on Auto Invoice Interface Program to load credit memos, debit memos and invoices from legacy system.

Loaded the vendor’s information from legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.

Infovision Consultants W.W.L

Oracle EBS Developer R12

Feb-2018 to Jan-2020

Oracle Forms & XML Reports

Worked on the development of interfaces, Data Conversions, Developing new Forms, Reports, Customizing Oracle Reports In order to Cash cycles touching various modules such as AR, PO and AP, GL.

Designed and created custom form using Forms 10g tool to hold lookup cross reference values between legacy system and oracle apps.

Customized AR-CE Bank Reconciliation Batch Info Report.

Strong Knowledge in Development and Customization of Forms/Reports with sound understanding of (AOL).

Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button.

Developed master detail yearly budget entry form in using TEMPLATE.FMB in oracle developer 10g for EBS.

PL/SQL Scripts & Staging Tables

Responsible for Journal Imports from all other modules like AP, AR into GL.

Created PL/SQL scripts to validate and store data in MTL_SYSTEM_ITEMS_INTERFACE for upload to tables using the ITEM IMPORT Interface.

Validation packages to Load data to interface tables (OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, OE_CUSTOMER_INFO_IFACE_ALL)

Customized Sales Order form using custom.pll to add customer fax, email and phone number contacts.

Developed a Custom Invoice Report (PL/SQL package) for the AP Payables Manager to verify the INVOICE Duplicates from Vendors and Validate against the checks paid for the INVOICES. Used UTL_FILE utility to generate PIPE-delimited format outputs for AP team.

Developed a program to load external data from legacy system into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE.

Oracle Reports

Designed various group left, group above, matrix reports.

Experience to Design AR Invoice Report for Customer Invoice Notes with Print facility in 10g and customize the report using XML Publisher.

Developed various Custom reports, Customized existing reports (PO Purchase Order and Releases Detail Report, Purchase Requisition Status Report) according to the functional specifications using Reports 10g and XML publisher.

In user edition, developed various crucial financial analysis reports (for all modules) for AP/GL/OM/PO/AR using Oracle Discoverer 10g.

Developed Cash flow detail & summary, PA_rev_monthly, PA_rev_monthly_budget, Inventory aging register reports.

Zahidjee Group of Textiles

System Analyst Customization & EBS-R12

Mar-2016 to Feb-2018

Developed SQL scripts to create temporary tables and developed SQL*Loader control files to load the legacy data into the tem tables.

Worked on configuration and customization various oracle modules (INV, AP, AR, GL) for a multi-site, multi-phase implementation

Worked on Open Item Interface to convert Purchased Item Information from Custom Purchasing System to Oracle INV module.

Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.

Validated the data and populated the Payables interface table by a Concurrent program which in turn submits a Payables APIs.

Masood Textile Mills

Software Engineer (Oracle D2K Suite )

Aug-2014 to Jan-2016

I have worked on Oracle Forms & Reports (6i,10g,11g), wrote complex Functions, PL/SQL Stored Procedures, Packages, Constraints.

I have developed complete in-house customized ERP modules (HRMS, Accounts, Manufacturing, PO Purchasing Inventory Stock).

I used waterfall model under SDLC approach based on Analysis, System Design, Implementation, Testing and Deployment Maintenance.

Qualifications

Education

Institute

Grade

BCS. (Bachelor of Comp Sc.)

International College of Management Sciences. Faisalabad

3.5

Diploma in Computer Applications. (DCA)

National College of Computer Sciences. Faisalabad

76%

Intermediate

Govt. Degree College Faisalabad.

567

Matriculation

Govt. Rehmania High School Faisalabad

567

Contact this candidate