QUALIFICATIONS

Expert in Microsoft SQL Database development including querying data with Transact-SQL

Administering and Provisioning SQL Database Infrastructure

Expert in developing end to end Machine Learning (ML) algorithm in Microsoft Azure

Capability to create Data Model using DAX and Power Pivot for data analysis using Power BI

Proficient in Python and R Programming Language, Apache Spark, Data Bricks

Ability to work with statistics on IBM SPSS (Statistical Package for the Social Sciences)

Developing solution through Machine Learning (ML) or other analytics modeling techniques

Capability of multi-tasking and have great effective time management skills

Exceptional management skills through organization and time-management

Good communication skill and able to thrive in challenging environment

EDUCATION

Master of Business Analytics (MBAN) September 2022-December 2023

Saint Mary’s University Halifax, Nova Scotia

Bachelor of Computing & Information Systems January 2016- April 2019

Saint Mary’s University Halifax, Nova Scotia

International Chinese Studies Certificate May 2018- July 2018

Beijing Normal University Zhuhai Zhuhai, China

SKILLS

Microsoft Certified: Data Analyst Associate – Certified 2021

Microsoft Certified: Azure Data Scientist – Certified 2023

Oracle Database Administration 2019 Certified Professional- Certified 2021

Microsoft Certified Solutions Associate (MCSA): SQL Database Development - Certified 2020

Data Visualization with Tableau- Certified 2020

Microsoft Certified Solutions Associate: SQL 2016 Database Administration

Data Preparation, Data Visualization and Analyzing Data with Microsoft Power BI

Administering both Oracle SQL and MySQL Database Infrastructure and Provisioning SQL Databases

WORK EXPERIENCE

Institutional Researcher (Data Scientist)- July 2021- Present

Saint Mary’s University

Making survey & collecting responses on Qualtrics then analyzing and reporting data on Power BI

Expert in General Linear Models, Time Series Analysis, Cluster Analysis, Random Forest, Neural Nets

Using Pandas, Scikit-learn, Machine Learning using SDK, data bricks, training & testing models

Working with Machine Learning (ML) Pipeline in Azure Cloud Development Environment

Creating Power BI Template for auto updating all the reports with new data & storing on SharePoint

Analyzing with R Programming, Crystal Report, Python, Power BI, Tableau, SPSS, Oracle SQL, MySQL

Besides internal Data requests, sent data for Macleans survey, CUSC Survey, MPHEC Survey

Analyzing & reporting data using tools like Tableau, Qualtrics, Power BI, SPSS, Crystal Reports, Vena

Identity Access Management Provisioning Analyst- May 2021- September 2022

PC Bank- Loblaw (Toronto)

Maintaining Role Based Access Controls (RBAC)

Working with SAP, ERP, Active Directory, Identity Management Tools

Moving database from MS Access to MS SQL Server and working with BI tools like Power BI Desktop

On/off boarding, problem management associated with access entitlement and termination

Creating, handling helpdesk ticketing system, solving, and closing tickets on ServiceNow

Giving and revoking access from TransUnion and different other platform

Timely resolution of clients IT issues using remote tools

System Analyst- May 2021- July 2021

Saint Mary’s University

Maintaining Oracle Database Engine and university students and business records

Working with SQL, MS-Access, Toad for Oracle, PuTTY, WinSCP, UNIX, Linux etc.

Developing database, spreadsheets, reports, dashboards and presentations

Data extraction from multiple data sources, Data conversion, Data consolidation, manipulation

Document data extraction, mapping, cleansing and migration processes

SQL Database Developer - August 2019- April 2021

Huru Technologies

Develop complex queries using T-SQL and analyzing data primarily using Tableau software

Using Project management software like Microsoft Project and using working on gantt chart also designing, builds and implements relational databases on Microsoft SQL

Writing T-SQL for data validation, data mapping and developing creative dashboards in Tableau

Work with IT department to manage Finance Data on Microsoft SQL Server, ETL with Alteryx

Process large datasets using specialized tools like Power BI, Tableau and SQL

Financial Services Representative- May 2019- July 2019

Concentrix (Citizens Bank)

Responsible for receiving, evaluating, and responding to a high volume of customer inquiries and provide resolutions promptly

Assist with account balance, address change, card service, check order, financial transfers, verify check and deposit posting, statements etc.

Build customer loyalty in a tactful, courteous and responsive manner

Ensures all business transactions follow operational, technical, and regulatory requirements

Data Analyst- October 2018- May 2019

Saint Mary’s University

Using Excel to manage the spreadsheet of student’s surveys and collect different data

Using SPSS software for doing quantitative analysis of 700+ students

Using QDA Miner and Word Stat software to code and do a content analysis of focus group transcript with strong technical and analytical skills

Working with R Programming, Python, Power BI, Tableau, SPSS, Oracle SQL, MySQL etc

Contact this candidate