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
Odisha2017
Certificate of Higher Education - Science
Santhosha Vidhyalaya
Tirunelveli, TN2012
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
Similar Profiles
Ajay KumarAjay Kumar
Senior Manager Care Operations at Uniorbit Technologies Private LimitedSenior Manager Care Operations at Uniorbit Technologies Private Limited
AKSHAY RAJANAKSHAY RAJAN
Manager - Sales and Operations at Uniorbit Technologies Pvt LtdManager - Sales and Operations at Uniorbit Technologies Pvt Ltd
VIJENDRA PRASADVIJENDRA PRASAD
Senior Administration at UNIORBIT TECHNOLOGIES PVT LTDSenior Administration at UNIORBIT TECHNOLOGIES PVT LTD
Simran SSimran S
Travel Consultant at BCD TravelTravel Consultant at BCD Travel
Kannan LKannan L
Service Owner - Identity Global Products at AXA Global Business ServicesService Owner - Identity Global Products at AXA Global Business Services