Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Professionalbackground
Timeline
Generic

Karamjeet Singh

Summary

Seeking a challenging and satisfactory job in database development with an organization that helps to provide me good work opportunities to justify my experience alongside enhancing my skills in designated fields.

Overview

8
8
years of professional experience

Work History

Data Architect Team Lead

Capgemini
Toronto
04.2022 - Current
  • Ensured that all applications adhere to established data governance policies and practices.
  • Implemented database objects such as tables, views, stored procedures, triggers and user-defined functions.
  • Provided recommendations on best practices in designing data warehouse architectures.
  • Investigated problems related to the production environment including performance issues, query tuning.
  • Created conceptual and logical data models using Entity Relationship modeling techniques.
  • Performed regular maintenance tasks such as backup and restore operations, index rebuilds.
  • Assisted in developing a roadmap for data migration from legacy systems to new systems.
  • Identified gaps between current state of the system and desired future state of the system.
  • Developed and maintained data architecture standards, models, diagrams and documentation.
  • Deployed scripts for creating, modifying database objects like tables, views, stored procedures, functions.
  • Analyzed business requirements for data solutions to ensure compliance with enterprise architecture guidelines.
  • Worked closely with software engineers in order to design efficient database schemas and queries.
  • Developed processes to monitor performance of databases and tune them for optimal efficiency.

Sql Developer and DBA

Loblaws
Toronto
06.2019 - 03.2022
  • Developed stored procedures, functions and triggers to support application requirements.
  • Provided technical assistance in the form of SQL coding advice to other team members.
  • Used T-SQL scripting language for creating stored procedures, functions, triggers.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Resolved customer service requests related to database errors or performance issues quickly and efficiently.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Developed database schemas, scripts, and models in collaboration with application developers to meet project requirements.
  • Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
  • Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.

Data Analyst

Xerox
Ontario
10.2016 - 05.2019
  • Built visualizations that enabled users to quickly interpret results from complex analyses.
  • Maintained documentation of all the processes related to Data Analysis.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Translated raw data into meaningful information using statistical techniques.
  • Optimized existing database structures for better performance on analytics tasks.
  • Provided data-driven solutions to support decision making.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.
  • Assisted with efforts to track, evaluate and report on impact of programs using multiple data sources.
  • Performed data entry, data cleaning, and data coding for analysis.
  • Utilized predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.

Education

Master of Science -

Master
Lambton College
01-2016

Skills

  • T-SQL
  • SQL-Optimization
  • Database Administrator Role
  • Snowflake
  • Active Batch Job Scheduling
  • DBT
  • Data visualization
  • Requirement gathering
  • Gap analysis
  • ETL (BASICS)
  • Redgate
  • Fog Light
  • Source-Graph
  • Active-Batch
  • Grafana
  • GitLab
  • JIRA

Accomplishments

  • Grabbed first prize in State level Bhangra competition.
  • Member of CSR (Corporate Social Responsibility) Team in Conduent.
  • Was rewarded with top rating in quarterly bonus for providing an automated SQL Script for retro and payroll.
  • Magic With client Award in 2023.

Certification

SnowFlake , Azure Data Fundamentals

Professionalbackground

Having 7 years of IT experience as MS SQL Developer. Major expertise in T-SQL , SQL-Optimization , Database Administrator Role, Snowflake, Active Batch Job Scheduling , DBT, Data visualization, Requirement gathering , Gap analysis .

Timeline

Data Architect Team Lead

Capgemini
04.2022 - Current

Sql Developer and DBA

Loblaws
06.2019 - 03.2022

Data Analyst

Xerox
10.2016 - 05.2019

Master of Science -

Master

Similar Profiles

CREATE PROFILE
Karamjeet Singh