Oracle PL/SQL Developer with 2+ years of Exp

Oracle PL/SQL Developer

Sujana

Mail: ******.****@*****.***

Mobile: +91-953*******

Professional Summary :

Professional Experience:

Presently working as a Database Engineer in Defence Machinery Design Establishment, Secunderabad from Mar 2010 to till Date.

Summary:

Having 2+ years of experience in Application Software development using Oracle 9i/10g.

Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.

Experience in bulk collect, bulk bind operators and collections.

Involved Explain plan and investigate the performance issues.

Strong understanding of business processes with good experience in development.

Good exposure on advanced topics Like Analytical Functions, Indexes, Partition Tables.

SQL Loader and UTL_FILE package.

Strong knowledge in SDLC and all phases of Application development.

Experience in UNIX Operating System.

Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process.

Experience of good client interaction and to deal with their requirements.

Quick learner & Self-directed, consistently updating self with emerging trends in the industry.

Education Profile :

B.Tech (ECE) from Narayana Engineering College, Gudur with an aggregate of 78.69%.

Intermediate from Nalanda College of Arts & Science, Nellore with an aggregate of 89.8%.

SSC from Govt. High School, Nellore with an aggregate of 83.5%.

Skills & Expertise :

Languages: SQL, PL/SQL

IDE: SQL Developer, SQL*PLUS, Toad.

Operating System: Windows XP, Window 7, UNIX

Databases: Oracle 9i, 10g

Tools & Technologies: UNIX

Functional Domain: Logistics. Order management.

Professional Experience :

Project # 2:

Title: Product Lifecycle Management (Team centre)

Client: DMDE, Secunderabad

Duration: Aug 2010 to Till Date

Team size: 4

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 # 1:

Title: Project Management Information System (PMIS)

Client: DMDE, Secunderabad

Duration: Mar 2010 to Jul 2010

Team size: 3

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.

Contact this candidate