Preview

Jile La Obstacle

Powerful Essays
Open Document
Open Document
1824 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Jile La Obstacle
Summary: * 8+ years of experience in systems Analysis, design and development of complex software systems for various domains. * Good exposure of Software Development Life Cycle methods (waterfall etc.). * Extensive experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. * In-depth Knowledge of Oracle Architecture, Data Dictionary and DBMS Packages. * Performed a major role in database migration. * Expertise in creating database Triggers, Stored Procedures, Packages, functions, Indexes. * Strong knowledge in Oracle cursor management and exception handling. * Worked on DML, DDL, and TCLoperations. * Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems. * Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures. * Good working experience with the usage of Collections, Bulk Insert, Global temp table, Nested tables, External tables, advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors. * Strong Knowledge on Object oriented Programming. * Experience in developing the webpage using JSP, extensive experience on Java, Java script, Hibernate. * Experience in using Oracle in-built packages like UTL_FILE, DBMS_SQL etc. * Experience in designed and deployment of UNIX Shell Scripts. * Expert knowledge in using data modeling tools like ER-WIN and ER diagrams with Model mart exposure. * Extensive Knowledge in Normalization Techniques for designing database Relational technology on N-Tier and created database reports to monitor the project. * Experience in debugging the performance issues and bugs within packages, forms, and reports using dbms_output. *

You May Also Find These Documents Helpful

  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    This memo is to inform you that your service request SR-ta-001 has reached my desk and currently is in the process of being completed. The purpose of this memo is to report the progress on the service requests. Currently I am in the stage of normalizing the database to the third normal form. By normalizing the database to the third level of normalization I will ensure that the data is efficiently organized within the database by removing duplicate and redundant data from the database relations. Normalizing the data to the normal third will help free up space and make it easier for the users to retrieve the data by elimination of the same data stored in more than one relation. In addition, normalizing to this level will also ensure data integrity, scalability, and storage efficiency. I have made sure that that there are no repeating columns or rows within the same tables and each column has only one value and one data type therefore the level of 1 normalization has been completed. I then continued to normalize the database to the second level of normalization by ensuring that each nonkey attribute is fully dependent on the key columns of the table. Once level one and two normal form had been completed I continued by establishing primary and foreign keys along with relationships. I will keep in contact with you as the project nears completion.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Best Essays

    Even, A., & Shankaranarayanan, G. (2009). Quality in Customer Databases-Centered Review of Object Oriented Software Development Methodologies. ACM Computer Database, 15, 3,4,5. Retrieved September 12, 2013, from the ACM Computer database.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    Bibliography: (2012). Database systems: Design, implementation, and management. (10 ed.). United States of America: Joe Sabatino.…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Good Essays

    References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.…

    • 906 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Cis 111

    • 790 Words
    • 4 Pages

    The purpose of the E-R diagram is to provide an organization with a simple drawing that can be used to describe the organization’s data. The E-R model consists of three primary components…

    • 790 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    DBM 380 Syllabus

    • 623 Words
    • 4 Pages

    This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.…

    • 623 Words
    • 4 Pages
    Satisfactory Essays
  • Better Essays

    Term Paper Intro to I.T.

    • 1605 Words
    • 7 Pages

    Greenwald, R. (2011, November). Creating value with the oracle database cloud service. Retrieved from http://www.oracle.com/technetwork/database/database-cloud/public/extreme-productivity-wp-1844125.pdf…

    • 1605 Words
    • 7 Pages
    Better Essays
  • Best Essays

    The selected database I have chosen for this project will be that of a veterinary medical supply database and the veterinarians who order medications from that database. I will track what is ordered and shipped to the veterinarians. This is an online veterinary supply, so, all medications will be mailed (or shipped) to the customer with a…

    • 3587 Words
    • 15 Pages
    Best Essays
  • Satisfactory Essays

    Many legacy systems require normalization. Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization. Include in your discussion a detailed example on how each factor would eliminate data redundancy.…

    • 160 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    Is Oracle Dying?

    • 4256 Words
    • 18 Pages

    Oracle Corporation was founded in Jun 1977 by Larry Ellison, Bob Miner, Ed Oates. Over the years, it has risen to become almost indisputable leader of the Relational Database Management System (RDBMS) market with 44% (Source: IDC 2009) – at least, for now, though, no one is sure how long that numero uno position will last. There were heady days of 1996-2008 or so when Oracle ruled the world of RDBMS. It was unchallenged crown king that could do no wrong. Hundreds of thousands of Database engineers, architects, administrators spoke of Oracle as if it was actually the famed “Oracle of Delphi”. Conference passes to Oracle Open World were so coveted that it was distributed to star employees in any company using Oracle Products.…

    • 4256 Words
    • 18 Pages
    Powerful Essays
  • Powerful Essays

    Engro Food's Erp System

    • 7898 Words
    • 32 Pages

    References: Raguž , E. (2007) ERP Concept for Enterprise Management and Knowledge Management University of Dubrovnik Croatia…

    • 7898 Words
    • 32 Pages
    Powerful Essays
  • Good Essays

    5. Which of the following performance-enhancing features of the Oracle Database require specific initialization parameter settings to gain their benefits?…

    • 2701 Words
    • 21 Pages
    Good Essays