Aveesh Kachroo Email & Phone Number

Tampa, Florida, United States

• Designed and Optimized ETL Pipelines: Created, managed, and improved ETL pipelines to ingest CCD data XML files from client SFTPs and FTPs into Snowflake databases, utilizing Azure Data Lake storage for efficient data.
• Developed Client Deliverables Using Airflow and Spark: Utilized Airflow DAGs and Spark to generate deliverables based on CCD data for insurance members. Identified and resolved issues within output file pipelines.
• Designed Data Processing Pipelines: Developed pipelines using Python, Snowflake, and SQL Server to extract customer membership data and generate output files for healthcare data vendors. Implemented dynamic automation.
• Upgraded Data Processing Pipeline: Enhanced the pipeline for a new client implementation by incorporating PGP file decryption capabilities using the GnuPG Python library.
• Managed HIPAA-Compliant ETL Data Loading: Executed and monitored ETL processes for loading data into on-premises SQL Servers while ensuring compliance with HIPAA regulations.
• Trained and Mentored New Team Members: Onboarded and guided 6 new hires and 2 interns, providing training on analyzing and enhancing operational data ETL pipelines. Facilitated their development through hands-on.

• Identified and resolved bugs in SSIS ETL pipeline ensuring lossless data extraction, transformation, and loading to production environment. Ingested 200-day backlog of unprocessed HIE files, ensuring data accuracy and.
• Developed Power BI Dashboards: Created detailed operational data visualization reports in Power BI to effectively communicate data processing insights to upper management.
• Consolidated and supplemented Source-to-Target mapping documents across data processing environment to ensure consistency, accuracy, and alignment with business requirements.

West Lafayette, IN

• Relevant courseworkComputer Science
• CS 180: Problem Solving and Object-Oriented Programming
• CS 182: Discrete Mathematics
• CS 240: Programming in C
• CS 250: Computer Architecture
• CS 251: Data Structures and Algorithms

Lafayette, Indiana Area

Reston

• Created a Data Analysis Application: Developed an application using Python and SQL to optimize database performance by improving data accessibility. Implemented techniques for removing duplicate data, data cleaning.
• Streamlined Ticket Management System: Organized and optimized the ticket management system, creating client-specific slot plans to facilitate future development and project scheduling. Improved system efficiency and.

IT Intern: Supervised the development of web services and projects, assisting in design, implementation, and testing phases.

Bachelor Of Science - Bs, Mathematics And Computer Science

High School Diploma