Gagan Deep

Background

About Gagan Deep

Support using various technologies SQL,PLSQL, Python & Unix Creating tables using Constraints. Good understanding of database concepts, anomalies and normalization process Implementation using Primary/Foreign Key constraints. Proficiency in all types of SQL commands, DDL, DML and TCL. Hands on experience in writing SQL window / Analytical functions. Particle knowledge use of Sets, date and aggregate functions. Joins, Sub -Quires and co-related sub quires. Hands on experience in writing SQL window / Analytical functions Data Analysis using window function such rank (), lead () and lag (). Exposure PL/SQL programs to work on data using Cursors, Records and Collections. Writing Stored Procedures and Functions according to the necessity of the operations on data including Exceptions to avoid abruption of programs. Grouping the related Procedures, Function and data into Packages. Usage of Indexes in order to improve the Performance of data retrievals. Strong knowledge in Core Python programming Espouse to Python objects such as string, lists, and tuples. Able solve problems using loops, if statements, while and compressions Strong knowledge in Object oriented programming, Able debug and write user defined functions Able to work in UNIX environment. Skilled at triaging and root cause analysis. Ability to provide step-by-step technical help, both written and verbal. Track, log and respond to support tickets. Management of permissions for users. Compare files, zip and unzip files, and transfer files. Monitoring of servers and processes, as well as task scheduling. Strong knowledge on Incident Management, Change Management and Problem Management concepts.