vaibhav
Software Consultant(Oracle Developer)
Join Date
May 2017
Country
Gender
Male
Age
Not Specified
About vaibhav
• 4 years of IT Experience in Business requirement Analysis, Data modeling and design techniques.
• 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 in using BI tools like OBIEE, QlikView
• Strong programming experience as an Oracle PL/SQL, SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Excellent knowledge on both OLAP and OLTP systems.
• Experience in Data warehouse concepts, ETL and reporting tools.
• Experience in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in QlikView tool for building dashboards to represent the same to the customers.
• Strong experience in writing Complex SQL Analytical queries for reporting purpose using Oracle Analytical functions.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loading Data into Oracle Tables using SQL Loader utility.
• Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Good communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• 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 in using BI tools like OBIEE, QlikView
• Strong programming experience as an Oracle PL/SQL, SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Excellent knowledge on both OLAP and OLTP systems.
• Experience in Data warehouse concepts, ETL and reporting tools.
• Experience in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in QlikView tool for building dashboards to represent the same to the customers.
• Strong experience in writing Complex SQL Analytical queries for reporting purpose using Oracle Analytical functions.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loading Data into Oracle Tables using SQL Loader utility.
• Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Experience in SQL performance tuning using Cost-Based Optimization (CBO).
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Good communication, interpersonal, analytical skills and strong ability to perform as part of a team.
