Emmanuel Odume
Windsor,ON
Summary
Data Analyst skilled in SQL, Tableau, and Python with hands-on experience analyzing and visualizing data to drive business decisions. Passionate about turning raw data into clear, actionable insights to improve company performance. Strong communicator and problem-solver with a focus on collaboration and efficiency.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Business Data Analyst
Primerock Capital
Windsor, Canada
02.2023 - Current
- Optimized mortgage application processes, analyzing financial data and reducing loan processing times by 15%, leading to faster approvals.
- Designed and maintained KPI dashboards in Tableau and Excel, enabling leadership to track key performance metrics and financial trends in real time.
- Wrote and optimized SQL queries, improving data accuracy and processing speed by 25%, ensuring timely and informed decision-making.
- Automated data workflows, cutting manual handling by 15%, reducing errors, and enhancing compliance with industry regulations.
- Developed Excel-based forecasting tools, improving resource planning and boosting operational efficiency by 20%.
- Collaborated cross-functionally with underwriting, finance, and compliance teams to enhance data workflows and ensure regulatory adherence.
- Led data-driven trend analysis, identifying opportunities to streamline financial processes and improve business performance.
Data Analyst
Digital Concept
Toronto, Ontario
03.2020 - 01.2023
- Assisted senior analysts in gathering and processing data from internal and external sources.
- Performed basic statistical analysis and generated reports to monitor business performance.
- Supported the creation of dashboards and data visualizations to track operational metrics.
- Utilized SQL to extract and query data from relational databases for analysis.
- Cleaned and validated data to ensure accuracy and consistency in reporting.
Education
Data Analytics -
University of Toronto
Bachelor of Business Administration -
University of Windsor
Skills
- SQL
- Tableau
- Power BI
- Python
- Excel
- Attention to Detail
- Data Cleaning
- Data Visualization
- Problem-Solving
- Team Collaboration
- Analytical Thinking
- Communication
Certification
Tableau Desktop Specialist Certified
Projects
Pewlett Hackard Employee Analysis
- Designed a relational database system to analyze two decades of employee data.
- Mapped data relationships with an Entity Relationship Diagram (ERD) and implemented optimized table schemas.
- Imported, cleaned, and normalized data in PostgreSQL to ensure consistency and integrity.
- Extracted insights on hiring trends and employee demographics using SQL queries.
- Documented the workflow in GitHub to showcase a clear and replicable approach.
Financial Performance Insights
- Created Tableau dashboards to analyze $2.3M in sales and a 12% profit margin. Visualized sales trends, profit by subcategory, and regional performance to identify key opportunities and challenges.
- Used a 20-day moving average of sales to reveal growth patterns from 2018 to 2022, providing actionable insights for long-term planning.
- Highlighted the most and least profitable subcategories using color-coded visuals, enabling smarter resource allocation and pricing strategies.
- Combined profit (color), sales (size), and state-level details to pinpoint high- and low-performing regions, helping stakeholders focus efforts effectively.
Timeline
Business Data Analyst
Primerock Capital
02.2023 - Current
Data Analyst
Digital Concept
03.2020 - 01.2023
Data Analytics -
University of Toronto
Bachelor of Business Administration -
University of Windsor
Similar Profiles
EMMANUEL ODUMEEMMANUEL ODUME
Business Data Analyst at Primerock CapitalBusiness Data Analyst at Primerock Capital
EMMANUEL ODUMEEMMANUEL ODUME
Business Data Analyst at Primerock CapitalBusiness Data Analyst at Primerock Capital
Chisom Emmanuel OdumeChisom Emmanuel Odume
Mortgage Analyst at Primerock CapitalMortgage Analyst at Primerock Capital