11+ yrs of Experience in IT Industry.
Programming experience in Oracle ADF development. Also have experience in Qlikview . Also experience in Oracle PL/SQL in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).Also 1year experience in IBM Cognos Business Intelligence Report Development & Analysis.
Experience in Data warehouse & Business Intelligence.
Developed Materialized Views for Report Performance Tuning.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Developed procedure using Oracle Advanced Queuing & Dequeuing such as DBMS_AQ.DEQUEUE package.
Leading development team and guiding towards creative solutions.
Creating requirements in cooperation with the head of development and Business Users.
Involved in effort estimation according to the complexity of the project.
Involve working in Agile Scrum.
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 working on waterfall model.
Invoved in preparing Unit Test Cases, Code Reviewing in UAT scenarios before project gone live.
Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD,PLSQL Developer and SQL*LOADER.
Knowledge and experience in BI environment utilizing tools such as Cognos 10.2.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio and Metric Studio)