Processing, Regulatory reporting and Inquires & reports. It’s an Internet-Enabled Application with a database backend, Provides an extensive range of functions andĭata access within all key investment activities such as Trade Processing, Investment Management, Cash Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.Ĭlient: More Techno Securities, inc, New York.Good knowledge of Query Optimizer, Execution Plans, and Indexes.Expertise in Dynamic SQL, Collections and Exception handling.Worked extensively on Ref Cursor, External Tables and Collections.Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).Good knowledge on logical and physical Data Modeling using normalizing Techniques.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections,Analytical functions, Materialized Views.Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL,SQL *PLUS, TOAD and SQL DEVELOPER.Participated in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.Participated in Analysis, Design, and Implementation of Business Applications using the Oracle (RDBMS).Highly skilled and experienced PL SQL Developer with programs and Ability to work asĪn independent or as part of a team. Oracle PL/SQL Developer with 7 years of experience in Analysis, Design, and Implementation of CustomeĪpplications using the Oracle Relational Database Management System (RDBMS).