Power Bi Sql Server

SHAHAD JAWAD

Dallas, Tx *****

***************@*****.*** / 713-***-****

SUMMARY

* ***** ** ********** ** data analysis and visualization professional with hands on experience analyzing, designing, developing, and visualizing business intelligence reports with Power BI and Microsoft BI stack. Proficient in creating DAX queries to perform complex calculations, create measures and calculate columns. In SSIS, experience developing packages to Extract, Transform, and Load (ETL) data into SQL Server data warehouses. Experienced creating and maintaining existing tables and views, optimizing queries in SQL, and creating parameterized reports and dashboards in SSRS and Experienced in maintaining database. Passionate about data and the tremendous potential visualization tools have in allowing end users to interpret and utilize data for more accurate business decisions based on trends, and a quick learner who strives for new technical knowledge.

SKILLS

Utilized Power BI to create various analytical

dashboards that describe critical KPIs

Experience in the concepts and practices of

physical and Logical data model design

Experienced in DAX queries to calculate KPIs

and functions in Power BI

Experienced in T- SQL queries, Stored

procedures, Views, UDF, Joins, Trigger, CTE,

Temp table

Experienced in SSIS Packages (Developing,

Deploying, Scheduling, Troubleshooting, and

monitoring) and performing data transfers and

ETL process

Expertise in generating reports using SQL

Server Reporting Services (SSRS)

Experience in using and integrating with

dashboards & reports

EXPERIENCE

BI/Power BI Developer / Colaberry Inc - Plano, Texas 02/2018 - Current SJ

Specific Responsibilities:

Develop dashboards and interactive visual reports using Power BI, Publishing the report to Service, and Mobile App.

Understand business requirements in BI context and design data models to transform raw data into meaningful insights.

Analyzing data and presenting data through reports that aid decision-making. Convert business requirements into technical specifications. Creating relationships between data and developing tabular and other multidimensional data models. Used Power BI Gateways to keep the dashboards and reports up to date. Design, develop, test, and deploy Power BI scripts and perform detailed analytics. Cleaning and validating Imported data from any source file (SQL, Excel, XML, CSV, etc.). SQL querying for best results, use of filters and graphs for better understanding of data. Used SSIS to create, maintain and troubleshoot ETL packages to validate, extract, transform and load data to data warehouse databases.

Experience in deploying SSIS packages to multiple environments using different methodologies and performing Automation of SSIS Packages using SQL Server agent. Worked on POC to migrate existing on premise BI platform to Azure Cloud. Worked on Azure cloud in spinning of new resources under resource group. Worked on Data factory tool in order to load the data from on premise to Azure Data Lake. Work with users and team members at all levels for performance improvement and suggestions. TECHNICAL SUMMARY

• Languages: DAX, T-SQL

• ETL Tools: SQL Server Integration Service (SSIS)

• Reporting Tools: Power BI, SQL Server Reporting Services (SSRS)

• BI Tools: SQL Server, Power BI, Visual Studio

• Office Tools: MS Word, PowerPoint, MS Excel

• Methodologies: Agile

EDUCATION AND TRAINING

Bachelor's degree: Communications And Electronics Engineering 2015 Al-Kufa University

Certificate of Colaberry Data Analytics

Colaberry School

Contact this candidate