Power BI Developer Resume

SUMMARY

4+ years of IT experience in analysis, reporting, design, implementation & administration of BI solutions with Microsoft SQL server, Power BI and SQL Server Integration Service.
Expert on creating multiple type of reports using tools like Power BI, SSRS, Tableau, Excel (Pivot Table, Matrix, Power Map…etc) and SAP Business Object.
Expertise in creating various type of reports such as Complex drill down & drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services (SSRS).
Excellent exposure in creating database T - SQL scripts, stored procedures, triggers, views, tables, indexes, and constraints, user defined functions using SQL SERVER 2008/2012/2014.
Working experience handling very large database from sourcing, modeling and transformations.
Experience in design, develop and deploy analysis model using SSAS and SSRS for data analysis and reports.
Strong communications and documentations skills; proactive, good ability to work positively and effectively in a team and adapt new environments with great potential to learn effectively in a team environment.

TECHNICAL SKILLS

Data Platforms: SQL Server 2005/2008/2012/2014/2016 , Visual Studio 2010,2012 and 2013, MS SharePoint 2013, TFS 2013, Power BI

Reporting Tools: SSRS, Tableau, Power BI and SAP BOE

Languages: SQL, C#

Analytics and Others: Data Modeling (ERwin), SSAS, PowerPivot, MS Office

PROFESSIONAL EXPERIENCE

Confidential

Power BI Developer

Responsibilities:

As aPowerBIDeveloper responsible for the design, development and production support of interactive data visualizations used across the company.
Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and T-SQL Queries to test and implement business rules.
Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
Expertise in data preparation with experience in blending multiple data connections, and creating multiple joins across same and various data sources.
Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
Developed various operationalDrill-throughandDrill-downreports usingSSRS.
Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. Publish and monitored various reports - Excel, Power BI, SSRS, Tableau.
Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Confidential

Report Developer

Responsibilities:

Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
Utilized power BI desktop to design real time dashboards and scorecards for analytical decision.
Created, Maintained & scheduled various reports in Power BI like Scatter, Matrix, Filled Map, ArcGis Map.. reports etc.
Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability. Implemented subscriptions and snapshots in the SSRS Report Manager.
Tune SQL queries as required to improve performance.
Developed CTE and sub queries for Stored Procedures.
Technical documentation and reports generation for the application.

Confidential

SQL/Report Developer

Responsibilities:

Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
Written T-SQL queries for the retrieval of the data.
Build, develop, and manage a SQL Server relational database using best practices.
Customized stored procedures and database triggers to meet the changing business rules.
Created SQL Queries to extract and compare data in the various sources.
Experience on Create scorecards and dashboards to empower reports from OLTP, OLAP and reporting tables using Performance Point Server and Excel sheet

Confidential

Tableau Developer

Responsibilities:

Built Tableau Visualizations by connecting to various Data Sources; Relational Databases (Oracle, SQL Server) & Flat files
Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
Scheduled data refresh on Tableau Server for weekly and monthly increments based on business needs to ensure that the views and dashboards were displaying the changed data accurately.
Designed and deployed interactive reports with Drill Downs, Drop Down menu option, Parameters and Linked Reports using Tableau.