Keerthana C

Experience

1. Data Analyst

   CVS Health

   Dec 2024 — Present · US

   Designed and improved data models by creating reusable constraints, documenting data flows, ER diagrams, and data dictionaries while maintaining mapping documents and metadata to support ETL and application development. Built Python-based ETL pipelines to extract, clean, and load large datasets into AWS Redshift, ensuring faster, more accurate reporting and analytics for business and consulting teams. Developed interactive dashboards in Tableau and Power BI to visualize key metrics, complaint trends, and CAPA performance, enabling leadership to make timely, data-driven decisions. Created automated workflows using Azure Data Factory and Alteryx to streamline data cleaning, validation, and reporting tasks, significantly reducing manual effort and process time. Wrote and optimized complex SQL queries and stored procedures to extract insights, manage indexes, and synchronize staging, UAT, and production databases for consistent data quality. Analyzed and reconciled data across multiple environments, reverse-engineered legacy databases, and maintained unified data models to ensure system-wide consistency and accuracy. Utilized Python and R for data analysis, anomaly detection, and exploratory analytics to uncover trends, improve data integrity, and support advanced decision-making. Automated FDA QSR-compliant reporting pipelines integrating complaint, CAPA, and risk data, achieving over 99% data accuracy and establishing traceable audit logs for ISO and FDA inspections. Leveraged tools like Spark, PySpark, AWS Glue, Airflow, Kafka, Snowflake, Terraform, Jenkins, and Delta Lake to orchestrate scalable data workflows, automate pipelines, and monitor performance.

Education

• University of Memphis

  Master's degree, Management Information Systems, General