Power BI/ SSRS Developer Resume Nashville, TN - Hire IT People

SUMMARY

Fluent in T - SQL programming language: creating and managing database objects, stored procedures, triggers, views and user defined functions.
Skilled in writing sub-queries, CTEs, derived tables and joins for complex queries involving multiple tables.
Skilled in design, development and maintenance of enterprise data warehouse
Skilled in creating SSIS ETL (Extract/Transform/Load) packages using visual studio
Skilled in enhancing, deploying and troubleshooting SSIS Packages from development server to production server
Excellent in developing Power BI and SSRS reports, dashboards, ad-hoc reports with functionality such as Drill Down, Drill through, and Parameters
Ability to meet deadlines, and produce effective results, while working both independently and with teams
Involved in requirements gathering, analysis, design, development, change management, deployment
Experience in agile methodology
Experienced in TFS Version Control
Flexible and versatile to adapt to any new environment and work on any project

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Power BI/ SSRS Developer

Responsibilities:

Created dashboards using tabular and multi-dimensional models.
Design and model data sets with Power BI desktop based on measure and dimension
Used DAX to create formula to develop visualization by using Power BI
Created workspace and published reports in Power BI Services
Connected Various Data Sources in Power BI Service using On-Premises Gateway connection.
Cleanses data by using Query Editor in Power BI
Created Dashboard, Tabular reports, Matrix reports, Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using Power BI and SQL Server Reporting Services (SSRS)
Created stored procedures, user defined functions, views, triggers, indexes and CTE using SQL Server Management Studio (SSMS)
Created Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints
Experienced in Error and Event Handling, Precedence Constraints, Break Points, Check Points and Logging
Developed packages that upload the data from excel spreadsheets and csv files.
Implemented error handling mechanisms to avoid abortive errors because of data issues.

Confidential, Morrisville, NC

Power BI / SSRS Developer

Responsibilities:

Created visualization, dashboards, tabular reports, matrix reports, chart reports, parameterized reports, sub reports, Ad-hoc reports, drill down reports according to business requirements using Power BI and SQL Server Reporting Services (SSRS)
Created CTE, indexes, stored procedures, user defined functions, views, triggers using SQL Server Management Studio
Created POWER BI Visualizations and Dashboards as per the requirements.
Built Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension
Used DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions
Created Workspace and Published reports in Power BI Services
Developed tablix reports, sub reports, matrix reports, charts, and drill down reports, ad hoc reports using SQL Server Reporting Services (SSRS)
Created and scheduled complex SSIS packages for transferring data from multiple sources into SQL Server, and Excel by using SSIS and DTS of SQL Server
Created triggers, cursors and joins by using SQL Server Management Studio
Used TFS version control

Confidential, Fairfax Station, VA

Power BI / SSRS Developer

Responsibilities:

Transformed and combined the data using Query Editor in the Power BI and published Power BI Desktop reports created in Report view to the Power BI service and installed on premise data gateway and scheduled daily data refresh in Power BI
Worked extensively on Power BI and created reports/dashboards using different type of slicers and different visualizations like bar charts, line charts, graphs, and pie charts etc. to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI
Created SSRS Reports, such as drilled-down, drilled-through, and parameterized reports, with SQL query to pull data from MS SQL Server.
Created Gauge Report, Sub-Reports, Drilldown-Reports, Summary Reports, Linked Reports, and Parameterized Reports in SSRS and Workday for different departments.
Used complex expressions to calculate, group, filter, parameterize, and format the contents of the SSRS and Workday reports.
Developed reports and deployed them on server using SQL Server Reporting Services.
Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
Used DTS Packages and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources.