Srikanth Chinthakindi Mobile: +91- 8886828286
Email: Sreeoracle112@gmail.com
Functional summary:
5+ years of Total IT experience.
Having 5.2 years of Experience in Application development and
Maintenance/Support projects using SQL, PL/SQL and UNIX with extensive
understanding of different Application development tools and technology.
Technical Knowledge – PL/SQL, SQL.
Having good experience in SQL and PLSQL development using ORACLE 10g, ORACLE
11g and ORACLE 12c.
Extensive experience in creating complex database objects like stored procedure,
Functions, Packages, Collections and Triggers.
Experience in Creating Tables, Views, Constraints, Sequences and Synonyms.
Proficient in PL/SQL programming -Stored Procedures, Functions and Packages,
SQL tuning, Constructing of Tables, Views, Database Triggers, Synonyms,
Sequence, Cursors, user defined exception, Pragma Autonomous
Transaction, Bulk Collect and for all, Oracle Hint, Explain Plan, Sys
refcursor, indexes, Analytical Functions, Dynamic SQL, SQL-Loader,
External Table etc.
Aware of the Concept of Exception handling mechanism in various scope and
visibility.
Having knowledge on Database Architecture and Performance Tuning.
Involved in development of code from scratch for the given requirement.
Flexible in each activity of organization.
Experience in Agile/Scrum development methodology.
Planning, delivering and implementation of quality solutions as per scheduled milestones.
Good communicational and interpersonal skills and involved in client interactions for
scoping, effort estimates and status reporting.
Ability to learn new technologies with minimal time period and excellence in team playing
with multi-location teams.
Experience Summary:
Worked as a SQL and PL/SQL Developer for “L&T Infotech” from Sep 2022 to
Feb 2023.
• Worked as a SQL and PL/SQL Developer for “Quess Corp Limited” from Jun
2021 to Mar 2022.
• Worked as a SQL and PL/SQL Developer for “CKS Global Ventures Pvt Ltd”
from Dec 2019 to May 2021.
• Worked as a SQL and PL/SQL Developer for “Capgemini Technology India
Pvt Ltd” from Jan 2018 to Oct 2019.
Educational Qualifications:
• B. tech in MEDHA College of Engineering and technology from JNTU
Hyderabad,2016.
Technical Skills:
Operating System Windows 7/10, Linux, Unix
Languages SQL, PLSQL
Tools Used SQL Developer,
Version Control/Repository GIT ,TFS
Methodology Agile/SCRUM
RDBMS ORACLE 10g, 11g, 12c ,Microsoft SQL server
2012
Office Packages JIRA
Project-1
Project Name : Home Site Insurance Company
Client : Cannon Cochran Management Services (CCMSI) US
Role : Team Member/Oracle SQL and PLSQL Developer
Environment : Oracle 12C, SQL, PLSQL, SQL Developer, GIT Extension
Description:
Home Site Insurance Inc, is a multinational provider of insurance technology software,
information technology services and consulting to insurance carriers worldwide across lines
of business – property & casualty (General insurance), life, annuity, health, pensions, and
group & worksite benefits insurance.
Roles & Responsibilities:
⮚ Developed stored procedures, functions, Triggers, PLSQL programmed unit etc. as per
the project requirement.
⮚ Worked on SQL*Loader to load data from flat files obtained from various
facilities every day.
⮚ Based on the mapping document we will create tables and write triggers for enhanced
validation and business logic management.
⮚ Modified existing procedures, functions as per the Project requirements.
⮚ Involved in the development backend code, altered tables to add new columns,
Constraints, Sequences and Indexes as per business requirements.
⮚ Using sql developer tool we debugging the code and unit test.
⮚ Created record types, tables, collections (nested tables and arrays) for improving
Query performance by reducing context switching.
⮚ Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
⮚ Handled errors using Exception Handling extensively for the ease of debugging and
displaying the error messages in the application.
Project-2
Project Name : GKYC
Client : ING Bank, Netherlands.
Role : Team Member/Oracle SQL and PLSQL Developer
Environment : Oracle 11g, SQL, PLSQL, SQL Developer, Git
Description:
Keeping ING safe, secure, and compliant continues to be a top priority. As a gatekeeper to
the financial system, we have an important role in the collective fight against financial and
economic crimes. By performing customer due diligence and monitoring transactions we aim
to detect and prevent the financial system from being misused in criminal activities, including
money laundering and terrorist financing, for the safety and security of our customers and
society.
Roles & Responsibilities:
Develop enforced data integrity by applying constraints to achieve quality of the data in
the database.
Develop complex SQL queries including Sub queries, Analytical functions, Set operators
and Hierarchical queries throughout the Project.
Prepare test cases and conduct unit testing for this Module.
Creating relational tables like, parent Tables with Primary keys and child Tables with
Foreign key relationship.
Creating integrity Constraints like not nulls, default values and check constraints where
ever necessary.
Creating Indexes for performance issues to search the data quickly.
Creating Triggers for enhanced validation and business logic management
Creating Stored Procedures for performance issues i.e. retrieving data or inserting data
into the database will be quickly when comparing to normal insertion or selection or
updating or deletion.
Creating Cursors for dynamic operations at various levels as per the requirement
Creating Functions, Procedure and sequences whenever used.
Writing Queries, Sub-queries, Joins.
Created record types, tables, collections (nested tables and arrays) for improving
Query performance by reducing context switching.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Project-3
Project Name : PRONTOINS
Client : Pronto Insurance Company, California, USA.
Role : Team Member/Oracle SQL and PLSQL Developer
Environment : Oracle 11g, SQL, PLSQL, SQL Developer, Git
Description:
The project has the facility to take vehicle insurance policy through internet. The main aim of
the project is to build up the enterprise data warehouse having the information of claims,
benefits, providers, enrolments, utilization is etc. This gives all the information about
insurance like policies, agents, offices, glossary of insurance terminology, online services to
some of the policies, information regarding expiry, renewal, status enquiry.
Roles & Responsibilities:
Creating relational tables like, parent Tables with Primary keys and child Tables with
Foreign key relationship.
Creating integrity Constraints like not nulls, default values and check constraints where
ever necessary.
Creating Indexes for performance issues to search the data quickly.
Creating Triggers for enhanced validation and business logic management
Creating Stored Procedures for performance issues i.e. retrieving data or inserting data
into the database will be quickly when comparing to normal insertion or selection or
updating or deletion.
Creating Cursors for dynamic operations at various levels as per the requirement
Creating Functions, Procedure and sequences whenever used.
Writing Queries, Sub-queries, Joins.
Created record types, tables, collections (nested tables and arrays) for improving
Query performance by reducing context switching.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Handled errors using Exception Handling extensively for the ease of debugging and
displaying the error messages in the application.
Using set auto trace on and explain plan for query optimization.
Using Optimization Hints to improve the query performance.
