Niranjan Kumar Reddy Kadapana  new_releases

• Having 5 years of programming experience as an Oracle PL/SQL Developer and as a support analyst • Having Experience in Development, Maintenance, and support projects. • Having domain expertise in Automobile, Health care and WMS (Warehouse management systems (SCM) • 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/11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, • Strong experience in Data warehouse concepts, ETL. • 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 and External tables • Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE. • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables. • Worked extensively on Ref Cursor, External Tables and Collections. • Expertise in Dynamic SQL, Collections and Exception handling. • Experience in SQL performance tuning. • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans, and Indexes. • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. • Experience in ETL techniques and Working experience in ETL Tools (SAP BODS, INFORMATICA) • Created Shell Scripts for invoking SQL scripts and scheduled them using crontab. • Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team. • Having good knowledge on oracle database architecture (SGA, PGA, Datafiles, table space, segments, extents, Data buffer cache, library cache, redo log files. etc.)