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
03.2022 - 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
01.2022 - 03.2022
- 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
04.2018 - 01.2022
- 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
06.2015 - 12.2017
- 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
01.2012 - 11.2012
- 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
05.2010 - 12.2010
- 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, CanadaM.Eng: Software Engineering -
Concordia University
Montreal, CanadaMaster’s in Computer and Applications -
Punjab Technical University
Punjab, IndiaBachelor of Science (Computer Science) -
Punjabi University
Punjab, IndiaSkills
- 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
03.2022 - Current
Database Administator
McGill University
01.2022 - 03.2022
SQL Server Database Administrator, Business Intelligence and Project Management
JP Metal America
04.2018 - 01.2022
Junior DBA and SQL Developer
Saeed and Mohammed Al Naboodah Group
06.2015 - 12.2017
Technical Support
RIMT University
01.2012 - 11.2012
SAP Finance & HR Support and Techical help
Federal Mogul Goetze
05.2010 - 12.2010
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 PizziDomenico Pizzi
Security Agent at Les Commissionaires Du QuebecSecurity Agent at Les Commissionaires Du Quebec
Connor-elie FrigonConnor-elie Frigon
Coordinator at Les YMCA QuebecCoordinator at Les YMCA Quebec
Nicole GonzálezNicole González
Customer Service Representative at Les Entreprises Vinmar Quebec Inc.Customer Service Representative at Les Entreprises Vinmar Quebec Inc.