{"totalEmployees":39,"totalClients":187,"totalProjects":708,"activeProjects":0,"projectsMissingPoNumber":688,"clientsMissingManager":128,"employeesByRegion":[{"label":"US","value":18},{"label":"EU","value":15},{"label":"APAC","value":5}],"employeesByCountry":[{"label":"US","value":9},{"label":"FR","value":3},{"label":"CH","value":2},{"label":"SG","value":2},{"label":"UK","value":2},{"label":"USA","value":2},{"label":"Czech Republic","value":1},{"label":"Ecuador","value":1},{"label":"United Kingdom","value":1},{"label":"United States","value":1}],"employeesByTitle":[{"label":"Contractor","value":6},{"label":"Director","value":6},{"label":"Managing Director","value":6},{"label":"Engagement Manager","value":4},{"label":"Senior Consultant","value":4},{"label":"Finance Director","value":2},{"label":"Managing Principal","value":2},{"label":"Senior Director","value":2},{"label":"Administrative Assistant","value":1},{"label":"Executive Managing Director","value":1},{"label":"Financial Accounting Analyst","value":1},{"label":"Global Events Manager & Sr. Marketing Assoc.","value":1},{"label":"Global Marketing Director","value":1},{"label":"Global Marketing Manager","value":1}],"employeesByTitleCode":[{"label":"CL4 - Director","value":7},{"label":"CL6 - Managing Director","value":6},{"label":"CL3 - Senior Consultant","value":5},{"label":"CL4 - Engagement Manager","value":2},{"label":"CL7 - Principal","value":2},{"label":"CL6 - Executive Managing Director","value":1},{"label":"ML2 - Global Events Manager & Sr. Marketing Assoc.","value":1},{"label":"ML2 - Global Marketing Manager","value":1},{"label":"ML5 - Global Marketing Director","value":1},{"label":"OL1 - Administrative Assistant","value":1},{"label":"OL1 - Finance Associate","value":1},{"label":"OL1 - Financial Accounting Analyst","value":1},{"label":"OL6 - Finance Director","value":1}],"newestHires":[{"id":"4614d83a-9c4d-46a6-a2fb-e8870b69081e","firstName":"Gurdip","lastName":"Dhariwal","fullName":"Gurdip Dhariwal","email":"gdhariwal@trascent.com","title":"Contractor","employeeRegion":"EU","supervisorName":"Rakesh Kishan","employeeCell":"","country":"","titleCode":"","hireDate":"2025-11-30","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"f0ee1d9b-8a19-46ed-ab27-a9c4196f3258","firstName":"Michael","lastName":"Joy","fullName":"Michael Joy","email":"mjoy@trascent.com","title":"Contractor","employeeRegion":"EU","supervisorName":"Rakesh Kishan","employeeCell":"","country":"","titleCode":"","hireDate":"2025-11-30","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"73b3b41a-813a-4b11-a61a-807ef0bf3dea","firstName":"Dharmesh","lastName":"Mahnot","fullName":"Dharmesh Mahnot","email":"dmahnot@trascent.com","title":"Contractor","employeeRegion":"APAC","supervisorName":"Rakesh Kishan","employeeCell":"","country":"","titleCode":"","hireDate":"2025-09-28","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"364cbfd8-5013-41da-a919-fee963c1440b","firstName":"Suteng","lastName":"Ni","fullName":"Suteng Ni","email":"sni@trascent.com","title":"Engagement Manager","employeeRegion":"APAC","supervisorName":"Sophie Hartmann","employeeCell":"","country":"","titleCode":"CL4 - Engagement Manager","hireDate":"2025-09-18","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"8d4507fb-428c-4f28-a814-359b896d4379","firstName":"James","lastName":"Katz","fullName":"James Katz","email":"jkatz@trascent.com","title":"Engagement Manager","employeeRegion":"US","supervisorName":"Rakesh Kishan","employeeCell":"","country":"","titleCode":"","hireDate":"2025-08-21","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"}],"longestTenuredEmployees":[{"id":"2867d22b-7ddc-46c6-a6a5-6d332130c34a","firstName":"Yvonne","lastName":"Liu","fullName":"Yvonne Liu","email":"yliu@trascent.com","title":"Global Marketing Director","employeeRegion":"US","supervisorName":"Rakesh Kishan","employeeCell":"-5239","country":"US","titleCode":"ML5 - Global Marketing Director","hireDate":"2009-02-15","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"6f71e689-8016-47c6-a169-6d66cd2a751b","firstName":"Nate","lastName":"Erpestad","fullName":"Nate Erpestad","email":"nerpestad@trascent.com","title":"Managing Director","employeeRegion":"US","supervisorName":"Kevin Rang","employeeCell":"+1 612-270-4582","country":"US","titleCode":"CL6 - Managing Director","hireDate":"2011-01-30","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"9ed6d4fd-0670-4f43-ac22-626f78dd8f77","firstName":"Atukwe","lastName":"Newell","fullName":"Atukwe Newell","email":"anewell@trascent.com","title":"Senior Director","employeeRegion":"US","supervisorName":"Kevin Rang","employeeCell":"-4087","country":"US","titleCode":"CL6 - Managing Director","hireDate":"2011-06-30","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"54bcbc75-58c6-4c53-aca5-a9f90f16668e","firstName":"Diego","lastName":"Sierra","fullName":"Diego Sierra","email":"dsierra@trascent.com","title":"Senior Director","employeeRegion":"US","supervisorName":"Kevin Rang","employeeCell":"-3995","country":"US","titleCode":"CL4 - Director","hireDate":"2013-04-14","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"},{"id":"b5fbeed6-6799-4ad8-a333-465bc9be453d","firstName":"Jade","lastName":"Khodr","fullName":"Jade Khodr","email":"jkhodr@trascent.com","title":"Managing Director","employeeRegion":"EU","supervisorName":"Rakesh Kishan","employeeCell":"33619691737","country":"FR","titleCode":"CL6 - Managing Director","hireDate":"2014-02-02","createdAt":"2026-05-08T20:57:12.801Z","updatedAt":"2026-05-08T20:57:12.801Z"}],"largestSupervisorTeams":[{"supervisorName":"Rakesh Kishan","teamSize":14},{"supervisorName":"Kevin Rang","teamSize":9},{"supervisorName":"Jade Khodr","teamSize":4},{"supervisorName":"Itay Fastovsky","teamSize":2},{"supervisorName":"Sophie Hartmann","teamSize":2},{"supervisorName":"Yvonne Liu","teamSize":2},{"supervisorName":"Julie Wynn","teamSize":1},{"supervisorName":"Nate Erpestad","teamSize":1},{"supervisorName":"Neha Patel","teamSize":1}],"missingDataWarnings":[{"severity":"warning","type":"missing_region_or_country","entityType":"employee","entityId":"a3f5f987-246c-401c-a34d-b1b8841d5c78","entityName":"Amanda Muzzarelli","message":"Employee is missing region or country."},{"severity":"warning","type":"phone_format","entityType":"employee","entityId":"9ed6d4fd-0670-4f43-ac22-626f78dd8f77","entityName":"Atukwe Newell","message":"Employee cell number format looks unusual."},{"severity":"warning","type":"phone_format","entityType":"employee","entityId":"e2e2bfac-31f4-400e-ac51-000a5aa9f7b2","entityName":"Bryan Gilmartin","message":"Employee cell number format looks unusual."},{"severity":"warning","type":"missing_region_or_country","entityType":"employee","entityId":"37d9baba-5492-42b7-ab95-0cc50d84d9dc","entityName":"Daniel Liu","message":"Employee is missing region or country."},{"severity":"warning","type":"missing_region_or_country","entityType":"employee","entityId":"73b3b41a-813a-4b11-a61a-807ef0bf3dea","entityName":"Dharmesh Mahnot","message":"Employee is missing region or country."},{"severity":"warning","type":"phone_format","entityType":"employee","entityId":"54bcbc75-58c6-4c53-aca5-a9f90f16668e","entityName":"Diego Sierra","message":"Employee cell number format looks unusual."},{"severity":"warning","type":"missing_region_or_country","entityType":"employee","entityId":"4614d83a-9c4d-46a6-a2fb-e8870b69081e","entityName":"Gurdip Dhariwal","message":"Employee is missing region or country."},{"severity":"warning","type":"invalid_hire_date","entityType":"employee","entityId":"a6540011-3182-449a-a889-a6693ff143e2","entityName":"Gustavo De La Vega Grunauer","message":"Hire date is missing or invalid."},{"severity":"warning","type":"missing_region_or_country","entityType":"employee","entityId":"2afd29e8-bf7f-4970-ab12-77d1258ac86b","entityName":"Hemant Kishan","message":"Employee is missing region or country."},{"severity":"warning","type":"missing_supervisor","entityType":"employee","entityId":"65e4aa30-4d18-4f82-a7c6-93c0f009964d","entityName":"Itay Fastovsky","message":"Employee does not have a supervisor listed."}]}