data analyst

EDUCATION

TORONTO METROPOLITAN UNIVERSITY **** - 2024

Bachelor of Arts (Hons.), Economics and Finance

Minor: Information Technology Management

NOTABLE QUALIFICATIONS

Areas Of Expertise

Data analytics

Data cleaning

Data visualization

Business analysis

Regression analysis

ETL (extract, transform, load)

Analytical insights

Hypothesis testing

Software testing

Business intelligence

System analysis

Trend analysis

Data storytelling

Operational efficiency

Data collection

Artificial intelligence

Data Mining

Requirements analysis

Data Warehousing

Data Reporting

Soft Skills: analytical problem solving, critical thinking, strong verbal/written communication skills, strong technology skills, detail-oriented, self-motivated, strong collaboration/interpersonal skills, adaptability, critical reasoning skills

TECHNICAL SKILLS & TRAINING

Excel: VBA Programming, VLOOKUP, Power Query, Power Pivot, DAX, Pivot Tables, regression analysis, data visualization

R: Data visualizations, data science, summary statistics, analytical insights, hypothesis testing, data frames, linear/log regression analysis

Python: Data analysis, pandas software, jupyter, matplotlib, NumPy, openpyxl

SQL: SQL querying, joins, subqueries, aggregate functions, performance tuning, data cleaning and transformation, data reporting, data manipulation, data analysis, analytical insights

Tableau: Data visualization, data blending/joins, data connection, custom calculations/fields, dashboards, retrieving data with SQL, A/B testing, data analysis, data storytelling, data insights

PROFESSIONAL EXPERIENCE

Data Analyst – Royal Bank of Canada Jan 2024 – Apr 2024

Identified areas for process improvement involving data extraction and data analysis to build and deploy automated reporting systems that improved data reporting efficiency by 85%+.

Analyzed and transformed raw data into meaningful dashboards and reports that highlighted trends and insights essential for continuous tracking for 7 departments.

Maintained data quality and integrity by identifying data sources to ensure accurate reporting of cost profiles.

Supported the migration and validation of client data for new Trade Finance clients and their portfolio of 10,000 financial instruments as part of RBC’s merger with HSBC Bank Canada.

Business System Analyst – Fujitsu Canada May 2023 – Aug 2023

Communicated with business partners and clients to elicit business requirements for ideal AI softwares specific to the business domain of the project to evaluate functionality, efficiency, and scalability.

Prepared documentation that detailed project-specific solutions, outlining meaningful insights, data trends, and data sources suitable for a technical and non-technical audience.

Spearheaded the design rationale of test use cases and communicated findings through presentations and prototypes to senior leaders and stakeholders.

Documented code for prototypes built for conversational AI softwares and conduct periodic unit testing.

Pricing Analyst – State Street Corporation Aug 2021 – Aug 2022

Extracted data from various sources such as spreadsheets and third-party databases to prepare data for analysis by identifying and resolving errors to deliver manual prices to internal/external clients and/or their agents.

Maintained dashboards used for data analysis to internal and external clients and/or agents; Implemented timely updates to dashboards when new clients requested pricing services.

Provided ongoing support to clients and agents when investigating data-related problems in source data.

Communicated findings and insights of pricing data through comprehensive documentation and ad-hoc reports that highlighted key trends of pricing data to stakeholders.

Contact this candidate