Summary
Overview
Work History
Education
Skills
Software
Timeline
Generic
RavieKumar Chandrasekeran

RavieKumar Chandrasekeran

Software Engineer
Chennai

Summary

Professional Summary:


Oracle Developer with more than 6+ years of experience in Oracle 11g/10g as an PL/SQL Created tables, packages, indexes, functions, using SQL Developer.

Excellent skill in Triggers, Stored Procedures and Standard Packages.

Extensive working knowledge in database objects like creating tables, views, indexes, sequences and constraints

Proficient in Oracle Tools and Utilities such as SQL* Loader, TOAD, SQL Developer.

Experience with software Development life cycle (SDLC) process

performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing.

Experience in interacting with Business/Technology groups to understand the new Change Request.

Experienced and Knowledge in SQL Query Tuning, PL/SQL Block Tuning and Performance Tuning (Explain Plan ) of Reports.

Good experience at UNIX (Commands), SHELL SCRIPTING (Production).

Prepare Detail Design Document and Impact Analysis Document.

Excellent Interpersonal Skills which helped me to share a good report with co-workers and the management

Analysis of specification to suggest the right solutions based on client requirements.

Worked as a team member and independently

Understood business requirements in the BI context and designed data models to transform raw data into meaningful insights

Utilized Power BI to build interactive and visually appealing dashboards and reports.

Developed visual reports, key performance indicators (KPI) scorecards, and dashboards using Power BI desktop.

Analyzed data and presented data through reports that aid in decision-making.

Overview

7
7
years of professional experience
3
3
Languages

Work History

Engineer - Application Management

Azentio Software Solution
01.2021 - Current
  • Created and maintained Oracle schema objects like Tables, Indexes, Sequences and Synonyms.
  • Wrote SQL*Loader scripts to migrate the data from the text files,
  • Spreadsheet etc. and populated the intermediate tables.
  • Involved in Data Migration.
  • Involved in writing complex SQL queries using Analytical functions in Oracle
  • Worked on Performance tuning by using Explain Plan and various Hints.
  • Developed UNIX Shell scripts to automate repetitive database processes.
  • Involved in Unit Testing, supports System testing and UAT Testing.
  • Analysis of specification to suggest the right solutions based on client requirements.
  • Created analytical reports and provided valuable and relevant business insights for internal and external clients.
  • Cleaned and transformed data using Power BIs Query Editor to prepare ETL processes to optimize reporting datasets.
  • Created data models, tables within Power BI to support efficient, optimized data warehousing and reporting workflows.
  • Experienced in tuning of long-running SQL queries using SQL server built-in tools like SQL Server profiler, Execution plan and creating indexes.
  • Experienced with Power BI Incremental refresh
  • Provided technical or functional guidance to project or work teams as needed within a specific discipline.
  • Collaborated on an on-going basis with the Business Systems Analyst.

PL/Senior SQL Developer

Oofix Infotech
07.2017 - 01.2021
  • Created PL SQL procedure for Daily reports, Intraday reports, Monthly reports, etc.
  • Created tables, packages, indexes, functions, using SQL Developer.
  • Created External Table to load data from CSV file • Create packages and procedure to parse data into different table from external table.
  • Coded and implemented data migration processes using Oracle procedures/packages
  • As per the client requirement we generate reports and transfer to the client as a Refcursor.
  • Coordinate with the application development team working on Java to provide them with the necessary stored procedures and packages and insight into the data.
  • Wrote PL/SQL procedures, packages, triggers. Involved in creation of databases, moved databases by creating control files, export/import, and complete backups.

Education

Bachelor of Technology - Elecetonics And Communication Engineering

Sri Manakula Vinayager Engineering College
Puducherry, India
04.2001 -

Skills

Windows 7/Windows XP, UNIX

undefined

Software

SQl

PLSQL

ORACLE REPORTS

POWER BI

Timeline

Engineer - Application Management

Azentio Software Solution
01.2021 - Current

PL/Senior SQL Developer

Oofix Infotech
07.2017 - 01.2021

Bachelor of Technology - Elecetonics And Communication Engineering

Sri Manakula Vinayager Engineering College
04.2001 -
RavieKumar ChandrasekeranSoftware Engineer