Data ANalyst - Susmitha katigala

Susmitha Kagitala

Virginia

PROFESSIONAL SUMMARY

Senior Data Analyst with 8 years of experience designing scalable data solutions, developing SQL-based analytics, automating ETL workflows, and delivering business intelligence solutions. Proficient in SQL Server, Tableau, Databricks, and SSIS with expertise in reporting automation, data quality, production support, and stakeholder collaboration. Proven success in improving processing performance by 30%, reducing manual effort by 40%, and delivering enterprise reporting solutions in regulated environments.

PROFESSIONAL EXPERIENCE

AARP

Data Analyst SQL Developer 2017 - Present

Project: Provider Data Processing & Reporting Platform

Technologies: SQL Server, SSIS, Tableau, Python, SFTP, ELT

• Developed and optimized complex SQL queries, stored procedures, and views supporting provider data processing, reporting, and outbound file generation.

• Automated ETL workflows and outbound file generation processes supporting multiple schedules and downstream integrations.

• Maintained and extended existing Python-based automation processes by modifying SQL logic and workflows to support onboarding of new providers and business requirements.

• Collaborated directly with business stakeholders to gather reporting requirements, define data attributes, and deliver customized data extracts supporting business initiatives.

• Designed and developed interactive Tableau dashboards to track operational KPIs and business performance, enabling stakeholders to monitor trends through Mom, QoQ, and YoY analysis.

• Delivered urgent business requests, including generating two-year historical data extracts containing approximately 50 attributes within aggressive timelines while maintaining data accuracy.

• Investigated and resolved production issues related to outbound files, fixed-width formatting, and data discrepancies to maintain delivery commitments and stakeholder confidence.

• Improved data quality by identifying inconsistencies across provider files, transformations, and business rules, ensuring reliable reporting outputs.

• Developed and executed SQL-based test cases to validate business rules and transformations across provider onboarding workflows.

• Automated test case reporting processes by replacing manual Excel-based tracking with automated email notifications displaying pass/fail validation outcomes.

• Mentored interns and junior team members by onboarding them to project processes, reviewing SQL queries and Tableau dashboards, and providing technical guidance.

• Created detailed documentation and conducted knowledge transfer sessions supporting project transitions and reducing dependency on individual contributors.

• Coordinated with internal teams and external vendors to ensure timely file reception, processing, and accurate data availability.

Innovation Initiative: AI – Assisted Address Matching Proof Of Concept

Technologies: Snowflake, SQL, Vector-Based Similarity Matching

• Participated in a proof-of-concept initiative evaluating AI-assisted address matching techniques using vector-based similarity approaches.

• Collaborated in designing the overall evaluation strategy and enhancing existing rule-based matching approaches.

• Contributed SQL analysis supporting comparison of matching outcomes across approximately 36 million records.

• Evaluated match performance between existing and proposed approaches, identifying a 2% improvement in address matching rates.

• Presented findings and recommendations to leadership; implementation was ultimately deferred due to security and compliance considerations.

Project: Databricks Modernization & Reporting Automation

Technologies: Databricks, Tableau Cloud, SQL

• Optimized Databricks ETL workflows by simplifying complex transformations and reducing unnecessary table dependencies, improving processing performance by approximately 30%.

• Developed and maintained Databricks notebooks supporting new vendor onboarding and integrated them into existing workflows for scheduled execution.

• Automated Tableau dashboard refreshes by publishing Databricks data sources to Tableau Cloud and configuring scheduled extract refreshes and email snapshot distributions, reducing manual reporting effort by 40%.

• Designed and developed Tableau dashboards providing leadership visibility into customer data quality trends, address completeness, and year-over-year comparisons.

• Conducted impact analysis for provider layout changes, business rule modifications, and data model updates to assess downstream impacts and maintain process integrity.

• Proposed alternative processing approaches when provider layouts lacked critical information, enabling successful onboarding despite incomplete requirements.

• Participated in requirements discussions with stakeholders to translate business needs into scalable reporting and analytics solutions.

TECHNICAL SKILLS

Programming Languages: SQL, Python

Databases: SQL Server, Snowflake (POC)

Data Processing & ETL: Databricks, SSIS, ETL Development

Visualization & Reporting: Tableau, Tableau Cloud

Data Quality & Validation: Test Case development, Root Cause Analysis, Data Profiling

Business Skills: Requirements Gathering, Stakeholder Management, Documentation, Knowledge Transfer.

EDUCATION

University of North America, Virginia

Master of Science in Data Analyst 2020-2021

Marist College, New York

Master of Science in Information Systems 2015-2016

Contact this candidate