Umang Dhakal
Lead Data Engineer
Suan Luang
Summary
Results-driven Lead Data Engineer with 9+ years of expertise in designing scalable data ecosystems, leading cloud migrations, and enabling data-driven decision-making for companies. Proven track record in unifying multinational datasets post-merger, optimizing ETL pipelines, and delivering actionable insights through BI tools. Experienced in leading cross-functional teams and automating workflows to drive efficiency and productivity. Committed to leveraging technical proficiency and strategic thinking to deliver innovative solutions that meet business objectives.
Overview
9
9
years of professional experience
3
3
Languages
Work History
Lead Data Engineer
CP AXTRA PUBLIC COMPANY LIMITED
09.2021 - Current
- Spearheaded the redesign of legacy ETL pipelines using Azure Data Factory for orchestration and Azure Databricks for distributed processing, reducing deployment and data processing costs by 60% while improving data availability.
- Unified multinational datasets post-merger across Makro and Lotuss’s, enabling seamless cross-company analytics unlocking significant cross-selling opportunities.
- Led the migration of on-premises processes to Azure Cloud, utilizing Databricks for Spark-based transformations and Delta Lake for scalable storage. Streamlined pipeline architecture reduced runtime by 62% and cut operational overhead by 45%.
- Designed, modeled and managed end-to-end data engineering processes and designed automated reconciliation processes, ensuring 99.9% data accuracy for business-critical reporting
- Collaborated with business stakeholders to understand requirements and deliver meaningful insights via Power BI dashboards
- Enhanced data security by implementing PGP encryption and SHA-256 hashing with salting in the pipelines, ensuring secure inter-cloud data transfers (Azure-to-GCP) and compliance with GDPR and CCPA.
- Worked closely with data scientists, analysts, and machine learning teams to provide clean, accessible data for advanced analytics
- Developed in-house solutions for data governance, ensuring data integrity, compliance, and security
On-shore Technical Consultant
LIS Nepal Pvt. Ltd.
03.2018 - 03.2020
- Provided expert guidance and technical leadership as an Onshore Technical Consultant for Siam Makro Pvt. Ltd., Thailand, integrating Oracle BI into business strategy, driving growth, and enabling data-driven decision-making.
- Redesigned nightly batch processes, improving stability and reducing runtime by 42%, enabling business teams to access daily and critical reports 4+ hours earlier daily. Optimized 100+ operational and analytical reports, reducing generation time from 15+ minutes to under 2 minutes.
- Optimized 100+ operational and analytical reports, reducing generation time from 15+ minutes to under 2 minutes.
- Engineered unified data integration frameworks to support international business scaling, harmonizing compliance and reporting across 4 new markets
- Implemented automated workflows for purging/archiving, customer and product reclassification etc.
- Developed automated legal audit reports, ensuring 100% compliance accuracy and reducing audit preparation time by 50%
- Migrated Oracle Data Warehouse (Retail Analytics) to support company expansion, implementing customizations for tax compliance and country-specific regulations
Senior Software Engineer
LIS Nepal Pvt. Ltd.
07.2018 - 09.2021
- Led a team of 5+ data engineers in migrating Oracle systems to Oracle Cloud ADW for a retail client, improving scalability and reducing operational costs
- Implemented data warehousing solutions for multiple companies, tailoring systems to meet diverse business requirements and enabling efficient data storage, processing, and analytics
- Acted as a key problem-solver and trusted advisor for the Managed Services team, providing guidance and implementing customized ETL solutions to address complex issues, despite not being an active member of their projects
- Provided technical leadership and mentorship to junior team members, guiding them in best practices, design principles, and technical skills related to Oracle BI and Data Warehousing
Software Engineer
LIS Nepal Pvt. Ltd.
09.2016 - 06.2018
- Provided support on various Managed Services tasks, including serving as On-Call Support personnel to address business issues related to data and reports
- Developed in-house reporting solutions using Oracle OBIEE, including an Employee Timesheet system that enabled the HR department to efficiently track and manage employee work hours
- Developed shell scripts to facilitate ETL processes from various sources into an on-premises Oracle Data Warehouse
- Conducted POCs for various ETL tools as part of internal projects to assess compatibility, differences, and feasibility for client requirements
Education
Bachelors - Computer Science
Kathmandu University
01.2011 - 1 2015
Skills
Apache Spark
Databricks
Azure Cloud Services
Oracle Autonomous Data Warehouse (ADW)
Azure Data Factory
Oracle Data Integrator (ODI)
ETL Development
Data Modeling
Database design
Performance tuning
SQL
Python Programming
Pyspark
Pandas
Data Analytics
Oracle Analytical Reporting Tools - OBIEE/ BIP
Oracle Retail Analytics (DW)
Data Quality Assurance
Data quality assurance
Refrences
Available upon request.
Timeline
Lead Data Engineer
CP AXTRA PUBLIC COMPANY LIMITED
09.2021 - Current
Senior Software Engineer
LIS Nepal Pvt. Ltd.
07.2018 - 09.2021
On-shore Technical Consultant
LIS Nepal Pvt. Ltd.
03.2018 - 03.2020
Software Engineer
LIS Nepal Pvt. Ltd.
09.2016 - 06.2018
Bachelors - Computer Science
Kathmandu University
01.2011 - 1 2015