JAYAKANTH M
Vellore
Summary
- Experienced in Oracle/PostgreSQL developer on application programmer with 3 years of progressive experience.
- Skilled in utilizing Oracle RDBMS and Azure cloud.
- Involved in complete SDLC processes, including requirement analysis, planning, design, development, testing, and implementation.
- Worked on 24/7 support for critical live production Environment.
- Proficient in Oracle SQL and PostgreSQL, Expertise in using DDL, DML, DCL& TCL Statements
- Extensive knowledge of Database objects such as Tables, Views, Indexes, Synonyms, and Sequences, etc.
- Hands-on experience with functions, Joins, Sub-query, Pseudo Columns, Set Operators, constraints, and Analytical Functions.
- Hands-on experience with PL/SQL database objects like stored procedures, functions, packages, and triggers. Familiar with cursors/ref cursors for fetching multiple records and handling exceptions.
- Good in coding knowledge and some sort of work gain on PL/SQL database objects like Stored Procedures, Functions, packages An
- Knowledge of supplied packages like UTL_FILE and DBMS_MVIEW. and some sort of work gain with collections like associative arrays, nested tables, Varrays), dynamic SQL, and bulk collect (FORALL, LIMIT, SAVE EXCEPTIONS).
- Good knowledge in SQL and PL/SQL Tuning as well as application tuning using various tool like to describe (EXPLAIN plan, index, hints, dbms_profiler)
- Skilled at analyzing and converting business requirements into code.
Overview
3
3
years of professional experience
Work History
Application Programmer L2
AHEL
08.2022 - Current
- The role plays a crucial part in supporting clinical and administrative staff, enabling them to deliver efficient and effective patient care
- This involves providing technical assistance to end-users, troubleshooting and resolving application-related issues, maintaining and upgrading software systems, and ensuring optimal performance and reliability of healthcare applications
- Faster Issue Resolution: Improved response and resolution times for application-related problems, with clear tracking metrics such as average resolution time and first-call resolution rates
- Successful Software Updates/Implementations: Smooth rollouts of system updates or new applications, with minimal disruption and effective staff adoption
- Understanding end user’s problem and giving resolution in compliance with IT protocol
- Major issues which are not solved at local level, forwarding those to us central L2 team for resolution under the SLA's for both the environment ORACLE & POSTGRESS SQL
- Periodic scrutiny of application Master data like corporate tariff and business rules for PAN INDIA by a customer relationship management (CRM), involving respective stakeholders and setup the configuration for all regions
- Reduced Errors: Minimal manual corrections required during reporting, billing, or patient care
Internship Trainer
JOY Infotech Consulting Pvt. Ltd.
07.2022 - 08.2022
- Attended job orientation with intern and reiterated policies and practices to facilitate successful work experience.
- Assessed progress and provided feedback to intern and team members.
- They Trained SQL,PL/SQL in oracle and some worked assets.
Education
Bachelor of Engineering -
Global Institute of Engineering And Technology
Vellore, India08-2018
Skills
- DDL, DML, DCL & TCL Statements of Oracle SQL
- Database objects such as Tables, Views, Indexes, Synonyms, and Sequences
- Functions, Joins, Sub-query, Pseudo Columns, Set Operators, constraints, and Analytical Functions
- Creating Scripts to load data from flat files into database using SQL
- Loader
- PL/SQL database objects like Stored Procedures, Functions, packages And Triggers
- Cursor/Ref cursor to fetch multiple records from table inside the PL/SQL block
- Supplied package (DBMS_MVIEW)
- Collections (Associative array, Nested table, Varray)
- Dynamic SQL and Bulk collect (FORALL, LIMIT, SAVE EXCEPTIONS)
- SQL and PL/SQL Tuning and application tuning using various tools like (EXPLAIN plan, index, hints, dbms_profiler)
- Analyzing and converting business equipment into code
- Requirements analysis
- Functional testing
- Code optimization
- Integration testing
- Data structures
Music,Games
Listen a melodies,peaceful songs
Liked more interested on playing Games for gaining focus and wining Achievements thougts.
Languages
Tamil
Advanced (C1)
English
Upper intermediate (B2)
Hindi
Beginner (A1)
Software
PL/SQL
PostgreSQL (DBeaver,Pgadmin)
SQL Developer
Interests
Need to Learn New Technologies and Software & Database management system in well cycle
network infrastructure
Quick Understand and analysis
Timeline
Application Programmer L2
AHEL
08.2022 - Current
Internship Trainer
JOY Infotech Consulting Pvt. Ltd.
07.2022 - 08.2022
Bachelor of Engineering -
Global Institute of Engineering And Technology
Similar Profiles
Hiritish Chidambaram NHiritish Chidambaram N
Business Intelligence Intern at HTC Global ServicesBusiness Intelligence Intern at HTC Global Services
Vignesh MSVignesh MS
SENIOR SALES MANAGER at GN RESOUND INDIA PVT. LTD.SENIOR SALES MANAGER at GN RESOUND INDIA PVT. LTD.
Ranjiit Mahaamurthy Ranjiit Mahaamurthy null
Head - Technical at Cryolor Asia Pacific Pvt Ltd., (Air Liquide Group)Head - Technical at Cryolor Asia Pacific Pvt Ltd., (Air Liquide Group)