Shafquat Arefeen Resume

Shafquat Arefeen

Data Analyst & Engineer

Welcome!

I ❤️ data! I consider myself a translator between big data and the people who need to understand it to make business decisions. While you're here, why don't you check out my resume or my portfolio?



Toronto Real Estate Market

GTA's (Greater Toronto Area) Real Estate Market is a mystery as data is withheld from the public and housing prices countinue to go up. Through a series of scraping and data cleaning techniques, I was able to pull 2 years of data and visualize it to help the public make informed data-based decisions.

View Project

BASc Engineering Science, Majoring in Math, Statistics, and Finance from the University of Toronto


Ontario Securities Commission

Financial Data Analyst

May 2016 - Present

  • Create Tableau Dashboards both AdHoc and for reporting purposes internally and for external parties
  • Improve data quality by using tools such as SQL, DB2, Anaconda, Excel, and R Studio to investigate the data and find inconsistencies
  • Work on database creation and provide insight to IT team for specifications

Decision Resources Group

Associate, Data & Analytics

May 2014 - August 2015

  • Compiling medical device reports using SQL databases, Visio Market maps and XML codes
  • Operating both independently and with multiple analysts to cover different parts of the medical device landscape
  • Working with big data sets and using statistical strategies to make observations

Ontario Ministry of Finance

Finance Intern

May 2013 - August 2013

  • Working with the Treasury and Finance department team to create public documents for OFA annual reports on government issued bonds
  • Research into ABCP and MAV Notes after recession; Research of debt in all provincial budgets
  • Preparing foreign exchange adjustments on non domestic currency and working with derivatives
  • Organizing debt portfolios through debt history and reconciliations

Skills

  • HTML
  • CSS
  • Ruby on Rails
  • Python
  • Tableau
  • Excel

In Conclusion

I build data visuals using Tableau, R, Python, and D3.js. I have a growing interest in machine learning and it's applications to data science. Check out my public code at my github. I keep my private repositories on Bitbucket. Tweet at me.