Around 11 years of IT experience which Includes area like Data Warehouse/ETL. Oracle, TIDAL scheduler, designing and Unix Scripting.
• Programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 12c/11g10g/9i, PL/SQL,
SQL *PLUS, sql developer.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• VB coding for new application as well as tuning for existing systems and code review.
• Creating Crystal reports.
• Solid understanding of relational database system structure, Oracle Database architecture and design and having performed some DBA duties, such as creating and managing Oracle Database Objects.
• Good problem solving and trouble shooting skills. Good skills with performance improvement for pre-existing applications. Good spoken and written communication skills.
• Good understanding of Visual Source Safe 6 (VSS),SVN and GIT.
• Created Technical Design documents for major enhancements and attended Technical Design Reviews.
• Conducted Peer Reviews to ensure quality work
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Software development experience in the Agile Methodology.
• Involved in the performance of tuning of the database.
• Involved in Writing/Tuning database packages, stored procedure and functions using PL/SQL.
• Performance tuning using SQL plans, developing coding standards and database management.
. Excel VBA Reporting