Sampanna S
The star rating is a representation of the overall rating, calculated as the mean of the client satisfaction rating, the average client interview rating, and internal interview scores.
The client satisfaction rating is the weighted average of client ratings, with weights based on reviewed work hours. When no client rating exists, the approval fraction (approved vs. reviewed work hours) determines it.
If the client satisfaction rating exceeds the overall rating, it becomes the star rating. In the absence of client ratings, if the average client interview rating is higher than the overall rating, it becomes the star rating. If no data is available, the star rating defaults to the internal interview score.
The client satisfaction rating is the weighted average of client ratings, with weights based on reviewed work hours. When no client rating exists, the approval fraction (approved vs. reviewed work hours) determines it.
If the client satisfaction rating exceeds the overall rating, it becomes the star rating. In the absence of client ratings, if the average client interview rating is higher than the overall rating, it becomes the star rating. If no data is available, the star rating defaults to the internal interview score.
Data Engineer Preferred Title
$20.00 /hr $ 30.0K /yr Hourly Rate and Yearly Salary
Overview
Basic Summary
LD Talent History - Worksession Approval 100.0%
- Average Response Time 10.1 hours
- Average Count of Messages/Day 1.0
- Project Completion Rate 2/4
- Interview Acceptance Rate 4/6
- Timezone Overlap 25h PST, 40h UTC
- Earned Hours 11.00
- Code Quality 60%
- Soft Skill Attributes 60%
- Expertise 2/3
- Coding Challenges 60%
- No. of Lifelong Learning Projects 2
- No. of Coding Challenges Completed 2 More details
- Software Engineering Process 3.0/5
- Technical Breadth 4.0/5
- Algorithmic Thinking 3.0/5
- Technical Strength 4.0/5
- Teamwork 4.0/5
- Intellectual Merit 4.0/5
- English Communication 4.0/5
- Desktop Windows
- Phone Android
- Member Since Oct 02, 2023
- Profile Last Updated Oct 21, 2023
- Last Activity July 13, 2024, 7:32 p.m. UTC
- Location Nepal
Profile Summary
Specializing in helping businesses transform their data into insights that drive growth and value. Leveraging my expertise in Azure, Snowflake, and Looker, I can provide tailored solutions that address your unique data challenges.
Skills
Total Experience: 3+ years
R (2E, 2Y)
2 experiences, across 2 yearsSnowflake (3E, 2Y)
3 experiences, across 2 yearsLooker (2E)
2 experiencesAzure Data Factory (2E)
2 experiencesscikit-learn (2E)
2 experiencesPandas (2E)
2 experiencesPython (2E)
2 experiencesggplot2
tidyverse
Data visualization
dplyr
PyTorch
Natural language processing
ETL Extract Transform Load
Google Bigquery
Azure Storage
Azure Logic Apps
OracleDB
Scripting
Pyspark
Airflow
FastAPI
AWS S3
AWS ElasticMapReduce
AWS Athena
AWS Redshift
Weekly Availability
Timezone Overlap with 06 - 21 per Week: 25h PST, 40h UTC
Day
Monday
Tuesday
Wednesday
Thursday
Friday
UTC
10 - 18
10 - 18
10 - 18
10 - 18
10 - 18
PST
03 - 11
03 - 11
03 - 11
03 - 11
03 - 11
Vetting
- Interview Data
- Agile Development Process
- Productivity and Responsiveness
- Teamwork
- Software Engineering
- Logical Thinking
- Technical Strength
- Intellectual Merit
- English Communication
- Documentation
- System Design
- Coding Challenges60%
- Algorithms Score60%
- General Score60%
- Easy Algorithm
- Correctness60%
- Performance60%
- Medium Algorithm
- Correctness60%
- Performance60%
- Hard Algorithm
- Correctness60%
- Performance60%
- Expertise2/3
- Design Patterns and Architectures2/3
- Debugging2/3
- Stack Traces2/3
- Testing2/3
- System Administration2/3
- Soft Skill Attributes60%
- Entrepreneurial60%
- Whole Brained60%
- Divergent Thinking / Creativity60%
- Design Ability60%
- Empathy60%
- Project Management Ability60%
- Security60%
- Code Quality60%
- Complex Logic60%
- Models60%
- Controllers60%
- Templates60%
- APIs60%
- Training/Testing Data Models60%
- Code Readability60%
- Ongoing Evaluation
- Number of Lifelong Learning Project2
- Number of Coding Challenge Completed3
Experience
Data Scientist
Employment
May 2023 - Aug 2023
LIS Nepal Pvt. Ltd Company
Retail Industry
Project: Accelerator for Buy Online Ship from Store Orders
- Created FastAPI server for store or warehouse shipping decisions, factoring in item details, distance, inventory, clearance, & labor existing in Snowflake through the scikit-learn linear programming.
- The Python framework is developed to seamlessly integrates new attributes and adjustable priority settings for enhanced decision refinement using pandas data transformation.
Data Engineer
Employment
Nov 2022 - May 2023
LIS Nepal Pvt. Ltd Company
Retail Industry
Project: Enterprise Datawarehouse for Wiggle Ltd
- Created and managed a suite of Azure resources, including Azure Storage accounts, key vaults, Azure Data Factory, Azure Logic Apps, and Batch service, to support critical data processing workflow.
- Implemented a scalable Snowflake virtual data warehouse, utilizing dimensional data modeling with dashboards developed in Looker.
Data Scientist
Course Project
Feb 2022 - Feb 2023
Tribhuvan University Company
Media and Communication Industry
Project: Research: Hierarchical Classification of Disaster News using Local Classifier Per Parent Node
- Constructed a tree of Support Vector Machines(SVM) using scikit-learn and PyTorch that classified news into a hierarchy of disasters. The model was constructed using python: pandas and R scripts
- Demonstrated a significant increase in accuracy compared to flat classifiers by tuning a type of hierarchical classifier ‘a non-mandatory leaf-node predictor’
- Presented research findings at ICISS 2023 and published in Springer LNNS Series 2023 on Natural language processing domain.
Data Developer
Employment
Jun 2022 - Oct 2022
LIS Nepal Pvt. Ltd. Company
Retail Industry
Project: Supply Chain Analytics for Express
- Engaged in scripting and optimizing ETL Konsole scripts, orchestrating data movement from OracleDB (Oracle RMS) as the source to Teradata EDW as the target.
- Enhancement of the MicroStrategy report execution performance.
QA Engineer
Employment
Mar 2022 - Jun 2022
LIS Nepal Pvt. Ltd. Company
Retail Industry
Project: Customer Analytics for Ralph Lauren
- Conducted System Integration and Functional Testing, utilizing AWS Athena as the query engine, sourcing data from AWS S3, and targeting data stored in AWS Redshift.
- Verified Pyspark ETL scripts scheduled via Airflow, utilizing AWS ElasticMapReduce for computation.
Data Engineer
Employment
Apr 2021 - Jan 2022
LIS Nepal Pvt. Ltd. Company
Retail Industry
Project: Omnichannel and Customer Analytics For Torrid LLC
- Developed and deployed ETL scripts and Looker Explorer for three subject areas(Omnichannel commerce, Finance, and Customer Experience).
- ETL Extract Transform Load processes are executed through Azure Data Factory, extracting from GA360 (Google BigQuery) and loading into Snowflake Data Warehouse as the target.
Developer
Passion Project
Aug 2020 - Aug 2021
Self Company
Project: Weekly Submission of #TidyTuesday
- Actively involved in TidyTuesday, a weekly online event where R users participate in data visualization.
- I submitted several Data visualization developed using Tidyverse packages: Dplyr, Ggplot2, etc in R.
Qualifications
Education
Tribhuvan University
Nov 2016 - Apr 2021
B.E. (Computer Engineering)
Courses
Microsoft Azure Virtual Training Day: Azure Fundamentals
Course Certificate Link Jan 2023 - Jan 2023
Microsoft Azure
Microsoft Azure Virtual Training Day: Azure Data Fundamentals
Course Certificate Link Feb 2023 - Feb 2023
Microsoft Azure
Reviews
Client Project Reviews
LD Talent
He did some great work using heuristics to develop a tfidf solution to identify important design-related n-grams for our project success canvas. He is quite capable in data science and NLP.