Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Japinder Kaur

Edmonton,Canada

Summary

Detail-oriented professional with 8+ years of experience in data analytics, system administration, and business operations. Known for improving workflow efficiency, ensuring data accuracy, and delivering actionable insights through custom dashboards and reports. Skilled at navigating diverse business functions, from executive support to IT troubleshooting. Proficient in SQL, Power BI, Tableau, and Excel, with a strong understanding of back-end data systems and front-line user support.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Administrative Assistant/Analyst

Celestial Immigration Services
02.2022 - 05.2025
  • Worked in a dual role supporting both business analysis and office operations. Led the effort to digitize internal workflows, improve reporting accuracy, and ensure smooth day-to-day IT and administrative functions.
  • Provided general administrative support, including filing, organizing data, and coordinating with other departments.
  • Contributed to accounts receivable, invoicing, and year-end audit report preparation.
  • Maintained accurate customer records, handled data entry, and ensured data compliance and integrity.
  • Supported data cleansing activities, enhancing overall data quality and reliability.
  • Designed interactive dashboards using Power BI to track client service metrics and workflow bottlenecks.
  • Cleaned, reconciled, and maintained client data to improve CRM performance and accuracy.
  • Handled financial record-keeping, including invoicing, accounts receivable tracking, and audit prep using Excel.
  • Provided first-level tech support for internal staff, resolving common network, printer, and software issues.
  • Managed procurement and setup of laptops, monitors, and licenses; tracked renewals and hardware life cycles.
  • Authored step-by-step guides for IT troubleshooting and routine admin procedures to support business continuity.
  • Acted as a point of contact across departments to streamline document flow and customer communication.
  • Project: LMIA department
  • Tools & Tech Used: Power BI, Tableau, Microsoft SQL Server, Excel, DAX, Microsoft Office Suite, Windows OS, CRM/ERP tools, IT asset management software

System Analyst

Tata Consultancy Services (TCS)
09.2013 - 02.2021
  • Part of a global team delivering technical solutions and system support for enterprise clients. Played a key role in database optimization, data migration, and business reporting initiatives for large-scale projects.
  • Wrote and optimized complex SQL queries for large datasets stored in Oracle environments.
  • Created scripts for data cleansing, validation, and migration during application upgrades.
  • Worked closely with QA teams to test new features and fix defects before and after releases.
  • Generated performance reports on database health and resource usage for technical teams.
  • Collaborated with business users to gather data requirements and build tailored reports and analytics views.
  • Contributed to UAT cycles and wrote detailed documentation to support future development and maintenance.
  • Project: TCS bancs
  • Tools & Tech Used: Oracle SQL, PL/SQL, Microsoft Excel, Windows Server, Jira, Git, HTML, JavaScript

Education

Postgraduate Certificate - IT Network Security

Conestoga College
Kitchener, ON
12.2021

Bachelor of Technology - Electronics and Communication Engineering

Guru Nanak Dev University (GNDU)
07.2013

Skills

  • Data Analysis & Visualization (Power BI, Tableau, SQL)
  • Business Intelligence Reporting & KPI Dashboards
  • System & Software Troubleshooting
  • Administrative Operations & Financial Coordination
  • Process Improvement & Documentation
  • IT Asset Procurement & License Management

Certification

Power BI Data Analyst Associate – Microsoft (In Progress)

Timeline

Administrative Assistant/Analyst

Celestial Immigration Services
02.2022 - 05.2025

System Analyst

Tata Consultancy Services (TCS)
09.2013 - 02.2021

Bachelor of Technology - Electronics and Communication Engineering

Guru Nanak Dev University (GNDU)

Postgraduate Certificate - IT Network Security

Conestoga College

Similar Profiles

CREATE PROFILE
Japinder Kaur