Sanghamitra Das

• Hands on experience in Analysis using Power BI
• Hands-on experience in ERP implementation
• Expertise in SQL queries, stored procedures, triggers, and functions
• Hands-on experience in developing reports and dashboards
• Experience in project coordination
• Worked closely with clients to make projects Go-Live
• Demonstration at Client Place
• Expertise in teaching and training

Understanding the client requirement and getting the entity using API and establishing the relationship
Connected to different sources like CRM, MySQL, SQL Server, Web, Text/CSV, and Excel, SharePoint and performed ETL using Power Query and concepts like append, merge, pivot, and unpivot
Building reports as per the request by creating calculated columns using Lookups, and different DAX functions
Checking the correctness of the reports and sending them to customers for their review
After reviewing embedding the reports to CRM or direct sharing to the user and establishing the schedule refresh
Implemented power automate and power apps flows as per the requirement
Worked on data flows to perform online queries
Established Gateway connection on server and scheduled refreshes of Dataflow and Dataset
Implemented different customization of Microsoft Dynamics 365 CRM like adding entities, creating fields, creating business processes, used workflow to trigger many conditions, used power automate to trigger flow
Implemented Row Level Security for sharing the reports

Understanding the client requirement and getting the entity using API and establishing the relationship
Connected to different sources like CRM, MySQL, SQL Server, Web, Text/CSV, and Excel, SharePoint and performed ETL using Power Query and concepts like append, merge, pivot, and unpivot.
Building reports as per the request by creating calculated columns using Lookups, and different DAX functions
Checking the correctness of the reports and sending them to customers for their review.
After reviewing embedding the reports to CRM or direct sharing to the user and establishing the schedule refresh.
Implemented power automate and power apps flows as per the requirement.
Worked on data flows to perform online queries.
Established Gateway connection on server and scheduled refreshes of Dataflow and Dataset.
Implemented different customization of Microsoft Dynamics 365 CRM like adding entities, creating fields, creating business processes, used workflow to trigger many conditions, used power automate to trigger flow.
Implemented Row Level Security for sharing the reports.

Installation and configure of software Fame including MSSQL 2017, Fame Server and connecting database with the software
Coordinating with developer and end user for software development
Checking the complete workflow of the software and fixing the errors in SQL Server query
Development of new stored procedures in SQL based on the requirement document
Creating the crystal report in Visual Studio 2005 as per the customer format
Conduct training sessions with system user to explain different software modules of the software like Sales, Purchase, Project, HR and Finance and operations
Creating video and written user manuals of different modules of ERP
Migration of master data from excel to different tables in ERP
Create and maintain all technical documents related to the project
Experience in connecting with multiple data sources like SQL Server, Oracle and Excel from Power BI to build complex Datasets
Extensively worked on performing the ETL Activities in Power Query
Good Experience in filtering the Unwanted Data in Power Query
Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc.
Extensive Experience in doing Data Modeling in Power Pivot Model
Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions
Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information
Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report
Good Experience in Creating Hierarchies and Drilldown Reports
Good Experience in sorting the Data in Visualizations, Grouping, and Binning the Data in Power BI
Extensive Experience in Creating APP Workspaces and adding Members to APP Workspace to Manage the Content in Power BI Service
Publishing Reports to Power BI Service and setting up the necessary connections
Extensive Experience in Creating Dashboards using Multiple Reports
Worked on On-Premise Data Gateway to Refresh and Schedule Refresh of the Data in the Dataset
Implemented ROW LEVEL SECURITY (RLS) as part of security in Power BI
Experience in sharing the Reports and Dashboards with End Users

Installation and configure of software Fame including MSSQL 2017, Fame Server and connecting database with the software.
Coordinating with developer and end user for software development.
Checking the complete workflow of the software and fixing the errors in SQL Server query.
Development of new stored procedures in SQL based on the requirement document.
Creating the crystal report in Visual Studio 2005 as per the customer format.
Conduct training sessions with system user to explain different software modules of the software like Sales, Purchase, Project, HR and Finance and operations.
Creating video and written user manuals of different modules of ERP.
Migration of master data from excel to different tables in ERP.
Create and maintain all technical documents related to the project
Experience in connecting with multiple data sources like SQL Server, Oracle and Excel from Power BI to build complex Datasets.
Extensively worked on performing the ETL Activities in Power Query.
Good Experience in filtering the Unwanted Data in Power Query.
Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc.
Extensive Experience in doing Data Modeling in Power Pivot Model.
Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions.
Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.