Rachana Muthyala

Data Analyst

Hyderabad, IN.

About

Analytical and detail-oriented Data Analyst with 9 months of hands-on experience in data-driven decision-making through internships. Proven expertise in SQL, Power BI, Tableau, Python, and Excel, with a track record of building automated dashboards that reduced reporting time by 25% and improved forecast accuracy by 40%. Adept at financial, insurance, and CRM analytics, skilled in interpreting regulatory requirements and supporting risk assessment to drive business intelligence and strategic outcomes.

Work

ExcelR

|

Data Analyst Intern

Hyderabad, Telangana, India

→

Summary

As a Data Analyst Intern at ExcelR, Rachana optimized data processing workflows and developed interactive Power BI dashboards, significantly improving financial forecast accuracy and reducing reporting time.

Highlights

Optimized data extraction and processing workflows using SQL and Python, achieving a 25% reduction in reporting time.

Designed interactive Power BI dashboards for financial KPIs, enhancing forecast accuracy by 40%.

Automated recurring compliance and performance reports, streamlining management review processes and improving efficiency.

Conducted in-depth data investigations to identify anomalies and ensure high data quality in financial datasets.

Collaborated with stakeholders to align analytical outputs with regulatory requirements and PMO objectives.

Education

Sri Indu Institute of Engineering and Technology

Hyderabad, Telangana, India
→
B.Tech. Computer Science Engineering Grade: 70.2%

Languages

English

Telugu

Hindi

Certificates

Deloitte Data Analytics Job Simulation

Forage

Data Analytics Certification

ExcelR

Power BI and SQL Fundamentals

Not specified

Skills

SQL

Joins, CTEs, Aggregations, Window Functions.

Python

Data Processing, Logistic Regression.

Excel

Advanced Excel, Data Cleaning, ETL.

Power BI

Dashboarding, KPI Tracking, DAX, Data Visualization.

Tableau

Dashboarding, Data Visualization.

Data Cleaning

ETL.

ETL

Power Query.

Forecasting

KPI Tracking

Investigative Analysis

Financial Data Analytics

Insurance Analytics

Churn Prediction.

CRM/Salesforce Analytics

Sales Pipeline, Lead Conversion.

Compliance Reporting

Stakeholder Communication

Problem Solving

Business Acumen

Interests

Cinematic Storytelling

Cooking

Projects

Salesforce CRM Analytics

→

Summary

Developed and optimized dashboards for sales pipeline monitoring and CRM data analysis to enhance business strategy and performance.

Insurance Analytics and Churn Prediction

→

Summary

Analyzed customer and policy data to identify churn patterns and risk profiles, applying predictive modeling for improved retention strategies.