VALLINAYAGAM IYYAPAN

To pursue a creative career with a challenging environment and committed people that would help me learning and where I could be a key player to work towards the continual improvement of the organization in terms of its Quality & Customer satisfaction. PROFESSIONAL SUMMARY 2.8 years of experience in the Oracle PL/SQL Developer/Production Support experience in software analysis, design, development, testing and implementation of full life cycle web based software applications. Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based). Bulk data Collecting, Performance tuning of huge data with use of PLSQL collections and records. Work closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review. Experienced in Query Optimization, Debugging and Improvising performance of the applications and also has good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques. Create, develop and maintain SQL processes for channel performance data warehousing Experience in working with Hints, Sequence and Indexes. Work experience in writing SQL queries, Views, Materialized views Exposure writing complex SQL Queries, advanced objects like V-arrays, Nested Tables, Records, Cursors, Collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL. Involved in 24X7 support and maintenance work. Worked as an PLSQL Developer and establish strong relationships with end users and technical resources throughout established projects Partners with development teams/vendors to provide reporting on in flight software development projects