Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic

Anamika Ranjan

New Delhi

Summary

Motivated and resourceful professional with a strong background in administration, customer service, and sales. Currently upskilling in data analytics, with hands-on knowledge of Excel, Power BI, SQL, Tableau, and introductory Python. Known for building strong relationships, solving problems efficiently, and improving team performance. Now seeking opportunities where analytical skills and business knowledge can make a measurable impact.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Customer Service Specialist

Naturo Habit Pvt. Ltd.
08.2023 - 08.2024
  • Analyzed 120+ daily customer interactions across chats, emails, calls, and social media, achieving a 99% positive rating (QC surveys).
  • Led a team of 12-14 agents, maintaining a 95%+ quality score and coaching to improve performance.
  • Developed weekly performance and quality reports using Excel (pivot tables, formulas, dashboards), tracking KPIs like turnaround time, failure rate, and satisfaction.
  • Monitored driver operations in real time; collected and maintained accurate logs to identify bottlenecks and support data-driven improvements.
  • Managed escalations and bulk orders; conducted follow-up actions and record-keeping to ensure resolution.
  • Reconciled refunds and cashback payments via Razorpay; audited transactional data to maintain accuracy.

Customer Experience Associate

Digital Design Technology
12.2020 - 08.2023
  • Managed & cleaned customer account data in Excel—using formulas (SUMIF, VLOOKUP) and filters to ensure accuracy in billing and records.
  • Analyzed billing data to identify errors, corrected issues, and prevented revenue loss.
  • Built Excel dashboards with pivot tables and charts to track customer inquiries and resolution rates, reducing reporting time by 20%.
  • Investigated root causes of customer issues by mining data, summarizing findings, and recommending workflow improvements.
  • Escalated critical cases via structured Excel tracking, preventing policy cancellations and reducing churn.
  • Trained new team members on Excel best practices for data entry, analysis, and issue-resolution.

Office Administrator

Lision Automation Services
05.2018 - 03.2020
  • Interacted with clients via phone, email, and in-person, routing calls, greeting visitors, and delivering information—boosting customer satisfaction.
  • Streamlined administrative systems—computerizing records, coordinating registrations and financials, and updating databases.
  • Resolved client issues using active listening and escalation protocols, improving first-response accuracy.
  • Provided consistent front-desk support, addressing inquiries and covering absent staff.
  • Collected and analyzed customer feedback to recommend service enhancements.
  • Maintained a safe work environment through staff training and enforced safety procedures.
  • Answered 40-50 multi-line phone system calls, routing calls, delivering messages to staff and greeting visitors.

Education

Data Science And Business Analytics -

Training YA Academy
Gurgaon, India
07-2024

Masters of Journalism And Mass Communication -

Indira Gandhi National Open University
New Delhi, India
12-2024

Bachelor of Science -

Magadh University
Patna, India
08-2019

12th -

S.V.V Senior Secondry School
Patna, India
03-2016

10th -

Vidya Sagar School
Indore, India
04-2013

Skills

  • Visual data representation
  • Data filtering
  • Tableau
  • Trend analysis
  • Time management
  • Python programming
  • Business intelligence tools( Tableau, Power BI)
  • Analytical problem solving
  • Large dataset manipulation
  • Data validation
  • ETL processes
  • Problem-solving
  • Data warehousing
  • Data analysis
  • MS Excel
  • SAS programming
  • Database management
  • Structured query language (SQL)

Certification

On the Job Training in Passenger Facilitation-Airport Authority Of India


"A" Grade Certificate- MP Air Squadron

Languages

English
Hindi

Timeline

Customer Service Specialist

Naturo Habit Pvt. Ltd.
08.2023 - 08.2024

Customer Experience Associate

Digital Design Technology
12.2020 - 08.2023

Office Administrator

Lision Automation Services
05.2018 - 03.2020

Data Science And Business Analytics -

Training YA Academy

Masters of Journalism And Mass Communication -

Indira Gandhi National Open University

Bachelor of Science -

Magadh University

12th -

S.V.V Senior Secondry School

10th -

Vidya Sagar School

Similar Profiles

  • BINOD SINGH

    BINOD SINGHBINOD SINGH

    IT Support Engineer at Design Habit Pvt LtdIT Support Engineer at Design Habit Pvt Ltd

  • Sipho Chilenge

    Sipho ChilengeSipho Chilenge

    Detox Nurse and Reception at MGT NATURO PHARMACYDetox Nurse and Reception at MGT NATURO PHARMACY

  • Sai Krishna.

    Sai Krishna.Sai Krishna.

    Quality Assurance and Quality Control Executive at Naturo Food and Fruit Products Private LimitedQuality Assurance and Quality Control Executive at Naturo Food and Fruit Products Private Limited

  • SIDDHARTH SHANKAR

    SIDDHARTH SHANKARSIDDHARTH SHANKAR

    Subject Matter Expert-Back Office Executive at EXL Service Ltd.Subject Matter Expert-Back Office Executive at EXL Service Ltd.

  • Satyam Dhawan

    Satyam DhawanSatyam Dhawan

    Senior Software Engineer at EmidsSenior Software Engineer at Emids

CREATE PROFILE
Anamika Ranjan