Mercy Kiambuthi
Scottdale, AZ 480-***-**** ************@*****.***
PROFILE
Analytical and motivated business intelligence professional with skills in healthcare and business data analysis, ad hoc analysis, data modelling, and database development. I have worked on data driven projects, utilizing my vast knowledge of business operations to monitor, measure operational performance and improve overall quality of care to our clients.
AREA OF EXPERTISE
Project Management
Ad Hoc Reports
Power BI (DAX)
T-SQL
SSIS
SSMS
MS Excel (Advanced)
Analytics
Data Modeling
EXPERIENCE
Smart Data Analytics Plano TX 01/2021 – Present
Business Intelligence Analyst
Identify, establish scope and parameters of required analysis to define outcome criteria and deliver measurable actions as part of daily efforts as well as in projects.
Manage end to end complex data migration, conversion, and data modeling using (SSIS, SQL).
Created SQL queries that extracted and transformed data for reporting purposes. The written SQL queries included constructs like Joins, Views, CTE’s, set operators and case statements.
Perform complex data transformations and cleansing in excel using formulas like VLOOKUP, INDEX/MATCH, IFS, MID, Data Validation, Conditional Formatting, and array formulas.
Create database solution to store data about Projects, Applied data modeling and normalization techniques.
Develops exception reporting and conducts drill down analysis to proactively identify specific opportunities and risks that warrant assessment by the Strategy Development Committee.
Allegiant HealthCare Phoenix AZ 6/2018 – 12/2020
Healthcare Data Analyst
Write complex T-SQL queries for data validation and to create reconciliation reports to resolve data discrepancies in payer contracts data.
Review, analyze the effectiveness and efficiency of existing dashboards and reports to identify opportunities for process improvements.
Generate performance analytics tools on a quarterly basis; develop reports on a regular basis using SQL, Power BI, and Excel.
Created interactive enterprise-wide dashboards with a focus on client intake and discharge rates that enabled the managers and executives to make strategic and data driven decisions.
Assisted in Rehab program analysis that provided real-time insights used to reduce the risk for our patients and improve the overall quality of care.
Conducted Patient Behavior and sentiment analysis to identify common issues for instance patients’ feedback on medical interventions.
Hacienda HealthCare Phoenix AZ 7/2016 –5/2018
Data Analyst
Formulated procedures for data extraction, transformation, and integration of health care data.
Conducted assessment to ensure data quality and completeness with validation techniques.
Assisted in designing and development of health-related analytical products for overall enterprise.
Helped with quantitative data analysis with health care, biometric and survey data.
Designed and developed continuous outcomes reporting for multiple intervention programs.
Partner with project and corporate stakeholders in preparation of weekly and monthly financial packages, dashboards and reporting of key performance metrics.
Assisted in development of data formatting and cleaning criteria from various data sources.
Performed ad hoc analysis of data sources for all external and internal customers.
EDUCATION
B.A., Applied Science in Respiratory Therapy Pima Medical Institute, Mesa, AZ 2015
B.Sc., Business & Enterprise Development Jomo Kenyatta University, Kenya 2012