Ravi Raushan Kumar

About Ravi Raushan Kumar

10+ years of experience in Data Modeling, Snowflake, Database Designing, Oracle PL/SQL Development and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Experience in Team Handling. Experience of working with projects in Ecommerce, Banking and Financial services, Telecom, Tower and Billing Domain. 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. Effectively made use of Function, Procedure, Package, Triggers, Indexes, Table Partitioning, Index Partitioning, Collections, Bulk collect, Analytical functions, Materialized Views, Ref Cursor etc. Experience in Data warehouse concepts, ETL. Created Tables, Views, Synonyms, 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. Loaded Data into Oracle Tables using SQL Loader and External Table. Created Packages and Procedures to handle the partitioning, index and statistics 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, Stats and HINTS. Involved in the problem tracking and bug fixing of various problems reported by the users in the production environment. Experienced in preparing Technical documentations(Coding design, Impact Analysis, Test cases, SOE, Release Note document etc.). Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Experience

1. Project Manager

   Cognizant

   Oct 2022 — Present · Gurugram, IN

   I\'m working as a Senior Data Modeler using Data Vault 2.0, Database Design, Data warehouse implementation and Data Transformation.E2E ETL and Data warehouse implementation to get source Data and using a flexible model make it Visual.

Education

• R.S.B. Inter College

  10th, PCM

• Samastipur Bihar

  I.Sc., Science

• Indira Gandhi National Open University

  Master of Computer Applications (MCA), Computer Science

  2008 — 2011

• Indira Gandhi National Open University

  Bachelor of Computer Application (BCA), Computer Science

  2005 — 2008

• Maharshi Dayanand University

  M.Tech , Computer Science and Engineering

  2016 — 2018

Skills

• Databases
• Sql
• Unix
• System Analysis and Design
• Vendor Management
• Oracle Pl/Sql Development
• Dbms
• Software Documentation
• Rdbms
• Software Engineering
• Oracle
• Team Management
• Dbms and Rdbms Concept
• Html
• Pl/Sql
• Rman
• Software Development