Rakesh Ranjan Pradhan

Experience

• 

  Tech Mahindra

  Sept 2019 - Jan 2023

  PL/SQL Developer

  • Extensively involved in writing PL/SQL Stored Procedures, Functions, Packages and Triggersto implement business rules into the application• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQLprogram to load data from temporary tables into base Tables.• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.• Analyzing the requirement from the middleware developer and writing SQL queries for• Them.• Analyzing the existing resource consuming SQL queries reported by the System• Performance engineering team and modifying those for better performance.• Designing and implementing index strategy for the current project.• Generate SQL Scripts and create views for reports.• Developed Database Triggers to enforce security.• Successfully implemented Data Extraction using UTL_FILES in PL/SQL. Show less

• 

  BeyonData Solutions Private Limited

  Feb 2023 - now

  • Created database objects like Tables, Views, Procedures, Functions, Sequences, Indexes, Packages • Created Application from scratch. • Used shared components like Plugins, LOVs, Report Query and Report Layout, Application items • Created dashboard for Cable TV and Broadband. • Created Network Link Management Module in the same application to manage the link for Cable • Created Interactive grid, Interactive Report and Classic Report based on the requirement. • Customized the Form and Report using CSS and HTML. • Created Dynamic actions, Validations for whole application based on the requirementsImplemented RESTful web services in Oracle APEX for seamless integration with external systems and data sources.. Show less

  • Sr. Programmer Analyst

    Apr 2024 - now

  • Oracle PL-SQL Developer

    Feb 2023 - Apr 2024