Employment History 

• Power BI / SQL BI Developer

  Colaberry Inc.

  September 2017 - Present

   Collaborate with analysts and department leaders to design, build, and customize reports and reporting packages using SQL Server, SSIS, SSRS, and Power BI
   Publishing of various kinds of data visualization dashboard reports from Power BI Desktop to Power BI service
   Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
   Used different types of transformations for cleaning the data from different sources into company format.
   Designed packages using data conversion, multicast, lookup. sorting, scripting, lookup.
   Troubleshooting of processes, issues, and errors in SSIS Packages to improve their performance.
   Edited and loaded data into Power BI desktop
   Involving in creating various Business Intelligence/Analytical Dashboard utilizing Power BI with calculating columns and measures using complex Dax calculation and transformation using Query Editor.
   Working knowledge and/or experience with Power BI (Power Pivot, Power View, Power BI Online, Power BI Desktop, Power Apps)
   Worked on Power BI Dashboard using the stacked chart, line chart, pie chart, geographical map, gauge, and slicer.
   Using Data Analysis Expressions (DAX) to solve several basic calculation and data analysis problems.
   Using Advance query editor and M language to bring raw or unstructured data to structure data with the help of different functions (adding a derived column, merge, append)
   Also, implement different M language functions or logical functions, or date-time functions.
   Using Advance query editor in parameter creation for server setting, Web content with the help of invoke function along with parameters and also in the incremental refresh.
   Experience building graphs, charts, and reports to communicate business information in SSRS and Power BI (Desktop, Service, Mobile)
   Experience in refreshing datasets using Power BI Gateway
   Experience in configuring Power BI Gateway (both personal and On-Premise)
   Interacted with users extensively in gathering the requirements and analyzing the needs of the end-users
   Understanding the various complex reporting requirements of the company and creating web reports using Reporting Services
   Defined the report layout and identified datasets for report generation. Developed reports using T-SQL queries, user-defined functions, stored procedures, common table expression (CTE), temporary table, and views.
   Optimized SQL queries for improved performance and availability.
   Created SSRS report projects in BI Visual studio and created, modified, and managed various report models with multiple objects, source fields, and expressions.
   Provide ticketing support through Azure DevOps.
   Troubleshoot T-SQL, SSIS, and SSRS errors and performance issues and address them as required.
   Select the appropriate data types and sizes for the new fields added to the system data model.
   Document definitions for all new data model constructs.
   Document the data model enhancements in a standard document.
   Develop data mappings for reports, to correlate data elements on reports to tables/fields in the underlying physical data model.