# Smaran Rai

Smaran Rai is a remote worker on Himalayas, Data Engineer at Uxcam Pvt Ltd, based in Nepal.

Source: https://himalayas.app/@smaranrai

```text
Data Engineer skilled in data analysis and stakeholder collaboration.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Nepal |
| Authorized to work in | Nepal |
| Job categories | Data Engineer, Data Analyst, Business Analyst, Data Scientist, Senior Business Intelligence Developer, Data Engineering, Cloud Data Engineer, DataOps Engineer, Data Engineer |
| Skills | SQL, Relational Databases, Citus, Trino, Apache Spark, Python, Pandas, Flask, Django, Redash, Data Visualization, Requirements Gathering, Stakeholder Management, Agile, Kanban, Business Process Analysis, Data Driven Decision Making, UXCam, Grafana, Excel |
| Portfolio | https://github.com/smaranrai/Khetala |

## What I'm looking for

```text
I seek a collaborative environment where I can leverage my data skills to drive business insights and support strategic initiatives.
```

## About

```text
I am a dedicated Data Engineer with a strong background in data analysis and business intelligence. Currently, I work at Uxcam Pvt Ltd, where I develop API endpoints and automate data tasks, delivering actionable insights to cross-functional teams. My experience includes managing large-scale datasets and optimizing SQL queries to enhance data performance.

Previously, I served as a Business Development Representative at Grepsr Pvt Ltd, where I led product development initiatives and designed outbound processes for lead qualification. My analytical skills were further honed as a Data Analyst at BhatBhateni Holding Company, where I performed inventory and sales analysis, contributing to strategic decision-making.
```

## Experience

### Data Engineer (current)

Uxcam Pvt Ltd. Mar 2023 - Present

```text
Developed API endpoints and automated recurring data tasks with cron jobs, building dashboards to deliver actionable insights to engineering, product, and customer success teams. Managed and optimized large-scale datasets across distributed systems, performing database tuning and implementing data governance practices to ensure data integrity and performance.
```

Skills: SQL, Relational-Databases, Citus, Trino, Apache-Spark, Python, Pandas, Flask, Django, Redash, Grafana, Agile

### Business Development Representative

Grepsr Pvt Ltd. May 2022 - Present

```text
Led a strategic initiative to introduce pre-packaged datasets as a new product offering, conducting market trend analysis and collaborating with developers to design the product. Designed and implemented a structured outbound process for identifying and reaching out to potential leads, analyzing their data needs and qualifying MQLs into SQLs.
```

Skills: Trend-Analysis, Product-Development, Lead-Qualification, Partnership-Management, Python

### Data Analyst of Merchandise Team

BhatBhateni Holding Company. Mar 2021 - Present

```text
Analyzed inventory and sales data of over 13 global brands across more than 20 branches using R and MS Excel to understand brand and branch-wise performance. Performed time series sales forecasting using R on historical sales data to predict merchandise pre-order sales.
```

Skills: Excel, Inventory-Analysis, Sales-Analysis, R, Sales-Forecasting, Data-Cleaning, Tidyr, Dplyr

### Data Analyst Intern

BhatBhateni Holding Company Pvt Ltd.. Jan 2021 - Present

```text
Automated the data entry process for BBHCo using Excel macros and Power Query, significantly improving efficiency. Cleaned, analyzed, and visualized performance data of brands and branches using R and Excel, providing actionable insights.
```

Skills: Excel-Automation, Excel-Macros, Power-Query, Reporting, Data-Cleaning, Data-Analysis, R, Data-Visualization

## Education

### Kathmandu University School of Management

Bachelors in Business Administration, Business Administration. 2018 - 2022. Grade: 3.7 CGPA

```text
Studied business administration principles and practices. Gained knowledge in various aspects of business management, including finance, marketing, and operations. Developed analytical and problem-solving skills relevant to business contexts.
```

## Tech stack

- Apache Spark
- Redash
- Pandas
- Citus
- Gmail
- Django
- UXCam
- Grafana
- SQL

To contact Smaran, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Sabrin Singh](https://himalayas.app/@sabrinsingh): Senior Software (Data) Engineer, Techkraft Inc. Pvt. Ltd.
- [Rifka Regmi](https://himalayas.app/@rifkaregmi): Dataset Expert, Kaggle
- [Rikesh Kayastha](https://himalayas.app/@rikeshkayastha): Data Consultant, Freelance
- [Harichandra Khatri](https://himalayas.app/@harichandrakhatri): Software Developer, Self Employed
- [Info Bhabukpokharel](https://himalayas.app/@infobhabukpokharel): Senior Data Analyst, Searchable Design Pvt Ltd
- [keshav purbey](https://himalayas.app/@keshavpurbey): Business Intelligence Analyst, OmnicomMediaGroup Nepal
- [Dhawa Dorje Ghising](https://himalayas.app/@dhawadorjeghising1): Freelance Data Analyst, Self Employed
- [Ashim Shrestha](https://himalayas.app/@ashimshrestha3): Business Insight Analyst, Extensodata (F1Soft International)
- [Asmita Banjade](https://himalayas.app/@asmitabanjade): Data Engineer, Pioneer Association Pvt. Ltd.
- [Suvash Gautam](https://himalayas.app/@suvashgautam): Data Engineer, Pwnbot Systems
