Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Likhita Yakanuru

Hartford,CT

Summary

Detail-oriented Data Analyst with 4+ years of experience in data analytics and business intelligence, primarily in fast-paced, data-driven ecosystems. Expert in advanced SQL, data modeling, and data lineage practices with deep experience across Snowflake, SQL Server, and large-scale data lakes. Proven track record of uncovering insights and delivering visual dashboards that support strategic decision-making. Experienced with Customer 360 initiatives, personalization platforms, and structured/semi-structured datasets including JSON. Adept in Power BI and Tableau for analysis, validation, and visualization.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Analyst

SMBC Group
, USA
01.2023 - Current
  • Optimized and debugged complex SQL queries across enterprise-scale datasets to support real-time analytics.
  • Built automated data pipelines using Python and SQL, reducing manual reporting time by 40%.
  • Developed Power BI dashboards for senior leadership to track KPIs and risk exposure.
  • Led documentation efforts including STT and FLD mappings to maintain data governance and audit readiness.
  • Partnered with internal teams to develop data lineage maps and conduct root cause analyses for data discrepancies.
  • Integrated structured and semi-structured datasets (including JSON) into analytics workflows.
  • Delivered segmentation and predictive models using scikit-learn to enhance personalization and Customer 360 strategies.

Data Analyst

Parexel
Hyderabad, India
06.2020 - 07.2022
  • Engineered ETL workflows to consolidate disparate data sources into centralized data warehouses (Snowflake, AWS S3).
  • Built SQL optimization routines using indexing and CTEs, cutting query times from 10+ minutes to <30 seconds.
  • Designed interactive dashboards in Power BI and Tableau for healthcare, finance, and operations stakeholders.
  • Supported EMR systems through data modeling and clinical analytics integrations.
  • Executed A/B testing and statistical analysis to validate business and compliance decisions.
  • Collaborated on the transition of analytics workflows to cloud environments including AWS Redshift.
  • Developed anomaly detection models to enhance fraud detection and operational efficiency.

Education

Master of Science - Data Science

University of New Haven
12.2023

Bachelor of Science -

SRM University
Hyderabad, India
05.2022

Skills

Languages & Tools: SQL, Python, NoSQL, Jupyter Notebook, Git

Databases: Snowflake, SQL Server, MySQL Workbench, AWS Redshift

BI & Visualization: Power BI, Tableau, Excel, MS Visio, MS Access

Data Engineering: Data Modeling, ETL Pipelines, Data Lineage, JSON

Platforms: Customer 360, EMR systems, Identity Resolution

Cloud & Workflow: AWS S3, Process Automation, Compliance Analytics

Certification

  • Certified in SQL & Data Visualization
  • Healthcare IT & EMR Workflow Analysis

Timeline

Data Analyst

SMBC Group
01.2023 - Current

Data Analyst

Parexel
06.2020 - 07.2022

Master of Science - Data Science

University of New Haven

Bachelor of Science -

SRM University
Likhita Yakanuru