Posina SIVA KRISHNA

Having total 5 years of Progressive Experience in IT field, which includes Analytical and visualization tools Power BI and SQL server and ADF. Power BI Dashboards and Reports created from various data sources like SQL Server Database, Excel, CSV data. Good experience on creating Power BI dashboard from scratch and handling Workspace, Apps and User Security in Power BI Service. Good Experience and knowledge on cloud computing such as – Azure. Experience in working with Azure services such as – Azure Storage, Azure Lake Storage, Azure SQL Database, and Azure Data Factory. Collaborated with azure data engineers and operation team to implement the ETL process using Azure Data Factory wrote and optimized SQL queries to perform data extraction to fit the analytical requirements. Performed data cleaning including transforming variables and dealing with missing value and ensured data quality, consistency, integrity using ADF. End to end experience in designing and deploying data visualizations using Power BI. Generation of Power BI Reports from Cubes using DAX and SQL Queries. Additional experience working on Power BI Desktop, Power BI Service and Power BI Mobile, as well as some limited hands-on experience using Power BI Report Server to build paginated reports. Created Power BI Gateway performance reports to monitor the Gateway and to gauge the activities for the gateway. Implemented Row-Level Security (RLS) to enforce user-specific data access, ensuring secure multi-tenant data isolation. Strong understanding of the principles of DW using Fact Tables, Dimension Tables, star schema modeling and data modeling for Data warehouse. Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions. Improved Power BI dashboard performance by optimizing data models, DAX queries, and Power Query transformations, resulting in faster load times and better user experience. Experience with creating reports by connecting different data sources to Power BI and using geographical visualizations as per the insights provided. Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop. Calculated columns, calculated measures and Calculated Tables using DAX, data modelling. Expertise writing SQL Queries, Joins.