Ravi Kumar

Professional Information:                                                                

·        10+ years of experience in analysis, design, development, testing and implementation as ORACLE PL/SQL  DEVELOPER and ODI 11g/12c developer.

·        Working on Snowflake .

·        Working on DBT (data build tool) .

·        Expertise in using Oracle 9i,10gand 11g databases.

·        Proficient working experience in SQL, PL/SQL,StoredProcedures, Functions, Packages, DB Triggers and Indexes.

·        Good Working Experience in Forms 9i& knowledge on Reports 9i Reports

·        Worked on Unix Shell Scripting.

·        Strong skills in using tools such as PL/SQL developer, SQL*Loader, TOAD ,Sql Navigatorand SQL*Plus.

·        Experienced in Tuning SQLStatements and Procedures for enhancing the load performance in various schemas across databases.

·        Experience in DBA activities such as Performance Tuning, taking database backup using Oracle data pump.

·        Hands on experience in preparing Technical documentation.

·        Involved in creating scripts for Creates, Alters and Data Modifications and worked with DBA for implementation.

·        In addition to excellent technical abilities possesses strong oral and written communication skills, analytical and interpersonal skills.

·        Good team spirit and organized working habits with willingness to learn new concepts.

·        Knowledge in Data modeling (Dimensional & Relational) concepts like Star-SchemaModeling, Snowflakes Modeling, fact and dimension tables.

·        Knowledge on Informatica.

·        Experience with Large Database query optimizations.

·        Worked on APEX(web development tool).

·        Knowledge on Oracle Application modules Inventory, AP, AR and GL.

·        Worked in ODI 11g.In ODI created packages , Procedures , interfaces, variables Scenarios as per the requirement .And knowledge in ODI 12c.

·        Scheduled ODI jobs using ODI Scheduler.

·         Used ODI utility as odisendemail for sending the emails to the group if any job got successful or got failed.