Looking for a job

RAVI VARMA B

@ravivarmab

Message

SQL Developer at C-Edge Technologies who optimized BANCS@24 reporting queries, cutting report generation time by 40%.

India

Message

At C-Edge Technologies Ltd., I write and maintain Oracle SQL queries for the BANCS@24 core banking platform, supporting customer analytics, regulatory reports, and operational dashboards.

I overhauled legacy queries by reviewing execution plans and index strategies, reducing report generation time by about 40%. I also rewrote high-net-worth customer analysis queries using window functions and materialized views, bringing runtime from 45 minutes to 6.

I automated End-of-Day reporting with Shell scripts and cron jobs on Linux, cutting processing time by 60% across 200+ branches. I also handled data extracts for RBI and Income Tax Department audits and received the Compliance Hero award in 2023–24.

Experience

Work history, roles, and key accomplishments

Current

SQL Developer / System Analyst

Current

C-Edge Technologies Ltd.

Sep 2019 - Present (7 years 2 months)

Developed and maintained 1500+ Oracle SQL queries for the BANCS@24 platform, handling over 5 million daily transactions. Automated End-of-Day reporting with Shell scripts and cron jobs, cutting processing time by 60% and ensuring 99.9% accuracy.

Oracle Database SQL Query Optimization Execution Plan Analysis Materialized Views Indexing Strategies

Table Partitioning

Performance Optimization Shell Scripting Cron Job Data Validation Error Handling

TCS BaNCS

General Ledger Reconciliation

RBI Reporting

Income Tax Compliance

SCP

WinSCP

grep

Tails

Jaspersoft

IMS

Excel

Education

Degrees, certifications, and relevant coursework

Sagi Rama Krishnam Raju Engineering College

Bachelor of Engineering, Electrical and Electronics Engineering

Grade: 7.23/10.0

Graduated with a Bachelor of Engineering in Electrical and Electronics Engineering in 2019, achieving a CGPA of 7.23 out of 10.0.

Oracle University

Oracle Database SQL Certified Associate, Database SQL

Certified as an Oracle Database SQL Certified Associate, covering advanced query development, performance optimization, and data transformation for enterprise environments.