Data Analyst Project Management

MARY NYANGARO

**** **** ********* ***** ***. *** Irving, Texas 75062

319-***-**** ************@*****.***

LinkedIn Profile

PROFESSIONAL SUMMARY

•Experienced Data Reporting Analyst with 5+ years of expertise in SQL Server, data visualization, and reporting for various industries, including healthcare and retail. •Proficient in designing and automating reporting processes, building interactive dashboards, and analyzing complex datasets to drive data-driven decision-making.

•Strong background in advanced SQL, ETL processes, and data governance with a focus on accuracy, efficiency, and collaboration.

TECHNICAL SKILLS

BI & Visualization: Tableau, Power BI, Domo, Looker, Greenfield, Report Studio.

Database & ETL Tools: SQL Server, Snowflake, SSRS, SSIS, Hadoop, Azure Data Lake, Databricks.

Tools & Platforms: Jira, Smartsheet, SharePoint, Automation Portal, Confluence.

Healthcare Systems: EPIC (Clarity & Caboodle), MEDITECH.

Programming & Queries: SQL (Advanced), Hadoop, Magic ETL, Excel (Macros, Pivot Tables, VLOOKUP).

PROFESSIONAL EXPERIENCE

Target Corporation

Forecasting Reporting Analyst 09/2023 – 04/2025

Developed interactive dashboards in Domo and Greenfield, enabling real-time insights into sales performance and inventory trends.

Automated data processing tasks using Domo’s Magic ETL and Excel macros, streamlining reporting workflows.

Designed ETL processes in Hadoop to manage and analyze large datasets, ensuring scalability and reliability.

Built Tableau dashboards for tracking key performance metrics, enhancing decision-making capabilities.

Documented workflows and processes in Confluence to maintain data transparency and accessibility.

Developed automated Excel dashboards using Pivot Tables and VLOOKUP to track inventory performance and sales KPIs across multiple departments

Created weekly executive summaries and PowerPoint reports for senior leadership to support strategic business reviews

Maintained SharePoint content to manage data documentation and cross-functional reporting workflows

Built a custom Excel model for budgeting, forecasting, and savings tracking

Used Pivot Tables and conditional formatting to visualize spending habits and inform monthly financial decisions demonstrating transferable skills relevant to banking and financial analytics

Baylor Scott & White Health

Reporting Data Analyst 01/2020 – 08/2023

Built Power BI dashboards to visualize clinical and operational performance metrics.

Analyzed healthcare data from EMR systems, including patient demographics and clinical outcomes, to improve operational efficiency.

Wrote complex SQL queries in Snowflake for data extraction, transformation, and reporting.

Automated ETL processes using SSIS for seamless data integration across healthcare systems.

Streamlined reporting processes using Domo’s Magic ETL and advanced Excel functionalities, enhancing data accuracy and timeliness.

Conducted ad hoc analysis for financial reporting, identifying billing anomalies and supporting compliance audits

Managed and updated team SharePoint site for resource sharing, project documentation, and status report

Supported clinical and operational reporting by building data validation rules in Excel and creating compliance dashboards for leadership

Cnergy Analytics LLC

Data Analyst 01/2019 – 08/2019

Designed and maintained dashboards in Power BI to monitor KPIs and drive business decisions.

Developed ETL workflows in SSIS to integrate and transform data for reporting purposes.

Utilized Hadoop to analyze large datasets, supporting supply chain and production management.

Delivered detailed SSRS reports, providing actionable insights into financial performance and sales trends.

EDUCATION

•Thika School of Medical and Health Sciences Nairobi, Kenya

Medical Records and Information Technology (2010 – 2013)

•Colaberry School of Data Analytics Plano, Texas

Certificate in Data Analytics (2018)

LANGUAGES

English

Swahili

REFERENCES

Available upon request

Contact this candidate