Venkata Reddy Mulamreddy

IT professional with 6+ years of total experience and around 4 years of experience in Data Engineering and ETL development using Microsoft Business Intelligence (MSBI) and multiple Azure services.

IT professional with 6+ years of total experience and around 4 years of experience in Data Engineering and ETL development using Microsoft Business Intelligence (MSBI) and multiple Azure services.

• Expertise in creating innovative power BI reports and Dashboard with Import and Direct query modes loading data from different type of data stores like Azure SQL, Azure DevOps, Excel, and flat files.
• Extensive experience on creating linked services, data sets and Pipelines in Azure Data Factory version 2 and experienced in creating Data flows.
• Hands on experience in creating datasets like Azure Data Lake gen1 and gen2, Azure SQL Data Warehouse, Azure SQL Source and Azure MariaDB.
• Experience on Azure Data bricks and able to write Notebooks using SQL and PySpark programming to transform the datasets stored in ADLS.

Responsible for creating pipelines in Azure Data Factory using activities like Copy, Lookup, for each and stored procedure.

• Creating views and tables using SQL in Azure Databricks
• Running queries on reporting views and tables for specific analysis and data validation
• Writing complex SQL queries based on business needs.
• Creating tabular cubes and importing data into tables
• Design, Develop, Deploy and testing of tabular cubes and consuming them in Power BI report.
• Creating Power BI reports and working on visualizing tabular data based on business needs.
• Responsible for creating pipelines, Datasets and Lined services in Azure Data Factory.
• Responsible for creating copy, lookup, Filter, For-each, Stored procedures, and Notebook activities In Azure Data Factory.