Summary
Overview
Work History
Education
Skills
Timeline
Generic

Navroop Kaur

Summary

SQL and Excel expertise to enhance data quality and efficiency.

Energetic and analytical, possessing strong problem-solving abilities and keen eye for detail. Demonstrates knowledge of database management principles and proficient in SQL and data entry. Capable of optimizing database performance and ensuring data integrity to drive operational success.

Overview

4
4
years of professional experience

Work History

Database Coordinator

Best Buy
05.2024 - 11.2024
  • Used Excel to perform data entry functions.
  • Maintains operations by monitoring error and stoppage messages, observing peripheral equipment, and making adjustments in the process.
  • Monitors and manipulates daily system jobs.
  • Operate various peripherals devices such as desktops, printers and scanners
  • Record manual data to keep financial records complete.
  • Maintained updated and detailed records of calls in physical and electronic database
  • Responded to daily caller requests with information about assistance and time-frames
  • Maintained precise records of all changes made to the database, guaranteeing accurate historical documentation.
  • Optimized database performance by conducting regular audits and updates.
  • Provided timely support to end-users on any database-related queries or concerns, enhancing user satisfaction levels.
  • Improved database usability by creating customized reports for various departments.
  • Collaborated with IT department to develop and maintain secure, user-friendly databases.
  • Streamlined data entry procedures for faster input and retrieval of information.
  • Maintained a high level of accuracy in data entry tasks, resulting in improved overall data quality.
  • Maintained spreadsheets of data across multiple systems.

Data Analyst Intern

United India Insurance Company
01.2021 - 05.2022
  • Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
  • Optimized SQL queries for faster processing times, increasing overall productivity within the team.
  • Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
  • Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
  • Created complex queries by joining tables from multiple databases.
  • Troubleshoot PC, Printers and Scanners.
  • Monitored and controlled data upload, checking for successful data import and quality.
  • Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
  • Identified trends and patterns in complex datasets through exploratory data analysis, leading to actionable insights.
  • Worked closely with senior developers and database admins.
  • Utilized advanced Excel functions to create comprehensive reports that informed decision-making at the executive level.
  • Utilized advanced Excel functions to manipulate large datasets efficiently, ensuring reliable results in analyses performed by other departments.
  • Utilized data visualization tools to effectively communicate business insights.
  • Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

Education

Master of Science - Information Technology

Guru Nanak Dev University
05-2020

Bachelor of Science - Information Technology

Guru Nanak Dev University
05-2018

Skills

  • SQL and database knowledge
  • SQL and Excel expertise
  • C programming knowledge
  • Excellent communication skills
  • Knowledge on Java Programming
  • Python Programming Knowledge
  • Technical support triage
  • Issue escalation
  • Ability to learn quickly and adopt any environments and Strong motivational skills
  • Analyze myself every aspects and ensure to have leadership skills hard working
  • Troubleshoot Network (LAN/WAN)Good Communication Skills, Committed, Result oriented and hard worker learn new technologies
  • Ability to work under critical and time bound activities
  • Familiar with MS Windows and Mac Operating environments

Timeline

Database Coordinator

Best Buy
05.2024 - 11.2024

Data Analyst Intern

United India Insurance Company
01.2021 - 05.2022

Master of Science - Information Technology

Guru Nanak Dev University

Bachelor of Science - Information Technology

Guru Nanak Dev University
Navroop Kaur