Business Intelligence Information Systems
Resume:
Qualification Highlights
Master’s degree in management information systems
Six years’ BI experience using – Tableau, Power BI, QuickSight, Looker, and Excel
Advanced SQL experience for data manipulation and reporting
Experienced in ETL processes using SSIS
Four years’ + experience in healthcare industry
Ethical business intelligence developer with 6+ 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
GitHub
Agile Development
Jira
Confluence
Work History
Index Analytics, Remote 04/2022 - Present
Data and Reporting Analyst/BI Analyst
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.
Analyze policy changes for Medicare payments under the PFS using CPT/HCPCS codes.
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 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.
Analyze policy changes for Medicare payments under PFS using CPT/HCPCS codes.
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, Remote 05/2020 – 04/2022
Acquisition Data and Reporting Analyst
Developed and monitored dashboards in Looker to track KPIs.
Analyzed and created reports on customer retention and churn using YoY and MoM analysis.
Analyzed and created reports on sales by products and categories in relation to customer behavior and marketing initiatives.
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 in Snowflake.
Retrieved data from disparate tables using Joins and Sub-queries in Snowflake.
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 and monitored APP initiatives using Branch.
Created reports on organic and paid search/social acquisitions, drawing insights for the stakeholders.
Created pull requests, pushed code and merged code using GitHub.
Collaborated cross-functionally with product, marketing teams on reporting and analysis.
Anthem Inc., Remote
04/2018 – 05/2020
Data and 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 medica claims reports using ICD-10 codes/Procedural codes.
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