Sowjanya B
Data Analyst |Business intelligence developer | Strong Foundation in SQL ,Python and Machine Learning
- Role
- Data Analyst at Samsung Electronics
- Location
- Danville, CA, US
- LinkedIn followers
- 500 followers
Experience
Data Analyst
Mar 2025 — Present · US
Built 25+ AWS QuickSight dashboards with advanced calculated fields, parameters, ML-powered anomaly detection, and drill-downs, enabling real-time insights for 500+ users. Optimized SPICE datasets through incremental refresh and aggregation, reducing refresh times by 40%. • Designed AWS data pipeline architecture using S3 (Parquet/ORC with partitioning), Glue ETL jobs, and Redshift, processing 2TB+ daily. Developed 30+ Glue ETL jobs in Python/PySpark with job bookmarks, schema evolution, and error recovery. • Created Lambda functions for event-driven data processing, API integrations, and real-time validation. Optimized Redshift performance through distribution/sort keys, VACUUM/ANALYZE, reducing query time by 50%. • Built serverless analytics with Athena for S3 data lake querying, implementing partition pruning to reduce costs by 35%. Implemented comprehensive SQL query optimization using execution plan analysis and index tuning, improving performance by 60%. • Developed cloud data warehouse using DBT models (staging/intermediate/mart) with automated quality tests. Created incremental pipelines with MERGE logic and partition strategies, reducing daily load time by 30%. • Built Azure Data Factory pipelines orchestrating REST APIs, S3, and internal systems into Snowflake with error handling and monitoring. Implemented row-level security in Power BI and QuickSight for users. • Designed Tableau dashboards with LOD expressions and parameter actions, replacing manual Excel reporting (40% time reduction). Developed churn prediction dashboards in Power BI, improving retention by 12%. • Optimized SQL queries and BI datasets, reducing Snowflake compute costs by 20%. Automated KPIs using Power Query, SQL, and VBA. Built Adobe Analytics dashboards for user engagement tracking.
Education
University of the Pacific
Master's degree, BUSINESS ANALYTICS
2023 — 2024
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.