Sign in

Data Software

Montreal, Quebec, Canada
March 07, 2019

Contact this candidate


Khushmita Sandhu

**** ****** *******, ********, ******

514-***-**** H3W 1K9 Canada


Highly-analytical and self-motivated individual, with proven ability to work in dynamic, driven and fast-paced environment

Relevant Work and Academic Experience in Analytics, Data Science, Econometrics, Financial Economics and Risk Management.

Strong acumen for Problem-Solving, Data Analysis and Forecasting and Reporting using R, SQL, Tableau

Excellent ability to grasp new concepts and a very quick learner. Education

Master of Arts, Economics: Specialization: Financial Economics & Risk Management Concordia University (Montreal, Canada) Jan 2016 – Sept 2017

Post-Graduate Diploma, Economics

Concordia University (Montreal, Canada) Sept 2015 – Dec 2015

Bachelor’s in Social Sciences (Dual Honors): Economics & Political Science Guru Nanak Dev University (Punjab, India) July 2012 – May 2015 Technical Skills

Programming Tools & Technologies •R •SQL (Oracle, Exasol) •MATLAB •Stata •Python •SAS

Software & Applications • Microsoft Office • Excel (Advanced) • MS PowerBI • JIRA • Tableau(advanced)

•Relational Database •BI Tools •OLAP •ODS (Operational Data Store) •RTDW Work Experience:

Business Intelligence Analyst May 2018 – Present

NZone Media, Montreal

Extracting reports from multiple sources using different business tools.

Building systems and provide Analytics by transforming raw data into actionable business insights using R, SQL

Designing and develop data visualization solutions using Tableau that synthesize data concepts into clear communications for key business stakeholders.

Data Manipulation using R and Python

Design and Build Interactive and Dynamic Dashboards/ Reports on Tableau using Real Time Data.

ETL and Automating Reports using SQL oracle and Exasol (columnar data) based Real-time data sources.

Presenting a compelling story to provide valuable business insights.

Working on Ad-hoc Requests (Jira tickets) from Stakeholders as per requirements. Technical Support Analyst – Apple Inc. July 2017 – Feb 2018 Teleperformance Canada, Montreal

Analysed technical software / hardware issues faced by customers in Apple products

Provided best possible solutions to resolve the software issue using technical tools

Maintained KPIs above 90% ensuring factors such as customer satisfaction, Business Critical, Regulatory Critical.

Submitted RTAs about emerging software issues

Escalated issues to other technical departments

Invigilator – ACSD Sept 2016 – Aug 2017

Concordia University

Invigilated students with disabilities during their exams ensuring time management for each student confirming to their special needs

Quantitative Experience:

Data Analysis; Analysing Interest Rate Risk using Principal Component Analysis (PCA) September 2017 Masters Research project (21 credits), Department of Economics, Concordia University

Thoroughly Researched and carried out empirical analysis using PCA to analyse Interest Rate Risk in Canadian Market by collecting data from Jan 2000 to May 2017 on Canadian government benchmark bond yields from Bank of Canada

Identified principal components that are responsible for credit risk arising from the market variables, by explaining the movements in bond yields

Identified interesting and consistent trends during pre-, mid- and post- Economic crisis of 2007 -08

Concluded that approximately 98% of the risk in Canadian benchmark bond yields or related securities can be accounted for by the first three factors - parallel shift (approximately 90%), rotation and bowing of yield curve

Visualized the data creating complete(17years), pre-crisis, mid-crisis and post-crisis reports using Pivot Tables and Charts Statistical Data Analysis; Econometrics Projects September 2015 - April 2016 Econometrics, Department of Economics, Concordia University

Carried out several independent empirical Econometrics Projects using raw observational Data on wages2, 401(k), 401(k)subs pension plans, containing information on variables using STATA and MATLAB

Identified appropriate variables to analyse correlations of dependant variable on independent variables using multiple regression techniques such as Ordinary Least Squares Technique (OLS), Weighted Least Squares Technique (WLS), etc.

Estimated Linear probability model using explanatory variables and obtained usual OLS and WLS standard errors and heteroskedasticity-robust versions to evaluate the differences

Calculated R^2 (coefficient of determination) and adjusted R^2 to conclude about goodness of fit.

Obtained the fitted values from the Linear programming model. Evaluated if the fitted values are negative or greater than 1.

Reported and interpreted the results plugging variables as Instrumental Variables (IV)

Carried out various tests on null hypothesis against stated alternative hypothesis using F-tests, t-tests, Chi-square tests

Simulated errors from a Gaussian distribution and non-Gaussian Distributions

Visually depicted Regression results to observe different parameters and find the solutions using problem-solving techniques Data Analysis and Research; Risk Management Projects September 2016-April 2017

Various projects on market, credit, and operational risk modeling using techniques from financial economics, statistics and time series methods

Calculated VaR(x%) on the 1,500 days preceding March 10, 2006 data for the NASDAQ Composite index for a $10 million portfolio invested in the index using basic historical simulation approach, Exponentially Weighted Moving Average (assuming λ = 0.995), Extreme value theory with u = 300 and equal weightings and submitted a report for the differences between results

Using Excel, estimated the expected loss from default, the probability of default, and the recovery rate using Merton’s model in the event of default from the given observational data

Researched and submitted a final analytical report on several regulatory changes (and their motivation) to some aspects of Basel II that have been implemented post 2008 crisis, including but not limited to Market risk, Credit Risk and Operational Risk Research; Environmental Risk July 2017

Masters Term Paper, Department of Economics, Concordia University

Researched and Evaluated aspects of Environmental risk central in socio-economic research promoting sustainable development.

Developed evaluations on various Self-enforcing International Environmental Agreement (IEA) models and regulatory policies established to control and manage risk from environment

Developed a report visualizing contrasts between different aspects of environmental risks from traditional and modern models

Collected data from assessments on Kyoto Protocol and evaluated self-enforcing agreements and other environmental risk models to validate results.

Created a report on recommendations for further studies

Contact this candidate