Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

AMAN MEHROTRA

Business Analyst
Prayagraj, Uttar Pradesh, India,AA

Summary

Recently graduated from a Business Analyst Pro course, have developed a strong foundation in operations and data analysis. With over five years of experience in operational roles at major companies like Amazon and SBI Capital Markets, having a proven track record of optimizing processes and enhancing team efficiency. Hands-on experience with data tools such as Excel, Power BI, and SQL, combined with recent studies, equips with the analytical skills necessary to drive insightful, data-backed decisions. Transitioning into a business analyst role excites as it allows to apply the skills in supporting strategic objectives and fostering operational success.

Overview

1823
1823
years of professional experience
5
5
years of post-secondary education
3
3
Certifications

Work History

Transportation Operation Specialist

Amazon
Hydrabad
08.2021 - 05.2023
  • Conducted thorough payment verifications for 4800 delivery service partners across EU/NA regions, ensuring timely and accurate payments and resolving any escalations regarding internal AMZL databases
  • Resulted in a 98% on-time payment rate and a reduction in payment disputes by 75%
  • Developed a comprehensive stakeholder e-mail list with over 200 contacts alphabetically arranged for daily outreach, resulting in more efficient reporting and quicker issue resolution
  • Make use of Excel functions to automate the process of updating the list regularly
  • Designed an effective data worksheet tracker and daily report email for top management, including key metrics such as payment accuracy, dispute resolution count, and Audit file report
  • Improved transparency into the team's performance by providing timely updates

Relationship Officer

SBI Capital Markets
Prayagraj, Uttar Pradesh, India
11.2020 - 07.2021
  • Managed over 100 consultations with potential clients to discuss the benefits of opening a Demat and Trading account, resulting in a 65% increase in new account openings
  • Utilized product demos to onboard 50 new clients monthly, leading to an overall increase of 500K in trading volume
  • Leveraged digital platforms such as social media and email marketing to promote Demat & Trading accounts, resulting in a 40% increase in website traffic and a 15% boost in online account activations

Community Associate

REGUS - IWG plc. Offices | Coworking | Meeting Rooms
12.2019 - 05.2020
  • Maintained exceptional customer service by promptly addressing and resolving 100+ customer complaints per week, resulting in a 95% satisfaction rate
  • Collaborated with team members to prioritize customers' needs, resulting in a 30% increase in customer retention rates within the first quarter
  • Managed vendor relationships and negotiated pricing for purchasing 50K worth of food and beverage items, achieving a cost savings of 15%

Operations Supervisor

Cinépolis India
Ahmedabad
06.2017 - 01.2019
  • Supervised a team of 10 associates, assigning daily duties and monitoring productivity to achieve a 15% increase in sales revenue over the past quarter
  • Efficiently implemented new processes and standards procedures, resulting in a 25% improvement in customer satisfaction ratings
  • Maintained high grooming standards among associates, ensuring compliance with company policies and improving overall store appearance by 30%

Quality Auditor Trainer

OYO
Ahmedabad
02.201 - 08.201
  • Led Quality audits for 40 hotels, identifying areas for improvement in service quality and hospitality
  • Trained 100+ staff members on best practices for customer service, resulting in a 20% increase in positive feedback from guests
  • Take advantage of customer feedback to develop customized training programs tailored to each hotel's unique needs, resulting in a 15% increase in guest satisfaction scores across all properties

Education

Bachelor of Science - hotel Administration, Hotel/Motel Administration/Management

Institute Of Hotel Management Catering And Technology
Guwahati
08.2013 - 01.2016

MBA - Operation Management

Narsee Monjee Institute Of Management Studies
Hydrabad
06.2022 - 10.2024

Skills

Data Analytics tools

  • Excel

  • Basic SQL

  • Power BI

Business Documentation

  • BRD

  • FRD

Certification

Advance Excel Certification (MyCaptain)

Timeline

MBA - Operation Management

Narsee Monjee Institute Of Management Studies
06.2022 - 10.2024

Transportation Operation Specialist

Amazon
08.2021 - 05.2023

Relationship Officer

SBI Capital Markets
11.2020 - 07.2021

Community Associate

REGUS - IWG plc. Offices | Coworking | Meeting Rooms
12.2019 - 05.2020

Operations Supervisor

Cinépolis India
06.2017 - 01.2019

Bachelor of Science - hotel Administration, Hotel/Motel Administration/Management

Institute Of Hotel Management Catering And Technology
08.2013 - 01.2016

Quality Auditor Trainer

OYO
02.201 - 08.201

Similar Profiles

CREATE PROFILE
AMAN MEHROTRABusiness Analyst