Shruti Porwal

Data Analyst and Engineer

LinkedIn

About

Highly analytical Data Analyst and Engineer with 2.5 years of experience leveraging SQL, Python, and Tableau to drive operational efficiency and strategic decision-making. Proven ability to transform complex data into actionable insights, optimize energy systems, and enhance business performance through predictive analytics, financial modeling, and interactive dashboard design.

Work Experience

Data Analyst

Freelancer

Apr 2023 - Present

Hyderabad, Telangana, IN

Led data-driven marketing and product analytics initiatives, improving conversion rates and real-time performance monitoring for clients.

  • Analyzed A/B tests on marketing campaigns and UI experiments, delivering data-driven recommendations that boosted conversions by 15%.
  • Developed interactive dashboards to monitor critical product KPIs (user retention, churn, Customer Lifetime Value) for leadership, providing real-time business performance insights.
  • Automated weekly product performance reports using Python and SQL, decreasing manual effort by 70% and significantly improving report turnaround time.

Engineer And Analyst

Freewings Power And Infra Ltd

Aug 2022 - Jan 2025

Hyderabad, Telangana, IN

Designed and implemented AI-powered dashboards and analytical frameworks to optimize energy efficiency and grid export strategies.

  • Developed and maintained 5+ interactive AI-powered dashboards with anomaly detection algorithms, achieving up to 20% improvements in energy efficiency.
  • Optimized grid export strategies by contributing to a 15% reduction in operational costs through data-driven insights.
  • Collaborated on financial models, predictive analytics frameworks, and automated data pipelines, providing accurate, real-time insights for operational efficiency, cost optimization, and strategic decision-making.
  • Applied data-driven analysis to optimize solar power plant installation, commissioning, panel selection, inverter design, and grid integration, enhancing system performance.

Intern - Design Verification

Texas Instruments

Jan 2022 - Jun 2022

Bangalore, Karnataka, IN

Validated power switch functionality and automated test processes, enhancing system reliability and project efficiency.

  • Validated functionality and performance of power switches, ensuring robust system reliability and adherence to design specifications.
  • Automated test case generation with Python, drastically reducing test creation time from 2 days to 2-3 minutes and significantly improving efficiency.
  • Facilitated cross-functional collaboration across departments, ensuring seamless project alignment and timely integration of updates and minor changes.

Automotive Software Intern - Memory Solutions

Samsung Semiconductor Research

Aug 2021 - Dec 2021

Bangalore, Karnataka, IN

Contributed to the development of Universal Flash Storage (UFS) firmware, specializing in Flash Translation Layer (FTL) modules.

  • Collaborated with the Memory Solutions team, specializing in Flash Translation Layer (FTL) development for Universal Flash Storage (UFS) firmware.
  • Developed dedicated FTL modules for firmware, reviewing and refactoring over 1000 lines of C code to ensure compliance with programming standards and enhance code quality.

Research Intern - Inventory

UltraTech Cement Limited

May 2019 - Jul 2019

Mumbai, Maharashtra, IN

Conducted inventory research and automated management processes, providing critical insights for stock optimization.

  • Identified and reported inventory preservation discrepancies, proposing improvements for various materials to enhance stock accuracy.
  • Automated inventory management using advanced Excel functions and developed dynamic dashboards, effectively presenting stock data to the board for informed decision-making.

Education

Mathematics and Electronics and Instrumentation

BITS Pilani Hyderabad Campus

7.7 Cgpa

Jun 2016 - Jun 2022

Hyderabad, Telangana, IN

Certificates

Management Essentials

Indian School of Business

Jan 2025

Lean Six Sigma Green Belt

Henry Harvin

Aug 2020

Languages

English

Skills

Python

  • Data Analysis
  • Automation
  • Scripting
  • Machine Learning

MySQL

  • Database Management
  • SQL Queries
  • Data Extraction
  • Relational Databases

Tableau

  • Data Visualization
  • Dashboard Design
  • Business Intelligence
  • Interactive Reports

Google Analytics

  • Web Analytics
  • Marketing Performance
  • KPI Tracking
  • User Behavior Analysis

Power BI

  • Business Intelligence
  • Dashboard Development
  • Data Modeling
  • Report Generation

Advanced Excel

  • Data Manipulation
  • Financial Modeling
  • Reporting
  • VBA

MS Office

  • Word
  • PowerPoint
  • Outlook
  • Collaboration

MATLAB

  • Technical Computing
  • Algorithm Development
  • Numerical Analysis

SQL

  • Database Querying
  • Data Management
  • Data Extraction

Predictive Analytics

  • Forecasting
  • Statistical Modeling
  • Data-driven Insights

Financial Modeling

  • Valuation
  • Budgeting
  • Forecasting
  • Scenario Analysis

Interactive Dashboard Design

  • UI/UX for Data
  • Data Storytelling
  • Real-time Monitoring

A/B Testing

  • Experiment Design
  • Hypothesis Testing
  • Conversion Rate Optimization

KPI Tracking

  • Performance Monitoring
  • Business Metrics
  • Goal Setting

Anomaly Detection

  • Data Monitoring
  • Pattern Recognition
  • Alert Systems

Data Pipelines

  • ETL Processes
  • Data Integration
  • Workflow Automation

Firmware Development

  • Embedded Systems
  • C Programming
  • Universal Flash Storage (UFS)
  • Flash Translation Layer (FTL)

Design Verification

  • System Reliability
  • Test Case Automation
  • Python Scripting

Inventory Management

  • Stock Optimization
  • Discrepancy Reporting
  • Process Automation