Life Insurance Developer

Ganesan babu

***************@*****.***

Mobile: +91-709*******

OBJECTIVE

Intend to build career with reputed organization with committed and dedicated people, which will help me to explore myself fully and willing to work as a key player in creative and challenging environment using Oracle PLSQL Technologies

EXPERIENCE SUMMARY

Total 5.5years experience in Software industries.

Having 3.4years of Progressive and Dynamic experience in software analysis, design, development, testing and implementation of full life cycle web based software applications.

Strong skills include Oracle 9i, Oracle 10g/11g, SQL, and PL/SQL.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Have good experience in IT industry in broad range of functions & Involved in development of various software projects and having complex SQL Queries and data Migration.

Extensively created and worked with Procedures, Functions, Packages, Triggers and PL/SQL advanced concepts.

Worked with Joins, Cursors, Ref cursors, Views, Materialized Views.

Expert in query optimization.

Tuning of SQL Queries

Export and using SQL Loader.

Involved in PL/SQL Programming.

Performed functional testing for the procedures and packages.

Experience in Production support .

Working with basic UNIX commands.

Expert in handling source control activities, code deployments and environment preparation including retrofit activities for different releases.

Good ability to quickly grasp and master new concepts and technologies.

JOB PROFILE

1. Working as an Virtusa consulting pvt Senior software engineer 2018 to Till.

2. Working as an Capgemini Pvt ltd Nov 2014 To June 2018

ACADEMIC PROFILE

B.TECH(Information Technology) (2012) from Kongunadu College of Engg and Technology.

SKILL SET

Operating system

Windows 7, Unix

Database

Oracle 9i/10g/11g

Languages

SQL, PL/SQL

Tools

SQL*Plus, SQL Developer, Toad

WORK EXPERIENCE

1.SVB bank. 2014 to 2015

PL/SQL Developer

Description:

This Project is Designed and developed for the SVB Bank located in Atlanta United States. The main objective of this project is to handle external loan products for all customers.

Roles & Responsibility:

Involved in the whole life cycle of the project.

Responsible for requirement gathering from business user.

Responsible for developing technical specifications from business requirements.

Understanding the requirements and carrying out impact analysis.

Extensively used Refcursor, dynamic SQL

Database Query tuning and Implementation.

Communicate with clients for the issues updates.

Attend daily status meetings with the onsite coordinators along with Client.

Environment: Oracle 10g/11g, PL/SQL, SQL* PLUS, UNIX Shell Scripting, TOAD, OOAD.

2.VODAFONE Telecom 2015 to 2017

PL/SQL Developer

Description:

The SQL Change Automation SSMS extension stores local repositories in %localappdata%\Red Gate\SQL Change Automation\Ssms. The settings.json file contains local settings that can be configured by editing this file directly.

Responsibilities:

Involved in modifying various existing packages, procedures, functions and Indexes according to the new business needs.

Created function based indexes to improve performance.

Worked with Materialized View, Join Cursor & views.Developed complex stored procedures and functions using PL/SQL and optimized for maximum performance .

Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements

Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan for Cost based optimization.

Provided production support for various different defects in the code.

Involved in debugging various defects relating to implementation of business logic.

3.Bajaj Life Insurance 2018 to till date

PL/SQL Developer

Description:

In My Project involved maintain the customer details. And also maintain the database .policy maturity and claim to customer and resolve the issues. Some kind of customer apply to an death claim and policy surrender .In my project package and group policy of an company.

Responsibilities:

Involved in modifying various existing packages, procedures, functions and Indexes according to the new business needs.

Created function based indexes to improve performance.

Worked with Materialized View, Join Cursor & views.Developed complex stored procedures and functions using PL/SQL and optimized for maximum performance .

Used Explain Plan and Oracle optimizer hints to enhance performance of SQL statements

Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plan for Cost based optimization.

Provided production support for various different defects in the code.

Involved in debugging various defects relating to implementation of business logic

PERSONAL PROFILE

Father’s Name : G.Prakashbabu

Marital status : Single

Languages known : English, Tamil

Gender : Male

Job type : Permanent

DECLARATION

I hereby declare that all the statements made above are true to the best of my knowledge and belief.

Date :

Place : Chennai (PRAKASH BABU)

Contact this candidate