Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali
Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

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
Senior Apps DBA
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
Lead Infrastructure Consultant
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.
Professional Freelancer
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
Assistant Director (Databases)
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
Newports Institute Of Communication & Economics
2008 - 2011
Newports Institute Of Communication & Economics
Pakistan

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

Certificate
Oracle University
2013
Oracle University
USA

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

Certificate
Oracle University
2013
Oracle University
USA

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

Certificate
Oracle University
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

Blog
July 1, 2017 How to check online FND_USERS in Oracle Apps
AppsDBA ScriptsScripts

How to check online FND_USERS in Oracle EBS R12

(more…)
July 1, 2017 Oracle Fixed assets (FA) Profile Options
Configurations-FAFixed AssetsOracle Functional

Oracle Fixed assets (FA) Profile Options

 

 

Account Generator: Purge Runtime Data

 

 Always set this profile option to Yes to ensure that Oracle Workflow has finished generating accounting flexfield code combinations.

Temporarily set this option to No at the user level if you are debugging the account generator. Running the account generator with this option set to No fills up the workflow tables and slows performance

 
FA: Allow Swiss Special Assets

 

 Controls whether you can use the Swiss insurance calculation method.

If this profile option is set, when you add insurance details on the Fixed Asset Insurance window, you can check the Special Swiss Assets check box, which signifies that this asset will use the Swiss insurance calculation method.

 
FA: Archive Table Sizing Factor

 

 This profile option controls the space allotted for the temporary tables created when you archive and purge a book.

The sizing factor specifies how many storage kilobytes to reserve for the initial extent. The default value is 100 kilobytes.

Update this option if you are archiving a large number of records for a fiscal year.

 
FA: Cache Sizing Factor

 

 This profile option controls the database information retained in the concurrent program for performance improvement. The range is 0 to 25.

 
FA: Deprn Single

 

 Controls the caching buffer used when you run depreciation. You can set the buffer to either No (20) or Yes (1).

If you set FA: Deprn Single to No, the cache is reset after every 20 assets. If you set FA: Deprn Single to Yes, the cache is reset after every asset.

 
FA: Generate Expense Account

 

 Allows you to generate the depreciation expense account based on Workflow rules.

When you set this profile option to Yes, Generate Accounts reads the profile option and generates the expense account using Workflow rules. If you do not set this profile option or you set it to No, Generate Accounts uses the expense account entered for an asset in the Assignments window.

 
FA: Large Rollback Segment Name

 

 This profile option indicates the rollback segment name that Oracle Assets uses for programs requiring large rollback space.

If you do not specify a large rollback segment, Oracle Assets uses the first available rollback segment.

 
FA: Number Mass Addition Parallel Requests

 

 Controls the number of requests the Mass Additions Post program will run in parallel. When you run the program, Oracle Assets spawns a parent process with several child processes.

Enter a number between 1 and 20 to specify the maximum number of parallel requests you want to allow. The parent process is not included in this number.

 
FA: Number of Parallel Requests

 

 This profile option controls the number of requests that Oracle Assets programs can run in parallel.

Enter a number between 1 and 20 to specify the maximum number of parallel requests that you want to allow.

 
FA: Print Debug

 

 This option indicates whether debug tracing messages are printed in concurrent program log files. Support uses these messages to identify a problem with the code.

 
FA: Print Timing Diagnostics

 

 This option indicates whether timing diagnostic messages are printed in concurrent program log files. Support. uses these messages to identify a problem with the code.

 
FA: Security Profile

 

 Restricts access to the organizations defined in the security profile. This option is seeded at the site level with the view–all security profile created for the Startup Business Group.

 
FA: Default DPIS to Invoice Date

 

 Enables you to use the Future Transactions feature by allowing the default date–placed–in–service to be the invoice date, even when the invoice date is in a future accounting period. If you set this profile option to Yes, Oracle Assets defaults the date–placed–in–service to the invoice date for future transactions. If you set this profile option to No, Oracle Assets does not default the date–placed–in–service to the invoice dates, and you cannot use the Future Transactions feature.

 
FA: Mass Copy All Cost Adjustments

 

 Allows the Mass Copy program to copy all cost adjustments, even when the un-revalued cost is different in the corporate book and the associated tax books.

 

 

 

 
July 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…)
July 1, 2017 APP-ONT-251213: Error: Please enter valid address elements: STATE, CITY.
Accounts ReceivablesErrors/Workarounds-AROracle Functional

 

ERROR

 

APP-ONT-251213: Error: Please enter valid address elements: STATE, CITY.

(more…)
July 1, 2017 General Ledger (GL) Journals Profile Options
Configurations-GLGeneral LedgerOracle Functional

General Ledger (GL) Journals Profile Options

 

 

Journals: Allow Multiple Exchange Rates

 Controls whether to allow multiple conversion rates within a journal entry.

Journals: Allow Posting During Journal Entry

 Controls whether you can post a manual journal entry from the Enter Journals window.

Journals: Default Category

  Specify the default category for manual journal entries.

Journals: Enable Prior Period Notification

 Controls whether General Ledger notifies you when you are entering a journal for a prior period.

Journals: Mix Statistical and Monetary

 Controls whether you can enter statistical amounts in the same journal line as monetary amounts.

Journals: Override Reversal Method

 Controls whether you can override the specified default reversal method.

 

 

 
July 1, 2017 Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION. Your session is no longer valid. </PRE>

(more…)

Contact

Get in Touch
  • Address: Karachi, PAKISTAN
  • Email: askme@SyedSaadAli.com
  • Phone: +92-300-026-5668
  • Freelance: Available
Contact Form

    All Rights Reserved