Summary
Overview
Work History
Education
Skills
Timeline
Generic
Mikhail Ramyed

Mikhail Ramyed

Data Consultant
Toronto,ON

Summary

Highly analytical & process-oriented Data consultant with data manipulation, visualization, and modeling knowledge that aids furnish insight, analytics, and business intelligence to advance opportunity identification, process re-engineering, and corporate growth.

Overview

5
5
years of professional experience
4
4
years of post-secondary education
3
3
Languages

Work History

Data Consultant

Montreal Analytics
Toronto
11.2021 - Current
  • Hands-on knowledge and experience in working with the modern data stack (Snowflake, BigQuery, dbt, Looker, Sigma, Fivetran)
  • Hands-on experience implementing ETL (or ELT) best practices at scale
  • Analyzed transactions to build logical business intelligence model for real-time reporting needs.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Designed and implemented tools to support strategic value chain optimization initiatives.
  • Collaborated with business-unit leaders to identify and prioritize problems.
  • Documented effective and replicable methods for extracting data and organizing data sources.
  • Participated in requirements meetings to understand business needs.
  • Applying best practices for Looker and dbt
  • Skilled in implementing the SCRUM methodology for data projects and leading cross-functional teams
  • Experience in working with many stakeholders from a variety of industries

Data Analyst

EY, Ernst and Young
10.2020 - 11.2021
  • Extract or collect required data for analysis from SAP or other ERP systems
  • Develop data transformation pipelines using Alteryx
  • Perform data reconciliation procedures to confirm the completeness of data extraction using MSSQL and Excel
  • Support the assessment of the data including data validation and profiling
  • Prepare programming logic to test identified data analysis business rules, by coding SQL Server
  • Verify results against given specifications and Visualize result using PowerBI and Tableau
  • Prepare results for review process and update scripts accordingly
  • Prepare working papers documenting steps followed during data assessment process
  • Flag outliers on financial reports like GL, AR, AP, Payroll
  • Verified accuracy, compliance and completeness of team auditing work.
  • Partnered with auditors to track errors and add contributions to maintain accuracy.

Account Executive - Payables and Receivables

Nadir Electric
Scarborough
2019.04 - 2020.03
  • Met existing customers to review current services and expand sales opportunities.
  • Informed customers of promotions to increase sales productivity and volume.
  • Negotiated prices, terms of sales and service agreements.
  • Recorded accurate and efficient records in customer database.
  • Fostered lasting relationships with customers through effective communication and quick response, resulting in long-term loyalty and expanded client base.
  • Maintained records by imaging invoices, debits, and credits.

Mathematics Tutor

Sheridan College - Davis Campus
Brampton
01.2018 - 04.2019
  • Supported students with helpful study habits and exam strategies.
  • Designed age-appropriate math activities to help student progress.
  • Used positive reinforcement, repetition, and review to help students master challenging material.
  • Met with students and discussed educational goals and expectations.
  • Coordinated tutoring efforts with teachers prior to student sessions.
  • Self-prepared materials based on school math curriculum to increase student comprehension.
  • Collaborated with students to complete homework assignments, identify lagging skills, and correct weaknesses.

Education

Diploma - Engineering

Sheridan College
Mississauga, ON
05.2018 - 05.2019

Bachelor of Science - Mathematics With Statistics

University of Mauritius
05.2014 - 05.2017

Skills

Looker Developer Certified

undefined

Timeline

Data Consultant

Montreal Analytics
11.2021 - Current

Data Analyst

EY, Ernst and Young
10.2020 - 11.2021

Account Executive - Payables and Receivables

Nadir Electric
2019.04 - 2020.03

Diploma - Engineering

Sheridan College
05.2018 - 05.2019

Mathematics Tutor

Sheridan College - Davis Campus
01.2018 - 04.2019

Bachelor of Science - Mathematics With Statistics

University of Mauritius
05.2014 - 05.2017
Mikhail RamyedData Consultant