Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Harjyot Singh Sethi

Sydney,Australia

Summary

Masters in IT graduate (extension Data Analytics) with hands-on experience in Python, SQL, Tableau, Power BI, and Excel. Skilled in data analysis, ETL, and dashboard development across HR, IT, and business operations. Proven ability to turn complex datasets into actionable insights. Passionate about data-driven transformation in banking and enterprise environments.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Customer Service Representative

Liquorland, Coles Group
Sydney, Australia
10.2022 - Current
  • Ensured customer and staff safety by assessing sobriety and following responsible service of alcohol (RSA) policies.
  • Monitored and enforced age restrictions to maintain full legal compliance with alcohol sales regulations.
  • Managed stock levels, organized product displays, and supported inventory control processes.
  • Conducted routine stock checks, assisted with customer inquiries, and resolved complaints professionally to ensure satisfaction.

Data Analytics Intern

Dynamic IT Solutions
Sydney, Australia
11.2023 - 07.2024
  • Built scalable reporting infrastructure using SQL and Tableau, improving real-time visibility into product performance, marketing funnels, and business KPIs by 30%.
  • Designed interactive dashboards that translated complex datasets into actionable insights, increasing stakeholder engagement by 20%.
  • Conducted deep data analysis on user behavior and market trends, boosting marketing campaign effectiveness by 17%.
  • Synthesized insights from external reports, public datasets, and purchased sources to improve business intelligence and enhance strategic decisions by 15%.
  • Partnered with cross-functional teams to align analytics with business goals and drive data literacy across departments.

Desktop support Engineer

Mphasis ltd
Pune, India
06.2021 - 05.2022
  • Delivered L3 technical support using AWS and Cisco, ensuring optimal system performance across US, UK, Australia, and India.
  • Led process improvement initiatives, enhancing team efficiency and driving successful project outcomes.
  • Managed change control and conducted training to ensure smooth system transitions.
  • Monitored SAP order flows to maintain operational continuity and timely execution.
  • Met key KPIs by reducing average handling time and streamlining ticket queue management.

Education

Master of information Technology - Extension-Data Analytics

University of Technology Sydney (UTS)
Sydney, Australia
07.2024

Bachelor Of Technology - Computer Science

Vishwakarma Institute of Information Technology(VIIT)
Pune, India
01.2021

Skills

  • Python
  • Pandas
  • NumPy
  • Matplotlib
  • Seaborn
  • Excel
  • Pivot Tables
  • VLOOKUP
  • Dashboarding
  • C
  • Tableau
  • Power BI
  • SQL
  • JIRA

Certification

  • Data Analysis with Python by IBM
  • Tableau Boot Camp by Udemy
  • Business and Data Analytics in Python by Udemy
  • Databases and SQL for Data Science with Python

Projects

Access Request & Support Ticket Analytics, Analyzed user access requests and IT support tickets to identify workflow delays, access issues, and departmental trends., Processed data using Python (Pandas) to clean, merge, and standardize formats., Built interactive Tableau dashboards showing access volumes, turnaround times, and resolution trends., Detected repeated access attempts, delayed approvals, and high-frequency issues affecting productivity., Delivered insights to HR and IT to improve onboarding, enforce access policies, and reduce support bottlenecks., Demonstrated the role of data analytics in improving operations and the employee experience. HR Attrition & Productivity Insights Dashboard, Analyzed HR datasets (tenure, performance, resignations) to identify trends in employee attrition., Used Python (Pandas) for data cleaning and transformation, focusing on project load, role changes, and internal mobility., Detected early disengagement signals by analyzing HR service tickets (leave, grievances, IT issues)., Created Power BI dashboards to visualize attrition rates, department-wise exits, and engagement-score correlations., Identified key attrition drivers like repeated transfers, unresolved access issues, and lack of training., Delivered insights to guide retention strategies, improve HR communication, and support early intervention for at-risk employees., Showcased how data analytics enhances employee experience and HR decision-making.

Timeline

Data Analytics Intern

Dynamic IT Solutions
11.2023 - 07.2024

Customer Service Representative

Liquorland, Coles Group
10.2022 - Current

Desktop support Engineer

Mphasis ltd
06.2021 - 05.2022

Master of information Technology - Extension-Data Analytics

University of Technology Sydney (UTS)

Bachelor Of Technology - Computer Science

Vishwakarma Institute of Information Technology(VIIT)
Harjyot Singh Sethi