Qualification Highlights

Tableau developer with Power BI, QuickSight, Looker experience

Master’s degree in management information systems

Five years’ BI experience with excellent Excel skills

Four years’ + experience in healthcare industry

Ethical business intelligence developer with 5+ years applying information technology to foster decision making and business processes to amplify business strategies. Remarkably proficient in identifying business requirements, driving process improvement, and designing IT solutions that enhance business growth.

Education

M.S., Management Information Systems, Bowie State University, 2019

Certifications and Training

Certified Information Systems Analyst, Bowie State University, 2019

Certified Power BI Data Analyst, Microsoft, 2023

Skills and Technologies

Tableau

Looker

AWS QuickSight

Power BI

TSQL and SQL

Business Intelligence

Requirements Gathering

Presentation and Report Writing

SQL Server, Snowflake

QNXT Claims System

Microsoft 365 tools

Agile Development

Jira

Confluence

Work History

Index Analytics, Baltimore, MD 04/2022 - Present

BI Developer

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.

Conducted data collection/entry, management, cleaning, and manipulation activities using Excel.

Analyse data in Excel using Pivot tables, pivot charts, Data Validation, conditional formatting, Vlookup, Xlookup and formulas.

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.

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.

Fedex Dataworks, Lanham, MD 05/2020 – 04/2022

Acquisition Reporting/Data Analyst

Developed and monitored 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 user path and 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.

Anthem Inc., Indianapolis, IN

04/2018 – 05/2020

BI Developer/ Reporting Analyst

Developed new BI reports, maintained existing dashboards in Tableau and Power BI.

Analyzed member/provider claims within QNXT Claims System.

Investigated and analyzed denied claims to identify common reasons for denials.

Extracted claims data, member information, provider details from the QNXT system for analysis and reporting.

Created complex SQL queries, views and functions using best practices and efficient code.

Created and presented custom interactive dashboards and reports using Tableau Desktop and Power BI.

Extracted, transformed, and loaded data from different RDBMS.

Assessed and analyzed 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.

Published Tableau dashboards to online servers.

Created drill down analysis in Tableau desktop.

PNC Bank, Pittsburg, PA

06/2017– 04/2018

Data Analyst

Collected, organized, and analyzed data to effectively communicate findings to stakeholders.

Validated data through data exploration and entry in excel.

Used Pivot tables in Excel to create reports that did dicing and slicing functions on data.

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.

Clearance

Public Trust, June 2022

Contact this candidate