Business & Systems Analyst · MBA · Kansas City

Estelle
Lu.

I combine psychology and business training to build analytics that work with human behavior — not against it. I enjoy working where business needs, data, technology, and people come together.

Currently contracting at Burns & McDonnell
View My Work LinkedIn ↗
2,000+
Employees trained on new tools and processes
50+
KPI dashboards delivered across industries
80%
Reduction in manual reporting labor
4 hrs
Saved daily through SQL automation

About

Nice to
meet you!

I'm an MBA-trained business systems and analytics professional based in Kansas City. I combine psychology and business training to build analytics that work with human behavior — not against it.

I enjoy working where business needs, data, technology, and people come together — helping teams clarify problems, improve processes, and make better decisions.

I believe that the best products and dashboards don't just give you more data. They give you a clearer vision.

Outside of work, you'll usually find me training for my next marathon, enjoying a latte, or baking something sweet.

How I work

Structured Problem Solving
I break down complexity, identify root causes, and build practical, scalable solutions
Human-Centered Adoption
I design with users in mind and support change through training, documentation and ongoing partnership
Turning Complexity into Clarity
I simplify the complex — creating clarity through systems, data, and compelling visuals

What I do best

Systems Thinking Business Analysis Training & Enablement Dashboard Design SQL & Reporting Change Management Process Mapping Requirements Gathering

Featured Work

Projects that made a
real difference.

Analytics, financial systems, workflow support, and business process improvement. Click any project to expand.

Financial Tech · Enterprise IT

Jira & Confluence Department Transformation

Jira Admin Confluence Change Mgmt Azure DevOps Power Apps
+

Overview

Served as the designated Jira administrator for four cross-functional teams during a department-wide transition from Azure DevOps and OneNote into Jira and Confluence. Led Jira setup, board creation, automation configuration, Confluence migration, Power App-to-Jira intake migration, and large-scale training efforts that supported adoption and go-live readiness for more than 2,000 employees.

Key Contributions

  • Led Jira setup, board creation, and automation configuration as the designated admin for four teams
  • Launched production-ready Jira spaces and boards within two weeks of starting
  • Managed Confluence migration from fragmented OneNote documentation into a structured knowledge base
  • Created a page-by-page migration inventory, assigned content owners, and coordinated documentation transition
  • Project managed migration of Power App intake forms into Jira for the Financial Automations team
  • Partnered with IT and FinTech leadership on change management strategy to support adoption of new workflows
  • Designed and led Jira and Confluence training programs and workshops for 2,000+ employees in virtual and in-person settings

Constraints Navigated

Change mgmt for 2,000+ employees 2-week go-live timeline Cross-collaboration with 3 teams Varied Jira/Confluence familiarity

Impact

2,000+
Employees trained
2 wks
Go-live timeline
4
Teams supported
3+
Systems migrated

What they said

"Special thanks to Estelle for keeping communication flowing across departments such as HR, Finance, and Procurement, ensuring alignment across the organization. She also prepared training materials and enablement resources that helped teams adopt the new platform and processes more effectively."
Mentor Bytyqi Department IT Manager, Enterprise Applications · Burns & McDonnell
Used with permission
"It was wonderful working with Estelle throughout the Jira migration project. Her contributions made a real difference, and I appreciate all of her hard work and positivity."
Mentor Bytyqi Department IT Manager, Enterprise Applications · Burns & McDonnell
Used with permission
Post-Acute Healthcare

Product Analyst — Post-Acute Healthcare Reporting Platform

SQL Dashboarding Healthcare Jira User Guides
+

Overview

At WellSky, I supported product analytics and reporting for a customer-facing platform used by post-acute healthcare clients. My work focused on helping teams and users better understand product performance, adoption, and reporting needs through KPI dashboards, custom reports, SQL-based logic, and user-focused enablement.

Key Contributions

  • Owned end-to-end product analytics for a reporting platform serving 200+ healthcare clients
  • Delivered 50+ KPI-driven dashboards and interactive reports designed to support real-time monitoring and decision-making
  • Worked with product managers and healthcare clients to define success metrics, gather requirements, and evaluate feature impact
  • Built reusable SQL-based reporting frameworks that supported self-service analytics for 200+ users
  • Wrote 10+ user guides and led training sessions to improve reporting adoption and customer confidence
  • Automated billing and patient face sheet reports to improve compliance and reduce manual reporting work

Impact

50+
KPI dashboards
200+
Healthcare clients
10+
User guides written
Manual effort reduced

Helped turn reporting into a more scalable, user-friendly part of the product experience. Improved visibility into customer usage patterns, feature adoption, and product performance. Enabled more self-service reporting, reducing reliance on analysts for routine reporting needs.

Supply Chain Client ERP & Reporting Automation

Sales Open Orders Dashboard & SQL Automation

SQL Incorta Oracle ERP NetSuite
+

Overview

Built real-time Sales Open Orders dashboards that consolidated ERP and CRM data to give supply chain and sales leadership instant visibility into order status, aging, and revenue forecasting — eliminating manual daily reporting.

Solution & Technical Approach

  • Integrated and standardized Oracle ERP and NetSuite data in SQL
  • Built an automated daily-refreshing data model for open orders
  • Designed KPI-driven dashboard views with executive-first visual hierarchy
  • Added rolling 7-day and month-over-month metrics for short-term planning

Key Decisions

Full automation over incremental optimization — stakeholders needed complete elimination of manual work, not just reduction. Familiar dashboard design patterns to lower change resistance and build trust to accelerate adoption.

Constraints Navigated

Multiple ERP schemas Strict security requirements Near real-time updates Legacy system integration

Impact

80%
Reduction in manual labor
4 hrs
Daily time saved

Eliminated a long-standing manual Excel reporting workflow. Enabled real-time executive visibility into open orders and backlog risk. Reduced reporting effort by ~80%, improving decision velocity across sales and supply chain leadership.

Local Bookstore Retail Strategy · KC Area

Data-Driven Operations & Customer Segmentation

Excel SQL Segmentation Retail Strategy
+

Overview

Improved operations for a local book, plant, and coffee shop through data-driven analysis, including inventory tracking, customer segmentation, and store-hour optimization based on traffic and sales patterns. Incorporated social media–driven demand trends (e.g., BookTok) into competitive analysis to inform customer engagement and merchandising recommendations.

Solution & Technical Approach

  • Built an Excel + SQL framework to track inventory turnover and revenue by product line
  • Analyzed purchasing behavior to identify high-impact sales periods and categories
  • Applied behavioral segmentation (demographics, technographics, and needs-based psychographics) to identify target customer mindsets beyond basic purchase patterns — revealing opportunities in the remote worker and creative community segments
  • Evaluated competitor positioning and social-media-driven demand trends (e.g., BookTok)
  • Delivered actionable recommendations for store hours, promotions, and community engagement

Key Decisions

Simplicity over complexity. Prioritized low-cost, maintainable tooling to ensure adoption by a small business team. Focused on actionable insights over complex analysis.

Constraints Navigated

Limited budget Minimal historical data No inventory software Confidentiality requirements

Impact

20%
Increase in foot traffic
3
Revenue streams optimized

Replaced ad-hoc inventory and sales tracking with a structured framework. Improved visibility across books, coffee, and plant revenue streams. Enabled data-driven decisions for store hours, customer targeting, and marketing.

Recognition

Dashboard Philosophy

Dashboards that help people decide, not just inform.

I design for the people who will actually use the data — busy professionals making important decisions under pressure. Good analytics begins not with the data, but with understanding the audience.

The best dashboards don't give you more information. They give you the right information, shaped into a story that's useful in the moment it's needed.

01

Outcome-First Metrics

Surface what matters most, not what's easiest to measure. Focus on business outcomes that drive impact.

02

Clear Visual Hierarchy

Information that's easier to take in reduces cognitive load at decision time. Clean, focused design that prioritizes signal over noise.

03

Signal Over Noise

Highlight what matters most and remove what doesn't. Clean, focused design that earns attention rather than demanding it.

04

Audience-Specific Decisions

Design for the user, their context, and their business. Executive, operational, and user-level needs are genuinely different.

Let's build
something
together.

Open to contract, full-time, and consulting opportunities in analytics, business systems, and data-driven strategy.

Connect on LinkedIn ↗ Say Hello