Data Analyst - SQL, Power BI, Excel

KUSUMA KANKANALA

DATA ANALYST SQL POWER BI EXCEL

561-***-**** **********@*****.***

PROFESSIONAL SUMMARY

Data Analyst experienced in turning healthcare, operational, customer, and academic data into accurate reports, dashboards, KPIs, and actionable business insights. Skilled in SQL, Excel, Power BI, Tableau, Python, and Power Query, with hands-on experience cleaning, validating, reconciling, and analyzing large datasets from multiple sources. Strong in ad hoc analysis, trend identification, data-quality improvement, requirements gathering, and explaining findings clearly to technical and nontechnical stakeholders.

KEY HIGHLIGHTS

• Analyzed multi-source datasets using SQL, Excel, Python, and Power Query to identify trends, performance drivers, risks, and business opportunities.

• Built and maintained Power BI, Tableau, and Excel dashboards and reports for KPI tracking, operational performance, and decision support.

• Improved reporting reliability through data cleaning, reconciliation, validation checks, anomaly investigation, and documented quality controls.

• Delivered ad hoc analysis and clear recommendations while collaborating with business and technical teams to improve data collection and reporting processes.

TECHNICAL SKILLS

Data Analysis & Querying: SQL (joins, CTEs, window functions, aggregations), Python, R, Pandas, NumPy, PostgreSQL, MySQL, exploratory analysis, statistical analysis

Business Intelligence & Reporting: Power BI, Tableau, Excel, Power Query, PivotTables, XLOOKUP/VLOOKUP, KPI dashboards, data visualization, recurring and ad hoc reporting

Data Management: Data extraction, cleaning, transformation, reconciliation, validation, relational data modeling, ETL, source-to-target mapping, metadata and schema documentation

Business Analytics: KPI tracking, trend and variance analysis, performance reporting, root-cause analysis, anomaly detection, business insights, process improvement

Stakeholder Collaboration: Requirements gathering, cross-functional partnership, report specifications, presentations, data storytelling, technical documentation, Agile/Scrum

Platforms & Tools: Microsoft Office Suite, Databricks, Snowflake, AWS S3, Glue, Lambda, Redshift, GCP, Spark, Scikit-learn, Jupyter, Git/GitHub

PROFESSIONAL EXPERIENCE

Cardinal Health Data Analyst - Contract United States

Oct 2025 - Jun 2026

• Analyzed healthcare and operational data with SQL, Python, Pandas, Excel, and Power Query, translating findings into clear insights for business and analytics stakeholders.

• Built and maintained Power BI and Tableau dashboards to track KPIs, performance trends, exceptions, and data-quality issues across recurring reports.

• Extracted, cleaned, reconciled, and validated data from multiple sources, investigating missing values, outliers, duplicates, and inconsistent business rules.

• Gathered stakeholder requirements and converted business questions into report logic, measures, drill-down views, and focused ad hoc analyses.

• Monitored reporting inputs and refresh results, troubleshot SQL and data issues, documented root causes, and supported timely corrective actions.

• Presented concise summaries and visualizations to technical and nontechnical audiences, highlighting trends, risks, and opportunities for operational improvement.

• Applied healthcare data-governance and privacy practices while documenting data definitions, assumptions, validation steps, and reporting processes.

Refined Beauty Day Spa Freelance Data Analyst Boca Raton, FL

Jan 2025 - Jul 2026

• Combined appointment, service, customer, campaign, and revenue data using SQL, Excel, Python, and Power Query to create consistent analysis-ready datasets.

• Developed Power BI and Excel dashboards for bookings, repeat visits, service performance, customer engagement, and revenue trends.

• Delivered ad hoc reporting to answer business questions, identified performance opportunities, and automated recurring tasks to reduce manual reporting effort.

PROFESSIONAL EXPERIENCE - CONTINUED

Florida Atlantic University Student Data Analyst Boca Raton, FL

Dec 2024 - Aug 2025

• Cleaned, transformed, and validated academic and operational datasets using SQL, Python, Excel, and Power Query to improve reporting accuracy.

• Created Power BI and Excel dashboards that tracked KPIs, trends, and project status and communicated results through concise visual summaries.

• Worked with the supervising professor to gather requirements, resolve discrepancies, document data processes, and deliver recurring and ad hoc reports on schedule.

HCLTech Data Engineer India

Mar 2022 - Jul 2024

• Developed and maintained SQL and Python ETL pipelines that integrated structured data from multiple systems into reliable, analysis-ready datasets.

• Performed data profiling, source-to-target mapping, reconciliation, and validation across datasets exceeding 500K records, improving consistency for downstream analysis.

• Built Power BI and Tableau dashboards for operational KPIs, trends, projections, and exceptions, enabling stakeholders to monitor performance and investigate variances.

• Used Databricks, AWS S3, Glue, Lambda, and Redshift with SQL and Python to support scalable data processing, quality checks, and reporting workflows.

• Partnered with business and technical teams to gather requirements, define reporting logic, and translate priorities into data models and deliverables.

• Troubleshot pipeline failures, source changes, SQL issues, and inconsistent results; documented root causes and implemented corrective actions.

• Managed multiple Agile deliverables and communicated status, risks, dependencies, findings, and recommendations to technical and nontechnical stakeholders.

ITC Infotech Data Analytics Intern India

Jan 2021 - Dec 2021

• Used SQL, Python, Excel, and Power Query to clean, join, profile, and validate customer and operational data for recurring and ad hoc analysis.

• Created Power BI and Tableau dashboards and Excel reports that communicated KPIs, performance trends, and important variances to stakeholders.

• Applied PivotTables, lookup formulas, and data-validation controls to reconcile source files and confirm reporting accuracy and completeness.

• Supported requirements gathering, report development, issue tracking, and documentation of data sources, transformation logic, assumptions, and limitations.

• Investigated missing, duplicate, and inconsistent records and collaborated with team members to correct discrepancies and strengthen data quality.

EDUCATION

Florida Atlantic University - Master of Science in Computer Science GPA: 4.0/4.0 2024 - 2026

QIS College of Engineering & Technology - Bachelor of Technology in Computer Science & Business Systems

CERTIFICATIONS

Graduate Certificate in Big Data Analytics - Florida Atlantic University Microsoft Certified: Power BI Data Analyst Associate Databricks Fundamentals SQL for Data Science Data Analytics with Python

Contact this candidate