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