About
Environments. Teamwork oriented and motivated data analyst with experience in Microsoft Power BI designing, developing, deploying and visualizing business reports. Alongside data visualizations, I am also proficient in developing SSIS packages to Extract, Transform and Load (ETL) and also Microsoft SQL Server in OLTP and OLAP (Data warehousing
Portfolio
Bike Sales in Europe & America
This dataset consists of sales data collected for the period between 2011 to 2016 of Bike Sales for ... ... More
Employment History
-
SQL/Power BI Developer
Colaberry Inc
December 2020 - 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 down 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 SQL to develop stored procedures, tables, user defined functions, joins to optimize data loading
into Power BI.