Oracle cloud SCM
SMSA
Total years of experience :15 years, 5 Months
20 August 2013 to till date: SMSA Express Transportation Co. Riyadh, KSA,
Project: Oracle supplies chain management: Working in Oracle supply chain management
Handling Oracle cloud fusion inventory module task, know how to configure and setup inventory module,
, Procurement Setup, OM, Warehouse, Purchasing, And module integration with OM, AR, WIP, BOM, and WS within the Oracle cloud fusion. Setup inventory And bringing the item into inventory. Item category Assignments and Product attribute from PIM (Product Information Management System).
Included having the assistance for making the required setups and also handling the request for schedule the jobs that are to be run and monitoring them on a period basis.
Preformed all setups for OM, Shipping, and advance pricing, Purchasing, INV and other related modules.
Application Setup of inventory Organization: Setup of inventory locations, sub- Inventory activity, item rel
Relationships, shipping networks, Transaction source and warehouse management etc. Purchasing
Module profile, receiving and financial options, location, job and position Flex Fields. Business requirement
Study and designed / documented Functional specification. Identified gap & put collaborative efforts with the technical team to address the same through technical Specification. Prepare the Configuration Document. Coordinated activities with implementation team on creating test plan & Documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated Discussions with end-users /
Managers to gather functional requirements. Pricing Business Requirement Study and designed /
Documented Functional. Conducting Pre Project Review & Post Project Review. Providing Post Implementation support Knowledge with Approvals Management, Create Oracle Service request
AYT Electrical Co., Riyadh 1-May-2010 to 15 August-2013
Project Detail : AYT was incorporated in Dubai, UAE, in 2001 primarily fulfill the Need of one stop solution of the customers the Middle East and North Africa (MENA) for all equipments and its testing and diagnostic systems. it has tied with With world reputed manufacturers and services providers who relentlessly support its vision and mission to achieve better client satisfaction.
Client name: AYT Group.
Project: Maintenance & support for Oracle Apps DBA.
Key Role & Responsibilities:
Manage 8 database instances for our prestigious AYT group including production, development, & testing databases. Size of databases ranges between 10GB to 1TB running on 10g, 11g version of Oracle. Databases are running on all flavors of UNIX ranging from HP, Linux and MS. Windows platforms. Availability of database 24* 7.
Oracle administration of 10g and 11g databases, Backup Oracle database using RMAN,
Performance tuning of oracle database (memory and queries). Oracle 10gR2 RAC setup,
Installation and implementation on Red hat enterprise Linux, involved in implementation of
RAC cluster ware, ASM (storage) and database level. Setting up ASM instances creating disk group, adding deleting instances.
Implementation & installation of Oracle Business suite R12 - R12.1.1 and R12.1.2. cloning
Oracle Application e-business suite R12, setting up database and Application database backup-online and cold using RMAN. Applying recommended Upgrade Patches as well as
Security patches to the oracle databases. Migration & Up gradation of Oracle database,
database cloning with cold backup, hot backup as well as RMAN tape backup.
Managing a high-end critical production Oracle Database and a Disaster Recovery Site.
General database management, Apply Health checks for database performance
Database Creation, Space Management and Database reorganization and User’s Schemas.
Oracle RDBMS 10, 11g, SQL*Net, Oracle Enterprise, Manager Export/Import Management
Database performance tuning, Troubleshooting database issues, Capacity Planning for Table spaces. Developing and implementing strategies for database security
Responsible for Monitoring &providing online support to the branch offices, Oracle Database Monitoring for Performance and Space utilization Performance Tuning of the database
Server Up-gradation and Disaster & Recovery implementation.
Miracle Valley, India, 07-Jan-2009 to 09-April-2010
Project Detail: HMRI Hospital is an initiative of the Paras Hospital Group and is a multi-specialty tertiary care Institute with over 25 medical and surgical discipline. it is a 350 bedded facility with hi-tech Infrastructure and state-of-the-art equipments, offering clinical services in the fields of Oncology, Cardiology, Neurosciences, Orthopedics & Joint Replacement, Neurology, and Emergency Care to name a few. Spread across the area of
3, 25, 00 sq ft, the hospital not only provide advanced cancer and Cardiac facilities to more than sixty lac people of Patna, Bihar, but also caters to population In adjoining areas of Uttar Pradesh, Jharkhand, Nepal & Bangladesh.
Client : Hai Medicare & Research Institute (HMRI, Patna
Project: Maintenance & support for Oracle 9i/10g databases.
Key Role & Responsibilities:
Involved in DBA activities, supporting Production Environments, Installation, creation and
Support oracle 9i/10g databases in production environments. Monitoring databases, which
Include basic health check, growth of objects, performance of the database and giving
Recommendation how to resolve it.
Performing status checks by monitoring the Alert log, trace files of the database. Looking into
Action request (tickets) and resolving issues, providing the root cause, providing the permanent
Fix. Performing backup and restoration. creating new database under various environments
monitoring the table spaces periodically for growth, table spaces management, user creation,
privilege roles etc. establishing Schedulers for various database backups, automated hot
Backups using a Combination of incremental, differential & full RMAN backups. shell scripting for different type of job scheduling.
Participating with Senior team to tracing, troubleshooting, database performance & tuning
Issues. On call support 24x7.
Environment: Oracle Server 9i/10g, Windows, Linux.
Oracle 11g Certified Professional (OCP 1Z0-034) from Delhi, India) Oracle 9i Certified from SQLSTAR INTERNATIONAL Training Center (Hyderabad, India) •Oracle 9i Database Administration Certified Associate (OCA). •Oracle 9i Database Administration Certified Professional (OCP). Training: Got training for Oracle DBA from SQLSTAR INTERNATIONAL (Hyderabad, India) Red Hat Enterprise Linux (RHEL5) from SQLSTAR INTERNATIONAL (Hyderabad, India) • Red Hat Certified Technician (RHCT) • Red Hat Certified Engineer (RHCE). (805009316540962) Training: Got training for Linux System Administrator from SQLSTAR INTERNATIONAL
Degree Master of Computer Application (MCA) with 1st Div, India. Degree Bachelor of Computer Application (BCA) with 1st Div, India.