Results-driven Business Intelligence Analyst with extensive experience at Consumer Direct Care Network, leveraging SQL and Power BI to enhance data accuracy and operational efficiency. Proven track record in optimizing ETL processes and developing dynamic dashboards, while fostering collaboration across teams to drive strategic decision-making and compliance.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst III
Consumer Direct Care Network
Remote, Mary
08.2024 - Current
Optimized business intelligence strategies by integrating AI with Power BI, increasing data-driven decision-making efficiency by 20% for client service utilization.
Co-led the design of a scalable Azure Synapse data warehouse, cutting report generation time by 50%, and improving data refresh and query performance by 25%.
Implemented dynamic KPI alert thresholds, successfully flagging 98% of potential overuse or underuse cases, mitigating Medicaid overbilling risks, and reducing overtime costs by 15%.
Managed a Power BI automation project, creating a custom DAX formula library that cut report development time by 30%, saving the Analytics Department 20 hours per week, and improving budget forecasting accuracy by 30%.
Worked with teams to build self-service reports and establish automated processes for large-scale data analyses.
Data Analyst III
Consumer Direct Care Network
Remote, Maryland
01.2024 - 08.2024
Spearheaded ETL pipeline development and optimization, achieving a 35% boost in data accuracy and process efficiency.
Implemented self-service Power BI dashboards, cutting IT report requests by 40%.
Enhanced performance of billing and authorization analysis queries by 45% using advanced SQL techniques such as window functions, CTEs, and indexing.
Created automated workflows for data validation, reducing eligibility processing errors by 35%.
Worked with internal teams to understand business needs and changing strategies.
Utilized statistical techniques to interpret data and analyze results, providing actionable insights to stakeholders.
Supported initiatives for data integrity and normalization.
Data Analyst II
Consumer Direct Care Network
Remote, Maryland
07.2022 - 01.2024
Transformed manual reporting processes into automated Power BI solutions, increasing operational efficiency by 15-25%, and improving visibility into caregiver service utilization by 45%.
Conducted rigorous data validation on caregiver timesheets and claims, refining data accuracy by 18%, and reducing claim processing time by 25%.
Optimized data models, increasing report generation speed by 20%, and enhancing real-time insights for care coordinators and finance teams.
Implemented row-level security in Power BI, ensuring HIPAA-compliant data protection.
Performed data cleaning and preprocessing, safeguarding data integrity for caregiver utilization, and client service trend analysis.
Built visualizations that enabled users to quickly interpret results from complex analyses.
Conducted full lifecycle analysis to include requirements, activities, and design of data analytic solutions.
Data Analyst
MAKOLA
West New York, NJ
01.2019 - 05.2022
Company Overview: Start-Up.
Integrated SQL with Power BI to automate sales and inventory reporting, reducing manual data extraction time by 15 hours per week.
Analyzed customer behavior and sales trends using SQL and Python, optimizing product recommendations, and increasing repeat purchases by 5%.
Developed dynamic Power BI dashboards to track order fulfillment and supplier performance, improving inventory management efficiency by 25%, and reducing stockouts.
Data Engineer
Goldman Sachs & Co
New York, NY
07.2016 - 01.2019
Engineered and optimized complex SQL queries to model and extract trading data (FX, options, commodities), providing critical insights for regulatory compliance and strategic decision-making.
Designed a scalable error-handling and reporting framework, reducing response time by four hours, and strengthening operational reliability across trading data pipelines.
Education
Bachelor of Arts - Computer Science
Berea College
Berea, KY
05-2016
Bachelor of Science - Business Administration
Berea College
Berea, KY
05-2016
Skills
SQL and databases
Power BI
SSRS
Tableau
Alteryx
Data warehouse design
KPI development and management
Trend analysis
Collaboration skills
Data analysis
Azure Synapse
Data visualization
Advanced Excel
ETL pipeline development
SSIS
Data integrity management
Python (Pandas, NumPy)
Java
Python programming
BI model development
Machine learning
Big data analytics
Analytical thinking
AWS Redshift
Azure Data Lake
Data migration
Certification
Microsoft Power BI Desktop for Business Intelligence - Maven Analytics (Udemy)
Advanced SQL Server Masterclass for Data Analysis - Travis Cuzick (Udemy)
Human Resources Coordinator at Home Health Care, Health Services, Consumer Direct Care Network of Washington StateHuman Resources Coordinator at Home Health Care, Health Services, Consumer Direct Care Network of Washington State