Sowmya Varanganti
@sowmyavaranganti
Experienced Data Analyst specializing in healthcare and finance insights.
United StatesWhat I'm looking for
I am an experienced Data Analyst with over 4 years of expertise in the healthcare, finance, and investment sectors. My passion lies in transforming complex datasets into actionable insights that drive strategic decision-making. I have a proven track record of designing and maintaining robust ETL pipelines using Python and SQL, ensuring seamless data integration and transformation across various data sources.
Throughout my career, I have developed interactive dashboards and executive-level reports using tools like Power BI and Tableau, enabling stakeholders to visualize key performance indicators and operational metrics effectively. My hands-on experience with relational databases and cloud platforms has equipped me with the skills to handle scalable and secure data operations. I thrive in collaborative environments, leveraging Agile methodologies to manage cross-functional projects and deliver impactful results.
Experience
Work history, roles, and key accomplishments
Data Analyst
CVS Health
Aug 2023 - Present (1 year 10 months)
Retrieved, cleaned, and integrated over 10 million records of medical claims, pharmacy transactions, and encounter data from Epic EHR using advanced SQL Server queries, facilitating in-depth analysis of chronic conditions. Automated data preprocessing pipelines in Python (pandas, NumPy) to standardize CPT, ICD-10, and NDC codes, clean demographic fields, and validate medication adherence, reducing
Data Analyst
Capgemini
Jul 2019 - Jul 2022 (3 years)
Designed Python-based ETL pipelines to ingest and clean over 15 million multi-asset class records from custodial systems, leveraging AWS Glue and S3 for scalable ingestion and storage, enhancing portfolio performance analysis accuracy by 35%. Engineered SQL-based data marts to integrate client holdings, transaction history, and benchmark indices, ensuring 99.9% precision in financial statement gen
Education
Degrees, certifications, and relevant coursework
UTUniversity of North Texas
Master of Science, Data Science
Focused on advanced data analysis techniques, including statistical modeling, machine learning algorithms, and data visualization. Gained expertise in extracting actionable insights from complex datasets for strategic decision-making.
Chaitanya Bharathi Institute of Technology
Bachelor of Engineering, Mechanical Engineering
Studied core principles of mechanical engineering, including thermodynamics, fluid mechanics, and material science. Developed foundational knowledge in design, analysis, and manufacturing processes.
Availability
Location
United StatesAuthorized to work in
Job categories
Skills
Interested in hiring Sowmya?
You can contact Sowmya and 90k+ other talented remote workers on Himalayas.
Message SowmyaFind your dream job
Sign up now and join over 85,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
