Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Candidate Response

 |  |  |  |  | Round 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Round 2 |  |  |  |  |  |  |  | HR Round
SL No | Candidate Name | [NAME] | Date | Interview Round | Interviewer | Logical Sense | Angular Score | SQL Score | .Net core web API Score | Others | Final Status | Q: [NAME] emp= {Name: “Ram”, Age: 40, Salary:{Basic:500, BonusPercentage : 0.5}}. If this is a Employee’s json data, calculate  Employs Bonus Where employs Bonus is equal to employee basic multiply to bonus percentage .  Ans .  var EmpBonus=emp.Salary.Basic* emp.Salary.BonusPercentage | If [NAME] is null then What is you result ?   Ans.  Error | How will you handle the Error  Ans   var empBonus=0  If(emp.[NAME]) empBonus= emp.Salary.Basic* emp.Salary.BonusPercentage | Can I implement many to many relation ship using SQL server | Suppose an Employee is working on multiple Projects and at the same time multiple other employees are also working on the same Project. Will  you be able to implement using SQL Server [Database diagram]? | Assume that you are working on Dynamic SQL or inline SQL Will you be able to handle SQL injection and Special character like ‘, &? | What is a [NAME]? Explain declarations, Imports, providers | What are Services? | Suppose there are 2 components, Component A and Component B .           a. I want pas information A to B if Ans @Input           b. If B is Parent Component if Ans @output           c. If there is not any relation A and B | What is routing and how do you define route in Angular? | How to identify which method is invoked in a Web API call? | Difference between get, post, put. | Feedback | Interviewer | OOPS | SQL | C#, ASP.Net | Leadership | Project Experience | Others | Feedback | Interviewer | Status | Feedback
1 | [NAME] | [EMAIL] | 2020-10-29 00:00:00 | 1st Round | Gajendra |  | 0 | 2 | 1 |  | Rejected |  |  |  |  |  |  |  |  |  |  |  |  | Poor knowledge in Angular (6 months).no experience working in JSON-Some basic concept are not clear.6 months expr. in API support (not in development)
2 | K Varun Kumar | [EMAIL] | 2020-10-27 00:00:00 | 1st Round | Gouranga |  | 0 | 3.5 | 1 |  | Rejected |  |  |  |  |  |  |  |  |  |  |  |  | Very poor idea about Angular.no experience working in JSONbut working in XML.Not done any real life project in .net web api.ASP.net good, [NAME] good,Web API Good With Response code
3 | Pradipto Banik Majumdar | [EMAIL] /[EMAIL] | 2020-11-05 00:00:00 | HR Round | Gouranga | 4 | 4 | 4 | 4 | 4 | Selected | Passed | Passed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Angular:The candidate knows about module,routing but he dosen't know multiple routing outlet.but I think he knows lazy loading.SQL Server:He knows database relationship,Dynamic query and knows Web Api. | Sudip and Sumanta |  |  |  |  |  |  | Selected | [NAME] and Ritu | [NAME] | He was not being able to justify his expirence and moreover to verify his salary to send the payslip then he said that his portal is not working will send later.Then he is now no more interested to  even  negotiate.
4 | [NAME] | [EMAIL] | 2020-11-06 00:00:00 | 1st Round | Gajendra | 4 | 4 | 3 | 2 | 3 | Selected | Passed | Passed | Failed | Passed | Passed | Failed | Passed | Passed | Passed | Failed | Failed | Passed | Angular: Good knowledge about module, lef cycle hooks,component (parent and child relation) and services. Weakness in route concept. Sql : Stored procedure, function,relationship and basic concepts are good. Weakness in Dynamic query. API: implement only GET and POST request. | Sudip and subrata |  |  |  |  |  |  | No Show
5 | kibria [NAME] | [EMAIL] | 2020-11-09 00:00:00 | HR Round | Gouranga | 4 | 4 | 3 | 3 | 4 | Selected | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Failed | Passed | Failed | Overall good, He has good knowledge in Angular, but some problem in SQL Server ,C# and Web API | Sudip and Debasis |  |  |  |  |  |  | Selected | [NAME] and Ritu | Offer Accepted | He will join on 4th Jan 2021
6 | [NAME] | [EMAIL] | 2020-11-13 00:00:00 | 1st Round | Amit | 0 | 0 | 0 |  |  | Rejected | Failed |  |  | Failed | Failed |  | Failed | Failed | Failed | Failed |  |  | Angular - Does not have the basic concept of Angular 2 + SQL Server - Does not posses the relational database concept. WEB API - Did not asked since does not worth proceeding further.
7 | Raja Dostidar | [EMAIL] | 2020-11-18 00:00:00 | 2nd Round | Gouranga | 4 | 5 | 2 | 3 | 4 | Selected | Passed | Passed | Passed | Failed | Failed | Failed | Passed | Passed | Passed | Passed | Passed |  | very good in Angular but week in SQL server. | Sudip and subrata |  |  |  |  |  |  | Rejected//no Knowledge in SQL server and [NAME].
8 | Dhriti Dutta | [EMAIL] | 2020-11-20 00:00:00 | 1st Round | Gajendra | 0 | 4 | 2 | 2 | 1 | Rejected | Failed | Failed | Failed | Passed | Failed | Failed | Passed | Passed | Passed | Passed | Failed | Passed | Angular: have an average knowledge in Angular.  Could not answer Observables, GlobalVariables, Decorators.Sql: 6 months expr. in sql. Could not answer Stored procedure, Function, dynamic sql.Logical: Could not answer.
9 | Nilabja Bhattacharya | [EMAIL] | 2020-11-21 00:00:00 | 1st Round | Gouranga | 4 | 3 | 2 | 3 | 3 | Selected | Passed | Passed | Passed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Failed | good but very confuse for this reason he knows but can't answer | Sudip and Debasis |  |  |  |  |  |  | No Show
10 | Subhasis Maitra | [EMAIL] | 2020-11-24 00:00:00 | 1st Round | Amit | 3 | 2 | 0 | 0 |  | Rejected | Passed | Failed | Passed | Failed | Failed | Failed | Passed | Passed | Failed | Failed | Failed | Failed | Angular - Not adequate knowledge as per experience. SQL - No knowledge of SQL Server .Net Core - No knowledge
11 | Aditya Das | [EMAIL] | 2020-11-26 00:00:00 | 1st Round | Gajendra | 4 | 4 | 1 | 2 | 2 | Rejected | Passed | Passed | Failed | Failed | Failed | Failed | Passed | Passed | Passed | Passed | Failed | Passed | Angular: have average knowledge in Angular (1.6 yrs expr.) Could not answer Decorator,  SQL: Could not write Store procedure and function syntax. Could not answer Dynamic query and basic concept of SQL Web API: Not have worked on dotnet api and not answer simple questions
12 | [NAME] | [EMAIL] | 2020-11-28 00:00:00 | 1st Round | Gouranga | 4 | 4 | 2 | 2 | 3 | Rejected | Passed | Passed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Everythikg good but he does not know Sql Server. But good knoladge in SQL Server
13 | Satyaki Chakraborty | [EMAIL] / [EMAIL] | 2020-12-02 00:00:00 | 2nd Round | Gajendra | 5 | 5 | 3 | 3 |  | Selected | Passed | Passed | Passed | Passed | Passed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Angular: have 2 yrs. working expr. in Angular 6. Could not answer Decorator, Lazy loading Sql: 8 yrs. working expr. have an average knowledge. Could not answer Dynamic SQL, CTE | Sudip and Sumanta |  |  |  |  |  |  | Rejected//Candiadte does not have good knowledge in SQL
14 | [NAME] | [EMAIL] | 2020-12-02 00:00:00 | 2nd Round | Gouranga | 2 | 4 | 3 | 3 | 4 | Selected | Passed | Failed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Good knowledge in Angular, SQL server. But Confusion in htpp response code. don't jwt token. he unable to handle httprResponse code like 401,400 | Sudip |  |  |  |  |  |  | Selected | [NAME] and Ritu | [NAME] | Not Willing to negotiate on salary
15 | [NAME] | [EMAIL]/[EMAIL] | 2020-12-02 00:00:00 | 1st Round | Amit | 3 | 2 | 0 | 1 |  | Rejected | Passed | Failed | Passed | Failed | Failed | Failed | Passed | Passed | Passed | Failed | Passed | Failed | Angular - Basic knowledge SQL - Very poor .Net Core - Not adequate knowledge as per experience
16 | [NAME] | [EMAIL] | 2020-12-09 00:00:00 | 2nd Round | Amit | 5 | 4 | 4 | 4 |  | Selected | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed |  | Passed | Passed | [NAME].Proceed for Second round | Sudip |  |  |  |  |  |  | Selected | [NAME] and [NAME] | Offer Accepted | He will join on 4th Jan 2021
17 | [NAME] | [EMAIL] | 2020-12-16 00:00:00 | 1st Round | Gajendra | 2.5 | 2 | 2 |  |  | Rejected | Passed | Failed | Failed | Passed | Passed | Failed | Failed | Passed | Passed | Failed | Failed | Passed | Angular: Could not answer [NAME], routing,decorators. SQL: Could not answer dynamic sql, sp vs function. Basic concept not clear Web API: Not worked on web API.
18 | [NAME] | [EMAIL] | 2020-12-19 00:00:00 | 1st Round | Gouranga | 2 | 3 | 3 | 2 | 2 | Rejected | Failed | Failed | Failed | Passed | Passed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Not Good Knowledge on Angular and SQL
19 | [NAME] | [EMAIL] | 2020-12-21 00:00:00 | 1st Round | Amit | 0 | 1 | 1 | 1 |  | Rejected | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Failed | Passed | Failed | Passed | Angular - Poor SQL - Poor Dotnet Core - Poor
20 | [NAME] | [EMAIL] | 2020-12-23 00:00:00 | 1st Round | Gouranga | 2 | 2 |  | 2 | 2 | Rejected | Passed | Failed |  | Failed | Failed |  |  | Failed | Passed | Failed | Failed |  | Poor Knowledge in Angular and SQL
21 | Pratik [NAME] | [EMAIL] | 2021-01-08 00:00:00 | 1st Round | Gajendra | 1 | 1 | 1 | 3 | 2 | Not Suitable | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Failed | Failed | Passed | Passed | Angular: Could not answer use on @input and @output. Not even route any component during developement. SQL: Basic concepts are not clear. Could not answer unique and primary key. Web API: Not have worked on .Net Core,
22 | Neeraj Kumar | [EMAIL] | 2021-01-14 00:00:00 | 1st Round | Amit | 1 | 1 | 1 | 1 |  | Rejected | Passed | Passed | Passed | Failed | Failed | Failed | Failed | Failed |  | Failed | Failed |  | Angular - Not adequate knowledge SQL - Not adequate knowledge .Net Core - Not worked
23 | Arijit Das | [EMAIL] | 2021-01-15 00:00:00 | 1st Round | Gouranga | 2 | 2 | 1 | 2 | 2 | Rejected | Failed | Failed | Failed | Passed | Passed | Passed | Failed | Failed | Failed | Failed | Failed | Failed | Very poor knolage in angular ,C# and SQL server
24 | [NAME] | [EMAIL] | 2021-01-15 00:00:00 | 1st Round | Gajendra | 1 | 2 | 2 | 1 |  | Not Suitable | Failed | Failed | Failed | Failed | Passed | Failed | Passed | Failed | Failed | Passed | Failed | Passed | Angular: 5 months expr. Not have worked on any project. Could not answer how to pass the data between two component.   SQL: 5 yrs expr. having basic clear knowledge.
25 | Sanjuckta Saha |  | 2021-01-19 00:00:00 | 1st Round | Gajendra | 2 | 3 | 2 | 2 |  | Not Suitable | Failed | Passed | Passed | Failed | Failed | Failed | Failed | Passed | Failed | Passed | Passed | Failed | Angular: 3 yrs. Expr. Could not answer passing data between components, services, routing SQL: 4 yrs. expr. Could not answer Dynamic SQL, function (DBA dependent on Company)
26 | [NAME] |  | 2021-01-19 00:00:00 | 1st Round | Amit | 0 | 1 | 1 | 1 |  | Rejected | Failed | Failed | Failed | Passed | Passed | Failed | Failed | Failed | Failed | Failed | Passed | Passed | Angular - Poor SQL - very less working exp. .Net Core - Freshe
27 | Moumita Banerjee |  | 2021-01-19 00:00:00 | 1st Round | Gouranga | 3 | 1 | 3 | 1 | 2 | Not Suitable | Passed | Passed | Passed | Passed | Passed | Failed | Passed | Passed | Failed | Failed | Passed | Failed | Not good
28 | [NAME] | [EMAIL] | 2021-01-22 00:00:00 | 1st Round | Amit | 1 | 1 | 1 | 1 |  | Rejected | Failed |  |  |  | Failed | Failed | Failed | Passed | Failed | Failed | Failed | Passed | Week in SQL, angular as per experience.
29 | Nilabja Bhattacharya | [EMAIL] | 2021-01-22 00:00:00 | 1st Round | Gajendra | 0 | 4 | 3 | 2 | 3 | Selected | Failed | Failed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Angular: 4 yrs. expr. having good working knowledge SQL: 5yrs. expr. Basic concepts are clear. General: Could not answer following question | Sudip |  |  |  |  |  |  | Selected | Sugata,[NAME] and [NAME] | [NAME]
30 | Sthitadhi Chakraborty | [EMAIL] | 2021-01-22 00:00:00 | 1st Round | Gouranga | 3 | 3 | 4 | 3 | 4 | Selected | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | Passed | [NAME] in Angular and SQL server
31 | [NAME] |  | 2021-01-25 00:00:00 | 1st Round | Gajendra | 0 | 1 | 2 | 2 | 2 | Rejected | Failed | Failed | Failed | Failed | Passed | Failed | Passed | Failed | Failed | Failed | Failed | Passed | Angular: 6 month expr. Could not answer the question in Question Bank SQL: Basic concepts are not clear
32 | Swati [NAME] |  | 2021-01-28 00:00:00 | 1st Round | Gajendra | 1 | 1 | 1 | 1 | 1 | Not Suitable | Failed | Failed | Failed | Failed | Passed | Failed | Failed | Passed | Failed | Failed | Passed | Failed | Angular: 2 yrs expr., Not in touch with last 6 months. Could not answer about [NAME], data passing between Comp A to Comp B SQL: 2 yrs. expr. (not in touch from last 1.5 yrs) Could not answer [NAME] procedure , function, trasaction and trigger. API: Could not answer concepts of GET, POST
33 | [NAME] |  | 2021-01-29 00:00:00 | 1st Round | Gouranga | 1 | 4 | 0 | 2 | 3 | On Hold | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Good in Angular, But Other knowledge not Good
34 | [NAME] |  | 2021-02-02 00:00:00 | 1st Round | Gouranga | 2 | 3 | 3 |  | 3 | Rejected | Passed | Passed | Passed | Failed | Failed | Passed | Passed | Passed | Passed | Passed |  | Failed | Not good Knowledge
35 | [NAME] |  | 2021-02-09 00:00:00 | 2nd Round | Gajendra | 3 | 3 | 2 | 2 | 1 | Selected | Passed | Passed | Failed | Passed | Passed | Failed | Passed | Passed | Failed | Passed | Failed | Passed | Angular: 1 yrs expr., have working knowledge. Answer the basic questions. SQL: 1.5 yrs. expr. , Basic concepts are clear. Could not answer complex questions WEB API:  Worked on MVC Web API | [NAME] and [NAME] |  |  |  |  |  |  | Rejected//Weak in sql server
36 | Ankur Chakraborty |  | 2021-02-10 00:00:00 | 1st Round | Gouranga | 1 | 0 | 1 | 1 | 1 | Rejected | Failed | Failed | Failed | Passed | Passed | Failed | Failed | Failed | Failed | Failed | Passed | Passed | Very poor knowledge
37 | [NAME] |  | 2021-02-11 00:00:00 | 1st Round | Gajendra | 2 | 2 | 2 | 1 | 2 | Not Suitable | Passed | Failed | Failed | Failed | Passed | Failed | Failed | Passed | Passed | Failed | Failed | Passed | Angular: Basic concepts are not clear. Could not answer [NAME], Decorator, observables SQL: Could not answer stored procedure vs fucntion, views vs table
38 | [NAME] |  | 2021-02-16 00:00:00 | 1st Round | Gouranga | 0 | 0 | 0 | 0 | 0 | Rejected | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Failed | Failed |  | Failed | Failed | Very poor
39 | Parshuram Kumar |  | 2021-02-16 00:00:00 | 1st Round | Amit | 0 | 1 | 1 | 1 |  | Rejected |  |  |  |  |  | Failed | Failed | Failed |  |  | Failed | Failed | Not adequate knowledge in all 3 divisions(SQL,Angular and WEB API)
40 | [NAME] |  | 2021-02-18 00:00:00 | 1st Round | Amit | 1 | 2 | 1 | 1 |  | Rejected | Passed | Passed | Passed | Failed | Failed | Failed | Failed | Passed | Failed | Failed | Passed | Failed | Poor in SQl server as per experience, Angular basic knowledge, WEB API poor
41 | Shabnam Shahin |  | 2021-02-18 00:00:00 | 1st Round | Gajendra | 2 | 4 | 1 | 2 | 2 | Not Suitable | Passed | Passed | Failed | Failed | Failed | Failed | Passed | Passed | Passed | Passed | Passed | Failed | Angular: 3 yrs. expr., basic concepts are clear. Answer all the question in list from Angular. SQL: 1yrs. expr. (last 2 yrs. have not worked) Could not answer [NAME] procedure, transaction, function. Note: She is working as a front end developer and good in Angular. She is not a full stack developer.
42 | Kanoj Kumar Paul |  | 2021-02-19 00:00:00 | 2nd Round | Amit | 0 | 2 | 1 | 1 |  | Selected |  |  |  |  |  |  | Passed | Passed | Passed | Passed | Failed | Passed | Did not complete the interview since the candidate left off. As discussed with Sudip, forwarded to next round
43 | Ravi Kumar |  | 2021-02-27 00:00:00 | 1st Round | Gouranga | 0 | 3 | 1 | 1 | 2 | Rejected | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Passed | Passed | Passed | Passed | Passed | Angular is ok , But in SQL the knowledge is very poor.
44 | [NAME] |  | 2021-03-09 00:00:00 | 1st Round | Gouranga | 2 | 2 | 1 | 1 | 2 | Rejected | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Failed | Failed | Passed | Failed | Poor Knowledge in Angular. The basic concepts of Angular  are not clear
45 | [NAME] |  | 2021-03-09 00:00:00 | 1st Round | Gajendra | 0 | 0 | 1 | 0 | 1 | Not Suitable | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Not have worked on Angular,SQL,WebAPI Only 5months expr. (last worked on Dec'19) not in touch with any our domain knowledge expr.
46 | [NAME] |  | 2021-03-10 00:00:00 | 1st Round | Gajendra | 1 | 2 | 0 | 0 | 1 | Not Suitable | Failed | Failed | Failed | Failed | Failed | Failed | Failed | Passed | Passed | Failed | Failed | Failed | Angular: Basic concepts are not clear. Working as a UI developer. SQL: Not worked. Web API: Not Worked. He is working as a UI developer. All backend part doing by his senior member.
47 | Akash Mishra |  | 2021-03-11 00:00:00 | 1st Round | Gouranga | 1 | 0 | 0 | 0 | 1 | Rejected | Failed | Failed | Failed | Failed | Failed | Failed |  | Failed | Failed | Failed | Failed | Passed | Very poor Knowledge.