SINDHU V
PLSQL DEVELOPER
Chennai
Summary
- To work in a dynamic organization in the field of IT that provides me generous opportunities to Explore &outshine while accomplishing personal, professional as well as organizational goals.
- Having 4.1 years of professional experience in Oracle as a PL/SQL Developer.
- Extensive RDBMS experience using oracle 11g SQL and PL/SQL.
- Strong technical expertise in creating and modifying database objects like Tables, Views, Indexes, Triggers, Sequences and Synonyms.
- Experience in writing complex SQL queries like Joins, Sub queries, Set Operators, Analytical Functions and Group Functions.
- Extensive Experience in developing PL/SQL Procedures, Functions, Packages, Collections (Nested Tables), Cursors, Exceptions, Dynamic SQL, DBMS Scheduler and Ref cursor.
- Proficient in Oracle utilities and tools such as SQL DEVELOPER, SQLPLUS, TOAD.
- Expertise in Performance Tuning using various types of Hints, Indexes, Joins and Bulking Techniques.
- Strong Experience in loading data from flat file to table using SQL Loader.
- Having Good knowledge in Table Partitioning, GTT, Materialized View, UTL_FILE, External Tables and Application Tuning.
- Involved in all phases of Software Development Life (SDLC) from collecting the requirements, analyze, design, development, testing and maintenance.
- Accomplish project goals consistently with elegant scalable code. Works great with team members under Agile methodology.
Overview
4
4
years of professional experience
5
5
years of post-secondary education
2
2
Languages
Work History
PL/SQL Developer
Trucube Technologies
12.2020 - Current
- Developed Procedures, Packages and Functions to implements the business Requirements using PL/SQL
- Created/Modified database objects like Tables, Views, Indexes, Triggers, Sequences and Synonyms
- Written complex queries using Sub queries, Joins and Set Operators to retrieve data from the multiple tables
- Extensively used Cursors, Bulk Collect with Bulk Bind statements for manipulating the large amount of data and enhance performance
- Created Dynamic SQL script in PL/SQL to build SQL statements dynamically at run time
- Used Explain Plan, Hints for performance tuning of SQL and PL/SQL queries
- Used DBMS Scheduler to automate the PL/SQL programs
- Created Indexes on the tables for faster retrieval of the data to enhance database performance
- Handled errors using System Defined Exceptions and User Defined Exceptions
- Optimized and enhanced the existing procedures and SQL statements for the better performance
- Using SQL Loader in order to load data from flat files into oracle tables
- Coordinated with front end team provide them with the necessary stored procedures and packages and the necessary insight into the data
- Managed unit testing of the PL/SQL Programs
- Worked with Production Support team to immediately resolve failures in production data processing
- Attended walk through, code review and Status meeting to discuss the status of the project
Education
M.Sc - Computer Science
Auxilium College
01.2011 - 01.2013
B.Sc - Computer Science
D.K.M college
01.2008 - 01.2011
Skills
- SQL
- Oracle PL/SQL
- Oracle 10g/11g
- Triggers and functions
- Performance tuning techniques
- Agile development methodologies
- SQL query optimization
- Materialized views management
- Code debugging
- SQL analytics
Personal Information
- Father's Name: Vel murugan.R
- Date of Birth: 01/03/89
- Marital Status: Married
Timeline
PL/SQL Developer
Trucube Technologies
12.2020 - Current
M.Sc - Computer Science
Auxilium College
01.2011 - 01.2013
B.Sc - Computer Science
D.K.M college
01.2008 - 01.2011
Similar Profiles
SINDHU VSINDHU V
PLSQL Developer at Trucube TechnologiesPLSQL Developer at Trucube Technologies
Vyankatesh WakharkarVyankatesh Wakharkar
Team Lead at Tata Technologies Ltd, Tata Technologies LimitedTeam Lead at Tata Technologies Ltd, Tata Technologies Limited
Ayush SinghAyush Singh
Client Partnership Manager at Tyroo Technologies Ltd (Divison of Smile Internet Technologies Ltd)Client Partnership Manager at Tyroo Technologies Ltd (Divison of Smile Internet Technologies Ltd)
Herbert Jeffrin MHerbert Jeffrin M
Specialist - Global Funds Control at Bank of New YorkSpecialist - Global Funds Control at Bank of New York
Zaheer Syed.SZaheer Syed.S
Team Manager at GSR Global ServicesTeam Manager at GSR Global Services