Jile La Obstacle
Summary: * 8+ years of experience in systems Analysis, design and development of complex software systems for various domains. * Good exposure of Software Development Life Cycle methods (waterfall etc.). * Extensive experience in Design, Development, and Enhancement and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. * In-depth Knowledge of Oracle Architecture, Data Dictionary and DBMS Packages. * Performed a major role in database migration. * Expertise in creating database Triggers, Stored Procedures, Packages, functions, Indexes. * Strong knowledge in Oracle cursor management and exception handling. * Worked on DML, DDL, and TCLoperations. * Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems. * Extensively used PL/SQL features like collections, nested table, Varray and Bulk collect for high performance of stored procedures. * Good working experience with the usage of Collections, Bulk Insert, Global temp table, Nested tables, External tables, advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors. * Strong Knowledge on Object oriented Programming. * Experience in developing the webpage using JSP, extensive experience on Java, Java script, Hibernate. * Experience in using Oracle in-built packages like UTL_FILE, DBMS_SQL etc. * Experience in designed and deployment of UNIX Shell Scripts. * Expert knowledge in using data modeling tools like ER-WIN and ER diagrams with Model mart exposure. * Extensive Knowledge in Normalization Techniques for designing database Relational technology on N-Tier and created database reports to monitor the project. * Experience in debugging the performance issues and bugs within packages, forms, and reports using dbms_output. *