Venkatesh S

Email : ac85zx@r.postjobfree.com

Mobile : 099********

Objective:

Seeking for a challenging and interesting role of SQL programmer in a company where my experience and knowledge can be utilize and enhance.

Professional Profile:

Worked as Senior Software Engineer in 3I infotech Ltd.

Ambitious and self-motivated SQL developer with a strong technical background and

3.9years of work experience

Functional domain experience in Insurance.

Responsibilities Handled:

Plan, design, and implement application database code objects.

Interacted with client to define business requirements and scope of project.

Involved in creating procedure, function, view and enhancing queries, based on requirements.

Perform quality assurance and testing of SQL environment.

Implementing Optimization strategies like Indexes, Parallel Job creation.

Database Technologies:

Oracle PLSQL & Oracle Forms and Reports

Work Experience:

From 28th January 2019 to Till Date as Senior Software Engineer in Tata Consultancy Services Ltd. (Innova Solutions) Mumbai.

From 9th April 2015 to 14th December 2018 as Oracle SQL & PLSQL Developer in 3I Infotech Ltd, Chennai.

Professional Experience:

1.

Company 3I Infotech Ltd, Chennai

Client Momentum Metropolitan Insurance, South Africa

Role Senior Software Engineer

Tools PLSQL Developer & Oracle Forms

Responsibilities

Developed Parallel processing of automated payment, instead of single execution parallel execution using oracle Jobs.

Dynamic SQL execution and bind variable handling to improve performance in the system

Build new framework to execute the Business logic in table data instead of package, executed dynamic through the new framework and new changes in the business logic will be simpler through the table data instead of package or procedure change. Impact analysis will be very easy.

Build global collection to cache the values which are frequently used inside the package instead of retrieving from the table whenever required.

Implemented all new oracle functionality in the existing process to improve performance tuning. E.g. Result cache, DBMS_SQL, DBMS_PARALLEL_EXECUTE, Hints

Writing SQL queries to implement business logics.

Creating and Reviewing Stored Procedures, Functions, and Views.

Strength:

Ability to take initiative, Teamwork & Co-operative self-Motivated.

Excellent decision making skills with a positive approach.

Hard worker and result oriented.

Skill Set:

Database Oracle

Language SQL, PL-SQL

Academic Qualifications:

B.TECH (Information Technology) from Anna University in 2014 with First Class.

H.S.C (Computer) in 2010 with First Class.

S.S.C in 2008 with First Class.

Personal Details:

Name Venkatesh S.

Permanent Address 2/6 centre street, Elandurai, Villupuram - 607209

Date of Birth 24-May-1993

Gender Male.

Nationality Indian.

Languages Known English and Tamil.

Declaration:

I hereby declare that the information given above is true to the best of my knowledge & belief.

Date:

Place: Venkatesh S

Contact this candidate