Shruti Awasthi

Detail-oriented and results-driven Data Analyst with experience in the hospitality sector, specializing in spend analysis, inflation tracking, and productivity reporting. Proficient in Power BI, Advanced Excel, SAP to build impactful dashboards and generate actionable insights that drive cost optimization and strategic decisions

• Extracted and analyzed large datasets from Qlik tool , enhancing reporting accuracy and reducing manual errors by 30%.
• Developed and maintained interactive Power BI dashboards visualizing key financial metrics, enabling stakeholders to monitor performance and trends in real time.
• Conducted inflation and cost trend analysis across multiple spend categories, providing insights that supported strategic sourcing decisions and identified 10–15% savings opportunities.
• Delivered customized insights and executive-ready reports for senior leadership using Power BI, contributing to quarterly planning and forecasting.

Direct Sourcing & Supply Chain Analytics | Global Operations

• Solely managed the end-to-end development of Supply Chain Productivity reports across multiple direct sourcing categories and global regions, ensuring accurate KPI tracking and reporting.
• Extracted, transformed, and managed data from PSR, and Wave systems using Advanced Excel techniques such as Power Query, PivotTables and complex formulas to prepare datasets aligned with business reporting needs.
• Developed interactive, executive-ready Power BI dashboards and detailed Excel-based reports to track productivity savings, and cost-efficiency across sourcing categories.
• Supported the Carrier Direct Material Productivity initiative by consolidating global savings data, resulting in actionable insights that enhanced cost optimization and cross-functional alignment.
• Ingested data from diverse sources including SharePoint, Excel, and CSVs, integrating them seamlessly into Power BI models with proper data modeling, DAX, and RLS (Row-Level Security) implementation.
• Led unit testing, validation, and stakeholder reviews independently; ensured deliverables met business requirements.
• Regularly engaged with global stakeholders, presented findings in MOR (Monthly Operational Reviews), and drove initiatives that improved reporting accuracy, automation, and turnaround time.

Insurance Analytics | Mosaic Insurance – London Market

• Gained extensive hands-on experience in PostgreSQL, performing data extraction, transformation, and loading (ETL) to support analytics across seven Mosaic Insurance products, including Cyber Insurance and Professional Liability Insurance.
• Developed interactive dashboards in both Amazon QuickSight and Power BI, embedding advanced SQL queries and parameters within QuickSight for dynamic filtering and insight generation.
• Created and maintained reports for multiple business lines, tracking product performance, claim trends, and underwriting metrics—ensuring stakeholders had real-time access to critical KPIs.
• Utilized various chart types (Bar, Line, Pie, Gauge) and applied filters, slicers, and calculated fields to deliver actionable, presentation-ready insights to business users.
• Tracked project activities, test cases, and bug fixes using JIRA and ServiceNow, ensuring report delivery timelines were met and issues were resolved promptly.
• Collaborated with clients and technical leads through CTO walk throughs, regularly presenting report structures, logic, and outcomes to ensure transparency and business alignment.