Umashankar Panda Email and Phone Number

Analysis of ticket (Function Specification Document) based on new Development, Enhancement or Fix raised by client.Creation of new Forms in Application using Oracle PL/SQL and JavaScript/jQuery, HTML for UI part as per coding standards defined in organization.Creation of new Jasper Reports. Also migrated existing Oracle reports to Jasper reports.Preparing project related documents like Design Specification, CAST, Test Plan, etc.Responsible for Unit testing based on test plans and dev testing on DEV, TEST and STAGE environment.Interacting with Business Analysts through scrum calls and understanding Business Requirement Document.Involved in the development of the web-based application as per the client requirements using HTML, CSS, JQUERY and JavaScript.Used joins, sub queries and correlated sub queries and analytical functions.Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.Creating stored programs in the form of PL/SQL Packages, Procedures and Functions.Writing Queries, creation and modification of tables.Managing indexes, constraints, views, synonyms and stored program units.Handled errors using Exception Handling extensively and for the ease of debugging and displaying the error messages in the application.Experience in Performance Tuning concepts such as Explain plan and Execution Plan.Solved various Complex issues, specific to business rules customization using cursors.