Michael Hanna
Verified Expert in Engineering
SAP BI Developer
Hamilton, ON, Canada
Toptal member since December 1, 2023
Michael is a visionary data strategist with experience working on different aspects of data. He specializes in data analytics, business intelligence, data visualization, data description, big data, reporting, and data mining while following the predictive data approach. Michael creates actionable insights and in-depth consumer analysis to facilitate decision-making and help business achieve their objectives.
Portfolio
Experience
- Microsoft 365 - 13 years
- Data Analysis - 7 years
- SAP Webi Reports - 7 years
- SAP Information Design Tool - 5 years
- SQL - 5 years
- Database Management - 3 years
- SAP Datasphere - 1 year
- SAP Analytics Cloud (SAC) - 1 year
Availability
Preferred Environment
SAP Datasphere, SAP Analytics Cloud (SAC), Eclipse, Microsoft Power BI, SAP Webi Reports, SAP Information Design Tool, Microsoft 365, Data Engineering
The most amazing...
...thing I've built is a complex data model of over 16 tables using SAP Datasphere and ABAP S4/HANA table.
Work Experience
SAP Datasphere and SAC Data Modeler Consultant
Baillie Lumber
- Built seven data models for traffic management and production using SAP Datasphere and ABAP S4/HANA table. The developed analysis depicted the contractual rates and payments to the transportation carriers.
- Set up SAP Datasphere data connections with SP4. Created spaces, added users, and created catalog assets and data governance in SAP Data Warehouse Cloud (DWC).
- Contributed to SAP Datasphere data architecture and set data model rules.
- Developed analysis to identify missing orders from SAP HANA tables.
- Created dashboards, KPI reports, and TV applications using SAP Analytics Cloud (SAC).
Strategic Product Advisor
Express Scripts Canada
- Crafted a data strategy roadmap for the company data, which identified all data aspects from a data warehouse, including reports, analytics, and processes.
- Built an analysis of one of the company's products to measure product performance, effectiveness, and savings using the company's data advanced statistics measurements and data visualization.
- Contacted two AI platform suppliers to move forward with utilizing AI in the organization, covering areas such as fraud detection and claimants' drug utilization prediction.
Business Intelligence Analyst
AmerisourceBergen
- Worked actively on data migration from .NET and Salesforce to Salesforce CRM.
- Created a data model for using the SAP information design tool for HealthForward.
- Migrated 25 reports from an old platform to a new one as part of a data migration project.
- Created over 100 reports with data visualization and/or tabular approach for clients and benefits providers using SAP BusinessObjects and Microsoft SQL Server. Reports included regular reports and KPI reports.
- Identified issues in the CRM data collection process and provided the CRM business users and developers with an implementation solution.
- Collaborated with a developer to design and build two SAP universes, i.e., business layers, for six benefit payers.
Experience
Traffic Management Data Model
The project also included creating five KPI reports, four dashboards, and TV applications with SAC for the traffic management team. Per the business team's requirements, we used SAC's visualization tools and interactive features to provide quantitative and qualitative business insights.
SAP Datasphere & SAC Consulting
KEY ACTIVITIES
• Designed and built 10+ data models and marts for TM with SAP Datasphere and DWC using views, analytics models, and task chains for production and sales, and leveraging back-end SAP HANA standard tables and SAP CDS views. Each model consists of 5+ tables and CDS views.
• Created tenant architecture and spaces and set up user roles and security at the space level.
• Identified data loading issues and connections in DWC affecting the model dimensions and measurement.
• Analyzed and queried SAP HANA using SQL in Eclipse.
• Established user security, roles, and team security.
• Developed space connections to S/4HANA.
• Replicated data in DWC from S/4HANA CDS and scheduled tasks to load data from S/4HANA using the date filter and partitions.
Education
Master's Degree in Business Analytics
University of Fredericton - Fredericton, New Brunswick, Canada
Master of Business Administration (MBA) in Global Leadership
University of Fredericton - Fredericton, New Brunswick, Canada
Bachelor's Degree in Computer Science
Bishop’s University - Sherbrooke, Quebec, Canada
Certifications
Introduction to SAP Datasphere
SAP
Skills
Tools
SAP Strategic Enterprise Management (SEM), Excel 2016, Microsoft Excel, Microsoft Power BI, Power BI Desktop, Salesforce Sales Cloud
Languages
Python, SQL
Platforms
Eclipse
Storage
Database Management, Microsoft SQL Server
Industry Expertise
Marketing
Other
SAP Datasphere, SAP Analytics Cloud (SAC), SAP Webi Reports, SAP Information Design Tool, Microsoft 365, Data Interpretation, Communication, Privacy, Continuous Learning, Data Analysis, Programming, Ethics, Reporting, Data Visualization, Analytical Dashboards, Interactive Dashboards, Data Analytics, BI Reporting, SAP Data Warehouse Cloud (DWC), Excel Add-ins, Business, IT Project Management, Team Management, Finance, Marketing Strategy, Operations Management, Innovation, Global Business, Economics, Complex Problem Solving, Leadership, Data-driven Decision-making, Algorithms, Data Structures, Data Modeling, Critical Thinking, Financial Accounting, Entrepreneurship, Data Engineering, Data Warehousing, International Development & Economics, Conflict Resolution, Relationship Building, Web Development, Machine Learning, ABAP Core Data Services, Artificial Intelligence (AI), Negotiation, Networking
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring