Teamwork-oriented and motivated data analyst with experience in Microsoft power BI designing, developing, deploying and visualizing business reports. Alongside data visualizations I’m also proficient in developing SSIS packages to Extract, Transform and load (ETL) data and also Microsoft SQL Server in OLTP and OLAP (Data warehousing) environments.
In the last few years, a craze for cryptocurrencies has gripped the world and these digital coins ar... ... More
SQL / Power BI Developer
September 2018 - Present
• Extract data from different sources like SQL server database, CSV, Excel, transform and clean the data in power query and load it to Power BI desktop.
• Create dashboards, charts, graphs, tabular and matrix reports based on customers' requirements using Power BI and SSRS.
• Generate drill down and drill up reports
• Create KPIs using complex DAX functions and publishing reports in Power BI service.
• Implemented row-level security to restrict data access.
• Use agile methodology while working on complex projects and breaking them into sprints.
• Working with Star schema and snowflake schema in data warehousing.
• Use T-SQL to develop stored procedures, tables, user-defined functions, joins to optimize data loading into Power BI.