Ravi Chandra Kanth Chembula

Built SQL queries using ROW NUMBER and RANK window functions to calculate fuel sales velocity against inventory turnover rates across Shell’s 5 Oracle databases, automating regional performance reports that reduced manual work from 8 hours to 45 minutes daily. Optimized Shell’s pricing algorithm stored procedures by partitioning tables by region and implementing batch processing instead of row-by-

Created SQL stored procedures using HASHBYTES encryption and window functions to track prescription refill intervals and identify non-adherent diabetes patients across 45,000+ Great Lakes region records, enabling targeted intervention programs. Redesigned CVS Symphony queries using table partitioning by pharmacy region and filtered indexes on low-stock thresholds, reducing medication availability

Developed SQL views using recursive CTEs to flatten customer hierarchies and UNPIVOT/PIVOT operations to transform transaction data for pattern analysis, identifying high-value cross-sell prospects that generated $12M in additional Chase product revenue. Built SQL stored procedures using dynamic SQL generation and table-valued parameters for batch processing credit risk factors, implementing paral

Built SQL validation queries using EXCEPT and INTERSECT operations to compare SAP ERP member enrollment data with migrated AWS RDS records, identifying 2,300+ data discrepancies and ensuring 99.7% migration accuracy for MedCore’s 850,000+ member base. Optimized PostgreSQL queries using indexed views and query plan analysis for claims processing system on AWS RDS, reducing claim lookup times from 1

Grade: 3.53/4.00

Pursued a Master of Science in Computer Sciences, focusing on advanced topics in the field. Achieved a CGPA of 3.53/4.00, demonstrating strong academic performance.

Grade: 8.63/10.00

Completed a Bachelors degree in Electronics & Communication, gaining foundational knowledge in the field. Achieved a CGPA of 8.63/10.00.