Home

About Me

Technically-sophisticated professional with extensive experience in updating server security, executing routine back-ups, and designing and implementing tests of the system to address issues with accessing data

Adept at leading the planning, designing, developing, testing, and deploying efficient solutions within Oracle EBS system, in order to satisfy strategic, financial, and operations needs of the organization.
Skilled in planning and managing successful projects, mitigating risks, controlling costs, and directing project teams. Instrumental in monitoring routine maintenance of system, implementing the ERP systems, and approving budget.
Proven success in analyzing business processes/process re-engineering and recommending solutions. Deft at establishing IT service continuity management strategies, disaster recovery plans and associated test procedures of each critical functional area of the organization.

Age: 37
Residence: Pakistan
Freelance: Available
Address: Karachi, PAKISTAN

My Services

Oracle E-Business Suite Upgrade

Oracle E-Business Suite Migration

Oracle Database Upgrade or Migrate

Oracle Maximum Availability Architecture

Performance Evaluation

Pricing

Hire Me On Upwork

$ 35 Hour

Database Administration
Oracle E-Business Suite Administration
Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Order Now

Hire Me on Fiverr

$ 35 Hour

Database Administration
Oracle E-Business Suite Administration
Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Order Now

Hire Team

$ 40 Hour

Database Administration
Oracle E-Business Suite Administration
Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Order Now

Resume

Experience

2024-

Senior Apps DBA

Private Contractor

My role includes infrastructure support, capacity planning, installation, configuration, database design, and migration, up gradation, performance monitoring, security, database backups, data recovery plan, and procedures including application server administration

2022- 2024

Senior Apps DBA

Computer & Systems Engineering Company

My role includes infrastructure support, capacity planning, installation, configuration, database design, and migration, up gradation, performance monitoring, security, database backups, data recovery plan, and procedures including application server administration

2020-2021

Lead Infrastructure Consultant

ITANZ Group

Managed Oracle cloud infrastructure, compute, storage, networking, connectivity, and edge service, database management, analytics, integration, and Oracle weblogic clustering environment over Oracle Cloud IAAS. Collaborated with the Oracle corporation staff for offering technical support to diagnose and troubleshoot common problems.

2020 - 2022

Professional Freelancer

Upwork Inc.

Collaborated with Clients for the Task Related to Oracle Database, Oracle E-Business Suite, Oracle Cloud Infrastructure, Oracle Weblogic

2015-2020

Assistant Director (Databases)

Pakistan Civil Aviation Authority

Managed ERP for implementing the structures effectively, while limiting the resources consumed in the planning process. Improved IT/business processes and investigations to resolve the user’s issues as well as offered user’s training to help the user in operating the system in efficient way.

Education

2008 - 2011

Newports Institute Of Communication & Economics

Pakistan

Newports Institute Of Communication & Economics offers a B.S. in Computer Science.

Certificate

2013

Oracle University

USA

Oracle E-Business Suite R12 Financials Certified Expert Consultant, PAYABLES

Certificate

2013

Oracle University

USA

Oracle E-Business Suite R12 Financials Certified Expert Consultant, PAYABLES

Certificate

2014

Oracle University

USA

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

Certificate

Skills

Oracle Expertise

Oracle Databases
Oracle E-Business Suite
Oracle Weblogic
Oracle Cloud Infrastructure
Oracle Database Appliances

Languages

English

System

Linux

90%
Microsoft

75%
SOLARIS

65%
AIX

60%

Knowledge

Installation/Configuration
Capacity Planning
Data Recovery Plan
Oracle Database Migration and Upgrade
Oracle ERP Migration and Upgrade
Linux and Windows management
Performance Evaluation

Works

Projects

Oracle Cloud Infrastructure Projects

Content

Oracle E-Business Suite Upgrade Project

Blog

August 1, 2017 Oracle financials interface tables

Accounts PayablesAccounts ReceivablesAPPS DBAConfigurations-APConfigurations-ARConfigurations-CMConfigurations-FAConfigurations-GLFixed AssetsGeneral LedgerInstallations/Configurations-ApplicationsOracle FunctionalScripts

General Ledger Interface Tables

GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_DRM_HIERARCHY_INTERFACE
GL_DRM_SEGVALUES_INTERFACE
GL_IMP_COA_ERR_INTERFACE
GL_IMP_COA_NORM_HIER_INTERFACE
GL_IMP_COA_SEG_VAL_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY
GL_REPORT_INTERFACE
GL_XFR_INTERFACE

Account Payables (AP) Interface Tables

AP_INTERFACE_CONTROLS
AP_INTERFACE_REJECTIONS
AP_INVOICE_INTERFACE
AP_INVOICE_LINES_INTERFACE
OIE_POL_RATES_INTERFACE

Account Receivables (AR) Interface Tables

AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_CUSTOMERS_INTERFACE_ALL
RE_INTERFACE_DISTRIBUTION_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_LINES_ALL
RA_INTERFACE_SALESCREDITS_ALL
AR_INTERFACE_CONTS_ALL
AR_PMTS_INTERFACE_HEADER_GT
AR_PMTS_INTERFACE_LINES_GT
AR_PMTS_INTERFACE_LINE_DETAILS
HZ_DQM_SH_SYNC_INTERFACE
HZ_DQM_SYNC_INTERFACE
RA_INTERFACE_REQID_GT

Fixed Assets (FA) Interface Tables

FA_BUDGET_INTERFACE
FA_INV_INTERFACE
FA_PRODUCTION_INTERFACE
FA_TAX_INTERFACE
FA_TRANSACTION_INTERFACE

Cash Management (CE) Interface Tables

CE_ARCH_INTERFACE_HEADERS
CE_ARCH_INTERFACE_HEADERS_ALL
CE_ARCH_INTERFACE_LINES
CE_HEADER_INTERFACE_ERRORS
CE_LINE_INTERFACE_ERRORS
CE_STATEMENT_LINES_INTERFACE
CE_UK_VALIDATIONS_INTERFACE

August 1, 2017 Unable to get passwords from Vault

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Completed database cleanup for previous session.

Error: Unable to execute statement <
Begin
ad_jar.get_jripasswords(:l_storepass, :l_keypass);
End;
> len = 63

AD Administration error:
ORA-01031: insufficient privileges
ORA-06512: at “SYS.DBMS_SESSION”, line 101
ORA-06512: at “APPS.AD_JAR”, line 17
ORA-06512: at line 3

AD Administration error:

Unable to get passwords from Vault

You should check the file
/u01/apps/apps_st/appl/admin/FMSGST/log/adadmin.log

for errors.

SOLUTION

$ sqlplus sys “/as sysdba”

SQL>@adgrants.sql APPS

August 1, 2017 PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

PLS-00201: identifier ‘AD_JAR.GET_JRIPASSWORDS’ must be declared

AD code level : [B.3]
(more…)

August 1, 2017 Relink of module “UMX_ENDECA_RBACMigration.sh” failed

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Relink of module “UMX_ENDECA_RBACAuto.sh” failed.
See error messages above (also recorded in log file) for possible
reasons for the failure. Also, please check that the Unix userid
running adrelink has read, write, and execute permissions
on the directory /u01/apps/apps_st/appl/fnd/12.0.0/bin,
and that there is sufficient space remaining on the disk partition
containing your Oracle Applications installation.
(more…)

August 1, 2017 TXKRUN.PL Deploying a New Forms .EAR File Error with OPMNCTL Start

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Errors encountered running /u01/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgOC4JApp.pl
…
Command error: <rc> = 32512, <command> = /u01/apps/tech_st/10.1.3/opmn/bin/opmnctl start
(more…)

August 1, 2017 An attempt has been made to enter a null value into a column that requires data

Accounts ReceivablesErrors/Workarounds-AROracle Functional

ERROR

An attempt has been made to enter a null value into a column that requires data. Please correct to ensure that only valid values are entered for the column.

(more…)

Contact

Get in Touch

Address: Karachi, PAKISTAN
Email: askme@SyedSaadAli.com
Phone: +92-300-026-5668
Freelance: Available

Contact Form