Data Analyst
Resume:
Chicago, IL
*************@*****.***
Likhitha Koyyada Data Analyst
Work Auth: H1B
Data Analyst with 6 years of experience across healthcare, banking, and enterprise technology, specializing in SQL, Python, Tableau, and Power BI. I build dashboards, automated reports, and data models that help business teams make faster, better decisions — covering the full analytics cycle from ETL and data modeling to analysis and executive-ready reporting. TECHNICAL SKILLS
Languages Advanced SQL (query optimization, indexing), Python (pandas, NumPy, PySpark), UNIX Shell BI & Reporting Tableau, Power BI (DAX), Advanced Excel (pivot tables, Power Query), SSRS Databases Snowflake, SQL Server, Oracle, MySQL, PostgreSQL, Azure SQL, data modeling Data Engineering ETL/ELT pipelines, Microsoft Fabric, Azure Data Factory, Airflow, dbt, Kafka, SSIS, Informatica Cloud & Big Data Microsoft Azure (Synapse, Data Lake, Databricks), AWS, Apache Spark, Delta Lake Tools & Methods Git, Jira, Azure DevOps, ServiceNow, Agile/Scrum, CI/CD PROFESSIONAL EXPERIENCE
Data Analyst Aug 2024 – Present
Mayo Clinic, Chicago, IL (Remote)
Build Power BI and Tableau dashboards tracking patient flow, wait times, and provider capacity for clinical leadership.
Write complex SQL (CTEs, window functions) over multi-million-row clinical datasets.
Run data quality checks and validation rules across source systems, keeping reporting accurate and trusted.
Partner with clinical and operational teams to define KPIs and present findings in decision-ready formats.
Build ETL pipelines from multiple sources into the reporting layer with scheduled refreshes.
Automate recurring reports and extracts with Python (pandas), cutting manual prep for weekly/monthly deliverables.
Analyze trends in patient volumes and operational metrics, flagging anomalies early for planning decisions.
Document data definitions and reporting standards so teams can self-serve consistent metrics.
Support ad hoc analysis requests from leadership with quick turnarounds during operational reviews. Reporting & Business Intelligence Analyst Nov 2023 – Jun 2024 Citi, Texas (Remote)
Produced monthly revenue and expense reporting across banking lines, including month-end actuals and management packs.
Optimized SQL queries and indexes over 20M+ monthly transactions, improving report performance.
Built driver-based forecasts and budget inputs; prepared plan, forecast, and YoY variance analysis on key drivers.
Automated recurring reporting with Advanced Excel, Power Query, and Python, reducing manual effort across cycles.
Maintained data integrity across hierarchies (business lines, cost centers, entities) with reconciliation checks.
Prepared senior management presentations and ad hoc analysis on business performance and expense trends.
Troubleshot reporting and data quality issues, resolving integrity problems with technology partners.
Partnered with finance and business teams to gather requirements and deliver on recurring deadlines.
Supported portfolio and regulatory reporting with accurate, well-documented data extracts and analysis. Application Development Analyst Mar 2019 – Jul 2022 Accenture, Hyderabad, India
Built data pipelines and reporting solutions with Python, Apache Spark, SQL, and Tableau for enterprise clients.
Designed relational data models in Oracle and MySQL using normalization and dimensional modeling.
Developed ETL processes integrating multiple sources into data warehouses with validation checks.
Improved data accuracy through reconciliation workflows, fixing source data issues with client teams.
Wrote and tuned SQL queries for reporting needs, improving performance on large transactional datasets.
Gathered requirements from business stakeholders and translated them into technical designs and features.
Created Tableau dashboards and scheduled reports giving users self-service visibility into operational metrics.
Worked in Agile teams — sprint planning, code reviews, documentation — delivering on tight timelines.
Supported testing and QA for data deliverables, ensuring reliability before production release. EDUCATION
M.S., Information Systems with Business Analytics — Murray State University Aug 2022 – Dec 2023 B.Tech., Computer Science and Engineering — JNTU Hyderabad Aug 2016 – May 2020 CERTIFICATIONS
Azure AI Engineer Associate Azure AI Fundamentals Fabric Data Engineer Associate Azure Data Fundamentals Power BI Data Analyst Associate
Contact this candidate