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 24, 2017 Using Patch Wizard to Identify Files Affected by Specific Patches
NEWS AND UPDATES

Using Patch Wizard to Identify Files Affected by Specific Patches

By: Steven Chan| Senior Director

Patch Wizard compares your EBS environment against a list of all recommended EBS patches. It creates a list of high-priority patches that your environment is missing.

You can use Patch Wizard to assess the impact of a specific patch on your environment.  Patch Wizard can report on a variety of areas, including:

  • The applications patched
  • File types installed
  • New files introduced
  • Existing files that are changed
  • Flagged files that are changed
  • Menu navigation trees affected — responsibilities that lead to patched functionality

Patch Wizard doesn’t have the ability to analyze business logic in the affected files, so it cannot report on functionality that is affected by new files delivered by a given patch.  You can review a patch’s README to see if there are functional changes introduced by a patch.

References

Related Articles

Source:https://blogs.oracle.com/stevenchan/using-patch-wizard-to-identity-files-affected-by-specific-patches

 

 

June 23, 2017 Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.

 

(more…)

June 23, 2017 APP-PAY-06882: Assertion failure detected at location py3vntsetup:2
Accounts PayablesAPPS DBAErrors/Workarounds-APErrors/Workarounds-ApplicationsOracle Functional

ERROR

Error while Payroll processing:-

HR_6882_HRPROC_ASSERT
LOCATION py3vntsetup:2
APP-PAY-06882: Assertion failure detected at location py3vntsetup:2.

(more…)

June 22, 2017 Oracle Application Implementation Methodology (AIM) Document List
Accounts PayablesAccounts ReceivablesCash ManagementFixed AssetsGeneral LedgerOracle Functional

Oracle Application Implementation Methodology (AIM) Document List

 

1.Business Process Architecture (BP)

  • BP.010 Define Business and Process Strategy 
  • BP.020 Catalog and Analyze Potential Changes 
  • BP.030 Determine Data Gathering Requirements 
  • BP.040 Develop Current Process Model 
  • BP.050 Review Leading Practices 
  • BP.060 Develop High-Level Process Vision 
  • BP.070 Develop High-Level Process Design 
  • BP.080 Develop Future Process Model 
  • BP.090 Document Business Procedure 

 

2. Business Requirements Definition (RD)

  • RD.010 Identify Current Financial and Operating Structure 
  • RD.020 Conduct Current Business Baseline 
  • RD.030 Establish Process and Mapping Summary 
  • RD.040 Gather Business Volumes and Metrics 
  • RD.050 Gather Business Requirements 
  • RD.060 Determine Audit and Control Requirements 
  • RD.070 Identify Business Availability Requirements 
  • RD.080 Identify Reporting and Information Access Requirements 

 

3. Business Requirements Mapping

  • BR.010 Analyze High-Level Gaps 
  • BR.020 Prepare mapping environment 
  • BR.030 Map Business requirements 
  • BR.040 Map Business Data 
  • BR.050 Conduct Integration Fit Analysis 
  • BR.060 Create Information Model 
  • BR.070 Create Reporting Fit Analysis 
  • BR.080 Test Business Solutions 
  • BR.090 Confirm Integrated Business Solutions 
  • BR.100 Define Applications Setup 
  • BR.110 Define security Profiles 

 

4. Application and Technical Architecture (TA)

  • TA.010 Define Architecture Requirements and Strategy 
  • TA.020 Identify Current Technical Architecture 
  • TA.030 Develop Preliminary Conceptual Architecture 
  • TA.040 Define Application Architecture 
  • TA.050 Define System Availability Strategy 
  • TA.060 Define Reporting and Information Access Strategy 
  • TA.070 Revise Conceptual Architecture 
  • TA.080 Define Application Security Architecture 
  • TA.090 Define Application and Database Server Architecture 
  • TA.100 Define and Propose Architecture Subsystems 
  • TA.110 Define System Capacity Plan 
  • TA.120 Define Platform and Network Architecture 
  • TA.130 Define Application Deployment Plan 
  • TA.140 Assess Performance Risks 
  • TA.150 Define System Management Procedures 

 

5. Module Design and Build (MD)

  • MD.010 Define Application Extension Strategy 
  • MD.020 Define and estimate application extensions 
  • MD.030 Define design standards 
  • MD.040 Define Build Standards
  • MD.050 Create Application extensions functional design 
  • MD.060 Design Database extensions 
  • MD.070 Create Application extensions technical design 
  • MD.080 Review functional and Technical designs 
  • MD.090 Prepare Development environment 
  • MD.100 Create Database extensions 
  • MD.110 Create Application extension modules 
  • MD.120 Create Installation routines 

 

6. Data Conversion (CV)

  • CV.010 Define data conversion requirements and strategy 
  • CV.020 Define Conversion standards 
  • CV.030 Prepare conversion environment 
  • CV.040 Perform conversion data mapping 
  • CV.050 Define manual conversion procedures 
  • CV.060 Design conversion programs 
  • CV.070 Prepare conversion test plans 
  • CV.080 Develop conversion programs 
  • CV.090 Perform conversion unit tests 
  • CV.100 Perform conversion business objects 
  • CV.110 Perform conversion validation tests 
  • CV.120 Install conversion programs 
  • CV.130 Convert and verify data 

 

7. Documentation (DO)

  • DO.010 Define documentation requirements and strategy 
  • DO.020 Define Documentation standards and procedures 
  • DO.030 Prepare glossary 
  • DO.040 Prepare documentation environment 
  • DO.050 Produce documentation prototypes and templates 
  • DO.060 Publish user reference manual 
  • DO.070 Publish user guide 
  • DO.080 Publish technical reference manual 
  • DO.090 Publish system management guide 

 

8. Business System Testing (TE)

  • TE.010 Define testing requirements and strategy 
  • TE.020 Develop unit test script 
  • TE.030 Develop link test script 
  • TE.040 Develop system test script 
  • TE.050 Develop systems integration test script 
  • TE.060 Prepare testing environments 
  • TE.070 Perform unit test 
  • TE.080 Perform link test 
  • TE.090 perform installation test 
  • TE.100 Prepare key users for testing 
  • TE.110 Perform system test 
  • TE.120 Perform systems integration test 
  • TE.130 Perform Acceptance test 

 

9. PERFORMANCE TESTING (PT)

  • PT.010 – Define Performance Testing Strategy 
  • PT.020 – Identify Performance Test Scenarios 
  • PT.030 – Identify Performance Test Transaction 
  • PT.040 – Create Performance Test Scripts 
  • PT.050 – Design Performance Test Transaction Programs 
  • PT.060 – Design Performance Test Data 
  • PT.070 – Design Test Database Load Programs 
  • PT.080 – Create Performance Test TransactionPrograms 
  • PT.090 – Create Test Database Load Programs 
  • PT.100 – Construct Performance Test Database 
  • PT.110 – Prepare Performance Test Environment 
  • PT.120 – Execute Performance Test 

 

10. Adoption and Learning (AP)

  • AP.010 – Define Executive Project Strategy 
  • AP.020 – Conduct Initial Project Team Orientation 
  • AP.030 – Develop Project Team Learning Plan 
  • AP.040 – Prepare Project Team Learning Environment 
  • AP.050 – Conduct Project Team Learning Events 
  • AP.060 – Develop Business Unit Managers’Readiness Plan 
  • AP.070 – Develop Project Readiness Roadmap 
  • AP.080 – Develop and Execute CommunicationCampaign 
  • AP.090 – Develop Managers’ Readiness Plan 
  • AP.100 – Identify Business Process Impact onOrganization 
  • AP.110 – Align Human Performance SupportSystems 
  • AP.120 – Align Information Technology Groups 
  • AP.130 – Conduct User Learning Needs Analysis 
  • AP.140 – Develop User Learning Plan 
  • AP.150 – Develop User Learningware 
  • AP.160 – Prepare User Learning Environment 
  • AP.170 – Conduct User Learning Events 
  • AP.180 – Conduct Effectiveness Assessment 

 

11. Production Migration (PM)

  • PM.010 – Define Transition Strategy 
  • PM.020 – Design Production Support Infrastructure 
  • PM.030 – Develop Transition and Contingency Plan 
  • PM.040 – Prepare Production Environment 
  • PM.050 – Set Up Applications 
  • PM.060 – Implement Production Support Infrastructure 
  • PM.070 – Verify Production Readiness 
  • PM.080 – Begin Production 
  • PM.090 – Measure System Performance 
  • PM.100 – Maintain System 
  • PM.110 – Refine Production System 
  • PM.120 – Decommission Former Systems 
  • PM.130 – Propose Future Business Direction 
  • PM.140 – Propose Future Technical Direction

 

 

 

June 21, 2017 Whitepaper: E-Business Suite Upgrade Sizing and Best Practices
NEWS AND UPDATES

Whitepaper: E-Business Suite Upgrade Sizing and Best Practices

By: Steven Chan | Senior Director

One of the most-common questions we see revolves around sizing for EBS upgrades — that is, the amount of resources required when upgrading from one EBS release to another. It is difficult to make general statements about these types of requirements that apply uniformly to all customer environments, since every customer’s database size, product usage mix, and concurrent end-user loads vary dramatically.

That said, our Applications Performance Group has published a whitepaper that describes an EBS 12.1.3 to EBS 12.2 upgrade:

The upgrade scenario covers a 456 GB database prior to the upgrade, and compares the application tier sizes before and after the upgrade.  Individual tablespace requirements are listed in detail.

Related Articles

Source: https://blogs.oracle.com/stevenchan/whitepaper%3a-e-business-suite-upgrade-sizing-and-best-practices

June 20, 2017 APP-OFA-47333: You Cannot Perform this transaction
Errors/Workarounds-FAFixed AssetsOracle Functional

ERROR

APP-OFA-47333: You Cannot Perform this transaction because the asset is fully retired. Choose a book in which you have not yet retired the asset, or reinstate the asset, and then perform the transaction. If you wish to cancel or undo the retirement, Please query it first.

 

SOLUTION

Step 1. Navigate to Inquiry > Transaction History.

Step 2. Enter the Book & Asset Number.

Step 3. Press the Find button.

Step 4. Click the Transaction type field for the Retired Asset.

Step 5. Note the Reference Number.

Step 6. Go to the Asset Workbench and query the Asset.

Step 7. Click the Retirements button.

Step 8. As the Retirements screen is displayed:

a. Press F11 to query or select Query>Enter on the menu bar.

b. Enter the Reference Number noted above.

c. Press CTRL F11 to perform the query or select Query>Run from the menu bar.

Step 9. As information appears on the screen, verify if it is correct and press the Reinstate button.

Step 10. Run the Calculate Gains and Losses program.

(more…)

Contact

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