Shruti Porwal

Data Analyst and Engineer

Hyderabad, IN.

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

Freelancer

|

Data Analyst

Hyderabad, Telangana, India

→

Summary

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

Highlights

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.

Freewings Power And Infra Ltd

|

Engineer And Analyst

Hyderabad, Telangana, India

→

Summary

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

Highlights

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.

Texas Instruments

|

Intern - Design Verification

Bangalore, Karnataka, India

→

Summary

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

Highlights

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.

Samsung Semiconductor Research

|

Automotive Software Intern - Memory Solutions

Bangalore, Karnataka, India

→

Summary

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

Highlights

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.

UltraTech Cement Limited

|

Research Intern - Inventory

Mumbai, Maharashtra, India

→

Summary

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

Highlights

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

BITS Pilani Hyderabad Campus

Hyderabad, Telangana, India
→
MSc and B.E. Mathematics and Electronics and Instrumentation Grade: 7.7 Cgpa

Languages

English

Certificates

Management Essentials

Indian School of Business

Lean Six Sigma Green Belt

Henry Harvin

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.