# Abby Yang

Abby Yang is a remote worker on Himalayas, Freelance Watercolor Artist at AdhocAbbs, based in United States.

Source: https://himalayas.app/@abbyyang

```text
Data analyst and analytics engineer who turns complex data into executive-ready dashboards and automated ETL pipelines.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | United States |
| Authorized to work in | United States |
| Salary expectations | 0+ USD |
| Job categories | Data Analyst, Analytics Engineer, Business Analyst, Data Engineer, Marketing Analyst, Business Intelligence Analyst, Business intelligence Engineer |
| Skills | Roadmapping, Power BI, Microsoft Fabric, T SQL, Excel, Tableau, Google Analytics, A B Testing, Power Automate, Azure DevOps, SharePoint, Python, Agentic AI, Prompt Engineering, Copilot, HubSpot, Microsoft SSRS, Visual Studio, SQL, CRM, HIPAA, Agile |

## What I'm looking for

```text
I’m looking for a role where I can build end-to-end analytics solutions—Power BI/Fabric dashboards, reliable ETL with SQL, and responsible AI—partnering with stakeholders to deliver measurable impact and continuous workflow improvements.
```

## About

```text
I’m a data-focused business analyst and analytics engineer who translates complex datasets into “decision-ready” insights for departmental leaders. I’ve led cross-functional analytics reporting across compliance, operations, and product teams to keep stakeholders aligned on performance and outcomes.

I designed and delivered executive dashboards surfacing revenue by consultant/product, using accounting and operational data to enable data-driven decisions. I also implemented Microsoft Fabric with end-to-end SQL integration, designing and validating ETL pipelines that reduced manual data cleaning and reporting by 10+ hours/week.

To scale workflows, I built an automated document ingestion pipeline using Power Automate and Python to process 50+ external invoices monthly (PDF/Excel/HTML), eliminating manual effort for accounting. I’ve also managed and customized CRM tracking with automated workflow alerts and executive dashboards for team performance metrics.

I’m committed to practical, responsible AI adoption—designing and delivering a seminar series with biweekly office hours to train 15+ non-technical staff on compliant Copilot usage and PII/HIPAA data handling protocols. Previously, I optimized marketing and eCommerce growth through analytics-driven campaign attribution and customer/sales analysis using tools like Google Analytics, HubSpot, Tableau, and A/B testing.
```

## Experience

### Freelance Watercolor Artist (current)

AdhocAbbs. Feb 2021 - Present

```text
Operated an end-to-end eCommerce business, analyzing sales and customer behavior to optimize product mix and promotional strategy. Managed product, pricing, and fulfillment while using analytics to guide business decisions.
```

Skills: eCommerce-Management, Pricing-Strategy, Product-Mix, Sales-Analytics, Customer-Segmentation

### Business Analyst

NFP. Nov 2023 - Aug 2025

```text
Led cross-functional analytics reporting and built executive dashboards that surfaced consultant/product revenue insights for senior leadership. Automated invoice ingestion and implemented Microsoft Fabric SQL ETL pipelines, reducing manual data cleaning and reporting by 10+ hours/week.
```

Skills: Power-BI, Microsoft-Fabric, T-SQL, ETL, Power-Automate, Python, Excel, Azure-DevOps, Copilot-PII-HIPAA-Compliance

### Marketing Coordinator

Lily Mili. Dec 2020 - Oct 2021

```text
Analyzed consumer and campaign performance using Google Analytics and HubSpot to identify growth opportunities. Optimized media spend and supported data-driven pricing decisions based on reporting and experimentation.
```

Skills: Google-Analytics, HubSpot, Data-Reporting, A-B-Testing, Excel, Prompt-Engineering

### Marketing Intern

Archipelago Strategies Group. May 2019 - Dec 2019

```text
Tracked media consumption trends and campaign KPIs using Tableau and Excel, building segmentation profiles to optimize paid media targeting. Conducted A/B testing and campaign attribution analysis to improve multichannel performance and inform targeting strategy.
```

Skills: Tableau, Excel, KPIs, A-B-Testing, Segmentation, Media-Optimization, Google-Analytics-Style-Reporting

### Branding & PR Intern

[Ogilvy](https://himalayas.app/companies/ogilvy). Nov 2017 - May 2018

```text
Adapted global go-to-market assets for regional markets and developed competitive research materials for pitches. Produced event collateral supporting media positioning and stakeholder presentations.
```

Skills: Competitive-Research, Positioning, Communication-Strategy

## Education

### LaunchCode Women+

Certificate, SQL Server & Databases. 2022 - 2023. Grade: N/A

Activities and societies: Built sales and inventory reports using T-SQL and SSRS in Visual Studio for an e-commerce startup.

### Emerson College

Master of Arts (MA), Strategic Communication for Marketing. 2018 - 2020. Grade: N/A

Activities and societies: Earned an MA in Strategic Communication for Marketing, completing a capstone focused on agility and restoring growth through refined branding strategy for a local winery.

### Beijing University of Technology

Bachelor of Science, Urban Planning. 2013 - 2018. Grade: N/A

Activities and societies: Served as manager of the university flag football team, coordinating collegiate games and leading partnership work with NFL China.

```text
Earned a B.S. in Urban Planning.
```

## Tech stack

- Microsoft Azure
- Microsoft SQL Server
- Microsoft SharePoint
- Gmail
- Google Analytics
- Microsoft Teams
- Visual Studio
- Azure DevOps
- Python
- HubSpot
- Microsoft Office 365
- Microsoft Excel
- Microsoft Power Automate
- Microsoft Power BI
- SQL
- Microsoft Visio
- Microsoft Fabric

To contact Abby, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Harshita Mishra](https://himalayas.app/@harshitamishra17): Data and Visualization Analyst, ACTIVEcharge
- [Fiona Nanzala](https://himalayas.app/@fionanguche): Data Analytics Consultant, International Society of Service Innovation Professionals
- [Reshma User](https://himalayas.app/@reshmauser): Data Analyst, Cognizant
- [Savita Navalgi](https://himalayas.app/@savitanavalgi): Business Intelligence Analyst, CCS Fundraising
- [Sally Wang](https://himalayas.app/@sallywang): Technology Analyst, Barclays
- [Cassandra Lobo](https://himalayas.app/@cassandralobo1): Lead Ambassador, DePaul University
- [Trevon Griffin](https://himalayas.app/@trevongriffin): Data & Market Research Consultant, NIL Attorney
- [Mahima Jain Kala](https://himalayas.app/@mahimajainkala): Data Analyst, Cisco
- [Divya Sri Pothuraju](https://himalayas.app/@divyasripothuraju): Marketing Analyst (E Commerce), The Home Depot
- [Brithaney Stewart](https://himalayas.app/@brithaneystewart): Business Intelligence Analyst, Solventum
