Nutan Pawade

Nutan Pawade

Associate Consultant

Followers of Nutan Pawade545 followers
location of Nutan PawadePune, Maharashtra, India

Connect with Nutan Pawade to Send Message

Connect

Connect with Nutan Pawade to Send Message

Connect
  • Timeline

  • About me

    I have 3 years of experience in the IT industry as an PLSQL and Shell scripting developer. My skills include SQL query optimization, query building, and performance tuning, procedure development , Database migration.

  • Education

    • PES Modern collage of engineering

      2016 - 2020
      Bachelor of Engineering Information Technology 6.4

      Activities and Societies: Lila Girl 2016 (Got Lila poonawala foundation scholership) Completed engineering from Pune University.

    • Samarth Polytechnic Belhe

      2013 - 2016
      Diploma Computer A+

      Completed Diploma from Samarth ploytechin Belhe.

  • Experience

    • Capgemini

      Sept 2021 - now
      Associate Consultant

      Created and maintained database objects such as tables, procedures, functions, and packages.Developed and optimized SQL queries, functions, and processes based on project requirements.Implemented code optimization techniques and indexes to improve processing time and overall performance.Conducted SQL and PL/SQL tuning, utilizing tools like Oracle Hints and EXPLAIN PLAN.Utilized Exception Handling extensively for error handling and debugging purposes.Performed data loading from flat files into Oracle tables using SQL*Loader and PL/SQL procedures.Developed packages, triggers, stored procedures, and functions for a solvency project, which involved retrieving data using FTP, scheduling through AUTOSYS, and PL/SQL.Conducted unit testing of PL/SQL packages, procedures, functions, and database triggers.Utilized JIRA for defect tracking and provided defect summary reporting.Worked in an agile and test-driven environment, actively participating in daily scrum meetings and discussions.Employed various tools and technologies such as Oracle 10g/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell scripts, Agile and waterfall methodologies, Windows XP, JIRA, Secure CRT, MS Excel, Putty, Notepad++, etc. Show less

  • Licenses & Certifications