Salesforce CRM Analytics
→
Summary
Developed and optimized dashboards for sales pipeline monitoring and CRM data analysis to enhance business strategy and performance.
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
Issued By
Forage
Data Analytics Certification
Issued By
ExcelR
Power BI and SQL Fundamentals
Issued By
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
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.