Suresh Sudarthi
Bangalore
Summary
- Having 5.11 years of extensive experience as Oracle PL/SQL Developer in implementation and Support. Strong experience in Oracle SQL in creating Tables, Views, Materialized views, Indexes, Sequences, Synonyms. Expert in SQL commands like DDL, DML, DQL, TCL, DCL. Good Experience in using Constraints like Primary Key, Unique, Not Null, Default, Check and Foreign Key. Having Expertise in writing complex queries, good in using Joins, Set operators, Aggregate functions, Analytical Functions, String Functions, Date Functions, Number Functions. Expertise in using Conversion functions like TO_NUMBER, TO_DATE, TO_CHAR. Good Experience in SQL
- LOADER, EXTERNAL TABLES, GLOBAL TEMPORARY TABLES. Strong Experience in Oracle PL/SQL in creating Procedures, Functions, Packages and Triggers. Expertise in using Cursors like Implicit cursors, Explicit cursors and Ref Cursors. Good experience in Cursor attributes, %ROWCOUNT, %FOUND, %NOTFOUND, %ISOPEN. Expert in Handling System Exceptions, User Defined exceptions. Have used Pragma exception_init. Good Experience in using Control Statements, Loop, While loop and For loop. Expertise in using PLSQL collections like Record, Index by table / Associative array, Nested tables and Varrays. Good Experience in Collection methods like COUNT, LIMIT, FIRST, LAST, DELETE, EXTEND etc. Hands on experience in Bulk collect, FORALL, SAVE EXCEPTIONS, BULK EXCEPTION HANDLING. Good Experience in UTL_FILE which load data from data base table to Flat file. Have knowledge on Unix basic commands. Used Tortoise SVN, WINSCP, putty. Well versed with client server environment and tools like SQL
- Plus, PL/SQL, SQL
- Loader, Toad, SQL Developer. Used Jira, service first now tools for working on tickets.
Overview
7
7
years of professional experience
Work History
Engineer II
Apexon India Pvt Ltd
02.2024 - Current
IT analyst
Tata consultancy services
06.2022 - 10.2023
Application Developer
Estuate Software PVT LD
11.2020 - 12.2021
Application Developer
Icici PWC
08.2020 - 11.2020
Application Developer
Fujitsu Consulting India
07.2018 - 08.2020
Education
MCA - Computer Applications
Sree Vidyanikethan Engineering College
Tirupati08-2012
Skills
- SQL Plus
- Toad
- SQL Developer
- PLSQL Developer
- Jira
- Service first now
- Git Lab
- Design development
- Agile methodologies
Languages
English
Advanced (C1)
Telugu
Bilingual or Proficient (C2)
Hindi
Intermediate (B1)
Tamil
Intermediate (B1)
Timeline
Engineer II
Apexon India Pvt Ltd
02.2024 - Current
IT analyst
Tata consultancy services
06.2022 - 10.2023
Application Developer
Estuate Software PVT LD
11.2020 - 12.2021
Application Developer
Icici PWC
08.2020 - 11.2020
Application Developer
Fujitsu Consulting India
07.2018 - 08.2020
MCA - Computer Applications
Sree Vidyanikethan Engineering College
Similar Profiles
Sarthak TyagiSarthak Tyagi
Engineer II at Apexon India Pvt. Ltd.Engineer II at Apexon India Pvt. Ltd.
Arpita JainArpita Jain
QA Automation Lead at Apexon India Private LimitedQA Automation Lead at Apexon India Private Limited
Chethan RChethan R
Senior Associate at Zomato india pvt ltd & grofers india pvt ltdSenior Associate at Zomato india pvt ltd & grofers india pvt ltd
C. RathiC. Rathi
Business Development Manager at HTC Global ServicesBusiness Development Manager at HTC Global Services
Sunil Kumar SSunil Kumar S
Associate Director SAP Basis at GSKAssociate Director SAP Basis at GSK