Shaik Reshma Email & Phone Number

Chennai, Tn, In

Hyderabad, Telangana, India

* Having 3+ Years of experience in Development and maintenance of Order Management.* Hands on experience in technologies like Oracle, SQL and PLSQL* Developed and Documented PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Ref cursors and Exceptions.* Extensive experience in SQL, PLSQL Programming concepts and writing advanced SQL queries.* Expertise in Dynamic SQL, Collections, Bulk collect, Bulk bind and Exception handling.* Solid experience in creating and maintaining different types of data base object such as Tables, Constraints, Views, Materialized views, Indexes.* Good knowledge on sequences and sequence Resetting. * Proficient in writing various kind of SQL like DML, DDL, DCL and Query Language statements.* Good exposure to join, sub query, co-related sub query, Inline view, nested sub query.* Expertise in creating and maintaining Composite data types like Objects, Varrays, Nested tables.* Expertise in using PLSQL data types like Percentage Row type, Record type and Percentage type.* Quick learner and strong desire to master new technologies in the areas of Database and strong team player.* Experience in using Global Temporary Tables. Responsible for: * Creating and maintaining tables and other objects.* Adding or modifying the constraints for tables as per the business requirement.* Created PL/SQL stored Procedures, Functions for customizing the application and to implement business logic* Created Packages and defines Procedures and functions in side of the packages.* Writing code for various modules as per the changes of client activities.* Involvement of writing SQL queries and stored procedures to extract the appropriate data.* Used PL/SQL tables, Cursors for processing huge amount of data and used Bulk Collect, Bulk Bind and Cursor with Bulk Collect feature for mass transaction update as performance improvement process.* Created Triggers for enhanced validation and business rules implementations* Handling exceptions.