Employment History 

• BI/Power BI Developer

  Colabery Inc

  March 2018 - Present

  . Participated in gathering requirements.
  · Used ETL (SSIS) to develop jobs for extracting, validating, transforming, and loading data into the ODS.
  · Prepared the complete data cleansing, mapping for all the migrated jobs using SSIS.
  · Designed SSIS Packages to transfer data from SQL Server, Excel, XML, and flat files to Data Warehouse loading Dimensional and Fact tables.
  · Developed new and modified existing stored procedures, queries, user-defined functions, and triggers using SQL.
  · Developed and implemented Power BI's reporting, analytics, and data visualization solutions.
  · Utilized Power BI to create dynamic reports and dashboards with Drill down and Drill through.
  · Creating DAX to create calculated columns and measures in providing KPIs with insights.
  · Troubleshoot slowly running reports and dashboard elements to improve report performance.
  . Created a dashboard that track the percentage of students signing up for a class per month.
  . Deployed Dashboard to power BI Service.

• BI Developer

  R.T.G LLC, Upper Marlboro, MD

  June 2016 - February 2018

  Involved in requirement gathering meetings to understand requirements and future usage for the reports and documented them.
  Worked on SQL Server development including writing SQL Queries and creating SQL Server objects like Stored Procedures, User-defined Functions, Views, Triggers, implementing relational database models, and data integrity.
  Extract data from different sources like; Excel, OLTP, Flat File, and XML, transformed and Load to the staging tables.
  Created views and join that combined data coming from different sources into one table.
  Cleaned and transformed data within SSIS and loaded it to ODS.
  Created Slowly changing dimension (SCD) and loaded it to the data warehouse for reporting purposes.
  Created Dimensions and Fact tables
  Created a report with SSRS and Power BI.