DHANUNJAYA REDDY KONASANI

• Designed and implemented end-to-end data pipelines using Azure Data Factory and Databricks to ingest, transform, and load data from multiple sources including Salesforce, SAP, SQL Server, and flat files.
• Built scalable data lakehouse architecture using Azure Data Lake Gen2 and Synapse Analytics to support structured and semi-structured data.
• Developed custom notebooks in Azure Databricks (PySpark) to perform data wrangling and business-specific transformations for reporting needs.
• Integrated Azure Data Factory with Logic Apps and Azure Functions for event-driven pipeline triggers.
• Used Delta Lake tables for optimized performance and ACID transactions.
• Maintained data lineage and data cataloging through Azure Purview.
• Built row-level security models in Power BI to restrict data access for different business units.
• Created parameterized reports and scheduled refreshes using Power BI Service.
• Implemented alerting and monitoring dashboards using Azure Monitor and Log Analytics.
• Worked closely with DevOps team to implement CI/CD pipelines using Azure DevOps, YAML templates, and Git repos.

• Led a team responsible for migrating legacy data systems to a modern cloud platform using AWS Glue, S3, and Redshift Spectrum.
• Designed and deployed serverless ETL/ELT workflows using Glue Studio and Python scripts to handle high-volume data ingestion from APIs and third-party tools.
• Implemented data partitioning and compression in Redshift and S3 to improve cost and query performance.
• Used Athena for ad-hoc querying and developed automated data profiling scripts.
• Developed reusable data validation and anomaly detection scripts using PySpark and Pandas.
• Coordinated with business analysts to identify KPIs and built Power BI dashboards with complex DAX calculations.
• Managed metadata using AWS Glue Data Catalog and maintained schema evolution.
• Implemented monitoring alerts using AWS CloudWatch, SNS notifications, and Lambda scripts for auto-remediation.
• Automated infrastructure deployment using CloudFormation and managed IAM roles and permissions.

Documented technical specifications and conducted KT sessions for junior engineers

• Collected, analyzed, and visualized operational and HR data using Power BI and Tableau.
• Designed SQL queries and Python scripts to automate extraction, transformation, and reporting of KPIs.
• Created dashboards showing employee retention trends, sales conversion rates, and team performance metrics.
• Optimized data extraction by indexing key tables and avoiding nested queries in MySQL and SQL Server.
• Supported ETL development by building SSIS packages for batch data processing.
• Participated in daily scrum meetings, sprint planning, and contributed to agile-based project delivery.
• Delivered training and documentation to business users on interpreting dashboards.