Sushant T
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.
Software Engineer Preferred Title
$27.50 /hr $ 30.0K /yr Hourly Rate and Yearly Salary
Overview
Basic Summary
LD Talent History - Worksession Approval 100.0%
- Average Response Time 0.6 hours
- Average Count of Messages/Day 2.4
- Project Completion Rate 2/4
- Interview Acceptance Rate 4/6
- Timezone Overlap 17h PST, 26h UTC
- Earned Hours 22.50
- 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 3.0/5
- Algorithmic Thinking 4.0/5
- Technical Strength 4.0/5
- Teamwork 4.0/5
- Intellectual Merit 4.0/5
- English Communication 5.0/5
- Desktop Mac
- Phone Android
- Member Since Mar 07, 2023
- Profile Last Updated Apr 12, 2023
- Last Activity July 14, 2024, 4:26 a.m. UTC
- Location Nepal
Profile Summary
Software Engineer with a strong foundation in data technologies. Ready to learn, adapt, and execute if the job demands.
Skills
Total Experience: 4+ years
SQL (7E, 4Y)
7 experiences, across 4 yearsAWS Redshift (2E, 2Y)
2 experiences, across 2 yearsUML Diagrams (2E, 2Y)
2 experiences, across 2 yearsData Engineering (2E, 3Y)
2 experiences, across 3 yearsMicrosoft Excel (2E, 3Y)
2 experiences, across 3 yearsTableau (2E, 2Y)
2 experiences, across 2 yearsData Science (2Y)
2 years of experienceMATLAB (2Y)
2 years of experienceGit (2E, 3Y)
2 experiences, across 3 yearsHTTP
Unity Game Design and Development
C#
Apache Spark
Pandas
JIRA
Python
OracleDB (2E, 2Y)
2 experiences, across 2 yearsData Semantic Layers
MySQL
JavaScript (2Y)
2 years of experienceThree.js (2Y)
2 years of experienceSnowflake (2Y)
2 years of experienceGoogle Scripts (2Y)
2 years of experiencePostgres
Oracle BI
Unity Augmented Reality Design and Development (2Y)
2 years of experience
Weekly Availability
Timezone Overlap with 06 - 21 per Week: 17h PST, 26h UTC
Day
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
UTC
02 - 08
13 - 17
13 - 17
13 - 17
13 - 17
13 - 16
06 - 11
PST
18 - 00
05 - 09
05 - 09
05 - 09
05 - 09
05 - 08
22 - 03
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 QA
Employment
Dec 2022 - Mar 2023
LIS Nepal Pvt. Ltd. Company
Technology Industry
Project: Retail Data warehouse development
- I performed various functional and non-functional validations ETL code and Enterprise Data Warehouse (EDW) using Microsoft Excel, Google Sheets, Snowflake SQL database, and Microstrategy reports.
- I automated repetitive tasks using Google Scripts and macros.
- I managed and tracked project QA status using ClickUp and git in bitbucket.
- I monitored query performance in Snowflake SQL.
Data and Business Intelligence Engineer
Employment
May 2022 - Dec 2022
LIS Nepal Pvt. Ltd. Company
Technology Industry
Project: Data Engineering in Retail Wholesale domain
- I wrote python scripts to automate anomaly detection in the AWS Redshift SQL database.
- I wrote Apache Spark scripts in Python (Pyspark) to delete, load, and move data between Amazon S3 buckets.
- I wrote, scheduled, and automated Apache airflow DAGs.
- I developed a system to track project task status using the Jira platform REST API and pandas data frame in Python.
Data and Business Intelligence Engineer
Employment
Dec 2021 - Apr 2022
LIS Nepal Pvt. Ltd. Company
Technology Industry
Project: Wholesale Datamart development, USA (offshore)
- I built and tested various subject areas of a wholesale datamart (end-to-end data ETL pipeline), using packages and scripts in Oracle PL/SQL, which is based on OracleDB SQL.
- I documented the data engineering process using git in bitbucket.
SQL Developer
Employment
Jul 2021 - Dec 2021
LIS Nepal Pvt. Ltd. Company
Project: Semantic Layer View Development, USA (offshore)
- I wrote SQL queries for historical data migration (from Oracle SQL to AWS Redshift).
- I developed materialized views for Data Semantic Layers (used by Business Reporting in Tableau) using Amazon Redshift.
- I performed data migration and semantic layer view validation using Tableau and Microsoft Excel.
Data Engineer
Employment
May 2021 - Jul 2021
LIS Nepal Pvt. Ltd. Company
Technology Industry
Project: Retail Insights Technical Consulting, Thailand (offshore)
- I performed query optimization in OracleDB SQL to suggest improvements in deployed queries.
- I analyzed batch failures using the Oracle Data Integrator (ODI) of Oracle BI to propose data fixes and batch improvement.
Project lead and javascript developer
Course Project
Oct 2020 - Feb 2021
Institute of Engineering, Pulchowk Campus (Tribhuvan University) Company
Education Industry
Project: Clothes Modeling In Human And Pattern Design Generation Using Gan (Computer Engineering Major Project)
- Using the JavaScript framework Three.js, I displayed a customizable 3D human model on which users could select custom clothing patterns (synthesized by a GAN model).
- I documented the project using Latex.
Business Developer
Course Project
Dec 2020 - Feb 2021
Institute of Engineering, Pulchowk Campus (Tribhuvan University) Company
Project: Augmented Reality Application (Project For Subject “Innovation And IT Entrepreneurship”)
- I developed a business plan for an application prototype we made.
- I made an application on android using "Unity Augmented Reality Design and Development", which rendered Augmented Reality models when related images were scanned.
Unity Developer
Internship
Mar 2020 - Oct 2020
Alternative Technology Pvt. Ltd. Company
Technology Industry
Project: Virtual Exhibition
- I created the early prototype for a "virtual exhibition", which is an environment where users can explore using "Unity Game Design and Development".
- I wrote the logic for interacting with the environment and moving around using C#.
- I wrote logic to dynamically download assets using HTTP protocols and load them in the environment objects using C#.
Data Engineer
Course Project
Jul 2019 - Mar 2020
Institute of Engineering, Pulchowk Campus (Tribhuvan University) Company
Education Industry
Project: Electrocardiogram (ECG) Analysis using AI (Computer Engineering Minor Project)
- I used principles of Data Science to implement a notch filter (frequency band-stop filter) on the raw dataset to reduce noise and improve the classifier using Octave/Matlab.
- I prepared the necessary documentation using standard UML diagrams as well as other diagrams (Use case diagram, Activity diagram, Class diagram, Deployment diagram, State diagram, and Object diagram).
Project lead and Database developer
Course Project
May 2019 - Oct 2019
Institute of Engineering, Pulchowk Campus (Tribhuvan University) Company
Education Industry
Project: Publication Management System
- I overlooked the data engineering aspect of the project. I was responsible for the operation of designing, implementing, and integrating the entire database in MySQL (SQL) from scratch.
- I prepared the necessary documentation using standard UML diagrams as well as other diagrams (Data Flow Diagram, Use Case Diagram, Entity Relationship Diagram, and Sequence Diagram).
LD Experience
Client Projects
Coding Challenges
Skill:
- SQL
- AWS Redshift
- UML Diagrams
- Data Engineering
- Microsoft Excel
- Tableau
- Data Science
Basic
Sep 2020 - Jan 2022
Basic
Sep 2020 - Jan 2022
Basic
Sep 2020 - Jan 2022
Video Projects
How to implement django-tenant-schemas with a fixed URL
Sep 2020 - Jan 2022
Frontend Developer
Technology
- SQL
- AWS Redshift
- UML Diagrams
- Data Engineering
- Microsoft Excel
- Tableau
- Data Science
- Led user research for a new construction site documentation tool.
- Hosted workshops to synthesize user insights into design requirements.
- Designed 3D concepts and built prototypes to investigate new tool form factors.
- Researched existing digital solutions and prioritized key features for app release.
LD Ventures
Thea
Sep 2020 - Jan 2022
Frontend Developer
Technology
- SQL
- AWS Redshift
- UML Diagrams
- Data Engineering
- Microsoft Excel
- Tableau
- Data Science
- I used the Django Rest Framework to create a multi tenant API with the aid of the django-tenant-schemas package.
- I used the Postgres Database as the persistence layer and specifically the PostgreSQL Schemas to ensure that all tenants using the API had their data.
- I used the REST architecture in designing my API.
- Researched existing digital solutions and prioritized key features for app release.
Qualifications
Education
Institute of Engineering, Tribhuvan University
Nov 2016 - Sep 2023
BE (Computer Engineering)