Namrata Samanta

Experience

• 

  Cognizant

  Nov 2015 - Feb 2024

  * Working as Lead Data Analyst with proficiency in Python, SQL and Power BI for Data Cleaning, Transformation, and visualization.* Having experience in connecting with multiple Data sources including SQL, Azure SQL, Databricks, SAP, Google Cloud Storage in Power BI with clear knowledge to rectify the connection errors if any.* Working with various Python modules such as PySpark, Pandas, NumPy, Seaborn, Matplotlib with clear understanding of object-oriented Programming. * Having experience in working in various Cloud environments like Azure, GCP.* Working with client in App hygiene with regular cleaning of Power BI workspaces/dashboards.* Strong hold over DAX and experience in Handling Dynamic Parameters with M language and power query.* Having experience in importing Power BI templates from vendors, creating templates per requirement.* Worked extensively on creating Supply Chain Power BI reports based on SAP and Non-SAP sources including Sales dashboard on Sales and Distribution Module providing critical insights on the SalesOrders to assist in order follow up and Fulfillment, Invoice vs Order Intake, Spend, Quotes Analysis based on CRM(SAP)- Pre Sales* KPI dashboard creation to understand the performance on various segments like Procurement, Warehousing to understand the bottlenecks, Margin and Budget Analysis, Customer insight.* Worked with internal teams to automate the data fetching from Service Now CMDB to power BI and created Billing reports with Json Api connection.* Imported data from SAP with help from SAP team to Azure Data Lake Storage and analyzed the data using PySpark in Databricks and visualized data in Power BI to provided business critical insights to clients.* Worked on Microsoft Dynamic 365 CRM report creation for providing overviews on Cases, Quotations and opportunities across multiple sales organization.* Experience with Unix Scripting* Following Agile methodology for delivering requirements/changes with Jira (Atlassian). Show less * Worked in k2 black pearl with MSSQL database, SSRS/ Power BI Reporting.* Created and updated of SSRS Reports with in depth knowledge in RDL.* Deployed multiple SSRS reports on dev, UAT and prod servers.* Worked with Microsoft Excel as an important tool for data cleaning and exploration. * Managed power BI app services including gateway, access, capacity, workspace, and app management.* Created and updated of K2 workflow/form/smart objects.* Hands-on experience in working with Azure Data Factory for defining Pipeline.* Having expertise in Unix Shell scripting.* Versioned deployment of big fixes and development requests* Created and updated stored Procedure, views, tables in MS SQL* In depth knowledge of MS SQL DDL, DML coding* Wrote SQL Stored procedures and views with around 1000 LOC or more.* Worked on variety of Finance requirements for the clients to provide clean dashboards, reports and corresponding apps for wider audience. * Created power BI report for the application using Power BI Report Builder with views in MSSQL* Worked with Hadoop CDP as primary database with some data fetched directly in power BI through CDP while other through MSSQL views/stored Procedure.* Worked on HUE, Azure data lake with understanding of the Hadoop ecosystem.* Developed Availability Reports, Performance Reports, Monthly Service Management Reports, Quarterly Management Reports, Finance Dashboard* Managed Row level security creating roles and maintaining access. Show less

  • Lead Data Analyst

    Dec 2020 - Feb 2024

  • SQL Developer/Data Analyst

    Mar 2017 - Nov 2020

  • IAM Admin

    Nov 2015 - Feb 2017
• 

  IKEA

  Mar 2024 - now

  Software Engineer