Keerthana Pathmanaban

Experience

• 

  AnWest Solution LLC

  Jun 2020 - Mar 2022

  Database Support

  • Troubleshooting and debugging SQL and PL/SQL code to identify and resolve issues.• Developed SQL queries using joins, sub-queries, analytic and group functions, and set operators.• Create and modifies database objects such as tables, indexes, and constraints.• Writing and executing SQL queries to retrieve data from Oracle databases.• Writing stored procedures, functions, and triggers to automate business processes.• Assisting with the development and maintenance of database structures, tables, and views.• Handled the client through emails and calls.• Implementing data validation Show less

• 

  Excelencia Consulting

  Apr 2022 - Oct 2023

  Analyst

  • Good knowledge and working experience in SQL, PLSQL and Oracle APEX.• Good experience in writing SQL Queries, Views, Materialized Views, Database Links, PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Exceptions• Experience in developing forms & Reports based on views, tables and procedures.• Good experience in front end development using APEX.• Experience in developing Classic Report, Interactive Reports, Interactive Grid, APEX_MAIL and etc.• Good experience in various authentication/Authorization schemes within APEX, APEX Plug-ins, Shared Components, and Session Management • Used dynamic actions, Validations, and processes in reports like classic, Interactive, and interactive grid reports. • Developing Excel, Word, PDF, XML Templates and Reports in Oracle BI Publisher.• Created Concurrent programs, Executables, and Request sets.• Created PL/SQL Packages and registered them as a concurrent program in Oracle APPS.• Hands-on knowledge in preparing technical documents like MD070, MD050, and MD120 Show less

• 

  Retransform, an Apex Group company

  Nov 2023 - now

  Software Programmer