Vikas Khairalia

• Client Management & Data Handling: Independently manage football clients major such as Benfica (includes all sports) and Sporting football, handling large volumes of raw data from platforms like Meltwater, Procurement, Presspower, and others.
• Data Cleaning & Quality Assurance: Expertly clean and validate raw data from multiple secondary media sources (Social Media, Online Press, TV, etc.) through extensive data checks and exposure monitoring to ensure accuracy and consistency.
• Dashboard Management & Exposure Monitoring: Oversee dashboard management and ensure accurate exposure tracking. Perform detailed Year-over-Year (YoY) extrapolation to assign precise values to brands, optimizing sponsorship assessments.
• Reporting & Insight Generation: Compile and generate insights from cleaned data, using report builders to create comprehensive reports covering various media channels such as TV & OTT, secondary media, online press, TV news, and print press.
• Quality Control & Proofreading: Thoroughly proofread and verify final reports for accuracy, ensuring that all sections are precise and aligned with client expectations.
• Sponsorship Value Enhancement: Work collaboratively with clients to analyze brand exposure and optimize sponsorship values, providing actionable insights that enhance brand partnerships and support strategic business decisions.
• Internal Stakeholder Collaboration: Participate in internal stakeholder calls to discuss client requirements, understand methodologies, and ensure efficient delivery of reports tailored to client expectations.
• Training & Knowledge Transfer: Train multiple new joiners on data cleaning process, report generation, and quality assurance procedures, ensuring they are equipped to handle client requirements effectively and efficiently.
• Utilized statistical software for accurate data analysis.

Led a team of 23 analysts in the newly established Bangalore branch, overseeing detailed report creation and providing valuable insights from data collection to analysis.

• Team Leadership & Training: Managed and mentored a team of analysts, providing training on various sports analytical tools to analyze global sports including American Football, Volleyball, Basketball, Ice Hockey, Lacrosse, and Soccer for elite teams across America and Europe, including NBA, EPL, and La Liga.
• Advanced Data Analysis: Utilized advanced Excel functions like Power Pivot, VLOOKUP, IF functions, Slicer tools, Sorting, and Filtering to generate insights, providing valuable trends that aided coaches in strategizing for future games.
• Quality Assurance & Ratings: Led the team’s user rating project, ensuring high-quality service to sports teams and achieving top-rated Quality Analyst status within the company.
• Leadership & Performance Optimization: Provided leadership and direction, driving team productivity and efficiency. Routinely surpassed monthly KPIs by setting performance standards, resulting in topping team rankings for February 2021.

Assisted the Team Leader in managing and guiding the team, overseeing task implementation, and ensuring timely delivery of high-quality results.

• Team Coordination & Task Management: Supported the Team Leader in guiding, managing, and monitoring the execution of assigned tasks, handling the team’s MIS, projects, and coordination efforts to ensure efficient and timely achievement of team objectives.
• R&D Project for NBA: Contributed to a research and development project for the NBA, focused on capturing player actions during games and predicting future performance by analyzing various player attributes using advanced sports analytical tools.
• Quality Assurance & Data Analysis: Played a key role in ensuring the team’s output met quality standards and contributed to data-driven insights that enhanced performance evaluation and prediction.

Worked on high-profile projects to enhance team performance by leveraging various data analysis tools.

• Elite Projects & Data Analysis: Contributed to key projects like Volley Metrics (Bulgaria-based) and Event Tagging for top European soccer teams (EPL, Bundesliga, La Liga) to capture detailed performance data using tools like SQL, Google Data Studio, and proprietary tools such as SportsCode.
• Quality Assurance: Performed comprehensive quality analysis to ensure the completeness, consistency, and relevance of the data, maintaining high standards for data integrity and accuracy.
• Training & Knowledge Sharing: Trained a batch of 40 new joiners on SportsCode and Event Tagging tools, equipping them with the necessary skills for effective data analysis and reporting.

Conducted in-depth analysis of American and European sports teams, providing key performance insights to enhance athlete performance in future games.

• Data Analysis & Performance Insights: Analyzed data for sports such as American Football, Volleyball, Ice Hockey, Soccer, and Basketball, using sports analytical tools to generate accurate performance statistics and support athlete development.
• Intelligence Resource Development: Created and improved intelligence resources to streamline workflows, ensuring consistent productivity and maintaining high-quality standards in data analysis.