Sushant T
The star rating is calculated by averaging the reviews provided by all clients the talent has worked with for a significant amount of time.
If such data is not available, the star rating is calculated from the fraction of work sessions approved by their past clients versus the total tracked by the talent.
If such data is not available, the star rating defaults to the interview rating of the talent at the time of the vetting process.
Other data including reviews from interviews are available on the talents’ profiles but do not influence their star rating, though they do influence their position in the search results.
If such data is not available, the star rating is calculated from the fraction of work sessions approved by their past clients versus the total tracked by the talent.
If such data is not available, the star rating defaults to the interview rating of the talent at the time of the vetting process.
Other data including reviews from interviews are available on the talents’ profiles but do not influence their star rating, though they do influence their position in the search results.
Software Engineer Preferred Title
$25.00 /hr $ 30.0K /yr Hourly Rate and Yearly Salary
Overview
Basic Summary
LD Talent History - Average Response Time 12.0 hours
- Average Count of Messages/Day 0.4
- Project Completion Rate 2/4
- Interview Acceptance Rate 4/6
- Timezone Overlap 21h PST, 26h UTC
- 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 Feb 18, 2023
- Last Activity March 14, 2023, 7:27 p.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 (6E, 2Y)
6 experiences, across 2 yearsAWS Redshift (2E, 1Y)
2 experiences, 1 yearUML Diagrams (2E, 1Y)
2 experiences, 1 yearData Engineering (2E, 1Y)
2 experiences, 1 yearMicrosoft Excel (2E, 1Y)
2 experiences, 1 yearData Science (1E, 1Y)
1 experience, 1 yearMATLAB (1E, 1Y)
1 experience, 1 yearGit (2E, 1Y)
2 experiences, 1 yearPython (1E, 1Y)
1 experience, 1 yearJIRA (1E, 1Y)
1 experience, 1 yearPandas (1E, 1Y)
1 experience, 1 yearApache Spark (1E, 1Y)
1 experience, 1 yearC# (1E, 1Y)
1 experience, 1 yearUnity Game Design and Development (1E, 1Y)
1 experience, 1 yearHTTP (1E, 1Y)
1 experience, 1 yearOracleDB (2E, 1Y)
2 experiences, 1 yearTableau (1E, < 1Y)
1 experience, less than a yearData Semantic Layers (1E, < 1Y)
1 experience, less than a yearMySQL (1E, < 1Y)
1 experience, less than a yearJavaScript (1E, < 1Y)
1 experience, less than a yearThree.js (1E, < 1Y)
1 experience, less than a yearSnowflake (1E, < 1Y)
1 experience, less than a yearGoogle Scripts (1E, < 1Y)
1 experience, less than a yearOracle BI (1E, < 1Y)
1 experience, less than a yearUnity Augmented Reality Design and Development (1E, < 1Y)
1 experience, less than a year
Weekly Availability
Timezone Overlap Per Week: 21h 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
19 - 01
06 - 10
06 - 10
06 - 10
06 - 10
06 - 09
23 - 04
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
- Microsoft Excel
- SQL
- Git
- Snowflake
- Google Scripts
- 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
- SQL
- AWS Redshift
- JIRA
- Apache Spark
- Python
- Pandas
- 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)
- OracleDB
- SQL
- Data Engineering
- Git
- 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)
- Microsoft Excel
- SQL
- AWS Redshift
- Tableau
- Data Semantic Layers
- 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)
- Oracle BI
- OracleDB
- SQL
- 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)
- Three.js
- JavaScript
- 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”)
- Unity Augmented Reality Design and Development
- 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
- HTTP
- C#
- Unity Game Design and Development
- 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)
- Data Science
- UML Diagrams
- MATLAB
- 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
- UML Diagrams
- SQL
- Data Engineering
- MySQL
- 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).
Qualifications
Education
Institute of Engineering, Tribhuvan University
Nov 2016 - Sep 2023
BE (Computer Engineering)