Prasanna Maralappanavar

Senior Analyst

capgemini•  May 2021 - February 2024•  Bengaluru

Senior Analyst at Follett Group, supporting e-commerce applications. -Built an interactive Tableau dashboard to analyze over 10,000 incidents and service requests, providing actionable insights that reduced the number of tickets by 25%. -Developed and utilized calculated fields to compute Key Performance Indicators (KPIs) and created visualizations to identify trends, supporting business analysis and decision-making in monthly and quarterly reporting. -Written complex SQL queries, designed joins, and developed stored procedures to address support tickets, resulting in a 10% reduction in resolution time. -Resolved tickets raised by clients and customers by addressing issue in Database using SQL commands, Stored Procedures, Joins, Window Functions, CTE’s. -Work closely with cross-functional teams, including developers, QA, and customer support, to troubleshoot issues and implement solutions. -Applied advanced Excel features, such as conditional formatting, data validation, VLOOKUP, HLOOKUP, and INDEX-MATCH, to streamline data preparation tasks and enhance analytical capabilities. Analyst in Sandvik group, supporting for data migration. -Migrated Sharepoint and Microsoft Teams data from SharePoint online to SharePoint online. -Led wave migrations using Sharegate, ensuring the smooth transition of sharepoint online sites with minimal disruption. -Developed a migration portal dashboard in Tableau, providing real-time visibility into migration progress.