Business Intelligence Developer Resume

SUMMARY:

5 years of experience in Implementing BI Solutions using Microsoft BI stack.
Expert in Creating Self Service Data models using Azure Analysis Services, SQL Server Analysis Services Tabular data models and Power BI.
Developing reports and dashboards using SQL Server Reporting Services and Power BI.
Expert in writing both TSQL queries against large databases and data warehouses both on premise SQL Server as well as various cloud data sources such as SQL Azure Data warehouse, Azure SQL Database.
Expert in working with key stakeholders to gather business requirements for reports and dashboards.
Expert in Implementing Security and distribution of automated reports using SharePoint.

TECHNICAL SKILLS:

Development Tool: SQL Server Management Studio, Power BI, BISM, Visual Studio, SQL Server Data Tools, Report Builder 3.0

Project Management Tools: JIRA and Visual Studio Team Services

Domain Expertise: Health & Welfare (HM), Manufacturing, Sales.

Languages: SQL, DAX, TMSL

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Developer

Build Tabular Data Models on Azure Analysis Services.
Created around 2000 complex calculated Measures using advanced DAX Expressions including time intelligence features on custom calendar for PY, YTD, QTD, MTD, WTD Calculations.
Developed highly interactive Dashboard with advanced drill down capability using Power BI Service.
Compare and Deploy changes to Azure using BISM.
Test, Validate and troubleshoot key metrics in Data model and Dashboard.
Developed, published and automated reports using SSRS.
Trained Business analysts and power users to create ad - hoc reports on their own using Power BI and Excel etc.
Create and modify various SQL queries, stored procedures and database views.
Build ETL and Big Data Pipeline using Azure Data Factory, SSIS and Azure Data lake Analytics

Confidential

Data Analyst

Implement Enterprise Level Business Intelligence Solution, Responsible for full Business Intelligence (BI) lifecycle, from data gathering to implementation of Microsoft solutions BI stack.
Created Data Models to enable analysis for various departments/business processes such as Sales, Marketing, HR, Customer Relations, and Finance.
Implemented Department Specific Data Models using SSAS Tabular Model and Power Pivot.
Optimized Data processing using advanced Table partitioning.
Developed highly interactive Dashboard consisting of Drill down Capabilities.
SSRS Reports development, deployment and automated subscriptions on SharePoint, also implemented Security for reports and data models.
Module ownership & management - End to end module ownership- monitor, track, review, sign off & close testing phase of projects.
Testing for data, client facing web, personalize notices.

Confidential

Associate Business Analyst

Developed around 200 reports with advanced functionality such as drill down and drill through.
Created complex TSQL stored procedures, Functions and views used for reports and maintaining data warehouse.
Installed and configured SQL Server reporting services in native and SharePoint integrated mode
Published and automated reports using SharePoint 2010 and Report Manager.
Implemented security on SharePoint 2010.
Trained Business analysts and power users to create ad-hoc reports on their own using Report Builder 3.0.
Developed highly interactive Dashboard with advanced drill down capability using Tableau.
Work with business to validate the data in reports.
Troubleshoot existing reports.