Summary
Overview
Work History
Education
Skills
Certification
References
Websites
Timeline
Generic

Ayush Karmacharya

Sydney,Australia

Summary

Energetic and detail-oriented data analyst with over a year of experience, proficient in Excel, SQL, Python, and Tableau, and over three years in customer service. Skilled in leveraging data to drive business decisions and optimize processes. Proven ability to manage and analyze large datasets, ensuring accuracy and integrity. Experienced in ETL processes, data cleaning, and creating insightful dashboards that provide actionable insights. Adept at collaborating with cross-functional teams to deliver data-driven solutions that align with business objectives. Seeking a full-time data analyst role to contribute to data-driven decision-making and continuous improvement.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst

Clarrow
Sydney, Australia
02.2023 - Current
  • Utilized Excel for data cleaning, analysis, and visualization, creating complex pivot tables and charts to support business decisions
  • Gathering, organized, and validated primary data using OneDrive and Excel from various sources within the company, improving data accuracy by 15%
  • Cleaning and validating the imported data using MS Excel to ensure accuracy and consistency by identifying and correcting errors, handling missing data, removing duplicates and summarizing in Pivot Tables
  • Managed and manipulated large datasets in Microsoft SQL Server, performing complex queries and data extraction, which enhanced data retrieval efficiency by 30%
  • Developed and maintained SQL scripts to automate data retrieval and reporting processes, ensuring data accuracy and consistency
  • Created interactive dashboards and reports in Tableau to visualize key performance indicators (KPIs) and track business metrics
  • Conducted exploratory data analysis using Python, leveraging libraries such as Pandas, NumPy, and Matplotlib to uncover insights and trends
  • Assisted in the design and implementation of data models to support various business functions and enhance data-driven decision-making
  • Collaborated with cross-functional teams to deliver actionable insights through comprehensive reports and presentations, driving a 10% improvement in project outcomes
  • Participated in data validation and quality assurance processes to ensure the integrity and reliability of data used in analysis and reporting
  • Identified and implemented data-driven process improvements that reduced data processing time by 20%, leading to faster decision-making and increased operational efficiency
  • Optimized the company's reporting system by streamlining data workflows, resulting in a 15% increase in reporting accuracy and a 30% reduction in manual reporting efforts.

Customer Service Representative

7 Eleven
Sydney, Australia
01.2022 - 02.2023
  • Delivered exceptional customer service by greeting customers, addressing inquiries, and resolving complaints efficiently to ensure a positive shopping experience
  • Managed cash register operations, including processing transactions, handling returns, and balancing the till at the end of shifts
  • Maintained store cleanliness and organization by restocking shelves, arranging displays, and ensuring products were correctly labeled and priced
  • Assisted in inventory management by conducting regular stock checks, receiving deliveries, and coordinating with suppliers to maintain optimal stock levels.

Education

Bachelor of Information Technology -

Crown Institute of Higher Education
North Sydney, NSW
06.2023

Diploma of Information Technology -

Australian Harbour International College
Sydney, NSW
04.2021

Skills

  • Microsoft Excel/Google Sheet
  • Python programming
  • Microsoft SQL Services
  • Data Visualization (eg Tableau)
  • Cloud Services (eg, AWS, MS Azure)
  • Snowflake
  • ETL/ELT processes and data pipeline development
  • Communication
  • Teamwork and Collaboration
  • Adaptability
  • Time Management

Certification

Google Data Analytics Certification

References

Provide upon request.

Websites

Timeline

Data Analyst

Clarrow
02.2023 - Current

Customer Service Representative

7 Eleven
01.2022 - 02.2023

Bachelor of Information Technology -

Crown Institute of Higher Education

Diploma of Information Technology -

Australian Harbour International College

Similar Profiles

CREATE PROFILE
Ayush Karmacharya