About

ArumugaPriya M is a Technology Analyst at Infosys with over 3 years of programming experience in Oracle PL/SQL Development and L1 Production support. She has been involved in all phases of the Software Development Life Cycle (SDLC) including analysis, design, development, testing and implementation against aggressive deadlines. ArumugaPriya is an expert in SQL and PL/SQL programming, developing complex code units. She has experience in developing applications using SQL statements like DDL, DML and TCL with Constraints features of Oracle. ArumugaPriya has strong knowledge in writing complex queries using Table Functions, Sub-query, Joins, Analytical Functions and Pseudo columns. She has effectively made use of Oracle database objects such as Tables, Views, Materialized views, Synonyms, Sequence and Index. Additionally, she has knowledge in table partitions, external table, Rollup, Cube, GTT and Multi table insert. ArumugaPriya has also been involved in migrating data from flat files to tables using SQL*LOADER. She has developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using PL/SQL and used Cursor to fetch multiple records in PL/SQL sub program. ArumugaPriya has handled errors using Exception Handling extensively for the ease of debugging and displaying the error message in the application. She has worked on advanced PL/SQL constructs like Collections (Nested Tables, Varray, Index By Table) and has knowledge in bulk collections (FOR ALL, LIMIT, Bulk Exception Handling) for better performance and easy retrieval of data, by using context switching between SQL and PL SQL engines. ArumugaPriya has good knowledge in Oracle supplied packages like UTL_FILE for generating reports, DBMS_XMLGEN and Dynamic SQL, Records and Ref cursor. She has been involved in performance tuning and query optimization using utilities like DBMS_PROFILER, table partitions, index, hints, Cost-Based Optimization (CBO) and Explain Plan. ArumugaPriya is an expert in analyzing and converting business requirement into code. ArumugaPriya has a Bachelor of Technology in Information Technology from Jayaraj Annapackiam CSI College of Engineering. She has also worked as a Software Engineer at thinclesoft in the past. ArumugaPriya's tech stack includes SQL, Software Engineering and Testing. With 4.77 years of relevant experience, ArumugaPriya is a skilled and experienced Technology Analyst with expertise in