Employment History 

• Power BI Developer

  Colaberry

  October 2019 - Present

  Worked with business teams to gain a rich understanding of their business, analytical, and
  reporting needs, including the identification of critical metrics.
  Performed detailed data analysis to determine the data’s structure, content, and quality
  through examination of source systems and data samples.
  Involved in creation of various Business Intelligence/ Analytical Dashboards utilizing Power
  BI Desktop and Publish it to Powe BI Service like giving slicer and filter give visualization like
  Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Scatter charts,
  Line objects, Pie charts, Map, Buttons.
  Strong knowledge in designing and developing Power BI Desktop by extracting data from
  different sources like Azure SQL DB, Salesforce, SQL Server, Oracle, Flat Files, Excel files,
  XML Files.
  Involved in designing, developing, testing, publishing, maintaining, and supporting Power BI
  Service.
  Understanding of data modeling, dimensional & relational concepts like Star-Schema
  Modeling, Snowflake Schema Modeling, Fact and Dimension tables; experience in Extract,
  Transform and Loading process of data. Read and interpret complex data models and
  optimize existing data models for better performance.
  Experience in SQL, DAX, and Power BI Query Set analysis and Section Access.
  Involved in analyzing the data and defining Key Performance Indicators (KPI).
  Handled applications performance tuning, including maintenance, upgrades, and migration of
  applications and systems.
  Automated and scheduled daily data
  Conducted Training sessions for end-users and created the documents for end-user support.

• SQL/ETL Developer

  Realtime Transportation/Dart

  October 2017 - Present

  Worked in Agile/SCRUM and Software Development Life Cycle (SDLC) environment.
  End-to-end development from gathering requirements to the deployment of SSRS reports.
  Designed and developed data warehouse & data marts using multi-dimensional models - star
  and snowflake schemas.
  Processed data from disparate data repositories and loaded it into those dimensionally
  modeled Datawarehouse.
  Created complex SSIS packages using various transformations and tasks like Sequence
  Containers, Script, for loop and For Each Loop Container, Execute SQL Task, Send Mail, File
  System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All,
  Flat file source and destination, OLE DB source and destination, excel source and
  destination, XML source, etc.
  Created various Stored Procedures to implement slowly changing dimensions with Merge
  Statement to validate the data from the source and update/insert the records into target
  tables.
  Created User Defined Functions to encapsulate frequently and commonly used business
  logic making the system more modular, secured, and extensible.
  Created calculated fields, Parameters, Filters to develop user-friendly, interactive, and
  actionable reports and dashboards.
  Involved in the publishing of various kinds of live interactive data visualizations dashboards
  and reports according to the business requirements using SQL Server Reporting Service
  Strong attention to detail, documenting business and technical requirements based on user
  interviews.
  Establish standards and best practices for dashboards and related technologies for the
  project.