Highly skilled & experienced Oracle professional with wide knowledge in variety of programs and procedures. Adept to all types of data storage & extraction and various oracle technologies. Over 13 years of strong experience in system analysis, database design, development, testing and support of Oracle 8i, 9i, 10g & 11g, Good Knowledge on various modules in Oracle Apps. Strong exposure in Oracle server side programming which includes SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialized Views, Temporary tables, Object Oriented PL/SQL Programming. Strong exposure in developing applications using Oracle 6i & Oracle 10g developer suites. Expertise in advanced PL/SQL programming using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables, Dynamic SQL, Exception Handling. Exposure & knowledge of designing data model in Oracle 8i/9i/10g/11g and building structural changes to the database objects on low level / high level. Highly skilled in trouble shooting & identifying performance issues, debugging and performance tuning using Explain plan, Indexing, Hints, Partitioning, etc. Extensively used packages like DBMS_STATS, UTL_FILE, DBMS_SCHEDULER and UTL_SMTP. Strong knowledge in SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP. Experience in Dimensional Modeling, writing ETL Stored procedures and designing DB for reporting. Experience in Requirement, Gap & Impact analysis, Functional and Technical design documentation. Experience in UNIX shell scripting & VB scripting. Proven records in translating business needs into technology. Expertise in implementing systems to provide end to end solutions. Managed assignments as Team & Project Lead and conducted meetings with all levels of management. Experience in onsite-offshore business model and coordinating with team in off-shore. Experience in all phases of the Software Development Life Cycle including analysis, resource planning, code development, testing, implementing and maintenance.