Shruti L.

Business Intelligence Analyst

Shruti is a Business Intelligence Analyst with seven years of experience in the automotive, semiconductor, and manufacturing industries. She excels at creating advanced visualizations and analytics that uncover insights and drive business growth through data-driven solutions.

Proficient in Tableau, SQL, and Power BI, she transforms complex data into clear, actionable strategies that empower informed decision-making.

At KMW Industries, her data insights increased in-house production by 170% and reduced rejection rates by 70%. At Micron Technology and Bajaj Auto, she enhanced assembly line yields to 97%, minimized production delays, and achieved substantial cost savings.

With a strong technical foundation and a strategic mindset, Shruti fosters innovation and efficiency through data-driven decision-making.

Main expertise

  • Python
    Python 3 years
  • Microsoft Power BI
    Microsoft Power BI 4 years
  • Databricks
    Databricks 1 years

Other skills

  • PostgreSQL
    PostgreSQL 2 years
  • Apache Spark
    Apache Spark 1 years
Shruti

Shruti L.

India

Get started

Selected experience

Employment

  • BI Analyst

    NewVision Software - 10 months

    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.

    Technologies:

    • Technologies:
    • MySQL MySQL
    • PostgreSQL PostgreSQL
    • SQL SQL
    • Microsoft Power BI Microsoft Power BI
    • Microsoft Fabric Microsoft Fabric
  • Business Analyst

    KMW Industries - 4 years 11 months

    • 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.

    Technologies:

    • Technologies:
    • MSSQL MSSQL
    • SQL SQL
    • Microsoft Power BI Microsoft Power BI
    • Data Analytics
    • Tableau Tableau
  • Industry Analyst

    Micron Technology - 2 years

    • 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.

    Technologies:

    • Technologies:
    • MSSQL MSSQL
    • SQL SQL
    • Data Analytics
    • Tableau Tableau
  • Operation Analyst

    Broan Nutone - 7 months

    • 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.

    Technologies:

    • Technologies:
    • MySQL MySQL
    • Microsoft Power BI Microsoft Power BI
    • Data Analytics

Education

  • MSc.Industrial Analytics

    University of Wisconsin Madison · 2017 - 2019

  • BSc.Mechanical Engineering

    Walchand College of Engineering · 2011 - 2015

Find your next developer within days, not months

In a short 25-minute call, we would like to:

  • Understand your development needs
  • Explain our process to match you with qualified, vetted developers from our network
  • You are presented the right candidates 2 days in average after we talk

Not sure where to start? Let’s have a chat