Venkata Simha Reddy Dumpala

Analytics Engineer with 2+ years of experience delivering data engineering, business intelligence, and analytics solutions for Bank of America through Infosys. Experienced in designing analytics-ready datasets, developing ETL/ELT pipelines, building dimensional data models, and creating business intelligence dashboards. Hands-on expertise in SQL, Python, PySpark, Azure Databricks, Azure Data Factory (ADF), Azure Synapse Analytics, Power BI, and Data Warehousing concepts.

Skilled in data validation, query optimization, KPI reporting, stakeholder collaboration, and transforming business requirements into scalable analytics solutions.

Analytics Engineer / Data Engineer - Infosys Limited - Hyderabad, India

(2024-06)

Project: Bank of America – Third-Party Data Protection Platform

• Developed analytics-ready datasets using Azure Databricks, PySpark, SQL, and Azure Data Factory for compliance and risk reporting initiatives.
• Built and maintained ETL/ELT pipelines to ingest, transform, and load structured and semi-structured data into reporting and analytics environments.
• Implemented Medallion Architecture (Bronze, Silver, Gold) using Azure Databricks and Delta Lake to improve data organization and downstream analytics consumption.
• Developed dimensional data models including Fact and Dimension tables using Star Schema concepts to support scalable business reporting.
• Created SQL transformation logic using CTEs, Window Functions, Aggregations, and Query Optimization techniques to improve reporting performance.
• Developed interactive Power BI dashboards and KPI scorecards to support compliance monitoring and business decision-making.
• Implemented CDC and Incremental Loading mechanisms in Azure Data Factory to improve data freshness and reduce processing overhead.
• Performed data profiling, validation, reconciliation, and quality checks to ensure reporting accuracy and consistency.
• Worked with Kafka-based ingestion workflows and downstream PySpark processing pipelines supporting batch and near real-time analytics use cases.
• Optimized Spark SQL and PySpark transformations through partitioning, caching, and efficient join strategies, reducing execution times and improving SLA adherence.
• Collaborated with business stakeholders to gather reporting requirements, define KPIs, and deliver analytics solutions aligned with business objectives.
• Supported CI/CD deployment activities using Azure DevOps and Git to streamline release management and improve deployment reliability.
• Documented data models, transformation logic, business rules, and reporting specifications to maintain data lineage and governance standards.

Bachelor of Engineering - Electronics & Communication Engineering - Bharath Institute of Higher Education and Research (2021)