Work Experience:-

Project # 4:

              Project                                   :PossibleNow

Description:

Consuming Resources Usage data (from Azure, Splunk, Dynamics CRM Case Management), storing into central warehouse and generating Power BI Reports

Roles and Responsibilities:

·        Gathered requirements from client

·        Designed and implemented the logical and physical models of the Reports using Power BI

·        Created DAX Calculations for supporting the Data

·        Created Dynamic Measures with the help of Parameters

·        Modifications and alterations in the Data through Power Query

·        Used bookmarks to give reports a tool like look and feel.

Project # 3:

              Project                                 :Pentax

Description:

Utilizing the data from D365 F&O, along with archived SAP legacy data to build a reporting solution and have a comprehensive view ofBBB information 

Roles and Responsibilities:

·        Coordinated with senior analysts for any specifications/ modifications related to the defect or enhancement

·        Responsible for building Power BI Reports and Dashboards

·        Understood the business requirements through the high-level design

·        Researched and suggested solutions for performance improvement

Project #2:

Project                        :          E-Target

Description: Dealers will sent mails out to the customers for different purposes. Front end application developers will generate the files related to the email sent to the customers and files will have list of customers received the emails, no of subscribers subscribed the link in the email, unsubscribed, bounces, clicks, opens and how many completed surveys. The files are placed in the ftp and there the files need to be picked and should be loaded according to the reporting team requirements.

Roles and Responsibilities:

·        Having experience on pulling data from sources to Power BI and  pulling data from different data sources to Power BI

·        Cleansing transformation activities using Power Query in the Power BI,SQL

·        Creating Relationship b/w the tables using Modeling in Power BI,SQL

·        Created calculated columns and calculated measures and fields in the dimension table with DAX expressions and created calculated columns as per business need in Power BI

·        Created Time based Calculations like MTD, QTD, YTD based requirement

·        Created Power BI reports and Dash Boards with various visualizations

·        Having experience on creating Power BI Gateway and scheduling refreshing data as per requirement

·        Sharing the Reports and Dash Boards to end user

·        Have created staging tables, Dimension tables and Fact tables based on business requirement

·        Created Relationships at database level and Tabular Model for custom dimension

·        Create DAX queries as per the requirement

·        Created Partitions, hierarchy, roles in Tabular Model based business requirement

·        Create Tabular Model and build the project, process and deployment and using SQL server