Bola Hassan
Data Analyst/Tableau Developer/Business Analyst at Change Health Systems- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Professional Scrum Master™ I (PSM I)
Scrum.orgSep, 2020- Nov, 2024
Experience
-
Change Health Systems
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Data Analyst/Tableau Developer/Business Analyst
-
Feb 2019 - Present
⮚ Data Analysis - Analyze monthly health data (HIPAA) to identify patterns and trends⮚ Experience with Centers for Medicare and Medicaid Services, health care provider data and online data submission process.⮚ Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data⮚ Created T/SQL statements (select, insert, update, delete) and stored procedures.⮚ Use data visualization tools to provide an easy-to-understand interface for end users to quickly identify key themes within their Data⮚ Designing the Reports as per client Requirement and created the reports using Excel file, SQL Server, and Oracle databases.⮚ Business requirement gathering and translating them into clear and concise specifications and queries⮚ Prepare high level analysis reports with Excel and Tableau⮚ Provides feedback on the quality of data including identification of billing patterns and outliers⮚ Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.⮚ Performing daily integration and ETL tasks by extracting, transforming, and loading data to and from different RDBMS.⮚ Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.⮚ Developed automated tool for updating and running quality checks on ERWIN data models⮚ Created Logical and Physical Models using ERWIN⮚ Used SAS to mine, alter, manage, and retrieve data from a variety of sources and perform statistical analysis⮚ Hands on experience to extract data from JSON file and SQL Server and built complex formulas in Python for various business calculations.⮚ Performed DATA MODELING, DATA MIGRATION, consolidate and harmonized data. Hands-on data modeling experience using Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension.
-
-
-
-
Business Analyst
-
Nov 2017 - Jan 2019
⮚ Perform data cleaning tasks while maintaining data integrity ⮚ Analyze data from multiple tables using Join Statements⮚ Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST and volatile tables.⮚ Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group By and OLAP (Online Analytical Functions).⮚ Execute integration and ETL tasks to and from different SQL Server databases⮚ Use DDL & DML Commands and SQL functions to retrieve, manipulate and analyze data⮚ Create dynamic and interactive dashboards that conveys essential information about dataset⮚ Developed, validated, published, and maintained LOGICAL and PHYSICAL data models using Erwin Data Modeler.⮚ Review existing SQL queries & Stored Procedures to identify opportunities for improvements⮚ Performed Data Analysis, created GAP Analysis Document, and performed Data Quality Checking⮚ Create action plan for data and report automation⮚ Identified functional issues and supported IT development team throughout the SDLC
-
-
Education
-
2022 - 2024
University of Maryland Global Campus
Master of Science - MS, Information Technology Database Systems Technology -
2003 - 2008
Lagos State University
Bachelor of Science - BS, Zoology
Community
