Venkatarami Reddy

About

4.8 years of experience in Oracle SQL, PL/SQL, ETL, Power BI, data analysis development of enterprise-level business applications. Strong expertise in Oracle SQL and PL/SQL, including complex queries, joins, subqueries, CTEs, analytical functions, procedures, functions, packages, cursors, collections, dynamic SQL, and exception handling. Hands-on experience in SQL/PLSQL performance tuning, including execution plan analysis, indexing, table partitioning, query optimization, bulk processing using BULK COLLECT/FORALL, and handling large-volume datasets. Experienced in designing and developing ETL processes, including data extraction, transformation, cleansing, validation, source-to-target mapping, reconciliation, and loading data into target systems. Strong hands-on experience with Power BI, including data modeling, star schema, relationships, Power Query, DAX measures, calculated columns, KPIs, interactive dashboards, and business reports. Experienced in developing advanced DAX calculations, including CALCULATE, FILTER, ALL, ALLSELECTED, RANKX, TOPN, time intelligence, YoY analysis, running totals, and dynamic business calculations. Experienced in data validation, troubleshooting, and performance optimization, including resolving data mismatches, ETL failures, SQL/PLSQL issues, Power BI refresh problems, and report performance bottlenecks. Strong analytical and problem-solving skills with experience in Excel, Pivot Tables, batch scripting, Master Data Management, reporting automation, and converting complex business requirements into scalable data and BI solutions.

Skills & Expertise (34)

Work Experience

Education

Certifications