KANHAIYA KUMAR

Experience

• 

  Nippon Data Systems Ltd.

  Mar 2010 - Oct 2010

  Software Developer

  • Creating and Modifying the Forms and Reports 10g. • Application customizations as per requirements and Handling the client’s issues• Implemented the project using Oracle, forms, reports and back-end database as Oracle 10g• Involved in Requirement gathering & documentation• Used PL/SQL program, procedures, functions, Cursors, Triggers and packages to retrieve, display and manipulate data.

• 

  Ginni Systems Limited

  Oct 2010 - Sept 2012

  Software Executive

  • Involved with customer communications, client calls and Single Point of Contact for query resolutions.• Responsible working on the new Business Change Requests to full fill the requirements.• Client Interaction, Requirement Gathering. • Creating and Modifying the Forms and Reports. • Writing SQL queries, stored procedures/functions/packages/triggers in Oracle PL/SQL • Creating Tables, Global temporary tables, Views in SQL.• Writing TEXT_IO package to write the CSV file generation and to extract data from .CSV files in Client machines and Used UTL_FILE.• Used Collection, Bulk collect, Bulk bind and Ref cursing in DB objects. Show less

• 

  Wave Mega City Centre Private Limited

  Sept 2012 - Feb 2013

  Sr. Software Engineer

  • Requirement gathering daily basis.• Developed database desired by application developer. • Creating/Modifying Database Data Model as per requirement.• Creating DB objects such as tables, View Packages, Store Procedure, Function, Triggers.

• 

  SHRI BALAJI INDUSTRIAL PRODUCTS LIMITED

  Feb 2013 - now

  Sr. Software Engineer

  • Involved from System Requirement to Design and Development of business solution.• Creating DB objects – Procedures, Functions, Views, Triggers and Packages etc.• During developing DB PLSQL Object, used Oracle Supplied packages, Bulk Collect, PL/SQL Collections, Materialized Views, Used Ref Cursor, Dynamic SQL Concepts and Exceptions.• Involved in SQL Query tuning.• Involved in coding of multiple modules and take the ownership and provide end to end Implementation.• Understanding the data, analyze it and map based on the business requirement into PL/SQL Code.• End to end implementation from source to production.• Backend Development for enhancement.• Requirement gathering and understanding.• Assigning work to the Team members. Show less