Description
PROFESSIONAL SUMMARY * Over 1.9 years of diversified experience working in the Information Technology industry primarily as an Oracle PL/SQL developer. * Skilled at Analysis, Design, Development, Support, and Performance tuning of applications using Oracle SQL, and PL/SQL. Worked with a financial client, and implemented business driven functionality using Oracle 11g/10g for development, data conversion, and migration projects. * Excellent skills in writing PL/SQL Stored Procedures, Functions and Packages using Oracle 11g/10g. * Expertise on Ref Cursor, External Tables, Dynamic SQL, Collections and records and Exception handling. * Strong experience in Cursor management, Exception Handling, performance tuning (PL/SQL), and optimization of SQL statements using SQL Trace, Explain Plan, Indexing, and Hints. * Expertise in creating and maintaining Table Partitioning, Collections and records, Analytical functions, Materialized Views, Query Re-Write, and Transportable table spaces. * Experience in Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Datastage as ETL tool on Oracle. * Expertise skills in using the tools TOAD, SQL *Loader, Oracle SQL Developer and Oracle utilities like DBMS_PIPE, UTL_FILE, Exp, Imp and Data pump. * Experience with Agile practices such as Backlog Grooming, Sprint planning, Story sizing, Story Prioritizing, Standup meetings, and User Story Demos on Agile Project implementation. * Having Good understanding and experience of Object Oriented Concepts. * Wrote Queries to retrieve data in XML format from the tables. * Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, and Exp/Import. * Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.
Accomplishments
Highlights:
Keywords
