Data Analyst Resume Seattle, Washington - Hire IT People

SUMMARY

5+ years of data analysis, data administration, and designing business intelligence solutions.

TECHNICAL SKILLS

BI Tools: Power BI desktop, Power BI service, Power BI Mobile, Power BI report builder, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), SQL server Integration Services (SSIS)

Environment: Power BI, DAX, Power query, Excel, ETL, SQL Server 2019/2017/2016/2014 , SharePoint, T - SQL.

Databases: MS SQL Server, Oracle, MS Access, MySQL.

Data Modeling: ER/Studio 18.3, Erwin 6.1

Languages: MS-SQL, MySQL, T-SQL, DAX, Visual Studio 2019 version 16.11 (.Net version 4.7.2) using C# Version 9.0

OS: Windows XP/03/07/10/11, OS X, Linux/Unix

Front-End Tools: Microsoft Teams, SharePoint, Jira

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

Fetched data from different sources like Excel, Flat Files, XML, SharePoint list/Library, SQL Server DB, Azure SQL DB, and various other databases to Power BI to generate reports.
Created complex tables and measures using DAX functions such as Aggregation Functions, Date & Time Functions (Time intelligence Functions), Filter functions, Logical Functions and Text Functions
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
Used different types of visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
Developed Several interactive visual reports, dashboards and KPI scorecards using Power BI desktop and made them available in Web clients and mobile apps.
Developed, published, and scheduled Several Power BI reports.
Created Workspace and Apps in Power BI and gave access to end users.
Created Deployment Pipelines and Publish Apps
Implementing Static and Dynamic row level security (RLS)
Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services to keep the dashboards and reports up to date.
Created Scheduled data refresh and Incremental Refresh.
Implemented Query Folding
Created Paginated Reports
Refreshing data using power Automate
Created SSIS packages to extract data from different sources; ADO NET Source, Excel Source, Flat File Source, OLE DB Source, XML Source.
Designed Star Schema and Snowflake schemas in the process of data modeling.
Developed, supported, and maintained different kinds of ETL (Extract, Transform and Load) processes for loading data into Data warehouse.
Worked on Aggregate, Derived Column, and Data Conversion Transformations.
Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions.
Worked withSCRUMteam in delivering agreed user stories on time for every Sprint.

Confidential, Seattle, Washington

Data Analyst/Power BI Developer

Responsibilities:

Imported data to Power BI from multiple sources like SQL server, MySQL, Oracle, Excel, CSV, JSON, XML, Web URL, Azure SQL Database and Azure Analysis Services Database
Created the data model in Power BI to meet performance requirements, defined - tables, relationship cardinality, cross filter direction, appropriate level of granularity and created a common date table
Developed DAX expressions using several Filter, Statistical, Date time, Logical, Relationship, Table Manipulation and Time Intelligence Functions
Improved the usability by configuring bookmarks, selection pane, tool tips, sync slicers, grouping and binning, cross report drill through and drill down into interactive visuals
Created Interactive cards, conditional drill through buttons and toggle buttons by leveraging bookmarks and selection panes in Power BI.
Created reports for multiple departments by creating URLs and adding a Parameter to the report in Power BI
Implemented complex hierarchical row level security as applicable to restrict data access to given users and their assigned regions
Implemented performance optimization techniques in Power BI to improve the performance and quality of the dashboards
Implemented Query Folding
Configured schedule refresh and Incremental refresh to keep dashboards and reports up to-date with on premise data sources when published to the Power BI Service

We provide IT Staff Augmentation Services!

Data Analyst Resume

Seattle, WashingtoN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship