Manjunadh Chandra

PRIMARY RESPONSIBILITIES:

• Collaborated with Stakeholders and different departments like International Business, Sales, Logistics, Procurement, E-Commerce, Dynamics development, External consultants and Controlling to understand their requirements and developed appropriate visualizations to meet their needs.
• Maintained Global Business Intelligence and DWH Projects in Azure DevOps by creating Epics, User Stories, tasks and thorough documentations for the business requirements.
• Extracting data from different data sources like SQL Server, Azure Datalake, O-data, Excel, .CSV, Sharepoint to Power BI Desktop.
• Created complex Data Models, reports, and dashboards by combining both SAGE and Dynamics 365 F&O ERP data for Departments like Sales, Procurement, Inventory etc.,
• Created complex DAX queries based on the business requirements.
• Good experience in creating Line, Table, Matrix, Bar, Pie chart, Doughnut charts, funnel, clustered columns for visualization.
• Experience on different filter levels like visual, page, report level, sync slicers, Drill down and Drill through filters.
• Experience in applying Edit interactions among the visuals, in using Bookmarks, selection pane and buttons for modeling in reports.
• Experience in publishing reports to Power BI Service and setting up required connections settings.
• Experience in scheduling Power BI reports using Data gateway.
• Worked on complex Row Level Security for the users in the Organization.
• Managed Power BI service admin portal along with the Team lead.
• Designed, developed and tested ETL processes by using Azure Data Factory to extract, transform and load data from multiple sources and consolidated diverse databases into a unified one.
• Assisted in creating Views, Stored Procedures, Fact and Dimension tables into DWH database and worked closely with the external consultants to develop Dynamics 365 F&O Data Lake tables into Fact tables.
• Tested all BI reports data directly with Dynamics 365 F&O for Data Accuracy and gained a very good knowledge in many modules.
• PowerApps: Built Canvas and Model Driven Apps, worked for D365 Sales CRM tool to integrate BI reports.
• Solved many BI related Helpdesk tickets in the Organization.
• Supported in automating Google Analytics data using python scripts.
• Participated in team meetings discussing project progress and providing feedback about possible improvements in design and functionality.
• Mentored and gave training to Business users.
• Maintained version control over all code changes within the BI environment including stored procedures, views and reports.

PRIMARY RESPONSIBILITIES:

• Interacted with clients, engineering firms to develop project opportunities and to interpret needs and requirements.
• Collected, analyzed and summarized project information and trends to prepare project status reports for management.
• Prepared technical offers during tender stages.
• Estimated change orders and costs for project manager.
• Upgraded the company's some Excel analytics processes with advanced formulas and macros, leading to a 40% decrease in processing time.
• Transformed data to Power Query Editor for any kind of operations like doing merge and append as per the requirement.
• Developed basic data visualizations and Data Analysis using Excel, aiding in the understanding of requirements.

PRIMARY RESPONSIBILITIES:

• Interacted with clients, engineering firms to develop project opportunities and to interpret needs and requirements.
• Collected, analyzed and summarized project information and trends to prepare project status reports for management.
• Prepared technical offers during tender stages.
• Transformed data to Power Query Editor for any kind of operations like doing merge and append as per the requirement.
• Developed project plans, timelines and coordinated resources to ensure successful completion of projects.