Venkatesh S
Email : *************@*****.***
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