Data Analytics Interim Resume Title: Data Analyst with Banking &

SUSMITHA KALLI

P: 572-***-**** E: **************@*****.*** www.linkedin.com/in/susmithakalli

PROFESSIONAL SUMMARY

Data Analyst with 3+ years of experience delivering analytics solutions across banking and healthcare domains. Strong expertise in SQL, Python, Power BI, Tableau, Snowflake, and Azure, with proven ability to analyze large datasets, automate reporting, build dashboards, and generate actionable business insights. Experienced in data modeling, ETL pipelines, and stakeholder collaboration.

TECHNICAL SKILLS

Data Analytics & BI:

Power BI, Tableau, Advanced Excel (Pivot Tables, Power Query, DAX), KPI Dashboards Programming & Analysis:

Python (Pandas, NumPy, Matplotlib, Seaborn), SQL (Joins, CTEs, Window Functions) Databases & Cloud:

Snowflake, SQL Server, MySQL, PostgreSQL, AWS S3, Azure Data Lake Data Engineering:

ETL Pipelines, Azure Data Factory, Snowpipe, SSIS, Airflow (Basic) Data Modeling & Quality:

Star Schema, Snowflake Schema, Data Cleaning, Data Validation, Feature Engineering Tools & Collaboration:

Git, GitHub, Jira, Confluence, Jupyter Notebook

PROFESSIONAL EXPERIENCE

Data Analyst – Fifth Third Bank, Kentwood, MI January 2025 – Present Project: Customer Transaction Behavior Analytics (Banking Analytics) Analyzed customer transaction behavior using SQL Server and Python to identify trends in deposits, withdrawals, and digital banking usage.

Built automated Power BI dashboards tracking loan delinquencies, NPAs, fraud indicators, and account growth used by senior leadership.

Developed ETL pipelines integrating deposits, credit card, lending, and digital channel data. Designed Star and Snowflake schemas to support scalable analytics and reporting. Implemented fraud detection indicators by identifying transaction anomalies, improving monitoring accuracy.

Automated monthly reporting using Python, reducing reporting cycle time by 50%. Improved data quality by resolving mismatched transaction codes and ETL inconsistencies. Collaborated with business and compliance teams to translate regulatory requirements into KPIs.

Data Analyst – Elevance Health, Atlanta, GA May 2024 – December 2024 Project: Claims Insights Modernization (Healthcare Analytics)

Analyzed large-scale claims datasets using SQL (Window Functions, Joins, CTEs) supporting adjudication insights.

Built Snowflake data marts for rejection patterns, prior authorization delays, and provider performance.

Developed Tableau dashboards tracking claim turnaround times, denial rates, and payer/provider trends.

Applied Python Pandas for data profiling and anomaly detection of inconsistent claim codes.

Developed ETL data flows using Azure Data Factory to standardize claims.

Reduced dashboard refresh time by 40% through performance tuning.

Automated scheduled reporting using Tableau Server and Power BI Gateway.

Built regression-based predictive models for claim denials.

Designed data quality rules to detect duplicates, invalid NPI codes, and missing values.

Integrated ICD-10 and CPT code sets into analytical layers with SME collaboration.

Presented insights to leadership, reducing operational rework by 18%. Environment: Tableau, Snowflake, SQL, Python, Azure Data Factory, Excel, Healthcare Data, Confluence, JIRA

Data Analyst – Cyient, Hyderabad, India June 2021 – July 2023 Project: Enterprise Data Analytics Platform (Healthcare Analytics)

Developed data analytics workflows using Python (Pandas, NumPy) to clean and process large healthcare datasets.

Wrote optimized SQL queries analyzing provider performance, claim rejections, disease categories, and appointments.

Built interactive Power BI dashboards for KPIs like LOS, readmission rates, turnaround time, and referrals.

Implemented data validation and transformation checks across ETL pipelines.

Identified root-cause issues in datasets by reconciling mismatches across multiple systems.

Conducted statistical analysis using Matplotlib/Seaborn for patient demographic trends.

Automated daily operational reporting using Python scripts, saving hours of manual effort.

Gathered requirements and translated them into analytics dashboards.

Designed compliance and efficiency KPIs tailored to healthcare operations.

Prepared processed datasets in SQL Server for downstream teams.

Documented workflows, logic, and table definitions in Confluence. Environment: Python, SQL Server, Power BI, Excel, GitHub, JIRA, Snowflake, Healthcare Data

EDUCATION

Master of Science in Computer Science, Campbellsville University — Jan 2024 to Aug 2025

Bachelor of Technology in Computer Science Engineering, RISE Krishna Sai Group of Institutions — June 2019 to May 2023

CERTIFICATIONS

Google Data Analytics

Advanced Microsoft Power BI

Generative AI: Prompt Engineering

Contact this candidate