Gayathri Perni
About Gayathri Perni
Gayathri Perni is a Senior PL/SQL Developer at American Electric Power, where she has worked since 2012 in the Columbus, Ohio area. She holds a Master of Computer Applications from Nagarjuna University and specializes in advanced Oracle utilities and performance tuning techniques.
Work at American Electric Power
Gayathri Perni has been employed at American Electric Power as a Senior PL/SQL Developer since 2012. Over her 12-year tenure, she has worked in the Columbus, Ohio area, contributing to various database management projects. Her role involves utilizing advanced Oracle utilities to enhance database performance and efficiency. She regularly addresses production issues and optimizes existing queries, demonstrating her capability in managing critical database functions.
Education and Expertise
Gayathri Perni earned her Master of Computer Applications (M.C.A.) degree from Nagarjuna University, where she studied Computer Science from 2002 to 2005. This educational background provides her with a solid foundation in computer science principles, which she applies in her professional role. Her expertise includes advanced database management techniques and performance tuning.
Technical Skills and Tools
In her role, Gayathri utilizes advanced Oracle utilities such as DBMS_PIPE and UTL_FILE for efficient database management. She has extensive experience in optimizing Oracle reports through performance tuning techniques, including SQL Trace, Explain Plan, and TkProf. Additionally, she employs materialized views in scenarios with infrequent data changes, showcasing her understanding of database design principles.
Database Design and Development
Gayathri has a strong background in designing and generating various database objects, including tables, views, and sequences. She is also involved in the design of front-end applications using Forms 6i/9i and Reports 6i/10g. Her coordination with offshore teams facilitates the integration of business requirements into these applications, highlighting her collaborative approach to project development.