Achalshail Khadka
Dallas,TX
Summary
Results-driven Data Engineer and Analyst with expertise in data analysis, pipeline development, and reporting. Specializes in building ETL workflows with SQL, Python, and Azure Data Factory, while leveraging cloud platforms such as AWS and Azure. Skilled in querying and data modeling with Snowflake and Azure Synapse, and creating impactful dashboards using Power BI and Tableau to enhance business decision-making.
Overview
6
6
years of professional experience
Work History
Data Engineer
Raven Software Solutions
Farmers Branch, TX
08.2024 - Current
- Designed and implemented ETL pipelines using Python, SQL, and Azure Data Factory to automate data ingestion and transformation workflows.
- Developed SQL queries for data extraction, cleansing, and aggregation to support reporting and analysis tasks.
- Managed creation of tables, views, and stored procedures in Azure Synapse and Snowflake, ensuring optimized data structures for analytics.
- Built data models and ER diagrams to support structured data storage and reporting needs.
- Developed Power BI dashboards to visualize key metrics for internal stakeholders, enhancing data accessibility and supporting informed decision-making.
- Collaborated with cross-functional teams to gather data requirements, ensuring data accuracy and consistency across systems.
- Participated in testing and validating data workflows, helping ensure integrity during data pipeline development.
- Environment: Python, SQL, Azure Data Factory, Azure Synapse, Snowflake, Power BI, Git, JIRA, Excel
Data Analyst
RGB IT Solutions
Kathmandu, Nepal
01.2021 - 07.2022
- Collected, cleaned, and transformed business data using Python (Pandas, NumPy) and SQL to enhance reporting and inform strategic decisions.
- Applied statistical techniques such as hypothesis testing, correlation analysis, and regression modeling to derive actionable insights.
- Conducted exploratory data analysis (EDA) and created predictive models using Python and SAS to forecast trends and support planning.
- Built dashboards in Power BI and Tableau to visualize key business metrics, customer behavior, and operational performance.
- Collaborated with stakeholders to define KPIs, gather requirements, and build interactive data models for business teams.
- Automated Excel-based reporting with formulas, pivot tables, and VBA, streamlining processes and increasing reporting accuracy.
- Validated inputs, resolved inconsistencies, and standardized data formats across multiple sources to maintain high data quality.
- Environment: Python, SQL, Power BI, Tableau, Excel (VLOOKUP, Pivot Tables, VBA), SAS, Git, JIRA, Regression Analysis, Hypothesis Testing, Predictive Modeling.
Data Analyst
Sustainable Technological Solution
Kathmandu, Nepal
04.2020 - 12.2020
- Analyzed structured datasets using Python (Pandas, NumPy) and SQL to generate insights on operational and product performance.
- Conducted statistical analysis including trend analysis, correlation, and variance analysis using Python.
- Performed data cleaning, feature engineering, and validation to ensure datasets were ready for accurate analysis and reporting.
- Developed and maintained dashboards and visual reports using Power BI and Excel, enhancing cross-departmental decision-making.
- Created ad hoc reports and KPI tracking tools, facilitating informed business intelligence and reporting.
- Worked closely with the development team to ensure data availability, accuracy, and proper integration across platforms.
- Environment: Python, SQL, Power BI, Excel, Git, JIRA
Education
Masters in Science - Business Analytics
University of Central Oklahoma
Edmond, Oklahoma01-2024
Bachelor’s - Computer Engineering
Tribhuvan University
Kathmandu, Nepal01-2020
Skills
- Python
- SQL
- Azure Data Factory
- Snowflake
- Azure
- Big data processing
- Data modeling
- Power BI
- Tableau
- Excel
- Statistical modeling
- Machine learning
- SAS
- AWS
Projects
- Predictive Model for Restaurant Closure, Python, SAS Enterprise Miner, SQL, Excel, Developed a predictive model using Yelp reviews and restaurant features (e.g., payment options, amenities) to estimate closure risk in Philadelphia. Applied machine learning techniques including GLM, LASSO, and LARS in SAS Enterprise Miner to improve model accuracy. Used Python for JSON-to-Excel data conversion, cleaning, and transformation; performed exploratory analysis using Pandas and NumPy. Visualized results with Matplotlib and Seaborn to understand feature influence on restaurant survival. Identified key risk factors such as delivery services, star ratings, and chain affiliation to derive actionable insights.
- University Major vs. Income Analysis, SAS, Python, Excel, Tableau, Conducted statistical analysis using Kaggle data to examine the relationship between university major and post-graduation income. Applied GLM models in SAS and used PROC MEANS for summarization and analysis. Transformed and cleaned data using Python and Excel; created visual dashboards in Tableau and Excel. Presented insights on how major, unemployment rate, and employment status impact earning potential.
Timeline
Data Engineer
Raven Software Solutions
08.2024 - Current
Data Analyst
RGB IT Solutions
01.2021 - 07.2022
Data Analyst
Sustainable Technological Solution
04.2020 - 12.2020
Masters in Science - Business Analytics
University of Central Oklahoma
Bachelor’s - Computer Engineering
Tribhuvan University