Summary
Overview
Work History
Education
Skills
Certification
References
Timeline
Generic

Basanta Bhandari

Killburn

Summary

A Master's degree in Information Technology with extensive experience in data analysis, business intelligence, and customer service. Skilled in using Excel, SQL, Python, and Tableau, developing data warehouses, optimizing SQL queries, and creating visually engaging dashboards. Strong communication, collaboration, and problem-solving skills, with a passion for AI and predictive modelling. Excelled in utilizing Tableau and advanced Excel, coupled with strong analytical thinking, to drive business insights, improve customer satisfaction, and achieve cost control. Demonstrated excellence in communicating complex data to stakeholders, ensuring data integrity and compliance. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Data Analyst

Palmer Hospitality Group
09.2023 - 07.2024

1. Data Collection and Extraction: Gather data from various sources, including databases, spreadsheets, and external sources and use SQL queries and other tools to extract relevant data.

2. Data Cleaning and Preparation: Clean and process raw data to ensure accuracy and consistency. Handle missing data, outliers, and errors through data validation techniques.

3. Data Analysis: Apply statistical methods to analyze data and identify trends, patterns, and correlations. Perform exploratory data analysis (EDA) to gain insights and understand the underlying data structure. 4. Data Visualization: Create visualizations, such as charts, graphs, and dashboards, to represent data clearly and effectively. tools like Tableau, Power BI, or Excel to develop interactive and user-friendly dashboards.

5. Reporting: Generate standard and custom reports that summarize key findings and insights and Present data in a clear and concise manner to stakeholders through reports, presentations, or visual aids.

6. Database Management: Develop and maintain data warehouses, marts, or databases to support data storage and retrieval for Optimize SQL queries for efficient data processing.

7. Collaboration and Communication: Work with cross-functional teams to understand business requirements and translate them into data solutions. Communicate analytical findings to stakeholders, providing actionable recommendations.

8. Supporting Decision-Making: Provide insights and data-driven recommendations to support strategic business decisions. Monitor and track key performance indicators (KPIs) to evaluate business performance.

9. Data Modelling: Create data models to simulate scenarios and predict future trends or outcomes and use se predictive analytics to forecast future business trends.

10. Technical Support: Offer technical support related to data management, backup, and integrity and Ensure compliance with data governance and security protocols.

Customer Service Representative

Foodland
10.2022 - 07.2023

1. Customer Interaction: Handle inbound and outbound customer calls, emails, and chat inquiries and Greet customers warmly and engage in active listening to understand their needs or concerns.

2. Issue Resolution: Address customer issues, complaints, or questions promptly and effectively and escalate complex or unresolved issues to higher-level support when necessary.

3. Product and Service Assistance: Assist customers with product selection, usage, and troubleshooting and Guide customers through the purchasing process or provide support with order tracking and returns.

4. Documentation and Reporting: Document customer interactions, issues, and resolutions in the company's CRM system. Maintain accurate records of customer inquiries and transactions for future reference.

5. Feedback Collection: Gather customer feedback on products and services and report it to relevant departments then Use feedback to suggest improvements to products, services, or customer service processes.

6. Team Collaboration: Work closely with other departments, such as sales, technical support, or billing, to resolve customer issues. Participate in team meetings, training sessions, and performance reviews to improve service quality.

7. Continuous Learning: Stay updated on product knowledge, company policies, and industry trends. Participate in ongoing training to improve customer service skills and knowledge.

Education

Master - Information Technology

Torrens University Australia
Adelaide, SA
08.2024

Skills

    Technical Skills: Data Analysis, Excel, SQL, Python, Data visualization (Tableau/Power BI) Simulation Modelling, Data Warehousing, Process Mapping, Data Validation, ETL process, Cloud Computing, Dashboard Design

    Analytical Skills: Statistical analysis, Data Interpretation, Data Cleaning, Data mining, Predictive Modelling, Data Visualization, KPI Analysis

    Project Management Skills: Project management, Stakeholder communication and Management, Mentorship

    Soft Skills: Communication, Collaboration, Critical Thinking, Creativity, Attention to detail, Time Management, Problem-Solving, Leadership skills, Business Intelligence

Certification

Certification on Advanced Excel

Certification on linkedin learning Tableau

References

Available upon request

Timeline

Data Analyst

Palmer Hospitality Group
09.2023 - 07.2024

Customer Service Representative

Foodland
10.2022 - 07.2023

Master - Information Technology

Torrens University Australia

Certification on Advanced Excel

Certification on linkedin learning Tableau

Basanta Bhandari