6 + years of Information Technology experience including data analysis, data design, data support, data mining and migration of Oracle RDBMS systems on various platforms . UNIX/LINUX and WINDOWS Server platforms. Worked Over 6 years on different oracle database versions, which are Oracle 8i/9i/10g and 11g, SQL and PL/SQL, SQL Loader, Physical database design, Logical database design, Gap Analysis, Data Exports & Imports, Inbound/Outbound Interfaces, Application Support, Performance Tuning, Oracle Tuning & Optimization. Solid 6 years of experience on Oracle SQL and PL/SQL including all database objects : Stored procedures, Stored functions, Packages , TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections. Strong experience on various programming techniques , BULK COLLECT with FOR ALL, User defined exceptions, MERGE, Global temporary tables. A sturdy hold on performance tuning using AUTOTRACE, EXPLAIN PLAN, SQLTRACE/TKPROF using external Hints. Experience on working and designing Physical/Logical data models during initial phase of project blueprint. Hands on experience on various database utilities like SYS_CONTEXT, LISTAGG, PIVOT, UNPIVOT, DBMS_UTILITY, DBMS_SCHEDULER. Strong experience on full life cycles of software development including requirement gathering, blue print design, development, testing and support. Worked in different non Oracle database applications, MS Access, Tera data , SAP R3, J2EE, Microsoft reporting tools. Proficiency on using various Oracle utility tools, Sql Plus, Sql PlusW, TOAD, PL/SQL Developer, Sql Navigator, Sql *Loader, Export/Import with data pump. Strong experience on XML manipulations using XMLTYPE/CLOB with XMLTABLE, XMLELEMENT, XMLFOREST, DBMS_XMLSAVE, DBMS_XMLGEN. Experienced in working different environments and having capability of directly coordinate with business and other technical teams. Expertise in problem solving and diagnostic analytical skills and ability to communicate with different kind of individual at all stages. Good in team leading skills including assigning and coordinating the work with offshore teams and on shore peers.
Spearheaded a company-wide innovation initiative resulting in [
Companies Worked For:
Job Titles Held: