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

<p>Understanding the client requirement and getting the entity using API and establishing the relationship<br>
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<br>
Building reports as per the request by creating calculated columns using Lookups, and different DAX functions<br>
Checking the correctness of the reports and sending them to customers for their review<br>
After reviewing embedding the reports to CRM or direct sharing to the user and establishing the schedule refresh<br>
Implemented power automate and power apps flows as per the requirement<br>
Worked on data flows to perform online queries<br>
Established Gateway connection on server and scheduled refreshes of Dataflow and Dataset<br>
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<br>
Implemented Row Level Security for sharing the reports</p>

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.

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

<p>Sending Request for Quotation to vendors<br>
Bid Preparation<br>
Preparing Technical Materials Submittal<br>
Project Processing<br>
Monitoring Variation<br>
Preparation of Purchase orders<br>
Raising of Invoices for orders</p>

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.