Venkateswara Reddy Yella
Bangalore,KA
Summary
Results-driven Data Engineer with 8+ years of IT experience, including 4+ years specializing in Azure cloud data engineering. Proficient in Azure Data Factory, Azure Data Lake, Azure Databricks, and Azure SQL. Skilled in building and automating data pipelines, implementing medallion architecture, and developing Spark-based ETL solutions. Strong in SQL Server, Power BI reporting, and performance tuning. A proactive team player with excellent communication and problem-solving skills.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior BI Engineer
Actualize Consulting Engineers (India) Pvt. Ltd.
Bangalore, KA
05.2022 - Current
- Designed star and snowflake schemas in Power BI. Created relationships, hierarchies, calculated tables, and advanced DAX measures, including time intelligence functions (YTD, MTD, QTD, rolling averages) to track KPIs and trends.
- Extracted data from Databricks, SQL Server, and APIs using PySpark and SQL. Built automated ingestion pipelines to feed datasets into Power BI for real-time and scheduled reporting.
- Cleaned, merged, and reshaped multi-domain data (Sales, Finance, Warehouse, Logistics) using Databricks (SQL/PySpark) and Power Query M, ensuring consistent, analysis-ready datasets.
- Developed interactive Power BI dashboards tailored to business needs, providing drill-throughs, dynamic filters, and actionable insights across EDMAC operations.
- Designed and automated data pipelines using Azure Data Factory and Databricks.
- Implemented Medallion Architecture and audit logging for data consistency.
- Built Power BI dashboards and optimized DAX queries for business reporting.
- Supported production pipelines and enhanced performance.
- Collaborated with cross-functional teams for data-driven solutions.
- Managed the end-to-end BI ecosystem and actively contributed to the migration and adoption of Microsoft Fabric.
- Engineered and maintained data flows from the Global Landing Zone by onboarding raw data into the Fabric Data Warehouse, ensuring it was clean, structured, and ready for downstream analytics.
- Developed and published high-impact, interactive Power BI dashboards customized for stakeholder requirements and operational KPIs.
- Administered Power BI Service workspaces, managed Incremental Refresh, optimized datasets, leveraged Dataflows, and implemented Row-Level Security (RLS) to ensure secure, scalable, and efficient reporting.
- Collaborated with stakeholders to gather detailed requirements, translated them into technical specifications, and ensured alignment with business needs.
- Participated in testing, validation, and defect resolution, ensuring accuracy and quality of dashboards and data pipelines.
- Contributed to effort estimation, sprint planning, and agile ceremonies, providing accurate insights for workload planning.
- Provided production support, monitored refresh issues, optimized dataset performance, and ensured minimal downtime.
- Created and maintained project documentation, including data dictionaries, technical design documents, and process workflows, following Infosys-quality standards.
Data Analyst
Brunet Info Solutions
07.2017 - 05.2022
- Built ETL pipelines on Azure platform using ADF and Databricks.
- Designed Power BI dashboards and tabular models for KPIs and business insights.
- Developed Spark applications for large-scale data processing and analytics.
- Optimized SQL queries and performed database performance tuning.
Education
B. Tech - undefined
Jawaharlal Nehru Technological University
01.2014
Skills
- Azure Data Lake
- Azure Data Factory
- Azure SQL Database
- Azure SQL Data Warehouse
- Azure Databricks
- PySpark
- Spark SQL
- Power BI
- Power Automate Flows
- Power Apps
- SQL Server
- Stored Procedures
- Views
- Parquet
- CSV
- JSON
- XML
- Excel
- Data Migration
- Pipeline Automation
- Performance Tuning
Certification
Certification of appreciation for valuable contribution during the world quality week, 2025-01-01
Personal Information
Title: Senior BI Engineer | Azure Data Engineer
Timeline
Senior BI Engineer
Actualize Consulting Engineers (India) Pvt. Ltd.
05.2022 - Current
Data Analyst
Brunet Info Solutions
07.2017 - 05.2022
B. Tech - undefined
Jawaharlal Nehru Technological University