Data Analyst
Addanki Sai Rohith
Guntur
Summary
Data Analyst with +2.0 years of experience in banking and financial services, specializing in MIS reporting, risk analytics, and predictive modeling. Proficient in SQL, Python, Power BI, and Excel for data extraction, transformation, visualization, and automation. Experienced in building interactive dashboards, developing machine learning models, and delivering data-driven insights to improve operational efficiency and business performance.
Overview
2
2
years of professional experience
2
2
Certifications
1
1
Language
Work History
Data Analyst
Spellor Logi Soft Pvt Ltd
11.2023 - 10.2025
- - Designed and implemented automated ETL pipelines, reducing manual data processing effort by 35%.
- - Performed data validation and reconciliation checks, improving reporting accuracy to 99.2%.
- - Architected and deployed interactive Power BI dashboards using DAX and Power Query, optimizing KPI visibility and reducing reporting turnaround time by 40%.
- - Optimized complex SQL queries, reducing report execution time by 30–45%.
- - Automated Python-based data cleaning processes, decreasing manual effort by 50%.
- - Developed risk assessment model performance by 18% through feature engineering and hyperparameter tuning.
- - Contributed to a 15% reduction in loan default risk using predictive analytics.
- - Increased sales conversion rate by 25% through customer segmentation and behavior analysis.
- - Achieved a 15% increase in customer retention through effective trend and churn analysis.
- - Reduced data inconsistencies by 28% by implementing standardized data validation checks.
- - Accelerated monthly MIS reporting cycle time by 33%.
- - Increased dashboard adoption rate among stakeholders by 45%.
- - Reduced data redundancy by 22% through structured database management.
- - Improved decision-making turnaround time by 30% by delivering automated KPI reports.
- - Developed end-to-end ETL workflows using SQL and Python, improving data processing efficiency by 35%.
- - Designed star-schema data models for reporting and analytical optimization.
- - Created DAX measures and calculated columns for advanced KPI tracking.
- - Performed variance and trend analysis to identify revenue leakage, improving profitability by 12%.
- - Conducted root cause analysis to reduce operational discrepancies by 20%.
- - Automated Excel-based MIS reports using advanced formulas (VLOOKUP, INDEX-MATCH, Pivot Tables), reducing manual effort by 45%.
- - Built forecasting models, improving monthly revenue prediction accuracy by 18%.
- Project: Loan Risk Analysis & Approval Prediction
Education
B.Sc - Electronics & Computer Science
Acharya Nagarjuna University
Skills
Programming & Querying: SQL (MS SQL Server, Spark SQL), Python (Pandas, NumPy, Scikit-learn)
Data Visualization & Reporting: Power BI, Excel (Advanced), Matplotlib, Seaborn, Plotly
Data Engineering & Processing: ETL, Data Cleaning, Data Transformation, Data Modeling, Spark DataFrames
Data validation
Data cleaning
Excel functions
SQL databases
Data modeling
Problem-solving
Data formatting
Software
Certification
Advanced Certification in Data Analytics
Timeline
Data Analyst
Spellor Logi Soft Pvt Ltd
11.2023 - 10.2025
B.Sc - Electronics & Computer Science
Acharya Nagarjuna University