Gunjan Gupta

Gunjan Gupta

Software Engineer

Followers of Gunjan Gupta193 followers
location of Gunjan GuptaIndia

Connect with Gunjan Gupta to Send Message

Connect

Connect with Gunjan Gupta to Send Message

Connect
  • Timeline

  • About me

    Senior Software Engineer at NIIT Technologies Limited

  • Education

    • GREENFIELDS PUBLIC SCHOOL

      2003 - 2004
      MCA COMPUTERS
  • 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
  • Licenses & Certifications

    • Oracle pl/sql developer

      Oracle
      May 2013
    • Oracle database sql

      OCA
      May 2013