Anitha V.

About Anitha V.

Over 7+ years of experience in Data Warehousing and Business Intelligence, with domainexposure across Healthcare, Insurance, and Technology sectors.• Proficient in Snowflake architecture, design, development, and deployment for scalable, securedata solutions.• Experienced in Agile/Scrum, participating in sprint planning, daily stand-ups, and iterativedevelopment.• Hands-on experience with Git for version control and dependency management in teamenvironments.• Strong knowledge of SDLC, QA processes, test case design, and resource scheduling fordata projects.• Specialized in dimensional modeling with Star and Snowflake schemas for robust fact anddimension tables.• Designed ETL pipelines using Informatica to ingest data from flat files, CSVs, and enterprisesystems.• Built Python-based automation frameworks for ETL orchestration and Snowflake dataworkflows.• Implemented Snowflake features like Time Travel, zero-copy cloning, resource monitors,and query tuning for efficient data management.• Integrated AWS services (S3, EC2, Lambda, RDS) to build scalable cloud-native datasolutions.• Developed and scheduled SSIS packages for automating data loads and transformations inSQL Server.• Authored complex stored procedures, views, and T-SQL scripts to support reporting andoperations.• Participated in code reviews, developed unit tests, and collaborated with QA teams to ensurequality.• Conducted and supported UAT by resolving defects and ensuring successful deployments.• Used SQL Profiler and indexing strategies to monitor and optimize long-running queries.• Proactively resolved performance bottlenecks in data pipelines, Snowflake queries, andsource systems.• Managed deployments across DEV, SIT, QA, UAT, and PROD environments, ensuringconsistency.• Provided production support including issue triage, log monitoring, and system maintenance.• Maintained ETL workflows and dashboards, ensuring timely delivery of scheduled data reports.• Ensured data integrity through cleansing, validation, and reconciliation processes.• Collaborated effectively in onsite-offshore models with strong communication and knowledgesharing.• Demonstrated strong interpersonal and collaboration skills, driving project success and teamgrowth.

Experience

1. Snowflake Data Engineer

   CVS Health

   Mar 2023 — Present · US

   Led as Senior Snowflake Developer in a Data Modernization project, building a warehouse for analytics and operations use.Migrated 487 Oracle tables (~125 TB) to Snowflake with 99% less data loss risk, ensuring reliable, consistent access.Designed and implemented ETL pipelines using Informatica PowerCenter to extract, transform, and load data from Oracle, flat files, and legacy systems into Snowflake.Developed ELT pipelines using DBT with reusable models and macros for scalable, enriched, deduplicated transformations.Integrated REST APIs for ingestion of third-party data into Snowflake, enhancing insight accuracy.Created Snowflake external functions to invoke REST APIs for real-time data enrichment and validation.Developed flattened and dimensional data models to support subject areas such as customer and transactions.Modeled operational and incident data to enhance efficiency in downstream analytics and reporting workflows.Implemented Snowflake Streams, Tasks, and Snowpipe for real-time and incremental data ingestion.Built reusable Python validation framework for legacy-to-Snowflake migration, ensuring 99%+ accuracy.Optimized Snowflake performance through clustering, query enhancements, and storage cost reduction.Integrated Snowflake with BI tools like Tableau and Power BI for self-service analytics and executive reporting.Automated data workflows using Control-M and UNIX shell scripting for accurate, timely, and reliable execution.Implemented secure data sharing and access control using RBAC, data masking, and Snowflake’s native features.Applied dynamic data masking and column-level security in Snowflake to protect PII and PHI, ensuring HIPAA compliance.Applied PGP encryption for secure data transmission, ensuring confidentiality of PII/PHI during transfers.Collaborated with cross-functional teams to validate data logic and transformation results against business requirements.

Education

• P.B.Siddhartha college of arts and science

  Master of Computer Applications - MCA, Computer Programming, Specific Applications