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 processing. • 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, including debugging Airflow DAGs and Spark jobs on Kubernetes clusters in Azure. • 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 for contracted clients and ad hoc solutions for one-off data requests. • 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 mentorship, ensuring they were equipped to manage and optimize pipeline performance effectively.

• 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 completeness for downstream analytics. • 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 • CS 252: Systems Programming • CS 307: Software Engineering • CS 314: Numerical Methods • CS 334: Computer Graphics • CS 381: Analysis of Algorithms • CS 471: Artificial IntelligenceMath • MA 27101: Honors Multivariate Calculus • MA 301: Proofs and Analysis • MA 351: Elementary Linear Algebra • MA 366: Ordinary Differential Equations • MA 35301: Linear Algebra II • MA 341: Foundations of Analysis • MA 362: Vector Calculus • MA 453: Abstract Algebra • STAT 350: Statistics • PHYS 272: Electricity and Magnetism

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, and streamlining data retrieval processes, resulting in more efficient database operations and reduced redundancy. • 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 ensured timely prioritization and resolution of client requests.

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