Developer Sql

K.S. LAVANYA

KUMBAKONAM (Tk), ***********@*****.***

TANJORE (Dt). +91-956*******

CAREER OBJECTIVE:

To work in an open and exciting environment having excellent growth prospects and to take up innovative and challenging projects and thus build a career with a leading corporate with committed and dedicated people, which will help me to explore myself and utilize my potential. FRESHERS FOR IT :

I have knowledge about oracle developer (sql and plsql developer),Immediate joiner SUMMARY:

Good knowledge in SQL and PL\SQL query optimization:

• Oracle 11G, SQL DDL and DML

• Created involved the SQL Plus comments, Pseudo column, Sequence, Synonyms, Analytical functions.

• Created the concepts of SQL in Set Operators

• Strong in SQL concepts in Materialized view.

• Conducted performance tuning of the database for optimal performance.

• Automated SQL*LOAD and External table to load data from flat files.

• Involved in all phases of a migration project from Oracle 11g.

• Created tables Constraints, Index (b. tree, bit map, composite)

• Exports in Single row function in SQL

• Good knowledge in PL\SQL concepts are Collection, triggers, cursors

• Strong concepts in PL\SQL queries like Stored procedures, Function, packages

• Involved in all phase’s oracle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

• Experienced in requirement analysis, coding and testing various modules in a Software development life cycle.

• Ability to work individually as well as in a team with excellent problem solving and capabilities.

• Knowledge in Performance tuning

TECHNICAL SKILLS:

• Database : ORACLE

• Language : SQL, PLSQL

• Tools : ISQLPLUS, SQLPLUS, TOAD, SQL DEVELOPER

• Version : 10G,11G,12C AND 18C

• Methodology : AGILE

AREA OF INTEREST:

• ORACLE DEVELOPER (SQL AND PL/SQL)

COURSE COMPLETED:

ORACLE DEVELOPER (SQL AND PL/SQL) AT GREEN TECHNOLOGY, PORUR, CHENNAI

From: NOVEMBER 2019 to JANUARY 2020

Technical Skill Trained:

• ORACLE Database - 10G,11G,12C AND 18C

• Languages of SQL, PLSQL with technical tools of ISQLPLUS, SQLPLUS, TOAD, SQL DEVELOPER

• Also gained Knowledge in Agile Methodology

WORK EXPERIENCE:

ACCENTURE, SOLINGANALLUR, CHENNAI

From: NOV 2016 to JAN 2018

• I have one year of 3 months experience in Transaction process associate at ACCENTURE, Chennai. (claims process in health care process, provider team and triage team are work in process.

• Download files from Citrix Platform and doing Naming Conversion.

• Handling various kinds of invoice such “claims process, triage process change setup and change the address of claims process

EDUCATIONAL PROFILE:

DEGREE INSTITUTION BOARD YEAR OF

PASSING

% CGPA

MCA

SASTRA

University

SASTRA University 2016 67.0

BCA

IDHAYA

Kumbakonam

BHARATHIDASAN

University

2014 82.0

H.S.C

T.H.S.S

Kumbakonam

State board 2011 50.0

S.S.L.C

St. Joseph’s

Kumbakonam

State board 2009 68.4

ACADEMIC PROJECT:

• Developed a mini project in UG on SUPERMARKET SYSTEM

• Developed a mini project in PG on PERSONAL FINANCE MANAGEMENT SYSTEM

• Major project in PG on DATA HIDING IN IMAGE USING STEGANOGRAPHY TECHNIQUE

IMPLANT TRAINING

• Participated in HCL for Implant training in Chennai

• Participated implant training Programmer Logistic Research Lab CO-CURRICULAR ACTIVITIES

• Participated in Debugging Event at Annai College, Kumbakonam

• Participated in Photoshop Event at SASTRA College, Kumbakonam

• Participated in Career development program in college campus.

• Awarded with certificate of proficiency, Excellence & commitment for academics in college.

• Involved in innovation of process improvement projects. ADDITIONAL QUALIFICATION COURSES

• Studied DCA in NCC, Kumbakonam

• Studied PGDCA in TNCC, Kumbakonam

• Studied .NET and SQL in CSC, Kumbakonam

PERSONAL PROFILE:

Name : K.S. LAVANYA

Father’s name : K.S. SUNDAR

Mother’s name : K.S. GIRIJA

Gender : FEMALE

Date of birth : 22-04-1994

Marital status : single

Nationality : Indian

Permanent Address : 473-F, Veera Vanjinathan St.,

Annalagraharam - 612401

Kumbakonam (Tk),

Tanjore (Dt).

Mobile : +91-956*******

Language Known : Sourashtra, Tamil, English

DECLARATION:

I do hereby confirm that the above-mentioned information is correct and true to my knowledge.

Place: Chennai K.S. LAVANYA

Date: 29.10.2020

Contact this candidate