Suresh Kumar D Email & Phone Number

• A versatile, reliable, and efficient administrative associate with 14 experience in Oracle SQL, PL/SQL, Report builder, Forms, Shell Scripts and Microsoft applications• Having experience in development as well as in all levels of production support (L1, L2, L3 and L4)• Working experience in both water fall model and agile model• Extensive experience in the areas of analysis, design, development, maintenance and testing of application software and project management (SDLC)• Having good testing experience as I worked closely with the testers in various application regions like Qa, Uat and production regions.• Already worked in many projects and also currently working in parallel as a team player as well as an individual player in two different modules• Expertise in Incident Management, Change Management, Root Cause Analysis and Remediation.• Diversified skills in health care, Insurance and in BankingSKILLS---------------------------------------------Oracle SQL, Pl/SQL:---------------------------------------------• Execution plan and cost based optimization• COMPOSITE and FUNCTION BASED indexes• Invisible index and parallel HINTS with different number of threads count in SQL• STATS gathering to gather statistics for multiple tables• Creating, using and purging the table partition• Bind variables and spoolingSHELL scripts and CRONTAB:--------------------------------------------• Various identical shell scripts like Stats Gathering jobs for better Data Base performance, housekeeping job scripts to clear the files from 250+ directory paths which are older than N number of days, file watcher script to wait and receive files from multiple servers to process in a common base server.• Linux commands to derive the scripts and reports paths dynamically.• Commands to get user input values (like data extraction date ranges, country code, etc)• User ID based validations to control the scripts and file access permission.• SFTP and FileIt file transfer methods to transfer the files to end user systems• Shell scripts with various unix commands• CRONTAB scheduler and nohup commands for manual trigger the jobs.Tools: --------------------------------------------SQL Developer, Toad, Putty, WinSCP, Jira, Service now, RAT

• 

  Development Manager

  Standard Chartered

  Apr 2024 - Present - India

• 

  Amrita Vishwa Vidyapeetham

  Computer Science