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
DBT Developer Certified
SnowPRO core Certification
Scrum methodology
Stakeholder relationship management
Risk Assessments
Agile frameworks
Sigma
Microsoft Excel
Github
Python
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