Venkata Srinivasa Rao Davuluri
Bloomington,IL
Summary
IT professional with 8+ years in Business Intelligence and Data Engineering. Specializes in Azure Data Factory, Power BI, Azure Databricks, and Microsoft Fabric. Proficient in designing ETL/ELT pipelines, interactive dashboards, and reports using DAX, SQL, and KQL. Expertise in migrating SSRS reports to Power BI and implementing data warehousing concepts. Experienced with Azure ecosystem tools, DevOps, and full-stack development with .NET and modern web technologies. Holds DP-203 and DP-600 certificates.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Engineer
Microsoft
06.2024 - Current
- Designed and implemented end-to-end data pipelines in Microsoft Fabric to automate and streamline complex data workflows.
- Developed and optimized 10+ Fabric notebooks to enhance performance and ensure efficient data processing.
- Achieved a 40% reduction in processing time by tuning queries, optimizing Spark execution plans, and improving resource utilization.
- Created comprehensive documentation and clear flow diagrams to explain business processes and data logic to both technical and non-technical stakeholders.
- Integrated multiple data sources and standardized ingestion processes to ensure data quality and consistency.
- Implemented parameterized notebooks for dynamic execution and greater reusability across different ETL jobs.
- Led knowledge-sharing sessions to upskill team members on Fabric features, notebook best practices, and performance tuning strategies.
Data Engineer
Microsft
06.2022 - 05.2024
- Built scalable, end-to-end data pipelines using Azure Synapse Notebooks, Azure Databricks, and SQL-based transformations.
- Developed parameterized notebooks and optimized Spark jobs in Databricks to process structured and unstructured data from ADLS and SQL sources.
- Configured Databricks clusters, established mount points to ADLS Gen1/Gen2, and managed versioned notebooks for team collaboration.
- Utilized Azure Synapse for large-scale data integration and transformation with focus on performance tuning and modular design.
- Worked on SSIS packages and Microsoft internal tools to orchestrate data workflows and support legacy systems.
- Developed and maintained SQL Server stored procedures, functions, and scheduled jobs for loading and transforming production data.
- Modeled and managed Master Data Services (MDS) hierarchies and entities to standardize key business dimensions.
- Implemented Row-Level Security (RLS) and defined custom roles to control access at user or department levels.
- Applied DAX measures and calculated columns to perform advanced business logic and aggregated calculations.
Data Engineer
Microsoft
05.2021 - 05.2022
- Led the migration of legacy data solutions to modern Azure-based platforms, contributing to the rollover and stabilization of new architectures.
- Developed and orchestrated data processing notebooks via Azure Data Factory, ensuring modular, maintainable ETL logic.
- Designed and implemented complex SQL logic including Common Table Expressions (CTEs), nested queries, and subqueries to solve targeted business challenges.
- Performed query optimization and performance tuning to reduce execution time and improve system efficiency across multiple layers of the data stack.
- Built and maintained Databricks clusters, configured mount points, and authored scalable notebooks for big data processing.
- Developed and validated Tabular cubes from scratch, including dimension/fact modeling, view creation, and cube processing logic using PolyBase.
- Created SQL Server Agent jobs and error alerts to monitor ETL performance and proactively address failures.
- Actively supported post-production enhancements and bug resolutions, working closely with business stakeholders to meet evolving requirements.
Software Engineer
Microsoft
05.2019 - 04.2021
- Conducted in-depth analysis of business requirements to design efficient, scalable data solutions aligned with stakeholder needs.
- Developed stored procedures, views, and user-defined functions leveraging both procedural and set-based SQL techniques to support reporting and analytics.
- Utilized the Excel Data Loader (EDL) framework for ingesting structured Excel files, including table creation and validation logic using dynamic stored procedures.
- Tuned complex SQL queries to optimize ETL transformation performance, reducing processing time across large data pipelines.
- Designed and implemented Spark SQL scripts and transformations based on functional specifications for batch and near real-time data processing.
- Applied Spark Streaming and Spark SQL operations (transformations/actions) for ingestion and transformation of high-volume datasets.
- Generated and stored partitioned Parquet files in Hive-compatible paths within ADLS for efficient querying and retrieval.
- Loaded dimension and fact datasets into analytical cubes, facilitating accurate BI reporting.
- Utilized Git repositories for version control and collaboration, enabling seamless sprint planning, code reviews, and dependency tracking.
Software Engineer
AppsTek And Amaze
01.2016 - 04.2019
- Analyzed and interpreted client requirements to design scalable software solutions across reporting, integration, and web interfaces.
- Developed and deployed SSIS packages for extracting and transforming data from diverse sources like Excel and flat files.
- Created and optimized stored procedures, triggers, indexes, and user-defined functions for backend processing and business rule enforcement.
- Designed and implemented SSRS and Tableau reports to deliver actionable insights to business users.
- Built dynamic web applications using C#, ASP.NET MVC, and integrated responsive frontends using HTML5, CSS3, Bootstrap, and JavaScript.
- Participated in end-to-end development, from writing unit test cases and coding to testing and deployment across staging and production environments.
- Resolved production support tickets by debugging and modifying SSIS packages, stored procedures, and .NET codebases.
- Handled build and deployment activities, ensuring smooth releases and continuous integration with minimal downtime.
- Collaborated with QA and business teams to validate test cases, resolve bugs, and enhance application features post-deployment.
Education
Master of Science -
Acharya Nagarjuna University
Guntur, Andra Pradesh, India05-2016
Skills
Microsoft Cloud Technologies:
Azure Data Lake Storage (ADLS), Azure Virtual Machines (VM), Azure Data Factory (ADF), Azure Data Warehouse (ADW), Azure Databricks, Kusto (Azure Data Explorer), Microsoft Flow (Power Automate), Power Apps, Azure SQL Database (AZSQL), Cosmos DB, Azure Synapse Analytics, Microsoft Fabric
Programming Languages:
SQL, C#, ASPNET, Python, JavaScript (JS), AngularJS, HTML, CSS, jQuery
Tools & Environments:
Power BI, Git, Visual Studio, PowerShell, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Visio, ServiceNow
Certification
Azure Data Engineer Associate : DP-203
Fabric Analytics Engineer Associate : DP-600
Timeline
Data Engineer
Microsoft
06.2024 - Current
Data Engineer
Microsft
06.2022 - 05.2024
Data Engineer
Microsoft
05.2021 - 05.2022
Software Engineer
Microsoft
05.2019 - 04.2021
Software Engineer
AppsTek And Amaze
01.2016 - 04.2019
Master of Science -
Acharya Nagarjuna University