Gunjan Gupta

Experience

• 

  Nucleus Software Exports pvt ltd

  Feb 2012 - Jan 2014

  Software Engineer

  A. Development of Forms and Reports (10g) as per the requirement, Support for existing application.B. Creating and modifying tables, sequences, stored procedures, functions, triggers, jobs etc.C. Documentation related to the developments like program specification, unit test plan, impact analysis and design, database scripting, preparing release patches etc.D. Team Coordination, Support during testing, performed on the application to the Testing Team.

• 

  Tech Mahindra

  Jan 2014 - Jun 2017

  Senior Software Engineer

  • Creating Database, Writing stored procedures, functions, triggers, cursors, packages using PL/SQL. • Involved in Table design, Created Tables, Views, Constrains, Synonyms, Sequences and SQL tuning. • Development, Maintenance, Post Implementation support Prepare the Technical Documentation for Developed Project. Understanding the requirements and carrying out impact analysis.• Created index on table to get better performance • Created Records, Tables, Collections (Nested Tables and Varrays) for improving performance by reducing context switching.• Used PL/SQL tables, PRAGMA AUTONOMUOS_TRANSACTION to avoid mutating problem in database trigger.• Wrote code Exception handling to trouble-shoot PL/SQL code.• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM. Involved in code reviews of other team members.• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancement on oracle Application.• Worked on performance tuning and used Explain Plan, TKprof and SQL trace for tuning the queries.• Created Indexes and hints for faster retrieval of the customer information and enhance the database performance.• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.• Coordinated with DBA in improving Database Performance and involved in SQL Tuning by creation of indexes, Explain Plan, SQL Trace and TKPROF Tools.• Fine tune existing query to gain performance using proper index and hint. Show less

• 

  NIIT Technologies Limited

  Jun 2017 - now

  Senior Software Engineer