...Professional Summary: • Over 6 years of professional experience as Oracle EBS R12/11i Technical and Functional Consultant with expertise in Oracle Financials modules (GL, AP, AR, FA and PA), Manufacturing Modules (OM, INV, Shipping, BOM, WIP, PO). • Good expertise in RICE (Reports, Interfaces, Conversions, Extensions) components. • Good knowledge in Order to Cash (O2C) and Procure to Pay (P2P) business flows. • Excellent knowledge of AOL (Application Object Library)/FND and System Administration Modules. • Experience in creating and customizing existing reports using BI and Reporting Tools like Oracle Discoverer, Reports 10g/6i/4i and XML/BI Publisher tools. • Good technical development skills in developing Reports, Interfaces, Conversions and Extensions (RICE components) in the domain of Oracle Applications E-Business Suite. • Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader etc. • Strong experience in Data Conversions and Design/Development of Interfaces using Oracle open interfaces and Oracle Public API’s. • Very Good understanding of Trading Community Architecture (TCA). • Familiar with Oracle Applications Framework (OA) technology, especially with personalization of existing OA Framework pages. • Experience in Application System Administration activities like managing concurrent managers, defining responsibilities...
Words: 2129 - Pages: 9
...Biodata * Using Informatica Designer designed and developed Source Entities for Oracle, COBOL files and Target warehouse Entity for Oracle. * Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation and Maintenance. * Extracted the data from different sources like COBOL Files, Flat files (delimited & fixed width) and Oracle. * Used the SQL Loader for extracting the data from Flat Files into Oracle. * Experience in PL/SQL programming, Developing Packages, stored procedures, Functions and Triggers. * Experience in developing business applications using Oracle 11g/10g/9i, Oracle Forms10g/9i, Reports10g/9i, SQL, PL/SQL, SQL*Loader and Open Interface. * Expertise in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports) and other front-end tools. * Expert in writing Cursors and Handling Exceptions while developing the applications. * Experienced in Project planning and scheduling, System design, Functional Specification, Design specification, Coding and System test plan. * Data cleansing experience using PL/SQL. SQL coding and UNIX. * Using Informatica Designer designed and developed Source Entities for Oracle, COBOL files and Target warehouse Entity for Oracle. * Involved in preparing Test Plans, Unit Testing, System Integration Testing, Implementation...
Words: 622 - Pages: 3
...success. Education (2003- 2007) Bachelor’s degree in computer information system from Jordan University with GPA: 3. 35 out of 4 (very good). Studying MBA at German Jordanian University -Talal abu Ghazaleh Graduate School of business (expected date to graduate 2014). Certifications/Exams Pass University achievement exam with rank 49 out of 906 students. Oracle DB 10g: oracle certified professional. Oracle DB 11g: oracle certified associate. Oracle E-Business Suite R12 Applications Database administrator certified professional. Oracle DB 10g: Managing oracle on Linux certified expert. Oracle E-Business Suite R12 system administrator certified expert. Pass Oracle enterprise linux fundmental exam as a prerequisite for oracle enterprise linux system administrator certified associate. Pass ITILV3 Foundation exam. Oracle DB 10g: Administering Real application clusters certified expert. Oracle DB: SQL Certified Expert. Professional Experience From To Title& Duties May 2011 Present @Umniah Senior database administrator Duties: Administration on Oracle E-business suite release R11.5.10.1 - Support/Maintain/Troubleshoot Umniah...
Words: 1191 - Pages: 5
...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL. Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database. 1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace. USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name. The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also included...
Words: 1424 - Pages: 6
...Critical Details about EBS R12 Upgrades Presented By Susan Behn VP, Oracle Practice Objectives/Agenda Provide a high level view of topics to consider when upgrading to R12 When is a “technical” upgrade possible What do I need to research more When is the right time for training What do I include in my budget/timeline Functional Topics Technical Topics 2 Overview Are you aware that… There are over 1500 new features in R12 A responsibility can now access data in multiple organizations R12.1 was released in April 2009 How does this impact custom Responsibilities How will all these new features be “discovered” Quicker data entry for shared services organizations The user interface to the Oracle Diagnostics scripts was rewritten in OA Framework in R12.0.6 12.0 focused on Financials 12.1 focused on everything else including HR Utilizes role-based access control requiring role grants from the user management responsibility Setup reports in diagnostics can help you find missing setups 3 FINANCIALS - GL 4 Financials - GL Legal Entities have significant functionality in R12 Should reflect legal corporate structure Utilized by Accounting Functions, E-Business Tax, Intercompany, and Bank Account Balancing segment is associated with legal entity – not ledger Bank account is owned by legal entity Align your Ledger structure with your business plan Operating units are associated...
Words: 3253 - Pages: 14
...TERM PAPER ON Information System of Standard Bank Limited [pic] Submitted To: Dr. Md. Mosharraf Hossain Professor Department of Management University of Dhaka Submitted By: Sabbir Ahmed 3-11-21-065 Department of Management University of Dhaka Date of Submission 09.11.2014 Preface Theoretical knowledge, what we learn through our academic activities, is not sufficient to prepare ourselves for the life battle. Academic knowing is needed to be backed up by practical experience. In business studies, besides their usual theoretical course works, students are required to fulfill some practical assignments which are set by the course teachers to examine the depth of knowledge learned by the students. Most of the time, the students are required to study a practical working environment of any organization or industry to critically examine ‘what is actually going on’ in the real world. This document is prepared as a result of an assignment set by the honorable course teacher of the course “Fundamental of MIS”. .My duty was to describe “Information System of My Organization.” and report what I found. This is how this assignment paper titled “Information System of Standard Bank Limited.” was emerged. I believe this paper is a reflection of accumulation of my effort, learning and dedication. Letter of Transmittal November 8, 2014 Dr. Mosharraf Hossain Professor MBA (Evening) Program Department...
Words: 1837 - Pages: 8
...Upgrade of Oracle Business Intelligence Edition Enterprise (OBIEE 10G) Reporting Tool to OBIEE 11G at Econet Wireless (PVT) LTD Paddy Mutimusakwa Managerial Applications of Information Technology DeVry University - Keller Graduate School of Management February, 2015 Table of Contents Abstract 3 Brief Company background 4 Discussion of business problem(s) 5 Business/Technical Approach 6 Benefits of solving the problem 7 Business process changes 8 Technology or business practices used to augment the solution 8 - 9 High-level implementation plan 9-10 Conclusions and overall recommendations 11 References 12 Abstract With technology changing so rapidly, it is important that companies stay abreast of these changes to remain competitive. Econet Wireless, with its global presence cannot afford to ignore this fact hence the need for an upgrade to its current systems. With the utilization of the older version of OBIEE, Econet is not able to process most of its requests thereby affecting overall business performance and productivity. It is with this realization that an upgrade be done on the current software to satisfy company needs. Econet has been using OBIEE 10G as its reporting tool since the company started operating...
Words: 2308 - Pages: 10
...Brian Morgan James.Neiman CIS 111 Benefits of a Database and Information-Gathering Techniques April 28, 2012 Benefits of a Database and Information-Gathering Techniques Database: Database is the collection of data or information, so that it can be easily fetched, managed and update. In database data or information is stored in the forms of tables. Each table in a database has it unique name and table duplication is not allowed. Example of database: Oracle 10g, MySQL, SQL Server, IBM DB2 etc. DBMS terms refer to the database management system. A database management system (DBMS) is a collection of software application package with some computer programs that are used to store, create, fetch, modify and extract the information from the database. Each DBMS system has some set of rules and pre-defined paradigm on which each database is working. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes or Solaris servers. Some of the example of DBMS is 1.> Air lines flight management system. 2.> Employee’s payroll management system for an organization. 3.> Inventory management system for warehouse operations. 4.> Student management system for Schools and Colleges. Advantages of DBMS 1.> It reduces the data redundancy (duplicate data in the database). 2.> Scalable: DBMS systems are highly scalable i.e. these systems can be scaled to store more data as required in...
Words: 777 - Pages: 4
...Oracle DBA Interview Questions and Answers Compiled By Mohamed Fowjil Abdul Hameed Contents Oracle DBA Interviews - Overview 2 Oracle DBA Interview Questions and Answers – ARCHITECTURE 4 SENIOR ORACLE DBA INTERVIEW QUESTIONS 31 MID LEVEL ORACLE DBA INTERVIEW QUESTIONS 57 Oracle 11g Database New Features Interview Questions and Answers 65 Oracle RAC Interview Questions and Answers 70 Oracle RAC Interview Questions (10g) Questions and Answers 137 Oracle Data Guard Interview Questions and Answers 168 Oracle ASM Interview Questions and Answers 205 Oracle Patching,Cloning and Upgrade Interview Questions and Answers 219 Oracle Backup and Recovery Interview Questions and Answers 228 Oracle RMAN Interview Questions and Answers 232 Oracle Performance Tuning Interview Questions and Answers 237 Oracle Performance Tuning Interview Questions and Answers 245 Oracle Export/Import (exp/imp)- Data Pump (expdp/imp) Interview Questions and Answers 249 UNIX Interview Questions and Answers for Oracle DBAs 254 Oracle DBA Interviews - Overview Dear Readers, Hereby, I am sharing my experience of interviews asd technical discussion with various MNC Dba’s, Project managers and Project delivery managers and Technical architects, as part of my interview preparation, I used to refer my own work note as well as web sources below details are a consolidate form of my interview preparation and Oracle dba interviews questions and answers General Guide line:...
Words: 97621 - Pages: 391
...A white paper prepared with Oracle and IBM technical collaboration March 2010 Oracle Real Application Clusters on IBM AIX Best practices in memory tuning and configuring for system stability Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability Executive Overview ........................................................................... 2 Introduction ....................................................................................... 2 Problem validation ......................................................................... 3 Examining the AIX Error Logging................................................... 3 Examining the Oracle oprocd logging ............................................ 4 Recommendations for system stability............................................... 5 1. Implement AIX tuning recommendations for Oracle ................... 5 2. Modify Oracle ‘diagwait’ parameter............................................ 6 3. Install the required updates and patches ................................... 8 4. Reduce heavy paging activity. ................................................. 11 Appendix A: Oprocd logging examples ............................................ 14 Clean oprocd log files .................................................................. 14 Oprocd log files showing scheduling delays................................. 14 Oprocd log files after a node reboot or CRS restart .................
Words: 4075 - Pages: 17
...Database: Database is the collection of data or information, so that it can be easily fetched, managed and update. In database data or information is stored in the forms of tables. Each table in a database has it unique name and table duplication is not allowed. Example of database: Oracle 10g, MySQL, SQL Server, IBM DB2 etc. DBMS terms refer to the database management system. A database management system (DBMS) is a collection of software application package with some computer programs that are used to store, create, fetch, modify and extract the information from the database. Each DBMS system has some set of rules and pre-defined paradigm on which each database is working. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes or Solaris servers. Some of the example of DBMS is 1.> Air lines flight management system. 2.> Employee’s payroll management system for an organization. 3.> Inventory management system for warehouse operations. 4.> Student management system for Schools and Colleges. Advantages of DBMS 1.> It reduces the data redundancy (duplicate data in the database). 2.> Scalable: DBMS systems are highly scalable i.e. these systems can be scaled to store more data as required in the future. 3.> Multiple accesses: Database software allows data to be accessed by multiple users simultaneously without causing any locks in the database. 4.> Security: In...
Words: 290 - Pages: 2
...A framework to implement Data Cleaning in Enterprise Data Warehouse for Robust Data Quality Kamran Ali Mubeen Ahmed Warraich Department of Computer Sciences Shaheed Zulfikar Ali Bhutto Institute of Science and Technology Islamabad, Pakistan. kamranali100@hotmail.com Department of Computer Sciences Shaheed Zulfikar Ali Bhutto Institute of Science and Technology Islamabad, Pakistan. mubeen_warraich@yahoo.com Abstract— every day, every hour, every minute, every second trillion of bytes of data is being generated by enterprises especially in telecom sector. To achieve level best decisions for business profits, access to that data in a well-situated and interactive way is always a dream of business executives and managers. Data warehouse is the only viable solution that can bring that dream into a reality. The enhancement of future endeavors to make decisions depends on the availability of correct information that based on quality of data underlying. The quality data can only be produced by cleaning data prior to loading into data warehouse. So correctness of data is essential for well-informed and reliable decision making. The framework proposed in this paper implements robust data quality to ensure consistent and correct loading of data into data warehouse that necessary to disciplined, accurate and reliable data analysis, data mining and knowledge discovery. Significant amounts of time and money are consequently spent on data cleaning, the...
Words: 3437 - Pages: 14
...BUSINESS INTELLIGENCE DATA MINING Business intelligence is a computerized technique used is searching, storing and analyzing useful business information (http://en.wikipedia.org/wiki/Business_intelligence). Business intelligence is an increasing strategy employed by many modern ventures, in the attempt to providing quick access to information and helps the business in making appropriate decisions. Holistic information on ones business environment is an important tool, since it does not only shows your past trend, but also prepares the firm for the future improvements. This sets a challenge in establishing the methods to source for the information, and how to use this information to improve a business position . Data mining is the sourcing of any hidden and predictive business information from a relevant database. It involves a thorough analysis of data gained from various sources, manipulating it into useful tool - a tool that leads to raising business revenue, saving on the running costs or both (http://en.wikipedia.org/wiki/Data_mining). Data mining tool incorporates analytical tools that helps build a useful predictive relationship. Data mining tools helps get answers as it scrutinizes data from different perspective to a precision, than any expert could do. Interplay of data mining process with software and hardware utilities is a big step in data analysis. The integration of artificial intelligence and databases heightens the data-mining goal as the information is translated...
Words: 1904 - Pages: 8
...Database: Database is the collection of data or information, so that it can be easily fetched, managed and update. In database data or information is stored in the forms of tables. Each table in a database has it unique name and table duplication is not allowed. Example of database: Oracle 10g, MySQL, SQL Server, IBM DB2 etc. DBMS terms refer to the database management system. A database management system (DBMS) is a collection of software application package with some computer programs that are used to store, create, fetch, modify and extract the information from the database. Each DBMS system has some set of rules and pre-defined paradigm on which each database is working. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes or Solaris servers. Some of the example of DBMS is 1.> Air lines flight management system. 2.> Employee’s payroll management system for an organization. 3.> Inventory management system for warehouse operations. 4.> Student management system for Schools and Colleges. Advantages of DBMS 1.> It reduces the data redundancy (duplicate data in the database). 2.> Scalable: DBMS systems are highly scalable i.e. these systems can be scaled to store more data as required in the future. 3.> Multiple accesses: Database software allows data to be accessed by multiple users simultaneously without causing any locks in the database. 4.> Security: In...
Words: 290 - Pages: 2
...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and design...
Words: 1374 - Pages: 6