Oracle E-Business SCM -Sales Implementation and Support
Al Jomaih Bottling Plant
مجموع سنوات الخبرة :7 years, 8 أشهر
With al jomaih bottling as Oracle SCM and Sales implementation fucntionl from Nov 2014 to Present
Job Profile:
International Refreshment Company (IRC) Riyadh November-2014-Till Date Role: Order Management Implementation and Support Responsibilities: Involved in implementation and testing of Oracle Applications OM module. • Involved in requirement gathering and analysis and design of the application. • Worked with the client team to understand the current Business Process. • Developed test plans and scripts and conducted testing for quality assurance. • Working on different transaction setups, pricing issues and customer Acceptance. • Worked on Setting Instances for new acquisitions. • Working on post upgrade support and interacting with Business users on Issue resolutions. • Working with the developers on developing conversions, reports • Prepared Module design ( BP80, BR100, MD050, TE40) Documents for Customizations. • Developed Reports in OM • Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access. • Created and maintained User Menu objects. • Created responsibilities assigned to users and set profile option
PROJECT# 1 Oct' 07 - Oct' 09
Oracle Technical Consultant, Virinchi Technologies - Hyderabad.
Oracle EBS Implementation & Support:
Project Description:
Project: JDSU, Implementation and Production Support
Client: JDSU - Milpitas, California
URL: jdsu.com
Team Size: 11
Solution Environment: Oracle Applications11i (11.5.7, 11.5.10), Oracle 9i, SQL,
PL/SQL, Report Builder6i, Toad
Role: Technical Consultant
JDSU is the world wide leading provider of broadband test & management solutions, communications, commercials, and consumer market. This company offers test and measurement system and services for communications service providers, cable operators, and network equipments, modules and subsystems for optical communication, display, security, medical/environmental, instrumentation, declarative, aerospace, and defense applications. The objective of the project is maintenance and support to the company
Responsibilities: Conducted informal training for the business owners and stakeholders to introduce them to the functionality offered by Oracle Order management Suite, and provided concise responses to their precise inquiries and questions, in a timely and lucid fashion.
Analyzed, designed, and configured fully automated processes. In addition created and developed the configuration documentation for the client to leverage in their training.
Interfaces: Customer Interface where customer information is dump from flat file.
Other Activities
✓ Actively involved in ongoing day to day Production Support activities / issues and providing problem solutions to Tickets.
✓ Identification of the problem, analyze the problem and finding viable solution to the same
✓ Analyze Functional/Technical Specifications of the business requirements.
✓ Developing Data/Bug Fixes.
✓ Working with Oracle Metalink Team for any Bug fix or applying the Patch
✓ Working with Alerts and form personalization
✓ Developing Data extraction scripts.
✓ Extensively worked on PL/SQL packages, procedures and functions to use in Interfaces
✓ Responsible for Enhancements.
✓ Responsible for migrating patches using PVCS and Kintana Migrator.
✓ Development of Technical Specification Design Document.
✓ Involved in 64-BitTesting.
✓ Responsible for creating and modifying AOL objects.
✓ Triaging of I-support tickets
PROJECT# 2 June' 07 - sep' 07
Developer, Virinchi Technologies - Hyderabad.
Project Description:
Project: CKNG, Implementation and Support
Client: CKNG
Team Size: 12
Solution Environment: JSP, Oracle 9i, SQL, PL/SQL, SQL Developer, windows
NT/XP
Role: Developer (Oracle 9i)
STAR (Q fund) is an on line Payday loan application that helps Payday Loan companies to web enables their existing business processes. This is re engineers for their existing data model to develop a web based application for the Point of Sale operations of CKNG. This system would enable the users to work on the centralized platform. The solution is to be accessed by around 2000 branches spread across USA and enable conducting transactions online. The solution delivered is a highly robust flexible solution, which in corporate the complex laws and there variations among the various states of the country.
The solution has been built based on the expertise of some of the leading industry professionals with extensive domain and operational experience. Star covers a wide array of functionality primarily required to automate and migrate the entire business process onto the web.
Technical Responsibilities:
✓ Provide constraints on tables for avoiding data duplication
✓ Generated triggers on tables for security
✓ Provided sequence and indexes on primary key (cust no)
✓ Writing PL/SQL blocks, Procedures, Functions, Packages, Triggers etc.
• Bachelor of technology in Information Technology Engineering From Jawaharlal Nehru Technological University • Oracle developer (9i), OCA oracle certified Associate