Ayo Omoseni: Data Analyst in Columbia, Maryland

Health Resources and Services Administration (HRSA), Division of Injury Compensation Systems, Countermeasures Injury Compensation Program (CICP) PM Services Project. HRSA Data Lakehouse Project. CMS Physician Fee Schedule (PFS) Project. * Review and analyze program and operational data system collection and processing for CICP claims. * Perform development of business intelligence solutions for the CICP program. * Understand business requirements and processes to enhance the CICP business processes and workflow. * Design, implement, and maintain multiple iterations of claims reporting data analytics dashboard in Tableau. * Run data validation and cleansing for ingested data for PFS Project. * Design QuickSight dashboard for reporting on physician fee schedule reporting. * Maintain QuickSight dashboard for reporting on physician fee schedule reporting. * Create SQL solution for reporting UDS formulas on Data Lake House Project. * Expand UDS formulas for granular and fact tables for Data Lake House Project. * Maintain Tableau dashboard for UDS reporting for Data Lake House project, * Write DDL and DML SQL queries for raw and target tables for HRSA Data Lake House Project. * Collaborate with DevOps to create procedures for data ingestion from raw to target tables for Data Lake House Project.

* Developed and monitor dashboards in Looker to track KPIs. * Created Looks in Looker for stakeholder perusal. * Created LookMLs using SQL in Looker to incorporate new UTMs for marketing initiatives. * Created UTM parameters using SQL for marketing initiatives. * Created dimensions in Looker using SQL for new Looks. * Wrote SQL queries in Snowflake to manipulate data for ad-hoc reporting. * Executed ad-hoc data extraction using SQL queries. * Retrieved data from disparate tables using Joins and Sub-queries. * Created fact tables to populate APP metrics in Snowflake. * Investigated several tables in Snowflake for data discrepancies and data validation. * Tracked and monitored acquisition through web traffic using Amplitude. * Tracked user web journey and create action items on user paths. * Tracked and monitored APP initiatives using Branch. * Created reports on organic and paid search/social acquisitions, drawing insights for the stakeholders. * Collaborated cross-functionally with product, marketing teams on reporting and analysis.

* Developed new BI reports, maintain existing dashboards and portals in Tableau. * Created complex SQL stored procedures, views and functions using best practices and efficient code. * Maintained code using TFS and follows change management process for migration and deployment. * Created, published, and presented custom interactive dashboards and reports using Tableau Desktop. * Extracted, transformed, and loaded data from different RDBMS. * Assessed and analyze missing and invalid data in payer claims data. * Executed ad-hoc data extraction using SQL queries. * Employed data visualization tools to provide an uncomplicated interface for end users to easily identify decisive themes within their data. * Collected functional and non-functional user requirements to optimize visualization of business requirements and deliverables. * Deployed Tableau dashboards and worksheets in a clustered environment. * Created bubble charts, motion charts and drill down analysis on Tableau desktop.

* Collected, organized, and analyzed data to effectively communicate findings to stakeholders. * Used Pivot tables to create reports that did dicing and slicing functions on data. * Validated data through data exploration and entry in excel. * Developed SQL queries to extract and manipulate data for satisfactory data and reporting requirements. * Executed Ad ad-hoc reporting analysis using SQL in SQL server. * Created performance reports using aggregate functions in SQL. * Extracted data from flat files and load the data into the target tables. Security Clearance * Public Trust, June 2022