Subrat Gouda

About Subrat Gouda

Having 6.5 Years of experience in IT industry as Oracle SQL and PL/SQL Developer.• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.• Can Write All Types of Database Joins With Oracle and Execute With ANSI Joins.• Extensively Worked With All Types of Sub-Queries Like Single Row Sub-Queries, Multi-Row Sub-Queries and Correlated Sub-Queries.• Can write all types Cursors and Using Ref-Cursors And FOR UPDATE Cursors.• Logically Strong in Developing User Defined Stored Procedures, User Defined Functions, Packages with Integration of Cursors, PL/SQL Tables, Exceptions and Triggers.• Hands on Exposure to Handle Runtime Exceptions Using Pre-Defined Exceptions, and User Defined Exceptions at Business Level Abnormalities.• Exposure in Identifying the Primary and Foreign Key Constraints, Implementing Complicated CHECK Constraints and Database Triggers.• Good Knowledge in Writing and Testing PL/SQL Code with Anonymous, Named and Sub-Programming Blocks• Exposure in Analysis, Design and Implementation of Business Applications Using the Oracle Relational Database Management System (RDBMS).• Exposure in integration application oriented Procedure and Function into Packages.• Can write different types views as per requirement and create materialized view for query performance as per the requirement.• Good in Implementing Oracle SQL and SQL*Plus Functions For Productive Development in Handling Data Consistency, Reliability and Integrity in The Project.• Good Perspective on Converting Functional Specification.• Has Good Knowledge In Data Migration Using SQL*Loader And UTL_FILE Package.• Good knowledge on Bulk Collect and collection for query performance.• Can create all type of index for get the better performance of retrieve the data.• Ability To Meet Deadlines And Handle Pressure In Coordinating Multiple Tasks In A Working Project Environment. • Experience Of Good Client Interaction And With Their Requirements

Experience

1. Senior Software Engineer

   OpenText

   Mar 2023 — Present · Hyderabad, IN

Education

• Berhampur University

  Master of Computer Applications - MCA, Computer

  2010 — 2013