Bharat Chhetri
Sydney,New South Wales
Summary
Dedicated professional with a strong background in customer service, time management, and trend tracking, alongside my technical expertise in data analysis using Excel, SQL, Python, and Tableau, to exceed goals and cultivate positive relationships where I can apply my skills in managing and configuring Office 365 applications, including Exchange Online, SharePoint Online, and Microsoft Teams, as well as my proficiency in SharePoint administration, to drive efficiency and organizational success. Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities.
Overview
5
5
years of professional experience
Work History
Data Analyst
Jade cleaning
11.2023 - Current
- Sorting and filtering through data to find the information and organizing it in a logical and meaningful sequence
- Figure out the total revenue over the year, analyze the revenue distribution by different types of cleaning services, and make a chart of monthly revenue trends to identify peak seasons and low periods
- Implement organizational delivery standards, monitoring work product quality
- Analysis the profit margin by subtracting total expenses from total revenue
- Making a graph of monthly profit and loss over time
- Gathering data scattered throughout another Excel spreadsheet and transferring it to a current spreadsheet using VLOOKUP and check the trend
- Calculate the total expense, including staff and stock, also analyses high-spending areas and plot the expense trend to track changes over 3-month periods
- Also, check the budget for future spending areas
- Data cleaning and transformation using SQL
- Extracting data using Excel and SQL queries
- Designing a dashboard for the business to understand the trend of profit and lost margin
- Calculate all customer satisfaction ratings and ratings for different types of cleaning services at excel
- Also, check the mail and complain about all types of cleaning and put them on a graph and a pie chart for future purpose.
Customer service representative
GJK Sydenham
01.2019 - Current
- Worked in close collaboration with team members to ensure customers received high-quality service
- Effectively multitasked within a fast-paced environment
- Participated in ongoing training to enhance job skills and knowledge
- Maintained a clean, safe, and organized work environment.
Education
Bachelor of Information Technology - Web and Mobile Application Development
Victoria University
Skills
Google sheets
Report writing
Microsoft word
SQL
Data Modeling
Big Query
Python (pandas)
Data cleaning
Data Transformation
Data Visualization
Dashboard designing
Data Validation
Date warehousing
Technical Analysis
Simulation Modeling
Soft skill
Excellent verbal and written Communication
Teamwork and attention to detail
Critical thinking and Problem solving
Time management
Leadership and creativity
Driving license
Business Needs Analysis
References
Available upon request
Timeline
Data Analyst
Jade cleaning
11.2023 - Current
Customer service representative
GJK Sydenham
01.2019 - Current
Bachelor of Information Technology - Web and Mobile Application Development
Victoria University