Open to opportunities

Roshan Gautam

@roshangautam

ETL Developer and Data Integration Engineer building reliable SSIS and Python pipelines for enterprise Oracle/MSSQL data.

Nepal

Message

What I'm looking for

I’m looking for remote or hybrid ETL / Data Engineering roles where I can build production SSIS and Python pipelines, optimize Oracle/MSSQL SQL performance, and own reliable reporting and data integration end-to-end.

I’m an ETL Developer and Data Integration Engineer with 1+ year of production experience designing, building, and maintaining enterprise-scale ETL pipelines for a Tier-1 Nepali commercial bank. I work daily with SSIS, Oracle, MSSQL, and Python inside a live core banking environment.

I’m an expert in SSIS pipeline architecture, including incremental/delta loads, watermark-based extraction, error row redirection, audit logging, and checkpoint-based restartability across Oracle and MSSQL source systems. I also build Python ETL pipelines with pandas, SQLAlchemy, pyodbc, and cx_Oracle, using chunked reads, upsert logic, schema validation, structured logging, and APScheduler-based orchestration.

I complement ETL with strong SQL performance tuning (Oracle PL/SQL and MSSQL T-SQL) and reporting ownership—building and maintaining 10–25 SSRS reports for internal teams and supporting Finacle CBS. I’ve also automated Finacle workstation provisioning across 300 branches to eliminate manual setup and configuration drift.

Experience

Work history, roles, and key accomplishments

Current

ETL Developer & BI

Current

Laxmi Sunrise Bank Ltd.

Apr 2024 - Present (2 years 2 months)

Architected and maintained 30+ production SSIS ETL pipelines integrating Oracle CBS, MSSQL, and flat-file sources with restart/checkpoint logic, audit logging, and error row redirection. Built and tuned incremental/delta loads using watermark tracking to reduce ETL runtime and created 10–25 SSRS reports; also automated Finacle workstation provisioning across 300 branches to cut setup from 20+ minu

SSIS Oracle PL SQL T SQL Watermark Incremental Loads SQLAlchemy

Current

Full-Stack Developer

Current

DStudios Nepal

Aug 2022 - Present (3 years 10 months)

Designed relational database schemas and wrote SQL for application reporting in MySQL using Sequelize ORM. Developed end-to-end web and mobile applications from requirements to deployment using React, Node.js/Express, Laravel, and React Native.

React Laravel React Native MySQL Sequelize SQL Database Schema Design

Web Developer Intern

Nepal Electricity Authority

Jan 2022 - Jul 2022 (6 months)

Built the front-end for Nepal Electricity Authority’s internal intranet and redesigned sections of the public-facing website. Collaborated with senior developers and stakeholders through the full delivery cycle.

Front End Developer Intranet Development Collaboration With Senior Stakeholders

Education

Degrees, certifications, and relevant coursework

University of Northampton

B.Sc. (Honours), Computing (Software Engineering)

Grade: Second Class Upper Division (2:1)

Activities and societies: Relevant coursework: Database Systems, Software Engineering, Machine Learning, Web Development.

Completed a B.Sc. (Honours) in Computing (Software Engineering) at the University of Northampton, graduating in 2024 with a Second Class Upper Division (2:1). Coursework included Database Systems, Software Engineering, Machine Learning, and Web Development.