Skip to content

SRINADH REDDY AMBATI

Data Analyst • s**********@gmail.com • +91*******699 • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Data Analyst with 0 years of experience applying SQL, Python, Excel, and Power BI to deliver validated data and actionable dashboards. Internship experience building ETL validations, automated reports, and interactive BI dashboards that improved KPI visibility and data accuracy for cross-functional teams.

Technical Skills

Programming Languages: Python
Frameworks and Libraries: Pandas,NumPy
Databases: SQL,MySQL,SQL Server,SQL queries,Database design
Data and Analytics: Exploratory Data Analysis,Statistical Modeling,Predictive Analytics,A,B Testing,Power BI,Tableau,Interactive Dashboards,KPI Reporting,ETL,SSIS,Power Query,Data Validation
Tools and Methodologies: Jupyter Notebook,Data Mining,Report Writing,Data Transformation
Spreadsheets: Excel Formulas,Pivot Tables,VLOOKUP,Data Cleaning

Work Experience

Spellor LogicSoft Pvt. Ltd.
Data Analyst Intern
Jun 2025 – Dec 2025
Internship at a software/analytics services company supporting reporting, data validation, and dashboard development for business stakeholders.
Tech Stack: MySQL, SQL, Python, Pandas, Excel, Power BI, Jupyter Notebook
  • Developed and optimized complex SQL queries in MySQL to extract, join, and aggregate operational datasets for weekly and ad-hoc reports used by business stakeholders.
  • Performed end-to-end data cleaning and transformation with Python (Pandas) and Excel (Power Query, Pivot Tables, VLOOKUP), raising dataset quality and maintaining 95%+ data accuracy.
  • Designed and implemented a data validation framework using SQL and Python to detect ingestion inconsistencies and reduce manual reconciliation effort.
  • Built interactive Power BI dashboards integrating multiple data sources to surface KPIs and operational metrics; dashboards improved KPI reporting efficiency by 35% and supported cross-functional decision-making.
  • Executed exploratory data analysis and basic statistical modeling to identify trends, anomalies, and process bottlenecks; packaged insights into executive summaries for management.
  • Collaborated with product, operations, and business teams to gather reporting requirements, documented reporting specs and SQL logic, and delivered analytical outputs within agreed timelines.

Projects

Operational Data Validation & Reporting
Tools Used: SQL, Python, Pandas, Power BI
  • Designed a data validation framework using SQL queries and Python (Pandas) to detect ingestion inconsistencies and flag anomalous records.
  • Automated validation checks and produced summary reports to prioritize data quality fixes, improving reliability of downstream dashboards.
  • Developed Power BI reports that consolidated validation results and operational metrics for real-time visibility into data health.
E-Commerce Analytics Dashboard
Tools Used: Power BI, SQL, Excel
  • Built an end-to-end analytics solution analyzing sales trends and customer behavior using SQL and Excel for data preparation and transformation.
  • Created interactive Power BI dashboards presenting sales KPIs, cohort analysis, and product performance to improve reporting efficiency by 35%.
  • Implemented pivot-based reporting and VLOOKUP-driven data merges to accelerate ad-hoc analysis for product and marketing teams.

Education

Trine University
MS in Information Studies • 2023 – 2024
VITS College
BTech in Electronics, Instrumentation & Control • 2017 – 2021
Telangana Intermediate Board
Class 12 • 2017 – 2017
Telangana Secondary School Board
Class 10 • 2015 – 2015

Certifications

Microsoft Power BI Data Analyst – PL-300 — Microsoft • In Preparation
Machine Learning Specialization — Coursera
Introduction to Data Science — Cisco Networking Academy
Power BI for Beginners — Simplilearn

Achievements

  • Maintained 95%+ data accuracy during internship: Implemented structured validation and data cleaning frameworks that preserved high data quality for reporting.
  • Improved KPI reporting efficiency by 35%: Developed interactive Power BI dashboards that streamlined KPI visibility and reduced manual reporting work.
  • MS in Information Studies — GPA 3.7/4.0 — 2024: Strong academic foundation in data analytics and information studies.

Powered by Drivetube · Create your own profile at drivetube.ai