Summary
Overview
Work History
Education
Skills
Timeline
Generic
Tanya Mehra

Tanya Mehra

New Delhi

Summary

Results-driven Data Research Analyst at Tata Consultancy Services with expertise in SQL querying and analytical research. Proven track record in enhancing data quality and supporting strategic decision-making. Adept at problem-solving and effective communication, consistently delivering actionable insights that drive client success and operational efficiency.

Overview

6
6
years of professional experience

Work History

Data Research Analyst

Tata Consultancy Services
Delhi
07.2023 - Current
  • Data Researcher at McKinsey/ The project was under Mckinsey

    Conducted in-depth data research and profiling on high-level professionals and decision-makers across industries and geographies.

    Collected, validated, and reconciled data from various trusted sources to ensure accuracy and consistency.

    Utilized platforms like LinkedIn, Salesforce, company websites, and other third-party databases for reliable information gathering.

    Cross-verified data points against internal records and external resources to maintain data integrity.

    Organized, updated, and managed large datasets using SQL and Microsoft Excel to streamline analysis and reporting.

    Ensured high standards of data quality, completeness, and confidentiality in compliance with McKinsey’s internal protocols.

    Developed and maintained documentation for data sources, research methods, and validation processes.

    Supported consultants and teams by providing accurate, timely, and actionable data for client deliverables and strategic planning.

    Collaborated with global team members and other departments to align research objectives and improve data workflows.

    Identified data inconsistencies or gaps and took proactive steps to resolve or escalate them as needed.

    Regularly monitored industry news, company updates, and market trends to keep databases current and relevant.

    Automated repetitive data tasks using advanced Excel functions (e.g., VLOOKUP, pivot tables) and SQL queries.

    Assisted in preparing research summaries, data reports, and insights for stakeholder presentations.

    Maintained a strong understanding of data privacy and compliance requirements, including GDPR and internal policies.
  • Analyzed large datasets to identify trends and patterns.

Senior Technical Associate

TCS
04.2022 - 06.2023
  •  Network Design Engineer at NBN (Australian Network Provider Company).
     Utilized tools such as Spatial.NET, Maximo, Comptel for network design tasks.
     Worked with JIRA and GIT for database management and tracking instructions.
     Demonstrated exceptional performance and skills in network designing, leading to a promotion within a year.
     Design and Triage Analyst for Multiple Technology Network.
     Utilized Salesforce and Spatial.NET for identifying root causes of network issues, including service loss, speed problems, and intermittent dropouts.
     Handled orders related to billing, involving network service upgrades or downgrades for NBN customers.
     Played a key role in enabling or disabling billing functionalities based on network service changes.
     Collaborated with cross-functional teams to address and resolve complex network issues
     Contributed to process improvements for efficient workflow in the Design and Triage Team
     Conducted training sessions for team members on the use of Salesforce and Spatial.NET for effective issue resolution and network optimization.
  • Evaluated existing systems against industry standards and recommended modifications as necessary.
  • Maintained extensive documentation for all customer issues, solutions, and processes.
  • Operated forklift trucks to unload and transport goods.

Senior Technical Consultant

Concentrix
Gurgaon
02.2021 - 04.2022
  • Worked as a Technical Chat Executive for Apple Products.
  • Troubleshooted all the issues in various devices and iCloud Accounts.
  • Troubleshooted MacOS and iPadOS related problems.
  • Handled 2-3 customers over chats at a single time.
  • Diagnosed hardware and software faults quickly and effectively for optimal network operations.
  • Communicated with service users, explaining complex technical information with ease and clarity.
  • Executed system upgrades with patches, service packs and new configurations to meet technical requirements.
  • Analysed customer network requirements, offering targeted product recommendations and setups to meet needs.

Freelance HR Recruiter

Optim Hire
01.2021 - 12.2021
  • Sourced candidates through social media platforms, validating suitability for available positions.
  • Advertised and managed position listings, organising interviews with suitable candidates.
  • Balanced client and candidate needs to achieve outstanding satisfaction ratings.
  • Managed interview process on behalf of clients and candidates, maintaining appropriate confidentiality with both parties.

Customer Delight Associate

Jindal X
08.2019 - 02.2021

 Managed customer inquiries and concerns for Zomato food
ordering app in the UAE, Middle East, and Lebanon regions.
 Addressed issues such as wrong orders, delayed deliveries,
spillage problems, and more.
 Demonstrated excellent communication skills to effectively
resolve customer queries and concerns.
 Showcased empathy in interactions to enhance customer
satisfaction and trust in the Zomato App.
 Implemented compensation strategies to retain customer loyalty
and uphold the brand's reputation.
 Successfully upheld a high standard of customer service, contributing to overall customer satisfaction.

  • Built rapport with customers through courteous and professional communications.
  • Monitored customer surveys and feedback to develop corrective actions for service-related issues.

Education

Diploma of Higher Education - Human Resource Management

Symbiosis Centre For Distance Learning Institute
Pune, MH
2024

B.COM - Commernce

Delhi University (SOL)
New Delhi
2021

Diploma in Spanish Language - Languages

St. Stephen's College
Delhi
04-2019

CBSE HSC 12th - Commerce

Tyagi Public School
New Delhi
2018

Certification in Spanish Language - Spanish

Mundo Latino
Delhi
03-2018

CBSE SSC 10th - General

Tyagi Public School
New Delhi
2016

Skills

  • Human Resource Management
  • Microsoft Office
  • Problem-Solving
  • Multilingual
  • Google Workspace
  • Analytical Research
  • SQL querying
  • Microsoft Excel
  • Data analysis
  • Data reporting
  • Project management
  • Effective communication
  • Problem solving
  • Time management
  • Data quality assurance
  • SQL databases
  • Data management
  • Excel functions
  • Network design
  • Technical troubleshooting
  • Customer support
  • Issue resolution

Timeline

Data Research Analyst

Tata Consultancy Services
07.2023 - Current

Senior Technical Associate

TCS
04.2022 - 06.2023

Senior Technical Consultant

Concentrix
02.2021 - 04.2022

Freelance HR Recruiter

Optim Hire
01.2021 - 12.2021

Customer Delight Associate

Jindal X
08.2019 - 02.2021

Diploma of Higher Education - Human Resource Management

Symbiosis Centre For Distance Learning Institute

B.COM - Commernce

Delhi University (SOL)

Diploma in Spanish Language - Languages

St. Stephen's College

CBSE HSC 12th - Commerce

Tyagi Public School

Certification in Spanish Language - Spanish

Mundo Latino

CBSE SSC 10th - General

Tyagi Public School
Tanya Mehra