nihar ranjan sahoo primary skills secondary skill total experience present company current location email nihar0808gmailcom mobile india 91 8018319781 91 8637269489 plsql oracle forms report developer unix shell scripting oracle application developer 58 years tata consultancy servicetcs bangalore professtional profile master computer application mca excellent curricular professional history 58 years experience skills sqlplsql oracle forms reports application maintenance unix shell scripting greatest strength dedication commitment towards work ability handle multiple roles simultaneously 2 years experience part time sr lecturer aptech computer education jharkhand vital part involved phases sdlc software development life cycle analysis design development testing implementation maintenance timely delivery aggressive deadlines design development maintenance oracle forms reports creating libraries menus hierarchical trees oracle forms developed different types reports matrix masterdetail letter etc created database objects like tables views materialized views refreshing technique triggers synonyms constraints dblink global temporary table gtt function based index fdi expertise application development using oracle 9i10g11g12c plsql sqlplus toad sql loaderexternal tableutl file effectively made use table functions indexes table partitioning collections analytical functions proficiency writing complex sql joins subquery corelated subquery nested queries unions analytical functions cursors writing complex queries conventional way well ansi standards proficiency writing complex plsql stored procedures complex functions sub program packages error handling export import schema export import text fielscsv files collections oracle utilities refcursor