Experience

Precima, a NielsenIQ Company

• Canada
• Retail
• 1 - 100 Employee

• Senior Software Engineer

  • Apr 2017 - Present

  Toronto, Ontario, Canada

• Senior Business Analyst

  • Oct 2013 - Apr 2017

  351 King St E, Toronto, Ontario, Canada • M5G 0L6 ● Designed data process workflows ● Engaged with client on POC, data sourcing, data analytics projects ● Translated Business Requirements into Functional Requirements and Technical Requirements ● Designed data models to support front end web/BI applications and for backend data analytics in Redshift and Netezza ● Integrated data models for multiple clients ● Conducted data design reviews to ensure quality of data objects and processes ● Managed user access to database… Show more ● Designed data process workflows ● Engaged with client on POC, data sourcing, data analytics projects ● Translated Business Requirements into Functional Requirements and Technical Requirements ● Designed data models to support front end web/BI applications and for backend data analytics in Redshift and Netezza ● Integrated data models for multiple clients ● Conducted data design reviews to ensure quality of data objects and processes ● Managed user access to database environment ● Actively engaged and consulted on an Agile product team ● Completed Business Analysis Certificate from University of Toronto, Continuing Education ● Technology: AWS, Redshift, Netezza, SQL, Shell, Linux, Bitbucket, Bamboo, Jira, Visio

• Business Analyst

  • Aug 2011 - Sep 2013

  438 University Ave, Toronto, Ontario, Canada ● Developed ETL processes to integrate raw client data into data warehousing environment in Netezza ● Automated the creation of reporting tables for Qlikview from transactional data for major grocery and retail clients ● Developed data analytics (including audience selection, offer assignment, production/supply chain files, and reporting tables) to support the execution of 1-to-1 marketing campaigns ● Engaged in data modeling designs ● Created ERDs in Visio ● Awarded with the… Show more ● Developed ETL processes to integrate raw client data into data warehousing environment in Netezza ● Automated the creation of reporting tables for Qlikview from transactional data for major grocery and retail clients ● Developed data analytics (including audience selection, offer assignment, production/supply chain files, and reporting tables) to support the execution of 1-to-1 marketing campaigns ● Engaged in data modeling designs ● Created ERDs in Visio ● Awarded with the President's Circle Award in the Innovation Category (Dec 2012) ● Completed the TDWI Data Modeling course (June 2013) ● Technology: Netezza, Qlikview, SQL, SAS, Shell, Unix, AQT, Excel, Visio



LoyaltyOne

• Canada
• Advertising Services
• 500 - 600 Employee

• Precima - Analyst (Co-op)

  • May 2010 - Aug 2010

  438 University Ave, Toronto, Ontario, Canada ● Developed knowledge in data warehousing structures and practices ● Developed knowledge in retail industry and customer-centric analytics ● Supported the production of reporting data tables ● Assisted with adhoc data analysis



IDC Canada

• Canada
• Market Research
• 1 - 100 Employee

• Associate Analyst (Co-op)

  • Sep 2009 - Dec 2009

  Toronto, Ontario, Canada ● Developed data visualizations using E-tabs, MS PowerPoint, and Excel ● Programmed in VBA to create Excel and PowerPoint macro for automating routine tasks ● Validated skip patterns and assisted in web implementations of surveys



Statistics Canada

• Canada
• Government Administration
• 700 & Above Employee

• Junior Statistician (Co-op)

  • Jan 2009 - Apr 2009

  Ottawa, Ontario, Canada ● Analyzed and manipulated census level datasets in SAS ● Produced written reports and presented results to senior methodologists ● Received training in SAS


Seneca College of Applied Arts and Technology
• Math Tutor (Co-op)

  • Jan 2008 - Apr 2008