Shruti L.

Standardized KPI definitions across Sales, Finance, and HR by aligning business inputs with DAX logic, ensuring consistent metric calculation across dashboards. • Improved dashboard performance by ~30% through SQL query tuning, data model restructuring, and use of aggregations for large datasets. • Implemented Row-Level Security (RLS) and role-based access controls to enable secure client-specific reporting within shared datasets. • Translated ad-hoc business requests into structured SQL logic and report specifications, reducing UAT rework and improving requirement clarity. • Developed parameter-driven paginated reports for payroll and operations, enabling dynamic filtering and business-friendly output formats. • Validated report outputs against business rules before deployment, reducing post-production data discrepancies.

• Designed, developed, and maintained Power BI dashboards, streamlining reporting processes and reducing manual efforts by 40%.
• Built ETL pipelines to integrate data from multiple sources, ensuring data accuracy, consistency, and governance.
• Collaborated with stakeholders to define KPIs, strengthening data-driven decision-making.
• Performed marketing trend analysis to identify patterns and optimize sales strategies.
• Implemented overhead cost optimization initiatives, reducing unnecessary expenses and increasing profitability.
• Achieved a 70% increase in in-house production by automating manufacturing setups, improving operational efficiency and minimizing manual intervention.

• Improved efficiency by using data analytics to optimize tool usage, job scheduling, and forecasting in semiconductor manufacturing.
• Developed a Tableau dashboard that reduced product lot holds by 13%.
• Increased workstation productivity by 6% through targeted data analysis.
• Built a SQL-based tool to track and minimize idle time.
• Implemented data-driven measures that boosted workstation efficiency by 8% and achieved significant cost savings.
• Optimized batch sizes, reducing setup time and improving overall process efficiency.
• Designed an automated Tableau report to monitor load port performance.
• Created a downtime matrix to track alarm rates and enhance maintenance scheduling.

• Standardized the Quality System, reducing colour variation by 80% globally and ensuring compliance with industry standards.
• Developed Power BI dashboards to track $5M in monthly scrap costs, enhancing data visibility and decision-making for senior management.