Suresh S

• Designed and deployed Power BI and Tableau dashboards to visualize key business metrics.
• Developed DAX and Tableau calculated fields for complex metrics and KPIs.
• Built robust data models, integrating data from Excel, SQL Server, and cloud sources.
• Automated ETL workflows using SSIS and Power Query.
• Collaborated with stakeholders to understand and translate business requirements into analytical solutions.
• Ensured data integrity with testing protocols, and performance tuning of reports.
• Implemented row-level security (RLS) in Power BI reports to manage user-level data access.
• Published reports to Power BI Service, and scheduled automatic data refresh via on-premise gateway.
• Integrated multiple sources, like SharePoint, Excel, and SQL, for consolidated reporting.
• Worked in Agile/Scrum environments, participating in sprint planning, stand-ups, and retrospectives.
• Provided training and documentation to business users for effective dashboard usage and adoption.
• Conducted UAT sessions with clients to gather feedback and implement improvements.
• Created bookmarks, drill-through pages, and report tooltips to enhance report interactivity.
• Optimized DAX measures to reduce report loading times, and improve performance.

• Extracted and formatted data from SQL databases using FastReactPlan.
• Conducted training for end users on software and reporting tools.
• Resolved database performance and connectivity issues.

• Collect, organize, and maintain data in Excel spreadsheets, ensuring data accuracy and integrity.
• Clean and preprocess data to ensure accuracy and consistency, including handling missing values, removing duplicates, and correcting errors.
• Develop and maintain standardized templates and data structures for MIS reporting and analysis.
• Analyze data using Excel functions, formulas, and pivot tables to generate performance-related reports.
• Prepare regular and management reports, and presentations to support decision-making at various levels of the organization.
• Perform data analysis using Excel functions, formulas, and tools such as pivot tables, VLOOKUP, HLOOKUP, SUBSTITUTE, IF, COUNTIF, and conditional formatting.
• Collaborate with senior management to develop strategic plans, goals, and objectives based on MIS data analysis.
• Track key performance indicators (KPIs) and performance targets, identifying areas for improvement and optimization.
• Continuously improve data analysis processes, and stay updated with Excel advancements.