Summary
Overview
Work History
Education
Skills
Websites
Additional Information
Accomplishments
Award
Timeline
Generic

Kahdel McPherson

Toronto,Canada

Summary

Results-focused Business Analyst with strong knowledge of Tableau, data mapping, SQL, and Python Programming.

As a proactive leader am proficient in leveraging reporting tools and translating complex concepts into simple visualization Dashboard solutions. Adept at managing concurrent projects to meet team and management objectives.

Overview

1
1
year of professional experience

Work History

Data Science / Business Analyst Student

Metro College of Technology
Toronto, ON
11.2021 - 08.2022
  • SQL - developed a Bank database to manage customer details, store bank data, and provide an interface for retrieving customer details with accuracy.
  • Tableau - Built interactive dashboard and charts from the dataset for Supermarket exploring enhanced Sales analytics.
  • Used statistical software to analyze and process large data sets.
  • Created graphs and charts detailing data analysis results.
  • Tested, validated, and reformulated models to foster accurate prediction of risk outcomes.
  • Managed large sets of data corresponding to over one(1) million observations, using SQL to format user input and derive desired metrics for input into data visualization tools.

Business Analyst Intern

Superior Analytics Canada
Toronto, ON
03.2021 - 02.2022
  • Created visual representations of product categories and relationships, using Tableau dashboards to highlight desired aspects of key financial and performance indicators.
  • Automated data processing tasks, developed standard data recording procedures, and used SQL to write scripts and macros for a dramatic reduction in data processing times.
  • Utilized Tableau mobile app to develop insightful, legible dashboards accessible through smartphones and tablet devices.
  • Conferred with project managers and other stakeholders to fully understand business needs to plan optimal development approaches.
  • Applied abilities in techniques like active listening and collaborative problem-solving to make a positive impact to meet deadlines
  • As a team member, I analyzed current risk performance data to plan for improvements.

Education

Some College (No Degree) - Advanced Diploma in Data Science And Programming

Metro College of Technology
Toronto, ON
09.2022

Tableau Certified Data Analyst - Tableau Certification

Tableau Certification Toronto ( in Progress )
SalesForce
08.2022

Bachelor of Science - Natural Sciences

University of The West Indies ( Mona Campus )
Kingston Jamaica
06.1992

Skills

  • More than 15 years experience as an SAP SD Analyst at a leading Distribution company in Toronto
  • Advanced Diploma in Data Science and Application and Bachelor's degree in Mathematics and Computer Science
  • Currently pursuing Tableau Certified Data Analyst certification
  • Experience writing SQL queries to access and analyze structured and unstructured data and finding and extracting useful information using Python
  • Proficient in connecting to data sources, preparing data for analysis, performing data transformation in Tableau Prep, exploring and analyzing data, creating interactive content with charts, dashboards and stories, publish and managing content on Tableau Server and Tableau Online
  • Strong organizational, problem-solving, and communication skills
  • A creative thinker, Dependable, and possess analytic and Teamwork skills
  • Connect Tableau to S4HAMA as a datasource for OTC ( order to Cash ) sales analysis

Additional Information

  • Presentation - Excel Pivot Chart, Tableau Dashboard, and Stories creation for Sales, Marketing, and Management.
  • Familiarity with modeling analysis to create targeted insights to inform management as well as meet department objectives.
  • Collaborate with team members and stakeholders to develop and maintain reproducible analytical visualization sales solutions
  • Knowledgeable in analytical tools like R or Python, Databases, SQL scripting, and Tableau.

Accomplishments

  • Created highly effective new programs that significantly impacted efficiency and improved operations in data analysis.
  • Developed relationships with 48 new trading partner clients to assist with successful onboarding resulting in no downtime to Order To Cash (OTC) processing.
  • Analyze and explore trading partner EDI X12 / EDIFACT data for errors during the testing onboarding process to ensure data accuracy we GO-LIVE.
  • Maintain SQL database that stores LIVE trading partner data.
  • Created month-end reports for Excel chart and graphs visualization.

Award

  • Top TeamWorker Leadership Award for year 2021 for assisting members achieve project deadlines.
  • Dependability Merit Award 2022 for going above and beyond at work.

Timeline

Data Science / Business Analyst Student

Metro College of Technology
11.2021 - 08.2022

Business Analyst Intern

Superior Analytics Canada
03.2021 - 02.2022

Some College (No Degree) - Advanced Diploma in Data Science And Programming

Metro College of Technology

Tableau Certified Data Analyst - Tableau Certification

Tableau Certification Toronto ( in Progress )

Bachelor of Science - Natural Sciences

University of The West Indies ( Mona Campus )

Similar Profiles

CREATE PROFILE
Kahdel McPherson