Power Bi Developer
T&Z International
• Created Microsoft Power BI dashboards that enable senior leaders and business teams to efficiently access key sales information • Used DAX to create complex measures and calculated columns • Developed and Published dynamic and complex Financial and Sales Reports in PowerBI • Built optimized data models that support Power BI dashboard requirements, integrating data from enterprise data warehouses, cloud platform, and external sources • Demonstrated expertise in deploying Business Intelligence solutions using SSIS, SSRS and SSAS • Led the architecture and functionality of BI product in which data from staging was transformed and transferred to a Data Warehouse for Analytics • Scheduled jobs to execute SSIS packages which were developed to update database objects daily • Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases• Analyzing data and re-mapping fields based on business requirements • Created SSIS packages to export and import data from CSV files, Text files and Excel spreadsheet • Store procedures, User defined functions, Views for complex business logic. Optimized the database by creating various clustered, non-clustered indexes and index views. Using aggregate strategies to aggregate data, sorting and joining tables • Experienced in creating, designing, processing of cubes using SSAS • Responsible for creating and maintaining Analysis services objects such as cubes, dimensions, measures. Created report model on SSAS cubes as well as changing default configuration on existing cubes • Transformation of data (Query Editor in Power BI, renaming and combining queries, filtering rows) • Modeling and Enhancing data • Created Workspace in Power BI service and publish reports in that workspace • Assigned Row level row security for Dataset in Power BI Desktop