Summary
Overview
Work History
Education
Skills
Soft Skills
Projects
References
Timeline
Generic
Krishmal Shrestha

Krishmal Shrestha

Melbourne,Australia

Summary

A driven and analytical data professional with a passion for extracting valuable insights from data. Possessing strong technical skills in data analysis, visualization and reporting using Excel, SQL, Python, and Tableau. Proven ability to clean, transform, and manipulate large datasets, ensuring data integrity and accuracy. Adept at identifying patterns, trends, and relationships within complex data sets to support data-driven decision-making. Dedicated to continuously learning and staying up to date with the latest data analysis tools and techniques.

Overview

2
2
years of professional experience

Work History

Junior Data Analyst

Danfe Consulting
11.2023 - Current
  • Analyze data related to visa and migration processes, providing insights to stakeholders
  • Gather data scattered throughout another Excel spreadsheet and transfer in a current spreadsheet using VLOOKUP
  • Use a pivot table in order to group and reorder the findings in such a way that makes it easier to organize the numbers and data by date, percentage or any other variables
  • Use SQL to correct inconsistent date formats and to extract relevant client data for specific visa categories, enabling more accurate analysis. Clean and transform raw data from the visa and migration application database by removing duplicates, normalizing data fields, and joining tables to create a unified dataset.
  • Use Python's Pandas library to handle missing values, perform data aggregation, and filter data sets specific to client nationality and visa type.
  • Design interactive dashboards to provide meaningful insights for tracking migration trends
  • Use historical data to predict future trends, such as which services will be in higher demand, which regions might see an increase in clients, or even which applications might be at risk of rejection
  • Identify which services are performing well and which need improvement based on success rates and client feedback

Customer Service

Danfe Consulting
09.2022 - 11.2023
  • Maintained and updated client records, ensuring data accuracy
  • Entered client information into the CRM system, generating regular reports to track application statuses and identify potential issues
  • Scheduled and managed appointments with clients
  • Collected and analyzed client feedback to identify common concerns and suggest actions for service improvements
  • Supported senior analyst by gathering relevant data from client interactions and documentation, contributing to more informed decision-making
  • Received phone calls and interacted with various clients to answer their queries
  • Managed and kept track of the clients’ documents and asked them if the required document is missing

Education

Master - Information Systems

Holmes Institute
Melbourne, Victoria
06.2024

Skills

  • MS Word
  • MS Excel
  • MS PowerPoint
  • Data Warehouse
  • ETL processes
  • Data Cleaning
  • Data Integration
  • Data Mapping
  • SQL
  • Python Programming (Pandas)
  • Excel
  • Tableau
  • Power BI
  • Microsoft SQL Server

Soft Skills

  • Effective time management by prioritizing the tasks and meeting deadlines.
  • Build and maintain good relationship with stakeholders, understanding their needs.
  • Identify and address potential issues before they escalate, ensuring accuracy and quality.
  • Good verbal and written communication skills. Good customer service by actively listening to clients' needs and delivering the solutions.
  • Excel in high-pressure situations, staying calm and focus to make well-informed decisions.
  • Good Presentation Skill

Projects

Road Accident Dashboard

https://public.tableau.com/app/profile/krishmal.shrestha/viz/RoadAccidentDashboard_17229349679140/Dashboard1?publish=yes

References

Available upon request

Timeline

Junior Data Analyst

Danfe Consulting
11.2023 - Current

Customer Service

Danfe Consulting
09.2022 - 11.2023

Master - Information Systems

Holmes Institute

Similar Profiles

CREATE PROFILE
Krishmal Shrestha