Open to opportunities

Yogesh Roy

@yogeshroy

Message

AWS-certified Data Engineer—I’ve built SQL ETL pipelines and automated financial reconciliation systems.

Nepal

Message

What I'm looking for

I’m open to immediate remote engagement where I can design AWS-based ETL pipelines, strengthen data quality and reconciliation, and help stakeholders with dependable Power BI dashboards—building scalable, well-documented data solutions that reduce manual work.

I’m an AWS-certified Data Engineer focused on designing SQL-based ETL pipelines and turning messy financial/retail data into reliable, automated reporting. In my current role, I build stored procedures, views, and ETL processes that handle millions of transactions while implementing vendor matching and duplicate detection using CTEs, window functions, and dynamic SQL—cutting manual effort by 40%+.

I also bring a strong audit-and-reconciliation mindset from roles as a Recovery Audit Analyst, where I reduced manual review time by 30%+ by building SQL/Excel reconciliation reports and delivering recovery strategies to senior management. From there, I expanded into applied analytics through a data science internship (85%+ accuracy in diabetes prediction) and I’m continuing to upskill on modern orchestration and transformation tools like Apache Airflow and dbt Core.

Experience

Work history, roles, and key accomplishments

Current

Associate Solution Architect

Current

FlexTecs

Feb 2026 - Present (3 months)

Designed and optimized SQL stored procedures, views, and ETL pipelines processing millions of financial transactions for major retail clients. Built automated vendor matching and duplicate detection tools, reducing manual effort by 40%+, and supported Power BI reporting through validated relational data models.

SQL Stored Procedures ETL Data Validation Window Functions Power BI

Recovery Audit Analyst

FlexTecs

Dec 2023 - Jan 2026 (2 years 1 month)

Audited financial records across retail client accounts to identify billing discrepancies, duplicate payments, and revenue leakage. Built SQL/Excel reconciliation reports that reduced manual review time by 30%+ and informed recovery strategies delivered to senior management.

Financial Reconciliations SQL Excel Duplicate Payment Detection Reporting Data Validation Audit Support

Data Science Intern

HCL Technologies

Feb 2025 - Jun 2025 (4 months)

Built diabetes prediction and credit risk analysis systems using Python and machine learning workflows, achieving 85%+ accuracy for the diabetes model. Developed data processing, modeling, and visualization steps with scikit-learn and Pandas.

Python scikit learn Pandas Matplotlib Machine Learning Diabetes Prediction Credit Risk Analysis Model Evaluation (ROC AUC PR Confusion Matrix)

Operations Executive

Innovative Investment Group (IIG Nepal)

Apr 2023 - Dec 2023 (8 months)

Managed end-to-end freight forwarding operations, including shipment tracking, vendor coordination, customs documentation, and international logistics. Streamlined workflows with international shipping partners to ensure regulatory compliance and timely delivery.

Freight forwarding Shipment Tracking Vendor coordination Customs Documents International Logistics Regulatory Compliance Process Improvement

Customer Service Representative

WorldLink Communications

Feb 2022 - Apr 2023 (1 year 2 months)

Handled 50+ daily customer interactions for a major ISP, resolving technical and billing queries with a first-call resolution focus. Provided timely support and helped ensure accurate, reliable customer outcomes.

Customer Service Technical Troubleshooting Billing Support First Call Resolution