Analytics Project
Impact of Virtual Care Services Healthcare Expenditures
02.2023 - 04.2023
Ivon Mbuyamba
Edmonton,AB
Summary
With over three years of experience as a Data Analyst, I help clients transform complex data into intuitive visualizations that guide strategic business planning and decision-making. As a recent MBA graduate with a specialization in Business Analytics, I have advanced knowledge and skills in data analysis, strategic business intelligence, and decision-making processes. I leverage my Power BI, PostgreSQL, and Python expertise to conduct in-depth data analysis, uncover key business trends and anomalies, and automate data processing and workflows.
Certification
- Data Analyst Associate (PostgreSQL), Datacamp - 2023
- Power Platform Fundamentals, Microsoft - 2023
Timeline
Data Analyst Consultant
Pilgrim Data Services Inc.
09.2020 - Current
Business Operations Manager
Eyeland Optometry
09.2019 - 09.2020
Business Operations Manager
City Centre Eye Care
09.2016 - 08.2019
Communication Coordinator
Edworthy Vision Corp.
09.2010 - 08.2016
MBA - Business Analytics
University of Fredericton
Bachelor of Arts - History And Philosophy
University of Toronto
Skills
- Data Analysis, Visualization & Presentation: PostgreSQL, Power BI, Excel (including Macros, VBA, Pivot Tables), Power Query, Tableau
- Programming & Database Management: Python (with libraries like Pandas, NumPy), SQL
- Data Management & Optimization Techniques
- Understanding of market dynamics, financial literacy, and strategic planning
- Risk and Opportunity Analysis
- Stakeholder Engagement & Adaptability
- Project Management
- Statistical Analysis
- Strong Work Ethic
- Attention to Detail
- Communication and Teamwork
- Analytical Problem-Solving & Critical Thinking
Work History
Data Analyst Consultant
Pilgrim Data Services Inc.
Oshawa, ON
09.2020 - Current
- Strategic Business Intelligence: Developed and optimized Power BI dashboards that improved client decision-making by 25%.
- Specializes in transforming complex data into intuitive visualizations guiding strategic business planning.
- Data-Driven Operational Efficiency: Conducted in-depth PostgreSQL analysis to uncover key business trends and anomalies, directly contributing to a 20% increase in operational efficiency.
- Process Automation and Efficiency: Automated data processing and analytics workflows using Python, improving accuracy, and freeing up resources for core business activities.
- Collaborative Strategic Consultation: Worked closely with cross-functional project teams, pivotal in defining data requirements and interpreting complex data findings.
- Used advanced data analysis to optimize patient flow management for a healthcare client, leading to a 15% reduction in wait times and a 10% increase in patient satisfaction.
Business Operations Manager
Eyeland Optometry
St. Albert, AB
09.2019 - 09.2020
- Spearheaded the management and analysis of diagnostic databases, resulting in a 15% improvement in data accuracy and record-keeping efficiency for the medical office.
- Interpreted and analyzed test results from diagnostic machines and tests to improve patient management and determine appropriate next phases of care.
- Revolutionized patient data management, achieving a 30% improvement in treatment planning accuracy.
- Clustered and segmented patient data based on diagnosed conditions to enhance patient care and treatment plans.
- Tracked patients' churn, exam records, medical billing, and sales data of OTC drugs and contact lenses using SQL queries.
- Managed contact lens inventory and analyzed sales trends using Python scripts and Excel.
Business Operations Manager
City Centre Eye Care
Edmonton, AB
09.2016 - 08.2019
- Developed customer-centric marketing strategies through detailed data analysis, leading to a 25% increase in customer satisfaction and engagement.
- Collaborated with cross-functional teams to understand business needs and develop data-driven solutions using Excel pivot tables and conditional formatting.
- Coordinated marketing events for showcasing product and service offerings using project planning and scheduling skills.
- Assisted with communication strategies and implemented tactics to support business objectives using active listening, written, verbal, and relationship building skills.
- Proposed internal and external ideas and initiatives to help promote general awareness of company brand using strategic thinking and creative skills.
- Developed internal and external marketing communication and collateral pieces to support localized initiatives using Microsoft Word, PowerPoint, and Adobe Photoshop.
Communication Coordinator
Edworthy Vision Corp.
Calgary, AB
09.2010 - 08.2016
- Analyzed customer data using Excel pivot tables and conditional formatting to determine appropriate marketing offerings and strategies.
- Collaborated with cross-functional teams to understand business needs and develop data-driven solutions.
- Coordinated marketing events for showcasing product and service offerings using project planning and scheduling skills.
- Assisted with communication strategies and implemented tactics to support business objectives using excellent communication skills.
- Proposed and developed internal and external marketing communication and collateral pieces using strategic thinking and creative skills.
Analytics Project
Impact of Virtual Care Services Healthcare Expenditures
MBA Program, University Of Fredericton
02.2023 - 04.2023
- Developed and managed a PostgreSQL database in pgAdmin4, handling over 10 GB of healthcare data, combined with rigorous data validation to ensure accuracy and completeness.
- Utilized Power BI for data modeling and visualization, identifying key correlations between virtual care and reduced emergency visits for self-harm.
- Designed an optimized database schema, enhancing data analysis efficiency and conducted statistical analysis to forecast health expenditures, indicating an upward trend.
- Demonstrated project management and analytical skills, aligning with roles in Data Analysis, Consulting, and Business Intelligence.
Education
MBA - Business Analytics
University of Fredericton
Fredericton, NB12-2023
Bachelor of Arts - History And Philosophy
University of Toronto
Toronto, ON11-2011
Overview
13
13
years of professional experience
1
1
Certificate
Similar Profiles
Francisco Javier Chavero, Jr.Francisco Javier Chavero, Jr.
Environmental Program Manager (EPM) at Amazon Web Services (AWS), Amazon Data Services, Inc.Environmental Program Manager (EPM) at Amazon Web Services (AWS), Amazon Data Services, Inc.
Madhushree GMadhushree G
Process Associate at Bread Financial Services (All data card services)Process Associate at Bread Financial Services (All data card services)
Mikal AlcalaMikal Alcala
Operations Manager at Sharecare Health Data ServicesOperations Manager at Sharecare Health Data Services