Summary
Overview
Work History
Education
Skills
Hobbies
Certification
Languages
Accomplishments
Timeline
Generic
Pranay Sourav Samontray

Pranay Sourav Samontray

Bangalore

Summary

MIS Executive with experience in preparing and automating reports for collections and performance tracking. Skilled in Excel, basic SQL, Google Sheets, and Looker Studio, with a focus on creating accurate, secure, and easy-to-understand data, and dashboards. Able to support operations by turning raw data into useful insights that help the team work better and faster.

Overview

2
2
years of professional experience
1
1
Certification

Work History

MIS Executive

Uniorbit Technology
Banglore
05.2024 - Current
  • Implemented automated processes to streamline daily operations and reduce manual workloads.
  • Created dashboards and visualizations to present data insights in an easy-to-understand format.
  • Maintained a database of customer information, including contact details, preferences, and product subscription histories.
  • Developed and maintained comprehensive MIS reports (hourly, daily, weekly, and monthly reports) to facilitate decision-making processes for senior management.
  • Created reports from databases using SQL queries
  • Analyzed large datasets to provide meaningful information.
  • Developed a performance monitoring dashboard in Looker Studio to track agent-wise collections, display the top three performers, and include KPIs such as login hours, total dials, AHT (Average Handling Time), and break durations on a cycle basis.
  • Implemented agent-level data restriction in Looker Studio dashboard, eliminating lead conflicts, and increasing trust and efficiency in collections operations.
  • Automated daily reporting using pivot tables to consolidate large datasets, improving data interpretation speed, and supporting faster decision-making for the collections team.

Sales Executive

Uniorbit Technology
Banglore
09.2023 - 04.2024
  • Showcased product features and benefits to drive sales.
  • Met sales targets through proactive promotion and excellent customer service.
  • Demonstrated products to customers to show features, and promote items.
  • Managed customer relationships through consultative sales techniques to attain individual sales goals.
  • Closed large sales to exceed quota and align with company targets.

Education

Bachelor of Technology - Mechanical Engineering

Synergy Institute Of Engineering And Technology
Odisha
2017

Certificate of Higher Education - Science

Santhosha Vidhyalaya
Tirunelveli, TN
2012

Skills

  • Analytical ability
  • Report automation
  • Excel (Pivot table, VLOOKUP, IF, etc)
  • Dashboard design (Looker Studio)
  • Collections analysis
  • Data validation and cleaning
  • Google Sheet
  • Interpersonal communication
  • Relationship building and management
  • Empathy

Hobbies

  • Music/Spending time with Guitar
  • Cooking
  • Playing Football

Certification

  • Excel, Advance Excel from Zeneth Pvt Ltd.(Banglore)

Languages

Odia, Hindi, English

Accomplishments

PROFESSIONAL

  • Automated most of the daily reporting tasks, saving approximately 2 hours per day and improving team productivity,
  • Reduced reporting errors by 80% through the creation of dynamic, validated Excel templates, and developed a performance dashboard that enabled team leads to identify top performers and underperformers in real time, improving collection performance by 5% to 10%
  • implemented agent-level access in Looker Studio, eliminating data conflict issues and improving data trust within the operations team
  • Used pivot-based reporting to deliver ad hoc reports to management within minutes, enhancing decision-making speed

OTHERS

  • I represented Odisha as an NCC cadet in New Delhi for the Republic Day Parade on January 26, 2015
  • Awarded as the best athlete of the year for four consecutive years at my university

Timeline

MIS Executive

Uniorbit Technology
05.2024 - Current

Sales Executive

Uniorbit Technology
09.2023 - 04.2024

Bachelor of Technology - Mechanical Engineering

Synergy Institute Of Engineering And Technology

Certificate of Higher Education - Science

Santhosha Vidhyalaya
Pranay Sourav Samontray