Developer Data

Location:

Hyderabad, Telangana, India

Salary:

900000

Posted:

May 28, 2020

Contact this candidate

Resume:

KASIMVALI CHETLURI

Email ID: addg7y@r.postjobfree.com

Contact no: +91-995*******

Career Objective

Seeking a position, where I can use 3.7 years of my extensive experience in Oracle

SQL & PL/SQL programming, database development, testing, performance tuning, Application support, UNIX and Production support can add value to the company.

Academics

EDUCATION:

Bachelor of Technology in Information Technology (IT) from J.N.T.U Kakinada.

Intermediate in MPC from Narayana Junior College.

SSC from SVR High School.

HIGHLIGHTS

3.7 years of professional experience in complete Software Development Life Cycle (SDLC): Requirement analysis, Database development using SQL and PLSQL code, Performance Tuning, Database maintenance, Application support, Unit testing and Production Support.

Extensive experience in creating DDL’s DML’s. Creating database objects such as tables, views, sequences, indexes, synonyms, materialized views etc.

Strong in writing complex queries using merge statement.

Hands on experience in writing PLSQL objects such as stored procedures, functions, triggers, packages, cursors, pragma etc.

Hands on experience using PLSQL collections such as nested tables, Varrays, bulk collects and experience in advanced feature such as bulk collect and bulk binds, Dynamic Sql, function based result caching feature for high performance of functions used in SQL queries.

Hands on experience in writing materialized view for improving the response time of long running query

Strong exception handling using user defined and pre-defined exceptions and debug techniques.

Re-written many complex SQL queries in best way to improve the performance using Sub-queries, SQL WITH clause, Global Temporary Table (GTT).

Having Knowledge on Query Performance (Query Tuning) by using optimizer HINTS and appropriate Indexes with best joining techniques.

Dumping the data from flat files into database tables using SQL* Loader script with best technique’s to improve speed of loading.

Generating Explain palns for sql queries.

Having good knowledge on Partition techniques like List, Range, Hash and Interval.

Having good knowledge on 12C features like function based result cache, UDF Pragma, Flashback data Archieve, Read Only and Read Write Patitions etc.

Experience on UNIX platform.

Knowledge on Java Objects.

Good Knowledge on EXCEL Database taking reports by using PIVOT and VLOOKUP functions.

Having Knowledge on SQL SEVER.

Recent Project Experience

Company : Liquid Hub India PVT LTD(A Capgemini Group Company) FEB2019 TO TILL

Client : ALKERMES

Project Name : ALKERMES

Skills : Oracle 11g, SQL, PL/SQL, SQL Developer, UNIX and JIRA.

Location : Hyderabad.

Description:

We should maintain the patient’s data, pharmacies data, manufacturing data etc. We are getting the data from different pharmacies like Walgreens, Asmbia, Orsini, Pharmacare, Accredo, Optum etc. We analysis the patient journey and shipment of the medicine to the patient through pharmacies here the medicine cost is very expensive so the patient have an insurance option for claiming through Triage process. We are processing the patient data in time on daily, weekly and monthly. We check the medicine status, shipment status and patient status.

My Role:

Generating stats on tables for better performance.

Creating and Altering the Partitions like List, Range, and Interval partitions to maintain the data in large tables.

Creating database objects such as tables, views, indexes, sequences etc.

Writing SQL queries using merge statements, inline views etc.

Writing PLSQL objects such as stored procedures, functions, triggers, packages, cursors.

Improved the query performance by creating materialized views.

Used PLSQL collections such as nested tables, Varrays, bulk collects etc.

Writing SQL and PL/SQL programs.

Trouble shooting of Database live issues, Code corrections, Providing Data Patches in production environment that comes in day to day activity.

Generating Explain palns and identified long running queries and changed them by appling good joining techniques, Indexes, optimzer HINTS such as index, append, Ordered.

Getting QA and UAT sign off by following release cycle process and delivery of the items on time with best quality.

Project Experience#2

Client : TCS JUL-2018 TO JAN-2019

Project Name : HUMANA

Skills : Oracle 11g, SQL, PL/SQL, SQL Developer, TOAD.

Location : Hyderabad.

Description:

We use to get data from client in multiple dat files, Then we use to load the data into staging and then we validate the data to move the into main tables which was partitioned for more performance. We usually state Immunization process comes under 6 states (Texas, Florida, Colorado, Ohio, Georgia and Wnconsin)

My Role:

Generating stats on tables for better performance.

Creating and Altering the Partitions like List, Range, and Interval partitions to maintain the data in large tables.

Creating database objects such as tables, views, indexes, sequences etc.

Writing SQL queries using merge statements, inline views etc.

Writing PLSQL objects such as stored procedures, functions, triggers, packages, cursors.

Improved the query performance by creating materialized views.

Used PLSQL collections such as nested tables, Varrays, bulk collects etc.

Writing SQL and PL/SQL programs.

Generating Explain palns and identified long running queries and changed them by appling good joining techniques, Indexes, optimzer HINTS such as index, append, Ordered.

Getting QA and UAT sign off by following release cycle process and delivery of the items on time with best quality.

Project Experience #1

Client : HCL SEP-2016 TO JUL-2018

Project Name : Policy Promotion.

Skills : Oracle 11g, SQL, PL/SQL, SQL Developer, SQL SERVER.

Location : Hyderabad.

Description:

We use to provide the health cards and insurance to the employees in corporates like HCL Technologies, HCL INFRA and HCL BPO etc. For this we are maintaining data in database. Also we use get monthly endorsements from clients, so that we manipulate as per business logic and storing the same in database.

Client : EMPHASIS, SENSERA, VERIZON

Project Name : Risk Watch.

Skills : Oracle 11g, SQL, PL/SQL, SQL Developer, SQL SERVER.

Location : Hyderabad.

Description:

We use to provide the health cards and insurance to the employees in corporates like EMPHASIS, SENSERA and VERIZON etc. For this we are maintaining data in database. Also we use get monthly endorsements from clients, so that we manipulate as per business logic and storing the same in database.