Krunal Dudhe

Client: MSCI (Morgan Stanley Capital International)

Project: Marketing

Team Size: 6

Role: BI Analyst

• Data Visualization and Reporting: Developed interactive Power BI reports and dashboards tailored for MSCI's marketing data. Translated intricate marketing business requirements into visually compelling data visualizations, empowering data-driven decision-making.
• Data Modeling and Transformation: Designed and implemented efficient data models specific to marketing, establishing relationships, Hierarchies, and calculated columns for accurate and consistent reporting. Utilized Power Query to transform and cleanse diverse marketing data sources into usable formats for in-depth analysis.
• DAX Calculation and Analysis: Created advanced DAX calculations and measures for MSCI's marketing data, extracting meaningful insights, performing complex calculations, and supporting comprehensive data analysis. Implemented time intelligence functions to facilitate comparisons and trend analysis in the marketing context.  Collaboration and Stakeholder Engagement in Marketing: Collaborated closely with MSCI's marketing business analysts and stakeholders. Conducted regular meetings and presentations to ensure seamless alignment between technical developments and marketing objectives, delivering customized Power BI solutions.
• Performance Optimization and Troubleshooting: Optimized report performance, minimized load times, and proactively resolved marketing data-related issues. Ensured the integrity and reliability of the Power BI solution within the dynamic marketing environment at MSCI.
• Environment: Proficient in Power BI, SQL, Excel, Jira, and SharePoint, with a focus on leveraging these tools in the context of marketing data analytics.

• Project: Reinsurance
• Team Size: 9
• Client: Everest
• Role: BI Analyst
• Description: Everest is an insurance company with a wide range of insurance products and property G casualty-related reinsurance services. In this project, we focused on the Reinsurance module and provided meaningful insights through Power BI reports.

Responsibilities:

• Data Visualization and Reporting: Develop interactive and visually appealing Power BI reports and dashboards to provide insightful data visualization for the Everest Reinsurance project. Translate complex business requirements into effective data visualizations that facilitate data-driven decision-making.
• Data Modeling and Transformation: Design and implement efficient data models, including relationships, hierarchies, and calculated columns, to support accurate and consistent reporting. Utilize Power Query to transform and cleanse raw data from diverse sources into usable formats for analysis.
• DAX Calculation and Analysis: Create advanced DAX calculations and measures to derive meaningful insights, perform complex calculations, and support data analysis within the Everest Reinsurance project. Implement time intelligence functions to facilitate comparisons and trend analysis.
• Collaboration and Stakeholder Engagement: Collaborate with business analysts, stakeholders, and team members to understand data requirements and deliver tailored Power BI solutions that meet project goals. Conduct regular meetings and presentations to ensure alignment between technical developments and business objectives.
• Performance Optimization and Troubleshooting: Optimize report performance through efficient data modeling, minimizing load times, and implementing best practices. Identify and resolve data-related issues and anomalies, ensuring the integrity and reliability of the Power BI solution.
• Identified operational efficiency opportunities to support long-term growth plans.
• Communicated findings and insights to senior management to establish best practices and guide analysis into action and results.
• Pinpointed opportunities for business improvement and defined and measured success points.
• Evaluated methods and made appropriate changes to increase productivity and decrease turnaround time to accomplish desired output.
• Environment: Power BI, SQL, Visual Studio, Jira, SharePoint.

• Project: UCO – Insurance
• Team Size: 5
• Client: GEICO (USA)
• Role: Power BI Developer
• Description: The client is a US-based vehicle insurance company specializing in vehicle insurance. The project involves data related to calls, sales, payments, and delinquencies.

Responsibilities:

• Creating and maintaining multiple Power BI reports to analyze call performance and sales.
• Gathering and understanding business requirements. Analyzing data and presenting meaningful insights through data visualization.
• Designing, developing, and enhancing intuitive and interactive reports and dashboards based on underlying data for data-driven decisions.
• Identifying and understanding Key Performance Indicators (KPIs) with clear objectives.
• Leading Operational and Development Teams. Gained good exposure in working with the pharmaceutical domain.
• Improved business direction by prioritizing customers and implementing changes based on collected feedback.
• Analyzed open orders, backlog, and sales data to provide sales team with insights.
• Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
• Conducted interviews with key business users to collect information on business processes and user requirements.
• Environment: Power BI, Power BI Service, SQL, SharePoint, JIRA.

• Project: Financial Sales Dashboard Analysis
• Client: Goldman Sachs (USA)
• Role: Power BI Developer.
• Description: Gathering Point of Sale (POS) data from various teams through SharePoint, SQL and creating Power BI reports to extract meaningful insights. Analyzing Revenue, Budget, Expenses, and Surplus/Deficit for each month and year.

Responsibilities:

• Creating and maintaining multiple Power BI reports. Writing Data Analysis Expressions (DAX) measures to create various metrics.
• Implementing dynamic Row-Level Security (RLS).
• Resolving bugs and defects, conducting root cause analysis, and providing optimized solutions.
• Participating in all phases of the Software Development Life Cycle (SDLC), including Requirement G Impact analysis, Build, Unit Testing, and post-deployment verification
• Liaised with customers, management, and sales team to better understand customer needs and recommend appropriate solutions.
• Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
• Supported clients with business analysis, documentation, and data modeling.
• Created monthly forecast templates and resource management allocations for approved projects.
• Environment: Windows 10, Power BI, Power BI Service, Visual Studio, Jira, SQL