Aakanksha S.

I am an IT professional with over 5 years of industry experience in Oracle Database. I have a very strong hold in Oracle SQL-PLSQL and have performed the following responsibilities as an Oracle Developer: - Perform an end-to-end structured analysis on the impacts of the requirements on the database design. - Used PL/SQL to create packages, functions, and procedures. - Developed complex forms and reports in Oracle Forms and Reports 10g, 11g. - Involved in testing the application for Oracle 10g to 11g upgrade. - Worked on integration of systems and data communication between systems through web-services, middleware, and EDI. - Tuning of the SQL queries, which takes a long time to process the request using Explain Plan, Hints to reduce the response time. - Involved in all phases of database development, from needs assessment to QA/QC, design, and support. - Worked on crontab on Linux. - Developed various database-related schema changes and configuration changes for four major releases of our product. - Involved in implementation of releases on production and support the same. - Expertise in Software Development Life Cycle, followed Waterfall, and Agile methodologies. - Migrated Oracle forms 6i to Java using Lanterna.