Kishore Kumar H

Experience

• 

  Capgemini

  Jun 2016 - Apr 2019

  Associate Consultant

  Worked as Associate Consultant at Bangalore since June-2016 to April 2019 at Capgemini India Pvt Ltd. I was working with a role as SQL Developer, Oracle SQL support.Responsibilties:Involved in development, testing and implementation of Oracle Database tables.Involved in the developing PL/SQL back-end programming – Database Packages, Stored Procedures, functions & Triggers.Worked with SQL Loader to import and export data from the database.Tuned some existing queries using hints to improve execution time of the queries.Solving problems faced by clients.Analyzing client requirement and validating the issues posted.Created Tables and Constraints.Unit testing of the PL/SQL programs. Show less

• 

  Collins Aerospace

  May 2019 - Dec 2021

  Associate Engineer

  Working as Associate Engineer at Bangalore since May-2019 to till date at Collins Aerospace Pvt Ltd, playing the role of PL/SQL developer.Responsibilities:Creating stored procedures, functions, packages and triggers for implementing required business logic.Designing constraints & tables.Writing complex SQL queries using Inline views, correlated sub-queries, joins etc.Unit testing of the PL/SQL programs.Worked on performance tuning using explain plan and TKPROF.Managing database using Functions, Procedures, Cursors, Triggers, Exception.Developed materialized views for data replication in distributed environments.Writing bulk operations by using collections, ref-cursors, bulk loading and bulk fetching.Use Oracle SQL* Loader utility for data loading in tables from the flat files.Interacting with user to acquire and understand the technical requirements.Technical documentation preparation for developing code.Given training and presentation for fresher about the product and basic SQL.Responsible for sending daily and weekly status reports.Providing the status of the backend progress and incorporations changes if any. Show less

• 

  IQVIA

  Dec 2021 - now

  Unix (Shell Scripts), Python Scripting, Machine Learning (NLP Process).Provide Customer Technical support for Application runs on Machine Learning NLP Process concept. Passionate Back End developer, PL/SQL Support, Unix (Shell Scripts), Python Scripting, Machine Learning (NLP Process).Provide Customer Technical support for Application runs on Machine Learning NLP Process concept.

  • Software engineer 2

    Apr 2024 - now

  • Software Engineer

    Dec 2021 - May 2024