TestingCOE

Fake it until you making it

2020-08-26T18:18:00.004-07:00

Manager: Asked his subordinate to squeeze the milk from the cow.

Subordinate1: Yes Manager, he went and saw that is bull. Immediately update the manager about that.

Bull/OX may not be able to squeeze the milk.

Subordinate2: Yes Manager, he went and saw that is bull. However, he has updated his manager that he has requested for grass (Note: Without grass will not be able to squeeze the milk).

Manager1 Comments: Fake it or Make it

About Subordinate1: He has a negative attitude to deliver the required things

About Subordinate2: He has a positive attitude to deliver the required things

Moral of the story: Fake it until making it.

Manager2 Comments: Releastic pic will not like

About Subordinate1: He has a positive attitude to deliver the required things

About Subordinate2: He has a negative attitude to deliver the required things

Eg: Straight trees cut first

Steps to complete the RFP

2020-07-29T16:50:00.002-07:00

Presentation for Phd compre

2020-07-29T16:50:00.001-07:00

__________________
0) Agenda
1) Video Analytics - 4/5 Slides
i) Video Analytics - What?
ii) Intro and importance of video
ii) Domain Snapshots
iii) Literature Survey
iv) Research Obj
v) Res Challenges
2) Topic 1
i) Research Objective (Existing vs new)
ii) Algorithm
iii) Experimental Analysis
A) Data sets (Table and Graphs)
B) Parameter setting
C) Performance Metrics
D) Outcomes (Data and outcomes)
3) Topic 2,3,4,5
7) Conclusion
8) Reference
9) Thanks

2017-12-23T14:10:00.001-08:00

1. FAT : Factory Acceptance Testing: Third party products or customized products which needs to be deployed in the client location before integrating with other applications.
Needs to be validated by the business team, based on their confirmation moved to system testing which will be deployed into the client network.
2. VPT: Volume and Performance Testing: Performance Testing is also called as VPT
3. IVT: Implementation Validation Testing
4. SAT: Service Acceptance Testing: Service team ie Support teams (Integration, Application, Colloboration, Database) will validate the deployment procedure.
5. DOT: Deployment Option Testing: Both old and new software versions of the application should work.
As per the process, deploy the new code and testing will continue once it is done then support team will reverse the new code to old code ie production code.
This code is tested by the testing team.
Note: Similar to IVT but it is not the same

Client Management

2017-12-23T14:09:00.002-08:00

1. What different you are making it
2. Fixed bidding and Time & Material
3. Explained information is not generated
4. Concise presentation

Business Focusing on three parameters to be in the market with successes

Clients
Vendors
Competitors

Based on Dr Bernice Mc'carthy 4 W's approach for business

10% why is it so important
40% what are the goals and objectives
40% how can achieve and what is the approach or process
10% what if

1. Why is the Primary and important to the business
2. What is important as a secondary for senior manager
3. How is the approach/process by the project manager>>project leaders>>Team leads and members.
4. What if Benefits(problem analysis and finance)

Agressive
Recursive>>Run away

Act on Stress based on the 4 years is difference from 14 years
Inner child ego (shame)-4 to 6 years
Outer Adolscent Ego(guilty) Anger to be controlled
Adult Ego

Adolescent Ego between minimize fight and guilty of the behavour

Child Ego between minimize fight and shame of the identity

Empathy >> Comparison

Guilty

Generalization you always (Archetypal victim)

Distortion

Deletion

Collude victim

Hero Victim

Karpman Triangle - Persecutor>>Rescue>>victim

Challenges while executing the test cases for large project

2015-08-23T09:15:00.001-07:00

Defects are in Closed status but the test scripts in either Not Completed or Failed or Blocked Status. Based on the conversation with Program Director regarding this, we have followed this method to get more productivity

Identify the defects which are closed and find the linked test scripts. Moved those to No Run status by updating the comment section in the test plan>>Run suite.

Identified the test scripts which are in the Not completed status for more than two or three days

Check the test steps status and if there is an update on those ie more than 50% of the test steps has been executed in that case need to check with the concerned tester for further update.

Else move the test script to no run status.

Possibility of no action on the test scripts due to concern tester is moved out of the portfolio or left the company or not feeling well or any emergency

Defect is in "closed" status, so the test script is moved to "No Run" status to re-run.

Daily Status Report update.

1.　　　　　　 Who are all stakeholders

2.　　　　　　 Which stakeholder needs what data

3.　　　　　　 Collect the information from the all stakeholder interested on

4.　　　　　　 Create a template and share with the stakeholders to get the signoff.

5.　　　　　　 If there is a need to improve or change in the reporting style, need a confirmation from the Business/TCS Managers.

Daily status report : Information Interested on : Ideal Scenario: All test cases/scripts are passed and all defects to be closed before the EOD of test execution cycle.

1.　　　　　　 How much work is completed/how much is pending

2.　　　　　　 Whether we can complete the task in time

3.　　　　　　 What is the percentage of the pass test scripts when compared to the base line plan

4.　　　　　　 Execution plan vs Actual Plan ie Baseline plan VS Forecast plan(have we complete the execution as per the plan, else how much is pending + how much needs to be completed tomorrow= is our target to complete)

5.　　　　　　 Execution plan VS Passed execution Actual

6.　　　　　　 Note: Rework is not interested by the client but as consultancy services we need to take care of this effort (Retest effort, rework effort, number of times executing the failed test scripts,

7.　　　　　　 What is the efficiency of test scripts/application development

8.　　　　　　 Overall/Cumulative test execution summary report: Number of test cases executed: Passed + Failed, number of descoped, No-run and Not completed

9.　　　　　　 Detailed information on each application

10.　　 Detailed information on each application/each module wise

11.　　 Overall Execution percentage (passed +Failed Test Scripts), Overall Completion percentage(passed Test Scripts)

12.　　

13.　　

Defect Reporting:

Always managers/Stakeholders are interested to see the product with defect free.

1.　　　　　　 Application vs Defects Severity

2.　　　　　　 Application vs Defects Status

3.　　　　　　 Application vs Defects aging

4.　　　　　　 Defects Severity vs Defects Status

5.　　　　　　 Application vs open defects (Apart from Closed defects, rest of all the status will be moved to open defects).

Analysis on Test Steps for Execution plan.

1. Count the number of Clicks, Enters and validation/verify

2. Count the number of test Steps

3. Number of test cases, calculate the risk of the module

Analysis on Execution plan

What is the percentage of the execution is passed

What is the percentage of the execution can be achieved

What is the forecast plan of the work to be achieved to complete the daily target.

What is the execution percentage (Passed + Failed)

What is the completion percentage(Passed)

What is Descoped test scripts: Features not to be tested, Out of scope features

What is blocked test scripts: Due to defect, due to dependency on the external application, due to the data dependency, due to time dependency

What is not completed test scripts: which may be able to complete or continue the execution due to data security.(Data protection act).

Ultra Testing: Business end users who is going to consume the application can be validated in any phase of the testing.

To find the defects at early stages and track those defects in the Test management/Defect tracking system for further analysis between the business Analysers and Designers.

Analysis on Execution plan

2015-07-25T16:18:00.000-07:00

Daily Status Report update.

1. Who are all stakeholders

2. Which stakeholder needs what data

3. Collect the information from the all stakeholder interested on

4. Create a template and share with the stakeholders to get the signoff.

5. If there is a need to improve or change in the reporting style, need a confirmation from the Business/TCS Managers.

Daily status report : Information Interested on : Ideal Scenario: All test cases/scripts are passed and all defects to be closed before the EOD of test execution cycle.

1. How much work is completed/how much is pending

2. Whether we can complete the task in time

3. What is the percentage of the pass test scripts when compared to the base line plan

4. Execution plan vs Actual Plan ie Baseline plan VS Forecast plan(have we complete the execution as per the plan, else how much is pending + how much needs to be completed tomorrow= is our target to complete)

5. Execution plan VS Passed execution Actual

6. Note: Rework is not interested by the client but as consultancy services we need to take care of this effort (Retest effort, rework effort, number of times executing the failed test scripts,

7. What is the efficiency of test scripts/application development

8. Overall/Cumulative test execution summary report: Number of test cases executed: Passed + Failed, number of descoped, No-run and Not completed

9. Detailed information on each application

10. Detailed information on each application/each module wise

11. Overall Execution percentage (passed +Failed Test Scripts), Overall Completion percentage(passed Test Scripts)

12.

13.

Defect Reporting:

Always managers/Stakeholders are interested to see the product with defect free.

1. Application vs Defects Severity

2. Application vs Defects Status

3. Application vs Defects aging

4. Defects Severity vs Defects Status

5. Application vs open defects (Apart from Closed defects, rest of all the status will be moved to open defects).

Analysis on Test Steps for Execution plan.

1. Count the number of Clicks, Enters and validation/verify

2. Count the number of test Steps

3. Number of test cases, calculate the risk of the module

Analysis on Execution plan

1. What is the percentage of the execution is passed

2. What is the percentage of the execution can be achieved

3. What is the forecast plan of the work to be achieved to complete the daily target.

4. What is the execution percentage (Passed + Failed)

5. What is the completion percentage(Passed)

6. What is Descoped test scripts: Features not to be tested, Out of scope features

7. What is blocked test scripts: Due to defect, due to dependency on the external application, due to the data dependency, due to time dependency

8. What is not completed test scripts: which may be able to complete or continue the execution due to data security.(Data protection act).

Ultra Testing: Business end users who is going to consume the application can be validated in any phase of the testing.

To find the defects at early stages and track those defects in the Test management/Defect tracking system for further analysis between the business Analysers and Designers.

HP QC SQL Queries

2015-07-01T23:35:00.006-07:00

Test-lab:

SELECT CY_CYCLE AS "Test Set",
       TS_NAME AS "Test Script Name",
       TC_ACTUAL_TESTER AS "Tester",
       TC_STATUS AS "Execution Status",
       LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10) AS "Execution Date"
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleid)

Test-Summary:

SELECT CY_CYCLE,
       TC_STATUS,
       COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleid)
GROUP BY CY_CYCLE, TC_STATUS
ORDER BY CY_CYCLE, TC_STATUS

Run-rate:

SELECT CY_CYCLE,
       TC_ACTUAL_TESTER,
       TC_STATUS,
       LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10),
       COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND   TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleid)
GROUP BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_DATE
ORDER BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_DATE

Bottom-Line:

SELECT TC_STATUS,
COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleid)
GROUP BY TC_STATUS
ORDER BY TC_STATUS

Defects:

SELECT BUG.BG_BUG_ID AS "Defect ID",
BUG.BG_USER_03 as "Application",
BUG.BG_SUMMARY AS "Summary",
BUG.BG_DETECTED_BY AS "Detected by",
LEFT(CONVERT(VARCHAR,BUG.BG_DETECTION_DATE,20),10) AS "Detected on",
BUG.BG_RESPONSIBLE AS "Assigned To",
BUG.BG_SEVERITY AS "Severity",
BUG.BG_PRIORITY AS "Priority",
BUG.BG_STATUS AS "Status",
BUG.BG_USER_01 AS "Test Environment",
BUG.BG_USER_02 AS "Test Phase",
BUG.BG_USER_09 AS "Root Cause"
FROM BUG
WHERE BUG.BG_DETECTED_IN_RCYC = 0028
/*AND BUG.BG_USER_01 = 'SIT'*/
AND BUG.BG_USER_02 = 'SIT'
ORDER BY BUG.BG_BUG_ID

HP ALM-QC Daily report extraction

2015-06-27T17:08:00.003-07:00

SIT Test Lab will extract the Test Set, test case name, executed on, Executed by and it status.

SELECT CY_CYCLE AS "Test Set",
TS_NAME AS "Test Script Name",
TC_ACTUAL_TESTER AS "Tester",
TC_STATUS AS "Execution Status",
LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10) AS "Execution Date"
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (Cycleids)

High level summary of the metrics

SELECT CY_CYCLE,
TC_STATUS,
COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleids)
GROUP BY CY_CYCLE, TC_STATUS
ORDER BY CY_CYCLE, TC_STATUS

SIT Execution Rate/Run Rate

SELECT CY_CYCLE,
TC_ACTUAL_TESTER,
TC_STATUS,
LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10),
COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (Cycleids)
GROUP BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_DATE
ORDER BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_DATE

Cumulative execution summary on daily basis.

SELECT TC_STATUS,
COUNT(TS_NAME)
FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND CY_CYCLE_ID IN (cycleids)
GROUP BY TC_STATUS
ORDER BY TC_STATUS

Defect report extract based on the field needed

SELECT BUG.BG_BUG_ID AS "Defect ID",
BUG.BG_USER_03 as "Application",
BUG.BG_SUMMARY AS "Summary",
BUG.BG_DETECTED_BY AS "Detected by",
LEFT(CONVERT(VARCHAR,BUG.BG_DETECTION_DATE,20),10) AS "Detected on",
BUG.BG_RESPONSIBLE AS "Assigned To",
BUG.BG_SEVERITY AS "Severity",
BUG.BG_PRIORITY AS "Priority",
BUG.BG_STATUS AS "Status",
BUG.BG_USER_01 AS "Test Environment",
BUG.BG_USER_02 AS "Test Phase",
BUG.BG_USER_09 AS "Root Cause"
FROM BUG
WHERE BUG.BG_DETECTED_IN_RCYC = 1028
/*AND BUG.BG_USER_01 = 'SIT'*/
AND BUG.BG_USER_02 = 'SIT'
ORDER BY BUG.BG_BUG_ID

Duplicate test scripts/cases were extracted from the project.

select rcyc_id as cycle_id, cycle_name,
cy_cycle_id as test_set_id, cy_cycle as test_set_name, test_id, ts_name
from testcycl t
join cycle on cy_cycle_id = tc_cycle_id
join (
select rcyc_id, rcyc_name as cycle_name, tc_test_id as test_id
from release_cycles
join testcycl on tc_assign_rcyc = rcyc_id
-- where rcyc_name = 'MY CYCLE NAME'
group by rcyc_id, rcyc_name, tc_assign_rcyc, tc_test_id
having count(tc_test_id) > 1
) multi on test_id = t.tc_test_id and tc_assign_rcyc = rcyc_id
join test on ts_test_id = t.tc_test_id
order by 2, 6, 5, 4

HP QC-ALM Reporting Queries

2015-06-27T17:01:00.001-07:00

Duplicate_TestScripts_TestLab

select rcyc_id as cycle_id, cycle_name,
cy_cycle_id as test_set_id, cy_cycle as test_set_name, test_id, ts_name
from testcycl t
join cycle on cy_cycle_id = tc_cycle_id
join (
select rcyc_id, rcyc_name as cycle_name, tc_test_id as test_id
from release_cycles
join testcycl on tc_assign_rcyc = rcyc_id
-- where rcyc_name = 'MY CYCLE NAME'
group by rcyc_id, rcyc_name, tc_assign_rcyc, tc_test_id
having count(tc_test_id) > 1
) multi on test_id = t.tc_test_id and tc_assign_rcyc = rcyc_id
join test on ts_test_id = t.tc_test_id
order by 2, 6, 5, 4

Number of Test Steps Count for not passed status.

SELECT CY_CYCLE AS "Test Set",
TS_NAME AS "Test Script Name",
TS_STEPS as "Test Steps", /*Test.Steps*/
TC_ACTUAL_TESTER AS "Tester",
TC_STATUS AS "Execution Status",
LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10) AS "Execution Date"

FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND TC_STATUS <> 'Passed'
AND CY_CYCLE_ID IN ( cycleid)

Number of Test Steps Count for passed status.
By this, calculate the Average number of test steps can be executed per day.

SELECT CY_CYCLE AS "Test Set",
TS_NAME AS "Test Script Name",
TS_STEPS as "Test Steps", /*Test.Steps*/
TC_ACTUAL_TESTER AS "Tester",
TC_STATUS AS "Execution Status",
LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10) AS "Execution Date"

FROM TEST, TESTCYCL, CYCLE
WHERE CY_CYCLE_ID = TC_CYCLE_ID
AND TS_TEST_ID = TC_TEST_ID
AND TC_STATUS = 'Passed'
AND CY_CYCLE_ID IN ( cycleid)

Defects are in Closed Status but the test scripts/cases were in not passed status.
SELECT t.LN_BUG_ID as "Defect ID",
BUG.BG_USER_03 AS "Application",
BUG.BG_PRIORITY AS "Priority",
t.BlockedScripts AS "No. Of Blocked Test Cases",
BUG.BG_USER_06 AS "Estimated Fix Date",
BUG.BG_DETECTION_DATE AS "Opened Date",
BUG.BG_STATUS AS "Current Status",
BUG.BG_RESPONSIBLE AS "Assigned To",
BUG.BG_SUMMARY AS "Summary",
BUG.BG_USER_05 As "Process Stream"
from bug, (
SELECT LN_BUG_ID,
COUNT(LN_ENTITY_ID) AS 'BlockedScripts'
FROM LINK
WHERE LN_ENTITY_TYPE = 'TESTCYCL'
AND LN_BUG_ID in (
SELECT BG_BUG_ID
FROM BUG
WHERE BG_STATUS = 'Closed'
AND BUG.BG_DETECTED_IN_RCYC = 1028
/*AND BUG.BG_USER_01 = 'SIT' */
AND BUG.BG_USER_02 = 'SIT')
GROUP BY LN_BUG_ID
HAVING COUNT(LN_ENTITY_ID) > 1) as t
where t.LN_BUG_ID = bug.bg_bug_id
order by 4 desc

Defects are in Closed Status but the test scripts/cases were in blocked status.

SELECT LN_BUG_ID as "Defect ID",
COUNT(LN_ENTITY_ID) AS '# BLOCKED SCRIPTS'
FROM LINK
WHERE LN_ENTITY_TYPE = 'TESTCYCL'
AND LN_BUG_ID in (
SELECT BG_BUG_ID
FROM BUG
WHERE BG_STATUS = 'Closed'
--WHERE BG_STATUS <> 'Closed'
/*Defect.Detected in Cycle and BUG.BG_DETECTED_IN_RCYC = 'SIT 2015 Cycle 1')*/
AND BG_USER_02 = 'SIT'
and LN_BUG_ID >3310)

GROUP BY LN_BUG_ID
HAVING COUNT(LN_ENTITY_ID) >= 1
ORDER BY 2 DESC

Defects which are failed in retest will be moved into Reopen status. Those defects needs to be tracked to provide the root cause analysis.
SELECT
BUG.BG_BUG_ID as Defect_ID,
BUG.BG_STATUS as Status,
BUG.BG_SUMMARY as Summary,
/*AUDIT_PROPERTIES.AP_FIELD_NAME,*/
AUDIT_PROPERTIES.AP_OLD_VALUE,
AUDIT_PROPERTIES.AP_NEW_VALUE
FROM BUG, AUDIT_LOG, AUDIT_PROPERTIES
WHERE AUDIT_LOG.AU_ENTITY_ID = BUG.BG_BUG_ID and AUDIT_LOG.AU_ENTITY_TYPE = 'BUG' and AUDIT_PROPERTIES.AP_ACTION_ID = AUDIT_LOG.AU_ACTION_ID and AUDIT_PROPERTIES.AP_FIELD_NAME = 'BG_STATUS' and AUDIT_PROPERTIES.AP_OLD_VALUE = 'Retest Failed' and BUG.BG_BUG_ID > X /*(Defect id is greater than X)*/

Don't run the project, so it is assigned to you. Follow the standard, process to complete.

2015-03-23T03:16:00.002-07:00

Project Manager gave the project plan at the end stage of the project.

With the given dates, Testing team has to build the test execution plan.
I saw lot of problems and wastage of the effort in doing the testing.

Because IT/SIT/UAT all these environments doesn't have the valid test data to test.
PPE you will have to do the testing in full fledged where there is a limitation of space. So we will be testing the sample test data.
Based on the given plan, Testing team has to execute parallel in all three env.
Lot of rework for the development and testing team.(Wastage of time)

Note:
1. If you are not assigned to the project. Don't work on that project, simply screw the other person work.
2. If you don't have knowledge on testing/development/Build works, Shut your mouth.

Appraisal Talk

2015-03-21T01:17:00.003-07:00

Appraisal Talk

First Managers will start with three points stating ,
1. how long working with current account (They should know, account has project which needs a resources for that position we got filled)
2. Do you have any complaints from the clients/ managers regarding the work.
As you all know, Managers like his empire. If you do great things he will not be able to see those achievements because it is covered his circle or friends or relatives or disciples etc.. later you will come...So you last this appraisal.
3. Scope of work
Manager explains in your last project you may be scientist but your current position is test manager.

Any manager should understand, he crossed the same appraisal discussion when he is young or in hos carrier.

Scientist always a scientist whatever the opportunity is whether it is small project or big project or scope of the work. Scientist always be a creative.

My grandma says "Lion is king of animals whether it is Forest, Zoo or Circus) It will eat non-veg"

Note: Manager use one more point i.e. This client is very tough they are very specific, so you will not face them directly anything is needed you need to send it to me later i will get those details from them.

They should understand whether we are working with Human beings or not.
All the clients are Human Beings but every one wants to save their ASS. Due to their carrier growth they will play some politics between them. In that they will use as coins.

Note: They also work for the Success of the project only and recognition.

About Test Data

2015-02-06T06:45:00.002-08:00

Test data is needed for Testing an application/product.

What are the different types of test data?
There are four different types of test data
1. Synthetic test data or some call as Artificial test data: Which is created by the testing team with minimal knowledge on Business domain and may not able to replicate as production data.
Eg: SSN number and account number: Which is secured numbers which testing team know the size of the SSN number so team provides 9 digits to test it. Similarly the account number based on the bank size of the account number will be defined. With the help of Business analyst team create the account number but the same account number will be used n number of test cases.

2. Pre-production test data: Where the data is extracted from the Production and it will be processed and pushed the testing env for testing the application.
This test data is very useful and provides clear testing of an application.

Where we can get the test data?
Who can provide the test data?
What are the steps to be take care before using the test data?

Continued...

Business Responsibilities

2012-03-28T16:43:00.001-07:00

1. Deal directly with customers on daily basis
a. Face2Face
b. web conference or video conference
c. Telephone
d. electronically ie email, chat
2. Respond to the customer promptly and answer the queries
3. On regular basis verify the customer satisfactions
4. Communicate and Coordinate with internal low level teams on surprise visits
5. Communicate with high level team on regular basis
6. Issues to be recorded and resolution to be provided
8. Keep records of interactions and transaction details.
9. Always keen on what you need to do ......not to be depended
10. Networth transactions to be validated regularly
11. Business Knowledge and product knowledge is required.
12. Data collections and keep looking for opportunity for growing
13. Share the information and listen to the other business owners about gain and loss.
14. Keen on process improvement and account growing.

Driving test in india

2012-01-19T21:52:00.001-08:00

Driving Written Test :

When you come to a stop sign, you must stop your vehicle :

n As close to the stop sign as possible.

n At place near the intersection providing you come to a complete stop.

n At marked stop line, before entering the crosswalk, or before entering the intersection if there is no crosswalk.

When headlight are required, they should be dimmed at least 500 feet before meeting and 300 feet before overtaking another vehicle.

n True

n False

When driving along the highway and the front wheel of your vehicle runs off the pavement, you should :

n Quickly swing back onto the pavement at your normal speed.

n Grasp the steering wheel tightly & take your foot off the accelerator.

n Apply the brakes immediately and swing the back onto the pavement quickly.

Most rear end collisions are caused by :

n Dangerous road conditions.

n The vehicle in front stopping too fast.

n The vehicle in back following too closely.

Which of the following in the single greatest factor in fatal motor vehicle accidents ?

n Alcohol

n Mechanical problems

n Bad weather conditions

n Bad road conditions

When a right turn against a red signal light is allowed, the proper way to make the turn is to :

n Stop. Give right-of-way to any persons or vehicles within the intersection, then cautiously make the turn.

n Turn quickly to get out of the way of other vehicles.

n Stop. Sound your horn to warn other traffic, then make your turn.

After consuming alcohol, time is only effective way to remove alcohol from the body.

n True

n False

When passing another vehicle, you should not cut back into the right lane until you can see the vehicle that you just passed in your rearview mirror.

n True

n False

When a school bus is stopped on two-lane highway and its red warning lights are flashing and its stop signal arm is extended, you just :

n Slow down, sound your horn and pass the bus with caution.

n Stop your vehicle before reaching the bus.

n Pass the bus on the left if there are no vehicles approaching from the opposite direction.

A person may never drive a motor vehicle (even if borrowed or rented for a short period of time) unless the operator holds a valid drivers license which is properly classified for that kind and type of vehicles.

n True

n False

When there are flashing signals at a railroad crossing and the clears the crossing, how soon you should proceed ?

n Follow the vehicle ahead of you.

n After you check to make sure another train is not approaching on another track.

n Just as soon as the train clears the crossing.

When a two-lane pavement is marked with a single, solid yellow line on your side of the center line :

n Construction work is going on ahead, slow down.

n You must not cross yellow line to pass another vehicle.

n You must slow down and proceed with caution.

Which of the following laws and safety rules apply to bicyclists ?

n Bicyclists should travel in the opposite direction of other vehicles.

n The safest hours for operation are during times of poor visibility.

n Bicyclists are entitled to the same right-of-way as other vehicle.

When asking a left or right turn in a business or residential district, a continuous signal to turn must be given :

n Not less than 100 feet before turning.

n Only when vehicle are coming toward you.

n At least 50 feet from the intersection.

When an authorized emergency vehicle is using its siren and flashing lights approaches your vehicle, you should :

n Increase your speed.

n Continue at the same speed.

n Pull over to the right hand edge of the highway and stop, if possible.

If your vehicle starts to skid on water (hydroplane), you should :

n Take your foot off the accelerator and let your vehicle slow down.

n Turn your wheel slightly to the right and brake gently.

n Turn your ignition off and coast to a stop.

If you are convicted of passing a school bus that is receiving or discharging passengers. You may lose your drivers license for at least 30 days.(3 months)

n True

n False

The road surface of a bridge may be dangerous in winter because :

n The bridge surface is warmer.

n There may be ice on bridge even when other pavements are clear.

n Neither of these.

A flashing red traffic signal light a an intersection means:

n An emergency vehicle is approaching from your rear.

n You should be careful when going to the intersection.

n Exactly the same thing as a stop sign.

It is permissible for you to pass on the shoulder of the road.

n True

n False

When required to stop at railroad crossing, vehicle must stop,

n within 25 feet, but not less than 15 ft from the nearest railroad crossing.

n Within 50 feet, but not less than 15 feet from the nearest railroad crossing.

n Within 75 feet, but not less than 25 feet from the nearest railroad crossing.

n Within 100 feet, but not less than 50 feet from the nearest railroad crossing.

In order to reinstate full driving privileges after a DRIVING UNDER THE INFLUENCE (DUI) revocation, a person must:

n carry high-risk auto insurance for three year.

n Be approved for reinstatement by a Secretary of State Hearing Officer and pay a $ 60 reinstatement fee.

n Submit to a professional assessment of alcohol and/or drug use and attend a remedial or rehabilitation program.

n Wait for the one year.

n All of the above.

IT is unlawful for any person to leave the roadway and travel across private property to avoid an official control devices.

n True

n False

When driving an a slippery road and the rear end of your vehicle starts to skid, you should :

n Apply brake gently

n Turn the front wheel in the direction of the skid.

n Hold the wheel firmly and steer straight ahead, braking gradually.

When a traffic light shows both a red light and a green arrow in the direction you wish to turn, you :

n Have the right-of-way over pedestrians in turning in the direction of the arrow.

n May proceed in the direction of arrow with caution.

n Must stop and remain stop until the red light has changed.

The 2-seacond Rule works like this when the vehicle ahead of you passes a fixed object like a tree etc., if you begin counting “ One thousand one, One thousand two “ then if you reach the same tree before you have finished saying :one thousand two”, you are following too closely .

n True

n False

Illinois law requires children under age 6 to be secured by a restraint system or seat belt when traveling in a motor vehicle:

n In the front seat only.

n Anywhere in the vehicle

n In the back seat only

n Never, this is not a law.

28. A diver moving out of a alley, privet road, or driveway within an urban area must :

n Sound your horn and exit quickly.

n Stop only if there are vehicles coming down the street.

n Stop before reaching the sidewalk and yield to pedestrians and vehicle before proceeding.

If you most drive during the foggy weather, you should turn on the low-beam headlight and :

n flash your lights routinely.

n Keep your foot on the brake pedal so your tail lights will be seen more easily.

n Drive at a speed that will allow you to stop within your field of vision.

When approaching a blind pedestrian carrying a white cane or accompanied by a guide bog:

n you may pass of you slow down and sound the horn.

n You must yield the right-of-way.

n You may pass if there are no vehicles approaching from the opposite direction.

Motorcycles , though smaller & lighter in weight, have the same right-of-way privileges as other vehicles, Special observance should be given to motorcyclists when they approach an intersection, a railroad crossing , bridge or when bad weather occurs.

n True

n False.

When you are driving and one of the tire has a blowout , you should :

n Quickly steer onto the right shoulder.

n Apply the brakes quickly to reduce speed.

n Grip the steering wheel firmly, take your foot off the gas pedal, and let the vehicle slow down before you drive onto the shoulder.

The driver and front seat passengers (age 6 and above) are required to wear seat safety belts while riding in a motor vehicle on Illinois roadways. Vehicles are subject to:

n $75 fine plus court cost.

n Suspension of their driver’s license.

n A $25 fine plus court cost.

n None of the above

You are waiting at an intersection and the traffic signal light changes to green. You may then go ahead :

n When you think it is safe to do so.

n After first yielding the right-of-way to any persons or vehicles which are within the intersection.

n Immediately

A person who REFUSES to subject to a chemical test of his/her blood, breath of urine,for the purpose of determining the level of alcohol and/or drug contents :

n Will receive a drivers license suspension for 12 months for second offender within 5 year period.

n May have this used as evidence against his/her in court if charged with DRIVING UNDER THE INFLUNCE of alcohol and/or drugs. (DUI)

n Will receive drivers license suspension for six months on first offence.

n All of the above.

Your driving privileges will be revoked in the State of Illinois if you are convicted of :

n Drug racing .

n Driving or being in actual physical control of a vehicle while under the influence of alcohol or other drugs (including prescription drugs which may affect driving ability)and/or combinations, thereof.

n Leaving the scene of an accident in which you are involved as a driver, if the accident results in death or personal injury.

n None of the above

n All of the above.

When approaching a railroad grade crossing which does not have any warning systems (such as electric flashing lights or gates) you should :

n continue at your normal speed.

n Look, listen, slow down in case you have to stop, and proceed when safe to do so.

n Increase Speed and cross tracks as quickly as possible.

Unless posted otherwise, it is permissible for drivers on one-way street to turn left on a red light into another one-way street that moves traffic to the left after making a proper stop and yielding to traffic or pedestrians within the intersection .

n True

n False

Motorcycles are entitled to use the fuel width of a traffic lane, the same as a vehicle. Therefore, when you are driving a vehicle and want to pass a motorcycle, you should:

n Follow the motorcycle without passing it.

n Cautiously pass the motorcycle, sharing the same lane it is using.

n Not to pass the motorcycle in the same lane that it is using, but change lanes and pass the way you would pass another vehicle.

Your driver license will be suspended if: after arrested for DRIVING UNDER THE INFLUENCE of alcohol and/or drugs (DUI)

n You take a chemical test (breath, blood or urine) and register an amount equal to or over the legal level intoxication(.10%)

n You refuse to take a chemical test (breath, blood or urine).

n You take a chemical test and register a .04%.(provided your driving ability impaired.

n A and B are correct.

n All of the above.

Looking for ideas

2011-10-10T07:17:00.000-07:00

To start new career: You name it anything you start is mainly for money.
Even if you want to start a charity, it needs money.... Baseline is money.

You need to think before you start. Once you started don't stop it immediately thinking you are in loses.

For Successes, people say “Due to luck he has achieved”
For Failure, Same people say “he doesn’t know how to handle the situation”
Example: In Indian cricket, if the person is out in that moment everyone start commenting he has to put defense, someone will say he can hit ball. These people, why they were not selected in the Indian team?

A Journey towards Sun Rise

2011-09-28T21:25:00.000-07:00

Life Builder Toast Master Club:

A Journey towards Sun Rise

I found I needed time to draw away to heal, process through the loss, and reflect on the impact of these experiences. I am thankful my loved ones are no longer in pain, but I am honest enough to say I wish I could still enjoy their company, see their smile, hear their laugh. And while I know God has been with me on this journey, I confess there have been some days of deep sadness, the sting of loss, and some moments of darkness. But now, I'm beginning to see the sun rise again.

The peace of God has brought comfort to me. Happiness has returned to my heart.

Because of the tender mercy of our God,

whereby the sunrise shall visit us from on high

to give light to those who sit in darkness and in the shadow of death,

to guide our feet into the way of peace

Each practical step along the Journey to Sunrise includes:

A straightforward destination
Reflections of actual career transition Journey
Specific insights/action items that you can apply to your Journey
private journaling tool for your personal thoughts and feelings
Inspirations and testimonies (Success and Failures of pervious experience)
A way to share YOUR spontaneous inspirations with others

Journey to Sunrise will guide you through the 8 phases of career transition:

Acceptance
Faith
Finances
Relationships
Self-Discovery
Dedication
Expectation
Victory

Note: It will talk about the Indian Goddess Maha Lakshmi.

Ashta Lakshmi Stuti - For Wealth, Fortune and Prosperity. ** Lakshmi is known in eight different forms called ashtalaksmi (8 forms of lakshmi) Adi Lakshmi, Aishwarya Lakshmi, Dhana Lakshmi. Dhanya Lakshmi. Gaja Lakshmi, Santana Lakshmi, Veera Lakshmi, Vijaya Lakshmi. ** Lakshmi is the goddess of light, beauty, good fortune and wealth. Being the consort of Vishnu, the preserving principle, Lakshmi also signifies love and grace. Lakshmi often expresses her devotion to Vishnu by massaging his feet as he lies on the coils of the snake Shesha. While Lakshmi is generally worshipped to achieve success, she does not reside long with anyone who is lazy or desires her only as wealth.

whatever you have to give me, you have to give me

2011-09-28T21:20:00.000-07:00

Life Builder Toast Master Club!

Good Evening Madame Contest Master, Fellow Toast Masters, Guest and Friends.
Welcome to Humorous Contest Speech, I am Madhu Dande from Life Builder Toast Master Club.

Today I will be sharing about the phrase “whatever you have to give me, you have to give me” We listen to this phrase in conservation between Boss and Team members. But I will share a short story about an Indian girl. There was beautiful family Father, Mother and daughter. Because of only daughter they share everything what she required more than that.

At the age of 4, her mom shouted against her doing some mischievous. In the evening father reached home and girl started weeping and explained dad, I don’t like your wife, either you can change her or you always get new things from walmart, and so can we get a new mom from walmart by swiping your credit card. That day, father and mother started laughing about that incident.

At the age of 12, her mom asked her to get some water to drink. She said I’m busy, can you please help yourself. Mother saw what she is busy? She is watching TV serial. Her mother got angry and hit with the stick. Immediately Girl called his dad office and asked operator can you please connect to my father? Operator asked number please, you idiot I have only one father not ten fathers and she dropped the call.

Her parents were giving a lot of freedom, so finally she is not listening to them. One fine day her mother got angry and started hitting with broom stick to complete any task and it continued on daily routine.

At Certain age, she has to get married to someone. Her parents saw an alliance and her mom told to that girl about last advice. In our Indian custom husband has to eat first, later you can have it. Thanks mom for your advice Girl said. I got it, what you mean! I learnt cooking from you, so he can have first and if he survives then I will have it. So that I can avoid killing myself by having the food I prepare.

After marriage she stays with her in-laws, days are running but she is not supporting any work in the house. Mother-in-law called her to help her in cutting vegetables, she said “whatever you have to give me, you have to give me” Mother-in-law thought she was afraid of cutting vegetables because she is only child for their parents. Similarly it is happening between the girl and Mother-in-law.

One fine day, mother-in-law is not feeling well and asked her to clean the vessels. She said the same thing as earlier. Mother-In-law got angry and threw the broom stick on her, immediately she did the cleaning for that day.
Once again the same story, Mother-in-law asked her to clean the house. She said the same as earlier.
Mother-In-Law got pissed off and called their in-laws and explained about their daughter. Her mother said, don’t worry. Whenever some work has to be done, you need to hit with the broom stick so that she can complete her task. Mother-in law said “That means every day, I need to do a follow-up for all my activities and also I need to increase the funds to buy broom sticks.

Now the situation got changed, every day there is fight between Mother-in-law and Girl. Neighborhood friend called girls husband and asked Why every day your wife and your mother fight?
Whenever your wife and mother fighting on which side you will stand, asked neighbor. Again he insists to ask the same question, he said I’m standing behind the wall. Because there is chance in fight both will throw items on me then I will be hospitalized. So prevention is better than cure formula I’m using.

Phrase of Indian poet “To be able to laugh is a blessing, to make others laugh is an art and to be unable to laugh is a disease”

Please laugh every day for atleast 10 min by readying the comic books, watching the comedy stories or movies, watch cartoons atleast listen to jokes.

Hope you all liked and enjoyed this. Laughter boosts your brain systems, lessens pain, reduces stress and lowers blood pressure. “A smile is a curve that sets everything straight.” Keep Smiling and Live Longer.
Thank you, Madame Contest Master!

Trust yourself before trusting others

2011-09-28T21:19:00.001-07:00

Life Builders Toast Master Club:

Trust yourself before trusting others

Brahmin who leaves in a village, he does all pujas for the people who lived in their village. Brahmin, he does the pujas from the child birth to death of a person and it includes the opening a new business, new house ceremony etc. He had good reputation in his village.

One day, he got a call from neighbor village to do some puja in their house. He did all formalities at that time, he saw a white goat. So the owner of the house gave the offereings to the Brahmin and also the goat. But the Brahmin took the goat and holding on his shoulder and started back to his village by walking. In the middle three friends they saw the Brahmin carriing the goat on his shoulder. They want grab this goat and they were not suppose to hurt him and threat him. They were planning how to grab the goat.

First person came to Brahmin and said Namasthe Swamiji. What is this you are carrying a Donkey on your shoulder, then Brahmin said that you illetrate don’t know the difference between the donkey and Goat. Offcourse both has four legs and one tail but it is different from one another.

Second person stop by the Brahmin and said Namasthe Swamiji!

Challenges in Onsite and Offshore model

2011-06-15T16:36:00.000-07:00

Generally for any model either it is offshore development center or onsite or onshore development center.

1. we need to have good coomunicator so that other part of the team can be able to understand the requirment clearly.
2. Team should have good understanding of their team mates
3. Always team should undergo the business knowledge training, it will be value added.
4. Onsite and offshore Connectivity
5. Application response time will be very slow
6. Application Stability
7. Documentation of understanding
8. For any formal or informal discussion about the project, need to be maintained in the MOM(Mins of Meeting).
9. Techinical Knowldge expert to be present as a part of the team
10. Commitment towards the work.

General Testing Practices

2011-06-15T16:24:00.001-07:00

General Testing Practices

Whenever possible, tests should be isolated and without system or user conflicts.
Retest should always be executed and fully documented when significant errors are found.
Review all scenarios and test cases with a functional expert prior to testing.
Explain Findings and provide backup documentation.
Define defect assignment and escalation workflow before test execution.
Review the Defects with all the stake holders on regular basis helps to ensure that all the defects are on track.
QA team and dev team should have Test Case review meeting before SQA which helps in synchronization and coordination of various QA activities and also minimize the defect rejection ratio.
Knowledge sharing sessions helps in getting awareness on other business process areas.
Maintaining a detailed KT Checklist which also covers transition pre requisites, application access, hands-on exposure followed by Exit Test.

Testing Documentation

2011-06-15T16:21:00.000-07:00

Documentation

1. Test Case Information should be extremely detailed and in simple language

2. Number each Test case – As described in the Test Plan.

3. Expected Result should be documented prior to testing for each Test Case.

4. Documents run times for all reports and processes.

5. Copy error exactly as they appear – screen shots are the best way to capture the error message.

6. Include the test case number in the screen shots File name.

7. Errors should stand out on Test plan ( use red to Highlight)

8. Web Testing – Document URL and Environment in the Test.

9. Be consistent with documentation throughout test plan(s)

10. Document logistics if appropriate

11. Document testers name on Test Plan.

Best Practices in testing

2011-06-15T16:19:00.001-07:00

Developing Test Cases

· Determine the Focus of the Test Before beginning.

· Create Test Scenarios – Follow the Application functionality when creating

· Scenarios should have multiple test cases tied to each.

· Positive Test Cases – Acceptable Input Data - Expected to Work

· Negative Test Cases – Unacceptable Input Data - Expected NOT to Work

· Creative Brainstorming Test Cases - Helps detect unexpected results

· Consider Risk Factors – Increase number of test cases for volatile areas of the systems, complex code, newly created code.

· Number of Test Cases – Average is 2 to 3 per function ( for Low to Medium Risk Factors)

Lessons learn't in Testing

2011-06-15T16:17:00.001-07:00

Lessons Learnt

· Know your domain

· Know your application

· Learn New Technologies, if needed

· You Can’t Guarantee a Bug Free Application

· Follow SDLC Process, for any development work

· Requirement review

· Code freeze and System build

· System Testing

· 100% Test Coverage is Not Possible

· Numbering of Test scripts

· Create a Test plan and Test coverage before Testing

· Think like an End User

· Test case review

· No assumptions in Testing

· Defect Tracking and reporting

· Having a single build for the project.

First speech in SFBLI-ToastMaster Club:- My Journey

2011-06-15T16:13:00.000-07:00

My Journey-----

I started my journey in the year of 1975 in Temple city Tirupati, Andhra Pradesh, India (Which is holy pilgrimage place for Hindus (it is the second place in generating the revenue in the world next ie next to Vatican City. First place in number of visitors, every day more than 100000 people within the visiting hours between 5:30 AM to 10:30PM. When I opened my eyes I saw my parents. They thought I will be as strong as I am and sought too, so I will be very active but myself too silent and looks like I’m lazy too. In India most of the Kids before one year itself they will take the Rice as food but myself till 5 years I haven’t had rice at all. For supplement, they started giving baby food ie Amul and Farex which is similar to Similac and Enfamil.

I started my education in Delhi which is capital city of India which is part of north-India, Where a person always speaks in Hindi language. I started communicating in Hindi after three years I left to my native which is Chittoor, ie south India Where people speaks Telugu , Tamil and Kanada because tri states connection point. But I’m unable to communicate with my Grand pa and Granny and my uncles of both sides neither mother side nor dad side relatives they don’t know Hindi. Similarly I don’t know any language apart from Hindi.
After few months I started my education in the little flower English medium high school and I started learning all the languages slowly and interacting with all people.

That is when I realized we don’t need to run to learn a new language, Time will teach you language, when it is needed.

About my family
My surname dande which means Warrior, all my ancestors served for the mother land and I am proud to say my Dad is an ex-service man. During his 16 years of continued service he was awarded Yudha seva medal for shot down the Pakistan helicopter in India-Pakistan war in the year 1971. He was in-charge of war tanker and hitting the targets.

If you look in top view, I came from rich and good background family but you look in direct view then reality is not the same. My family means Mom, dad and younger brother and sister. Though they are younger than me I always respect their views before taking any decision in my carrier. My marriage was an arranged marriage (decisions were taken by my parents). Until my marriage day that was on Mar-02-2006 I was not given a chance to meet my life partner. They just shared her photo which was taken six years back when she was in college, atlast I am happy they did not share her childhood photo.

My life partner Neelima and we are blessed with son (Shyam and I am sure soon he will start his journey first toast master speech, saying “I started my journey from Newyork, USA”.

About my Education and Carrier
I did my bachelor of science for three years and later joined B.Tech because there is completion to get into Engg College(to better foundation of my education) in the year of 1995 I got the rank of 9963 in state level exam. We belong to Forward community so we won’t able to get the seat ie for sure. Because my father is an ex-service man and he has awarded with a medal so I got the seat in Btech. I want to share a funny story behind how I landed in EEE, In India most of the people believe in Astrology similarly my father got an advice from some person and that person showed him bulb then my father decided to join me in EEE even though I got the seat in CSE I need to stay back in EEE.

Now he realizes that he shouldn’t trust in astrology for any decisions.

Later I joined the electrical company and moved to networking company and worked for IT companies but still something lagging in my carrier. My parents and my brother, sister were released that I need to continue my further studies Master degree, lot of hurdles to get seat in Mtech CSE.

I joined C-Dot which is India’s prestigious Telecommunication networking company and jumped into i2 technologies. Later I joined TCS-2003 TATA from that day to till date I am working with same organization but for different clients. In my journey recently landed on SFBLI. I like to continue my journey for different places with higher aspirations.