Gaurav Giri

• 4.4 Years of experience in Oracle PL/SQL and SQL technologies on Windows WP/NT/2k, specializing in software application development and support. Skilled in designing DDL, DML, and TCL queries, utilizing Oracle and ANSI joins, and crafting various subqueries. Experienced in developing stored procedures, functions, and packages, along with handling exceptions and utilizing Oracle 11g features. Strong knowledge of creating database tables, views, indexes, sequences, and synonyms. Experience and Having Knowledge on Collections such as PLSQL Tables. Have Knowledge on Nested Tables and Varrays. Experience in Loading data into Oracle database utilizing SQL
• Loader, UTL_FILE Package. Good Knowledge in Creation Of Primary Keys, Constraints, Triggers, Privileges, etc. Experience and Having Good Knowledge in Using Cursors such as Implicit, Explicit and Ref Cursor. Proficient in writing Stored procedures, Functions and Packages in PLSQL. Have Good Knowledge on Bulk Collect And Bulk Bind Process. Proficient in Exception Handling such Oracle Pre-Defined, Unnamed, User Defined Exceptions. Have Good Knowledge in OLAP and Analytic Functions Like Rank, Dense_Rank, First_Value, Last_Value, Lag, Lead, Listagg. Have Good Knowledge in Hierarchical Retrieval, Pseudo Columns, Group Functions, Analytical Functions. Experience in Developing and Designing Queries Using Joins, Sub-queries, Set Operators.

Results-oriented and innovative Senior Software Engineer with 4 years 4 months of experience. Easily communicates complex technical requirements to non-technical stakeholders. Excellent leadership record of leading development teams in enterprise-wide development projects.