Chisom Emmanuel Odume

Data Analyst with expertise in Python, SQL, and Tableau, developed through the University of Toronto's Data Analytics Bootcamp. Skilled in transforming complex data into actionable insights to drive decision-making and operational efficiency. Adept at collaborating to achieve team objectives and support business growth.

Employee Data Engineering and Analysis

Tools: SQL, Relational Database Management, Data Modeling, Data Analysis

• Designed a relational database from historical employee data (1980s–1990s) by creating an Entity Relationship Diagram (ERD) to map table relationships, primary keys, and foreign keys.
• Built table schemas for six datasets in SQL, defining appropriate data types, constraints (NOT NULL, UNIQUE), and relationships to ensure data integrity.
• Imported datasets into a relational database and wrote complex SQL queries to extract insights:
• Analyzed employee hiring patterns, departmental assignments, and managerial hierarchies.
• Identified trends in salary distribution and departmental roles using JOIN, WHERE, and aggregate functions.
• Generated frequency counts of last names and filtered data using pattern matching for specific criteria.
• Demonstrated strong understanding of relational database design, data engineering, and SQL scripting to answer analytical business questions

Data Visualization Project: CO2 Emissions Analysis

Tools: Tableau, SQL, Excel

• Designed and developed interactive dashboards to analyze CO2 emissions trends, contributors, and actionable insights for sustainable business growth.
• Built four dashboards to address key business challenges:
• Emissions Growth Analysis: Highlighted unsustainable emissions trends from 2019-2022 and their potential impact on scaling.
• Category Contributions: Identified Folders and Papers as top CO2 contributors, accounting for 30% of total emissions, guiding targeted reductions.
• Geographic Insights: Mapped state-level emissions, revealing over 50% of emissions from two states, and recommended region-specific strategies.
• Multifactor Analysis: Explored additional factors (e.g., shipping, energy usage) in California and Texas to identify holistic mitigation approaches.
• Demonstrated skills in data storytelling, trend analysis, and problem-solving, showcasing the potential for emission reductions and sustainable growth.

• Tableau Desktop Specialist Certified

• Learning new skills on Udemy
• Playing chess to sharpen strategic thinking
• Staying informed with the latest news