Sravani Kothakota
Data Analyst with 5+ years of experience delivering data-driven insights and governance across finance, healthcare, and technology sectors, proficient in Snowflake, SQL, Python, and Power BI.
Data Analyst with 5+ years of experience delivering data-driven insights across financial services, healthcare, consulting, and SaaS environments. Skilled in SQL, Python, and advanced analytics for analyzing large datasets, performing data validation, and improving data accuracy and reporting reliability. Experienced in building scalable ETL pipelines, data models, and KPI dashboards using Snowflake, Databricks, AWS, Azure, and Power BI. Proven ability to resolve data quality issues, automate reconciliation processes, and optimize data pipelines to reduce reporting latency and improve operational efficiency. Strong expertise in data warehousing, statistical analysis, anomaly detection, and root cause analysis, with hands-on experience supporting SOX and HIPAA-compliant analytics environments. Adept at translating complex business requirements into actionable insights through executive dashboards, automated reporting solutions, and governed data models.
[email protected] +1 913-601-5244
Data Analyst
State Street · USA
July 2024 - Present
- Analyzed large-scale financial transactions and portfolio datasets using Snowflake SQL and Spark SQL,
- reducing reconciliation breaks and KPI mismatches by 42% across enterprise reports.
- Performed end-to-end data lineage analysis across AWS S3 ingestion, Azure Data Factory pipelines,
- Databricks transformations, and Power BI semantic models, eliminating 38% of silent data failures.
- Built SQL and Python (Pandas, NumPy) validation frameworks enforcing reconciliation, null thresholds, and
- duplicate detection, preventing 90% of downstream reporting defects.
- Applied trend analysis and historical distribution comparisons to identify abnormal KPI behavior, enabling
- anomaly detection 2–3 days earlier than traditional controls.
- Developed and stabilized Power BI executive dashboards using governed semantic models and DAX,
- reducing refresh failures by 38% and improving stakeholder trust.
- Optimized Snowflake and Databricks transformations through query refactoring and warehouse right-
- sizing, improving performance by 45% and lowering cloud costs by 22%.
- Enforced SOX-aligned data governance controls, including role-based access, data masking, and lineage
- documentation, maintaining 100% audit readiness.
Business Data Analyst
Molina Healthcare · USA
Sep 2023 - Jul 2024
- Investigated enterprise claims, enrollment, and provider data integrity issues, reducing duplicate
- numbers, missing encounters, and authorization mismatches by 40%, directly improving operational KPIs.
- Traced end-to-end healthcare data flows across ingestion, ETL, and reporting layers, eliminating data loss
- points impacting 32% of utilization and care management metrics.
- Designed structured data quality validation rules detecting authorization inconsistencies and claim
- mismatches before executive reporting consumption, preventing 30% of downstream reporting errors.
- Automated SQL and Python reconciliation workflows, replacing manual checks and saving 15+ hours per
- week across analytics teams.
- Standardized KPI definitions across enrollment, utilization, and care management, reducing conflicting
- metrics by 28% and improving cross-team alignment.
- Accelerated ETL workflows and SQL transformations, improving data availability timelines by 35% and
- reducing reporting latency by 45%.
- Delivered HIPAA-compliant Power BI dashboards tracking denial rates, turnaround times, and utilization
- trends, increasing leadership visibility by 30% while maintaining 100% audit readiness.
Data Analyst
Deloitte · India
Aug 2021 - Jul 2024
- Supported multi-client analytics initiatives addressing fragmented reporting and inconsistent KPIs,
- reducing data preparation effort by 50% across client engagements.
- Conducted deep data discovery across heterogeneous client systems, identifying refresh delays and
- transformation defects impacting 25+ enterprise reports.
- Converted business requirement documents (BRDs) into governed data models and standardized metrics,
- lowering KPI inconsistencies by 20%.
- Built scalable SQL and Python transformation pipelines across Snowflake, Databricks, and AWS,
- processing millions of records daily for client analytics.
- Introduced early anomaly detection and schema change monitoring, preventing 30% of recurring
- production reporting failures.
- Optimized complex SQL logic and joins, improving dashboard refresh performance by 60% and supporting
- faster decision cycles.
- Delivered executive-ready Power BI and Tableau dashboards and partnered with consulting teams to
- translate insights into actions, contributing to 12% revenue growth and 30% productivity improvement
- for client portfolios.
Data Analyst
Open Text · India
Mar 2020 - Jul 2021
- Analyzed enterprise reporting failures across product, finance, and operations datasets, improving KPI
- accuracy by 35% across 20+ recurring reports through governed metric alignment.
- Translated business requirements into standardized data models and metric definitions, reducing
- conflicting KPIs by 28% and improving cross-team reporting consistency.
- Built and optimized Azure Data Factory ETL pipelines using SQL and Python for batch and incremental
- processing, reducing data processing cycles by 50% and improving data availability SLAs by 40%.
- Implemented data quality and reconciliation frameworks (row counts, null thresholds, duplicate
- detection), preventing 30% of downstream reporting defects and improving pipeline reliability.
- Automated reporting workflows and delivered Power BI and Matplotlib dashboards, cutting 12–15 hours
- per week of manual effort while improving operational KPI visibility by 40%.
Skills
Data Analysis & Programming: SQL (T-SQLPL/SQLPostgreSQLMySQLSnowflake SQLSpark SQL)Python (PandasNumPyMatplotlibSeaborn)PySparkRJupyter NotebookVS CodeBusiness Intelligence & Reporting: Power BITableauExcel (Power QueryPivotTablesMacros)SSRSKPI DashboardsExecutive ReportingSemantic ModelsDAXPaginated ReportsData Platforms & Warehousing: SnowflakeDatabricksAmazon RedshiftOracleMongoDBSQL ServerBigQueryAzure Synapse AnalyticsETL / ELT & Data Pipelines: Azure Data FactorySSISTalendAirflowAlteryxdbtBatch & Incremental ProcessingData OrchestrationPipeline MonitoringCloud Technologies: AWS (S3RedshiftGlueQuickSight)Microsoft Azure (ADFADLSSynapse)Google BigQueryCloud Cost OptimizationAnalytics & Methods: Data Modeling (Star & Snowflake Schemas)Statistical AnalysisForecastingTrend AnalysisData ValidationReconciliationAnomaly DetectionRoot Cause AnalysisGovernance & Compliance: HIPAASOXGDPRData Quality ControlsAudit SupportData LineageAccess ControlsMetadata ManagementTools & Collaboration: JIRAConfluenceGitGitHubServiceNowSAP ERPCI/CD PipelinesDocumentation Standards
Master’s in computer science
Saint Louis University · Missouri, USA
Aug 2023 - May 2024