ARUNSUNDAR M

Overall, I have 11.8 years of experience, including 5.1 years as a results-driven Business Intelligence Developer, designing and developing data-driven solutions to enhance business insights. Proven track record of leveraging data analysis and visualization techniques to deliver impactful reports and dashboards to stakeholders. Expertise in data modeling, DAX formulas, and ETL processes to transform raw data into actionable insights. Handling and collaborating with cross-functional teams and stakeholders to gather requirements and drive data-centric decision-making. Skilled in optimizing performance and ensuring data security within Power BI projects. Known for consistently delivering high-quality solutions that drive operational efficiency and business growth. I bring extensive experience in presenting insightful reports to stakeholders, showcasing a strong ability to communicate complex findings in a clear and impactful manner. My proficiency in delivering compelling presentations contributes to informed decision-making and drives successful collaboration within diverse project environments. Created and optimized Materialized Views (MV) in Incorta to streamline complex data modeling processes, improving data integration and query performance in Power BI reports.

• Microsoft Certified: Power BI Data Analyst Associate

Client  

FCM Travel Solutions

 Domain

Business Travel Management

Project Period of Work

[Jul 2019 – Jul2023]

Environment Description 

Power BI, SQL

Challenges Solutions Responsibilities

Implemented a dynamic and user-friendly Power BI solution tailored to FCM Travel Solutions' unique requirements. The project focused on consolidating and visualizing global business travel data to streamline reporting mechanisms, enabling key stakeholders to derive actionable insights for strategic decision-making.

• Data Silos: Consolidating data from diverse sources like web and direct sales across numerous regions.
• Granular Insights: Drilling down into individual store performance metrics, including budget, capital expenditure, and construction models.
• Dynamic Visualization: Creating visually compelling and interactive dashboards for business users.
• Data Integration: Used SQL for effective data cleansing and integration from disparate sources.
• Multi-Dimensional Analysis: Designed Power BI reports with drill-down capabilities for regional and store-level performance analysis.
• Interactive Dashboards: Developed dashboards with slicers, filters, and conditional formatting for intuitive user exploration.
• Report Design & Development: Created Power BI reports with defined drill-through filters.
• Metrics & Calculations: Designed measures and calculated columns to generate actionable insights.
• Security Implementation: Applied row-level and role-based security to ensure controlled data access.
• User Interactivity: Enhanced user experience with bookmarks, synchronized slicers, and editable interactions.
• Automation & Sharing: Scheduled report refreshes using Enterprise Gateway for timely data access.

Client    

FedEx

Domain

Logistics and Supply Chain Automation

Project Period of Work

[Sep 2023 – Jan 2024]

Environment Description

Power BI,Sql,sharepoint,Automation Anywhere, Business Intelligence Tools

Responsibilities

Implemented automation solutions using Automation Anywhere to enhance operational efficiency. The project involved analyzing performance data, refining bot logic, incorporating stakeholder feedback, and driving data-driven improvements in logistics processes.

• Performance Analysis: Systematically analyzed performance data to identify areas for improvement and enhance operational efficiency.
• Bot Logic Refinement: Collaborated with developers to optimize bot logic and resolve technical issues for seamless functionality.
• Stakeholder Engagement: Incorporated stakeholder feedback into the development process to improve bot functionality and ensure a positive user experience.
• Data Interpretation: Used analytical skills to identify data trends and patterns, providing actionable insights for informed decision-making.
• Problem Solving: Addressed challenges in bot performance with adaptable solutions, contributing to a robust and reliable automation system.
• Cross-Functional Collaboration: Maintained communication with cross-functional teams to support the ongoing refinement of bot capabilities.
• Development Lifecycle Contribution: Actively participated in the development lifecycle by leveraging expertise in Business Intelligence tools and methodologies to optimize bot performance.
• Documentation: Contributed to creating comprehensive documentation of performance analysis, improvements, and stakeholder feedback to ensure knowledge transfer and transparency.

Client 

Norther Trust

Domain

IT Operations and Service Management Analytics

 Project Period

[Apr 2024 – Dec 2024]

Work Environment Description

Power BI, PostgreSQL, SharePoint, OData Feeds, Incorta

Responsibilities

Developed and delivered interactive Power BI dashboards and reports to visualize ServiceNow data from multiple sources, enabling data-driven decision-making for IT operations. The project involved advanced data modeling, optimization techniques, and collaboration with cross-functional teams to ensure timely and accurate reporting.

• Dashboard Development: Designed interactive Power BI dashboards and reports to visualize data from ServiceNow, PostgreSQL, SharePoint, and OData feeds.
• Advanced Analytics: Utilized advanced DAX functions to create calculated measures, columns, and time intelligence for KPI analysis related to incident management, change requests, and service performance.
• Data Integration: Modeled and integrated data from various enterprise systems, ensuring consistent and accurate reporting.
• Optimization:Created and optimized Materialized Views (MV) in Incorta to streamline complex data modeling processes.
  Implemented DAX query optimization to reduce report load times and enhance data refresh efficiency across large datasets.
  
• Collaboration: Worked with cross-functional teams to design robust data models and ensure alignment with business requirements.
• Training: Conducted training sessions for business users and teams on Power BI, DAX, and data visualization best practices to enhance the organization’s analytical capabilities.