We provide IT Staff Augmentation Services!

Power Bi Developer/ Data Analyst Resume

4.50/5 (Submit Your Rating)

Seattle, WA

SUMMARY

  • 5+ years of hands - on experience on T-SQL.
  • 4+ years of experience on ETL/SSIS/SSAS.
  • 4+ years of experience on Power BI.
  • 4+ years of experience on data warehousing and Tabular Modeling.
  • 3+ years of experience on Azure Data Factory (ADF).

TECHNICAL SKILLS

Data Analytics: Tabular Modeling

Databases: MS SQL Server, SSAS, Access

SDLC: Agile, Scrum, Jira, AzureDevOps

Programming/Scripting: T-SQL, Python, DAX

Tools: SSMS, Visual Studio, Power BI, Excel, Azure Data Studio, DAX Studio, MS Visio, MS Project, Tableau, SPSSAzure Machine Learning Algorithms (Regression, Classification, Clustering)

PROFESSIONAL EXPERIENCE

Power BI Developer/ Data Analyst

Confidential Seattle, WA

Responsibilities:

  • Loaded datasets from multiple sources (Excel, Power BI Datasets, SQL Server Databases, Analysis Services, Files, Stored Procedures, Views) into Power BI Desktop.
  • Worked on data shaping, transformation, and modeling in Power BI using DAX and Power Query Editor.
  • Developed calculated columns and measures using complex DAX functions and Power Pivot.
  • Created reports in Power BI using Power Query, DAX Functions, visuals (Charts, Graphs, KPIs, Maps, Gauges,Power KPI,Matrix, etc.) developed and dashboards.
  • Worked on row-level security, dynamic parametrized filtering, and generated trends/ insights through the forecasting feature in the Analytics tab.
  • Worked on data analytics using SSAS Tabular Model and Excel (Pivot tableanalysis)
  • Created perspectives, roles, measures, KPIs in Tabular model based on the end user requirements and deploying to the Analysis Services Instance.
  • Worked on performance optimization in Power BI using DAX Studio and Performance Analyzer.
  • Worked with senior leaders and colleagues to secure greater engagement with clients.

SQL/MSBI Developer

Confidential Seattle, WA

Responsibilities:

  • Worked on designing and developing Data Marts and Data Warehouse using the Star/Snowflake Schema approaches.
  • Developed stored procedures and views to simplify complex joins, Sub-Queries, and merge queries from multiple tables.
  • Created measures, calculated columns, hierarchy, relationships, roles, KPIs, and Perspectives on the Tabular Model.
  • Deployed SSIS Packages from the Visual Studio to Integration Service Catalogs.
  • Developed constraints, Common Table Expressions(CTEs), User Defined Functions(UDFs), Table variables, Indexes, and Subqueries.
  • Worked on data shaping, transformation, and modeling in Power BI using Power Query and DAX.
  • Created reports and dashboards in Power BI using Power Query, DAX Functions, visuals (Charts, Graphs, KPIs, Maps, Gauges,Power KPI,Matrix, etc.).
  • Worked on row-level security, dynamic parametrized filtering, and generated trends/ insights through the forecasting feature in the Analytics tab.
  • Extensively worked on SSIS transformations:Lookup, Derived column, Data conversion, File System Task, Conditional split, Execute SQL task, Containers, etc.
  • Worked on Database modeling, data lineage & dictionary, job Scheduling, Backup & Recovery.
  • Worked on error handling and debugging (Break points, Check points) in SSIS.
  • Worked on ADF components: Pipelines, Activities, Datasets, Linked Services, Data Flows, and Integration Runtimes.
  • Migrated data between on-premise and cloud(Azure SQL database & Azure Blob storage) using ADF(v2) activities and connections.

Business/Data Analyst

Confidential

Responsibilities:

  • Developed complex Views, Stored Procedures, Joins, constraints, CTEs,Indexes, and Subqueries in T-SQL.
  • Worked on data analysis and reports/visualizations using Excel (HLookup,VLookup, DAX functions, and pivot table analysis)
  • Coordinated cross-functional teams to accomplish projects on-time.
  • Developed business plans for companies by conducting research andanalyzing the data using SPSS for potential business opportunities.
  • Maintained strong client relationships with various business and non-business organizations.
  • Track and report project metrics to clients and senior management.

We'd love your feedback!