Lead Data Engineer

Leapfrog Technology, Inc02/2023 - Present

• Architect and optimize ETL pipelines for healthcare ERA data processing
• Design and deploy scalable data infrastructure supporting analytics for healthcare claims processing
• Develop Python-based data transformations for financial reconciliation workflows
• Engineer Amazon QuickSight dashboards providing visibility into pipeline health and business metrics
• Lead root cause analysis on production incidents and implement preventative measures

Senior Data Engineer

LIS Nepal08/2021 - 02/2023

• Architected scalable ETL solution ingesting POSLog data from retail APIs into AWS datalake
• Designed serverless architecture using AWS Lambda and S3 for data processing and analytics
• Engineered data warehouse implementation supporting analytics workflows with optimized query performance
• Developed robust data validation frameworks for upstream data quality assurance
• Delivered Oracle-to-Snowflake migration utilities for legacy data system consolidation

Data Engineer

eSewa Fonepay11/2018 - 08/2021

• Optimized SQL queries and developed stored procedures to improve report generation performance for financial reporting workflows
• Managed MySQL database infrastructure and implemented automation workflows for data management and analytics
• Implemented MySQL replication topologies (master-slave and multi-master configurations) achieving high availability for payment systems
• Built automated backup and disaster recovery systems protecting critical financial data across distributed infrastructure
• Developed Python and shell automation scripts for scheduled report generation delivering insights to stakeholders

mailerpy - Open-source Python library enabling scalable, reliable email workflows - abstracts SMTP complexity and improves email delivery reliability

Churn Analysis Pipeline - End-to-end ETL pipeline extracting customer records from MySQL into Hive, computing churn metrics, and exposing APIs for analytics and visualization