Summary
Overview
Work History
Education
Skills
Accomplishments
Languages
Timeline
Generic

Paramjeet GHUMAN

Montreal

Summary

As a highly effective Business Intelligence and DBA, effective at delivering quality system requirement documentation ahead of tight deadlines. Support in Maintenance in SQL Server, Migration of Databases between Oracle and Microsoft SQL server using ETL to achieve business needs with accurate generated insights.

Overview

14
14
years of professional experience

Work History

Database Administator and Analyst

Les YMCA du Quebec
2022.03 - Current
  • Checking the configurations of SQL and Oracle Servers
  • Creating maintenance and backup plans for the servers
  • Creating Linked Servers, SSIS jobs, Store procedures, and jobs to do the ETLs between the servers and connecting them with applications
  • Documenting all the ETL processes for the User and the department needs for references
  • Moving databases from one server to another
  • Creating high availability, Cluster on and off servers
  • Upgrading the existing SQL Servers
  • Monitoring and optimizing the Server resources Usage
  • Expertise in database designing and capacity planning
  • Rebuilding the indexes at regular intervals for better performance
  • Updating/Deleting Filestream Data
  • Monitored and modified performance using execution plans and Index tuning
  • Created DTS packages for migration of data from Oracle to SQL Servers
  • Created groups, roles, users and assigned access privileges to users
  • Managing Databases spread across multiple servers in Production, Development, staging and test environments
  • Scheduling the DBCC commands to run daily, weekly basis
  • Installed, authored and managed reports using SQL Server and Power BI.

Database Administator

McGill University
2022.01 - 2022.03
  • Support the development and maintenance of clinical data governance model, in compliance with McGill IRB and IT security policies
  • Work collaboratively with researchers, and project members to identify their research software and database needs
  • Where required, coordinate the technical team responsible for: (1) programming the electronic data capture software (e.g
  • REDCap, FileMaker, ABELDent), (2) developing the data storage and management environments, (3) managing and ensuring quality control of data collected and (4) ensuring long-term maintenance and dissemination of data
  • Work with researchers to ensure the appropriate design of databases, including data security, integrity
  • Design data visualization dashboards using PowerBI, Python Dash or similar platforms
  • Curate clinical management data for research, based on the needs of research teams (design, migrate and manage relational databases).

SQL Server Database Administrator, Business Intelligence and Project Management

JP Metal America
2018.04 - 2022.01
  • Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines
  • Installing, configuring and upgrading SQL Server Databases
  • Checking health Stats of the servers and performing optimisation of the servers by solving failing jobs and other performance issues on daily bases
  • Support in Creating ETL solutions from Oracle to Microsoft using Visual studio 2017
  • Database Migration from Oracle to SQL server
  • Supporting in Database Maintenance and Auditing SQL/Oracle server
  • Troubleshooting Oracle and SQL server
  • Support in Creating reports of Microsoft Power BI and Oracle BI publisher
  • Mapped current business and operational processes and offered recommendations for improvement
  • Orchestrated smooth and effective flow of BI data to support end users in giving better results
  • Supporting Data modelling to convert Raw data into structured data SQL
  • Taking part in client meetings to gather requirements and further supporting with functional coding with SQL Coding to help better estimating the User scenario in Business Analysis
  • Supporting IT department in Data warehousing in Microsoft Azure, Microsft SQL Server, and with Oracle databases.

Junior DBA and SQL Developer

Saeed and Mohammed Al Naboodah Group
2015.06 - 2017.12
  • Reformatted large datasets for use in technical applications
  • Monitoring Performance of SQL/Oracle server
  • Verifying and troubleshooting jobs running on SQL/Oracle server
  • Supporting in Database Migration from Oracle to SQL server
  • Supporting Health check in Databases
  • Supporting Auditing of Databases
  • Improvement suggestions for SQL/Oracle server
  • Support in creating procedure for reports in SQL Server with Microsoft Power BI.

Technical Support

RIMT University
2012.01 - 2012.11
  • Resolved problems with malfunctioning products
  • Identified and solved technical issues with a variety of diagnostic tools
  • Provided base level IT support to non-technical personnel within the business
  • Installed software, modified and repaired hardware and resolved technical issues.

SAP Finance & HR Support and Techical help

Federal Mogul Goetze
2010.05 - 2010.12
  • Identified and solved technical issues with a variety of diagnostic tools
  • Followed up with clients to ensure optimal customer satisfaction
  • Resolved problems with malfunctioning products
  • Provided base level IT support to non-technical personnel within the business.

Education

Certificate in Oracle Database, Microsoft Business Intelligence (ETL & Power BI), Big Data. -

College Bois De Boulogne
Montreal, Canada

M.Eng: Software Engineering -

Concordia University
Montreal, Canada

Master’s in Computer and Applications -

Punjab Technical University
Punjab, India

Bachelor of Science (Computer Science) -

Punjabi University
Punjab, India

Skills

  • Root Cause Analysis
  • Workflow Analysis
  • Microsoft SQL Server.
  • Oracle Database
  • SQL Lines.
  • Visual Studio 2017
  • Creating reports with report builder.
  • Proficient in SQL programming Language.
  • Proficient in power BI.
  • Cleaning and Transforming data with ETL tool, SSIS, SSRS, SSAS.
  • Microsoft office 365
  • Microsoft Visio
  • Microsoft power BI
  • Windows
  • Oracle
  • Python
  • PHP
  • SQL
  • SAP finance Module
  • UML
  • Alteryx
  • Tableau

Accomplishments

  • Completed intensive training in database fundamentals and software engineering.
  • Promoted to Senior Help Desk after 6 months of employment.
  • Customer relations Earned highest marks for customer satisfaction, company wide.
  • Conflict resolution Responsible for handling customer account enquiries, accurately providing information to ensure resolution of product/service complaints, and customer satisfaction.

Languages

English(Fluent)
French (intermediate)
Spanish (intermediate)

Timeline

Database Administator and Analyst

Les YMCA du Quebec
2022.03 - Current

Database Administator

McGill University
2022.01 - 2022.03

SQL Server Database Administrator, Business Intelligence and Project Management

JP Metal America
2018.04 - 2022.01

Junior DBA and SQL Developer

Saeed and Mohammed Al Naboodah Group
2015.06 - 2017.12

Technical Support

RIMT University
2012.01 - 2012.11

SAP Finance & HR Support and Techical help

Federal Mogul Goetze
2010.05 - 2010.12

Certificate in Oracle Database, Microsoft Business Intelligence (ETL & Power BI), Big Data. -

College Bois De Boulogne

M.Eng: Software Engineering -

Concordia University

Master’s in Computer and Applications -

Punjab Technical University

Bachelor of Science (Computer Science) -

Punjabi University

Similar Profiles

  • Domenico Pizzi

    Domenico PizziDomenico Pizzi

    Security Agent at Les Commissionaires Du QuebecSecurity Agent at Les Commissionaires Du Quebec

    View Profile
  • Nicole González

    Nicole GonzálezNicole González

    Customer Service Representative at Les Entreprises Vinmar Quebec Inc.Customer Service Representative at Les Entreprises Vinmar Quebec Inc.

    View Profile
  • Dorsaint Emmanuel

    Dorsaint EmmanuelDorsaint Emmanuel

    Laundry Technician at Auberge du QuebecLaundry Technician at Auberge du Quebec

    View Profile
Paramjeet GHUMAN