Gurpreet Singh Saini

I have involved in various type of projects from planning to implementation, requirement gathering to providing solution

DG Consultant | Internal Deloitte

• Main goal is to Catalog data of various domains using Informatica IDMC
• Providing KT session of each step performed in Data Cataloging journey
• Prepare custom Roles and Access Policies required for governance process
• Configuring Workflows and custom attribute settings
• Configuring Single Sign On (SSO) using Azure AD
• Working on MCC and CDGC to create assets, scanning metadata, etc

Data Analyst | Public Sector

• Collaboration on creating new Data Model with colleagues
• Combine data from multiple sources provided by client
• Data cleansing: remove or correct inaccurate, incomplete, or irrelevant data
• Data Transformation using Power Query to standardize data for analysis

Web Developer | Internal Deloitte

• Website developed from scratch using Node.js back-end in Docker container
• Main goal was to develop a UI to interact with user uploaded CSV file
• Have a web page to upload CSV file and display the data in table format
• Another page to show a map location from data and edit fields to modify data

PHP Developer | Snow Removal company

• Bug fixes for web app and implement success/failed paths for various actions
• Improving JavaScript logics, refactoring HTML code, and CSS chages
• Improve web app. accessibility for screen reader user as per WCAG2
• Resolving issues with PostgreSQL triggers and stored procedures

Developer | Internal Deloitte

• Develop/support Power Query solution in Excel that ingest data from other files
• Supporting internal team to get employees on the project related to their area of interest
• Created Microsoft Forms to insert data inside Excel in proper format
• Automate the processing of uploaded files and sending auto-reply Emails using Power Automate
• Created survey on Qualtrics for gathering data from employees related to their interest

DG Consultant | Retail company

• Setup Data Governance & migration of DQ from on-premises to cloud
• Re-created mappings in Cloud Data Integration (CDI) from IDQ on-premises
• Custom catalog model based on client’s requirement
• On-board various kind of assets in Cloud Data Governance Catalog

Android App Dev. | Greenhouse Deloitte

• Main goal is to create a Chat-Bot App. for Pepper Robot
• Dialogflow CX as backend for the response with OpenAI & CohereAI
• Based on Voice input sent to Dialogflow the Robot response back

Power Query Developer | Internal Deloitte

• Identify the steps that can be automated with in the processes
• Documenting the set of requirements, validation, cleansing and transformation rules for the source data
• Implementing the final solution in Power Query to automate the manual steps of transformation

This was my first IT internship, which I completed as part of my studies at College LaSalle

• Writing Test Cases for API in SoapUI in order to generate Bulk Data
• Use of Groovy Scripting Language to perform required tasks
• Automation of tests and saving results back to the Excel sheet

Founded in 1959 in Montréal, LaSalle College is a private and subsidized post-secondary education institution. It offers collegial and pre-university programs, available both on campus and online.

During my time at LaSalle I learnt most of my key skills that have I have taken through my career such as teamwork and working to tight deadlines. I thouroughly enjoyed my time at college and learned a lot about a healthy work life balance.

I have learned following technology at LaSalle:

• Programming: PHP, Java, C# (dot net), Python, Swift, GoLang
• Web Tools: HTML, CSS, JavaScript, WordPress, Bootstrap
• Database: Firebase, MySQL
• Mobile Tools: XCode, Android Studio
• C# //dot net