Employment History 

• SQL/Power BI Developer

  Colaberry Inc

  May 2017 - Present

  United States
  · Creation and development of Power BI reports and Dashboards
  · Identification of KPI’s based on Industry KPI
  · Using DAX to help give reports and Dashboards insightful meanings.
  · Collaborate with Business analyst to understand fully Business requirement Document for
  assigned Task.
  · Troubleshoot and maintain codes and packages as the need arises.
  · Publish completed Power BI reports in Power BI service workspaces.
  · Experience in using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks.
  · Created SSIS packages to extract the data from multiple sources like Excel, flat files and OLTP and
  consolidate them into staging tables.
  · Used multiple SSIS transformations such as data conversion, derived column, character map,
  conditional split, multicast to cleanse and validate data.
  · Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse
  databases, data mart databases
  · Create multi-functional reports in SSRS that are visually aesthetic.
  · Attend Daily Stand-up meetings
  · Generating on-demand and scheduled reports for business analysis using SQL Server Reporting
  Services (SSRS). Also, generated Drill down reports, Parameterized reports, linked reports, Sub
  reports, Matrix reports and Cascaded reports in SSRS
  · Excellent DAX Skills and the ability to create and troubleshoot complex calculations and measures.
  · Creating Apps for the reports using Power BI service
  · Monitoring, debugging and tuning ETL jobs and workflows