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

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

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
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
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

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

June 15, 2017 The Center of Excellence in the Era of Self-Service Analytics
NEWS AND UPDATES

The Center of Excellence in the Era of Self-Service Analytics

With the new generation of visual, self-service analytics software, the traditional role of IT in providing business analysis tools, integration with data sources, data models and reports has changed.

Nowadays, the pendulum has swung heavily towards business self-service capabilities. Business people now have the ability to quickly deploy, access a variety of data and intuitively visualize business results and scenarios. However, there are risks — the return of data silos, concerns about security and compliance, the lack of enterprise scale resulting in higher costs, and more.

In this era, the role of an Analytics Center of Excellence (COE) can provide considerable value to an organization, but it may require rethinking and reorganizing the business structure and operating principles.

In a recent Forrester research study, researchers explained the need for a new balance between IT and Business. Aptly named, “Balance Self-Service Analytics and Governance to Achieve Business Success,” Forrester pointed out that powerful analytics tools have become visual, accessible and user-friendly, forcing a change in the traditional IT role as a technology provider. Additionally, the role of the Analytics Center of Excellence (ACE), also known as the Business Intelligence Competency Center (BICC) needs to adapt to this new paradigm to enable its continued value to the organization.

These roles are important to define clearly. Self-service analytics and data discovery have been embraced by business people in all functions as a way of quickly and effectively driving greater insight into current and future business performance. Cloud or hybrid cloud deployment makes it easier to start small and scale and increases the flexibility for users. Business people no longer need to rely on IT to provide analytic capabilities.

This new era of self-service, however, has risks mainly centered around the lack of governance. Part of this risk is the unintended creation of a new set of analytic silos where individuals cannot align or communicate effectively with each other and across departments. The lack of data models and standards, missing oversight of data quality, and absent management of data security and legal—and or—regulatory compliance can reduce the effectiveness of data-driven decisions, inhibit economies of scale and ultimately result in higher, rather than lower overall costs of operation. In the Forrester study, data security and privacy, data quality, and user training ranked at the top of the list of concerns.

Enabling self-service analytics without providing for compliance and cross-functional alignment is risky. Organizations need to minimize the threats of operational drag and myopic perspective resulting from self-service silos. What’s needed is a rebalancing of the traditional Business—IT relationship where, as Forrester says “…IT mostly governs and curates data while business users are empowered to drive insights mostly on their own without delay.”

This new balanced approach also requires new thinking about the role of the Analytics Center of Excellence (COE). As an enterprise resource, the Center can remain as “a team of people established to promote collaboration and the application of standards and best practices across the organization.”

But as organizations become more data-led, there needs to be recognition that business is more likely to drive the acquisition of analytics tools and put them into use quickly. At the same time, IT has a more critical role in governance to reduce risk and inefficiency by defining standards for data models, quality, and compliance. A best-practice COE can become a vehicle for empowering Business with speed and self-sufficiency while providing the necessary and effective controls.

Some examples of how the Center of Excellence (COE) can adapt to the new world are:

  • Companies that have an existing COE can step back and review their framework to determine how to recast the COE charter in the self-service era. Business will select and acquire analytics tools while IT leaders are tasked with, “…ensuring that business users have the tools they need for self-service analytics and free-form discovery while remaining monitored and controlled” to enable data-driven insight and compliance.
  • Business people are becoming accustomed to creating their own visual and predictive analyses without waiting for IT to build reports or models for them. Here the opportunity is to create an internal community where best practice visualizations and models are shared among users.
  • The learning curve for self-service solutions is dramatically reduced, but there may still be a place for training on startup and best practices.
  • The concept of the Service Level Agreement (SLA) takes on new meaning in the cloud era. Uptime becomes the responsibility of the PaaS or SaaS service provider, whether public or private cloud. IT’s role in providing data quality and security becomes more critical.

While the Analytics Center of Excellence needs to adapt to cloud and self-service, it can still provide structure, collaboration, and value.

For more information about Oracle’s Center of Excellence, review our whitepaper on Data Discovering and the Transformation of Business Analysis.

Source: https://blogs.oracle.com/analyticscloud/the-center-of-excellence-in-the-era-of-self-service-analytics

 

 

 

June 15, 2017 Webcast: Testing E-Business Suite with Flow Builder
NEWS AND UPDATES

Webcast: Testing E-Business Suite with Flow Builder

By: Steven Chan| Senior Director

Oracle University has a large number of free recorded webcasts that EBS sysadmins might find useful.  Here’s another good webcast on our testing tools:

Mazen Arar, Senior Director EBS Quality Assurance, provides an overview of how the Quality Assurance team tests Oracle E-Business Suite. It covers main areas that you should consider during functional testing, approaches for new-feature and regression testing, how to reduce the test script generation and execution time, experiences on capturing and presenting metrics to showcase the ROI of testing investment, leveraging automation for testing Oracle E-Business Suite applications and more. This material was presented at Oracle OpenWorld 2016.

Related Articles

Source:https://blogs.oracle.com/stevenchan/webcast%3a-testing-e-business-suite-with-flow-builder

 

 

 

June 14, 2017 How to Create a Read-Only APPS Schema?
Installations/Configurations-ApplicationsOracle APPS DBA

How to Create a Read-Only APPS Schema?

 

We are going to create a schema similar to the APPS schema having only read-only privileges.

 

Step 1. Create the user for the required schema:

  • SQL> connect system/manager
  • SQL> create user <your_user> identified by <your_user_password> default tablespace;
  • SQL><tablespace_to_assign_to_user> temporary tablespace temp;

 

Step 2. Grant connect and resource privileges to your user:

  • SQL> connect system/manager
  • SQL> grant connect, resource to <your_user>;

 

Step 3. Use the following select statement to generate a script that will grant privileges on APPS objects to your User.

This select statement would generate a script that will grant almost all required permissions to a user called READONLY.

SELECT 'GRANT ' 
       || Decode(O.object_type, 'TABLE', 'SELECT', 
                                'VIEW', 'SELECT', 
                                'EXECUTE') 
       || ' ON ' 
       || Decode(O.owner, 'PUBLIC', '', 
                          O.owner 
                          || '.') 
       || '"' 
       || O.object_name 
       || '"' 
       || ' TO MYUSER;' COMMAND 
FROM   all_objects O 
WHERE  O.object_type IN ( 'TABLE', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 
                          'VIEW', 'FUNCTION' ) 
UNION 
SELECT 'GRANT ' 
       || Decode(O2.object_type, 'TABLE', 'SELECT', 
                                 'VIEW', 'SELECT', 
                                 'EXECUTE') 
       || ' ON ' 
       || Decode(O.owner, 'PUBLIC', '', 
                          O.owner 
                          || '.') 
       || '"' 
       || O.object_name 
       || '"' 
       || ' TO READONLY;' COMMAND 
FROM   all_objects O, 
       all_objects O2, 
       dba_synonyms S 
WHERE  O.object_type = 'SYNONYM' 
       AND O.object_name = S.synonym_name 
       AND O2.object_name = S.table_name 
       AND O2.object_type IN ( 'TABLE', 'PACKAGE', 'PACKAGE BODY', 'PROCEDURE', 
                               'VIEW', 'FUNCTION' )

 

Now, Use the following select statement to generate a script that will create synonyms in <your_user> schema for all objects owned by APPS.

SELECT ‘CREATE SYNONYM MYUSER.’ || O.OBJECT_NAME || ‘ FOR APPS.’ || O.OBJECT_NAME || ‘;’ COMMAND FROM DBA_OBJECTS O WHERE O.Owner = ‘APPS’

 

Run the above two scripts as SYS user.

 

 

 

June 12, 2017 How to get table information? How to get About this Page link in OA page in R12
Installations/Configurations-ApplicationsOracle APPS DBA

How to get table information? How to get About this Page link in OA page in R12

How to find supplier related view / table information in web page environment?

Step 1. Navigate to the Supplier Page

Step 2. Click on the About this page link

Step 3. Click Expand All

Step 4. You will be seeing SuppSrchVO, SupplierVO and SitesVO

Step 5. If you click on that view it will show you the query used.

How to get the About this Page link in OA page?

To get the About this Page Link, Please ensure the below Profile option is set to Yes at site level:

  • FND: Diagnostics
  • System Administrator > Profile > System

The FND: Diagnostics profile option controls whether the Diagnostics button is rendered.

It also controls the display of the About this Page link.

You may also set below

  • Personalize Self-Service Defn : Yes
  • FND: Personalization Region Link Enabled : Yes 
  • FND: Diagnostics : Yes

 

Add the below responsibilities to the user:

System Administrator > Security > User > Define

  • FND Html Forms
  • Functional Administrator
  • Functional Developer

1. Once done bounce the apache

2. Retest the issue

3. Migrate the solution to other environments as appropriate.

 

 

June 12, 2017 Unable to locate ‘make’ utility in path
APPS DBAErrors/Workarounds-Applications

ERROR

Unable to locate ‘make’ utility in path

Issue :

bash-3.2$ perl adcfgclone.pl dbTechStack

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.7.1202010.2

Enter the APPS password :

Checking for make…
 Unable to locate ‘make’ utility in path
 Checking for ld…
 Unable to locate ‘ld’ utility in path
 Checking for ar…
 Unable to locate ‘ar’ utility in path
 Unable to locate all utilities with system path.

 PATH = /u01/apps/Test/11.2.0/appsutil/clone/bin/../jre/bin:/usr/bin:/bin
WARNING: Could not find all the required OS utilities in the $PATH. Please review the checks above

 

 

SOLUTION

1.export PATH=/usr/ccs/bin:$PATH

2. Now, Run perl adcfgclone.pl dbTechStack

 

 

June 10, 2017 Is it Possible to Run Patch Wizard Offline?
NEWS AND UPDATES

Is it Possible to Run Patch Wizard Offline?

By: Steven Chan| Senior Director

Patch Wizard helps you identify useful or critical missing patches for your EBS environment.

Many of the largest EBS customers run their environments where external network connectivity is extremely limited or non-existent.  The latter architectures are sometimes “air gapped” from external networks for maximum security.

Patch Wizard identifies missing patches by comparing them to the Patch Information Bundle (a.k.a. “InfoBundle”), a master repository of the latest available patches. It is still possible to run Patch Wizard even if your environment is air-gapped.  You need to download the Infobundle file or the patches you wish to analyze from Oracle’s Support Portal using a system that has network access to Oracle Support.  Once you’ve downloaded those files, you can move them to your secure or isolated EBS environment manually.

For more details about running Patch Wizard in network-isolated EBS environments, see:

References

Related Articles

Source: https://blogs.oracle.com/stevenchan/is-it-possible-to-run-patch-wizard-offline

 

 

Contact

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