Murthy N Email & Phone Number

Bengaluru, Karnataka, India

 Involved End-to-End in Power BI - Flying Carpet Dashboard in Lonza Project. Identified the Key Metrics, Data Cleaning and Transformation, Also, Provided Regularly update and refine on report in Lonza project Completed Requirement gathering, Specification document and received sign-off for Flying Carpet Dashboard, Self-Service and Commentary module. Created 450+ measures using Tabular editor and Simplified Complex Data modelling from SQL Server Datasource. Created Self-Service report and Zebra BI Self-Service that user have freedom to select a visual type from several options and choose the different Metric field in Lonza Project. Used Zebra BI Advanced visuals with license key in Flying Carpet Dashboard. Created SharePoint List in Client Environment and Managed Access. Created Commentary Module using multiple SharePoint list to Write-back user comments in Power apps and Integrated in Power BI. Completed Assigned tasks within Time period and updated in Jira board with description

Bengaluru, Karnataka, India

Client: Spend Insights 360Role: Data Analyst Environment: Power BI Reporting tool: Power BI Desktop, Power BI Service and Excel Description:Insight360, a SaaS-based business intelligence technology platform, helps companies achieve greater profitability and revenue by unlocking hidden insight within data and information assets. The Insight360 technology leverages typically hard-to-combine data including log files, customer files, billing databases and CRM data to deliver unique multi-dimensional analysis and visualization for its customers. The company offers five real-time solutions: Insight360 Customer Data Platform, Insight360 Analytics, Sales Rep Insight360, Prospecting Insight360, and Search Insight360.Roles & Responsibilities: ●Involved in configuring gateways and performing schedule refresh for dashboards. ● Implemented Visual Level, Page level, report level filters and pinning in dashboards. ● Written simple DAX calculation as per the requirement to maintain business measures. ● Creating the roles for the dashboards, sharing the developed dashboards to the client in power BI ● Shared dashboards with various users across business based on their country level applied roles to restrict data to specific region. ● Configured SQL jobs and maintenance plans to ensure database stability and integrity ● We have been working with SQL queries like DDL and DML operations and working with date functions. ● Wrote several stored procedures, functions and writing the date intelligent functions in SQL build consistent for the sale. ● Using Aggregate functions, Time Intelligence Functions, Date and Time functions.

Bengaluru, Karnataka, India

Client : HenkelRole : Data analyst Environment: Power BI & Excel. Description: Henkel AG & Co. KGaA is a German chemical and consumer goods company headquartered in Düsseldorf, Germany. It is a multinational company active both in the consumer and industrial sector. Founded in 1876, the DAX company is organized into three globally operating business units (Laundry & Home Care, Beauty Care, Adhesive Technologies) and is known for brands such as Loctite, Persil, Pritt, Dial and Purex, amongst others. Roles & Responsibilities: ● Creating different reports like Pivot table, list, chart reports and Dashboards.● developing KPIs, Key influencers, Pie charts, Scatter charts, Tree maps using power BI desktop. ● Using Power query for ETL Process and Data profiling.● Identifying Fact and dimension tables for creating relationship in Data model view.● Ensure the data quality and integrity in databases● Implementing Python Script in PowerBI Desktop for visualization.● Changing String connection between Environment in Power BI service.● Improve report performances and identifying bugs. ● Handled the admin setting in particular with tenant & capacity settings.● Ensure the data quality and integrity in databases. ● Fix any issues related to database performance and provide corrective measures. ● Develop best practices for Dashboard design and development activities.