ETL Developer at Texas State University

Built and enhanced ETL pipelines integrating over 20 academic datasets into a centralized data warehouse supporting 2,500+ daily queries. Led data migration of pipelines from on-prem Oracle and SQL Server to Azure cloud architecture, improving data availability by 3 hours. Implemented data reconciliation frameworks using Python and SQL, reducing manual checking efforts by over 40 staff hours monthly, and established SCD Type 2 dimensional models in Snowflake for accurate tracking of student records. Automated data quality monitoring using dbt and SQL, improving reporting accuracy for over 30 departments. Collaborated on embedding data security measures for sensitive student data compliant with FERPA. Streamlined batch scheduling and optimized UNIX shell scripts, reducing delays in critical reporting processes from 6 hours to 2.

ETL Developer at Cognizant Technology Solutions

Redesigned ETL architecture using Informatica PowerCenter and Azure Data Factory to consolidate healthcare data for compliance reporting. Developed workflows integrating HL7, FHIR, and flat file feeds from partner hospitals into a secure cloud data lake, enhancing rapid access to critical healthcare datasets. Created data masking and encryption frameworks to safeguard PHI/PII following HIPAA regulations. Built SCD Type 2 dimensional models in Snowflake supporting patient demographics and treatment histories for longitudinal analysis. Programmed advanced data quality checks detecting inconsistencies across multiple sources to strengthen federal and state reporting readiness. Migrated high-volume ETL workloads from on-prem DB2 and Oracle to Azure SQL Database, improving query performance and batch processing efficiency.

ETL Engineer at Smartnerd Home Automation Solutions

Led migration of an on-premise Oracle data warehouse to AWS Redshift, improving query performance by 48%. Designed and deployed ETL pipelines using AWS Glue and PySpark to process daily healthcare transactions, reducing latency by 2 hours. Automated ingestion workflows for real-time CSV and JSON data from S3, improving data availability timelines by 70%. Constructed optimized ETL workflows in Informatica with pushdown optimization, improving pipeline performance by 40%. Developed Python-based data validation scripts, eliminating 75% of manual QA effort and accelerating production deployments.

Software Engineer at CVS Health

Developed REST APIs to integrate patient onboarding with insurance verification and eligibility checks, handling over 2,000 patient enrollments weekly. Redesigned a patient prescription management system using Java 17, Spring Boot, and Hibernate, automating medication scheduling and refill tracking, and revamped the clinician dashboard with React.js, TypeScript, and Tailwind CSS to improve patient interactions. Implemented secure authentication with Spring Security and JWT for HIPAA-compliant access, integrated Apache Kafka for real-time event streaming across microservices, and established CI/CD pipelines with GitHub Actions, AWS CodePipeline, and Docker for weekly updates.

Software Engineer at Hexaware Technologies

Designed backend services for real-time payments and fund transfer platform using Spring Boot and PostgreSQL, processing over 1.2 million transactions monthly. Engineered secure access control and user authorization modules with Hibernate and Spring Security. Architected web dashboards for loan/investment analytics using JavaScript/HTML/CSS, reducing processing times. Implemented automated batch reconciliation with Spring Batch and containerized EMI scheduling microservices using Docker and Kubernetes. Deployed RESTful APIs on AWS EC2 and managed document uploads via S3 for onboarding workflows.