Summary
Overview
Work History
Education
Skills
Certification
Section name
Timeline
Generic

Milan Sharma

Mount Druitt,NSW

Summary

Proactive Reporting Analyst and Customer Service Representative with expertise in data integrity, visualization, and defect management. Skilled in SQL, Excel, Tableau, and VBA automation, contributing to efficient reporting and customer satisfaction. Brings strong problem-solving and collaboration abilities to support data-driven decision-making and process optimization. Driven to help the organization comprehend its long-term goals with strong analytical skills and extreme dedication.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Junior Reporting Analyst

Amazon Robotics Warehouse
09.2023 - Current
  • Maintained Data Integrity: Ensured 0% error rate in data management by using SQL for database querying and integrity checks, and Excel for data analysis and validation, contributing to reliable and accurate reporting.
  • Data Visualization: Created and maintained charts and graphs using Tableau, leading to a 15% increase in productivity over a 6-month period by enhancing data interpretation and decision-making for stakeholders.
  • Defect Management: Utilized Excel and bin checks to conduct thorough examinations and inspections of products for defects and damages. Implemented in-depth research on defect trends, which reduced customer order returns by 20% over a 1-year period by addressing and mitigating recurring issues.
  • Training and Support: Informed leadership team on interpreting data trends, fostering a data-driven decision-making culture within the organization.
  • Collaboration: Worked closely with solution designers and architects to finalize system solutions, contributing to the development of effective and scalable systems.
  • Data Mining and Problem Solving: Employed data mining techniques to identify patterns and insights and leveraged problem-solving skills to address data-related issues, optimizing processes and supporting strategic decision-making.
  • · Automation: Developed and implemented VBA macros in Excel to automate repetitive data processing tasks, which reduced manual entry time by 30% and increased reporting efficiency. Designed automated reporting tools that streamlined data aggregation and visualization.

Customer Service Representative

Gyradiko Kitchen
01.2020 - 07.2023
  • Customer Relationship Management: Demonstrated strong ability to build and maintain positive customer relationships, managing interactions with over 100 customers daily and ensuring a welcoming environment.
  • Communication: Effectively communicated with both customers and team members, managing up to 50 customer interactions per shift and achieving a 95% satisfaction rate.
  • Problem-Solving: Successfully resolved customer complaints, handling an average of 15 complaints per week and improving satisfaction through prompt and effective solutions.
  • Team Collaboration: Collaborated with a team of 12 staff members to manage high-volume periods, ensuring seamless service and a collaborative work environment.
  • Organizational Skills: Efficiently managed multiple tasks, including processing up to 200 orders per shift, maintaining inventory records, and addressing customer inquiries.
  • Adaptability: Adapted to changing customer needs and peak times, maintaining high performance even with a 20% increase in customer volume.

Education

Masters of Technology - Enterprise System And Business Analytics

Federation University(IIBIT College)
Sydney, NSW
10.2021

Skills

  • Data interpretation and validation
  • Data visualization
  • KPI analysis
  • Trend analysis
  • SQL and database management
  • Excel (pivot tables, complex formulas)
  • Tableau (dashboard design)
  • Python (data analysis)
  • Problem-solving and critical thinking
  • Attention to details
  • Effective communication and team collaboration

Certification

Python for data science - Udemy

Excel Macros and VBA for Beginners - LinkedIn Learning

Section name

Available upon request.

Timeline

Junior Reporting Analyst

Amazon Robotics Warehouse
09.2023 - Current

Customer Service Representative

Gyradiko Kitchen
01.2020 - 07.2023

Masters of Technology - Enterprise System And Business Analytics

Federation University(IIBIT College)
Milan Sharma