Azeez Sanusi
Mansfield, Dallas,TX
Summary
6+ years of Extensive experience in Data Engineering and Data Analyst working with SQL Server, Snowflakes Cloud, and Raw Data pull from optimum. Designing and developing dashboards and reports utilizing power BI, and Smartsheet Developer in healthcare with the successful ability to turn data into a product. Worked with Smartsheet and dashboard for Smartsheet with expertise in data visualization and reporting in Smartsheet and project manage assigned tasks with healthcare fee schedule tracking Proficient in multiple database technologies such as Oracle, Sqlyog, workbench, and SQL server studio General understanding of Project Management in relation to data and Pulling from Data Warehousing Worked with ETL process to Extract, Transform and Load the data into the stage area with extensive knowledge of managing snowflake cloud data warehouse and Database Design with Snowflake. Dealing with AWS S3, SFTP sites, and azure containers for data storage and Data Transfer. Create a Daily store procedure on a group of structured data with parameters to the data type with encryption. Involved working Professional, Facility, and Worker Compensation Fee Schedule. Used SLP to analyze and test EAPG, Ambulatory APC, and Medicare ASP Drug Pricing. Involved working with OPPS, IPPS, RVUs, DME, Pharmacy, and Labs Fee Schedule pull raw data from CMS and Optimum.
Overview
10
10
years of professional experience
Work History
Data Analyst
Sedgwick CMS
07.2022 - 04.2023
- Fee Schedule, SQL &, Focused on provider data and provider data management from Medicare and Medicaid knowledge of medical coding
- Develop fee schedule business specifications and Change Requests requesting enhancements
- Create a Daily store procedure on a group of structured data with parameters to the data type with encryption
- Involved working Professional, Facility, and Worker Compensation Fee Schedule
- Used SLP to analyze and test EAPG, Ambulatory APC, and Medicare ASP Drug Pricing
- Involved working with OPPS, IPPS, RVUs, DME, Pharmacy, and Labs Fee Schedule pull raw data from CMS and Optimum
- Worked with Smartsheet and dashboard for Smartsheet with expertise in data visualization and reporting in Smartsheet and project manager assigned tasks with healthcare fee schedule tracking
- Create a Smartsheet portfolio to track fee schedule ticket Backlog, Process log, and Completion log to improve productivity by 30% every month
- Create a Smartsheet, sheets with column types and indented rows, worked with grid, Gantt, calendar, and card views
- Worked with Smartsheet filters, color with conditional formatting, formulas, and updates with highlight changes
- Worked with Smartsheet to empower teams to track projects, processes, and resources to improve and drive fee schedule delivery
Healthcare Medicaid Medicare Claims Analyst
Aetna CVS Health
06.2021 - 07.2022
- Creating high-level smart sheet report daily to increase fee schedule workers’ compensation Efficiency
- Research and review the state Workers’ Compensation Fee Schedule
- Performs data analysis using database query tools to build up fee schedule table and methodology
- Created tables, views, store procedures, CTE, and SQL scripts
- Develops detailed load requests for updates to the provider data
- Working within the growing knowledge of HIPAA, EDI and privacy, security, Medicaid, and Medicare
- Environment: Sqlyog, MS Access, Schedule Link Processor, Smartsheet, Responsible for data modeling, creating a logical and physical model
- Created tables, views, procedures, and SQL scripts
- Understands and/or learns the client’s business requirements for maintenance of provider data within QNXT
- Develops detailed load requests for updates to the provider data
- Maintains tracking of work products utilized during the analysis of QNXT data to the information received from the Provider Group
- Executes SQL queries to pull QNXT data
- Runs complex Excel processes to migrate provider data and QNXT data to perform data validation
- Maintains a favorable working relationship with all project stakeholders to foster and promote a cooperative and harmonious working climate that will be conducive to maximum employee morale, productivity, and efficiency/effectiveness
- Resolve complex, severe exposure claims, using high service-oriented file handling
- Respond to external and internal requests for the release of information contained in medical records, copying medical records and selective extracts by laws and regulations
- Followed adjudication policies and procedures to ensure proper payment on claims
- Extensively worked on EDI gateway and fee schedule with HIPAA regulation (HCFA1500, UB04, ICD09/ICD 10)
- Working within the growing knowledge of HIPAA 830, 834, 835, 205, 270, 271,276, 277,278, C69 and C70, EDI and privacy, security, Medicaid, and Medicare
- Environment: TSQL, Schedule Link Processor, Excel Reporting Tools, MS Access and QNXT
Correctional Officer IV
Criminal Justice Huntsville Tx
06.2018 - 05.2021
- TDCJ is a Criminal Justice Detention, and Corrections Officer focused on maintaining peace, security, and safety within correction centers and jail systems
- Extensively trained in crisis prevention and intervention
- Able to remain calm and confident even in the most adverse and stressful working conditions
- Responsibilities
- Historical Data Research and Database Maintenance (Security Domain)
- Implemented defensive tactics and physical restraints to maintain the safety and security of personnel and the public
- Assisted in restraining violent and unruly inmates
- Monitored inmate behavior to prevent crime, escape attempts and other dangerous activities
- Supervised meal distribution and observed inmates during meals
- Excellent analytical person
- Transport inmates to and from for medical assistance in outside unit care
- Environment: Azure Cloud Security, MS Excel
IT Project Coordinator
Lekki Garden Estate
Lagos Nigeria, Lagos
01.2013 - 12.2016
- Built a portfolio management solution using Smartsheet Control Center and visualized project/portfolio level reporting through dashboards
- Responsible for data modeling, creating a logical and physical model
- Created tables, views, procedures, and SQL scripts
- Created a view on the table to show updated data from the database
- Dashboard Visualization through Power BI application
- Building and publishing customized interactive reports, dashboards, and report scheduling using the Power BI server
- Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Power
- Effectively used Power BI's data blending, filters, actions, and Hierarchies feature
- Created various actions in the database like filter actions to send information to other Power BI worksheets and to connect the same in analytical flows
- Built data reporting live dashboards with built-in on-demand data analysis reports using Business Intelligence tools and Techniques, for the leadership and as a part of PMO's endeavor for agency-wide Business Process Improvement & transparency
- Deep understanding of Smartsheet core and advanced applications with an ability to put real solutions in place that maximize the end-user experience
- Ability to design blueprints through Control Center in an optimal and effective way that minimizes manual touchpoints in the system
- Experience in Dynamic View development and Pivot Table creation through Smartsheet
- Experience leveraging and developing Data Shuffle
- Extensive understanding of metric creation through Smartsheet through the utilization of Dashboards and advanced formula creation
- Expertise in the following: Sheets vs Workspace, Reports, Forms, Workflows, Dynamic Views, Pivots, Functions and Formulas, Sales Force Connector (or similar)
- Responsible for overall end-user experience and tracking efficiency gains using Smartsheet applications
- Review all new Smartsheet feature releases, analyze how Digital Radius can leverage new releases, and host end-user engagement sessions to train/advertise new features
- Train and empower Smartsheet users to maximize their use of the system.
Education
Bachelor’s degree - construction Cost Engineering
Lagos State Polytechnic
Skills
BI Reporting Tools: Power BI, Smartsheet, Tableau
Additional Information
- with ETL Process which includes SSAS, SSIS, and SSRS. Daily use of Smartsheet, sheets with column types and indented rows, worked with grid, Gantt, calendar, and card views. Worked with Smartsheet filters, color with conditional formatting, formulas, and updates with highlight changes. worked with Smartsheet to empower teams to track projects, processes, and resources to improve and drive fee schedule delivery. Creating high-level smart sheet report daily to increase fee schedule workers’ compensation Efficiency. Data Management, manipulation, cleaning, processing data, manual data extraction, power query, pivot table, VLOOKUP, and formulas in excel. Involved in the meeting with the Business process to accelerate innovative marketing data and processed it properly and recommendations for cross-channel global marketing campaigns. Designing the Reports based on the Requirement and developing the Tableau reports using Excel files and Oracle database.
Timeline
Data Analyst
Sedgwick CMS
07.2022 - 04.2023
Healthcare Medicaid Medicare Claims Analyst
Aetna CVS Health
06.2021 - 07.2022
Correctional Officer IV
Criminal Justice Huntsville Tx
06.2018 - 05.2021
IT Project Coordinator
Lekki Garden Estate
01.2013 - 12.2016
Bachelor’s degree - construction Cost Engineering
Lagos State Polytechnic