๐Ÿšจ

EXECUTIVE SUMMARY: 5 Immediate Actions Required

1. Terminate/reassign mahalakshmi.vasamsetti & thushara.prasad (0% credibility) | 2. Block same-minute EC claims | 3. Schedule Randstad Digital executive call | 4. Stop submissions to Innova, Valere, OSS, StackCraft | 5. Assign top performers as vendor owners

Revenue Recovery Projection

Based on 8,000 annual submissions
Current State
$930K
62 placements/year
3.29% interview rate
Month 3 Target
$1.8M
120 placements/year
+$870K revenue
Month 6 Target
$3.0M
200 placements/year
+$2.07M revenue
Month 12 Target
$4.8M
320 placements/year
+$3.87M revenue

Section 1: Individual Salesperson Actions

Week 1 Priority

๐Ÿ›‘ Immediate Action Required

mahalakshmi.vasamsetti 0.00% credibility
TERMINATE/REASSIGN
Evidence: 51 EC claims with ZERO interviews. Complete failure to convert any submission.
Action: HR meeting this week. Either terminate or reassign to non-sales role immediately. Every submission is wasted effort.
Owner: HR + Sales Director | Deadline: End of Week 1
thushara.prasad 0.00% credibility (new hire 2023)
TERMINATE
Evidence: 86 submissions in 2023 with ZERO interviews. Complete failure despite training period.
Action: Recommend separation. Not suitable for sales role based on complete inability to generate interviews.
sunil.nalli.inactive 0.79% credibility
PERFORMANCE REVIEW
Evidence: 127 EC claims, only 1 interview. Already marked inactive in system.
Action: Confirm inactive status. If returning, require intensive retraining before any submissions allowed.
sravan.kumar 1.55% credibility
30-DAY PIP
Evidence: 129 EC claims, only 2 interviews. Well below 5% minimum threshold.
Action: Issue 30-day PIP. Weekly check-ins with sales manager. Must reach 5% by end of PIP or separate.
Mentor: yogish.kosuru | Review Date: Week 2
pyarasanisai.prakash 2.17% credibility
COACHING + AUDIT
Evidence: 184 EC claims (high volume), only 4 interviews. Pattern suggests gaming behavior.
Action: Audit EC claim timestamps. Retrain on proper vendor communication process. Reduce volume, focus on quality.
vinod.boppana 0.78% credibility (new hire 2023)
2-WEEK INTENSIVE
Evidence: 128 submissions in 2023, only 1 interview. High volume but nearly zero conversion.
Action: Pair with yogish.kosuru for 2-week intensive. Review every submission before it goes out. Focus on quality vendors only.

๐ŸŒŸ Top Performers to Study & Reward

yogish.kosuru PLATINUM 12.56% credibility
STUDY & REWARD
Performance: 430 EC claims, 54 interviews. Highest credibility on the team. Consistent through collapse.
What He Does Right: Waits for vendor confirmation, strong Randstad relationship, focuses on Java/.NET roles, quality over quantity.
Action: Document his exact process for training materials. Assign as vendor owner for Randstad & Ursus. Bonus eligible. Use as mentor for struggling reps.
SaiChander.Gundu PLATINUM 12.42% credibility
STUDY & REWARD
Performance: 298 EC claims, 37 interviews. Second highest credibility. Specialist in Insight Global.
Action: Assign as vendor owner for Insight Global & Stone Resource. Pair with new hires for mentoring. Bonus eligible.
mohsin.khan 10.42% | GOLD
High volume sustainable (499 EC claims). Assign to ManpowerGroup & MethodHub.
basith.abdul 9.83% | GOLD
Stable through collapse. Assign to Systems Integration & Timber IT (premium partners).
Ishan.Jain 8.26% | GOLD
Good relationship builder. Assign to TEKsystems & Inabia.
sandeep.gandu 7.20% | SILVER
Growing performer. Assign to Robert Half & Beacon Hill.

Section 2: Vendor Recovery Strategy

Weeks 1-4

Priority 1: Vendors to Rebuild (Lost 500+ Interviews Combined)

Randstad Digital
Lost 211 interviews (350 โ†’ 139) | Rate: 35.32% โ†’ 8.31%
EXECUTIVE OUTREACH
Assigned Owner
yogish.kosuru
Sales Navigator Search
"Account Executive OR Sales Manager at Randstad Digital"
Action Plan: Week 1: VP schedules executive call with Randstad leadership. Acknowledge EC claim concerns directly. Propose transparency improvement. Week 2: Document action items and restart relationship.
Stone Resource, LLC
Lost 107 interviews (126 โ†’ 19) | Rate: 44.84% โ†’ 19.19%
ACCOUNT RECOVERY
Assigned Owner
SaiChander.Gundu
Key Contact
Use ZoomInfo to find Account Manager
Systems Integration Solutions
Lost 69 interviews (83 โ†’ 14) | Rate: 66.94% โ†’ 35.00%
PREMIUM PARTNER
Assigned Owner
basith.abdul
Note
Historically BEST converting vendor (67%!)

Priority 2: Growth Partners (Double Down on These)

Insight Global, LLC
+9 interviews | 25.53% rate
Owner: SaiChander.Gundu
Action: Double submissions to this vendor
Inabia Solutions & Consulting
+9 interviews | 31.75% rate
Owner: Ishan.Jain
Action: Expand relationship aggressively
Timber IT Consulting
53.13% rate (BEST!)
Owner: basith.abdul
Action: Premium partner - protect & grow carefully
MethodHub
19.61% rate
Owner: mohsin.khan
Action: Room for volume growth

STOP: Vendors to Blacklist (Zero Interview Rate)

Stop ALL submissions to these vendors immediately. 175 wasted submissions with ZERO return.

Innova Solutions
47 subs โ†’ 0 int
Valere Consulting
34 subs โ†’ 0 int
OSS, Inc
33 subs โ†’ 0 int
StackCraft
28 subs โ†’ 0 int
+ 8 more
See full list

Section 3: Salesperson-Vendor Relationship Assignments

Clear Ownership

Each vendor should have a clear owner who manages the relationship. Assignments based on credibility scores and historical performance.

Vendor
Primary Owner
Volume
Backup
Randstad Digital
yogish.kosuru
HIGH
mohsin.khan
Insight Global, LLC
SaiChander.Gundu
MEDIUM
Ishan.Jain
Ursus, Inc.
yogish.kosuru
MEDIUM
basith.abdul
Systems Integration Solutions
basith.abdul
LOW
yogish.kosuru
Timber IT Consulting
basith.abdul
LOW
SaiChander.Gundu
ManpowerGroup (Experis)
mohsin.khan
HIGH
Ishan.Jain
TEKsystems
Ishan.Jain
HIGH
mohsin.khan
Beacon Hill Staffing
sandeep.gandu
MEDIUM
basith.abdul
Inabia Solutions
Ishan.Jain
MEDIUM
SaiChander.Gundu
Robert Half International
sandeep.gandu
MEDIUM
mohsin.khan

Section 4: External Tools Integration Strategy

Sales Navigator + Dice + ZoomInfo
in
Sales Navigator
Find vendor contacts
Purpose: Identify new contacts at collapsed vendors, find decision makers
Week 1 Searches:
  • "Account Executive at Randstad Digital"
  • "VP Sales at Stone Resource"
  • "Talent Acquisition at Insight Global"
Weekly Quota: 20 new connections per salesperson
dice
Dice
Job market intel
Purpose: Monitor job trends, identify hot skills and growing companies
Weekly Searches:
  • .NET Core jobs posted last 7 days
  • Java Spring Boot $100+ rate
  • React TypeScript remote
  • Azure Data Engineer
Track: New postings matched to consultants
ZI
ZoomInfo
Contact enrichment
Purpose: Verify contacts, get direct phone numbers for outreach
Priority Lookups:
  • Randstad Digital leadership
  • Stone Resource decision makers
  • Growing vendor account managers
Monthly: Enrich all vendor contacts

Section 5: Phased Implementation Timeline

1
Emergency Triage
Week 1 | Owner: Sales Director
Freeze submissions to zero-interview vendors
Review mahalakshmi.vasamsetti account
Review thushara.prasad account
Block same-minute EC claims (Dev Team)
Schedule Randstad Digital executive call
Document yogish.kosuru process
Deploy monitoring dashboard
2
Process Reset
Weeks 2-4 | Owner: Sales Director
Issue PIPs to sravan.kumar, pyarasanisai.prakash
Intensive training for vinod.boppana, teja.majji
Vendor relationship owners assigned
Sales Navigator campaign started
Weekly credibility reports configured
Vendor tier list communicated
3
Relationship Rebuilding
Month 2-3 | Owner: VP Sales
Executive visits to top 5 collapsed vendors
Double submissions to growing vendors
Dice job market automation
ZoomInfo contact enrichment
New compensation model piloted
Bi-weekly vendor reviews
Success Criteria: 5 vendor relationships restored, 20% increase in growing vendor volume
4
Sustained Recovery
Month 4-6 | Owner: VP Sales
New compensation model rolled out
Automated gaming detection alerts
Monthly vendor health scorecards
Re-engage 507 missing consultants
QBRs with top 10 vendors
Target KPIs: Interview rate >8% | Stuck at EC <50% | Credibility avg >6%
5
Scale & Optimize
Month 7-12 | Owner: VP Sales
Predictive analytics for submission quality
AI-powered consultant-job matching
Automated vendor relationship scoring
Full process automation
Year 1 Target: Interview rate >12% | Stuck at EC <30% | Credibility avg >8% | 320 annual placements

Section 6: SQL Queries for Deep Analysis

Run in ATS Database

For detailed analysis, run the queries in AuraQuestionBank/db/SalespersonVendorRelationships.sql. This file contains 10 queries:

Query 1: Salesperson-Vendor Matrix
Who works best with which vendor?
Query 2: Best Salesperson per Vendor
Optimal owner for each vendor
Query 3: Growing Vendor Relationships
Who's working with growing vendors?
Query 4: Collapsed Vendor Relationships
Who was working with them before?
Query 5: Vendor Contact Info
Account manager details
Query 6: 507 Missing Consultants
Who didn't get submitted in 2023?
Query 7: New 2023 Hire Analysis
What vendors are they using?
Query 8: Top Performer Patterns
What are they doing right?
Query 9: End Client Analysis
Which end clients are still hiring?
Query 10: Active Job Requirements
Current opportunities to prioritize

Executive Summary: 12-Month Recovery Path

Interview Rate
3.29% โ†’ 15%
+356% improvement
Placement Rate
0.77% โ†’ 4%
+419% improvement
Stuck at EC
78% โ†’ 20%
-74% reduction
Annual Revenue
$930K โ†’ $4.8M
+$3.87M gain
Key Message: 60% of the collapse is self-inflicted (gaming, poor vendor relationships) and therefore fixable. Execute this plan to recover 320+ annual placements within 12 months.