Rakesh Ranjan Pradhan Email & Phone Number

Ahmedabad, Gujarat, India

Ahmedabad, Gujarat, India

• 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..

Bengaluru, Karnataka, India

• 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.

Master Of Computer Applications - Mca, Computer Science

Bachelor Of Science - Bs, Computer Science

Intermediate, Science

10Th