Scribd Logo
Upload

Welcome to Scribd!

  • 118 views

    Project Details

    Uploaded by

    manojkumar
    The document describes three projects worked on by the individual as a PL/SQL Developer. The first project was a Project Management Information System for Creed Global Consultancy from Dec 2014 to Apr 2015. It involved developing the backend code and database for a system to manage project lifecycles. The second project was for Product Lifecycle Management software called Teamcenter for the same client from Jun 2015 to present. Responsibilities included requirements gathering, database development, and testing. The third project was a Purchase Order System for BrainEye InfoTech from Jan 2016 to present, with roles such as database design, object creation, testing, and documentation.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Project Details

    Uploaded by

    manojkumar
    118 views4 pages
    The document describes three projects worked on by the individual as a PL/SQL Developer. The first project was a Project Management Information System for Creed Global Consultancy from Dec 2014 to Apr 2015. It involved developing the backend code and database for a system to manage project lifecycles. The second project was for Product Lifecycle Management software called Teamcenter for the same client from Jun 2015 to present. Responsibilities included requirements gathering, database development, and testing. The third project was a Purchase Order System for BrainEye InfoTech from Jan 2016 to present, with roles such as database design, object creation, testing, and documentation.

    Original Description:

    PLSQL project details

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes three projects worked on by the individual as a PL/SQL Developer. The first project was a Project Management Information System for Creed Global Consultancy from Dec 2014 to Apr 2015. It involved developing the backend code and database for a system to manage project lifecycles. The second project was for Product Lifecycle Management software called Teamcenter for the same client from Jun 2015 to present. Responsibilities included requirements gathering, database development, and testing. The third project was a Purchase Order System for BrainEye InfoTech from Jan 2016 to present, with roles such as database design, object creation, testing, and documentation.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    118 views4 pages

    Project Details

    Uploaded by

    manojkumar
    The document describes three projects worked on by the individual as a PL/SQL Developer. The first project was a Project Management Information System for Creed Global Consultancy from Dec 2014 to Apr 2015. It involved developing the backend code and database for a system to manage project lifecycles. The second project was for Product Lifecycle Management software called Teamcenter for the same client from Jun 2015 to present. Responsibilities included requirements gathering, database development, and testing. The third project was a Purchase Order System for BrainEye InfoTech from Jan 2016 to present, with roles such as database design, object creation, testing, and documentation.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 4

    Title: Project Management Information System (PMIS)

    Client: Creed Global Consultancy Pvt. Ltd , Bangalore


    Duration: Dec 2014 to APR 2015
    Team size: 8
    Environment: Oracle 9i, Windows, Reports, Java
    Role: PL/SQL Developer
    Project Description:
    Project Management Information system is a Database System which is used for maintaining the entire
    Database regarding Naval Projects developed by DMDE. This Project Processing Lifecycle of Products
    from gathering of Technical Requirements to Final Production which includes Master data, financial data,
    Purchase Orders, Quality Assurance report etc. The centralized data is maintained in the oracle
    database. The end users will be able to take the Business Decisions based on our different Forecast
    reports. Finally the data is maintained in different staging servers. The data warehouse systems will be
    maintained internally for Business analysis and ongoing customization.
    Responsibilities:
    Requirement gathering and worked according to the CR.
    Worked under the senior level guidance.
    Data validation/Reconciliation report generation.
    Code Development as per the client requirements.
    Involved in the development backend code, altered tables to add new columns, Constraints, Sequences
    and Indexes as per business requirements.
    Perform DML, DDL Operations as per the Business requirement.
    Creating views and prepares the Business Reports.
    Resolved production issues by modifying backend code as and when required.
    Used different joins, sub queries and nested query in SQL query.
    Involved in creation of sequences for automatic generation of Product ID.
    Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions,
    Packages, Cursors, Ref Cursor and Triggers.

    Testing of code functionality using testing environment.

    Project # 2:
    Title: Product Lifecycle Management (Team centre)
    Client: Creed Global Consultancy Pvt. Ltd , Bangalore
    Duration: Jun 2015 to till date
    Team size: 10
    Environment: Oracle 9i/10G, Windows, Reports, Java
    Role: PL/SQL Developer

    Project Description:
    Product Lifecycle Management is the process of managing the entire lifecycle of product from its
    conception, through design and manufacture, to service and disposal.PLM integrates people, data,
    processes and business system provides a product information backbone for the organization. A major
    part of PLM is the co ordination and management product definition data. The deployment of PLM
    TEAMCENTER at DMDE is mainly aimed at establishing an efficient knowledge management system.
    The system is planned to be project with a single central data repository which would be accessible to all
    authorized users over the Local Area Network. The System has a data Management module which serves
    as a tool for archival and retrieval of both product and project related information required for knowledge
    management. The typically would include Tender Enquiries, Purchase Orders, Quality assurance Plans,
    Design Documents, Approved Test Plans, drawings, Model files, Trial and inspection reports etc.
    Responsibilities:
    Requirement gathering from the Business Team.
    Convert the functional requirements into technical document as per the business standards.
    Worked as per the CR Raised from the end user.
    Analyze the Existing code and do the impact analysis.
    Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions,
    Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.

    Involved in modifying various existing packages, Procedures, functions, triggers according to the new
    business needs.
    Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the
    database.
    Used SQL Loader to upload the information into the database and using UTL_FILE packages write data
    to files.
    Involved in explain plan for query optimization.
    Data validation/Reconciliation report generation.
    Involved in peer to peer code reviews.
    Code validation as per client requirement.
    Testing of code functionality using testing environment.

    Project 3 : Purchase Order System


    Designation : PL/SQL Developer
    Client : BrainEye InfoTech Pvt Ltd
    Team size :- 10
    Duration:-Jan 2016 Till Date.
    Key Roles & Responsibilities:
    Collected User Requirements by participating in meetings and studying existing System.
    Creating E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using
    Oracle Designer.
    Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures,
    function, packages, Cursor, Ref Cursor and Triggers.
    Inolved in analysis, design, coding and Testing.
    Involved in modifying various existing packages, procedures, functions and triggers according to the
    new business needs.
    Front End Screen was developed using Forms 9i.

    Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the
    database.
    Used SQL LOADER to upload the information into the database.
    Used Explain Plan for query optimization.
    Created Database design and converting them into database objects.
    Wrote test cases and performed Unit testing.
    Involved in writing Technical Specification Documentation.

    You might also like