Amarpreet Kaur Dhanoa
Lathrop
Summary
Dynamic Customer Service Associate with proven success at Staybridge Suites, enhancing customer satisfaction through effective problem-solving and communication. Proficient in Python and SQL, I excel in data-driven environments, driving insights that improved sales by 10%. A collaborative team player, I thrive under pressure while maintaining high standards of service.
Overview
11
11
years of professional experience
Work History
Customer Service Associate
Staybridge Suites Madison- Fitchburg by IHG
Madison, WI
07.2024 - 05.2026
- Followed up with customers to resolve inquiries and ensure satisfaction.
- Resolved customer queries and issues regarding products and services.
- Recommended tailored solutions based on customer needs to enhance service experience.
- Contacted existing and prospective customers to strengthen relationships and promote services.
- Obtained customer information and relevant data to enhance service.
- Answering phones and explaining the product and services offered by the company.
- Maintained customer database regularly to ensure accurate records.
- Utilized MS Office proficiently to manage and maintain data reports.
Customer Service Associate
Sleep Inn & Mainstay Suites Madison- Monona by Choice Hotels
Madison, WI
11.2024 - 11.2025
- Resolved guest issues calmly and professionally on first call, escalating to management for further assistance.
- Assisted guests with upgrades and clarified payment charges to enhance their experience.
- Answering all the queries either about property or nearby areas, food and attractions.
- Welcomed each guest warmly upon entrance, creating a positive first impression.
- Checking arrival and departure records/sheets, handling payments.
Data Engineer
Ticketmaster
Hollywood, USA
08.2022 - 05.2025
- Created data visualizations and reports from extracted, transformed, and loaded data using Amazon Quicksight, enhancing data accessibility for stakeholders.
- Configured Databricks executor to start a Databricks job each time the executor receives an event record.
- Developed Python code to gather the data from HBase and designed the solution to implement using PySpark.
- Collaborated with data owners, business units, and data integration teams in a fast-paced Agile/Scrum environment to streamline data processes.
- Excellent Experience in Hadoop, Python architecture and various components such as HDFS, Task node, Namenode, Data node and MapReduce programming paradigm.
- Designed and implemented AWS Lambda functions for ETL migration, generating a serverless data pipeline integrated with Glue Catalog and queryable from Athena.
- Creating shell scripts to process the raw data, loading data to AWS S3 and Redshift databases.
- Implement AWS Lambdas to drive real-time monitoring dashboards from system logs, utilize python/PySpark in Databricks notebooks when creating ETL pipelines in Azure Data Factory.
- SQL- Experienced working with all of it. Postgres, SQL Server, Oracle, MySQL. Written T-SQL and PLSQL scripts for data clean-up, transformation, reporting and analysis.
- Python - Experienced programmer for a variety of development projects. Building infrastructure, user applications, interfaces, data pipelines, Airflow for WMS, writing transformation logic and various algorithms. Use pandas extensively.
- R- Experienced in data analysis, data visualization, big data exercises.
- Environment: Spark, AWS, Amazon Quicksight, S3, Python, Teradata, SQL, Databricks, R, MySQL, PySpark, AWS Lambda, Redshift.
Customer Service Representative
Follett Corporation-Golden Gate University
San Francisco, USA
08.2019 - 04.2021
- Engaged customers to increase sales of products at cafe and bookstore.
- Assisted in developing customer feedback surveys, promotional strategies, resource reallocation resulting in an increase in quarterly sales by ~10%.
- Transformed existing on-site training and development of new team members in areas like management skills, inventory tasks, and general operations of the business.
- Integrated customer buying behavior with inventory forecasts to generate insights report that contributed to quarterly cost savings of 6-8%.
Assistant Engineer
SEER Engg IT Solutions Pvt. Ltd.
Chandigarh, India
07.2015 - 12.2017
- Analyzed reasons for site outages and restored functionality, minimizing downtime.
- Coordinated with vendors and other operators regarding site issues.
- Resolved customer complaints via telephone and email, enhancing customer satisfaction.
Education
Master of Science - Business Analytics
Golden Gate University
San Francisco, CA, USA08-2021
Master of Business Administration -
Desh Bhagat University
Mandi Gobindgarh, INDIA05-2017
Bachelor of Technology - Electronics and Communication
Gulzar Group of Engineering and Technology
Khanna, INDIA11-2015
Skills
- Customer relationship management
- Technical support
- Problem-solving skills
- Communication excellence
- Team collaboration
- Stress management
- Multitasking capabilities
- Microsoft Office proficiency
- Leadership and motivation
- Conflict resolution
- Python and SQL
- Tableau and Power BI
- MicroStrategy expertise
- Flexible work support
Projects
- Multi Switch Doorbell Using Indicators, Developed by team of 3, Responsible for programming and to give hardware design. The essence of this project is that it was simple, and it is devoid of hard-to-get micros, PROMS, double sided PCBs and much more.
- Android Based Ordering System in Restaurants, Teamwork of 3 students, responsible for programming and hardware design, implemented an app with the help of MIT software and used that application on mobile phones and implemented in college canteen to check the server.
Languages
Hindi
Full Professional
Punjabi
Native or Bilingual
Timeline
Customer Service Associate
Sleep Inn & Mainstay Suites Madison- Monona by Choice Hotels
11.2024 - 11.2025
Customer Service Associate
Staybridge Suites Madison- Fitchburg by IHG
07.2024 - 05.2026
Data Engineer
Ticketmaster
08.2022 - 05.2025
Customer Service Representative
Follett Corporation-Golden Gate University
08.2019 - 04.2021
Assistant Engineer
SEER Engg IT Solutions Pvt. Ltd.
07.2015 - 12.2017
Master of Business Administration -
Desh Bhagat University
Bachelor of Technology - Electronics and Communication
Gulzar Group of Engineering and Technology
Master of Science - Business Analytics
Golden Gate University